converter.dvl.to / mysql / a04004_subscribe

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		a04004_subscribe as_sabor
id : int(11)
sgo_id : int(11)
sgor_id : int(11)
sobl_id : int(11)
sgrd_id : int(11)
syifr : int(11)
norg : varchar(255)
pue : int(11)
pind : int(11)
aorg : int(11)
forg : int(11)
rsch : int(11)
korsch : int(11)
otgb : int(11)
gor : int(11)
obl : int(11)
ogrn : int(11)
kpp : int(11)
pri : int(11)
zpvz : int(11)
fax : int(11)
tel : int(11)
fio : int(11)
unn : int(11)
kmf : int(11)
okp : int(11)
dtz : int(11)
uname : int(11)
bname : int(11)
bik : int(11)
pb : int(11)
timz : int(11)
is_del : int(11)
fiob : int(11)
descr : int(11)
external_id : int(11)
passport : int(11)
discount : int(11)
ndsc : int(11)
email : int(11)
birthday : int(11)

v		a04004_subscribe authassignment
itemname : varchar(64)
userid : varchar(64)
bizrule : text
data : text

v		a04004_subscribe authitem
name : varchar(64)
type : int(11)
description : text
bizrule : text
data : text

v		a04004_subscribe auth_assignment
item_name : varchar(64)
user_id : varchar(64)
created_at : int(11)

v		a04004_subscribe auth_item
name : varchar(64)
type : smallint(6)
description : text
rule_name : varchar(64)
data : blob
created_at : int(11)
updated_at : int(11)

v		a04004_subscribe authitemchild
parent : varchar(64)
child : varchar(64)

v		a04004_subscribe auth_item_child
parent : varchar(64)
child : varchar(64)

v		a04004_subscribe auth_rule
name : varchar(64)
data : blob
created_at : int(11)
updated_at : int(11)

v		a04004_subscribe bases_events
id : int(11)
id_base : int(11)
id_user : int(11)
event : varchar(5)
date : timestamp

v		a04004_subscribe client_report
id : int(11)
created : int(11)
create_user_id : int(11)
date_begin : date
date_end : date
status : int(11)
report_type : int(11)
integrations_1c : int(11)
config_id : int(11)

v		a04004_subscribe client_report_row
id : int(11)
client_report_id : int(11)
base_id : int(11)
data : longtext
status : int(11)

v		a04004_subscribe conditions
id : int(11)
auto : tinyint(4)
name : varchar(255)
alias : varchar(255)
date : timestamp
condition : varchar(255)
id_template : int(11)
comment : tinytext
isNews : tinyint(1)
repeat : tinyint(1)
template_alias : varchar(255)

v		a04004_subscribe 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_subscribe file
id : int(11)
class : varchar(255)
field : varchar(255)
object_id : int(11)
title : varchar(255)
filename : varchar(255)
content_type : varchar(255)
type : int(11)
video_status : int(11)
ordering : int(11)
created : int(11)
user_id : int(11)
size : int(11)
hash : varchar(255)

v		a04004_subscribe localise_log
id : int(11)
created_at : int(11)
created_by : int(11)
type_id : int(11)
endpoint : varchar(255)
response_code : int(11)
response_body : longtext

v		a04004_subscribe login_attempt
id : int(11)
key : varchar(255)
amount : int(11)
reset_at : datetime
created_at : datetime
updated_at : datetime

v		a04004_subscribe migration
version : varchar(180)
apply_time : int(11)

v		a04004_subscribe profiles_fields
id : int(11)
varname : varchar(50)
title : varchar(255)
field_type : varchar(50)
field_size : int(11)
field_size_min : int(11)
required : int(11)
match : varchar(255)
range : varchar(255)
error_message : varchar(255)
other_validator : text
default : varchar(255)
widget : varchar(255)
widgetparams : text
position : int(11)
visible : int(11)

v		a04004_subscribe mailing
id : int(11)
status : int(11)
title : varchar(255)
content : text
created : int(11)
updated : int(11)
send : int(11)
type_id : int(11)
template_id : int(11)
create_user_id : int(11)
update_user_id : int(11)

v		a04004_subscribe mailing_client
id : int(11)
mailing_id : int(11)
client_id : int(11)
status : int(11)

v		a04004_subscribe mails_stack
id : int(11)
email_to : varchar(255)
name_to : varchar(255)
email_from : varchar(255)
name_from : varchar(255)
subject : varchar(255)
body : longtext
time : timestamp
charset : varchar(10)
priority : int(11)

v		a04004_subscribe mail_configurations
id : int(10) unsigned
site_name : varchar(100)
site_mail : varchar(100)

v		a04004_subscribe mail_view
id : int(11)
mailing_id : int(11)
hash : varchar(255)

v		a04004_subscribe 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_subscribe 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_subscribe 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_subscribe 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_subscribe 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)

SQL upload ( 0 ) x -

v		a04004_subscribe order_payment_sender
id : bigint(20) unsigned
payment_ibox_id : bigint(20) unsigned
date_at : timestamp

v		a04004_subscribe preset_base
id : int(11)
preset_id : int(11)
base_id : int(11)

v		a04004_subscribe profiles
user_id : int(11)
first_name : varchar(255)
last_name : varchar(255)

v		a04004_subscribe report_preset
id : int(11)
title : varchar(255)
create_user_id : int(11)
created : int(11)

v		a04004_subscribe sent_emails
id : int(11)
id_user : int(11)
id_base : int(11)
id_condition : int(11)
date : timestamp
subject : varchar(255)
body : text
initiator : int(11)
result : int(11)
data : text
email : varchar(255)

v		a04004_subscribe site_options
id : int(11)
name : varchar(255)
alias : varchar(255)
value : varchar(255)

v		a04004_subscribe snapshot
id : int(11)
timestamp : int(11)
usersTotal : int(11)
usersActive : int(11)
baseNew : int(11)
notProlong : int(11)
eshops : int(10) unsigned

v		a04004_subscribe subscribe_status
id : int(11)
id_user : int(11)
id_base : int(11)
stopNextNews : tinyint(1)
stopNextEvents : tinyint(1)
stopForeverNews : tinyint(1)
stopForeverEvents : tinyint(1)
unsubscribe_hash : varchar(32)
email : varchar(255)

v		a04004_subscribe system_users
id : int(11)
username : varchar(255)
auth_key : varchar(32)
password_hash : varchar(255)
password_reset_token : varchar(255)
email : varchar(255)
status : smallint(6)
created_at : int(11)
updated_at : int(11)
last_login : int(11)

v		a04004_subscribe templates
id : int(11)
name : varchar(255)
alias : varchar(255)
subject : varchar(255)
text : text
comment : text
template_group_id : int(11)
locale : varchar(255)
config_id : int(11)