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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 as_sgor
* id : bigint(10)
* naim : varchar(40)
* pr5 : int(3)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1755595046 as_sgrg
* id : bigint(10)
* naim : varchar(30)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1755595046 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_1755595046 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_1755595046 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)
* cycle_pay_email : varchar(255)
* cycle_pay_is_active : tinyint(1)
* cycle_pay_is_default : tinyint(1)
v mgn5_1755595046 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)
* cycle_pay_email : varchar(255)
* cycle_pay_is_active : tinyint(1)
* cycle_pay_is_default : tinyint(1)
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 checkout_cart
* id : bigint(20) unsigned
* public_id : char(27)
* status : varchar(16)
* session_id : bigint(20) unsigned
* origin_host : varchar(255)
* created_at : datetime
* updated_at : datetime
* converted_at : datetime
v mgn5_1755595046 checkout_cart_item
* id : bigint(20) unsigned
* cart_id : bigint(20) unsigned
* snon_id : int(11)
* quantity : int(11)
* name : varchar(200)
* added_at : datetime
* variant_id : bigint(20) unsigned
* variant_key : bigint(20) unsigned
v mgn5_1755595046 checkout_promo_code
* id : bigint(20) unsigned
* code : varchar(32)
* type : varchar(8)
* value : decimal(15,2)
* description : varchar(255)
* min_subtotal : decimal(15,2)
* starts_at : datetime
* ends_at : datetime
* max_redemptions : int(11)
* once_per_customer : tinyint(1)
* active : tinyint(1)
* times_redeemed : int(11)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v mgn5_1755595046 checkout_promo_redemption
* promo_code_id : bigint(20) unsigned
* session_id : bigint(20) unsigned
* mz_id : bigint(20) unsigned
* customer_email : varchar(255)
* created_at : datetime
v mgn5_1755595046 checkout_session
* id : bigint(20) unsigned
* public_id : varchar(32)
* token : varchar(64)
* external_order_id : varchar(100)
* status : varchar(16)
* currency_id : int(11)
* locale : varchar(8)
* allow_quantity_decrease : tinyint(1)
* allowed_payment_methods : varchar(64)
* allowed_delivery_types : varchar(32)
* customer : longtext
* delivery : longtext
* payment_method : varchar(16)
* subtotal : decimal(15,2)
* discount : decimal(15,2)
* delivery_amount : decimal(15,2)
* tax : decimal(15,2)
* total : decimal(15,2)
* success_url : varchar(2048)
* cancel_url : varchar(2048)
* metadata : longtext
* mz_id : bigint(20) unsigned
* idempotency_key : varchar(64)
* request_hash : char(64)
* created_at : datetime
* expires_at : datetime
* placed_at : datetime
* completed_at : datetime
* idempotency_response : longtext
* place_idempotency_key : varchar(64)
* place_request_hash : char(64)
* place_response : text
* receipt_done_at : datetime
* digital_done_at : datetime
* reissued_payment_id : varchar(64)
* spz_id : bigint(20) unsigned
* cart_id : bigint(20) unsigned
* channel : varchar(16)
* reminder_sent_at : datetime
* order_cancelled_at : datetime
* allow_promotion_codes : tinyint(1)
* promo_code_id : bigint(20) unsigned
* promo_code : varchar(32)
* promo_type : varchar(8)
* promo_value : decimal(15,2)
* promo_min_subtotal : decimal(15,2)
* reversed_sale : longtext
v mgn5_1755595046 checkout_session_discount
* id : bigint(20) unsigned
* session_id : bigint(20) unsigned
* position : smallint(6)
* label : varchar(100)
* type : varchar(8)
* value : decimal(15,2)
v mgn5_1755595046 checkout_session_item
* id : bigint(20) unsigned
* session_id : bigint(20) unsigned
* line_no : smallint(6)
* name : varchar(200)
* quantity_original : int(11)
* quantity : int(11)
* unit_price : decimal(15,2)
* discount_per_unit : decimal(15,2)
* tax_rate : decimal(5,2)
* tax_included : tinyint(1)
* allow_quantity_decrease : tinyint(1)
* sku : varchar(100)
* external_id : varchar(100)
* image_url : varchar(1024)
* weight_g : int(11)
* dimensions_mm : longtext
* snon_id : int(11)
* metadata : longtext
* variant_id : bigint(20) unsigned
* variant_name : varchar(200)
v mgn5_1755595046 checkout_webhook_attempt
* id : bigint(20) unsigned
* delivery_id : bigint(20) unsigned
* attempt : tinyint(3) unsigned
* http_code : smallint(6)
* error : varchar(64)
* created_at : datetime
v mgn5_1755595046 checkout_webhook_delivery
* id : bigint(20) unsigned
* event_id : varchar(32)
* event_type : varchar(64)
* session_id : bigint(20) unsigned
* payload : longtext
* status : varchar(16)
* attempts : tinyint(4)
* next_attempt_at : datetime
* last_http_code : smallint(6)
* last_error : varchar(500)
* created_at : datetime
* endpoint_id : int(10) unsigned
v mgn5_1755595046 checkout_webhook_endpoint
* id : int(10) unsigned
* url : varchar(2048)
* secret : varchar(128)
* events : varchar(255)
* is_active : tinyint(1)
* created_at : datetime
* is_primary : tinyint(1)
* description : varchar(100)
* updated_at : datetime
v mgn5_1755595046 checkout_widget
* id : tinyint(3) unsigned
* enabled : tinyint(1)
* allowed_domains : text
* spz_id : bigint(20) unsigned
* accent_color : char(7)
* button_text : varchar(40)
* cart_mode : varchar(16)
* after_add : varchar(16)
* floating_button : varchar(16)
* success_url : varchar(2048)
* allow_promotion_codes : tinyint(1)
* datalayer : tinyint(1)
* updated_at : datetime
* connected_from : text
v mgn5_1755595046 checkout_widget_origin
* host : varchar(255)
* allowed : tinyint(1)
* first_seen_at : datetime
* last_seen_at : datetime
v mgn5_1755595046 clients_trigger
* sabor_id : bigint(10)
* date_last_visit : datetime
* count_operation : int(10)
* average_value : double
* total : double
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 data_table_user_config
* susers_id : bigint(10)
* action : varchar(255)
* body : longtext
* dtz : date
* timz : varchar(10)
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 eshop_block_type
* id : bigint(20)
* eshop_id : bigint(20) unsigned
* type : varchar(50)
* label : varchar(100)
* description : text
* html_template : longtext
* props_schema : longtext
* is_system : tinyint(1)
* created_at : datetime
* updated_at : datetime
v mgn5_1755595046 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)
* delivery_method_id : int(11)
* phone : varchar(32)
* phone_country : varchar(2)
* msut_id : bigint(10)
* requisites : varchar(8000)
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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)
* description : varchar(255)
v mgn5_1755595046 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)
* description : varchar(255)
v mgn5_1755595046 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_1755595046 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_1755595046 eshop_field_type
* id : bigint(20) unsigned
* type : varchar(255)
* name : varchar(255)
* placeholder : varchar(255)
* is_active : tinyint(1)
v mgn5_1755595046 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_1755595046 eshop_page_layout
* id : bigint(20)
* eshop_id : bigint(20) unsigned
* page_type : varchar(50)
* version : int(11)
* layout_json : longtext
* is_published : tinyint(1)
* ai_prompt : text
* ai_model : varchar(100)
* created_at : datetime
* updated_at : datetime
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 eshop_product_param
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* name : varchar(250)
* value : varchar(1000)
v mgn5_1755595046 eshop_product_param_v1
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* name : varchar(250)
* value : varchar(1000)
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 eshop_suffix
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* suffix : varchar(100)
* location : varchar(100)
* is_active : tinyint(4)
v mgn5_1755595046 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_1755595046 fd_mac
* sgo_id : bigint(10)
* kurs : double
* is_del : int(11) unsigned
* dtz : date
* timz : varchar(10)
v mgn5_1755595046 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
* 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_1755595046 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_1755595046 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_1755595046 lt_store_staff
* susers_id : bigint(10)
* spz_id : bigint(10)
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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 mgn5_1755595046 ms_msu_op_snon_history
* msu_id : int(10) unsigned
* op_snon_history_id : int(10) unsigned
v mgn5_1755595046 ms_msu_return
* id : int(11)
* msu_id : bigint(20)
* msut_id : bigint(20)
* cont : varchar(255)
* quantity : double
v mgn5_1755595046 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_1755595046 ms_sgro
* id : bigint(10)
* naim : varchar(80)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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
* delivery_method_id : int(11)
* order_comment : text
* delivery_comment : text
* delivery_datetime : datetime
* pay_type : int(11)
* order_payment_create_type : int(1)
* order_payment_property_type : int(10) unsigned
* address_parts : longtext
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 op_snont
* id : bigint(11) unsigned
* naim : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(10) unsigned
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 op_sppr
* id : int(10)
* naim : varchar(50)
v mgn5_1755595046 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
* external_tran_id : varchar(200)
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 product_store_available
* id : bigint(10) unsigned
* product_id : bigint(20)
* store_id : int(11)
* is_available : tinyint(1)
v mgn5_1755595046 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_1755595046 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_1755595046 sku_store_available
* id : bigint(10) unsigned
* sku_id : bigint(11)
* store_id : int(11)
* is_available : tinyint(1)
v mgn5_1755595046 store_prices
* id : bigint(10) unsigned
* spz_id : bigint(10) unsigned
* snon_id : bigint(10) unsigned
* cenao_sp : double
* cenad_sp : double
v mgn5_1755595046 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_1755595046 store_type
* id : int(10) unsigned
* store_type_name : varchar(100)
v mgn5_1755595046 su_psys
* id : bigint(10)
* sist : varchar(4)
* nsist : varchar(28)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1755595046 sy_mmd5
* hash : varchar(32)
* dt : datetime
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 sy_sbase
* id : bigint(10)
* date : date
* ver : varchar(20)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1755595046 sy_sroles
* id : int(10) unsigned
* name : varchar(100)
* is_del : tinyint(1) unsigned
v mgn5_1755595046 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_1755595046 sy_ssetgr
* id : bigint(10)
* name : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1755595046 sy_ssetur
* id : bigint(10)
* name : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v mgn5_1755595046 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_1755595046 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_1755595046 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_1755595046 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_1755595046 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