| 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(80)
|
utf8_general_ci
|
|
|
| PRIVILEGES |
varchar(80)
|
utf8_general_ci
|
|
|
| COLUMN_COMMENT |
varchar(1024)
|
utf8_general_ci
|
|
|
| IS_GENERATED |
varchar(6)
|
utf8_general_ci
|
|
|
| GENERATION_EXPRESSION |
longtext
|
utf8_general_ci
|
|
|
