TABLE_CATALOG |
varchar(512) |
utf8_general_ci |
|
|
|
TABLE_SCHEMA |
varchar(64) |
utf8_general_ci |
|
|
|
TABLE_NAME |
varchar(64) |
utf8_general_ci |
|
|
|
COLUMN_NAME |
varchar(64) |
utf8_general_ci |
|
|
|
ORDINAL_POSITION |
bigint(21) |
|
|
|
|
COLUMN_DEFAULT |
longtext |
utf8_general_ci |
|
|
|
IS_NULLABLE |
varchar(3) |
utf8_general_ci |
|
|
|
DATA_TYPE |
varchar(64) |
utf8_general_ci |
|
|
|
CHARACTER_MAXIMUM_LENGTH |
bigint(21) |
|
|
|
|
CHARACTER_OCTET_LENGTH |
bigint(21) |
|
|
|
|
NUMERIC_PRECISION |
bigint(21) |
|
|
|
|
NUMERIC_SCALE |
bigint(21) |
|
|
|
|
DATETIME_PRECISION |
bigint(21) |
|
|
|
|
CHARACTER_SET_NAME |
varchar(32) |
utf8_general_ci |
|
|
|
COLLATION_NAME |
varchar(32) |
utf8_general_ci |
|
|
|
COLUMN_TYPE |
longtext |
utf8_general_ci |
|
|
|
COLUMN_KEY |
varchar(3) |
utf8_general_ci |
|
|
|
EXTRA |
varchar(27) |
utf8_general_ci |
|
|
|
PRIVILEGES |
varchar(80) |
utf8_general_ci |
|
|
|
COLUMN_COMMENT |
varchar(1024) |
utf8_general_ci |
|
|
|