column_stats

表注释: Statistics on Columns

字段类型默认 链接到 注释 MIME
db_name (主键)varchar(64)
table_name (主键)varchar(64)
column_name (主键)varchar(64)
min_valuevarchar(255)NULL
max_valuevarchar(255)NULL
nulls_ratiodecimal(12,4)NULL
avg_lengthdecimal(12,4)NULL
avg_frequencydecimal(12,4)NULL
hist_sizetinyint(3)NULL
hist_typeenum('SINGLE_PREC_HB', 'DOUBLE_PREC_HB')NULL
histogramvarbinary(255)NULL

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEdb_nameA
table_nameA
column_name0A

columns_priv

表注释: Column privileges

字段类型默认 链接到 注释 MIME
Host (主键)char(60)
Db (主键)char(64) SCHEMATA -> SCHEMA_NAME
User (主键)char(80)
Table_name (主键)char(64)
Column_name (主键)char(64)
TimestamptimestampCURRENT_TIMESTAMP
Column_privset('Select', 'Insert', 'Update', 'References')

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEHost1A
Db1A
User1A
Table_name1A
Column_name1A

db

表注释: Database privileges

字段类型默认 链接到 注释 MIME
Host (主键)char(60)
Db (主键)char(64) SCHEMATA -> SCHEMA_NAME
User (主键)char(80)
Select_privenum('N', 'Y')N
Insert_privenum('N', 'Y')N
Update_privenum('N', 'Y')N
Delete_privenum('N', 'Y')N
Create_privenum('N', 'Y')N
Drop_privenum('N', 'Y')N
Grant_privenum('N', 'Y')N
References_privenum('N', 'Y')N
Index_privenum('N', 'Y')N
Alter_privenum('N', 'Y')N
Create_tmp_table_privenum('N', 'Y')N
Lock_tables_privenum('N', 'Y')N
Create_view_privenum('N', 'Y')N
Show_view_privenum('N', 'Y')N
Create_routine_privenum('N', 'Y')N
Alter_routine_privenum('N', 'Y')N
Execute_privenum('N', 'Y')N
Event_privenum('N', 'Y')N
Trigger_privenum('N', 'Y')N

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEHost4A
Db4A
User4A
UserBTREEUser4A

event

表注释: Events

字段类型默认 链接到 注释 MIME
db (主键)char(64) SCHEMATA -> SCHEMA_NAME
name (主键)char(64)
bodylongblob
definerchar(141)
execute_atdatetimeNULL
interval_valueint(11)NULL
interval_fieldenum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')NULL
createdtimestampCURRENT_TIMESTAMP
modifiedtimestamp0000-00-00 00:00:00
last_executeddatetimeNULL
startsdatetimeNULL
endsdatetimeNULL
statusenum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')ENABLED
on_completionenum('DROP', 'PRESERVE')DROP
sql_modeset('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')
commentchar(64)
originatorint(10)
time_zonechar(64)SYSTEM
character_set_clientchar(32)NULL CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connectionchar(32)NULL COLLATIONS -> COLLATION_NAME
db_collationchar(32)NULL COLLATIONS -> COLLATION_NAME
body_utf8longblobNULL

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEdbA
name0A

func

表注释: User defined functions

字段类型默认 链接到 注释 MIME
name (主键)char(64)
rettinyint(1)0
dlchar(128)
typeenum('function', 'aggregate')

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEname0A

general_log

表注释: General log

字段类型默认 链接到 注释 MIME
event_timetimestamp(6)CURRENT_TIMESTAMP(6)
user_hostmediumtext
thread_idbigint(21)
server_idint(10)
command_typevarchar(64)
argumentmediumtext

gtid_slave_pos

表注释: Replication slave GTID position

字段类型默认 链接到 注释 MIME
domain_id (主键)int(10)
sub_id (主键)bigint(20)
server_idint(10)
seq_nobigint(20)

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEdomain_id0A
sub_id0A

help_category

表注释: help categories

字段类型默认 链接到 注释 MIME
help_category_id (主键)smallint(5)
namechar(64)
parent_category_idsmallint(5)NULL help_category -> help_category_id
urltext

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEhelp_category_id39A
nameBTREEname39A

help_keyword

表注释: help keywords

字段类型默认 链接到 注释 MIME
help_keyword_id (主键)int(10)
namechar(64)

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEhelp_keyword_id464A
nameBTREEname464A

help_relation

表注释: keyword-topic relation

字段类型默认 链接到 注释 MIME
help_topic_id (主键)int(10) help_topic -> help_topic_id
help_keyword_id (主键)int(10) help_keyword -> help_keyword_id

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEhelp_keyword_idA
help_topic_id1028A

help_topic

表注释: help topics

字段类型默认 链接到 注释 MIME
help_topic_id (主键)int(10)
namechar(64)
help_category_idsmallint(5) help_category -> help_category_id
descriptiontext
exampletext
urltext

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEhelp_topic_id508A
nameBTREEname508A

