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 a04004_magelan aci_payment_log
* id : bigint(20) unsigned
* bases_id : int(10) unsigned
* date_create : timestamp
* ext_data : text
* payment_id : varchar(50)
* code : varchar(11)
* entity_id : varchar(50)
v a04004_magelan aci_payment_session
* id : bigint(20) unsigned
* bases_id : int(10) unsigned
* date_update : timestamp
* date_create : timestamp
* code : varchar(11)
* session_id : varchar(50)
* payment_id : varchar(500)
* status : int(11)
* entity_id : varchar(50)
* mz_id : bigint(20) unsigned
* deadline : datetime
* payment_profile : text
* refunded_amount : decimal(15,2)
* checker : varchar(50)
* last_check_time : datetime
v a04004_magelan aci_refund_operations
* id : bigint(20) unsigned
* payment_session_id : bigint(20) unsigned
* msut_id : bigint(20) unsigned
* mdr_id : bigint(20) unsigned
* bases_id : int(10) unsigned
* amount : decimal(15,2)
* status : tinyint(4)
* crossswitch_refund_id : varchar(50)
* error_message : text
* checker : varchar(50)
* last_check_time : datetime
* date_create : timestamp
* date_update : timestamp
v a04004_magelan acl_role
* id : int(10) unsigned
* name : varchar(20)
* descr : varchar(200)
v a04004_magelan acl_roles_users
* user_id : int(10) unsigned
* role_id : tinyint(3) unsigned
v a04004_magelan api_exc_log
* id : bigint(20) unsigned
* datetime : timestamp
* bases_id : int(10) unsigned
* request_uri : varchar(255)
* post_data : text
* content_data : text
* server_data : text
* response_data : text
* user_agent : text
* cookie : text
* result : varchar(100)
* spd_id : int(11)
v a04004_magelan applications
* id : int(10) unsigned
* name : varchar(50)
* date : datetime
* is_available : tinyint(3) unsigned
v a04004_magelan app_listener
* id : int(10) unsigned
* app_id : int(10) unsigned
* base_id : int(10) unsigned
* is_available : int(10) unsigned
v a04004_magelan app_params
* id : int(10) unsigned
* app_id : int(10) unsigned
* name : varchar(50)
* type : tinyint(1)
* def_value : varchar(100)
v a04004_magelan app_par_values
* app_id : int(11)
* base_id : int(11)
* param_id : int(11)
* value : varchar(100)
v a04004_magelan app_temp
* id : bigint(20) unsigned
* identity : varchar(50)
* value : text
* app_id : int(10) unsigned
v a04004_magelan as_sabor
* uid : binary(16)
* bases_id : int(10) unsigned
* updated_at : timestamp
* created_at : timestamp
* 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)
* 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 a04004_magelan aws_s3_file
* id : bigint(20) unsigned
* s3_key : varchar(300)
* s3_bucket : varchar(50)
* bases_id : int(11)
* datetime : timestamp
* public_url : varchar(500)
* file_name_source : varchar(300)
* file_tag : varchar(50)
v a04004_magelan bases
* id : int(10) unsigned
* name : varchar(20)
* users_id : bigint(20) unsigned
* date : datetime
* auth_params : text
* is_new : tinyint(4)
* subdomain : varchar(100)
* phone : varchar(20)
* phone_country : varchar(2)
* config_id : int(11)
* date_start : datetime
* date_expiration : datetime
* is_available : tinyint(1)
* locale : varchar(5)
* id2can : bigint(20)
* is_test : tinyint(3) unsigned
* tarif_id : int(10) unsigned
* tariff_period : int(11)
* is_enterprise : tinyint(3) unsigned
* old_tarif_id : int(10) unsigned
* promo : varchar(50)
* is_api : tinyint(3) unsigned
* sign_up_step : int(11)
* log_level : tinyint(1)
* is_validate_email : tinyint(3) unsigned
* checkout_test_of : int(10) unsigned
v a04004_magelan bases_active
* bases_id : bigint(20) unsigned
* date : datetime
v a04004_magelan bases_config
* id : bigint(20)
* name : varchar(100)
v a04004_magelan bases_cr
* id : bigint(20) unsigned
* bases_id : int(10) unsigned
* id2can : bigint(20) unsigned
* uname : varchar(100)
* tarif_id : int(10) unsigned
* count_cash : int(11)
* currency : varchar(3)
* summ_itog : double
* summ_itog_rub : double
* cash_rub : double
* summ_by_type : text
* countop_cash : int(11)
* avg_cash : double
v a04004_magelan bases_details
* bases_id : int(10) unsigned
* norg : varchar(200)
* uname : varchar(100)
* requisites : text
* timezone : varchar(100)
* currency : varchar(100)
* count_staff : int(11)
* count_shops : int(11)
* setting : text
v a04004_magelan bases_events
* id : int(11)
* id_base : int(11)
* id_user : int(11)
* event : varchar(50)
* date : timestamp
* data : text
v a04004_magelan bases_settings
* id : int(10) unsigned
* bases_id : int(10) unsigned
* setting_name : varchar(256)
* setting_value : varchar(2048)
* setting_type : varchar(64)
v a04004_magelan calculated_transaction_recalculation_queue
* id : bigint(20) unsigned
* base_id : int(10) unsigned
* transaction_id : bigint(20) unsigned
* asc_priority : int(11)
* created_at : datetime
* updated_at : datetime
* start_processing_at : datetime
* processing_started_at : datetime
* processing_ended_at : datetime
* status : tinyint(4)
* processing_attempts_count : int(10) unsigned
v a04004_magelan checker
* id : int(10) unsigned
* type : int(10) unsigned
* id_type : int(10) unsigned
* date_update : timestamp
* created : timestamp
* updated : timestamp
v a04004_magelan checkout_api_key
* id : int(10) unsigned
* bases_id : int(10) unsigned
* user_id : int(10) unsigned
* name : varchar(100)
* key_prefix : varchar(16)
* key_hash : char(64)
* created_at : datetime
* last_used_at : datetime
* revoked_at : datetime
* scopes : varchar(255)
v a04004_magelan checkout_publishable_key
* key : varchar(48)
* bases_id : int(10) unsigned
* created_at : datetime
* revoked_at : datetime
v a04004_magelan checkout_session_index
* token : varchar(64)
* bases_id : int(10) unsigned
* session_id : bigint(20) unsigned
* expires_at : datetime
v a04004_magelan checkout_webhook_due
* bases_id : int(10) unsigned
* due_at : datetime
* version : bigint(20) unsigned
* marked_at : datetime
v a04004_magelan client
* id : bigint(20) unsigned
* uid : varchar(36)
* bases_id : int(11)
* user_id : int(11)
* date_create : timestamp
* date_update : timestamp
v a04004_magelan client_event_registrator
* id : bigint(20) unsigned
* client_uid : varchar(36)
* event : varchar(32)
* data : text
* date_create : timestamp
* date_update : timestamp
v a04004_magelan country
* country_code : varchar(2)
* country_name : varchar(45)
* format_date : varchar(20)
* format_time : varchar(20)
* format_currency : varchar(20)
* format_decimal : varchar(1)
* format_thousands : varchar(1)
v a04004_magelan country_currency
* country_code : varchar(2)
* knm : varchar(10)
v a04004_magelan cross_payment_ibox_msut
* id : bigint(20) unsigned
* payment_ibox_id : bigint(20) unsigned
* bases_id : int(10) unsigned
* msut_id : int(10) unsigned
* cart_id : int(10) unsigned
v a04004_magelan currency
* id : bigint(20) unsigned
* knm : varchar(10)
v a04004_magelan custom_modules
* id : int(10) unsigned
* module_name : varchar(100)
* is_active : tinyint(4)
* descr : text
* pnz : int(11)
v a04004_magelan devices
* id : bigint(20) unsigned
* activation_code : varchar(8)
* bases_id : int(10) unsigned
* spd_id : int(10) unsigned
* dtz : date
* timz : varchar(10)
* is_available : int(11)
* date_act : datetime
* PUBLIC_KEY : varchar(100)
v a04004_magelan device_active
* id : int(10) unsigned
* bases_id : int(10) unsigned
* spd_id : int(10) unsigned
* data : varchar(32)
* date_create : timestamp
* date_at : timestamp
v a04004_magelan device_binding
* id : bigint(20) unsigned
* base_id : int(10) unsigned
* parent_spd_id : int(10) unsigned
* child_spd_id : int(10) unsigned
v a04004_magelan device_command
* id : bigint(20)
* base_id : int(10) unsigned
* spd_id : int(10) unsigned
* code : varchar(64)
* type : int(11)
v a04004_magelan device_description
* id : bigint(20)
* bases_id : int(10) unsigned
* spd_id : int(10) unsigned
* device_name : varchar(200)
* device_id : varchar(100)
* device_model : text
* is_available : int(10) unsigned
* spz_id : bigint(20) unsigned
* device_address : varchar(200)
* device_type : int(11)
* version : varchar(200)
* date_at : timestamp
v a04004_magelan device_list
* id : bigint(20)
* bases_id : int(10) unsigned
* spd_id : int(10) unsigned
* device_model : varchar(100)
* name : varchar(100)
* is_available : int(10) unsigned
* is_del : int(10) unsigned
* spz_id : int(10) unsigned
* device_type : int(10) unsigned
* version : varchar(200)
* push_token : varchar(1000)
* provider : varchar(100)
* app : varchar(100)
* device_role : int(10) unsigned
v a04004_magelan device_online
* id : int(10) unsigned
* bases_id : int(10) unsigned
* spd_id : int(11)
* date : datetime
* time_online : int(11)
v a04004_magelan device_transactions
* id : bigint(20) unsigned
* bases_id : int(10) unsigned
* spd_id : int(10) unsigned
* data : text
* date_create : timestamp
* date_at : timestamp
v a04004_magelan entity_sms_code
* id : bigint(20) unsigned
* entity_id : bigint(20) unsigned
* entity_type : varchar(64)
* bases_id : int(10) unsigned
* phone : varchar(32)
* code : varchar(32)
* last_requested : timestamp
* request_count : int(10) unsigned
v a04004_magelan eshop_active
* id : bigint(20) unsigned
* bases_id : int(11)
* eshop_id : bigint(20)
* data : longtext
* date_create : datetime
* date_at : datetime
* uri : varchar(250)
v a04004_magelan eshop_hostname
* id : bigint(20) unsigned
* base_id : int(10) unsigned
* eshop_id : bigint(20) unsigned
* hostname : varchar(512)
* deleted_at : timestamp
* is_hostname_processing : int(11)
* new_hostname : varchar(512)
* xxxxx : int(11)
v a04004_magelan export
* id : int(10) unsigned
* type : varchar(60)
* base_id : int(10) unsigned
* user_id : int(10) unsigned
* filename : varchar(256)
* status : tinyint(3) unsigned
* items_total : int(10) unsigned
* ids : text
* locale : varchar(5)
* created : timestamp
* updated : timestamp
* items_processed : int(10) unsigned
* public_url : varchar(300)
* error_message : varchar(512)
* progress_at : datetime(6)
v a04004_magelan external_fiscalization
* id : bigint(20) unsigned
* base_id : int(11)
* provider : varchar(100)
* uuid : varchar(300)
* spd_id : int(11)
* msut_id : int(11)
* status : tinyint(1)
* date_create : datetime
* response_data : longtext
v a04004_magelan fd_mdr
* uid : binary(16)
* bases_id : int(10) unsigned
* updated_at : timestamp
* created_at : timestamp
* 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 a04004_magelan fd_subscription_queue
* id : bigint(20)
* table_name : varchar(64)
* where_clause : text
* row_data : text
* base_id : int(10) unsigned
* asc_priority : int(11)
* status : tinyint(4)
* created_at : timestamp
* updated_at : datetime
* start_processing_at : datetime
* processing_started_at : datetime
* processing_ended_at : datetime
* processing_attempts_count : int(10) unsigned
* error_message : text
v a04004_magelan field
* id : int(11)
* parent_id : int(11)
* merchant_category_code : varchar(4)
* name : varchar(200)
v a04004_magelan filesystem_client
* id : bigint(20)
* bases_id : int(10) unsigned
* size : int(11)
* date_create : timestamp
* date_update : timestamp
v a04004_magelan import
* id : int(10) unsigned
* type : varchar(10)
* base_id : int(10) unsigned
* user_id : int(10) unsigned
* params : text
* filename : varchar(255)
* filepath : varchar(512)
* created : timestamp
* updated : timestamp
* status : tinyint(3) unsigned
* items_processed : int(10) unsigned
* items_error : int(10) unsigned
* items_total : int(10) unsigned
* deleted : tinyint(1)
* count_iterations : int(11)
* iteration_status : int(11)
* error_message : varchar(512)
* progress_at : datetime(6)
* queue : int(11)
v a04004_magelan import_data
* id : int(11)
* import_id : int(10) unsigned
* json_data : longtext
* created_at : timestamp
* updated_at : timestamp
v a04004_magelan import_events
* id : bigint(20)
* date_event : timestamp
* log : longtext
* stack_id : bigint(20)
v a04004_magelan import_stack
* id : bigint(20) unsigned
* type : int(10) unsigned
* bases_id : int(10) unsigned
* dts : timestamp
* dte : timestamp
* status : int(10) unsigned
* pid : int(11)
v a04004_magelan insales_categories
* PID : int(10) unsigned
* id : int(10) unsigned
* parent_id : int(10) unsigned
* position : int(10) unsigned
* title : varchar(200)
* base_id : int(10) unsigned
* smcur_id : bigint(20) unsigned
* smcgr_id : bigint(20) unsigned
v a04004_magelan insales_option
* PID : int(10) unsigned
* id : int(10) unsigned
* position : int(10) unsigned
* title : varchar(200)
* base_id : int(10) unsigned
* smcur_id : bigint(20) unsigned
* smcgr_id : bigint(20) unsigned
v a04004_magelan insales_option_value
* PID : int(10) unsigned
* id : int(10) unsigned
* position : int(10) unsigned
* option_name_id : int(10) unsigned
* title : varchar(200)
* base_id : int(10) unsigned
* smcur_id : bigint(20) unsigned
* smcgr_id : bigint(20) unsigned
v a04004_magelan insales_params
* PID : int(10) unsigned
* id : int(10) unsigned
* backoffice : tinyint(1)
* is_hidden : tinyint(1)
* is_navigational : tinyint(1)
* position : int(11)
* title : varchar(150)
* base_id : int(10) unsigned
* spar_id : bigint(20) unsigned
v a04004_magelan insales_params_value
* PID : bigint(20) unsigned
* id : int(10) unsigned
* property_id : int(10) unsigned
* title : varchar(200)
* base_id : int(10) unsigned
* spar_id : bigint(20) unsigned
v a04004_magelan insales_product
* PID : int(10) unsigned
* id : int(10) unsigned
* base_id : int(10) unsigned
* snon_id : bigint(20) unsigned
v a04004_magelan insales_unit
* PID : int(10) unsigned
* name : varchar(100)
* name_ru : varchar(100)
* base_id : int(10) unsigned
* seizm_id : bigint(20) unsigned
v a04004_magelan insales_variants
* PID : int(10) unsigned
* id : int(10) unsigned
* base_id : int(10) unsigned
* msus_id : bigint(20) unsigned
v a04004_magelan key_value
* id : bigint(20) unsigned
* key : varchar(1000)
* value : mediumtext
* created_at : timestamp
* updated_at : timestamp
* expired_at : timestamp
v a04004_magelan lock_keys
* key_id : varchar(64)
* key_token : varchar(44)
* key_expiration : int(10) unsigned
v a04004_magelan lt_modules_countries
* custom_modules_id : int(10) unsigned
* country_code : varchar(2)
v a04004_magelan marking_client_products
* uid : bigint(20)
* bases_id : int(10) unsigned
* marking_tag : int(11)
* product_id : int(10) unsigned
v a04004_magelan marking_device_report
* id : int(10) unsigned
* bases_id : int(11)
* spd_id : int(11)
* device_name : varchar(255)
* device_model : varchar(255)
* spz_id : int(11)
* storage_name : varchar(255)
* has_marking : varchar(8)
* marking_count : int(11)
* summ : double
* last_dataop : date
* period_start : date
* period_end : date
* created_at : timestamp
v a04004_magelan marking_tags
* id : int(10) unsigned
* name : varchar(100)
v a04004_magelan measures
* id : bigint(20)
* group_id : bigint(20)
* measures_name : varchar(25)
* measures_name_short : varchar(15)
* okei : varchar(3)
* fraction_digits_number : int(10) unsigned
* locale : varchar(5)
v a04004_magelan merchant_card
* id : bigint(20) unsigned
* date_create : timestamp
* date_update : timestamp
* pan : varchar(20)
* bases_id : int(10) unsigned
* pnz : int(11)
* is_active : int(11)
* type_card : varchar(20)
v a04004_magelan merchant_document
* id : int(10) unsigned
* document_name : varchar(255)
* date_create : timestamp
* date_update : timestamp
* document_body : longtext
* document_preview : varchar(500)
* document_type : int(10) unsigned
* is_del : int(11)
* is_active : tinyint(4)
* bases_id : int(10) unsigned
* order : int(10) unsigned
* eshop_id : bigint(20) unsigned
v a04004_magelan merchant_document_pub
* id : int(10) unsigned
* document_name : varchar(255)
* date_create : timestamp
* date_update : timestamp
* document_body : longtext
* document_preview : varchar(500)
* document_type : int(10) unsigned
* is_del : int(11)
* is_active : tinyint(4)
* bases_id : int(10) unsigned
* order : int(10) unsigned
* eshop_id : bigint(20) unsigned
v a04004_magelan merchant_payment_log
* id : bigint(20)
* date_create : timestamp
* date_update : timestamp
* bases_id : int(11)
* payment_type : int(11)
* tarif_id : int(10) unsigned
* amount : double
* payment_status : int(11)
* ext_data : text
* is_user_log : int(11)
v a04004_magelan merchant_rebill
* id : int(11)
* bases_id : int(11)
* boxplat_id : varchar(128)
* amount : double
* days : int(11)
* date_create : timestamp
* date_update : timestamp
* tarif_id : int(10) unsigned
* mc_id : bigint(20) unsigned
* type : varchar(30)
v a04004_magelan merchant_rebill_event
* id : bigint(20)
* date_create : timestamp
* date_update : timestamp
* mc_id : bigint(20) unsigned
* bases_id : int(10) unsigned
* date_event : timestamp
* rebill_done : int(11)
* merchant_rebill_id : int(11)
v a04004_magelan ms_msu
* uid : binary(16)
* bases_id : int(10) unsigned
* updated_at : timestamp
* created_at : timestamp
* id : bigint(10)
* spz_sid : int(4)
* snon_id : int(9)
* parent_snon_id : int(9) unsigned
* kont : varchar(32)
* dataop : date
* ndok : varchar(20)
* tdok : varchar(10)
* pnz : int(4)
* svop_id : int(4)
* svop_pu : int(1)
* sabor_kid : int(9)
* sabor_rid : int(9)
* spz_cid : int(9)
* sprp_id : int(9)
* mz_id : int(9)
* zak : varchar(15)
* spz : varchar(20)
* sppr_id : int(10)
* kol : double
* ost : double
* reserve : double
* cena : double
* sgo_id : int(4)
* kurs : double
* cenao : double
* sgo_oid : int(4)
* okurs : double
* cenad : double
* original_price : double
* discount_item : double
* sopr_id : int(3)
* sopr : varchar(10)
* dsopr : date
* sob_id : int(9)
* nobj : varchar(20)
* mlskod : varchar(15)
* seizm_id : int(3)
* msus_id : int(9)
* ppv : int(1)
* dtz : date
* timz : varchar(10)
* is_del : int(11)
* susers_id : int(9) unsigned
* msut_id : bigint(10) unsigned
* parent_msut_id : bigint(10) unsigned
* stnds : double
* sumnds : double
* tax_type : int(10) unsigned
* device_id : varchar(100)
* spd_id : int(10) unsigned
* marking_body : varchar(100)
* marking_raw : varchar(255)
* marking_raw_check : varchar(32)
* marking_tag : int(10) unsigned
* marking_crpt_validation_request_id : varchar(36)
* marking_crpt_validation_request_timestamp : varchar(25)
* fiscal_spd_id : int(10) unsigned
* quantity_real_sale : double
* product_name : varchar(200)
* modifiers : text
* agent_tin : varchar(15)
* agent_phone : varchar(20)
* agent_name : varchar(200)
* agent_id : bigint(20)
* agent_sign : tinyint(4)
* rg_id : int(11) unsigned
v a04004_magelan ms_msus
* uid : binary(16)
* bases_id : int(10) unsigned
* updated_at : timestamp
* created_at : timestamp
* 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 a04004_magelan ms_msusp
* uid : binary(16)
* bases_id : int(10) unsigned
* updated_at : timestamp
* created_at : timestamp
* 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 a04004_magelan ms_msusw
* uid : binary(16)
* bases_id : int(10) unsigned
* updated_at : timestamp
* created_at : timestamp
* 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 a04004_magelan ms_msut
* uid : binary(16)
* bases_id : int(10) unsigned
* updated_at : timestamp
* created_at : timestamp
* 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 a04004_magelan nds_report
* id : int(10) unsigned
* bases_id : int(11)
* uname : varchar(255)
* norg : varchar(255)
* nds_enabled : varchar(8)
* nds_default : varchar(16)
* nds_rates : varchar(64)
* created_at : timestamp
v a04004_magelan notification_channel
* id : int(10) unsigned
* name : varchar(1000)
v a04004_magelan notification_config
* id : bigint(20) unsigned
* entity_id : bigint(20)
* entity_type : enum('user','telegram_chat')
* notification_event_id : int(10) unsigned
* notification_channel_id : int(10) unsigned
* is_active : tinyint(4)
* meta : text
v a04004_magelan notification_event
* id : int(10) unsigned
* name : varchar(1000)
v a04004_magelan openai_log
* id : bigint(20)
* ai_request : text
* ai_response : text
* bases_id : int(10) unsigned
* user_id : int(10) unsigned
* date_create : timestamp
* date_update : timestamp
v a04004_magelan orders_check_payment
* id : bigint(20) unsigned
* date_at : timestamp
* orders_id : int(10) unsigned
* bases_id : int(10) unsigned
* checked : tinyint(3) unsigned
v a04004_magelan payment
* id : bigint(20)
* date : datetime
* body : text
v a04004_magelan payment_ibox
* id : bigint(20) unsigned
* ibox_id : varchar(128)
* amount : double
* create_date : datetime
* status : varchar(20)
* deadline : datetime
* response_data : longtext
* last_check_time : datetime
* checker : varchar(128)
* source : varchar(255)
* is_refund : tinyint(1)
* TransactionReverseID : varchar(128)
* refund_status : tinyint(1)
* fiscal_status : tinyint(1)
* TransactionByPrepayment : text
* TransactionIDByPrepayment : varchar(128)
* agent : varchar(200)
* dup : timestamp
v a04004_magelan payment_ibox_check
* id : bigint(20)
* bases_id : int(11)
* msut_id : int(11)
* ibox_transaction_status : int(11)
* agent : varchar(200)
* data : text
* date_create : timestamp
* date_update : timestamp
v a04004_magelan payment_ibox_log
* id : bigint(20) unsigned
* payment_ibox_id : bigint(20)
* data : text
* message : varchar(200)
* bases_id : bigint(20)
* uri : varchar(250)
* body : text
* date_create : timestamp
* date_update : timestamp
v a04004_magelan payment_operation_group
* id : int(11)
* payment_group_name : varchar(150)
* date_at : timestamp
* is_del : int(10) unsigned
v a04004_magelan payment_orders
* id : bigint(20) unsigned
* bases_id : int(10) unsigned
* amount : double
* date : datetime
* status : varchar(20)
* days : int(11)
* date_expiration : datetime
* boxplat_id : varchar(128)
* date_upd : datetime
* data : text
* tariff_id : int(10) unsigned
v a04004_magelan payment_refund_idempotency
* id : int(11)
* idempotency_key : varchar(64)
* msut_id : int(11)
* payment_ibox_id : int(11)
* bases_id : int(11)
* request_data : text
* response_data : text
* status : enum('processing','completed','failed')
* error_message : text
* created_at : timestamp
* updated_at : timestamp
* completed_at : timestamp
v a04004_magelan payment_stripe
* id : bigint(20)
* bases_id : bigint(20)
* session : varchar(200)
* status : bigint(20)
* date_create : timestamp
* body : text
v a04004_magelan payment_success
* id : bigint(20) unsigned
* order_id : varchar(50)
* date : datetime
v a04004_magelan payment_types
* id : int(11)
* naim : varchar(50)
* localization_key_name : varchar(100)
* is_del : int(10) unsigned
* dtz : date
* timz : varchar(10)
v a04004_magelan push
* id : bigint(20) unsigned
* base_id : int(10) unsigned
* dtz : date
* timz : varchar(10)
* status : int(10) unsigned
* type : int(10) unsigned
* method : varchar(10)
* PID : int(10) unsigned
v a04004_magelan ref_nalog
* id : int(10) unsigned
* nalog_name : varchar(100)
* localization_key : varchar(100)
v a04004_magelan report_api_keys
* id : int(10) unsigned
* api_report_public_key : varchar(32)
* api_report_private_key : varchar(32)
* date_expiration : datetime
* date_add : datetime
v a04004_magelan report_history
* id : bigint(20)
* date_create : timestamp
* date_update : timestamp
* requests_id : int(10) unsigned
* bases_id : int(10) unsigned
v a04004_magelan repository
* id : int(10) unsigned
* date : datetime
* log : longtext
* release : tinyint(3) unsigned
v a04004_magelan service_stack
* id : bigint(20) unsigned
* body : text
* bases_id : int(10) unsigned
* sdate : timestamp
* is_del : tinyint(1)
* response : text
v a04004_magelan sql_res_log
* id : bigint(20) unsigned
* bases_id : int(11)
* cnt : int(11)
* data : text
v a04004_magelan stack
* id : int(10) unsigned
* body : text
* date : datetime
* version : int(10) unsigned
v a04004_magelan tariff
* id : int(10) unsigned
* name : varchar(300)
* group_id : int(11)
* date_create : timestamp
* date_update : timestamp
* date_until : timestamp
* amount : double
* amount_usd : float
* amount_monthly : decimal(10,2)
* amount_quarterly : decimal(10,2)
* amount_semi_annual : decimal(10,2)
* amount_annual : decimal(10,2)
* currency_code : varchar(3)
v a04004_magelan tariff_acl_base
* id : int(10) unsigned
* tariff_acl_resource_id : int(10) unsigned
* tariff_id : int(10) unsigned
* value : varchar(50)
* value_per_unit : varchar(50)
v a04004_magelan tariff_acl_resource
* id : int(10) unsigned
* acl_resource_name : varchar(255)
* descr : varchar(4000)
* date_update : datetime
* date_create : timestamp
* status : int(11)
v a04004_magelan tariff_acl_value
* id : int(10) unsigned
* bases_id : int(10) unsigned
* tariff_acl_resource_id : int(10) unsigned
* value : varchar(50)
* date_update : timestamp
* date_start : timestamp
* date_until : timestamp
v a04004_magelan tariff_country_price
* id : int(10) unsigned
* country_code : varchar(2)
* currency_code : varchar(10)
* tariff_id : int(10) unsigned
* amount : double
* amount12 : double
* date_create : timestamp
* date_update : timestamp
v a04004_magelan tariff_periods
* id : int(10) unsigned
* tariff_id : int(10) unsigned
* period_type : enum('monthly','quarterly','semi_annual','annual','custom')
* period_months : int(3) unsigned
* period_name : varchar(100)
* amount : decimal(10,2)
* currency_code : varchar(3)
* discount_percentage : decimal(5,2)
* is_active : tinyint(1)
* sort_order : int(3) unsigned
* date_create : timestamp
* date_update : timestamp
v a04004_magelan tariff_resource_country_price
* id : int(10) unsigned
* country_code : varchar(2)
* tariff_acl_resource_id : int(10) unsigned
* tariff_id : int(10) unsigned
* additional_price : double
* date_create : timestamp
* date_update : timestamp
v a04004_magelan test
* id : int(11)
* name : varchar(100)
v a04004_magelan timezone
* zone_id : int(11)
* abbreviation : varchar(6)
* time_start : int(11)
* gmt_offset : int(11)
* dst : char(1)
v a04004_magelan user
* user_id : int(10) unsigned
* username : varchar(255)
* email : varchar(255)
* display_name : varchar(100)
* password : varchar(128)
* state : smallint(5) unsigned
* phone : varchar(100)
* phone_country : varchar(2)
* date_start : datetime
* date_expiration : datetime
* locale : varchar(5)
* config_id : bigint(20)
v a04004_magelan users_bases
* id : int(10) unsigned
* users_id : bigint(20) unsigned
* bases_id : int(10) unsigned
* date : datetime
v a04004_magelan user_params
* id : int(10) unsigned
* user_id : int(10) unsigned
* param_name : varchar(50)
* param_value : varchar(100)
* spd_id : int(10) unsigned
* is_del : tinyint(3) unsigned
* date_at : timestamp
v a04004_magelan user_password
* id : bigint(20) unsigned
* user_id : int(10) unsigned
* user_password : varchar(128)
* date_create : timestamp
* date_update : timestamp
v a04004_magelan user_provider
* user_id : int(10) unsigned
* provider_id : varchar(50)
* provider : varchar(255)
v a04004_magelan user_token
* id : bigint(20) unsigned
* users_id : int(10) unsigned
* ticket : varchar(200)
* token : varchar(200)
* expires : datetime
* device_id : varchar(100)
* spd_id : int(10) unsigned
v a04004_magelan yookassa_receipt_processing_queue
* id : bigint(20) unsigned
* base_id : int(10) unsigned
* transaction_id : bigint(20) unsigned
* asc_priority : int(11)
* created_at : datetime
* updated_at : datetime
* start_processing_at : datetime
* processing_started_at : datetime
* processing_ended_at : datetime
* status : tinyint(4)
* processing_attempts_count : int(10) unsigned
v a04004_magelan zone
* zone_id : int(11)
* country_code : char(2)
* zone_name : varchar(35)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship