Column | Type | Null | Default | Links to | Comments |
---|---|---|---|---|---|
FILE_ID | bigint(4) | No | 0 | ||
FILE_NAME | varchar(64) | Yes | NULL | ||
FILE_TYPE | varchar(20) | No | |||
TABLESPACE_NAME | varchar(64) | Yes | NULL | TABLESPACES -> TABLESPACE_NAME | |
TABLE_CATALOG | varchar(64) | No | |||
TABLE_SCHEMA | varchar(64) | Yes | NULL | SCHEMATA -> SCHEMA_NAME | |
TABLE_NAME | varchar(64) | Yes | NULL | ||
LOGFILE_GROUP_NAME | varchar(64) | Yes | NULL | ||
LOGFILE_GROUP_NUMBER | bigint(4) | Yes | NULL | ||
ENGINE | varchar(64) | No | ENGINES -> ENGINE | ||
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 |