Column | Type | Null | Default | Links to | Comments |
---|---|---|---|---|---|
TABLE_CATALOG | varchar(512) | No | |||
TABLE_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
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 | TABLESPACES -> TABLESPACE_NAME |