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 mgn5_1782743211 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 mgn5_1782743211 as_sabop
* id : bigint(10)
* sabor_id : bigint(10)
* aspar_id : bigint(10)
* parc : varchar(50)
* parm : text
* dtz : date
* timz : varchar(10)
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 as_sgor
* id : bigint(10)
* naim : varchar(40)
* pr5 : int(3)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1782743211 as_sgrg
* id : bigint(10)
* naim : varchar(30)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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
* tip_amount : double
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 clients_trigger
* sabor_id : bigint(10)
* date_last_visit : datetime
* count_operation : int(10)
* average_value : double
* total : double
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 data_table_user_config
* susers_id : bigint(10)
* action : varchar(255)
* body : longtext
* dtz : date
* timz : varchar(10)
v mgn5_1782743211 device_cycle_pay_account
* id : int(10) unsigned
* spd_id : int(11)
* email : varchar(255)
* secret_key : text
* is_default : tinyint(1)
* is_active : tinyint(1)
* created_at : datetime
* updated_at : datetime
v mgn5_1782743211 device_events
* id : bigint(10) unsigned
* event : varchar(20)
* body : text
* event_date : datetime
* susers_id : bigint(10)
* spd_id : int(10) unsigned
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 eshop_field_type
* id : bigint(20) unsigned
* type : varchar(255)
* name : varchar(255)
* placeholder : varchar(255)
* is_active : tinyint(1)
v mgn5_1782743211 eshop_image
* id : int(11)
* eshop_id : int(11)
* path : varchar(3000)
* name : varchar(255)
* is_active : tinyint(1)
* is_default : tinyint(1)
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 eshop_product
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* external_product_id : bigint(20)
* alias : varchar(250)
* is_active : tinyint(4)
v mgn5_1782743211 eshop_product_param
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* name : varchar(250)
* value : varchar(1000)
v mgn5_1782743211 eshop_product_param_v1
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* name : varchar(250)
* value : varchar(1000)
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 eshop_suffix
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* suffix : varchar(100)
* location : varchar(100)
* is_active : tinyint(4)
v mgn5_1782743211 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 mgn5_1782743211 fd_mac
* sgo_id : bigint(10)
* kurs : double
* is_del : int(11) unsigned
* dtz : date
* timz : varchar(10)
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 lt_store_staff
* susers_id : bigint(10)
* spz_id : bigint(10)
v mgn5_1782743211 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)
* marking_check_result : varchar(512)
* 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)
* rg_id : int(11) unsigned
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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
* is_ibox_transaction : int(11)
* ibox_transaction_status : int(11)
v mgn5_1782743211 ms_msu_op_snon_history
* msu_id : int(10) unsigned
* op_snon_history_id : int(10) unsigned
v mgn5_1782743211 ms_msu_return
* id : int(11)
* msu_id : bigint(20)
* msut_id : bigint(20)
* cont : varchar(255)
* quantity : double
v mgn5_1782743211 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 mgn5_1782743211 ms_sgro
* id : bigint(10)
* naim : varchar(80)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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)
* order_payment_property_type : int(10) unsigned
* order_barcode : varchar(15)
* address_parts : longtext
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 op_snont
* id : bigint(11) unsigned
* naim : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(10) unsigned
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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)
* rg_id : int(11) unsigned
v mgn5_1782743211 op_sppr
* id : int(10)
* naim : varchar(50)
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 product_button
* id : bigint(20) unsigned
* product_id : int(11)
* name : varchar(255)
* is_active : tinyint(1)
* order : int(11)
* action : int(11)
v mgn5_1782743211 product_store_available
* id : bigint(10) unsigned
* product_id : bigint(20)
* store_id : int(11)
* is_available : tinyint(1)
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 sku_store_available
* id : bigint(10) unsigned
* sku_id : bigint(11)
* store_id : int(11)
* is_available : tinyint(1)
v mgn5_1782743211 store_prices
* id : bigint(10) unsigned
* spz_id : bigint(10) unsigned
* snon_id : bigint(10) unsigned
* cenao_sp : double
* cenad_sp : double
v mgn5_1782743211 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 mgn5_1782743211 store_type
* id : int(10) unsigned
* store_type_name : varchar(100)
v mgn5_1782743211 su_psys
* id : bigint(10)
* sist : varchar(4)
* nsist : varchar(28)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1782743211 sy_mmd5
* hash : varchar(32)
* dt : datetime
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 sy_sbase
* id : bigint(10)
* date : date
* ver : varchar(20)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1782743211 sy_sroles
* id : int(10) unsigned
* name : varchar(100)
* is_del : tinyint(1) unsigned
v mgn5_1782743211 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 mgn5_1782743211 sy_ssetgr
* id : bigint(10)
* name : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1782743211 sy_ssetur
* id : bigint(10)
* name : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1782743211 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 mgn5_1782743211 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 mgn5_1782743211 transaction_map
* internal_transaction_id : bigint(20) unsigned
* external_transaction_id : varchar(256)
* provider : int(11)
* request_type : int(11)
* request_context : mediumtext
v mgn5_1782743211 transaction_tip
* id : bigint(20) unsigned
* msut_id : bigint(20) unsigned
* amount : double
* percentage : double
* user_id : int(11)
* sgo_id : int(11)
* dtz : datetime
v mgn5_1782743211 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