Column | Type | Null | Default | Comments |
---|---|---|---|---|
CHARACTER_SET_NAME | varchar(64) | No | ||
DEFAULT_COLLATE_NAME | varchar(64) | No | ||
DESCRIPTION | varchar(2048) | No | ||
MAXLEN | int(10) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CONSTRAINT_CATALOG | varchar(64) | No | ||
CONSTRAINT_SCHEMA | varchar(64) | No | ||
CONSTRAINT_NAME | varchar(64) | No | ||
CHECK_CLAUSE | longtext | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
COLLATION_NAME | varchar(64) | No | ||
CHARACTER_SET_NAME | varchar(64) | No | ||
ID | bigint(20) | No | 0 | |
IS_DEFAULT | varchar(3) | No | ||
IS_COMPILED | varchar(3) | No | ||
SORTLEN | int(10) | No | ||
PAD_ATTRIBUTE | enum('PAD SPACE', 'NO PAD') | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
COLLATION_NAME | varchar(64) | No | ||
CHARACTER_SET_NAME | varchar(64) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_CATALOG | varchar(64) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
COLUMN_NAME | varchar(64) | Yes | NULL | |
ORDINAL_POSITION | int(10) | No | ||
COLUMN_DEFAULT | text | Yes | NULL | |
IS_NULLABLE | varchar(3) | No | ||
DATA_TYPE | longtext | Yes | NULL | |
CHARACTER_MAXIMUM_LENGTH | bigint(21) | Yes | NULL | |
CHARACTER_OCTET_LENGTH | bigint(21) | Yes | NULL | |
NUMERIC_PRECISION | bigint(10) | Yes | NULL | |
NUMERIC_SCALE | bigint(10) | Yes | NULL | |
DATETIME_PRECISION | int(10) | Yes | NULL | |
CHARACTER_SET_NAME | varchar(64) | Yes | NULL | |
COLLATION_NAME | varchar(64) | Yes | NULL | |
COLUMN_TYPE | mediumtext | No | ||
COLUMN_KEY | enum('', 'PRI', 'UNI', 'MUL') | No | ||
EXTRA | varchar(256) | Yes | NULL | |
PRIVILEGES | varchar(154) | Yes | NULL | |
COLUMN_COMMENT | text | No | ||
GENERATION_EXPRESSION | longtext | No | ||
SRS_ID | int(10) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
GRANTEE | varchar(292) | No | ||
TABLE_CATALOG | varchar(512) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
COLUMN_NAME | varchar(64) | No | ||
PRIVILEGE_TYPE | varchar(64) | No | ||
IS_GRANTABLE | varchar(3) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SCHEMA_NAME | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
COLUMN_NAME | varchar(64) | No | ||
HISTOGRAM | json | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ENGINE | varchar(64) | No | ||
SUPPORT | varchar(8) | No | ||
COMMENT | varchar(80) | No | ||
TRANSACTIONS | varchar(3) | Yes | ||
XA | varchar(3) | Yes | ||
SAVEPOINTS | varchar(3) | Yes |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
EVENT_CATALOG | varchar(64) | No | ||
EVENT_SCHEMA | varchar(64) | No | ||
EVENT_NAME | varchar(64) | No | ||
DEFINER | varchar(288) | No | ||
TIME_ZONE | varchar(64) | No | ||
EVENT_BODY | varchar(3) | No | ||
EVENT_DEFINITION | longtext | No | ||
EVENT_TYPE | varchar(9) | No | ||
EXECUTE_AT | datetime | Yes | NULL | |
INTERVAL_VALUE | varchar(256) | 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 | |
SQL_MODE | set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL') | No | ||
STARTS | datetime | Yes | NULL | |
ENDS | datetime | Yes | NULL | |
STATUS | enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED') | No | ||
ON_COMPLETION | varchar(12) | No | ||
CREATED | timestamp | No | ||
LAST_ALTERED | timestamp | No | ||
LAST_EXECUTED | datetime | Yes | NULL | |
EVENT_COMMENT | varchar(2048) | No | ||
ORIGINATOR | int(10) | No | ||
CHARACTER_SET_CLIENT | varchar(64) | No | ||
COLLATION_CONNECTION | varchar(64) | No | ||
DATABASE_COLLATION | varchar(64) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
FILE_ID | bigint(21) | Yes | NULL | |
FILE_NAME | text | Yes | NULL | |
FILE_TYPE | varchar(256) | Yes | NULL | |
TABLESPACE_NAME | varchar(268) | No | ||
TABLE_CATALOG | char(0) | No | ||
TABLE_SCHEMA | binary(0) | Yes | NULL | |
TABLE_NAME | binary(0) | Yes | NULL | |
LOGFILE_GROUP_NAME | varchar(256) | Yes | NULL | |
LOGFILE_GROUP_NUMBER | bigint(21) | Yes | NULL | |
ENGINE | varchar(64) | No | ||
FULLTEXT_KEYS | binary(0) | Yes | NULL | |
DELETED_ROWS | binary(0) | Yes | NULL | |
UPDATE_COUNT | binary(0) | Yes | NULL | |
FREE_EXTENTS | bigint(21) | Yes | NULL | |
TOTAL_EXTENTS | bigint(21) | Yes | NULL | |
EXTENT_SIZE | bigint(21) | Yes | NULL | |
INITIAL_SIZE | bigint(21) | Yes | NULL | |
MAXIMUM_SIZE | bigint(21) | Yes | NULL | |
AUTOEXTEND_SIZE | bigint(21) | Yes | NULL | |
CREATION_TIME | binary(0) | Yes | NULL | |
LAST_UPDATE_TIME | binary(0) | Yes | NULL | |
LAST_ACCESS_TIME | binary(0) | Yes | NULL | |
RECOVER_TIME | binary(0) | Yes | NULL | |
TRANSACTION_COUNTER | binary(0) | Yes | NULL | |
VERSION | bigint(21) | Yes | NULL | |
ROW_FORMAT | varchar(256) | Yes | NULL | |
TABLE_ROWS | binary(0) | Yes | NULL | |
AVG_ROW_LENGTH | binary(0) | Yes | NULL | |
DATA_LENGTH | binary(0) | Yes | NULL | |
MAX_DATA_LENGTH | binary(0) | Yes | NULL | |
INDEX_LENGTH | binary(0) | Yes | NULL | |
DATA_FREE | bigint(21) | Yes | NULL | |
CREATE_TIME | binary(0) | Yes | NULL | |
UPDATE_TIME | binary(0) | Yes | NULL | |
CHECK_TIME | binary(0) | Yes | NULL | |
CHECKSUM | binary(0) | Yes | NULL | |
STATUS | varchar(256) | Yes | NULL | |
EXTRA | varchar(256) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
POOL_ID | bigint(21) | No | ||
BLOCK_ID | bigint(21) | No | ||
SPACE | bigint(21) | No | ||
PAGE_NUMBER | bigint(21) | No | ||
PAGE_TYPE | varchar(64) | Yes | ||
FLUSH_TYPE | bigint(21) | No | ||
FIX_COUNT | bigint(21) | No | ||
IS_HASHED | varchar(3) | Yes | ||
NEWEST_MODIFICATION | bigint(21) | No | ||
OLDEST_MODIFICATION | bigint(21) | No | ||
ACCESS_TIME | bigint(21) | No | ||
TABLE_NAME | varchar(1024) | Yes | ||
INDEX_NAME | varchar(1024) | Yes | ||
NUMBER_RECORDS | bigint(21) | No | ||
DATA_SIZE | bigint(21) | No | ||
COMPRESSED_SIZE | bigint(21) | No | ||
PAGE_STATE | varchar(64) | Yes | ||
IO_FIX | varchar(64) | Yes | ||
IS_OLD | varchar(3) | Yes | ||
FREE_PAGE_CLOCK | bigint(21) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
POOL_ID | bigint(21) | No | ||
LRU_POSITION | bigint(21) | No | ||
SPACE | bigint(21) | No | ||
PAGE_NUMBER | bigint(21) | No | ||
PAGE_TYPE | varchar(64) | Yes | ||
FLUSH_TYPE | bigint(21) | No | ||
FIX_COUNT | bigint(21) | No | ||
IS_HASHED | varchar(3) | Yes | ||
NEWEST_MODIFICATION | bigint(21) | No | ||
OLDEST_MODIFICATION | bigint(21) | No | ||
ACCESS_TIME | bigint(21) | No | ||
TABLE_NAME | varchar(1024) | Yes | ||
INDEX_NAME | varchar(1024) | Yes | ||
NUMBER_RECORDS | bigint(21) | No | ||
DATA_SIZE | bigint(21) | No | ||
COMPRESSED_SIZE | bigint(21) | No | ||
COMPRESSED | varchar(3) | Yes | ||
IO_FIX | varchar(64) | Yes | ||
IS_OLD | varchar(3) | Yes | ||
FREE_PAGE_CLOCK | bigint(21) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
POOL_ID | bigint(21) | No | ||
POOL_SIZE | bigint(21) | No | ||
FREE_BUFFERS | bigint(21) | No | ||
DATABASE_PAGES | bigint(21) | No | ||
OLD_DATABASE_PAGES | bigint(21) | No | ||
MODIFIED_DATABASE_PAGES | bigint(21) | No | ||
PENDING_DECOMPRESS | bigint(21) | No | ||
PENDING_READS | bigint(21) | No | ||
PENDING_FLUSH_LRU | bigint(21) | No | ||
PENDING_FLUSH_LIST | bigint(21) | No | ||
PAGES_MADE_YOUNG | bigint(21) | No | ||
PAGES_NOT_MADE_YOUNG | bigint(21) | No | ||
PAGES_MADE_YOUNG_RATE | float(12,0) | No | ||
PAGES_MADE_NOT_YOUNG_RATE | float(12,0) | No | ||
NUMBER_PAGES_READ | bigint(21) | No | ||
NUMBER_PAGES_CREATED | bigint(21) | No | ||
NUMBER_PAGES_WRITTEN | bigint(21) | No | ||
PAGES_READ_RATE | float(12,0) | No | ||
PAGES_CREATE_RATE | float(12,0) | No | ||
PAGES_WRITTEN_RATE | float(12,0) | No | ||
NUMBER_PAGES_GET | bigint(21) | No | ||
HIT_RATE | bigint(21) | No | ||
YOUNG_MAKE_PER_THOUSAND_GETS | bigint(21) | No | ||
NOT_YOUNG_MAKE_PER_THOUSAND_GETS | bigint(21) | No | ||
NUMBER_PAGES_READ_AHEAD | bigint(21) | No | ||
NUMBER_READ_AHEAD_EVICTED | bigint(21) | No | ||
READ_AHEAD_RATE | float(12,0) | No | ||
READ_AHEAD_EVICTED_RATE | float(12,0) | No | ||
LRU_IO_TOTAL | bigint(21) | No | ||
LRU_IO_CURRENT | bigint(21) | No | ||
UNCOMPRESS_TOTAL | bigint(21) | No | ||
UNCOMPRESS_CURRENT | bigint(21) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SPACE_ID | int(11) | No | ||
INDEX_ID | bigint(21) | No | ||
N_CACHED_PAGES | bigint(21) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
page_size | int(5) | No | ||
compress_ops | int(11) | No | ||
compress_ops_ok | int(11) | No | ||
compress_time | int(11) | No | ||
uncompress_ops | int(11) | No | ||
uncompress_time | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
page_size | int(5) | No | ||
buffer_pool_instance | int(11) | No | ||
pages_used | int(11) | No | ||
pages_free | int(11) | No | ||
relocation_ops | bigint(21) | No | ||
relocation_time | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
page_size | int(5) | No | ||
buffer_pool_instance | int(11) | No | ||
pages_used | int(11) | No | ||
pages_free | int(11) | No | ||
relocation_ops | bigint(21) | No | ||
relocation_time | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
database_name | varchar(192) | No | ||
table_name | varchar(192) | No | ||
index_name | varchar(192) | No | ||
compress_ops | int(11) | No | ||
compress_ops_ok | int(11) | No | ||
compress_time | int(11) | No | ||
uncompress_ops | int(11) | No | ||
uncompress_time | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
database_name | varchar(192) | No | ||
table_name | varchar(192) | No | ||
index_name | varchar(192) | No | ||
compress_ops | int(11) | No | ||
compress_ops_ok | int(11) | No | ||
compress_time | int(11) | No | ||
uncompress_ops | int(11) | No | ||
uncompress_time | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
page_size | int(5) | No | ||
compress_ops | int(11) | No | ||
compress_ops_ok | int(11) | No | ||
compress_time | int(11) | No | ||
uncompress_ops | int(11) | No | ||
uncompress_time | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_ID | bigint(21) | No | ||
NAME | varchar(193) | No | ||
POS | bigint(21) | No | ||
MTYPE | int(11) | No | ||
PRTYPE | int(11) | No | ||
LEN | int(11) | No | ||
HAS_DEFAULT | int(1) | No | ||
DEFAULT_VALUE | text | Yes |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SPACE | varbinary(256) | Yes | NULL | |
PATH | varchar(512) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
INDEX_ID | varbinary(256) | Yes | NULL | |
NAME | varchar(64) | No | ||
POS | bigint(11) | No | 0 |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ID | varchar(129) | Yes | NULL | |
FOR_NAME | varchar(129) | Yes | NULL | |
REF_NAME | varchar(129) | Yes | NULL | |
N_COLS | bigint(21) | No | 0 | |
TYPE | bigint(21) | No | 0 |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ID | varchar(129) | Yes | NULL | |
FOR_COL_NAME | varchar(64) | No | ||
REF_COL_NAME | varchar(64) | No | ||
POS | int(10) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
DOC_ID | bigint(21) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
KEY | varchar(193) | No | ||
VALUE | varchar(193) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
value | varchar(18) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
DOC_ID | bigint(21) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
WORD | varchar(337) | No | ||
FIRST_DOC_ID | bigint(21) | No | ||
LAST_DOC_ID | bigint(21) | No | ||
DOC_COUNT | bigint(21) | No | ||
DOC_ID | bigint(21) | No | ||
POSITION | bigint(21) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
WORD | varchar(337) | No | ||
FIRST_DOC_ID | bigint(21) | No | ||
LAST_DOC_ID | bigint(21) | No | ||
DOC_COUNT | bigint(21) | No | ||
DOC_ID | bigint(21) | No | ||
POSITION | bigint(21) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
INDEX_ID | bigint(21) | No | ||
NAME | varchar(193) | No | ||
TABLE_ID | bigint(21) | No | ||
TYPE | int(11) | No | ||
N_FIELDS | int(11) | No | ||
PAGE_NO | int(11) | No | ||
SPACE | int(11) | No | ||
MERGE_THRESHOLD | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
NAME | varchar(193) | No | ||
SUBSYSTEM | varchar(193) | No | ||
COUNT | bigint(21) | No | ||
MAX_COUNT | bigint(21) | Yes | ||
MIN_COUNT | bigint(21) | Yes | ||
AVG_COUNT | float(12,0) | Yes | ||
COUNT_RESET | bigint(21) | No | ||
MAX_COUNT_RESET | bigint(21) | Yes | ||
MIN_COUNT_RESET | bigint(21) | Yes | ||
AVG_COUNT_RESET | float(12,0) | Yes | ||
TIME_ENABLED | datetime | Yes | ||
TIME_DISABLED | datetime | Yes | ||
TIME_ELAPSED | bigint(21) | Yes | ||
TIME_RESET | datetime | Yes | ||
STATUS | varchar(193) | No | ||
TYPE | varchar(193) | No | ||
COMMENT | varchar(193) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ID | int(11) | No | ||
SPACE | int(11) | No | ||
PATH | varchar(4001) | No | ||
SIZE | bigint(21) | No | ||
STATE | varchar(192) | No | ||
PURPOSE | varchar(192) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_ID | bigint(21) | No | ||
NAME | varchar(655) | No | ||
FLAG | int(11) | No | ||
N_COLS | int(11) | No | ||
SPACE | bigint(21) | No | ||
ROW_FORMAT | varchar(12) | Yes | ||
ZIP_PAGE_SIZE | int(11) | No | ||
SPACE_TYPE | varchar(10) | Yes | ||
INSTANT_COLS | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SPACE | int(11) | No | ||
NAME | varchar(655) | No | ||
FLAG | int(11) | No | ||
ROW_FORMAT | varchar(22) | Yes | ||
PAGE_SIZE | int(11) | No | ||
ZIP_PAGE_SIZE | int(11) | No | ||
SPACE_TYPE | varchar(10) | Yes | ||
FS_BLOCK_SIZE | int(11) | No | ||
FILE_SIZE | bigint(21) | No | ||
ALLOCATED_SIZE | bigint(21) | No | ||
SERVER_VERSION | varchar(10) | Yes | ||
SPACE_VERSION | int(11) | No | ||
ENCRYPTION | varchar(1) | Yes | ||
STATE | varchar(10) | Yes |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SPACE | varbinary(256) | Yes | NULL | |
NAME | varchar(268) | No | ||
PATH | varchar(512) | No | ||
FLAG | varbinary(256) | Yes | NULL | |
SPACE_TYPE | varchar(7) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_ID | bigint(21) | No | ||
NAME | varchar(193) | No | ||
STATS_INITIALIZED | varchar(193) | No | ||
NUM_ROWS | bigint(21) | No | ||
CLUST_INDEX_SIZE | bigint(21) | No | ||
OTHER_INDEX_SIZE | bigint(21) | No | ||
MODIFIED_COUNTER | bigint(21) | No | ||
AUTOINC | bigint(21) | No | ||
REF_COUNT | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_ID | bigint(21) | No | ||
NAME | varchar(64) | Yes | ||
N_COLS | int(11) | No | ||
SPACE | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
trx_id | varchar(18) | No | ||
trx_state | varchar(13) | No | ||
trx_started | datetime | No | ||
trx_requested_lock_id | varchar(105) | Yes | ||
trx_wait_started | datetime | Yes | ||
trx_weight | bigint(21) | No | ||
trx_mysql_thread_id | bigint(21) | No | ||
trx_query | varchar(1024) | Yes | ||
trx_operation_state | varchar(64) | Yes | ||
trx_tables_in_use | bigint(21) | No | ||
trx_tables_locked | bigint(21) | No | ||
trx_lock_structs | bigint(21) | No | ||
trx_lock_memory_bytes | bigint(21) | No | ||
trx_rows_locked | bigint(21) | No | ||
trx_rows_modified | bigint(21) | No | ||
trx_concurrency_tickets | bigint(21) | No | ||
trx_isolation_level | varchar(16) | No | ||
trx_unique_checks | int(1) | No | ||
trx_foreign_key_checks | int(1) | No | ||
trx_last_foreign_key_error | varchar(256) | Yes | ||
trx_adaptive_hash_latched | int(1) | No | ||
trx_adaptive_hash_timeout | bigint(21) | No | ||
trx_is_read_only | int(1) | No | ||
trx_autocommit_non_locking | int(1) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_ID | bigint(21) | No | ||
POS | int(11) | No | ||
BASE_POS | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
WORD | varchar(29) | Yes | NULL | |
RESERVED | int(11) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CONSTRAINT_CATALOG | varchar(64) | No | ||
CONSTRAINT_SCHEMA | varchar(64) | No | ||
CONSTRAINT_NAME | varchar(64) | Yes | NULL | |
TABLE_CATALOG | varchar(64) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
COLUMN_NAME | varchar(64) | Yes | NULL | |
ORDINAL_POSITION | int(10) | No | 0 | |
POSITION_IN_UNIQUE_CONSTRAINT | int(10) | Yes | NULL | |
REFERENCED_TABLE_SCHEMA | varchar(64) | Yes | NULL | |
REFERENCED_TABLE_NAME | varchar(64) | Yes | NULL | |
REFERENCED_COLUMN_NAME | varchar(64) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
QUERY | varchar(65535) | No | ||
TRACE | varchar(65535) | No | ||
MISSING_BYTES_BEYOND_MAX_MEM_SIZE | int(20) | No | ||
INSUFFICIENT_PRIVILEGES | tinyint(1) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SPECIFIC_CATALOG | varchar(64) | No | ||
SPECIFIC_SCHEMA | varchar(64) | No | ||
SPECIFIC_NAME | varchar(64) | No | ||
ORDINAL_POSITION | bigint(11) | No | 0 | |
PARAMETER_MODE | varchar(5) | Yes | NULL | |
PARAMETER_NAME | varchar(64) | Yes | NULL | |
DATA_TYPE | longtext | Yes | NULL | |
CHARACTER_MAXIMUM_LENGTH | bigint(21) | Yes | NULL | |
CHARACTER_OCTET_LENGTH | bigint(21) | Yes | NULL | |
NUMERIC_PRECISION | int(10) | Yes | NULL | |
NUMERIC_SCALE | bigint(10) | Yes | NULL | |
DATETIME_PRECISION | int(10) | Yes | NULL | |
CHARACTER_SET_NAME | varchar(64) | Yes | NULL | |
COLLATION_NAME | varchar(64) | Yes | NULL | |
DTD_IDENTIFIER | mediumtext | No | ||
ROUTINE_TYPE | enum('FUNCTION', 'PROCEDURE') | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_CATALOG | varchar(64) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
PARTITION_NAME | varchar(64) | Yes | NULL | |
SUBPARTITION_NAME | varchar(64) | Yes | NULL | |
PARTITION_ORDINAL_POSITION | int(6) | Yes | NULL | |
SUBPARTITION_ORDINAL_POSITION | int(6) | Yes | NULL | |
PARTITION_METHOD | varchar(13) | Yes | NULL | |
SUBPARTITION_METHOD | varchar(13) | Yes | NULL | |
PARTITION_EXPRESSION | varchar(2048) | Yes | NULL | |
SUBPARTITION_EXPRESSION | varchar(2048) | Yes | NULL | |
PARTITION_DESCRIPTION | text | Yes | NULL | |
TABLE_ROWS | bigint(21) | Yes | NULL | |
AVG_ROW_LENGTH | bigint(21) | Yes | NULL | |
DATA_LENGTH | bigint(21) | Yes | NULL | |
MAX_DATA_LENGTH | bigint(21) | Yes | NULL | |
INDEX_LENGTH | bigint(21) | Yes | NULL | |
DATA_FREE | bigint(21) | Yes | NULL | |
CREATE_TIME | timestamp | No | ||
UPDATE_TIME | datetime | Yes | NULL | |
CHECK_TIME | datetime | Yes | NULL | |
CHECKSUM | bigint(21) | Yes | NULL | |
PARTITION_COMMENT | text | No | ||
NODEGROUP | varchar(256) | Yes | NULL | |
TABLESPACE_NAME | varchar(268) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
PLUGIN_NAME | varchar(64) | No | ||
PLUGIN_VERSION | varchar(20) | No | ||
PLUGIN_STATUS | varchar(10) | No | ||
PLUGIN_TYPE | varchar(80) | No | ||
PLUGIN_TYPE_VERSION | varchar(20) | No | ||
PLUGIN_LIBRARY | varchar(64) | Yes | ||
PLUGIN_LIBRARY_VERSION | varchar(20) | Yes | ||
PLUGIN_AUTHOR | varchar(64) | Yes | ||
PLUGIN_DESCRIPTION | varchar(65535) | Yes | ||
PLUGIN_LICENSE | varchar(80) | Yes | ||
LOAD_OPTION | varchar(64) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ID | bigint(21) | No | ||
USER | varchar(32) | No | ||
HOST | varchar(261) | No | ||
DB | varchar(64) | Yes | ||
COMMAND | varchar(16) | No | ||
TIME | int(7) | No | ||
STATE | varchar(64) | Yes | ||
INFO | varchar(65535) | Yes |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
QUERY_ID | int(20) | No | ||
SEQ | int(20) | No | ||
STATE | varchar(30) | No | ||
DURATION | decimal(905,0) | No | ||
CPU_USER | decimal(905,0) | Yes | ||
CPU_SYSTEM | decimal(905,0) | Yes | ||
CONTEXT_VOLUNTARY | int(20) | Yes | ||
CONTEXT_INVOLUNTARY | int(20) | Yes | ||
BLOCK_OPS_IN | int(20) | Yes | ||
BLOCK_OPS_OUT | int(20) | Yes | ||
MESSAGES_SENT | int(20) | Yes | ||
MESSAGES_RECEIVED | int(20) | Yes | ||
PAGE_FAULTS_MAJOR | int(20) | Yes | ||
PAGE_FAULTS_MINOR | int(20) | Yes | ||
SWAPS | int(20) | Yes | ||
SOURCE_FUNCTION | varchar(30) | Yes | ||
SOURCE_FILE | varchar(20) | Yes | ||
SOURCE_LINE | int(20) | Yes |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CONSTRAINT_CATALOG | varchar(64) | No | ||
CONSTRAINT_SCHEMA | varchar(64) | No | ||
CONSTRAINT_NAME | varchar(64) | Yes | NULL | |
UNIQUE_CONSTRAINT_CATALOG | varchar(64) | No | ||
UNIQUE_CONSTRAINT_SCHEMA | varchar(64) | No | ||
UNIQUE_CONSTRAINT_NAME | varchar(64) | Yes | NULL | |
MATCH_OPTION | enum('NONE', 'PARTIAL', 'FULL') | No | ||
UPDATE_RULE | enum('NO ACTION', 'RESTRICT', 'CASCADE', 'SET NULL', 'SET DEFAULT') | No | ||
DELETE_RULE | enum('NO ACTION', 'RESTRICT', 'CASCADE', 'SET NULL', 'SET DEFAULT') | No | ||
TABLE_NAME | varchar(64) | No | ||
REFERENCED_TABLE_NAME | varchar(64) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
RESOURCE_GROUP_NAME | varchar(64) | No | ||
RESOURCE_GROUP_TYPE | enum('SYSTEM', 'USER') | No | ||
RESOURCE_GROUP_ENABLED | tinyint(1) | No | ||
VCPU_IDS | blob | Yes | NULL | |
THREAD_PRIORITY | int(11) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SPECIFIC_NAME | varchar(64) | No | ||
ROUTINE_CATALOG | varchar(64) | No | ||
ROUTINE_SCHEMA | varchar(64) | No | ||
ROUTINE_NAME | varchar(64) | No | ||
ROUTINE_TYPE | enum('FUNCTION', 'PROCEDURE') | No | ||
DATA_TYPE | longtext | Yes | NULL | |
CHARACTER_MAXIMUM_LENGTH | bigint(21) | Yes | NULL | |
CHARACTER_OCTET_LENGTH | bigint(21) | Yes | NULL | |
NUMERIC_PRECISION | int(10) | Yes | NULL | |
NUMERIC_SCALE | int(10) | Yes | NULL | |
DATETIME_PRECISION | int(10) | Yes | NULL | |
CHARACTER_SET_NAME | varchar(64) | Yes | NULL | |
COLLATION_NAME | varchar(64) | Yes | NULL | |
DTD_IDENTIFIER | longtext | Yes | NULL | |
ROUTINE_BODY | varchar(3) | No | ||
ROUTINE_DEFINITION | longtext | Yes | NULL | |
EXTERNAL_NAME | binary(0) | Yes | NULL | |
EXTERNAL_LANGUAGE | varchar(64) | No | SQL | |
PARAMETER_STYLE | varchar(3) | No | ||
IS_DETERMINISTIC | varchar(3) | No | ||
SQL_DATA_ACCESS | enum('CONTAINS SQL', 'NO SQL', 'READS SQL DATA', 'MODIFIES SQL DATA') | No | ||
SQL_PATH | binary(0) | Yes | NULL | |
SECURITY_TYPE | enum('DEFAULT', 'INVOKER', 'DEFINER') | No | ||
CREATED | timestamp | No | ||
LAST_ALTERED | timestamp | No | ||
SQL_MODE | set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL') | No | ||
ROUTINE_COMMENT | text | No | ||
DEFINER | varchar(288) | No | ||
CHARACTER_SET_CLIENT | varchar(64) | No | ||
COLLATION_CONNECTION | varchar(64) | No | ||
DATABASE_COLLATION | varchar(64) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CATALOG_NAME | varchar(64) | No | ||
SCHEMA_NAME | varchar(64) | No | ||
DEFAULT_CHARACTER_SET_NAME | varchar(64) | No | ||
DEFAULT_COLLATION_NAME | varchar(64) | No | ||
SQL_PATH | binary(0) | Yes | NULL | |
DEFAULT_ENCRYPTION | enum('NO', 'YES') | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
GRANTEE | varchar(292) | No | ||
TABLE_CATALOG | varchar(512) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
PRIVILEGE_TYPE | varchar(64) | No | ||
IS_GRANTABLE | varchar(3) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_CATALOG | varchar(64) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
NON_UNIQUE | int(1) | No | 0 | |
INDEX_SCHEMA | varchar(64) | No | ||
INDEX_NAME | varchar(64) | Yes | NULL | |
SEQ_IN_INDEX | int(10) | No | ||
COLUMN_NAME | varchar(64) | Yes | NULL | |
COLLATION | varchar(1) | Yes | NULL | |
CARDINALITY | bigint(21) | Yes | NULL | |
SUB_PART | bigint(21) | Yes | NULL | |
PACKED | binary(0) | Yes | NULL | |
NULLABLE | varchar(3) | No | ||
INDEX_TYPE | varchar(11) | No | ||
COMMENT | varchar(8) | No | ||
INDEX_COMMENT | varchar(2048) | No | ||
IS_VISIBLE | varchar(3) | No | ||
EXPRESSION | longtext | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_CATALOG | varchar(64) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
COLUMN_NAME | varchar(64) | Yes | NULL | |
SRS_NAME | varchar(80) | Yes | NULL | |
SRS_ID | int(10) | Yes | NULL | |
GEOMETRY_TYPE_NAME | longtext | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
SRS_NAME | varchar(80) | No | ||
SRS_ID | int(10) | No | ||
ORGANIZATION | varchar(256) | Yes | NULL | |
ORGANIZATION_COORDSYS_ID | int(10) | Yes | NULL | |
DEFINITION | varchar(4096) | No | ||
DESCRIPTION | varchar(2048) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
UNIT_NAME | varchar(255) | Yes | NULL | |
UNIT_TYPE | varchar(7) | Yes | NULL | |
CONVERSION_FACTOR | double | Yes | NULL | |
DESCRIPTION | varchar(255) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_CATALOG | varchar(64) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
TABLE_TYPE | enum('BASE TABLE', 'VIEW', 'SYSTEM VIEW') | No | ||
ENGINE | varchar(64) | Yes | NULL | |
VERSION | int(2) | Yes | NULL | |
ROW_FORMAT | enum('Fixed', 'Dynamic', 'Compressed', 'Redundant', 'Compact', 'Paged') | Yes | NULL | |
TABLE_ROWS | bigint(21) | Yes | NULL | |
AVG_ROW_LENGTH | bigint(21) | Yes | NULL | |
DATA_LENGTH | bigint(21) | Yes | NULL | |
MAX_DATA_LENGTH | bigint(21) | Yes | NULL | |
INDEX_LENGTH | bigint(21) | Yes | NULL | |
DATA_FREE | bigint(21) | Yes | NULL | |
AUTO_INCREMENT | bigint(21) | Yes | NULL | |
CREATE_TIME | timestamp | No | ||
UPDATE_TIME | datetime | Yes | NULL | |
CHECK_TIME | datetime | Yes | NULL | |
TABLE_COLLATION | varchar(64) | Yes | NULL | |
CHECKSUM | bigint(21) | Yes | NULL | |
CREATE_OPTIONS | varchar(256) | Yes | NULL | |
TABLE_COMMENT | text | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLESPACE_NAME | varchar(64) | No | ||
ENGINE | varchar(64) | No | ||
TABLESPACE_TYPE | varchar(64) | Yes | ||
LOGFILE_GROUP_NAME | varchar(64) | Yes | ||
EXTENT_SIZE | bigint(21) | Yes | ||
AUTOEXTEND_SIZE | bigint(21) | Yes | ||
MAXIMUM_SIZE | bigint(21) | Yes | ||
NODEGROUP_ID | bigint(21) | Yes | ||
TABLESPACE_COMMENT | varchar(2048) | Yes |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
CONSTRAINT_CATALOG | varchar(64) | No | ||
CONSTRAINT_SCHEMA | varchar(64) | No | ||
CONSTRAINT_NAME | varchar(64) | Yes | NULL | |
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
CONSTRAINT_TYPE | varchar(11) | No | ||
ENFORCED | varchar(3) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
GRANTEE | varchar(292) | No | ||
TABLE_CATALOG | varchar(512) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
PRIVILEGE_TYPE | varchar(64) | No | ||
IS_GRANTABLE | varchar(3) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TRIGGER_CATALOG | varchar(64) | No | ||
TRIGGER_SCHEMA | varchar(64) | No | ||
TRIGGER_NAME | varchar(64) | No | ||
EVENT_MANIPULATION | enum('INSERT', 'UPDATE', 'DELETE') | No | ||
EVENT_OBJECT_CATALOG | varchar(64) | No | ||
EVENT_OBJECT_SCHEMA | varchar(64) | No | ||
EVENT_OBJECT_TABLE | varchar(64) | No | ||
ACTION_ORDER | int(10) | No | ||
ACTION_CONDITION | binary(0) | Yes | NULL | |
ACTION_STATEMENT | longtext | No | ||
ACTION_ORIENTATION | varchar(3) | No | ||
ACTION_TIMING | enum('BEFORE', 'AFTER') | No | ||
ACTION_REFERENCE_OLD_TABLE | binary(0) | Yes | NULL | |
ACTION_REFERENCE_NEW_TABLE | binary(0) | Yes | NULL | |
ACTION_REFERENCE_OLD_ROW | varchar(3) | No | ||
ACTION_REFERENCE_NEW_ROW | varchar(3) | No | ||
CREATED | timestamp(2) | No | ||
SQL_MODE | set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'NOT_USED_9', 'NOT_USED_10', 'NOT_USED_11', 'NOT_USED_12', 'NOT_USED_13', 'NOT_USED_14', 'NOT_USED_15', 'NOT_USED_16', 'NOT_USED_17', 'NOT_USED_18', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'ALLOW_INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NOT_USED_29', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH', 'TIME_TRUNCATE_FRACTIONAL') | No | ||
DEFINER | varchar(288) | No | ||
CHARACTER_SET_CLIENT | varchar(64) | No | ||
COLLATION_CONNECTION | varchar(64) | No | ||
DATABASE_COLLATION | varchar(64) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
GRANTEE | varchar(292) | No | ||
TABLE_CATALOG | varchar(512) | No | ||
PRIVILEGE_TYPE | varchar(64) | No | ||
IS_GRANTABLE | varchar(3) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_CATALOG | varchar(64) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
VIEW_DEFINITION | longtext | Yes | NULL | |
CHECK_OPTION | enum('NONE', 'LOCAL', 'CASCADED') | Yes | NULL | |
IS_UPDATABLE | enum('NO', 'YES') | Yes | NULL | |
DEFINER | varchar(288) | Yes | NULL | |
SECURITY_TYPE | varchar(7) | Yes | NULL | |
CHARACTER_SET_CLIENT | varchar(64) | No | ||
COLLATION_CONNECTION | varchar(64) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
TABLE_CATALOG | varchar(64) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No | ||
SPECIFIC_CATALOG | varchar(64) | No | ||
SPECIFIC_SCHEMA | varchar(64) | No | ||
SPECIFIC_NAME | varchar(64) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
VIEW_CATALOG | varchar(64) | No | ||
VIEW_SCHEMA | varchar(64) | No | ||
VIEW_NAME | varchar(64) | No | ||
TABLE_CATALOG | varchar(64) | No | ||
TABLE_SCHEMA | varchar(64) | No | ||
TABLE_NAME | varchar(64) | No |
No index defined!