Table Name |
Name |
Data Type |
Primary Key |
Unique |
Required |
Autoincrement |
Charset |
Collation |
Comment |
KEY_COLUMN_USAGE
|
CONSTRAINT_CATALOG
|
varchar(512)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
KEY_COLUMN_USAGE
|
CONSTRAINT_SCHEMA
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
KEY_COLUMN_USAGE
|
CONSTRAINT_NAME
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
KEY_COLUMN_USAGE
|
TABLE_CATALOG
|
varchar(512)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
KEY_COLUMN_USAGE
|
TABLE_SCHEMA
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
KEY_COLUMN_USAGE
|
TABLE_NAME
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
KEY_COLUMN_USAGE
|
COLUMN_NAME
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
KEY_COLUMN_USAGE
|
ORDINAL_POSITION
|
bigint(10)
|
|
|
|
|
NULL
|
NULL
|
|
KEY_COLUMN_USAGE
|
POSITION_IN_UNIQUE_CONSTRAINT
|
bigint(10)
|
|
|
|
|
NULL
|
NULL
|
|
KEY_COLUMN_USAGE
|
REFERENCED_TABLE_SCHEMA
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
KEY_COLUMN_USAGE
|
REFERENCED_TABLE_NAME
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|
KEY_COLUMN_USAGE
|
REFERENCED_COLUMN_NAME
|
varchar(64)
|
|
|
|
|
utf8
|
utf8_general_ci
|
|