converter.dvl.to / mysql / mgn4_repro

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		mgn4_repro 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		mgn4_repro as_sabop
id : bigint(10)
sabor_id : bigint(10)
aspar_id : bigint(10)
parc : varchar(50)
parm : text
dtz : date
timz : varchar(10)

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

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

v		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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

v		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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

v		mgn4_repro clients_trigger
sabor_id : bigint(10)
date_last_visit : datetime
count_operation : int(10)
average_value : double
total : double

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

v		mgn4_repro device_events
id : bigint(10) unsigned
event : varchar(20)
body : text
event_date : datetime
susers_id : bigint(10)
spd_id : int(10) unsigned

v		mgn4_repro 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		mgn4_repro 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

SQL upload ( 0 ) x -

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

v		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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		mgn4_repro 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)