mysql

columns_priv

Table comments: Column privileges

Column Type Null Default Links to Comments Media type
Host (Primary) char(60) No
Db (Primary) char(64) No SCHEMATA -> SCHEMA_NAME
User (Primary) char(80) No
Table_name (Primary) char(64) No
Column_name (Primary) char(64) No
Timestamp timestamp No current_timestamp()
Column_priv set('Select', 'Insert', 'Update', 'References') No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host A No
Db A No
User A No
Table_name A No
Column_name 0 A No

column_stats

Table comments: Statistics on Columns

Column Type Null Default Links to Comments Media type
db_name (Primary) varchar(64) No
table_name (Primary) varchar(64) No
column_name (Primary) varchar(64) No
min_value varbinary(255) Yes NULL
max_value varbinary(255) Yes NULL
nulls_ratio decimal(12,4) Yes NULL
avg_length decimal(12,4) Yes NULL
avg_frequency decimal(12,4) Yes NULL
hist_size tinyint(3) Yes NULL
hist_type enum('SINGLE_PREC_HB', 'DOUBLE_PREC_HB') Yes NULL
histogram varbinary(255) Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No db_name A No
table_name A No
column_name 0 A No

db

Table comments: Database privileges

Column Type Null Default Links to Comments Media type
Host (Primary) char(60) No
Db (Primary) char(64) No SCHEMATA -> SCHEMA_NAME
User (Primary) char(80) No
Select_priv enum('N', 'Y') No N
Insert_priv enum('N', 'Y') No N
Update_priv enum('N', 'Y') No N
Delete_priv enum('N', 'Y') No N
Create_priv enum('N', 'Y') No N
Drop_priv enum('N', 'Y') No N
Grant_priv enum('N', 'Y') No N
References_priv enum('N', 'Y') No N
Index_priv enum('N', 'Y') No N
Alter_priv enum('N', 'Y') No N
Create_tmp_table_priv enum('N', 'Y') No N
Lock_tables_priv enum('N', 'Y') No N
Create_view_priv enum('N', 'Y') No N
Show_view_priv enum('N', 'Y') No N
Create_routine_priv enum('N', 'Y') No N
Alter_routine_priv enum('N', 'Y') No N
Execute_priv enum('N', 'Y') No N
Event_priv enum('N', 'Y') No N
Trigger_priv enum('N', 'Y') No N
Delete_history_priv enum('N', 'Y') No N

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host 4 A No
Db 4 A No
User 4 A No
User BTREE No No User 4 A No

event

Table comments: Events

Column Type Null Default Links to Comments Media type
db (Primary) char(64) No SCHEMATA -> SCHEMA_NAME
name (Primary) char(64) No
body longblob No
definer char(141) No
execute_at datetime Yes NULL
interval_value int(11) Yes NULL
interval_field enum('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') Yes NULL
created timestamp No current_timestamp()
modified timestamp No 0000-00-00 00:00:00
last_executed datetime Yes NULL
starts datetime Yes NULL
ends datetime Yes NULL
status enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED') No ENABLED
on_completion enum('DROP', 'PRESERVE') No DROP
sql_mode set('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', 'EMPTY_STRING_IS_NULL', 'SIMULTANEOUS_ASSIGNMENT', 'TIME_ROUND_FRACTIONAL') No
comment char(64) No
originator int(10) No
time_zone char(64) No SYSTEM
character_set_client char(32) Yes NULL CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connection char(32) Yes NULL COLLATIONS -> COLLATION_NAME
db_collation char(32) Yes NULL COLLATIONS -> COLLATION_NAME
body_utf8 longblob Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No db A No
name 0 A No

func

Table comments: User defined functions

Column Type Null Default Links to Comments Media type
name (Primary) char(64) No
ret tinyint(1) No 0
dl char(128) No
type enum('function', 'aggregate') No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No name 0 A No

general_log

Table comments: General log

