CHARACTER_SETS

Column Type Null Default Comments
CHARACTER_SET_NAME varchar(32) No
DEFAULT_COLLATE_NAME varchar(32) No
DESCRIPTION varchar(60) No
MAXLEN bigint(3) No 0

COLLATIONS

Column Type Null Default Comments
COLLATION_NAME varchar(32) No
CHARACTER_SET_NAME varchar(32) No
ID bigint(11) No 0
IS_DEFAULT varchar(3) No
IS_COMPILED varchar(3) No
SORTLEN bigint(3) No 0

COLLATION_CHARACTER_SET_APPLICABILITY

Column Type Null Default Comments
COLLATION_NAME varchar(32) No
CHARACTER_SET_NAME varchar(32) No

COLUMNS

Column Type Null Default Comments
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
COLUMN_NAME varchar(64) No
ORDINAL_POSITION bigint(21) No 0
COLUMN_DEFAULT longtext Yes NULL
IS_NULLABLE varchar(3) No
DATA_TYPE varchar(64) No
CHARACTER_MAXIMUM_LENGTH bigint(21) Yes NULL
CHARACTER_OCTET_LENGTH bigint(21) Yes NULL
NUMERIC_PRECISION bigint(21) Yes NULL
NUMERIC_SCALE bigint(21) Yes NULL
CHARACTER_SET_NAME varchar(32) Yes NULL
COLLATION_NAME varchar(32) Yes NULL
COLUMN_TYPE longtext No
COLUMN_KEY varchar(3) No
EXTRA varchar(27) No
PRIVILEGES varchar(80) No
COLUMN_COMMENT varchar(1024) No

COLUMN_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(81) 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

ENGINES

Column Type Null Default Comments
ENGINE varchar(64) No
SUPPORT varchar(8) No
COMMENT varchar(80) No
TRANSACTIONS varchar(3) Yes NULL
XA varchar(3) Yes NULL
SAVEPOINTS varchar(3) Yes NULL

EVENTS

Column Type Null Default Comments
EVENT_CATALOG varchar(64) No
EVENT_SCHEMA varchar(64) No
EVENT_NAME varchar(64) No
DEFINER varchar(77) No
TIME_ZONE varchar(64) No
EVENT_BODY varchar(8) No
EVENT_DEFINITION longtext No
EVENT_TYPE varchar(9) No
EXECUTE_AT datetime Yes NULL
INTERVAL_VALUE varchar(256) Yes NULL
INTERVAL_FIELD varchar(18) Yes NULL
SQL_MODE varchar(8192) No
STARTS datetime Yes NULL
ENDS datetime Yes NULL
STATUS varchar(18) No
ON_COMPLETION varchar(12) No
CREATED datetime No 0000-00-00 00:00:00
LAST_ALTERED datetime No 0000-00-00 00:00:00
LAST_EXECUTED datetime Yes NULL
EVENT_COMMENT varchar(64) No
ORIGINATOR bigint(10) No 0
CHARACTER_SET_CLIENT varchar(32) No
COLLATION_CONNECTION varchar(32) No
DATABASE_COLLATION varchar(32) No

FILES

Column Type Null Default Comments
FILE_ID bigint(4) No 0
FILE_NAME varchar(64) Yes NULL
FILE_TYPE varchar(20) No
TABLESPACE_NAME varchar(64) Yes NULL
TABLE_CATALOG varchar(64) No
TABLE_SCHEMA varchar(64) Yes NULL
TABLE_NAME varchar(64) Yes NULL
LOGFILE_GROUP_NAME varchar(64) Yes NULL
LOGFILE_GROUP_NUMBER bigint(4) Yes NULL
ENGINE varchar(64) No
FULLTEXT_KEYS varchar(64) Yes NULL
DELETED_ROWS bigint(4) Yes NULL
UPDATE_COUNT bigint(4) Yes NULL
FREE_EXTENTS bigint(4) Yes NULL
TOTAL_EXTENTS bigint(4) Yes NULL
EXTENT_SIZE bigint(4) No 0
INITIAL_SIZE bigint(21) Yes NULL
MAXIMUM_SIZE bigint(21) Yes NULL
AUTOEXTEND_SIZE bigint(21) Yes NULL
CREATION_TIME datetime Yes NULL
LAST_UPDATE_TIME datetime Yes NULL
LAST_ACCESS_TIME datetime Yes NULL
RECOVER_TIME bigint(4) Yes NULL
TRANSACTION_COUNTER bigint(4) Yes NULL
VERSION bigint(21) Yes NULL
ROW_FORMAT varchar(10) 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 datetime Yes NULL
UPDATE_TIME datetime Yes NULL
CHECK_TIME datetime Yes NULL
CHECKSUM bigint(21) Yes NULL
STATUS varchar(20) No
EXTRA varchar(255) Yes NULL