host

表注释: Host privileges; Merged with database privileges

字段类型默认 链接到 注释 MIME
Host (主键)char(60)
Db (主键)char(64)
Select_privenum('N', 'Y')N
Insert_privenum('N', 'Y')N
Update_privenum('N', 'Y')N
Delete_privenum('N', 'Y')N
Create_privenum('N', 'Y')N
Drop_privenum('N', 'Y')N
Grant_privenum('N', 'Y')N
References_privenum('N', 'Y')N
Index_privenum('N', 'Y')N
Alter_privenum('N', 'Y')N
Create_tmp_table_privenum('N', 'Y')N
Lock_tables_privenum('N', 'Y')N
Create_view_privenum('N', 'Y')N
Show_view_privenum('N', 'Y')N
Create_routine_privenum('N', 'Y')N
Alter_routine_privenum('N', 'Y')N
Execute_privenum('N', 'Y')N
Trigger_privenum('N', 'Y')N

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEHostA
Db0A

index_stats

表注释: Statistics on Indexes

字段类型默认 链接到 注释 MIME
db_name (主键)varchar(64)
table_name (主键)varchar(64)
index_name (主键)varchar(64)
prefix_arity (主键)int(11)
avg_frequencydecimal(12,4)NULL

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEdb_nameA
table_nameA
index_nameA
prefix_arity0A

innodb_index_stats

字段类型默认 链接到 注释 MIME
database_name (主键)varchar(64) SCHEMATA -> SCHEMA_NAME
table_name (主键)varchar(64)
index_name (主键)varchar(64)
last_updatetimestampCURRENT_TIMESTAMP
stat_name (主键)varchar(64)
stat_valuebigint(20)
sample_sizebigint(20)NULL
stat_descriptionvarchar(1024)

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEdatabase_name2A
table_name3129A
index_name6258A
stat_name6258A

innodb_table_stats

字段类型默认 链接到 注释 MIME
database_name (主键)varchar(64) SCHEMATA -> SCHEMA_NAME
table_name (主键)varchar(64)
last_updatetimestampCURRENT_TIMESTAMP
n_rowsbigint(20)
clustered_index_sizebigint(20)
sum_of_other_index_sizesbigint(20)

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEdatabase_name6A
table_name1313A

plugin

表注释: MySQL plugins

字段类型默认 链接到 注释 MIME
name (主键)varchar(64)
dlvarchar(128)

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEname0A

proc

表注释: Stored Procedures

字段类型默认 链接到 注释 MIME
db (主键)char(64) SCHEMATA -> SCHEMA_NAME
name (主键)char(64)
type (主键)enum('FUNCTION', 'PROCEDURE')
specific_namechar(64)
languageenum('SQL')SQL
sql_data_accessenum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')CONTAINS_SQL
is_deterministicenum('YES', 'NO')NO
security_typeenum('INVOKER', 'DEFINER')DEFINER
param_listblob
returnslongblob
bodylongblob
definerchar(141)
createdtimestampCURRENT_TIMESTAMP
modifiedtimestamp0000-00-00 00:00:00
sql_modeset('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'IGNORE_BAD_TABLE_OPTIONS', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')
commenttext
character_set_clientchar(32)NULL CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connectionchar(32)NULL COLLATIONS -> COLLATION_NAME
db_collationchar(32)NULL COLLATIONS -> COLLATION_NAME
body_utf8longblobNULL

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEdbA
nameA
type2A

procs_priv

表注释: Procedure privileges

字段类型默认 链接到 注释 MIME
Host (主键)char(60)
Db (主键)char(64)
User (主键)char(80)
Routine_name (主键)char(64)
Routine_type (主键)enum('FUNCTION', 'PROCEDURE')
Grantorchar(141)
Proc_privset('Execute', 'Alter Routine', 'Grant')
TimestamptimestampCURRENT_TIMESTAMP

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEHost1A
Db1A
User1A
Routine_name1A
Routine_type1A
GrantorBTREEGrantor1A

proxies_priv

表注释: User proxy privileges

字段类型默认 链接到 注释 MIME
Host (主键)char(60)
User (主键)char(80)
Proxied_host (主键)char(60)
Proxied_user (主键)char(80)
With_granttinyint(1)0
Grantorchar(141)
TimestamptimestampCURRENT_TIMESTAMP

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEHostA
UserA
Proxied_hostA
Proxied_user1A
GrantorBTREEGrantor0A

roles_mapping

表注释: Granted roles

字段类型默认 链接到 注释 MIME
Hostchar(60)
Userchar(80)
Rolechar(80)
Admin_optionenum('N', 'Y')N

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
HostBTREEHostA
UserA
Role0A

servers

表注释: MySQL Foreign Servers table

