| 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 | |||
| COLUMN_NAME | varchar(64) | No | |||
| ORDINAL_POSITION | bigint(21) | No | 0 | ||
| COLUMN_DEFAULT | longtext | Yes | NULL | ||
| IS_NULLABLE | varchar(3) | No | |||
| DATA_TYPE | varchar(64) | No | |||
| CHARACTER_MAXIMUM_LENGTH | bigint(21) | Yes | NULL | ||
| CHARACTER_OCTET_LENGTH | bigint(21) | Yes | NULL | ||
| NUMERIC_PRECISION | bigint(21) | Yes | NULL | ||
| NUMERIC_SCALE | bigint(21) | Yes | NULL | ||
| DATETIME_PRECISION | bigint(21) | Yes | NULL | ||
| CHARACTER_SET_NAME | varchar(32) | Yes | NULL | CHARACTER_SETS -> CHARACTER_SET_NAME | |
| COLLATION_NAME | varchar(32) | Yes | NULL | COLLATIONS -> COLLATION_NAME | |
| COLUMN_TYPE | longtext | No | |||
| COLUMN_KEY | varchar(3) | No | |||
| EXTRA | varchar(30) | No | |||
| PRIVILEGES | varchar(80) | No | |||
| COLUMN_COMMENT | varchar(1024) | No |