columns_priv

Table comments: Column privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(255)	No
Db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
User (Primary)	char(32)	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

component

Table comments: Components

Column	Type	Null	Default	Links to	Comments	MIME
component_id (Primary)	int	No
component_group_id	int	No
component_urn	text	No

Indexes

db

Table comments: Database privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(255)	No
Db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
User (Primary)	char(32)	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

Indexes

default_roles

Table comments: Default roles

Column	Type	Null	Default	Links to	Comments	MIME
HOST (Primary)	char(255)	No
USER (Primary)	char(32)	No
DEFAULT_ROLE_HOST (Primary)	char(255)	No	%
DEFAULT_ROLE_USER (Primary)	char(32)	No

Indexes

engine_cost

Column	Type	Null	Default	Links to	Comments	MIME
engine_name (Primary)	varchar(64)	No
device_type (Primary)	int	No
cost_name (Primary)	varchar(64)	No
cost_value	float	Yes	NULL
last_update	timestamp	No	CURRENT_TIMESTAMP
comment	varchar(1024)	Yes	NULL
default_value	float	Yes	NULL

Indexes

func

Table comments: User defined functions

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

Indexes

general_log

Table comments: General log

Column	Type	Null	Default	Links to	Comments	MIME
event_time	timestamp(6)	No	CURRENT_TIMESTAMP(6)
user_host	mediumtext	No
thread_id	bigint	No
server_id	int	No
command_type	varchar(64)	No
argument	mediumblob	No

global_grants

Table comments: Extended global grants

Column	Type	Null	Default	Links to	Comments	MIME
USER (Primary)	char(32)	No
HOST (Primary)	char(255)	No
PRIV (Primary)	char(32)	No
WITH_GRANT_OPTION	enum('N', 'Y')	No	N

Indexes

gtid_executed

Column	Type	Null	Default	Links to	Comments	MIME
source_uuid (Primary)	char(36)	No			uuid of the source where the transaction was originally executed.
interval_start (Primary)	bigint	No			First number of interval.
interval_end	bigint	No			Last number of interval.

Indexes

help_category

Table comments: help categories

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

Indexes

help_keyword

Table comments: help keywords

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

Indexes

help_relation

Table comments: keyword-topic relation

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

Indexes

help_topic

Table comments: help topics

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

Indexes

innodb_index_stats

Column	Type	Null	Default	Links to	Comments	MIME
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	No
sample_size	bigint	Yes	NULL
stat_description	varchar(1024)	No

Indexes

innodb_table_stats

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

Indexes

password_history

Table comments: Password history for user accounts

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(255)	No
User (Primary)	char(32)	No
Password_timestamp (Primary)	timestamp(6)	No	CURRENT_TIMESTAMP(6)
Password	text	Yes	NULL

Indexes

plugin

Table comments: MySQL plugins

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

Indexes

procs_priv

Table comments: Procedure privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(255)	No
Db (Primary)	char(64)	No
User (Primary)	char(32)	No
Routine_name (Primary)	char(64)	No
Routine_type (Primary)	enum('FUNCTION', 'PROCEDURE')	No
Grantor	varchar(288)	No
Proc_priv	set('Execute', 'Alter Routine', 'Grant')	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP

Indexes

proxies_priv

Table comments: User proxy privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(255)	No
User (Primary)	char(32)	No
Proxied_host (Primary)	char(255)	No
Proxied_user (Primary)	char(32)	No
With_grant	tinyint(1)	No	0
Grantor	varchar(288)	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP

Indexes

role_edges

Table comments: Role hierarchy and role grants

Column	Type	Null	Default	Links to	Comments	MIME
FROM_HOST (Primary)	char(255)	No
FROM_USER (Primary)	char(32)	No
TO_HOST (Primary)	char(255)	No
TO_USER (Primary)	char(32)	No
WITH_ADMIN_OPTION	enum('N', 'Y')	No	N

Indexes

servers

Table comments: MySQL Foreign Servers table

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

Indexes

server_cost