字段类型默认 链接到 注释 MIME
Server_name (主键)char(64)
Hostchar(64)
Dbchar(64) SCHEMATA -> SCHEMA_NAME
Usernamechar(80)
Passwordchar(64)
Portint(4)0
Socketchar(64)
Wrapperchar(64)
Ownerchar(64)

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEServer_name0A

slow_log

表注释: Slow log

字段类型默认 链接到 注释 MIME
start_timetimestamp(6)CURRENT_TIMESTAMP(6)
user_hostmediumtext
query_timetime(6)
lock_timetime(6)
rows_sentint(11)
rows_examinedint(11)
dbvarchar(512) SCHEMATA -> SCHEMA_NAME
last_insert_idint(11)
insert_idint(11)
server_idint(10)
sql_textmediumtext
thread_idbigint(21)
rows_affectedint(11)

table_stats

表注释: Statistics on Tables

字段类型默认 链接到 注释 MIME
db_name (主键)varchar(64)
table_name (主键)varchar(64)
cardinalitybigint(21)NULL

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEdb_nameA
table_name0A

tables_priv

表注释: Table privileges

字段类型默认 链接到 注释 MIME
Host (主键)char(60)
Db (主键)char(64) SCHEMATA -> SCHEMA_NAME
User (主键)char(80)
Table_name (主键)char(64)
Grantorchar(141)
TimestamptimestampCURRENT_TIMESTAMP
Table_privset('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger')
Column_privset('Select', 'Insert', 'Update', 'References')

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEHost1A
Db1A
User1A
Table_name1A
GrantorBTREEGrantor1A

time_zone

表注释: Time zones

字段类型默认 链接到 注释 MIME
Time_zone_id (主键)int(10)
Use_leap_secondsenum('Y', 'N')N

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREETime_zone_id0A

time_zone_leap_second

表注释: Leap seconds information for time zones

字段类型默认 链接到 注释 MIME
Transition_time (主键)bigint(20)
Correctionint(11)

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREETransition_time0A

time_zone_name

表注释: Time zone names

字段类型默认 链接到 注释 MIME
Name (主键)char(64)
Time_zone_idint(10) time_zone -> Time_zone_id

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEName0A

time_zone_transition

表注释: Time zone transitions

字段类型默认 链接到 注释 MIME
Time_zone_id (主键)int(10) time_zone -> Time_zone_id
Transition_time (主键)bigint(20) time_zone_leap_second -> Transition_time
Transition_type_idint(10)

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREETime_zone_idA
Transition_time0A

time_zone_transition_type

表注释: Time zone transition types

字段类型默认 链接到 注释 MIME
Time_zone_id (主键)int(10) time_zone -> Time_zone_id
Transition_type_id (主键)int(10)
Offsetint(11)0
Is_DSTtinyint(3)0
Abbreviationchar(8)

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREETime_zone_idA
Transition_type_id0A

user

表注释: Users and global privileges

字段类型默认 链接到 注释 MIME
Host (主键)char(60)
User (主键)char(80)
Passwordchar(41)
Select_privenum('N', 'Y')N
Insert_privenum('N', 'Y')N
Update_privenum('N', 'Y')N
Delete_privenum('N', 'Y')N
Create_privenum('N', 'Y')N
Drop_privenum('N', 'Y')N
Reload_privenum('N', 'Y')N
Shutdown_privenum('N', 'Y')N
Process_privenum('N', 'Y')N
File_privenum('N', 'Y')N
Grant_privenum('N', 'Y')N
References_privenum('N', 'Y')N
Index_privenum('N', 'Y')N
Alter_privenum('N', 'Y')N
Show_db_privenum('N', 'Y')N
Super_privenum('N', 'Y')N
Create_tmp_table_privenum('N', 'Y')N
Lock_tables_privenum('N', 'Y')N
Execute_privenum('N', 'Y')N
Repl_slave_privenum('N', 'Y')N
Repl_client_privenum('N', 'Y')N
Create_view_privenum('N', 'Y')N
Show_view_privenum('N', 'Y')N
Create_routine_privenum('N', 'Y')N
Alter_routine_privenum('N', 'Y')N
Create_user_privenum('N', 'Y')N
Event_privenum('N', 'Y')N
Trigger_privenum('N', 'Y')N
Create_tablespace_privenum('N', 'Y')N
ssl_typeenum('', 'ANY', 'X509', 'SPECIFIED')
ssl_cipherblob
x509_issuerblob
x509_subjectblob
max_questionsint(11)0
max_updatesint(11)0
max_connectionsint(11)0
max_user_connectionsint(11)0
pluginchar(64)
authentication_stringtext
password_expiredenum('N', 'Y')N
is_roleenum('N', 'Y')N
default_rolechar(80)
max_statement_timedecimal(12,6)0.000000

索引

没有已定义的索引!
键名类型唯一紧凑字段基数排序规则注释
PRIMARYBTREEHostA
User9A