Column Type Null Default Links to Comments Media type
event_time timestamp(6) No current_timestamp(6)
user_host mediumtext No
thread_id bigint(21) No
server_id int(10) No
command_type varchar(64) No
argument mediumtext No

No index defined!

global_priv

Table comments: Users and global privileges

Column Type Null Default Links to Comments Media type
Host (Primary) char(60) No
User (Primary) char(80) No
Priv longtext No '{}'

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host A No
User 6 A No

gtid_slave_pos

Table comments: Replication slave GTID position

Column Type Null Default Links to Comments Media type
domain_id (Primary) int(10) No
sub_id (Primary) bigint(20) No
server_id int(10) No
seq_no bigint(20) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No domain_id 0 A No
sub_id 0 A No

help_category

Table comments: help categories

Column Type Null Default Links to Comments Media type
help_category_id (Primary) smallint(5) No
name char(64) No
parent_category_id smallint(5) Yes NULL help_category -> help_category_id
url text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No help_category_id 48 A No
name BTREE Yes No name 48 A No

help_keyword

Table comments: help keywords

Column Type Null Default Links to Comments Media type
help_keyword_id (Primary) int(10) No
name char(64) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No help_keyword_id 37 A No
name BTREE Yes No name 37 A No

help_relation

Table comments: keyword-topic relation

Column Type Null Default Links to Comments Media type
help_topic_id (Primary) int(10) No help_topic -> help_topic_id
help_keyword_id (Primary) int(10) No help_keyword -> help_keyword_id

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No help_keyword_id A No
help_topic_id 114 A No

help_topic

Table comments: help topics

Column Type Null Default Links to Comments Media type
help_topic_id (Primary) int(10) No
name char(64) No
help_category_id smallint(5) No help_category -> help_category_id
description text No
example text No
url text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No help_topic_id 752 A No
name BTREE Yes No name 752 A No

index_stats

Table comments: Statistics on Indexes

Column Type Null Default Links to Comments Media type
db_name (Primary) varchar(64) No
table_name (Primary) varchar(64) No
index_name (Primary) varchar(64) No
prefix_arity (Primary) int(11) No
avg_frequency decimal(12,4) Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No db_name A No
table_name A No
index_name A No
prefix_arity 0 A No

innodb_index_stats

Column Type Null Default Links to Comments Media type
database_name (Primary) varchar(64) No SCHEMATA -> SCHEMA_NAME
table_name (Primary) varchar(199) No
index_name (Primary) varchar(64) No
last_update timestamp No current_timestamp()
stat_name (Primary) varchar(64) No
stat_value bigint(20) No
sample_size bigint(20) Yes NULL
stat_description varchar(1024) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No database_name 18 A No
table_name 173 A No
index_name 347 A No
stat_name 347 A No

innodb_table_stats

Column Type Null Default Links to Comments Media type
database_name (Primary) varchar(64) No SCHEMATA -> SCHEMA_NAME
table_name (Primary) varchar(199) No
last_update timestamp No current_timestamp()
n_rows bigint(20) No
clustered_index_size bigint(20) No
sum_of_other_index_sizes bigint(20) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No database_name 23 A No
table_name 92 A No

plugin

Table comments: MySQL plugins

Column Type Null Default Links to Comments Media type
name (Primary) varchar(64) No
dl varchar(128) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No name 0 A No

proc

Table comments: Stored Procedures

Column Type Null Default Links to Comments Media type
db (Primary) char(64) No SCHEMATA -> SCHEMA_NAME
name (Primary) char(64) No
type (Primary) enum('FUNCTION', 'PROCEDURE', 'PACKAGE', 'PACKAGE BODY') No
specific_name char(64) No
language enum('SQL') No SQL
sql_data_access enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA') No CONTAINS_SQL
is_deterministic enum('YES', 'NO') No NO
security_type enum('INVOKER', 'DEFINER') No DEFINER
param_list blob No
returns longblob No
body longblob No
definer char(141) No
created timestamp No current_timestamp()
modified timestamp No 0000-00-00 00:00:00
sql_mode set('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', 'EMPTY_STRING_IS_NULL', 'SIMULTANEOUS_ASSIGNMENT', 'TIME_ROUND_FRACTIONAL') No
comment text No
character_set_client char(32) Yes NULL CHARACTER_SETS -> CHARACTER_SET_NAME
collation_connection char(32) Yes NULL COLLATIONS -> COLLATION_NAME
db_collation char(32) Yes NULL COLLATIONS -> COLLATION_NAME
body_utf8 longblob Yes NULL
aggregate enum('NONE', 'GROUP') No NONE

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No db A No
name A No
type 0 A No

