Table NameNameData TypePrimary KeyUniqueRequiredAutoincrementCharsetCollationComment
COLUMNSTABLE_CATALOGvarchar(512)falsefalsetruefalseutf8utf8_general_ci
COLUMNSTABLE_SCHEMAvarchar(64)falsefalsetruefalseutf8utf8_general_ci
COLUMNSTABLE_NAMEvarchar(64)falsefalsetruefalseutf8utf8_general_ci
COLUMNSCOLUMN_NAMEvarchar(64)falsefalsetruefalseutf8utf8_general_ci
COLUMNSORDINAL_POSITIONbigint(21) unsignedfalsefalsetruefalse
COLUMNSCOLUMN_DEFAULTlongtextfalsefalsefalsefalseutf8utf8_general_ci
COLUMNSIS_NULLABLEvarchar(3)falsefalsetruefalseutf8utf8_general_ci
COLUMNSDATA_TYPEvarchar(64)falsefalsetruefalseutf8utf8_general_ci
COLUMNSCHARACTER_MAXIMUM_LENGTHbigint(21) unsignedfalsefalsefalsefalse
COLUMNSCHARACTER_OCTET_LENGTHbigint(21) unsignedfalsefalsefalsefalse
COLUMNSNUMERIC_PRECISIONbigint(21) unsignedfalsefalsefalsefalse
COLUMNSNUMERIC_SCALEbigint(21) unsignedfalsefalsefalsefalse
COLUMNSCHARACTER_SET_NAMEvarchar(32)falsefalsefalsefalseutf8utf8_general_ci
COLUMNSCOLLATION_NAMEvarchar(32)falsefalsefalsefalseutf8utf8_general_ci
COLUMNSCOLUMN_TYPElongtextfalsefalsetruefalseutf8utf8_general_ci
COLUMNSCOLUMN_KEYvarchar(3)falsefalsetruefalseutf8utf8_general_ci
COLUMNSEXTRAvarchar(27)falsefalsetruefalseutf8utf8_general_ci
COLUMNSPRIVILEGESvarchar(80)falsefalsetruefalseutf8utf8_general_ci
COLUMNSCOLUMN_COMMENTvarchar(1024)falsefalsetruefalseutf8utf8_general_ci