GLOBAL_STATUS

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(1024) Yes NULL

GLOBAL_VARIABLES

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(1024) Yes NULL

KEY_COLUMN_USAGE

Column Type Null Default Comments
CONSTRAINT_CATALOG varchar(512) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) No
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
COLUMN_NAME varchar(64) No
ORDINAL_POSITION bigint(10) No 0
POSITION_IN_UNIQUE_CONSTRAINT bigint(10) Yes NULL
REFERENCED_TABLE_SCHEMA varchar(64) Yes NULL
REFERENCED_TABLE_NAME varchar(64) Yes NULL
REFERENCED_COLUMN_NAME varchar(64) Yes NULL

PARAMETERS

Column Type Null Default Comments
SPECIFIC_CATALOG varchar(512) No
SPECIFIC_SCHEMA varchar(64) No
SPECIFIC_NAME varchar(64) No
ORDINAL_POSITION int(21) No 0
PARAMETER_MODE varchar(5) Yes NULL
PARAMETER_NAME varchar(64) Yes NULL
DATA_TYPE varchar(64) No
CHARACTER_MAXIMUM_LENGTH int(21) Yes NULL
CHARACTER_OCTET_LENGTH int(21) Yes NULL
NUMERIC_PRECISION int(21) Yes NULL
NUMERIC_SCALE int(21) Yes NULL
CHARACTER_SET_NAME varchar(64) Yes NULL
COLLATION_NAME varchar(64) Yes NULL
DTD_IDENTIFIER longtext No
ROUTINE_TYPE varchar(9) No

PARTITIONS

Column Type Null Default Comments
TABLE_CATALOG varchar(512) 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 bigint(21) Yes NULL
SUBPARTITION_ORDINAL_POSITION bigint(21) Yes NULL
PARTITION_METHOD varchar(18) Yes NULL
SUBPARTITION_METHOD varchar(12) Yes NULL
PARTITION_EXPRESSION longtext Yes NULL
SUBPARTITION_EXPRESSION longtext Yes NULL
PARTITION_DESCRIPTION longtext Yes NULL
TABLE_ROWS bigint(21) No 0
AVG_ROW_LENGTH bigint(21) No 0
DATA_LENGTH bigint(21) No 0
MAX_DATA_LENGTH bigint(21) Yes NULL
INDEX_LENGTH bigint(21) No 0
DATA_FREE bigint(21) No 0
CREATE_TIME datetime Yes NULL
UPDATE_TIME datetime Yes NULL
CHECK_TIME datetime Yes NULL
CHECKSUM bigint(21) Yes NULL
PARTITION_COMMENT varchar(80) No
NODEGROUP varchar(12) No
TABLESPACE_NAME varchar(64) Yes NULL

PLUGINS

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 NULL
PLUGIN_LIBRARY_VERSION varchar(20) Yes NULL
PLUGIN_AUTHOR varchar(64) Yes NULL
PLUGIN_DESCRIPTION longtext Yes NULL
PLUGIN_LICENSE varchar(80) Yes NULL
LOAD_OPTION varchar(64) No

PROCESSLIST

Column Type Null Default Comments
ID bigint(4) No 0
USER varchar(16) No
HOST varchar(64) No
DB varchar(64) Yes NULL
COMMAND varchar(16) No
TIME int(7) No 0
STATE varchar(64) Yes NULL
INFO longtext Yes NULL

PROFILING

Column Type Null Default Comments
QUERY_ID int(20) No 0
SEQ int(20) No 0
STATE varchar(30) No
DURATION decimal(9,6) No 0.000000
CPU_USER decimal(9,6) Yes NULL
CPU_SYSTEM decimal(9,6) Yes NULL
CONTEXT_VOLUNTARY int(20) Yes NULL
CONTEXT_INVOLUNTARY int(20) Yes NULL
BLOCK_OPS_IN int(20) Yes NULL
BLOCK_OPS_OUT int(20) Yes NULL
MESSAGES_SENT int(20) Yes NULL
MESSAGES_RECEIVED int(20) Yes NULL
PAGE_FAULTS_MAJOR int(20) Yes NULL
PAGE_FAULTS_MINOR int(20) Yes NULL
SWAPS int(20) Yes NULL
SOURCE_FUNCTION varchar(30) Yes NULL
SOURCE_FILE varchar(20) Yes NULL
SOURCE_LINE int(20) Yes NULL

REFERENTIAL_CONSTRAINTS

