converter.dvl.to / mysql / mgn5_1786096556

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

v		mgn5_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 as_sgor
id : bigint(10)
naim : varchar(40)
pr5 : int(3)
dtz : date
timz : varchar(10)
is_del : int(11)

v		mgn5_1786096556 as_sgrg
id : bigint(10)
naim : varchar(30)
dtz : date
timz : varchar(10)
is_del : int(11)

v		mgn5_1786096556 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_1786096556 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_1786096556 as_spd
id : int(10) unsigned
naim : varchar(200)
device_id : varchar(100)
device_model : text
is_available : int(10)
is_del : int(10) unsigned
dtz : date
timz : varchar(10)
spz_id : bigint(10) unsigned
device_address : varchar(200)
device_type : int(10)
device_subtype : int(11)
version : varchar(200)
push_token : varchar(1000)
provider : varchar(200)
app : varchar(256)
device_role : int(11)

v		mgn5_1786096556 as_spd_history
uid : int(10) unsigned
id : int(10) unsigned
date_insert : datetime
date_close : datetime
susers_id : bigint(10) unsigned
naim : varchar(200)
device_id : varchar(100)
device_model : text
is_available : int(10)
is_del : int(10) unsigned
dtz : date
timz : varchar(10)
spz_id : bigint(10) unsigned
device_address : varchar(200)
device_type : int(10)
device_subtype : int(11)
version : varchar(200)
push_token : varchar(1000)
provider : varchar(200)
app : varchar(256)
device_role : int(11)

v		mgn5_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 clients_trigger
sabor_id : bigint(10)
date_last_visit : datetime
count_operation : int(10)
average_value : double
total : double

v		mgn5_1786096556 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_1786096556 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_1786096556 data_table_user_config
susers_id : bigint(10)
action : varchar(255)
body : longtext
dtz : date
timz : varchar(10)

v		mgn5_1786096556 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_1786096556 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_1786096556 device_favorite_product
id : bigint(20) unsigned
spd_id : int(10) unsigned
snon_id : bigint(20)
position : int(10) unsigned
spz_id : bigint(20)

SQL upload ( 0 ) x -

v		mgn5_1786096556 eshop_analytics_data
id : bigint(20)
is_active : tinyint(4)
eshop_id : bigint(20) unsigned
analytics_header : text
analytics_footer : text
created_at : timestamp
updated_at : timestamp

v		mgn5_1786096556 eshop_analytics_data_v1
id : bigint(20)
is_active : tinyint(4)
eshop_id : bigint(20) unsigned
analytics_header : text
analytics_footer : text
created_at : timestamp
updated_at : timestamp

v		mgn5_1786096556 eshop_cart
id : bigint(20) unsigned
eshop_id : bigint(20) unsigned
user_id : bigint(20) unsigned
pay_type : int(11)
delivery_type : int(11)
step : int(11)
client_email : varchar(250)
client_name : varchar(255)
created_at : timestamp
status : int(11)
description : text
client_comment : text
order_id : int(10) unsigned
ext_data : text
delivery_address : varchar(1000)
phone : varchar(32)
phone_country : varchar(2)
delivery_method_id : int(11)
msut_id : bigint(10)
requisites : varchar(8000)

v		mgn5_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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_1786096556 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)