Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
PARTITIONS
|
TABLE_CATALOG
|
varchar(512)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
TABLE_SCHEMA
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
TABLE_NAME
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
PARTITION_NAME
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
SUBPARTITION_NAME
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
PARTITION_ORDINAL_POSITION
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
PARTITIONS
|
SUBPARTITION_ORDINAL_POSITION
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
PARTITIONS
|
PARTITION_METHOD
|
varchar(18)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
SUBPARTITION_METHOD
|
varchar(12)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
PARTITION_EXPRESSION
|
longtext
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
SUBPARTITION_EXPRESSION
|
longtext
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
PARTITION_DESCRIPTION
|
longtext
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
PARTITIONS
|
TABLE_ROWS
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
PARTITIONS
|
AVG_ROW_LENGTH
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
PARTITIONS
|
DATA_LENGTH
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
PARTITIONS
|
MAX_DATA_LENGTH
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
PARTITIONS
|
INDEX_LENGTH
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
PARTITIONS
|
DATA_FREE
|
bigint(21) unsigned
|
|
|
|
|
NULL
|
NULL
|
|
PARTITIONS
|
CREATE_TIME
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|
PARTITIONS
|
UPDATE_TIME
|
datetime
|
|
|
|
|
NULL
|
NULL
|
|