Column Type Null Default Comments
CONSTRAINT_CATALOG varchar(512) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) No
UNIQUE_CONSTRAINT_CATALOG varchar(512) No
UNIQUE_CONSTRAINT_SCHEMA varchar(64) No
UNIQUE_CONSTRAINT_NAME varchar(64) Yes NULL
MATCH_OPTION varchar(64) No
UPDATE_RULE varchar(64) No
DELETE_RULE varchar(64) No
TABLE_NAME varchar(64) No
REFERENCED_TABLE_NAME varchar(64) No

ROUTINES

Column Type Null Default Comments
SPECIFIC_NAME varchar(64) No
ROUTINE_CATALOG varchar(512) No
ROUTINE_SCHEMA varchar(64) No
ROUTINE_NAME varchar(64) No
ROUTINE_TYPE varchar(9) No
DATA_TYPE varchar(64) No
CHARACTER_MAXIMUM_LENGTH int(21) Yes NULL
CHARACTER_OCTET_LENGTH int(21) Yes NULL
NUMERIC_PRECISION int(21) Yes NULL
NUMERIC_SCALE int(21) Yes NULL
CHARACTER_SET_NAME varchar(64) Yes NULL
COLLATION_NAME varchar(64) Yes NULL
DTD_IDENTIFIER longtext Yes NULL
ROUTINE_BODY varchar(8) No
ROUTINE_DEFINITION longtext Yes NULL
EXTERNAL_NAME varchar(64) Yes NULL
EXTERNAL_LANGUAGE varchar(64) Yes NULL
PARAMETER_STYLE varchar(8) No
IS_DETERMINISTIC varchar(3) No
SQL_DATA_ACCESS varchar(64) No
SQL_PATH varchar(64) Yes NULL
SECURITY_TYPE varchar(7) No
CREATED datetime No 0000-00-00 00:00:00
LAST_ALTERED datetime No 0000-00-00 00:00:00
SQL_MODE varchar(8192) No
ROUTINE_COMMENT longtext No
DEFINER varchar(77) No
CHARACTER_SET_CLIENT varchar(32) No
COLLATION_CONNECTION varchar(32) No
DATABASE_COLLATION varchar(32) No

SCHEMATA

Column Type Null Default Comments
CATALOG_NAME varchar(512) No
SCHEMA_NAME varchar(64) No
DEFAULT_CHARACTER_SET_NAME varchar(32) No
DEFAULT_COLLATION_NAME varchar(32) No
SQL_PATH varchar(512) Yes NULL

SCHEMA_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(81) No
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
PRIVILEGE_TYPE varchar(64) No
IS_GRANTABLE varchar(3) No

SESSION_STATUS

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(1024) Yes NULL

SESSION_VARIABLES

Column Type Null Default Comments
VARIABLE_NAME varchar(64) No
VARIABLE_VALUE varchar(1024) Yes NULL

STATISTICS

Column Type Null Default Comments
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
NON_UNIQUE bigint(1) No 0
INDEX_SCHEMA varchar(64) No
INDEX_NAME varchar(64) No
SEQ_IN_INDEX bigint(2) No 0
COLUMN_NAME varchar(64) No
COLLATION varchar(1) Yes NULL
CARDINALITY bigint(21) Yes NULL
SUB_PART bigint(3) Yes NULL
PACKED varchar(10) Yes NULL
NULLABLE varchar(3) No
INDEX_TYPE varchar(16) No
COMMENT varchar(16) Yes NULL
INDEX_COMMENT varchar(1024) No

TABLES

Column Type Null Default Comments
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
TABLE_TYPE varchar(64) No
ENGINE varchar(64) Yes NULL
VERSION bigint(21) Yes NULL
ROW_FORMAT varchar(10) 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 datetime Yes NULL
UPDATE_TIME datetime Yes NULL
CHECK_TIME datetime Yes NULL
TABLE_COLLATION varchar(32) Yes NULL
CHECKSUM bigint(21) Yes NULL
CREATE_OPTIONS varchar(255) Yes NULL
TABLE_COMMENT varchar(2048) No

TABLESPACES

Column Type Null Default Comments
TABLESPACE_NAME varchar(64) No
ENGINE varchar(64) No
TABLESPACE_TYPE varchar(64) Yes NULL
LOGFILE_GROUP_NAME varchar(64) Yes NULL
EXTENT_SIZE bigint(21) Yes NULL
AUTOEXTEND_SIZE bigint(21) Yes NULL
MAXIMUM_SIZE bigint(21) Yes NULL
NODEGROUP_ID bigint(21) Yes NULL
TABLESPACE_COMMENT varchar(2048) Yes NULL