procs_priv

Table comments: Procedure privileges

Column Type Null Default Links to Comments Media type
Host (Primary) char(60) No
Db (Primary) char(64) No
User (Primary) char(80) No
Routine_name (Primary) char(64) No
Routine_type (Primary) enum('FUNCTION', 'PROCEDURE', 'PACKAGE', 'PACKAGE BODY') No
Grantor char(141) No
Proc_priv set('Execute', 'Alter Routine', 'Grant') No
Timestamp timestamp No current_timestamp()

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host A No
Db A No
User A No
Routine_name A No
Routine_type 0 A No
Grantor BTREE No No Grantor A No

proxies_priv

Table comments: User proxy privileges

Column Type Null Default Links to Comments Media type
Host (Primary) char(60) No
User (Primary) char(80) No
Proxied_host (Primary) char(60) No
Proxied_user (Primary) char(80) No
With_grant tinyint(1) No 0
Grantor char(141) No
Timestamp timestamp No current_timestamp()

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host A No
User A No
Proxied_host A No
Proxied_user 1 A No
Grantor BTREE No No Grantor 1 A No

roles_mapping

Table comments: Granted roles

Column Type Null Default Links to Comments Media type
Host char(60) No
User char(80) No
Role char(80) No
Admin_option enum('N', 'Y') No N

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
Host BTREE Yes No Host A No
User A No
Role 0 A No

servers

Table comments: MySQL Foreign Servers table

Column Type Null Default Links to Comments Media type
Server_name (Primary) char(64) No
Host char(64) No
Db char(64) No SCHEMATA -> SCHEMA_NAME
Username char(80) No
Password char(64) No
Port int(4) No 0
Socket char(64) No
Wrapper char(64) No
Owner char(64) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Server_name 0 A No

slow_log

Table comments: Slow log

Column Type Null Default Links to Comments Media type
start_time timestamp(6) No current_timestamp(6)
user_host mediumtext No
query_time time(6) No
lock_time time(6) No
rows_sent int(11) No
rows_examined int(11) No
db varchar(512) No SCHEMATA -> SCHEMA_NAME
last_insert_id int(11) No
insert_id int(11) No
server_id int(10) No
sql_text mediumtext No
thread_id bigint(21) No
rows_affected int(11) No

No index defined!

tables_priv

Table comments: Table privileges

Column Type Null Default Links to Comments Media type
Host (Primary) char(60) No
Db (Primary) char(64) No SCHEMATA -> SCHEMA_NAME
User (Primary) char(80) No
Table_name (Primary) char(64) No
Grantor char(141) No
Timestamp timestamp No current_timestamp()
Table_priv set('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger', 'Delete versioning rows') No
Column_priv set('Select', 'Insert', 'Update', 'References') No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host A No
Db A No
User A No
Table_name 0 A No
Grantor BTREE No No Grantor A No

table_stats

Table comments: Statistics on Tables

Column Type Null Default Links to Comments Media type
db_name (Primary) varchar(64) No
table_name (Primary) varchar(64) No
cardinality bigint(21) Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No db_name A No
table_name 0 A No

time_zone

Table comments: Time zones

Column Type Null Default Links to Comments Media type
Time_zone_id (Primary) int(10) No
Use_leap_seconds enum('Y', 'N') No N

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Time_zone_id 0 A No

