| 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 |