TABLE_CONSTRAINTS

Column Type Null Default Comments
CONSTRAINT_CATALOG varchar(512) No
CONSTRAINT_SCHEMA varchar(64) No
CONSTRAINT_NAME varchar(64) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
CONSTRAINT_TYPE varchar(64) No

TABLE_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(81) 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

TRIGGERS

Column Type Null Default Comments
TRIGGER_CATALOG varchar(512) No
TRIGGER_SCHEMA varchar(64) No
TRIGGER_NAME varchar(64) No
EVENT_MANIPULATION varchar(6) No
EVENT_OBJECT_CATALOG varchar(512) No
EVENT_OBJECT_SCHEMA varchar(64) No
EVENT_OBJECT_TABLE varchar(64) No
ACTION_ORDER bigint(4) No 0
ACTION_CONDITION longtext Yes NULL
ACTION_STATEMENT longtext No
ACTION_ORIENTATION varchar(9) No
ACTION_TIMING varchar(6) No
ACTION_REFERENCE_OLD_TABLE varchar(64) Yes NULL
ACTION_REFERENCE_NEW_TABLE varchar(64) Yes NULL
ACTION_REFERENCE_OLD_ROW varchar(3) No
ACTION_REFERENCE_NEW_ROW varchar(3) No
CREATED datetime Yes NULL
SQL_MODE varchar(8192) No
DEFINER varchar(77) No
CHARACTER_SET_CLIENT varchar(32) No
COLLATION_CONNECTION varchar(32) No
DATABASE_COLLATION varchar(32) No

USER_PRIVILEGES

Column Type Null Default Comments
GRANTEE varchar(81) No
TABLE_CATALOG varchar(512) No
PRIVILEGE_TYPE varchar(64) No
IS_GRANTABLE varchar(3) No

VIEWS

Column Type Null Default Comments
TABLE_CATALOG varchar(512) No
TABLE_SCHEMA varchar(64) No
TABLE_NAME varchar(64) No
VIEW_DEFINITION longtext No
CHECK_OPTION varchar(8) No
IS_UPDATABLE varchar(3) No
DEFINER varchar(77) No
SECURITY_TYPE varchar(7) No
CHARACTER_SET_CLIENT varchar(32) No
COLLATION_CONNECTION varchar(32) No

INNODB_BUFFER_PAGE

Column Type Null Default Comments
POOL_ID bigint(21) No 0
BLOCK_ID bigint(21) No 0
SPACE bigint(21) No 0
PAGE_NUMBER bigint(21) No 0
PAGE_TYPE varchar(64) Yes NULL
FLUSH_TYPE bigint(21) No 0
FIX_COUNT bigint(21) No 0
IS_HASHED varchar(3) Yes NULL
NEWEST_MODIFICATION bigint(21) No 0
OLDEST_MODIFICATION bigint(21) No 0
ACCESS_TIME bigint(21) No 0
TABLE_NAME varchar(1024) Yes NULL
INDEX_NAME varchar(1024) Yes NULL
NUMBER_RECORDS bigint(21) No 0
DATA_SIZE bigint(21) No 0
COMPRESSED_SIZE bigint(21) No 0
PAGE_STATE varchar(64) Yes NULL
IO_FIX varchar(64) Yes NULL
IS_OLD varchar(3) Yes NULL
FREE_PAGE_CLOCK bigint(21) No 0

INNODB_TRX

Column Type Null Default Comments
trx_id varchar(18) No
trx_state varchar(13) No
trx_started datetime No 0000-00-00 00:00:00
trx_requested_lock_id varchar(81) Yes NULL
trx_wait_started datetime Yes NULL
trx_weight bigint(21) No 0
trx_mysql_thread_id bigint(21) No 0
trx_query varchar(1024) Yes NULL
trx_operation_state varchar(64) Yes NULL
trx_tables_in_use bigint(21) No 0
trx_tables_locked bigint(21) No 0
trx_lock_structs bigint(21) No 0
trx_lock_memory_bytes bigint(21) No 0
trx_rows_locked bigint(21) No 0
trx_rows_modified bigint(21) No 0
trx_concurrency_tickets bigint(21) No 0
trx_isolation_level varchar(16) No
trx_unique_checks int(1) No 0
trx_foreign_key_checks int(1) No 0
trx_last_foreign_key_error varchar(256) Yes NULL
trx_adaptive_hash_latched int(1) No 0
trx_adaptive_hash_timeout bigint(21) No 0

INNODB_BUFFER_POOL_STATS