Column	Type	Null	Default	Links to	Comments	MIME
cost_name (Primary)	varchar(64)	No
cost_value	float	Yes	NULL
last_update	timestamp	No	CURRENT_TIMESTAMP
comment	varchar(1024)	Yes	NULL
default_value	float	Yes	NULL

Indexes

slave_master_info

Table comments: Master Information

Column	Type	Null	Default	Links to	Comments	MIME
Number_of_lines	int	No			Number of lines in the file.
Master_log_name	text	No			The name of the master binary log currently being read from the master.
Master_log_pos	bigint	No			The master log position of the last read event.
Host	char(255)	Yes	NULL		The host name of the master.
User_name	text	Yes	NULL		The user name used to connect to the master.
User_password	text	Yes	NULL		The password used to connect to the master.
Port	int	No			The network port used to connect to the master.
Connect_retry	int	No			The period (in seconds) that the slave will wait before trying to reconnect to the master.
Enabled_ssl	tinyint(1)	No			Indicates whether the server supports SSL connections.
Ssl_ca	text	Yes	NULL		The file used for the Certificate Authority (CA) certificate.
Ssl_capath	text	Yes	NULL		The path to the Certificate Authority (CA) certificates.
Ssl_cert	text	Yes	NULL		The name of the SSL certificate file.
Ssl_cipher	text	Yes	NULL		The name of the cipher in use for the SSL connection.
Ssl_key	text	Yes	NULL		The name of the SSL key file.
Ssl_verify_server_cert	tinyint(1)	No			Whether to verify the server certificate.
Heartbeat	float	No
Bind	text	Yes	NULL		Displays which interface is employed when connecting to the MySQL server
Ignored_server_ids	text	Yes	NULL		The number of server IDs to be ignored, followed by the actual server IDs
Uuid	text	Yes	NULL		The master server uuid.
Retry_count	bigint	No			Number of reconnect attempts, to the master, before giving up.
Ssl_crl	text	Yes	NULL		The file used for the Certificate Revocation List (CRL)
Ssl_crlpath	text	Yes	NULL		The path used for Certificate Revocation List (CRL) files
Enabled_auto_position	tinyint(1)	No			Indicates whether GTIDs will be used to retrieve events from the master.
Channel_name (Primary)	char(64)	No			The channel on which the slave is connected to a source. Used in Multisource Replication
Tls_version	text	Yes	NULL		Tls version
Public_key_path	text	Yes	NULL		The file containing public key of master server.
Get_public_key	tinyint(1)	No			Preference to get public key from master.
Network_namespace	text	Yes	NULL		Network namespace used for communication with the master server.
Master_compression_algorithm	char(64)	No			Compression algorithm supported for data transfer between master and slave.
Master_zstd_compression_level	int	No			Compression level associated with zstd compression algorithm.
Tls_ciphersuites	text	Yes	NULL		Ciphersuites used for TLS 1.3 communication with the master server.

Indexes

slave_relay_log_info

Table comments: Relay Log Information

Column	Type	Null	Default	Links to	Comments	MIME
Number_of_lines	int	No			Number of lines in the file or rows in the table. Used to version table definitions.
Relay_log_name	text	Yes	NULL		The name of the current relay log file.
Relay_log_pos	bigint	Yes	NULL		The relay log position of the last executed event.
Master_log_name	text	Yes	NULL		The name of the master binary log file from which the events in the relay log file were read.
Master_log_pos	bigint	Yes	NULL		The master log position of the last executed event.
Sql_delay	int	Yes	NULL		The number of seconds that the slave must lag behind the master.
Number_of_workers	int	Yes	NULL
Id	int	Yes	NULL		Internal Id that uniquely identifies this record.
Channel_name (Primary)	char(64)	No			The channel on which the slave is connected to a source. Used in Multisource Replication
Privilege_checks_username	char(32)	Yes	NULL		Username part of PRIVILEGE_CHECKS_USER.
Privilege_checks_hostname	char(255)	Yes	NULL		Hostname part of PRIVILEGE_CHECKS_USER.
Require_row_format	tinyint(1)	No			Indicates whether the channel shall only accept row based events.

