|
TABLE_CATALOG
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
TABLE_SCHEMA
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
TABLE_NAME
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
COLUMN_NAME
|
varchar(64)
|
utf8mb3_tolower_ci
|
|
|
|
ORDINAL_POSITION
|
int
|
|
|
|
|
COLUMN_DEFAULT
|
text
|
utf8mb3_bin
|
|
|
|
IS_NULLABLE
|
varchar(3)
|
utf8mb3_general_ci
|
|
|
|
DATA_TYPE
|
longtext
|
utf8mb3_bin
|
|
|
|
CHARACTER_MAXIMUM_LENGTH
|
bigint
|
|
|
|
|
CHARACTER_OCTET_LENGTH
|
bigint
|
|
|
|
|
NUMERIC_PRECISION
|
bigint
|
|
|
|
|
NUMERIC_SCALE
|
bigint
|
|
|
|
|
DATETIME_PRECISION
|
int
|
|
|
|
|
CHARACTER_SET_NAME
|
varchar(64)
|
utf8mb3_general_ci
|
|
|
|
COLLATION_NAME
|
varchar(64)
|
utf8mb3_general_ci
|
|
 Visualizar valores estrangeiros
|
|
COLUMN_TYPE
|
mediumtext
|
utf8mb3_bin
|
|
|
|
COLUMN_KEY
|
enum('', 'PRI', 'UNI', 'MUL')
|
utf8mb3_bin
|
|
|
|
EXTRA
|
varchar(256)
|
utf8mb3_general_ci
|
|
|
|
PRIVILEGES
|
varchar(154)
|
utf8mb3_general_ci
|
|
|
|
COLUMN_COMMENT
|
text
|
utf8mb3_bin
|
|
|
|
GENERATION_EXPRESSION
|
longtext
|
utf8mb3_bin
|
|
|
|
SRS_ID
|
int
|
|
|
|