Column Type Null Default Comments
POOL_ID bigint(21) No 0
POOL_SIZE bigint(21) No 0
FREE_BUFFERS bigint(21) No 0
DATABASE_PAGES bigint(21) No 0
OLD_DATABASE_PAGES bigint(21) No 0
MODIFIED_DATABASE_PAGES bigint(21) No 0
PENDING_DECOMPRESS bigint(21) No 0
PENDING_READS bigint(21) No 0
PENDING_FLUSH_LRU bigint(21) No 0
PENDING_FLUSH_LIST bigint(21) No 0
PAGES_MADE_YOUNG bigint(21) No 0
PAGES_NOT_MADE_YOUNG bigint(21) No 0
PAGES_MADE_YOUNG_RATE double No 0
PAGES_MADE_NOT_YOUNG_RATE double No 0
NUMBER_PAGES_READ bigint(21) No 0
NUMBER_PAGES_CREATED bigint(21) No 0
NUMBER_PAGES_WRITTEN bigint(21) No 0
PAGES_READ_RATE double No 0
PAGES_CREATE_RATE double No 0
PAGES_WRITTEN_RATE double No 0
NUMBER_PAGES_GET bigint(21) No 0
HIT_RATE bigint(21) No 0
YOUNG_MAKE_PER_THOUSAND_GETS bigint(21) No 0
NOT_YOUNG_MAKE_PER_THOUSAND_GETS bigint(21) No 0
NUMBER_PAGES_READ_AHEAD bigint(21) No 0
NUMBER_READ_AHEAD_EVICTED bigint(21) No 0
READ_AHEAD_RATE double No 0
READ_AHEAD_EVICTED_RATE double No 0
LRU_IO_TOTAL bigint(21) No 0
LRU_IO_CURRENT bigint(21) No 0
UNCOMPRESS_TOTAL bigint(21) No 0
UNCOMPRESS_CURRENT bigint(21) No 0

INNODB_LOCK_WAITS

Column Type Null Default Comments
requesting_trx_id varchar(18) No
requested_lock_id varchar(81) No
blocking_trx_id varchar(18) No
blocking_lock_id varchar(81) No

INNODB_CMPMEM

Column Type Null Default Comments
page_size int(5) No 0
buffer_pool_instance int(11) No 0
pages_used int(11) No 0
pages_free int(11) No 0
relocation_ops bigint(21) No 0
relocation_time int(11) No 0

INNODB_CMP

Column Type Null Default Comments
page_size int(5) No 0
compress_ops int(11) No 0
compress_ops_ok int(11) No 0
compress_time int(11) No 0
uncompress_ops int(11) No 0
uncompress_time int(11) No 0

INNODB_LOCKS

Column Type Null Default Comments
lock_id varchar(81) No
lock_trx_id varchar(18) No
lock_mode varchar(32) No
lock_type varchar(32) No
lock_table varchar(1024) No
lock_index varchar(1024) Yes NULL
lock_space bigint(21) Yes NULL
lock_page bigint(21) Yes NULL
lock_rec bigint(21) Yes NULL
lock_data varchar(8192) Yes NULL

INNODB_CMPMEM_RESET

Column Type Null Default Comments
page_size int(5) No 0
buffer_pool_instance int(11) No 0
pages_used int(11) No 0
pages_free int(11) No 0
relocation_ops bigint(21) No 0
relocation_time int(11) No 0

INNODB_CMP_RESET

Column Type Null Default Comments
page_size int(5) No 0
compress_ops int(11) No 0
compress_ops_ok int(11) No 0
compress_time int(11) No 0
uncompress_ops int(11) No 0
uncompress_time int(11) No 0

INNODB_BUFFER_PAGE_LRU

Column Type Null Default Comments
POOL_ID bigint(21) No 0
LRU_POSITION bigint(21) No 0
SPACE bigint(21) No 0
PAGE_NUMBER bigint(21) No 0
PAGE_TYPE varchar(64) Yes NULL
FLUSH_TYPE bigint(21) No 0
FIX_COUNT bigint(21) No 0
IS_HASHED varchar(3) Yes NULL
NEWEST_MODIFICATION bigint(21) No 0
OLDEST_MODIFICATION bigint(21) No 0
ACCESS_TIME bigint(21) No 0
TABLE_NAME varchar(1024) Yes NULL
INDEX_NAME varchar(1024) Yes NULL
NUMBER_RECORDS bigint(21) No 0
DATA_SIZE bigint(21) No 0
COMPRESSED_SIZE bigint(21) No 0
COMPRESSED varchar(3) Yes NULL
IO_FIX varchar(64) Yes NULL
IS_OLD varchar(3) Yes NULL
FREE_PAGE_CLOCK bigint(21) No 0