Indexes

slave_worker_info

Table comments: Worker Information

Column	Type	Null	Default	Links to	Comments	MIME
Id (Primary)	int	No
Relay_log_name	text	No
Relay_log_pos	bigint	No
Master_log_name	text	No
Master_log_pos	bigint	No
Checkpoint_relay_log_name	text	No
Checkpoint_relay_log_pos	bigint	No
Checkpoint_master_log_name	text	No
Checkpoint_master_log_pos	bigint	No
Checkpoint_seqno	int	No
Checkpoint_group_size	int	No
Checkpoint_group_bitmap	blob	No
Channel_name (Primary)	char(64)	No			The channel on which the slave is connected to a source. Used in Multisource Replication

Indexes

slow_log

Table comments: Slow log

Column	Type	Null	Default	Links to	Comments	MIME
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	No
rows_examined	int	No
db	varchar(512)	No		SCHEMATA -> SCHEMA_NAME
last_insert_id	int	No
insert_id	int	No
server_id	int	No
sql_text	mediumblob	No
thread_id	bigint	No

tables_priv

Table comments: Table privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(255)	No
Db (Primary)	char(64)	No		SCHEMATA -> SCHEMA_NAME
User (Primary)	char(32)	No
Table_name (Primary)	char(64)	No
Grantor	varchar(288)	No
Timestamp	timestamp	No	CURRENT_TIMESTAMP
Table_priv	set('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger')	No
Column_priv	set('Select', 'Insert', 'Update', 'References')	No

Indexes

time_zone

Table comments: Time zones

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

Indexes

time_zone_leap_second

Table comments: Leap seconds information for time zones

Column	Type	Null	Default	Links to	Comments	MIME
Transition_time (Primary)	bigint	No
Correction	int	No

Indexes

time_zone_name

Table comments: Time zone names

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

Indexes

time_zone_transition

Table comments: Time zone transitions

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

Indexes

time_zone_transition_type

Table comments: Time zone transition types

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

Indexes

user

Table comments: Users and global privileges

Column	Type	Null	Default	Links to	Comments	MIME
Host (Primary)	char(255)	No
User (Primary)	char(32)	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
Reload_priv	enum('N', 'Y')	No	N
Shutdown_priv	enum('N', 'Y')	No	N
Process_priv	enum('N', 'Y')	No	N
File_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
Show_db_priv	enum('N', 'Y')	No	N
Super_priv	enum('N', 'Y')	No	N
Create_tmp_table_priv	enum('N', 'Y')	No	N
Lock_tables_priv	enum('N', 'Y')	No	N
Execute_priv	enum('N', 'Y')	No	N
Repl_slave_priv	enum('N', 'Y')	No	N
Repl_client_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
Create_user_priv	enum('N', 'Y')	No	N
Event_priv	enum('N', 'Y')	No	N
Trigger_priv	enum('N', 'Y')	No	N
Create_tablespace_priv	enum('N', 'Y')	No	N
ssl_type	enum('', 'ANY', 'X509', 'SPECIFIED')	No
ssl_cipher	blob	No
x509_issuer	blob	No
x509_subject	blob	No
max_questions	int	No	0
max_updates	int	No	0
max_connections	int	No	0
max_user_connections	int	No	0
plugin	char(64)	No	caching_sha2_password
authentication_string	text	Yes	NULL
password_expired	enum('N', 'Y')	No	N
password_last_changed	timestamp	Yes	NULL
password_lifetime	smallint	Yes	NULL
account_locked	enum('N', 'Y')	No	N
Create_role_priv	enum('N', 'Y')	No	N
Drop_role_priv	enum('N', 'Y')	No	N
Password_reuse_history	smallint	Yes	NULL
Password_reuse_time	smallint	Yes	NULL
Password_require_current	enum('N', 'Y')	Yes	NULL
User_attributes	json	Yes	NULL

Indexes