Table NameNameData TypePrimary KeyUniqueRequiredAutoincrementCharsetCollationComment
COLUMNSTABLE_CATALOGvarchar(512)utf8utf8_general_ci
COLUMNSTABLE_SCHEMAvarchar(64)utf8utf8_general_ci
COLUMNSTABLE_NAMEvarchar(64)utf8utf8_general_ci
COLUMNSCOLUMN_NAMEvarchar(64)utf8utf8_general_ci
COLUMNSORDINAL_POSITIONbigint(21) unsigned
COLUMNSCOLUMN_DEFAULTlongtextutf8utf8_general_ci
COLUMNSIS_NULLABLEvarchar(3)utf8utf8_general_ci
COLUMNSDATA_TYPEvarchar(64)utf8utf8_general_ci
COLUMNSCHARACTER_MAXIMUM_LENGTHbigint(21) unsigned
COLUMNSCHARACTER_OCTET_LENGTHbigint(21) unsigned
COLUMNSNUMERIC_PRECISIONbigint(21) unsigned
COLUMNSNUMERIC_SCALEbigint(21) unsigned
COLUMNSCHARACTER_SET_NAMEvarchar(32)utf8utf8_general_ci
COLUMNSCOLLATION_NAMEvarchar(32)utf8utf8_general_ci
COLUMNSCOLUMN_TYPElongtextutf8utf8_general_ci
COLUMNSCOLUMN_KEYvarchar(3)utf8utf8_general_ci
COLUMNSEXTRAvarchar(27)utf8utf8_general_ci
COLUMNSPRIVILEGESvarchar(80)utf8utf8_general_ci
COLUMNSCOLUMN_COMMENTvarchar(1024)utf8utf8_general_ci