time_zone_leap_second

Table comments: Leap seconds information for time zones

Column Type Null Default Links to Comments Media type
Transition_time (Primary) bigint(20) No
Correction int(11) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Transition_time 0 A No

time_zone_name

Table comments: Time zone names

Column Type Null Default Links to Comments Media type
Name (Primary) char(64) No
Time_zone_id int(10) No time_zone -> Time_zone_id

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Name 0 A No

time_zone_transition

Table comments: Time zone transitions

Column Type Null Default Links to Comments Media type
Time_zone_id (Primary) int(10) No time_zone -> Time_zone_id
Transition_time (Primary) bigint(20) No time_zone_leap_second -> Transition_time
Transition_type_id int(10) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Time_zone_id A No
Transition_time 0 A No

time_zone_transition_type

Table comments: Time zone transition types

Column Type Null Default Links to Comments Media type
Time_zone_id (Primary) int(10) No time_zone -> Time_zone_id
Transition_type_id (Primary) int(10) No
Offset int(11) No 0
Is_DST tinyint(3) No 0
Abbreviation char(8) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Time_zone_id A No
Transition_type_id 0 A No

transaction_registry

Column Type Null Default Links to Comments Media type
transaction_id (Primary) bigint(20) No
commit_id bigint(20) No
begin_timestamp timestamp(6) No 0000-00-00 00:00:00.000000
commit_timestamp timestamp(6) No 0000-00-00 00:00:00.000000
isolation_level enum('READ-UNCOMMITTED', 'READ-COMMITTED', 'REPEATABLE-READ', 'SERIALIZABLE') No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No transaction_id 0 A No
commit_id BTREE Yes No commit_id 0 A No
begin_timestamp BTREE No No begin_timestamp 0 A No
commit_timestamp BTREE No No commit_timestamp 0 A No
transaction_id 0 A No

user

Table comments: VIEW

Column Type Null Default Links to Comments Media type
Host char(60) No
User char(80) No
Password longtext Yes NULL
Select_priv varchar(1) Yes NULL
Insert_priv varchar(1) Yes NULL
Update_priv varchar(1) Yes NULL
Delete_priv varchar(1) Yes NULL
Create_priv varchar(1) Yes NULL
Drop_priv varchar(1) Yes NULL
Reload_priv varchar(1) Yes NULL
Shutdown_priv varchar(1) Yes NULL
Process_priv varchar(1) Yes NULL
File_priv varchar(1) Yes NULL
Grant_priv varchar(1) Yes NULL
References_priv varchar(1) Yes NULL
Index_priv varchar(1) Yes NULL
Alter_priv varchar(1) Yes NULL
Show_db_priv varchar(1) Yes NULL
Super_priv varchar(1) Yes NULL
Create_tmp_table_priv varchar(1) Yes NULL
Lock_tables_priv varchar(1) Yes NULL
Execute_priv varchar(1) Yes NULL
Repl_slave_priv varchar(1) Yes NULL
Repl_client_priv varchar(1) Yes NULL
Create_view_priv varchar(1) Yes NULL
Show_view_priv varchar(1) Yes NULL
Create_routine_priv varchar(1) Yes NULL
Alter_routine_priv varchar(1) Yes NULL
Create_user_priv varchar(1) Yes NULL
Event_priv varchar(1) Yes NULL
Trigger_priv varchar(1) Yes NULL
Create_tablespace_priv varchar(1) Yes NULL
Delete_history_priv varchar(1) Yes NULL
ssl_type varchar(9) Yes NULL
ssl_cipher longtext No
x509_issuer longtext No
x509_subject longtext No
max_questions bigint(20) No 0
max_updates bigint(20) No 0
max_connections bigint(20) No 0
max_user_connections bigint(21) No 0
plugin longtext No
authentication_string longtext No
password_expired varchar(1) No
is_role varchar(1) Yes NULL
default_role longtext No
max_statement_time decimal(12,6) No 0.000000

No index defined!