🗄️ Database Browser © Nasirudin
Databases
›
information_schema
›
COLUMNS
📋 Copy ke Clipboard (Excel Format)
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
ORDINAL_POSITION
COLUMN_DEFAULT
IS_NULLABLE
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
CHARACTER_OCTET_LENGTH
NUMERIC_PRECISION
NUMERIC_SCALE
DATETIME_PRECISION
CHARACTER_SET_NAME
COLLATION_NAME
COLUMN_TYPE
COLUMN_KEY
EXTRA
PRIVILEGES
COLUMN_COMMENT
IS_GENERATED
GENERATION_EXPRESSION
def
information_schema
ALL_PLUGINS
PLUGIN_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_VERSION
2
NULL
NO
varchar
20
60
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(20)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_STATUS
3
NULL
NO
varchar
16
48
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(16)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_TYPE
4
NULL
NO
varchar
80
240
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(80)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_TYPE_VERSION
5
NULL
NO
varchar
20
60
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(20)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_LIBRARY
6
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_LIBRARY_VERSION
7
NULL
YES
varchar
20
60
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(20)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_AUTHOR
8
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_DESCRIPTION
9
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_LICENSE
10
NULL
NO
varchar
80
240
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(80)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
LOAD_OPTION
11
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_MATURITY
12
NULL
NO
varchar
12
36
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(12)
select
NEVER
NULL
def
information_schema
ALL_PLUGINS
PLUGIN_AUTH_VERSION
13
NULL
YES
varchar
80
240
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(80)
select
NEVER
NULL
def
information_schema
APPLICABLE_ROLES
GRANTEE
1
NULL
NO
varchar
385
1.155
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(385)
select
NEVER
NULL
def
information_schema
APPLICABLE_ROLES
ROLE_NAME
2
NULL
NO
varchar
128
384
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(128)
select
NEVER
NULL
def
information_schema
APPLICABLE_ROLES
IS_GRANTABLE
3
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
APPLICABLE_ROLES
IS_DEFAULT
4
NULL
YES
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
CHARACTER_SETS
CHARACTER_SET_NAME
1
NULL
NO
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
CHARACTER_SETS
DEFAULT_COLLATE_NAME
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
CHARACTER_SETS
DESCRIPTION
3
NULL
NO
varchar
60
180
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(60)
select
NEVER
NULL
def
information_schema
CHARACTER_SETS
MAXLEN
4
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(3)
select
NEVER
NULL
def
information_schema
CHECK_CONSTRAINTS
CONSTRAINT_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
CHECK_CONSTRAINTS
CONSTRAINT_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
CHECK_CONSTRAINTS
TABLE_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
CHECK_CONSTRAINTS
CONSTRAINT_NAME
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
CHECK_CONSTRAINTS
LEVEL
5
NULL
NO
varchar
6
18
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(6)
select
NEVER
NULL
def
information_schema
CHECK_CONSTRAINTS
CHECK_CLAUSE
6
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
COLLATIONS
COLLATION_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLLATIONS
CHARACTER_SET_NAME
2
NULL
YES
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
COLLATIONS
ID
3
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(11)
select
NEVER
NULL
def
information_schema
COLLATIONS
IS_DEFAULT
4
NULL
YES
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
COLLATIONS
IS_COMPILED
5
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
COLLATIONS
SORTLEN
6
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(3)
select
NEVER
NULL
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
COLLATION_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
CHARACTER_SET_NAME
2
NULL
NO
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
FULL_COLLATION_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
ID
4
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(11)
select
NEVER
NULL
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
IS_DEFAULT
5
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
COLUMNS
TABLE_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
COLUMNS
TABLE_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLUMNS
TABLE_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLUMNS
COLUMN_NAME
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLUMNS
ORDINAL_POSITION
5
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
COLUMNS
COLUMN_DEFAULT
6
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
COLUMNS
IS_NULLABLE
7
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
COLUMNS
DATA_TYPE
8
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLUMNS
CHARACTER_MAXIMUM_LENGTH
9
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
COLUMNS
CHARACTER_OCTET_LENGTH
10
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
COLUMNS
NUMERIC_PRECISION
11
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
COLUMNS
NUMERIC_SCALE
12
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
COLUMNS
DATETIME_PRECISION
13
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
COLUMNS
CHARACTER_SET_NAME
14
NULL
YES
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
COLUMNS
COLLATION_NAME
15
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLUMNS
COLUMN_TYPE
16
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
COLUMNS
COLUMN_KEY
17
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
COLUMNS
EXTRA
18
NULL
NO
varchar
80
240
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(80)
select
NEVER
NULL
def
information_schema
COLUMNS
PRIVILEGES
19
NULL
NO
varchar
80
240
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(80)
select
NEVER
NULL
def
information_schema
COLUMNS
COLUMN_COMMENT
20
NULL
NO
varchar
1.024
3.072
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1024)
select
NEVER
NULL
def
information_schema
COLUMNS
IS_GENERATED
21
NULL
NO
varchar
6
18
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(6)
select
NEVER
NULL
def
information_schema
COLUMNS
GENERATION_EXPRESSION
22
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
COLUMN_PRIVILEGES
GRANTEE
1
NULL
NO
varchar
385
1.155
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(385)
select
NEVER
NULL
def
information_schema
COLUMN_PRIVILEGES
TABLE_CATALOG
2
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
COLUMN_PRIVILEGES
TABLE_SCHEMA
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLUMN_PRIVILEGES
TABLE_NAME
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLUMN_PRIVILEGES
COLUMN_NAME
5
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLUMN_PRIVILEGES
PRIVILEGE_TYPE
6
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
COLUMN_PRIVILEGES
IS_GRANTABLE
7
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
ENABLED_ROLES
ROLE_NAME
1
NULL
YES
varchar
128
384
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(128)
select
NEVER
NULL
def
information_schema
ENGINES
ENGINE
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ENGINES
SUPPORT
2
NULL
NO
varchar
8
24
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(8)
select
NEVER
NULL
def
information_schema
ENGINES
COMMENT
3
NULL
NO
varchar
160
480
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(160)
select
NEVER
NULL
def
information_schema
ENGINES
TRANSACTIONS
4
NULL
YES
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
ENGINES
XA
5
NULL
YES
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
ENGINES
SAVEPOINTS
6
NULL
YES
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
EVENTS
EVENT_CATALOG
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
EVENTS
EVENT_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
EVENTS
EVENT_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
EVENTS
DEFINER
4
NULL
NO
varchar
384
1.152
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(384)
select
NEVER
NULL
def
information_schema
EVENTS
TIME_ZONE
5
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
EVENTS
EVENT_BODY
6
NULL
NO
varchar
8
24
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(8)
select
NEVER
NULL
def
information_schema
EVENTS
EVENT_DEFINITION
7
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
EVENTS
EVENT_TYPE
8
NULL
NO
varchar
9
27
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(9)
select
NEVER
NULL
def
information_schema
EVENTS
EXECUTE_AT
9
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
EVENTS
INTERVAL_VALUE
10
NULL
YES
varchar
256
768
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(256)
select
NEVER
NULL
def
information_schema
EVENTS
INTERVAL_FIELD
11
NULL
YES
varchar
18
54
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(18)
select
NEVER
NULL
def
information_schema
EVENTS
SQL_MODE
12
NULL
NO
varchar
8.192
24.576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(8192)
select
NEVER
NULL
def
information_schema
EVENTS
STARTS
13
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
EVENTS
ENDS
14
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
EVENTS
STATUS
15
NULL
NO
varchar
18
54
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(18)
select
NEVER
NULL
def
information_schema
EVENTS
ON_COMPLETION
16
NULL
NO
varchar
12
36
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(12)
select
NEVER
NULL
def
information_schema
EVENTS
CREATED
17
NULL
NO
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
EVENTS
LAST_ALTERED
18
NULL
NO
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
EVENTS
LAST_EXECUTED
19
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
EVENTS
EVENT_COMMENT
20
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
EVENTS
ORIGINATOR
21
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(10)
select
NEVER
NULL
def
information_schema
EVENTS
CHARACTER_SET_CLIENT
22
NULL
NO
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
EVENTS
COLLATION_CONNECTION
23
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
EVENTS
DATABASE_COLLATION
24
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
FILES
FILE_ID
1
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
FILES
FILE_NAME
2
NULL
YES
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
FILES
FILE_TYPE
3
NULL
NO
varchar
20
60
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(20)
select
NEVER
NULL
def
information_schema
FILES
TABLESPACE_NAME
4
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
FILES
TABLE_CATALOG
5
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
FILES
TABLE_SCHEMA
6
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
FILES
TABLE_NAME
7
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
FILES
LOGFILE_GROUP_NAME
8
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
FILES
LOGFILE_GROUP_NUMBER
9
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
FILES
ENGINE
10
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
FILES
FULLTEXT_KEYS
11
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
FILES
DELETED_ROWS
12
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
FILES
UPDATE_COUNT
13
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
FILES
FREE_EXTENTS
14
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
FILES
TOTAL_EXTENTS
15
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
FILES
EXTENT_SIZE
16
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
FILES
INITIAL_SIZE
17
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
MAXIMUM_SIZE
18
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
AUTOEXTEND_SIZE
19
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
CREATION_TIME
20
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
FILES
LAST_UPDATE_TIME
21
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
FILES
LAST_ACCESS_TIME
22
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
FILES
RECOVER_TIME
23
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
FILES
TRANSACTION_COUNTER
24
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
FILES
VERSION
25
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
ROW_FORMAT
26
NULL
YES
varchar
10
30
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(10)
select
NEVER
NULL
def
information_schema
FILES
TABLE_ROWS
27
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
AVG_ROW_LENGTH
28
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
DATA_LENGTH
29
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
MAX_DATA_LENGTH
30
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
INDEX_LENGTH
31
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
DATA_FREE
32
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
CREATE_TIME
33
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
FILES
UPDATE_TIME
34
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
FILES
CHECK_TIME
35
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
FILES
CHECKSUM
36
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
FILES
STATUS
37
NULL
NO
varchar
20
60
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(20)
select
NEVER
NULL
def
information_schema
FILES
EXTRA
38
NULL
YES
varchar
255
765
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(255)
select
NEVER
NULL
def
information_schema
GLOBAL_STATUS
VARIABLE_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
GLOBAL_STATUS
VARIABLE_VALUE
2
NULL
NO
varchar
4.096
12.288
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(4096)
select
NEVER
NULL
def
information_schema
GLOBAL_VARIABLES
VARIABLE_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
GLOBAL_VARIABLES
VARIABLE_VALUE
2
NULL
NO
varchar
4.096
12.288
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(4096)
select
NEVER
NULL
def
information_schema
KEYWORDS
WORD
1
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
KEY_CACHES
KEY_CACHE_NAME
1
NULL
NO
varchar
192
576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(192)
select
NEVER
NULL
def
information_schema
KEY_CACHES
SEGMENTS
2
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(3) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
SEGMENT_NUMBER
3
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(3) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
FULL_SIZE
4
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
BLOCK_SIZE
5
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
USED_BLOCKS
6
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
UNUSED_BLOCKS
7
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
DIRTY_BLOCKS
8
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
READ_REQUESTS
9
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
READS
10
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
WRITE_REQUESTS
11
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
KEY_CACHES
WRITES
12
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
CONSTRAINT_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
CONSTRAINT_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
CONSTRAINT_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
TABLE_CATALOG
4
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
TABLE_SCHEMA
5
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
TABLE_NAME
6
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
COLUMN_NAME
7
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
ORDINAL_POSITION
8
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(10)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
POSITION_IN_UNIQUE_CONSTRAINT
9
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(10)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
REFERENCED_TABLE_SCHEMA
10
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
REFERENCED_TABLE_NAME
11
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
KEY_COLUMN_USAGE
REFERENCED_COLUMN_NAME
12
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
OPTIMIZER_TRACE
QUERY
1
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
OPTIMIZER_TRACE
TRACE
2
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
OPTIMIZER_TRACE
MISSING_BYTES_BEYOND_MAX_MEM_SIZE
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
OPTIMIZER_TRACE
INSUFFICIENT_PRIVILEGES
4
NULL
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(1)
select
NEVER
NULL
def
information_schema
PARAMETERS
SPECIFIC_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
PARAMETERS
SPECIFIC_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARAMETERS
SPECIFIC_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARAMETERS
ORDINAL_POSITION
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(21)
select
NEVER
NULL
def
information_schema
PARAMETERS
PARAMETER_MODE
5
NULL
YES
varchar
5
15
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(5)
select
NEVER
NULL
def
information_schema
PARAMETERS
PARAMETER_NAME
6
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARAMETERS
DATA_TYPE
7
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARAMETERS
CHARACTER_MAXIMUM_LENGTH
8
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(21)
select
NEVER
NULL
def
information_schema
PARAMETERS
CHARACTER_OCTET_LENGTH
9
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(21)
select
NEVER
NULL
def
information_schema
PARAMETERS
NUMERIC_PRECISION
10
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(21)
select
NEVER
NULL
def
information_schema
PARAMETERS
NUMERIC_SCALE
11
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(21)
select
NEVER
NULL
def
information_schema
PARAMETERS
DATETIME_PRECISION
12
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARAMETERS
CHARACTER_SET_NAME
13
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARAMETERS
COLLATION_NAME
14
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARAMETERS
DTD_IDENTIFIER
15
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
PARAMETERS
ROUTINE_TYPE
16
NULL
NO
varchar
9
27
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(9)
select
NEVER
NULL
def
information_schema
PARTITIONS
TABLE_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
PARTITIONS
TABLE_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARTITIONS
TABLE_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARTITIONS
PARTITION_NAME
4
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARTITIONS
SUBPARTITION_NAME
5
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PARTITIONS
PARTITION_ORDINAL_POSITION
6
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARTITIONS
SUBPARTITION_ORDINAL_POSITION
7
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARTITIONS
PARTITION_METHOD
8
NULL
YES
varchar
18
54
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(18)
select
NEVER
NULL
def
information_schema
PARTITIONS
SUBPARTITION_METHOD
9
NULL
YES
varchar
12
36
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(12)
select
NEVER
NULL
def
information_schema
PARTITIONS
PARTITION_EXPRESSION
10
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
PARTITIONS
SUBPARTITION_EXPRESSION
11
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
PARTITIONS
PARTITION_DESCRIPTION
12
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
PARTITIONS
TABLE_ROWS
13
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARTITIONS
AVG_ROW_LENGTH
14
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARTITIONS
DATA_LENGTH
15
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARTITIONS
MAX_DATA_LENGTH
16
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARTITIONS
INDEX_LENGTH
17
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARTITIONS
DATA_FREE
18
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARTITIONS
CREATE_TIME
19
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
PARTITIONS
UPDATE_TIME
20
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
PARTITIONS
CHECK_TIME
21
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
PARTITIONS
CHECKSUM
22
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
PARTITIONS
PARTITION_COMMENT
23
NULL
NO
varchar
80
240
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(80)
select
NEVER
NULL
def
information_schema
PARTITIONS
NODEGROUP
24
NULL
NO
varchar
12
36
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(12)
select
NEVER
NULL
def
information_schema
PARTITIONS
TABLESPACE_NAME
25
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_VERSION
2
NULL
NO
varchar
20
60
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(20)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_STATUS
3
NULL
NO
varchar
16
48
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(16)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_TYPE
4
NULL
NO
varchar
80
240
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(80)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_TYPE_VERSION
5
NULL
NO
varchar
20
60
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(20)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_LIBRARY
6
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_LIBRARY_VERSION
7
NULL
YES
varchar
20
60
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(20)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_AUTHOR
8
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_DESCRIPTION
9
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_LICENSE
10
NULL
NO
varchar
80
240
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(80)
select
NEVER
NULL
def
information_schema
PLUGINS
LOAD_OPTION
11
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_MATURITY
12
NULL
NO
varchar
12
36
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(12)
select
NEVER
NULL
def
information_schema
PLUGINS
PLUGIN_AUTH_VERSION
13
NULL
YES
varchar
80
240
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(80)
select
NEVER
NULL
def
information_schema
PROCESSLIST
ID
1
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
PROCESSLIST
USER
2
NULL
NO
varchar
128
384
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(128)
select
NEVER
NULL
def
information_schema
PROCESSLIST
HOST
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PROCESSLIST
DB
4
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PROCESSLIST
COMMAND
5
NULL
NO
varchar
16
48
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(16)
select
NEVER
NULL
def
information_schema
PROCESSLIST
TIME
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(7)
select
NEVER
NULL
def
information_schema
PROCESSLIST
STATE
7
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
PROCESSLIST
INFO
8
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
PROCESSLIST
TIME_MS
9
NULL
NO
decimal
NULL
NULL
22
3
NULL
NULL
NULL
decimal(22,3)
select
NEVER
NULL
def
information_schema
PROCESSLIST
STAGE
10
NULL
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(2)
select
NEVER
NULL
def
information_schema
PROCESSLIST
MAX_STAGE
11
NULL
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(2)
select
NEVER
NULL
def
information_schema
PROCESSLIST
PROGRESS
12
NULL
NO
decimal
NULL
NULL
7
3
NULL
NULL
NULL
decimal(7,3)
select
NEVER
NULL
def
information_schema
PROCESSLIST
MEMORY_USED
13
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(7)
select
NEVER
NULL
def
information_schema
PROCESSLIST
MAX_MEMORY_USED
14
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(7)
select
NEVER
NULL
def
information_schema
PROCESSLIST
EXAMINED_ROWS
15
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(7)
select
NEVER
NULL
def
information_schema
PROCESSLIST
QUERY_ID
16
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
PROCESSLIST
INFO_BINARY
17
NULL
YES
blob
65.535
65.535
NULL
NULL
NULL
NULL
NULL
blob
select
NEVER
NULL
def
information_schema
PROCESSLIST
TID
18
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
PROFILING
QUERY_ID
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
SEQ
2
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
STATE
3
NULL
NO
varchar
30
90
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(30)
select
NEVER
NULL
def
information_schema
PROFILING
DURATION
4
NULL
NO
decimal
NULL
NULL
9
6
NULL
NULL
NULL
decimal(9,6)
select
NEVER
NULL
def
information_schema
PROFILING
CPU_USER
5
NULL
YES
decimal
NULL
NULL
9
6
NULL
NULL
NULL
decimal(9,6)
select
NEVER
NULL
def
information_schema
PROFILING
CPU_SYSTEM
6
NULL
YES
decimal
NULL
NULL
9
6
NULL
NULL
NULL
decimal(9,6)
select
NEVER
NULL
def
information_schema
PROFILING
CONTEXT_VOLUNTARY
7
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
CONTEXT_INVOLUNTARY
8
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
BLOCK_OPS_IN
9
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
BLOCK_OPS_OUT
10
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
MESSAGES_SENT
11
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
MESSAGES_RECEIVED
12
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
PAGE_FAULTS_MAJOR
13
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
PAGE_FAULTS_MINOR
14
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
SWAPS
15
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
PROFILING
SOURCE_FUNCTION
16
NULL
YES
varchar
30
90
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(30)
select
NEVER
NULL
def
information_schema
PROFILING
SOURCE_FILE
17
NULL
YES
varchar
20
60
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(20)
select
NEVER
NULL
def
information_schema
PROFILING
SOURCE_LINE
18
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(20)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
CONSTRAINT_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
CONSTRAINT_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
CONSTRAINT_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
UNIQUE_CONSTRAINT_CATALOG
4
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
UNIQUE_CONSTRAINT_SCHEMA
5
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
UNIQUE_CONSTRAINT_NAME
6
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
MATCH_OPTION
7
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
UPDATE_RULE
8
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
DELETE_RULE
9
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
TABLE_NAME
10
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
REFERENTIAL_CONSTRAINTS
REFERENCED_TABLE_NAME
11
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
SPECIFIC_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
ROUTINE_CATALOG
2
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
ROUTINES
ROUTINE_SCHEMA
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
ROUTINE_NAME
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
ROUTINE_TYPE
5
NULL
NO
varchar
13
39
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(13)
select
NEVER
NULL
def
information_schema
ROUTINES
DATA_TYPE
6
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
CHARACTER_MAXIMUM_LENGTH
7
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(21)
select
NEVER
NULL
def
information_schema
ROUTINES
CHARACTER_OCTET_LENGTH
8
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(21)
select
NEVER
NULL
def
information_schema
ROUTINES
NUMERIC_PRECISION
9
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(21)
select
NEVER
NULL
def
information_schema
ROUTINES
NUMERIC_SCALE
10
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(21)
select
NEVER
NULL
def
information_schema
ROUTINES
DATETIME_PRECISION
11
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
ROUTINES
CHARACTER_SET_NAME
12
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
COLLATION_NAME
13
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
DTD_IDENTIFIER
14
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
ROUTINES
ROUTINE_BODY
15
NULL
NO
varchar
8
24
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(8)
select
NEVER
NULL
def
information_schema
ROUTINES
ROUTINE_DEFINITION
16
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
ROUTINES
EXTERNAL_NAME
17
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
EXTERNAL_LANGUAGE
18
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
PARAMETER_STYLE
19
NULL
NO
varchar
8
24
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(8)
select
NEVER
NULL
def
information_schema
ROUTINES
IS_DETERMINISTIC
20
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
ROUTINES
SQL_DATA_ACCESS
21
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
SQL_PATH
22
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
SECURITY_TYPE
23
NULL
NO
varchar
7
21
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(7)
select
NEVER
NULL
def
information_schema
ROUTINES
CREATED
24
NULL
NO
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
ROUTINES
LAST_ALTERED
25
NULL
NO
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
ROUTINES
SQL_MODE
26
NULL
NO
varchar
8.192
24.576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(8192)
select
NEVER
NULL
def
information_schema
ROUTINES
ROUTINE_COMMENT
27
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
ROUTINES
DEFINER
28
NULL
NO
varchar
384
1.152
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(384)
select
NEVER
NULL
def
information_schema
ROUTINES
CHARACTER_SET_CLIENT
29
NULL
NO
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
ROUTINES
COLLATION_CONNECTION
30
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
ROUTINES
DATABASE_COLLATION
31
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SCHEMATA
CATALOG_NAME
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
SCHEMATA
SCHEMA_NAME
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SCHEMATA
DEFAULT_CHARACTER_SET_NAME
3
NULL
NO
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
SCHEMATA
DEFAULT_COLLATION_NAME
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SCHEMATA
SQL_PATH
5
NULL
YES
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
SCHEMATA
SCHEMA_COMMENT
6
NULL
NO
varchar
1.024
3.072
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1024)
select
NEVER
NULL
def
information_schema
SCHEMA_PRIVILEGES
GRANTEE
1
NULL
NO
varchar
385
1.155
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(385)
select
NEVER
NULL
def
information_schema
SCHEMA_PRIVILEGES
TABLE_CATALOG
2
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
SCHEMA_PRIVILEGES
TABLE_SCHEMA
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SCHEMA_PRIVILEGES
PRIVILEGE_TYPE
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SCHEMA_PRIVILEGES
IS_GRANTABLE
5
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
SESSION_STATUS
VARIABLE_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SESSION_STATUS
VARIABLE_VALUE
2
NULL
NO
varchar
4.096
12.288
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(4096)
select
NEVER
NULL
def
information_schema
SESSION_VARIABLES
VARIABLE_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SESSION_VARIABLES
VARIABLE_VALUE
2
NULL
NO
varchar
4.096
12.288
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(4096)
select
NEVER
NULL
def
information_schema
STATISTICS
TABLE_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
STATISTICS
TABLE_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
STATISTICS
TABLE_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
STATISTICS
NON_UNIQUE
4
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(1)
select
NEVER
NULL
def
information_schema
STATISTICS
INDEX_SCHEMA
5
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
STATISTICS
INDEX_NAME
6
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
STATISTICS
SEQ_IN_INDEX
7
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(2) unsigned
select
NEVER
NULL
def
information_schema
STATISTICS
COLUMN_NAME
8
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
STATISTICS
COLLATION
9
NULL
YES
varchar
1
3
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1)
select
NEVER
NULL
def
information_schema
STATISTICS
CARDINALITY
10
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
STATISTICS
SUB_PART
11
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(3)
select
NEVER
NULL
def
information_schema
STATISTICS
PACKED
12
NULL
YES
varchar
10
30
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(10)
select
NEVER
NULL
def
information_schema
STATISTICS
NULLABLE
13
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
STATISTICS
INDEX_TYPE
14
NULL
NO
varchar
16
48
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(16)
select
NEVER
NULL
def
information_schema
STATISTICS
COMMENT
15
NULL
YES
varchar
16
48
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(16)
select
NEVER
NULL
def
information_schema
STATISTICS
INDEX_COMMENT
16
NULL
NO
varchar
1.024
3.072
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1024)
select
NEVER
NULL
def
information_schema
STATISTICS
IGNORED
17
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
SQL_FUNCTIONS
FUNCTION
1
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
VARIABLE_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
SESSION_VALUE
2
NULL
YES
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
GLOBAL_VALUE
3
NULL
YES
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
GLOBAL_VALUE_ORIGIN
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
DEFAULT_VALUE
5
NULL
YES
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
VARIABLE_SCOPE
6
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
VARIABLE_TYPE
7
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
VARIABLE_COMMENT
8
NULL
NO
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
NUMERIC_MIN_VALUE
9
NULL
YES
varchar
21
63
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(21)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
NUMERIC_MAX_VALUE
10
NULL
YES
varchar
21
63
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(21)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
NUMERIC_BLOCK_SIZE
11
NULL
YES
varchar
21
63
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(21)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
ENUM_VALUE_LIST
12
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
READ_ONLY
13
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
COMMAND_LINE_ARGUMENT
14
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
SYSTEM_VARIABLES
GLOBAL_VALUE_PATH
15
NULL
YES
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
TABLES
TABLE_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
TABLES
TABLE_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLES
TABLE_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLES
TABLE_TYPE
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLES
ENGINE
5
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLES
VERSION
6
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
ROW_FORMAT
7
NULL
YES
varchar
10
30
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(10)
select
NEVER
NULL
def
information_schema
TABLES
TABLE_ROWS
8
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
AVG_ROW_LENGTH
9
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
DATA_LENGTH
10
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
MAX_DATA_LENGTH
11
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
INDEX_LENGTH
12
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
DATA_FREE
13
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
AUTO_INCREMENT
14
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
CREATE_TIME
15
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
TABLES
UPDATE_TIME
16
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
TABLES
CHECK_TIME
17
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
TABLES
TABLE_COLLATION
18
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLES
CHECKSUM
19
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
CREATE_OPTIONS
20
NULL
YES
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
TABLES
TABLE_COMMENT
21
NULL
NO
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
TABLES
MAX_INDEX_LENGTH
22
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLES
TEMPORARY
23
NULL
YES
varchar
1
3
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1)
select
NEVER
NULL
def
information_schema
TABLESPACES
TABLESPACE_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLESPACES
ENGINE
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLESPACES
TABLESPACE_TYPE
3
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLESPACES
LOGFILE_GROUP_NAME
4
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLESPACES
EXTENT_SIZE
5
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLESPACES
AUTOEXTEND_SIZE
6
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLESPACES
MAXIMUM_SIZE
7
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLESPACES
NODEGROUP_ID
8
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
TABLESPACES
TABLESPACE_COMMENT
9
NULL
YES
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
TABLE_CONSTRAINTS
CONSTRAINT_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
TABLE_CONSTRAINTS
CONSTRAINT_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLE_CONSTRAINTS
CONSTRAINT_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLE_CONSTRAINTS
TABLE_SCHEMA
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLE_CONSTRAINTS
TABLE_NAME
5
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLE_CONSTRAINTS
CONSTRAINT_TYPE
6
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLE_PRIVILEGES
GRANTEE
1
NULL
NO
varchar
385
1.155
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(385)
select
NEVER
NULL
def
information_schema
TABLE_PRIVILEGES
TABLE_CATALOG
2
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
TABLE_PRIVILEGES
TABLE_SCHEMA
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLE_PRIVILEGES
TABLE_NAME
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLE_PRIVILEGES
PRIVILEGE_TYPE
5
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TABLE_PRIVILEGES
IS_GRANTABLE
6
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
TRIGGERS
TRIGGER_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
TRIGGERS
TRIGGER_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TRIGGERS
TRIGGER_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TRIGGERS
EVENT_MANIPULATION
4
NULL
NO
varchar
6
18
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(6)
select
NEVER
NULL
def
information_schema
TRIGGERS
EVENT_OBJECT_CATALOG
5
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
TRIGGERS
EVENT_OBJECT_SCHEMA
6
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TRIGGERS
EVENT_OBJECT_TABLE
7
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TRIGGERS
ACTION_ORDER
8
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(4)
select
NEVER
NULL
def
information_schema
TRIGGERS
ACTION_CONDITION
9
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
TRIGGERS
ACTION_STATEMENT
10
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
TRIGGERS
ACTION_ORIENTATION
11
NULL
NO
varchar
9
27
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(9)
select
NEVER
NULL
def
information_schema
TRIGGERS
ACTION_TIMING
12
NULL
NO
varchar
6
18
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(6)
select
NEVER
NULL
def
information_schema
TRIGGERS
ACTION_REFERENCE_OLD_TABLE
13
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TRIGGERS
ACTION_REFERENCE_NEW_TABLE
14
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TRIGGERS
ACTION_REFERENCE_OLD_ROW
15
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
TRIGGERS
ACTION_REFERENCE_NEW_ROW
16
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
TRIGGERS
CREATED
17
NULL
YES
datetime
NULL
NULL
NULL
NULL
2
NULL
NULL
datetime(2)
select
NEVER
NULL
def
information_schema
TRIGGERS
SQL_MODE
18
NULL
NO
varchar
8.192
24.576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(8192)
select
NEVER
NULL
def
information_schema
TRIGGERS
DEFINER
19
NULL
NO
varchar
384
1.152
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(384)
select
NEVER
NULL
def
information_schema
TRIGGERS
CHARACTER_SET_CLIENT
20
NULL
NO
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
TRIGGERS
COLLATION_CONNECTION
21
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
TRIGGERS
DATABASE_COLLATION
22
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
USER_PRIVILEGES
GRANTEE
1
NULL
NO
varchar
385
1.155
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(385)
select
NEVER
NULL
def
information_schema
USER_PRIVILEGES
TABLE_CATALOG
2
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
USER_PRIVILEGES
PRIVILEGE_TYPE
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
USER_PRIVILEGES
IS_GRANTABLE
4
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
VIEWS
TABLE_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
VIEWS
TABLE_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
VIEWS
TABLE_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
VIEWS
VIEW_DEFINITION
4
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
longtext
select
NEVER
NULL
def
information_schema
VIEWS
CHECK_OPTION
5
NULL
NO
varchar
8
24
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(8)
select
NEVER
NULL
def
information_schema
VIEWS
IS_UPDATABLE
6
NULL
NO
varchar
3
9
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(3)
select
NEVER
NULL
def
information_schema
VIEWS
DEFINER
7
NULL
NO
varchar
384
1.152
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(384)
select
NEVER
NULL
def
information_schema
VIEWS
SECURITY_TYPE
8
NULL
NO
varchar
7
21
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(7)
select
NEVER
NULL
def
information_schema
VIEWS
CHARACTER_SET_CLIENT
9
NULL
NO
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
VIEWS
COLLATION_CONNECTION
10
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
VIEWS
ALGORITHM
11
NULL
NO
varchar
10
30
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(10)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
CLIENT
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
TOTAL_CONNECTIONS
2
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
CONCURRENT_CONNECTIONS
3
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
CONNECTED_TIME
4
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
BUSY_TIME
5
NULL
NO
double
NULL
NULL
21
NULL
NULL
NULL
NULL
double
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
CPU_TIME
6
NULL
NO
double
NULL
NULL
21
NULL
NULL
NULL
NULL
double
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
BYTES_RECEIVED
7
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
BYTES_SENT
8
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
BINLOG_BYTES_WRITTEN
9
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
ROWS_READ
10
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
ROWS_SENT
11
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
ROWS_DELETED
12
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
ROWS_INSERTED
13
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
ROWS_UPDATED
14
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
SELECT_COMMANDS
15
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
UPDATE_COMMANDS
16
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
OTHER_COMMANDS
17
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
COMMIT_TRANSACTIONS
18
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
ROLLBACK_TRANSACTIONS
19
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
DENIED_CONNECTIONS
20
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
LOST_CONNECTIONS
21
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
ACCESS_DENIED
22
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
EMPTY_QUERIES
23
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
TOTAL_SSL_CONNECTIONS
24
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
CLIENT_STATISTICS
MAX_STATEMENT_TIME_EXCEEDED
25
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INDEX_STATISTICS
TABLE_SCHEMA
1
NULL
NO
varchar
192
576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(192)
select
NEVER
NULL
def
information_schema
INDEX_STATISTICS
TABLE_NAME
2
NULL
NO
varchar
192
576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(192)
select
NEVER
NULL
def
information_schema
INDEX_STATISTICS
INDEX_NAME
3
NULL
NO
varchar
192
576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(192)
select
NEVER
NULL
def
information_schema
INDEX_STATISTICS
ROWS_READ
4
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_FT_CONFIG
KEY
1
NULL
NO
varchar
193
579
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(193)
select
NEVER
NULL
def
information_schema
INNODB_FT_CONFIG
VALUE
2
NULL
NO
varchar
193
579
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(193)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
F_TABLE_CATALOG
1
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
F_TABLE_SCHEMA
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
F_TABLE_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
F_GEOMETRY_COLUMN
4
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
G_TABLE_CATALOG
5
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
G_TABLE_SCHEMA
6
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
G_TABLE_NAME
7
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
G_GEOMETRY_COLUMN
8
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
STORAGE_TYPE
9
NULL
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(2)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
GEOMETRY_TYPE
10
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(7)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
COORD_DIMENSION
11
NULL
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(2)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
MAX_PPR
12
NULL
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(2)
select
NEVER
NULL
def
information_schema
GEOMETRY_COLUMNS
SRID
13
NULL
NO
smallint
NULL
NULL
5
0
NULL
NULL
NULL
smallint(5)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESTATS
TABLE_ID
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESTATS
NAME
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESTATS
STATS_INITIALIZED
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESTATS
NUM_ROWS
4
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESTATS
CLUST_INDEX_SIZE
5
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESTATS
OTHER_INDEX_SIZE
6
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESTATS
MODIFIED_COUNTER
7
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESTATS
AUTOINC
8
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESTATS
REF_COUNT
9
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
SPATIAL_REF_SYS
SRID
1
NULL
NO
smallint
NULL
NULL
5
0
NULL
NULL
NULL
smallint(5)
select
NEVER
NULL
def
information_schema
SPATIAL_REF_SYS
AUTH_NAME
2
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
SPATIAL_REF_SYS
AUTH_SRID
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(5)
select
NEVER
NULL
def
information_schema
SPATIAL_REF_SYS
SRTEXT
4
NULL
NO
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
USER
1
NULL
NO
varchar
128
384
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(128)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
TOTAL_CONNECTIONS
2
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
CONCURRENT_CONNECTIONS
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
CONNECTED_TIME
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
BUSY_TIME
5
NULL
NO
double
NULL
NULL
21
NULL
NULL
NULL
NULL
double
select
NEVER
NULL
def
information_schema
USER_STATISTICS
CPU_TIME
6
NULL
NO
double
NULL
NULL
21
NULL
NULL
NULL
NULL
double
select
NEVER
NULL
def
information_schema
USER_STATISTICS
BYTES_RECEIVED
7
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
BYTES_SENT
8
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
BINLOG_BYTES_WRITTEN
9
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
ROWS_READ
10
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
ROWS_SENT
11
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
ROWS_DELETED
12
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
ROWS_INSERTED
13
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
ROWS_UPDATED
14
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
SELECT_COMMANDS
15
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
UPDATE_COMMANDS
16
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
OTHER_COMMANDS
17
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
COMMIT_TRANSACTIONS
18
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
ROLLBACK_TRANSACTIONS
19
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
DENIED_CONNECTIONS
20
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
LOST_CONNECTIONS
21
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
ACCESS_DENIED
22
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
EMPTY_QUERIES
23
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
USER_STATISTICS
TOTAL_SSL_CONNECTIONS
24
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
USER_STATISTICS
MAX_STATEMENT_TIME_EXCEEDED
25
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_state
2
NULL
NO
varchar
13
39
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(13)
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_started
3
NULL
NO
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_requested_lock_id
4
NULL
YES
varchar
81
243
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(81)
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_wait_started
5
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_weight
6
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_mysql_thread_id
7
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_query
8
NULL
YES
varchar
1.024
3.072
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1024)
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_operation_state
9
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_tables_in_use
10
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_tables_locked
11
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_lock_structs
12
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_lock_memory_bytes
13
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_rows_locked
14
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_rows_modified
15
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_concurrency_tickets
16
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_isolation_level
17
NULL
NO
enum
5
16
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
enum('READ UNCOMMITTED','READ COMMITTED','REPEATABLE READ','SERIALIZABLE')
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_unique_checks
18
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_foreign_key_checks
19
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_last_foreign_key_error
20
NULL
YES
varchar
256
768
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(256)
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_is_read_only
21
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_TRX
trx_autocommit_non_locking
22
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX
database_name
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX
table_name
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX
index_name
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX
compress_ops
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX
compress_ops_ok
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX
compress_time
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX
uncompress_ops
7
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX
uncompress_time
8
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
NAME
1
NULL
NO
varchar
193
579
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(193)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
SUBSYSTEM
2
NULL
NO
varchar
193
579
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(193)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
COUNT
3
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
MAX_COUNT
4
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
MIN_COUNT
5
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
AVG_COUNT
6
NULL
YES
float
NULL
NULL
12
NULL
NULL
NULL
NULL
float
select
NEVER
NULL
def
information_schema
INNODB_METRICS
COUNT_RESET
7
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
MAX_COUNT_RESET
8
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
MIN_COUNT_RESET
9
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
AVG_COUNT_RESET
10
NULL
YES
float
NULL
NULL
12
NULL
NULL
NULL
NULL
float
select
NEVER
NULL
def
information_schema
INNODB_METRICS
TIME_ENABLED
11
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
INNODB_METRICS
TIME_DISABLED
12
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
INNODB_METRICS
TIME_ELAPSED
13
NULL
YES
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
TIME_RESET
14
NULL
YES
datetime
NULL
NULL
NULL
NULL
0
NULL
NULL
datetime
select
NEVER
NULL
def
information_schema
INNODB_METRICS
ENABLED
15
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_METRICS
TYPE
16
NULL
NO
enum
4
14
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
enum('value','status_counter','set_owner','set_member','counter')
select
NEVER
NULL
def
information_schema
INNODB_METRICS
COMMENT
17
NULL
NO
varchar
193
579
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(193)
select
NEVER
NULL
def
information_schema
INNODB_FT_DELETED
DOC_ID
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_CMP
page_size
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(5)
select
NEVER
NULL
def
information_schema
INNODB_CMP
compress_ops
2
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP
compress_ops_ok
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP
compress_time
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP
uncompress_ops
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP
uncompress_time
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
THREAD_POOL_WAITS
REASON
1
NULL
NO
varchar
16
48
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(16)
select
NEVER
NULL
def
information_schema
THREAD_POOL_WAITS
COUNT
2
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
INNODB_CMP_RESET
page_size
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(5)
select
NEVER
NULL
def
information_schema
INNODB_CMP_RESET
compress_ops
2
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_RESET
compress_ops_ok
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_RESET
compress_time
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_RESET
uncompress_ops
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_RESET
uncompress_time
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
THREAD_POOL_QUEUES
GROUP_ID
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(6)
select
NEVER
NULL
def
information_schema
THREAD_POOL_QUEUES
POSITION
2
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(6)
select
NEVER
NULL
def
information_schema
THREAD_POOL_QUEUES
PRIORITY
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
THREAD_POOL_QUEUES
CONNECTION_ID
4
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(19) unsigned
select
NEVER
NULL
def
information_schema
THREAD_POOL_QUEUES
QUEUEING_TIME_MICROSECONDS
5
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
TABLE_STATISTICS
TABLE_SCHEMA
1
NULL
NO
varchar
192
576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(192)
select
NEVER
NULL
def
information_schema
TABLE_STATISTICS
TABLE_NAME
2
NULL
NO
varchar
192
576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(192)
select
NEVER
NULL
def
information_schema
TABLE_STATISTICS
ROWS_READ
3
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
TABLE_STATISTICS
ROWS_CHANGED
4
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
TABLE_STATISTICS
ROWS_CHANGED_X_INDEXES
5
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_SYS_FIELDS
INDEX_ID
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_FIELDS
NAME
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_SYS_FIELDS
POS
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
POOL_ID
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
LRU_POSITION
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
SPACE
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
PAGE_NUMBER
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
PAGE_TYPE
5
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
FLUSH_TYPE
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
FIX_COUNT
7
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
IS_HASHED
8
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
NEWEST_MODIFICATION
9
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
OLDEST_MODIFICATION
10
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
ACCESS_TIME
11
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
TABLE_NAME
12
NULL
YES
varchar
1.024
3.072
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1024)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
INDEX_NAME
13
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
NUMBER_RECORDS
14
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
DATA_SIZE
15
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
COMPRESSED_SIZE
16
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
COMPRESSED
17
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
IO_FIX
18
NULL
NO
enum
2
8
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
enum('IO_NONE','IO_READ','IO_WRITE')
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
IS_OLD
19
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE_LRU
FREE_PAGE_CLOCK
20
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_id
1
NULL
NO
varchar
81
243
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(81)
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_trx_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_mode
3
NULL
NO
enum
2
8
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
enum('S','S,GAP','X','X,GAP','IS','IS,GAP','IX','IX,GAP','AUTO_INC')
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_type
4
NULL
NO
enum
2
6
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
enum('RECORD','TABLE')
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_table
5
NULL
NO
varchar
1.024
3.072
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1024)
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_index
6
NULL
YES
varchar
1.024
3.072
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1024)
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_space
7
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_page
8
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_rec
9
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_LOCKS
lock_data
10
NULL
YES
varchar
8.192
24.576
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(8192)
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_TABLE
WORD
1
NULL
NO
varchar
337
1.011
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(337)
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_TABLE
FIRST_DOC_ID
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_TABLE
LAST_DOC_ID
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_TABLE
DOC_COUNT
4
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_TABLE
DOC_ID
5
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_TABLE
POSITION
6
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM
page_size
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(5)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM
buffer_pool_instance
2
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM
pages_used
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM
pages_free
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM
relocation_ops
5
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM
relocation_time
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
THREAD_POOL_GROUPS
GROUP_ID
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(6)
select
NEVER
NULL
def
information_schema
THREAD_POOL_GROUPS
CONNECTIONS
2
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(6)
select
NEVER
NULL
def
information_schema
THREAD_POOL_GROUPS
THREADS
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(6)
select
NEVER
NULL
def
information_schema
THREAD_POOL_GROUPS
ACTIVE_THREADS
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(6)
select
NEVER
NULL
def
information_schema
THREAD_POOL_GROUPS
STANDBY_THREADS
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(6)
select
NEVER
NULL
def
information_schema
THREAD_POOL_GROUPS
QUEUE_LENGTH
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(6)
select
NEVER
NULL
def
information_schema
THREAD_POOL_GROUPS
HAS_LISTENER
7
NULL
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(1)
select
NEVER
NULL
def
information_schema
THREAD_POOL_GROUPS
IS_STALLED
8
NULL
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(1)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX_RESET
database_name
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX_RESET
table_name
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX_RESET
index_name
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX_RESET
compress_ops
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX_RESET
compress_ops_ok
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX_RESET
compress_time
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX_RESET
uncompress_ops
7
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMP_PER_INDEX_RESET
uncompress_time
8
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_SYS_FOREIGN_COLS
ID
1
NULL
NO
varchar
193
579
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(193)
select
NEVER
NULL
def
information_schema
INNODB_SYS_FOREIGN_COLS
FOR_COL_NAME
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_SYS_FOREIGN_COLS
REF_COL_NAME
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_SYS_FOREIGN_COLS
POS
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_CACHE
WORD
1
NULL
NO
varchar
337
1.011
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(337)
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_CACHE
FIRST_DOC_ID
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_CACHE
LAST_DOC_ID
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_CACHE
DOC_COUNT
4
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_CACHE
DOC_ID
5
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_INDEX_CACHE
POSITION
6
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
POOL_ID
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
POOL_SIZE
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
FREE_BUFFERS
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
DATABASE_PAGES
4
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
OLD_DATABASE_PAGES
5
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
MODIFIED_DATABASE_PAGES
6
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PENDING_DECOMPRESS
7
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PENDING_READS
8
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PENDING_FLUSH_LRU
9
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PENDING_FLUSH_LIST
10
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PAGES_MADE_YOUNG
11
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PAGES_NOT_MADE_YOUNG
12
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PAGES_MADE_YOUNG_RATE
13
NULL
NO
float
NULL
NULL
12
NULL
NULL
NULL
NULL
float
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PAGES_MADE_NOT_YOUNG_RATE
14
NULL
NO
float
NULL
NULL
12
NULL
NULL
NULL
NULL
float
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
NUMBER_PAGES_READ
15
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
NUMBER_PAGES_CREATED
16
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
NUMBER_PAGES_WRITTEN
17
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PAGES_READ_RATE
18
NULL
NO
float
NULL
NULL
12
NULL
NULL
NULL
NULL
float
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PAGES_CREATE_RATE
19
NULL
NO
float
NULL
NULL
12
NULL
NULL
NULL
NULL
float
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
PAGES_WRITTEN_RATE
20
NULL
NO
float
NULL
NULL
12
NULL
NULL
NULL
NULL
float
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
NUMBER_PAGES_GET
21
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
HIT_RATE
22
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
YOUNG_MAKE_PER_THOUSAND_GETS
23
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
NOT_YOUNG_MAKE_PER_THOUSAND_GETS
24
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
NUMBER_PAGES_READ_AHEAD
25
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
NUMBER_READ_AHEAD_EVICTED
26
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
READ_AHEAD_RATE
27
NULL
NO
float
NULL
NULL
12
NULL
NULL
NULL
NULL
float
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
READ_AHEAD_EVICTED_RATE
28
NULL
NO
float
NULL
NULL
12
NULL
NULL
NULL
NULL
float
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
LRU_IO_TOTAL
29
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
LRU_IO_CURRENT
30
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
UNCOMPRESS_TOTAL
31
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_POOL_STATS
UNCOMPRESS_CURRENT
32
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_FT_BEING_DELETED
DOC_ID
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_FOREIGN
ID
1
NULL
NO
varchar
193
579
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(193)
select
NEVER
NULL
def
information_schema
INNODB_SYS_FOREIGN
FOR_NAME
2
NULL
NO
varchar
193
579
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(193)
select
NEVER
NULL
def
information_schema
INNODB_SYS_FOREIGN
REF_NAME
3
NULL
NO
varchar
193
579
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(193)
select
NEVER
NULL
def
information_schema
INNODB_SYS_FOREIGN
N_COLS
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_FOREIGN
TYPE
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM_RESET
page_size
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(5)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM_RESET
buffer_pool_instance
2
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM_RESET
pages_used
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM_RESET
pages_free
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM_RESET
relocation_ops
5
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(21)
select
NEVER
NULL
def
information_schema
INNODB_CMPMEM_RESET
relocation_time
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_FT_DEFAULT_STOPWORD
value
1
NULL
NO
varchar
18
54
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(18)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLES
TABLE_ID
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLES
NAME
2
NULL
NO
varchar
655
1.965
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(655)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLES
FLAG
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLES
N_COLS
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLES
SPACE
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLES
ROW_FORMAT
6
NULL
YES
enum
3
10
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
enum('Redundant','Compact','Compressed','Dynamic')
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLES
ZIP_PAGE_SIZE
7
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLES
SPACE_TYPE
8
NULL
YES
enum
2
6
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
enum('Single','System')
select
NEVER
NULL
def
information_schema
INNODB_SYS_COLUMNS
TABLE_ID
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_COLUMNS
NAME
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_SYS_COLUMNS
POS
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_COLUMNS
MTYPE
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_SYS_COLUMNS
PRTYPE
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_SYS_COLUMNS
LEN
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESPACES
SPACE
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESPACES
NAME
2
NULL
NO
varchar
655
1.965
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(655)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESPACES
FLAG
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESPACES
ROW_FORMAT
4
NULL
YES
varchar
22
66
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(22)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESPACES
PAGE_SIZE
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESPACES
FILENAME
6
NULL
NO
varchar
512
1.536
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(512)
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESPACES
FS_BLOCK_SIZE
7
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESPACES
FILE_SIZE
8
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_TABLESPACES
ALLOCATED_SIZE
9
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_INDEXES
INDEX_ID
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_INDEXES
NAME
2
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_SYS_INDEXES
TABLE_ID
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_INDEXES
TYPE
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_SYS_INDEXES
N_FIELDS
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_SYS_INDEXES
PAGE_NO
6
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_SYS_INDEXES
SPACE
7
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_SYS_INDEXES
MERGE_THRESHOLD
8
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
POOL_ID
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
BLOCK_ID
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
SPACE
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
PAGE_NUMBER
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
PAGE_TYPE
5
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
FLUSH_TYPE
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
FIX_COUNT
7
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
IS_HASHED
8
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
NEWEST_MODIFICATION
9
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
OLDEST_MODIFICATION
10
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
ACCESS_TIME
11
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
TABLE_NAME
12
NULL
YES
varchar
1.024
3.072
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(1024)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
INDEX_NAME
13
NULL
YES
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
NUMBER_RECORDS
14
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
DATA_SIZE
15
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
COMPRESSED_SIZE
16
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
PAGE_STATE
17
NULL
NO
enum
3
11
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
enum('NOT_USED','MEMORY','REMOVE_HASH','FILE_PAGE')
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
IO_FIX
18
NULL
NO
enum
2
8
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
enum('IO_NONE','IO_READ','IO_WRITE')
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
IS_OLD
19
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_BUFFER_PAGE
FREE_PAGE_CLOCK
20
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_VIRTUAL
TABLE_ID
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_VIRTUAL
POS
2
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_SYS_VIRTUAL
BASE_POS
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
user_variables
VARIABLE_NAME
1
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
user_variables
VARIABLE_VALUE
2
NULL
YES
varchar
2.048
6.144
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(2048)
select
NEVER
NULL
def
information_schema
user_variables
VARIABLE_TYPE
3
NULL
NO
varchar
64
192
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(64)
select
NEVER
NULL
def
information_schema
user_variables
CHARACTER_SET_NAME
4
NULL
YES
varchar
32
96
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(32)
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
SPACE
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
NAME
2
NULL
YES
varchar
655
1.965
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(655)
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
ENCRYPTION_SCHEME
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
KEYSERVER_REQUESTS
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
MIN_KEY_VERSION
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
CURRENT_KEY_VERSION
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
KEY_ROTATION_PAGE_NUMBER
7
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
KEY_ROTATION_MAX_PAGE_NUMBER
8
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
CURRENT_KEY_ID
9
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11) unsigned
select
NEVER
NULL
def
information_schema
INNODB_TABLESPACES_ENCRYPTION
ROTATING_OR_FLUSHING
10
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(1)
select
NEVER
NULL
def
information_schema
INNODB_LOCK_WAITS
requesting_trx_id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_LOCK_WAITS
requested_lock_id
2
NULL
NO
varchar
81
243
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(81)
select
NEVER
NULL
def
information_schema
INNODB_LOCK_WAITS
blocking_trx_id
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(21) unsigned
select
NEVER
NULL
def
information_schema
INNODB_LOCK_WAITS
blocking_lock_id
4
NULL
NO
varchar
81
243
NULL
NULL
NULL
utf8mb3
utf8mb3_general_ci
varchar(81)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
GROUP_ID
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(6)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
THREAD_CREATIONS
2
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
THREAD_CREATIONS_DUE_TO_STALL
3
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
WAKES
4
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
WAKES_DUE_TO_STALL
5
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
THROTTLES
6
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
STALLS
7
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
POLLS_BY_LISTENER
8
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
POLLS_BY_WORKER
9
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
DEQUEUES_BY_LISTENER
10
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
information_schema
THREAD_POOL_STATS
DEQUEUES_BY_WORKER
11
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(19)
select
NEVER
NULL
def
ayam_mrothol_db
ruang_penjualan
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
ruang_penjualan
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
ruang_penjualan
foto
3
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
ruang_penjualan
permanen
4
0
YES
smallint
NULL
NULL
5
0
NULL
NULL
NULL
smallint(6)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
ruang_penjualan
share_fee
5
0
YES
smallint
NULL
NULL
5
0
NULL
NULL
NULL
smallint(6)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
ruang_penjualan
urut
6
NULL
YES
smallint
NULL
NULL
5
0
NULL
NULL
NULL
smallint(6)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
ruang_penjualan
created_at
7
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
ruang_penjualan
updated_at
8
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
akses_diskon
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
akses_diskon
user_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
akses_diskon
created_at
3
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
akses_diskon
updated_at
4
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
password_reset_tokens
email
1
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
PRI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
password_reset_tokens
token
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
password_reset_tokens
created_at
3
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
id_device
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
id_outlet
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
id_user_pic
4
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
starting_cash
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
closing_cash
6
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
opened_at
7
NULL
NO
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
closed_at
8
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
created_at
9
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cashier_shifts
updated_at
10
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
closing_days
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
closing_days
brand_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
closing_days
komponen
3
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_bin
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
closing_days
created_at
4
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
closing_days
updated_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
migrations
id
1
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(10) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
migrations
migration
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
migrations
batch
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cache
key
1
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
PRI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cache
value
2
NULL
NO
mediumtext
16.777.215
16.777.215
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
mediumtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cache
expiration
3
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(20)
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
failed_jobs
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
failed_jobs
uuid
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
UNI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
failed_jobs
connection
3
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
failed_jobs
queue
4
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
failed_jobs
payload
5
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
failed_jobs
exception
6
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
failed_jobs
failed_at
7
current_timestamp()
NO
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
payment_methods
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
payment_methods
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
payment_methods
foto
3
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
payment_methods
permanent
4
0
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(1)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
payment_methods
created_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
payment_methods
updated_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
alamat
3
NULL
NO
text
65.535
65.535
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
text
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
nama_kontak
4
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
nomor_telepon
5
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
email
6
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
bank_rek
7
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
bank_nama
8
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
bank_pemilik
9
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
created_at
10
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
suppliers
updated_at
11
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
name
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
telp
3
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
jabatan
4
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
email
5
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
UNI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
email_verified_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
foto
7
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
password
8
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
approve
9
0
YES
smallint
NULL
NULL
5
0
NULL
NULL
NULL
smallint(6)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
remember_token
10
NULL
YES
varchar
100
400
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(100)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
created_at
11
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
users
updated_at
12
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
harga_jual
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
harga_hpp
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
harga_share
5
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
foto
6
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
tags
7
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
brand_id
8
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
category_id
9
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
ruang_penjualan_id
10
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
keywords
11
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
created_at
12
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
products
updated_at
13
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_devices
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_devices
id_outlet
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_devices
device_id
3
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_devices
device_token
4
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
UNI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_devices
fcm_token
5
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_devices
created_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_devices
updated_at
7
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah_komponen
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah_komponen
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah_komponen
unit_id
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah_komponen
created_at
4
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah_komponen
updated_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
supplier_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
tgl_pesan
3
NULL
NO
date
NULL
NULL
NULL
NULL
NULL
NULL
NULL
date
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
tgl_tiba
4
NULL
NO
date
NULL
NULL
NULL
NULL
NULL
NULL
NULL
date
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
paket
5
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_bin
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
tgl_terima
6
NULL
YES
date
NULL
NULL
NULL
NULL
NULL
NULL
NULL
date
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
paket_terima
7
NULL
YES
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
keterangan
8
NULL
YES
text
65.535
65.535
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
text
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
created_at
9
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
purchase_ck
updated_at
10
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
produksi_ck
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
produksi_ck
tgl_produksi
2
NULL
NO
date
NULL
NULL
NULL
NULL
NULL
NULL
NULL
date
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
produksi_ck
komp_bahan_baku_id
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
produksi_ck
jumlah
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
produksi_ck
created_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
produksi_ck
updated_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah
komponen
3
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah
created_at
4
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_mentah
updated_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
jobs
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
jobs
queue
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
jobs
payload
3
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
jobs
attempts
4
NULL
NO
smallint
NULL
NULL
5
0
NULL
NULL
NULL
smallint(5) unsigned
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
jobs
reserved_at
5
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(10) unsigned
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
jobs
available_at
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(10) unsigned
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
jobs
created_at
7
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(10) unsigned
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cache_locks
key
1
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
PRI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cache_locks
owner
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
cache_locks
expiration
3
NULL
NO
bigint
NULL
NULL
19
0
NULL
NULL
NULL
bigint(20)
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
id_outlet
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
note
3
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
created_at
4
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
updated_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
device_id
6
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
shift_id
7
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
transaction_number
8
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
payment_method_id
9
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
order_time
10
0
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
ordered_at
11
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
customer_name
12
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
selling_room
13
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
total_amount
14
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
hpp
15
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
paid_amount
16
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
change_amount
17
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
payment_reference
18
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
order_discount
19
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
order_discount_type
20
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sales
order_discount_rupiah
21
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
outlet_sale_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
UNI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
shift_id
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
cashier_id
4
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
note
5
NULL
YES
text
65.535
65.535
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
text
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
cash_back_amount
6
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
pelanggan
7
NULL
YES
varchar
16
64
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(16)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
rejected_count
8
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
no_wa
9
NULL
YES
varchar
16
64
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(16)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
status
10
'Pending'
NO
enum
8
32
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
enum('Pending','Rejected','Accepted','Done')
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
reviewer_id
11
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
reviewed_at
12
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
rejection_reason
13
NULL
YES
text
65.535
65.535
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
text
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
created_at
14
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transactions
updated_at
15
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_staffs
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_staffs
outlet_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_staffs
staff_id
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_staffs
created_at
4
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_staffs
updated_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku
qty
3
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku
nilai_total
4
0,00
NO
decimal
NULL
NULL
15
2
NULL
NULL
NULL
decimal(15,2)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku
unit_id
5
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku
created_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku
updated_at
7
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_qr_tokens
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_qr_tokens
device_id
2
NULL
NO
varchar
100
400
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(100)
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_qr_tokens
qr_token
3
NULL
NO
varchar
16
64
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(16)
UNI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_qr_tokens
user_id
4
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_qr_tokens
expired_at
5
NULL
NO
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_qr_tokens
is_used
6
0
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(1)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_qr_tokens
created_at
7
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_qr_tokens
updated_at
8
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku_ck
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku_ck
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku_ck
unit_id
3
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku_ck
harga
4
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku_ck
komponen
5
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_bin
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku_ck
created_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
bahan_baku_ck
updated_at
7
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
outlet_sale_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
product_id
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
nama_produk
4
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
qty
5
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
price
6
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
hpp
7
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
discount
8
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
discount_type
9
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
discount_rupiah
10
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
note
11
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
created_at
12
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_sale_items
updated_at
13
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
tokenable_type
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
tokenable_id
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
name
4
NULL
NO
text
65.535
65.535
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
text
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
token
5
NULL
NO
varchar
64
256
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(64)
UNI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
abilities
6
NULL
YES
text
65.535
65.535
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
text
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
last_used_at
7
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
expires_at
8
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
created_at
9
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
personal_access_tokens
updated_at
10
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
categories
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
categories
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
UNI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
categories
foto
3
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
categories
created_at
4
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
categories
updated_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transaction_details
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transaction_details
return_transaction_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transaction_details
outlet_sale_item_id
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
UNI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transaction_details
qty
4
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transaction_details
cash_back_amount
5
0
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transaction_details
created_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
return_transaction_details
updated_at
7
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
units
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
units
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
units
satuan
3
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
units
created_at
4
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
units
updated_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
id
1
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
PRI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
name
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
total_jobs
3
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
pending_jobs
4
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
failed_jobs
5
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
failed_job_ids
6
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
options
7
NULL
YES
mediumtext
16.777.215
16.777.215
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
mediumtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
cancelled_at
8
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
created_at
9
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
job_batches
finished_at
10
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
brands
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
brands
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
brands
logo
3
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
brands
mode_header
4
'LOGO_ONLY'
NO
enum
13
52
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
enum('LOGO_ONLY','NAME_ONLY','LOGO_AND_NAME')
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
brands
created_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
brands
updated_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
attendance_logs
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
attendance_logs
id_outlet
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
attendance_logs
short_time_code
3
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
attendance_logs
email
4
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
attendance_logs
checkin
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
attendance_logs
checkout
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
attendance_logs
created_at
7
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
attendance_logs
updated_at
8
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
sessions
id
1
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
PRI
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
sessions
user_id
2
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
sessions
ip_address
3
NULL
YES
varchar
45
180
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(45)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
sessions
user_agent
4
NULL
YES
text
65.535
65.535
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
text
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
sessions
payload
5
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
sessions
last_activity
6
NULL
NO
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_otp
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_otp
id_outlet
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_otp
otp_code
3
NULL
NO
varchar
6
24
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(6)
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_otp
expired_time
4
NULL
NO
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_otp
is_used
5
0
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(1)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_otp
created_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlet_otp
updated_at
7
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
product_bahan_baku
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
product_bahan_baku
product_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
product_bahan_baku
bahan_baku_id
3
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
product_bahan_baku
volume
4
NULL
NO
double
NULL
NULL
22
NULL
NULL
NULL
NULL
double
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
product_bahan_baku
created_at
5
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
product_bahan_baku
updated_at
6
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
brand_id
2
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
nama
3
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
tanggal_mulai
4
NULL
NO
date
NULL
NULL
NULL
NULL
NULL
NULL
NULL
date
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
tanggal_berakhir
5
NULL
NO
date
NULL
NULL
NULL
NULL
NULL
NULL
NULL
date
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
kode_voucher
6
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
kuota
7
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
tipe_promo
8
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
detail_promo
9
NULL
NO
longtext
4.294.967.295
4.294.967.295
NULL
NULL
NULL
utf8mb4
utf8mb4_bin
longtext
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
is_hold
10
0
NO
tinyint
NULL
NULL
3
0
NULL
NULL
NULL
tinyint(1)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
created_at
11
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
promos
updated_at
12
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
id
1
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
PRI
auto_increment
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
nama
2
NULL
NO
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
alamat
3
NULL
NO
text
65.535
65.535
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
text
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
foto
4
NULL
YES
varchar
255
1.020
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(255)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
latitude
5
NULL
NO
varchar
50
200
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(50)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
longitude
6
NULL
NO
varchar
50
200
NULL
NULL
NULL
utf8mb4
utf8mb4_unicode_ci
varchar(50)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
brand_id
7
NULL
YES
int
NULL
NULL
10
0
NULL
NULL
NULL
int(11)
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
supervisor_id
8
NULL
NO
bigint
NULL
NULL
20
0
NULL
NULL
NULL
bigint(20) unsigned
MUL
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
created_at
9
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
def
ayam_mrothol_db
outlets
updated_at
10
NULL
YES
timestamp
NULL
NULL
NULL
NULL
0
NULL
NULL
timestamp
select,insert,update,references
NEVER
NULL
Total Baris: 1079