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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 as_sabop
* id : bigint(10)
* sabor_id : bigint(10)
* aspar_id : bigint(10)
* parc : varchar(50)
* parm : text
* dtz : date
* timz : varchar(10)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 as_sgor
* id : bigint(10)
* naim : varchar(40)
* pr5 : int(3)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v regtpl_8713618d37b73346 as_sgrg
* id : bigint(10)
* naim : varchar(30)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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
v regtpl_8713618d37b73346 checkout_webhook_endpoint
* id : int(10) unsigned
* url : varchar(2048)
* secret : varchar(128)
* events : varchar(255)
* is_active : tinyint(1)
* created_at : datetime
v regtpl_8713618d37b73346 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
v regtpl_8713618d37b73346 checkout_widget_origin
* host : varchar(255)
* allowed : tinyint(1)
* first_seen_at : datetime
* last_seen_at : datetime
v regtpl_8713618d37b73346 clients_trigger
* sabor_id : bigint(10)
* date_last_visit : datetime
* count_operation : int(10)
* average_value : double
* total : double
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 data_table_user_config
* susers_id : bigint(10)
* action : varchar(255)
* body : longtext
* dtz : date
* timz : varchar(10)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 device_events
* id : bigint(10) unsigned
* event : varchar(20)
* body : text
* event_date : datetime
* susers_id : bigint(10)
* spd_id : int(10) unsigned
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 eshop_field_type
* id : bigint(20) unsigned
* type : varchar(255)
* name : varchar(255)
* placeholder : varchar(255)
* is_active : tinyint(1)
v regtpl_8713618d37b73346 eshop_image
* id : int(11)
* eshop_id : int(11)
* path : varchar(3000)
* name : varchar(255)
* is_active : tinyint(1)
* is_default : tinyint(1)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 eshop_product
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* external_product_id : bigint(20)
* alias : varchar(250)
* is_active : tinyint(4)
v regtpl_8713618d37b73346 eshop_product_param
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* name : varchar(250)
* value : varchar(1000)
v regtpl_8713618d37b73346 eshop_product_param_v1
* id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* name : varchar(250)
* value : varchar(1000)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 eshop_suffix
* id : bigint(20) unsigned
* eshop_id : bigint(20) unsigned
* suffix : varchar(100)
* location : varchar(100)
* is_active : tinyint(4)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 fd_mac
* sgo_id : bigint(10)
* kurs : double
* is_del : int(11) unsigned
* dtz : date
* timz : varchar(10)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 lt_store_staff
* susers_id : bigint(10)
* spz_id : bigint(10)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 ms_msu_op_snon_history
* msu_id : int(10) unsigned
* op_snon_history_id : int(10) unsigned
v regtpl_8713618d37b73346 ms_msu_return
* id : int(11)
* msu_id : bigint(20)
* msut_id : bigint(20)
* cont : varchar(255)
* quantity : double
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 ms_sgro
* id : bigint(10)
* naim : varchar(80)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 op_snont
* id : bigint(11) unsigned
* naim : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(10) unsigned
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 op_sppr
* id : int(10)
* naim : varchar(50)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 product_button
* id : bigint(20) unsigned
* product_id : int(11)
* name : varchar(255)
* is_active : tinyint(1)
* order : int(11)
* action : int(11)
v regtpl_8713618d37b73346 product_store_available
* id : bigint(10) unsigned
* product_id : bigint(20)
* store_id : int(11)
* is_available : tinyint(1)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 sku_store_available
* id : bigint(10) unsigned
* sku_id : bigint(11)
* store_id : int(11)
* is_available : tinyint(1)
v regtpl_8713618d37b73346 store_prices
* id : bigint(10) unsigned
* spz_id : bigint(10) unsigned
* snon_id : bigint(10) unsigned
* cenao_sp : double
* cenad_sp : double
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 store_type
* id : int(10) unsigned
* store_type_name : varchar(100)
v regtpl_8713618d37b73346 su_psys
* id : bigint(10)
* sist : varchar(4)
* nsist : varchar(28)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v regtpl_8713618d37b73346 sy_mmd5
* hash : varchar(32)
* dt : datetime
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 sy_sbase
* id : bigint(10)
* date : date
* ver : varchar(20)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v regtpl_8713618d37b73346 sy_sroles
* id : int(10) unsigned
* name : varchar(100)
* is_del : tinyint(1) unsigned
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 sy_ssetgr
* id : bigint(10)
* name : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v regtpl_8713618d37b73346 sy_ssetur
* id : bigint(10)
* name : varchar(50)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 sy_susers_passcode
* susers_id : bigint(10)
* passcode : varchar(255)
* updated_at : datetime
v regtpl_8713618d37b73346 transaction_map
* internal_transaction_id : bigint(20) unsigned
* external_transaction_id : varchar(256)
* provider : int(11)
* request_type : int(11)
* request_context : mediumtext
v regtpl_8713618d37b73346 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 regtpl_8713618d37b73346 users_conditions
* id : bigint(10) unsigned
* susers_id : bigint(10)
* event : varchar(20)
* condition : int(3)
* condition_body : text
* dtz : date
* timz : varchar(10)
v regtpl_8713618d37b73346 _regtpl_ready
* dump_sha1 : char(40)
* format : tinyint(4)
* dump_path : varchar(255)
* tables_count : int(11)
* manifest : mediumtext
* built_at : datetime
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship