Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v mgn1_1392917539 as_sabob
* id : bigint(10)
* splor_id : int(9)
* splor_sid : int(9)
* rsch : varchar(34)
* korsch : varchar(34)
* kormfo : varchar(10)
* sgo_id : int(2)
* pr : int(2)
* subs : int(6)
* jo : int(1)
* prs : int(1)
* pnz : int(2)
* dtz : date
* rschf : varchar(20)
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 as_sabop
* id : bigint(10)
* sabor_id : bigint(10)
* aspar_id : bigint(10)
* parc : varchar(50)
* parm : text
* dtz : date
* timz : varchar(10)
v mgn1_1392917539 as_sabor
* id : bigint(10)
* sgo_id : int(4)
* sgor_id : int(9)
* sobl_id : int(9)
* sgrd_id : int(9)
* syifr : int(4)
* norg : varchar(200)
* pue : int(1)
* pind : int(6)
* aorg : varchar(200)
* vat_no : varchar(10)
* is_eq_address : tinyint(1) unsigned
* forg : varchar(200)
* rsch : varchar(34)
* korsch : varchar(34)
* otgb : varchar(18)
* gor : varchar(18)
* obl : varchar(12)
* ogrn : varchar(20)
* kpp : varchar(20)
* pri : int(1)
* zpvz : int(9)
* fax : varchar(20)
* fax_country : varchar(2)
* tel : varchar(20)
* tel_country : varchar(2)
* fio : varchar(50)
* unn : varchar(15)
* kmf : varchar(20)
* okp : varchar(20)
* dtz : date
* uname : varchar(200)
* bname : varchar(50)
* bik : varchar(30)
* pb : int(2)
* timz : varchar(10)
* is_del : int(11)
* fiob : varchar(50)
* descr : mediumtext
* external_id : varchar(100)
* passport : varchar(250)
* discount : double
* ndsc : int(2) unsigned
* email : text
* birthday : date
* okpo : varchar(10)
* card_loyalty : varchar(22)
* contr_localization_key : varchar(100)
* legal_form_id : int(11)
* field_id : int(11)
* custom_field_name : varchar(200)
v mgn1_1392917539 as_sabor_history
* uid : bigint(10)
* id : bigint(10)
* date_insert : datetime
* date_close : datetime
* susers_id : bigint(10) unsigned
* sgor_id : int(9)
* norg : varchar(200)
* aorg : varchar(200)
* vat_no : varchar(10)
* is_eq_address : tinyint(1) unsigned
* forg : varchar(200)
* rsch : varchar(34)
* korsch : varchar(34)
* ogrn : varchar(20)
* kpp : varchar(20)
* pri : int(1)
* fax : varchar(20)
* fax_country : varchar(2)
* tel : varchar(20)
* tel_country : varchar(2)
* fio : varchar(50)
* unn : varchar(15)
* okp : varchar(20)
* dtz : date
* uname : varchar(200)
* bname : varchar(50)
* bik : varchar(30)
* timz : varchar(10)
* is_del : int(11)
* fiob : varchar(50)
* descr : text
* external_id : varchar(100)
* passport : varchar(250)
* discount : double
* ndsc : int(2) unsigned
* email : text
* birthday : date
* okpo : varchar(10)
* card_loyalty : varchar(22)
* contr_localization_key : varchar(100)
* legal_form_id : int(11)
* field_id : int(11)
* custom_field_name : varchar(200)
v mgn1_1392917539 as_scountry
* id : bigint(10)
* sgrg_id : int(4)
* kg : int(2)
* ng : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* c_code : char(2)
* sgo_id : int(10)
v mgn1_1392917539 as_sgo
* id : bigint(10)
* sgrg_id : int(4)
* kg : int(2)
* ng : varchar(50)
* nvg : varchar(30)
* knvg : varchar(10)
* sot : varchar(20)
* knm : varchar(10)
* kvgm : int(4)
* prnv : int(1)
* prnk : int(1)
* prno : decimal(3,1)
* pru : varchar(10)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* c_code : char(2)
v mgn1_1392917539 as_sgor
* id : bigint(10)
* naim : varchar(40)
* pr5 : int(3)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 as_sgrg
* id : bigint(10)
* naim : varchar(30)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 as_sob
* id : bigint(10)
* ob : varchar(10)
* naim : varchar(60)
* prim : varchar(60)
* splor_gid : int(9)
* splor_zid : int(9)
* pl : int(2)
* dno : date
* dko : date
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 as_spar
* id : bigint(10)
* spart_id : bigint(10)
* naim : varchar(150)
* alias : varchar(50)
* defparc : varchar(50)
* defparm : text
* dtz : date
* timz : varchar(10)
* type : tinyint(1)
* external_id : varchar(100)
v mgn1_1392917539 as_spd
* id : int(10) unsigned
* naim : varchar(200)
* device_id : varchar(100)
* device_model : text
* is_available : int(10)
* is_del : int(10) unsigned
* dtz : date
* timz : varchar(10)
* spz_id : bigint(10) unsigned
* device_address : varchar(200)
* device_type : int(10)
* device_subtype : int(11)
* version : varchar(200)
* push_token : varchar(1000)
* provider : varchar(200)
* app : varchar(256)
* device_role : int(11)
v mgn1_1392917539 as_spd_history
* uid : int(10) unsigned
* id : int(10) unsigned
* date_insert : datetime
* date_close : datetime
* susers_id : bigint(10) unsigned
* naim : varchar(200)
* device_id : varchar(100)
* device_model : text
* is_available : int(10)
* is_del : int(10) unsigned
* dtz : date
* timz : varchar(10)
* spz_id : bigint(10) unsigned
* device_address : varchar(200)
* device_type : int(10)
* device_subtype : int(11)
* version : varchar(200)
* push_token : varchar(1000)
* provider : varchar(200)
* app : varchar(256)
* device_role : int(11)
v mgn1_1392917539 as_spz
* id : bigint(10)
* cex : int(4)
* npdp : varchar(100)
* npd : varchar(50)
* gcex : int(4)
* pos : int(1)
* ves : int(4)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* npdt : varchar(250)
* store_address : varchar(200)
* store_type_id : int(10) unsigned
* storage_localization_key : varchar(100)
v mgn1_1392917539 as_spz_history
* uid : bigint(10)
* id : bigint(10)
* date_insert : datetime
* date_close : datetime
* susers_id : bigint(10) unsigned
* cex : int(4)
* npdp : varchar(100)
* npd : varchar(50)
* pos : int(1)
* ves : int(4)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* npdt : varchar(250)
* store_address : varchar(200)
* store_type_id : int(10) unsigned
* storage_localization_key : varchar(100)
v mgn1_1392917539 calculated_receipt
* transaction_id : bigint(20) unsigned
* parent_transaction_id : bigint(20) unsigned
* calculation_started_at : datetime
* calculation_ended_at : datetime
* created_at : datetime
* document_datetime : datetime
* position_min_created_at : datetime
* position_max_created_at : datetime
* position_min_document_datetime : datetime
* position_max_document_datetime : datetime
* operation_id : int(10) unsigned
* operation_goods_movement : int(10) unsigned
* operation_type : int(10) unsigned
* operation_mark : int(10) unsigned
* currency_id : int(10) unsigned
* exchange_rate : double
* paid_total : double
* document_number : varchar(20)
* pay_type : int(10) unsigned
* payment_status : int(10) unsigned
* payment_property_type : int(10) unsigned
* taxation : int(11)
* is_fiscalized : tinyint(4)
* fiscalization_status : enum('pending','enqueued','fiscalization','fiscalizationError','fiscalized')
* fiscal_document : varchar(256)
* device_id : int(10) unsigned
* storage_id : int(10) unsigned
* contractor_id : int(10) unsigned
* user_id : int(10) unsigned
* source_id : varchar(256)
* history_storage_name : varchar(256)
* history_contractor_company_name : varchar(256)
* history_user_name : varchar(256)
* taxation_sum : double
v mgn1_1392917539 calculated_transaction_log
* transaction_id : bigint(20) unsigned
* parent_transaction_id : bigint(20) unsigned
* main_position_id : bigint(20) unsigned
* calculation_started_at : datetime
* calculation_ended_at : datetime
* created_at : datetime
* committed_at : datetime
* position_min_created_at : datetime
* position_max_created_at : datetime
* position_min_document_datetime : datetime
* position_max_document_datetime : datetime
* operation_id : int(10) unsigned
* operation_goods_movement : int(10) unsigned
* operation_type : int(10) unsigned
* operation_mark : int(10) unsigned
* document_number : varchar(20)
* pay_type : int(10) unsigned
* payment_status : int(10) unsigned
* payment_property_type : int(10) unsigned
* taxation : int(11)
* is_fiscalized : tinyint(4)
* fiscalization_status : enum('pending','enqueued','fiscalization','fiscalizationError','fiscalized')
* fiscal_document : varchar(256)
* device_id : int(10) unsigned
* storage_id : int(10) unsigned
* contractor_id : int(10) unsigned
* user_id : int(10) unsigned
* source_id : varchar(256)
* history_storage_name : varchar(256)
* history_contractor_company_name : varchar(256)
* history_user_name : varchar(256)
v mgn1_1392917539 calculated_transaction_position
* position_id : bigint(20) unsigned
* transaction_id : bigint(20) unsigned
* parent_transaction_id : bigint(20) unsigned
* is_subject_of_transaction : tinyint(4)
* created_at : datetime
* document_datetime : datetime
* operation_id : int(10) unsigned
* operation_goods_movement : int(10) unsigned
* operation_type : int(10) unsigned
* operation_mark : int(10) unsigned
* has_price : tinyint(4)
* currency_id : int(10) unsigned
* exchange_rate : double
* base_total : double
* total : double
* paid_total : double
* quantity : double
* base_price : double
* price : double
* paid_price : double
* tax : double
* tax_type : int(10) unsigned
* document_number : varchar(20)
* container_id : int(10) unsigned
* product_id : bigint(20) unsigned
* product_type : int(11)
* device_id : int(10) unsigned
* storage_id : int(10) unsigned
* contractor_id : int(10) unsigned
* user_id : int(10) unsigned
* order_id : int(10) unsigned
* source_id : varchar(256)
* measure_id : int(11)
* history_storage_name : varchar(256)
* history_contractor_company_name : varchar(256)
* history_user_name : varchar(256)
* history_product_name : varchar(256)
* history_product_sku : varchar(256)
* taxation_sum : double
v mgn1_1392917539 calculated_transaction_total
* transaction_id : int(11)
* operation_id : int(10) unsigned
* operation_goods_movement : int(10) unsigned
* operation_type : int(10) unsigned
* operation_mark : int(10) unsigned
* currency_id : int(10) unsigned
* has_total : tinyint(4)
* base_total : double
* total : double
* has_paid_total : tinyint(4)
* paid_total : double
* taxation_sum_total : double
* tax_type : int(10) unsigned
v mgn1_1392917539 clients_trigger
* sabor_id : bigint(10)
* date_last_visit : datetime
* count_operation : int(10)
* average_value : double
* total : double
v mgn1_1392917539 crypto_data
* id : bigint(20) unsigned
* crypto_history_id : bigint(20) unsigned
* document_hash : bigint(20) unsigned
* crypto_currency_id : bigint(20) unsigned
* crypto_currency_code : varchar(3)
* crypto_currency_name : varchar(50)
* crypto_fraction_digits : int(10) unsigned
* amount_fiat : double
* amount_crypto : double
* amount_crypto_fee : double
* amount_crypto_total : double
* crypto_currency_rate : double
* crypto_wallet_number : varchar(50)
* crypto_wallet_qr_prefix : varchar(50)
v mgn1_1392917539 crypto_history
* id : bigint(20) unsigned
* operation_id : bigint(20) unsigned
* document_number : varchar(50)
* document_date : datetime
* spd_id : bigint(20) unsigned
* msut_id : bigint(20) unsigned
* susers_id : bigint(20) unsigned
* sabor_rid : bigint(20) unsigned
* sabor_kid : bigint(20) unsigned
* ext_data : text
v mgn1_1392917539 cs_drawer_operation
* UID : bigint(11)
* id : bigint(11)
* type : int(10)
* timestamp : bigint(11)
* amount : double
* recipient : varchar(255)
* reason : int(10)
* reason_description : text
* shift_hash : bigint(11)
* dtz : int(11)
* timz : int(11)
* spd_id : int(10) unsigned
v mgn1_1392917539 cs_shift
* shift_hash : bigint(11)
* number : bigint(11)
* create_timestamp : bigint(11)
* open_timestamp : bigint(11)
* close_timestamp : bigint(11)
* staff_id : bigint(10)
* device_name : varchar(200)
* device_serial : text
* device_fiscal_storage_number : text
* dtz : date
* timz : varchar(10)
* spd_id : int(10) unsigned
* start_cash : double unsigned
v mgn1_1392917539 data_table_user_config
* susers_id : bigint(10)
* action : varchar(255)
* body : longtext
* dtz : date
* timz : varchar(10)
v mgn1_1392917539 device_events
* id : bigint(10) unsigned
* event : varchar(20)
* body : text
* event_date : datetime
* susers_id : bigint(10)
* spd_id : int(10) unsigned
v mgn1_1392917539 device_favorite_product
* id : bigint(20) unsigned
* spd_id : int(10) unsigned
* snon_id : bigint(20)
* position : int(10) unsigned
* spz_id : bigint(20)
v mgn1_1392917539 device_param
* id : int(10) unsigned
* date : datetime
* spd_id : int(11)
* param_name : varchar(255)
* param_value : varchar(255)
* fiscal_spd_id : int(11)
v mgn1_1392917539 eshop
* id : bigint(20) unsigned
* name : varchar(255)
* description : varchar(1000)
* color : varchar(6)
* is_active : tinyint(4)
* logo_file : varchar(500)
* cover_file : varchar(500)
* store_id : bigint(20)
* store_default : bigint(20)
* store_id_for_order : bigint(20)
* created_at : timestamp
* published_at : timestamp
* updated_at : timestamp
* deleted_at : timestamp
* meta : longtext
* associated_url : varchar(512)
* emails : varchar(500)
* stock_control : tinyint(1)
* if_product_over : smallint(6)
* color_contact : int(11)
* is_show_social_name : tinyint(1)
* is_adult_content : tinyint(1)
* showremains : tinyint(1)
* is_created : tinyint(1)
* dark_cover : tinyint(1)
* picture_crop : int(11)
* pbgcolor : varchar(100)
* ordersms : tinyint(1)
v mgn1_1392917539 eshop_analytics_data
* id : bigint(20)
* is_active : tinyint(4)
* eshop_id : bigint(20) unsigned
* analytics_header : text
* created_at : timestamp
* updated_at : timestamp
v mgn1_1392917539 eshop_analytics_data_v1
* id : bigint(20)
* is_active : tinyint(4)
* eshop_id : bigint(20) unsigned
* analytics_header : text
* created_at : timestamp
* updated_at : timestamp
v mgn1_1392917539 eshop_cart
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* pay_type : int(11)
* delivery_type : int(11)
* step : int(11)
* client_email : varchar(250)
* client_name : varchar(255)
* created_at : timestamp
* status : int(11)
* description : text
* client_comment : text
* order_id : int(10) unsigned
* ext_data : text
* delivery_address : varchar(1000)
* phone : varchar(32)
* phone_country : varchar(2)
* delivery_method_id : int(11)
* msut_id : bigint(10)
* requisites : varchar(8000)
v mgn1_1392917539 eshop_cart_item
* id : bigint(20) unsigned
* cart_id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* quantity : varchar(250)
* price : double(10,2)
* base_price : double(10,2)
* modifier_ids : text
v mgn1_1392917539 eshop_category
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* parent_id : bigint(20) unsigned
* name : varchar(250)
* alias : varchar(250)
* is_favorite : tinyint(4)
* order : int(11)
v mgn1_1392917539 eshop_category_product
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* category_id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* alias : varchar(250)
* is_active : tinyint(4)
* order : int(11)
v mgn1_1392917539 eshop_category_product_v1
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* category_id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* alias : varchar(250)
* is_active : tinyint(4)
* order : int(11)
v mgn1_1392917539 eshop_category_v1
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* parent_id : bigint(20) unsigned
* name : varchar(250)
* alias : varchar(250)
* is_favorite : tinyint(4)
* order : int(11)
v mgn1_1392917539 eshop_contact
* id : int(11)
* eshop_id : bigint(20) unsigned
* name : varchar(255)
* type : smallint(6)
* is_active : tinyint(1)
* value : text
* social : int(11)
* messenger : int(11)
* order : int(11)
* type_group : smallint(6)
v mgn1_1392917539 eshop_contact_v1
* id : int(11)
* eshop_id : bigint(20) unsigned
* name : varchar(255)
* type : smallint(6)
* is_active : tinyint(1)
* value : text
* social : int(11)
* messenger : int(11)
* order : int(11)
* type_group : smallint(6)
v mgn1_1392917539 eshop_delivery_method
* id : int(11)
* eshop_id : bigint(20) unsigned
* name : varchar(256)
* price : double
* is_active : tinyint(4)
* is_active_for_order : tinyint(1)
* tax : double
* image_id : int(11)
v mgn1_1392917539 eshop_delivery_method_v1
* id : int(11)
* eshop_id : bigint(20) unsigned
* name : varchar(256)
* price : double
* is_active : tinyint(4)
* is_active_for_order : tinyint(1)
* tax : double
* image_id : int(11)
v mgn1_1392917539 eshop_feedback
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* name : varchar(255)
* description : text
* is_active : tinyint(1)
* is_system : tinyint(1)
* order : int(11)
v mgn1_1392917539 eshop_feedback_field
* id : bigint(20) unsigned
* feedback_id : bigint(20) unsigned
* type : varchar(255)
* name : varchar(255)
* placeholder : varchar(255)
* is_active : tinyint(1)
* is_required : tinyint(1)
* order : int(11)
v mgn1_1392917539 eshop_field_type
* id : bigint(20) unsigned
* type : varchar(255)
* name : varchar(255)
* placeholder : varchar(255)
* is_active : tinyint(1)
v mgn1_1392917539 eshop_image
* id : int(11)
* eshop_id : int(11)
* path : varchar(3000)
* name : varchar(255)
* is_active : tinyint(1)
* is_default : tinyint(1)
v mgn1_1392917539 eshop_payment_method
* id : int(11)
* eshop_id : bigint(20) unsigned
* name : varchar(256)
* description : varchar(256)
* pay_type : int(11)
* is_active : tinyint(4)
* is_active_for_order : tinyint(1)
v mgn1_1392917539 eshop_payment_method_v1
* id : int(11)
* eshop_id : bigint(20) unsigned
* name : varchar(256)
* description : varchar(256)
* pay_type : int(11)
* is_active : tinyint(4)
* is_active_for_order : tinyint(1)
v mgn1_1392917539 eshop_pickup_point
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* name : varchar(512)
* address : varchar(1024)
* description : varchar(10000)
* price : double
* opening_hours : varchar(100)
* is_active : tinyint(4)
* is_active_for_order : tinyint(1)
* tax : double
* image_id : int(11)
v mgn1_1392917539 eshop_pickup_point_table
* id : int(10) unsigned
* name : varchar(100)
* seating_capacity : int(11)
* revision : timestamp
* is_active : tinyint(4)
* eshop_pickup_point_id : bigint(20)
v mgn1_1392917539 eshop_pickup_point_table_v1
* id : int(10) unsigned
* name : varchar(100)
* seating_capacity : int(11)
* revision : timestamp
* is_active : tinyint(4)
* eshop_pickup_point_id : bigint(20)
v mgn1_1392917539 eshop_pickup_point_v1
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* name : varchar(512)
* address : varchar(1024)
* description : varchar(10000)
* price : double
* opening_hours : varchar(100)
* is_active : tinyint(4)
* is_active_for_order : tinyint(1)
* tax : double
* image_id : int(11)
v mgn1_1392917539 eshop_product
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* external_product_id : bigint(20)
* alias : varchar(250)
* is_active : tinyint(4)
v mgn1_1392917539 eshop_product_param
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* name : varchar(250)
* value : varchar(1000)
v mgn1_1392917539 eshop_product_param_v1
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* name : varchar(250)
* value : varchar(1000)
v mgn1_1392917539 eshop_product_v1
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* external_product_id : bigint(20)
* alias : varchar(250)
* is_active : tinyint(4)
v mgn1_1392917539 eshop_seo
* id : bigint(20)
* is_active : tinyint(4)
* eshop_id : bigint(20) unsigned
* seo_title : varchar(250)
* seo_description : text
* favicon_16 : varchar(550)
* favicon_32 : varchar(550)
* favicon_160 : varchar(550)
* created_at : timestamp
* updated_at : timestamp
v mgn1_1392917539 eshop_seo_v1
* id : bigint(20)
* is_active : tinyint(4)
* eshop_id : bigint(20) unsigned
* seo_title : varchar(250)
* seo_description : text
* favicon_16 : varchar(550)
* favicon_32 : varchar(550)
* favicon_160 : varchar(550)
* created_at : timestamp
* updated_at : timestamp
v mgn1_1392917539 eshop_suffix
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* suffix : varchar(100)
* location : varchar(100)
* is_active : tinyint(4)
v mgn1_1392917539 eshop_v1
* id : bigint(20) unsigned
* name : varchar(255)
* description : varchar(1000)
* color : varchar(6)
* is_active : tinyint(4)
* logo_file : varchar(500)
* cover_file : varchar(500)
* store_id : bigint(20)
* store_default : bigint(20)
* store_id_for_order : bigint(20)
* created_at : timestamp
* published_at : timestamp
* updated_at : timestamp
* deleted_at : timestamp
* meta : longtext
* associated_url : varchar(512)
* emails : varchar(500)
* stock_control : tinyint(1)
* if_product_over : smallint(6)
* color_contact : int(11)
* is_show_social_name : tinyint(1)
* is_adult_content : tinyint(1)
* showremains : tinyint(1)
* is_created : tinyint(1)
* dark_cover : tinyint(1)
* picture_crop : int(11)
* pbgcolor : varchar(100)
* ordersms : tinyint(1)
v mgn1_1392917539 external_fiscalization
* id : bigint(20) unsigned
* base_id : int(11)
* provider : varchar(100)
* uuid : varchar(300)
* spd_id : int(11)
* msut_id : int(11)
* status : tinyint(1)
* date_create : datetime
* response_data : longtext
v mgn1_1392917539 fd_mac
* sgo_id : bigint(10)
* kurs : double
* is_del : int(11) unsigned
* dtz : date
* timz : varchar(10)
v mgn1_1392917539 fd_mdr
* id : bigint(10) unsigned
* skf_id : bigint(10) unsigned
* shr_id : bigint(2) unsigned
* ddok : date
* ndok : varchar(20)
* tdok : varchar(10)
* pu : int(1) unsigned
* sabor_kid : bigint(10) unsigned
* sabor_rid : bigint(10) unsigned
* sumv : double
* sgo_id : bigint(10) unsigned
* kurs : double
* tn_id : bigint(10) unsigned
* tp_id : bigint(10) unsigned
* s_id : bigint(10) unsigned
* dob : date
* date_plan : date
* deb : varchar(20)
* kre : varchar(20)
* prim : mediumtext
* dtz : date
* timz : varchar(10)
* msut_id : bigint(10) unsigned
* mz_id : bigint(20) unsigned
* orders_id : bigint(20) unsigned
* pay_type : int(3) unsigned
* stnds : double
* sumnds : double
* ext_data : text
* processing_date : bigint(11) unsigned
* device_id : varchar(100)
* spz_id : bigint(10) unsigned
* spd_id : int(10) unsigned
* source_id : varchar(255)
* payment_status : int(10) unsigned
* fiscal_spd_id : int(10) unsigned
v mgn1_1392917539 fd_mw
* id : bigint(10) unsigned
* mws_id : bigint(10) unsigned
* mdr_id : bigint(10) unsigned
* pu : int(1) unsigned
* spz_id : bigint(10) unsigned
* device_id : varchar(100)
* sgo_id : bigint(10) unsigned
* pay_type : int(3) unsigned
* sumv : double
* ost : double
* pnz : int(4)
* dtz : date
* timz : varchar(10)
* msut_id : bigint(10)
* spd_id : int(10) unsigned
v mgn1_1392917539 fd_mws
* id : bigint(10) unsigned
* spz_id : bigint(10) unsigned
* device_id : varchar(100)
* sgo_id : bigint(10) unsigned
* pay_type : int(3) unsigned
* ost : double
* descr : text
* dtz : date
* timz : varchar(10)
* spd_id : int(10) unsigned
v mgn1_1392917539 iiko_locations
* id : bigint(20) unsigned
* uid : varchar(50)
* name : varchar(150)
* terminalGroupId : varchar(50)
* revision : bigint(20)
v mgn1_1392917539 iiko_organizations
* id : bigint(20) unsigned
* uid : varchar(50)
* name : varchar(500)
* revision : int(11)
v mgn1_1392917539 iiko_tables
* id : bigint(20) unsigned
* uid : varchar(50)
* number : int(11)
* name : varchar(100)
* seating_capacity : int(11)
* revision : bigint(20)
* is_deleted : tinyint(4)
* pos_id : varchar(50)
v mgn1_1392917539 iiko_terminal_groups
* id : bigint(20) unsigned
* uid : varchar(50)
* organizationId : varchar(50)
* name : varchar(150)
* address : varchar(500)
* timeZone : varchar(10)
v mgn1_1392917539 key_value
* id : bigint(20) unsigned
* key : varchar(1000)
* value : mediumtext
* created_at : timestamp
* updated_at : timestamp
* expired_at : timestamp
v mgn1_1392917539 lt_store_staff
* susers_id : bigint(10)
* spz_id : bigint(10)
v mgn1_1392917539 ms_msu
* id : bigint(10)
* spz_sid : int(4)
* snon_id : int(9)
* parent_snon_id : int(9) unsigned
* kont : varchar(32)
* dataop : date
* ndok : varchar(20)
* tdok : varchar(10)
* pnz : int(4)
* svop_id : int(4)
* svop_pu : int(1)
* sabor_kid : int(9)
* sabor_rid : int(9)
* spz_cid : int(9)
* sprp_id : int(9)
* mz_id : int(9)
* zak : varchar(15)
* spz : varchar(20)
* sppr_id : int(10)
* kol : double
* ost : double
* reserve : double
* cena : double
* sgo_id : int(4)
* kurs : double
* cenao : double
* sgo_oid : int(4)
* okurs : double
* cenad : double
* original_price : double
* discount_item : double
* sopr_id : int(3)
* sopr : varchar(10)
* dsopr : date
* sob_id : int(9)
* nobj : varchar(20)
* mlskod : varchar(15)
* seizm_id : int(3)
* msus_id : int(9)
* ppv : int(1)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* susers_id : int(9) unsigned
* msut_id : bigint(10) unsigned
* parent_msut_id : bigint(10) unsigned
* stnds : double
* sumnds : double
* tax_type : int(10) unsigned
* device_id : varchar(100)
* spd_id : int(10) unsigned
* marking_body : varchar(100)
* marking_raw : varchar(255)
* marking_raw_check : varchar(32)
* marking_tag : int(10) unsigned
* marking_crpt_validation_request_id : varchar(36)
* marking_crpt_validation_request_timestamp : varchar(25)
* fiscal_spd_id : int(10) unsigned
* quantity_real_sale : double
* product_name : varchar(200)
* modifiers : text
* agent_tin : varchar(15)
* agent_phone : varchar(20)
* agent_name : varchar(200)
* agent_id : bigint(20)
* agent_sign : tinyint(4)
* marking_check_result : varchar(512)
v mgn1_1392917539 ms_msus
* id : bigint(10)
* spz_sid : int(4)
* snon_id : int(9)
* kont : varchar(32)
* cena : double
* sgo_id : int(4)
* cenao : double
* sgo_oid : int(4)
* spasp_id : int(9)
* stell : varchar(10)
* jach : varchar(10)
* marka : varchar(10)
* sort : varchar(10)
* seizm_id : int(3)
* nskod : varchar(15)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* ost : double
* reserve : double
* susers_id : bigint(20)
* sabor_kid : int(9) unsigned
* external_id : varchar(100)
* kurs : double
v mgn1_1392917539 ms_msusp
* id : bigint(10)
* msus_id : bigint(10)
* spar_id : bigint(10)
* parc : varchar(50)
* parm : text
* dtz : date
* timz : varchar(10)
* kont : varchar(32)
v mgn1_1392917539 ms_msusw
* id : bigint(10)
* msus_id : int(9)
* smcgr_id : int(6)
* smcur_id : int(6)
* zu : int(1)
* isost : int(1)
* kont : varchar(32)
* prop : varchar(250)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 ms_msut
* id : bigint(10) unsigned
* prim : varchar(200)
* pu : int(1)
* svop_id : bigint(10)
* dtz : date
* timz : varchar(10)
* personal_id : varchar(100)
* IDSDK : int(10)
* contractor_id : int(10) unsigned
* source_id : varchar(255)
* transaction_create_date : datetime
* fiscalization_status : enum('notFiscalized','pending','enqueued','fiscalization','fiscalizationError','fiscalized')
* fiscalization_status_context : text
v mgn1_1392917539 ms_msu_op_snon_history
* msu_id : int(10) unsigned
* op_snon_history_id : int(10) unsigned
v mgn1_1392917539 ms_msu_return
* id : int(11)
* msu_id : bigint(20)
* msut_id : bigint(20)
* cont : varchar(255)
* quantity : double
v mgn1_1392917539 ms_seizm
* id : bigint(10)
* pneiz : varchar(15)
* kneiz : varchar(5)
* fiscal_value : int(10) unsigned
* fiscal_descr : varchar(255)
* fiscal_print : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* okei : varchar(3)
* localization_key_full_name : varchar(40)
* localization_key_short_name : varchar(40)
* fraction_digits_number : int(10) unsigned
v mgn1_1392917539 ms_sgro
* id : bigint(10)
* naim : varchar(80)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 ms_smcgr
* id : bigint(10)
* naim : varchar(80)
* ukod : varchar(15)
* smcur_id : bigint(10)
* su : int(1)
* f_avlble : int(1)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* external_id : varchar(100)
v mgn1_1392917539 ms_smcgr_history
* uid : bigint(10)
* id : bigint(10)
* date_insert : datetime
* date_close : datetime
* susers_id : bigint(10) unsigned
* naim : varchar(80)
* ukod : varchar(15)
* smcur_id : bigint(10)
* su : int(1)
* f_avlble : int(1)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* external_id : varchar(100)
v mgn1_1392917539 ms_smcsg
* id : bigint(10)
* smcgr_iid : bigint(10)
* nukodi : varchar(80)
* smcgr_kid : bigint(10)
* nukodk : varchar(80)
* smcur_id : bigint(10)
* pnzu : int(6)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* ves : int(10) unsigned
v mgn1_1392917539 ms_smcur
* id : bigint(10)
* naim : varchar(80)
* smcgr_id : bigint(10)
* su : int(1)
* zu : int(1)
* f_avlble : int(1)
* maska : varchar(100)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 ms_spar
* id : bigint(10)
* spart_id : bigint(10)
* naim : varchar(150)
* alias : varchar(50)
* defparc : varchar(50)
* defparm : text
* dtz : date
* timz : varchar(10)
* type : tinyint(1)
* external_id : varchar(100)
v mgn1_1392917539 ms_spart
* id : bigint(10)
* naim : varchar(50)
* mask : varchar(50)
* type : varchar(10)
* when : varchar(50)
* valid : varchar(50)
* max : varchar(20)
* min : varchar(20)
* dtz : date
* timz : varchar(10)
v mgn1_1392917539 ms_svop
* id : bigint(10)
* pu : int(1)
* naim : varchar(200)
* kname : varchar(50)
* pname : varchar(50)
* pvp : int(1)
* nsi : varchar(15)
* ves : int(4)
* sgro_id : int(3)
* pus : int(2)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* cname : varchar(200)
* docname : varchar(200)
* bname : varchar(200)
* colorname : varchar(50)
* operation_localization_key : varchar(100)
* operation_docname_localization_key : varchar(100)
v mgn1_1392917539 ms_svopr
* id : int(10) unsigned
* svop_id : int(10) unsigned
* smrts_id : int(10) unsigned
* spz_id : int(10) unsigned
* dtz : int(11)
* timz : varchar(20)
* is_del : tinyint(1) unsigned
v mgn1_1392917539 op_mln
* id : bigint(10) unsigned
* snon_id : bigint(10)
* snon_lid : bigint(10)
* kont_snon : varchar(32)
* kol : double
* dtz : date
* timz : varchar(10)
* is_del : int(11) unsigned
v mgn1_1392917539 op_mlnp
* mln_id : bigint(10) unsigned
* spar_id : bigint(10)
* parc : varchar(50)
* kont_snon : varchar(32)
* dtz : date
* timz : varchar(10)
* is_del : int(11) unsigned
v mgn1_1392917539 op_mlnw
* mln_id : bigint(10) unsigned
* smcgr_id : bigint(10)
* smcur_id : bigint(10)
* kont_snon : varchar(32)
* dtz : date
* timz : varchar(10)
* is_del : int(11) unsigned
v mgn1_1392917539 op_mz
* id : bigint(20) unsigned
* dtz : date
* timz : varchar(10)
* datep : datetime
* timep : varchar(25)
* datef : datetime
* spz_sid : bigint(10) unsigned
* sabor_id : bigint(10) unsigned
* msut_id : bigint(10) unsigned
* susers_id : bigint(10) unsigned
* author_id : int(11)
* descr : longtext
* is_del : int(10) unsigned
* dataop : date
* ndok : varchar(20)
* mzs_id : bigint(10)
* payment : double
* address : text
* is_payment : int(10) unsigned
* is_shipped : int(10) unsigned
* type : tinyint(2) unsigned
* order_payment : int(11)
* order_status_id : int(10)
* order_delivery_type : int(10)
* rejection_reason : varchar(1000)
* external_tran_id : varchar(200)
* sumitog : double
* date_create : datetime
* order_comment : text
* delivery_comment : text
* delivery_method_id : int(11)
* delivery_datetime : datetime
* pay_type : int(11)
* order_payment_create_type : int(1)
* address_parts : longtext
v mgn1_1392917539 op_mzs
* id : bigint(10) unsigned
* name : varchar(20)
* is_del : tinyint(1)
* color : varchar(10)
* dtz : date
* timz : varchar(10)
* order_status_localization_key : varchar(100)
v mgn1_1392917539 op_snon
* id : bigint(10)
* nomnsk : varchar(20)
* nmod : varchar(50)
* naim : varchar(200)
* chert : varchar(200)
* art : varchar(100)
* seizm_id : int(3)
* neizm : varchar(3)
* dneizm : varchar(3)
* seizm_did : bigint(10)
* kdseiz : double
* sost : varchar(30)
* sost_id : int(9)
* cvet : varchar(30)
* scv_id : int(9)
* rg : varchar(30)
* rg_id : int(3)
* prnd : int(1)
* smcur_id : int(6)
* smcgr_id : int(6)
* mnmod : varchar(20)
* vh : varchar(30)
* psdm : tinyint(1)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* cena : double
* cenao : double
* cenad : double
* uniform_sale_price : int(1) unsigned
* cenao2 : double
* cenao3 : double
* cenao4 : double
* cenao5 : double
* external_id : varchar(100)
* type : int(10)
* stnds : double
* sumndscenao : double
* sumndscenao2 : double
* sumndscenao3 : double
* sumndscenao4 : double
* sumndscenao5 : double
* scountry_id : bigint(10) unsigned
* kit_type : int(10)
* discount_type : int(10)
* marking_tag : int(10) unsigned
* sppr_id : int(10) unsigned
* product_localization_key : varchar(100)
* descr : varchar(8000)
* delivery_or_pickup : tinyint(1)
* gtin : varchar(20)
* source_snon_id : bigint(20)
* source_count : double
* digital_type : int(11)
* stock_control : tinyint(1)
* agent_id : bigint(20)
* agent_sign : tinyint(4)
v mgn1_1392917539 op_snonp
* id : bigint(10)
* snon_id : bigint(10)
* spar_id : bigint(10)
* zu : int(1) unsigned
* is_show_in_showcase : tinyint(4)
* parc : varchar(100)
* parm : text
* dtz : date
* timz : varchar(10)
v mgn1_1392917539 op_snont
* id : bigint(11) unsigned
* naim : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(10) unsigned
v mgn1_1392917539 op_snonv
* id : bigint(10)
* snon_id : int(9)
* vh : mediumtext
* foto : varchar(300)
* s3_key : varchar(300)
* foto3 : varchar(30)
* fotopv : varchar(30)
* mfoto : longblob
* ppath : varchar(30)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* order : int(11)
* meta : mediumtext
v mgn1_1392917539 op_snonw
* id : bigint(10)
* snon_id : int(9)
* smcgr_id : bigint(10)
* smcur_id : int(6)
* zu : int(1)
* prop : varchar(100)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 op_snon_digital
* id : bigint(20) unsigned
* digital_source : varchar(250)
* digital_name : varchar(255)
* digital_size : varchar(50)
* dtz : date
* timz : varchar(10)
* snon_id : int(11)
v mgn1_1392917539 op_snon_history
* uid : bigint(10)
* id : bigint(10)
* date_insert : datetime
* date_close : datetime
* susers_id : bigint(10) unsigned
* nomnsk : varchar(20)
* nmod : varchar(50)
* naim : varchar(200)
* chert : varchar(200)
* art : varchar(100)
* seizm_id : int(3)
* neizm : varchar(3)
* dneizm : varchar(3)
* seizm_did : bigint(10)
* kdseiz : double
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* cena : double
* cenao : double
* cenad : double
* uniform_sale_price : int(1) unsigned
* cenao2 : double
* cenao3 : double
* cenao4 : double
* cenao5 : double
* external_id : varchar(100)
* type : int(10)
* stnds : double
* sumndscenao : double
* sumndscenao2 : double
* sumndscenao3 : double
* sumndscenao4 : double
* sumndscenao5 : double
* scountry_id : bigint(10) unsigned
* kit_type : int(10)
* discount_type : int(10)
* marking_tag : int(10) unsigned
* sppr_id : int(10) unsigned
* product_localization_key : varchar(100)
* descr : varchar(8000)
* delivery_or_pickup : tinyint(1)
* gtin : varchar(20)
* source_snon_id : bigint(20)
* source_count : double
* digital_type : int(11)
* stock_control : tinyint(1)
* agent_id : bigint(20)
* agent_sign : tinyint(4)
v mgn1_1392917539 op_sppr
* id : int(10)
* naim : varchar(50)
v mgn1_1392917539 orders
* id : bigint(10) unsigned
* order_number : varchar(50)
* order_status_id : int(10)
* susers_id : bigint(10)
* order_comment : text
* order_delivery_datetime : datetime
* sabor_id : bigint(10)
* dtz : date
* timz : varchar(10)
* is_del : int(10)
* order_payment : int(11)
* order_delivery_address : text
* order_discount : int(2) unsigned
* order_create : datetime
* order_delivery_type : int(10) unsigned
* order_type : tinyint(2)
* sumv : double
* sumitog : double
* courier_id : bigint(10)
* ext_data : text
* aux_data : text
* rejection_reason : varchar(1000)
* external_tran_id : varchar(200)
v mgn1_1392917539 orders_good
* id : bigint(10)
* orders_id : bigint(10)
* snon_id : bigint(10)
* cenao : double
* sgo_oid : bigint(10)
* kol : double
* ndsc : int(2)
* dtz : date
* timz : varchar(10)
* sppr_id : int(10)
* is_del : int(10) unsigned
* properties : text
* parameters : text
* product_name : varchar(200)
v mgn1_1392917539 orders_status
* id : int(10)
* orders_status_name : varchar(100)
* localization_key_name : varchar(100)
* dtz : date
* timz : varchar(10)
* is_del : int(10)
v mgn1_1392917539 product_button
* id : bigint(20) unsigned
* product_id : int(11)
* name : varchar(255)
* is_active : tinyint(1)
* order : int(11)
* action : int(11)
v mgn1_1392917539 product_store_available
* id : bigint(10) unsigned
* product_id : bigint(20)
* store_id : int(11)
* is_available : tinyint(1)
v mgn1_1392917539 pr_smrts
* id : bigint(10) unsigned
* date : datetime
* name : varchar(100)
* params : varchar(300)
* is_del : tinyint(1) unsigned
* is_payment : tinyint(1) unsigned
* is_local : tinyint(1) unsigned
* type : int(3) unsigned
* body : longblob
* description : mediumtext
* alias : varchar(100)
* templ_id : bigint(10) unsigned
* date_upd : datetime
* version : varchar(20)
* docname_localization_key : varchar(100)
v mgn1_1392917539 sku
* id : bigint(11)
* product_id : bigint(10)
* modifiers : text
* photos : text
* barcode : varchar(20)
* gtin : varchar(20)
* price_purchase : double
* price_sale : double
* price_with_discount : double
* is_active : tinyint(4)
v mgn1_1392917539 sku_store_available
* id : bigint(10) unsigned
* sku_id : bigint(11)
* store_id : int(11)
* is_available : tinyint(1)
v mgn1_1392917539 store_prices
* id : bigint(10) unsigned
* spz_id : bigint(10) unsigned
* snon_id : bigint(10) unsigned
* cenao_sp : double
* cenad_sp : double
v mgn1_1392917539 store_prices_history
* uid : bigint(10)
* id : bigint(10) unsigned
* date_insert : datetime
* date_close : datetime
* susers_id : bigint(10) unsigned
* spz_id : bigint(10) unsigned
* snon_id : bigint(10) unsigned
* cenao_sp : double
* cenad_sp : double
v mgn1_1392917539 store_type
* id : int(10) unsigned
* store_type_name : varchar(100)
v mgn1_1392917539 su_psys
* id : bigint(10)
* sist : varchar(4)
* nsist : varchar(28)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 sy_mmd5
* hash : varchar(32)
* dt : datetime
v mgn1_1392917539 sy_mouop
* id : bigint(10)
* mouusr_id : int(10)
* svop_id : int(4)
* svop_pu : int(1)
* svop_pvp : int(1)
* db_id : int(9)
* renamekop : varchar(50)
* prim : varchar(40)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 sy_mouusr
* id : bigint(10)
* susers_id : int(9)
* kuser : varchar(100)
* cex : varchar(10)
* prim : varchar(40)
* pset : mediumtext
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 sy_muorgr
* id : bigint(10) unsigned
* susers_id : int(9) unsigned
* order_group : tinyint(1)
* dtz : date
* timz : varchar(10)
* is_del : int(11) unsigned
v mgn1_1392917539 sy_musrpr
* id : int(10) unsigned
* susers_id : bigint(10) unsigned
* tpl_id : int(10) unsigned
* dtz : date
* timz : varchar(10)
* is_del : int(11) unsigned
v mgn1_1392917539 sy_sbase
* id : bigint(10)
* date : date
* ver : varchar(20)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 sy_sroles
* id : int(10) unsigned
* name : varchar(100)
* is_del : tinyint(1) unsigned
v mgn1_1392917539 sy_sset
* id : bigint(10)
* noid : varchar(200)
* ssetur_id : int(9)
* nur : varchar(50)
* ssetgr_id : int(9)
* ngr : varchar(50)
* lset : int(1)
* cset : varchar(100)
* mset : mediumtext
* nset : double
* naim : varchar(100)
* knaim : varchar(100)
* isvisibl : int(1)
* isedit : int(1)
* nsi : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 sy_ssetgr
* id : bigint(10)
* name : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 sy_ssetur
* id : bigint(10)
* name : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn1_1392917539 sy_susers
* id : bigint(10)
* guser_id : int(9)
* kuser : varchar(100)
* nuser : varchar(100)
* ugroup : varchar(20)
* prim : text
* ip : varchar(40)
* invnum : varchar(15)
* prof : varchar(20)
* timz : varchar(10)
* dtz : date
* is_del : int(11)
* sroles_id : int(10) unsigned
* locale : varchar(5)
* status : int(10)
* phone_staff : varchar(100)
* phone_staff_country : varchar(2)
* personal_id : varchar(100)
v mgn1_1392917539 sy_susers_history
* uid : bigint(10)
* id : bigint(10)
* date_insert : datetime
* date_close : datetime
* susers_id : bigint(10) unsigned
* guser_id : int(9)
* kuser : varchar(100)
* nuser : varchar(40)
* ugroup : varchar(20)
* prim : text
* ip : varchar(40)
* invnum : varchar(15)
* prof : varchar(20)
* timz : varchar(10)
* dtz : date
* is_del : int(11)
* sroles_id : int(10) unsigned
* locale : varchar(5)
* status : int(10)
* phone_staff : varchar(100)
* phone_staff_country : varchar(2)
* personal_id : varchar(100)
v mgn1_1392917539 transaction_map
* internal_transaction_id : bigint(20) unsigned
* external_transaction_id : varchar(256)
* provider : int(11)
* request_type : int(11)
* request_context : mediumtext
v mgn1_1392917539 users_conditions
* id : bigint(10) unsigned
* susers_id : bigint(10)
* event : varchar(20)
* condition : int(3)
* condition_body : text
* dtz : date
* timz : varchar(10)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship