CHARACTER_SETS

Name Type NULL Default Key
CHARACTER_SET_NAME varchar(64) NO
DEFAULT_COLLATE_NAME varchar(64) NO
DESCRIPTION varchar(60) NO
MAXLEN bigint(3) NO 0

COLLATIONS

Name Type NULL Default Key
COLLATION_NAME varchar(64) NO
CHARACTER_SET_NAME varchar(64) NO
ID bigint(11) NO 0
IS_DEFAULT varchar(3) NO
IS_COMPILED varchar(3) NO
SORTLEN bigint(3) NO 0

COLLATION_CHARACTER_SET_APPLICABILITY

Name Type NULL Default Key
COLLATION_NAME varchar(64) NO
CHARACTER_SET_NAME varchar(64) NO

COLUMNS

Name Type NULL Default Key
TABLE_CATALOG varchar(512) YES None
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
COLUMN_NAME varchar(64) NO
ORDINAL_POSITION bigint(21) NO 0
COLUMN_DEFAULT longtext YES None
IS_NULLABLE varchar(3) NO
DATA_TYPE varchar(64) NO
CHARACTER_MAXIMUM_LENGTH bigint(21) YES None
CHARACTER_OCTET_LENGTH bigint(21) YES None
NUMERIC_PRECISION bigint(21) YES None
NUMERIC_SCALE bigint(21) YES None
CHARACTER_SET_NAME varchar(64) YES None
COLLATION_NAME varchar(64) YES None
COLUMN_TYPE longtext NO
COLUMN_KEY varchar(3) NO
EXTRA varchar(20) NO
PRIVILEGES varchar(80) NO
COLUMN_COMMENT varchar(255) NO

COLUMN_PRIVILEGES

Name Type NULL Default Key
GRANTEE varchar(81) NO
TABLE_CATALOG varchar(512) YES None
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
COLUMN_NAME varchar(64) NO
PRIVILEGE_TYPE varchar(64) NO
IS_GRANTABLE varchar(3) NO

KEY_COLUMN_USAGE

Name Type NULL Default Key
CONSTRAINT_CATALOG varchar(512) YES None
CONSTRAINT_SCHEMA varchar(64) NO
CONSTRAINT_NAME varchar(64) NO
TABLE_CATALOG varchar(512) YES None
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
COLUMN_NAME varchar(64) NO
ORDINAL_POSITION bigint(10) NO 0
POSITION_IN_UNIQUE_CONSTRAINT bigint(10) YES None
REFERENCED_TABLE_SCHEMA varchar(64) YES None
REFERENCED_TABLE_NAME varchar(64) YES None
REFERENCED_COLUMN_NAME varchar(64) YES None

PROFILING

Name Type NULL Default Key
QUERY_ID bigint(20) NO 0
SEQ bigint(20) NO 0
STATE varchar(30) NO
DURATION varchar(9) NO
CPU_USER varchar(9) YES None
CPU_SYSTEM varchar(9) YES None
CONTEXT_VOLUNTARY bigint(20) YES None
CONTEXT_INVOLUNTARY bigint(20) YES None
BLOCK_OPS_IN bigint(20) YES None
BLOCK_OPS_OUT bigint(20) YES None
MESSAGES_SENT bigint(20) YES None
MESSAGES_RECEIVED bigint(20) YES None
PAGE_FAULTS_MAJOR bigint(20) YES None
PAGE_FAULTS_MINOR bigint(20) YES None
SWAPS bigint(20) YES None
SOURCE_FUNCTION varchar(30) YES None
SOURCE_FILE varchar(20) YES None
SOURCE_LINE bigint(20) YES None

ROUTINES

Name Type NULL Default Key
SPECIFIC_NAME varchar(64) NO
ROUTINE_CATALOG varchar(512) YES None
ROUTINE_SCHEMA varchar(64) NO
ROUTINE_NAME varchar(64) NO
ROUTINE_TYPE varchar(9) NO
DTD_IDENTIFIER varchar(64) YES None
ROUTINE_BODY varchar(8) NO
ROUTINE_DEFINITION longtext YES None
EXTERNAL_NAME varchar(64) YES None
EXTERNAL_LANGUAGE varchar(64) YES None
PARAMETER_STYLE varchar(8) NO
IS_DETERMINISTIC varchar(3) NO
SQL_DATA_ACCESS varchar(64) NO
SQL_PATH varchar(64) YES None
SECURITY_TYPE varchar(7) NO
CREATED datetime NO 0000-00-00 00:00:00
LAST_ALTERED datetime NO 0000-00-00 00:00:00
SQL_MODE longtext NO
ROUTINE_COMMENT varchar(64) NO
DEFINER varchar(77) NO

SCHEMATA

Name Type NULL Default Key
CATALOG_NAME varchar(512) YES None
SCHEMA_NAME varchar(64) NO
DEFAULT_CHARACTER_SET_NAME varchar(64) NO
DEFAULT_COLLATION_NAME varchar(64) NO
SQL_PATH varchar(512) YES None

SCHEMA_PRIVILEGES

Name Type NULL Default Key
GRANTEE varchar(81) NO
TABLE_CATALOG varchar(512) YES None
TABLE_SCHEMA varchar(64) NO
PRIVILEGE_TYPE varchar(64) NO
IS_GRANTABLE varchar(3) NO

STATISTICS

Name Type NULL Default Key
TABLE_CATALOG varchar(512) YES None
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
NON_UNIQUE bigint(1) NO 0
INDEX_SCHEMA varchar(64) NO
INDEX_NAME varchar(64) NO
SEQ_IN_INDEX bigint(2) NO 0
COLUMN_NAME varchar(64) NO
COLLATION varchar(1) YES None
CARDINALITY bigint(21) YES None
SUB_PART bigint(3) YES None
PACKED varchar(10) YES None
NULLABLE varchar(3) NO
INDEX_TYPE varchar(16) NO
COMMENT varchar(16) YES None

TABLES

Name Type NULL Default Key
TABLE_CATALOG varchar(512) YES None
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
TABLE_TYPE varchar(64) NO
ENGINE varchar(64) YES None
VERSION bigint(21) YES None
ROW_FORMAT varchar(10) YES None
TABLE_ROWS bigint(21) YES None
AVG_ROW_LENGTH bigint(21) YES None
DATA_LENGTH bigint(21) YES None
MAX_DATA_LENGTH bigint(21) YES None
INDEX_LENGTH bigint(21) YES None
DATA_FREE bigint(21) YES None
AUTO_INCREMENT bigint(21) YES None
CREATE_TIME datetime YES None
UPDATE_TIME datetime YES None
CHECK_TIME datetime YES None
TABLE_COLLATION varchar(64) YES None
CHECKSUM bigint(21) YES None
CREATE_OPTIONS varchar(255) YES None
TABLE_COMMENT varchar(80) NO

TABLE_CONSTRAINTS

Name Type NULL Default Key
CONSTRAINT_CATALOG varchar(512) YES None
CONSTRAINT_SCHEMA varchar(64) NO
CONSTRAINT_NAME varchar(64) NO
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
CONSTRAINT_TYPE varchar(64) NO

TABLE_PRIVILEGES

Name Type NULL Default Key
GRANTEE varchar(81) NO
TABLE_CATALOG varchar(512) YES None
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
PRIVILEGE_TYPE varchar(64) NO
IS_GRANTABLE varchar(3) NO

TRIGGERS

Name Type NULL Default Key
TRIGGER_CATALOG varchar(512) YES None
TRIGGER_SCHEMA varchar(64) NO
TRIGGER_NAME varchar(64) NO
EVENT_MANIPULATION varchar(6) NO
EVENT_OBJECT_CATALOG varchar(512) YES None
EVENT_OBJECT_SCHEMA varchar(64) NO
EVENT_OBJECT_TABLE varchar(64) NO
ACTION_ORDER bigint(4) NO 0
ACTION_CONDITION longtext YES None
ACTION_STATEMENT longtext NO
ACTION_ORIENTATION varchar(9) NO
ACTION_TIMING varchar(6) NO
ACTION_REFERENCE_OLD_TABLE varchar(64) YES None
ACTION_REFERENCE_NEW_TABLE varchar(64) YES None
ACTION_REFERENCE_OLD_ROW varchar(3) NO
ACTION_REFERENCE_NEW_ROW varchar(3) NO
CREATED datetime YES None
SQL_MODE longtext NO
DEFINER longtext NO

USER_PRIVILEGES

Name Type NULL Default Key
GRANTEE varchar(81) NO
TABLE_CATALOG varchar(512) YES None
PRIVILEGE_TYPE varchar(64) NO
IS_GRANTABLE varchar(3) NO

VIEWS

Name Type NULL Default Key
TABLE_CATALOG varchar(512) YES None
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
VIEW_DEFINITION longtext NO
CHECK_OPTION varchar(8) NO
IS_UPDATABLE varchar(3) NO
DEFINER varchar(77) NO
SECURITY_TYPE varchar(7) NO