Recent
`saa_system`.`wh_patrol_log`
`saa_system`.`form_signers`
`mysql`.`help_category`
`mysql`.`innodb_table_stats`
`mysql`.`general_log`
`information_schema`.`TABLE_CONSTRAINTS`
`mysql`.`time_zone_name`
`saa_system`.`lg_predelivery_check`
`performance_schema`.`session_account_connect_attrs`
`information_schema`.`KEY_CACHES`
Favorites
There are no favorite tables.
New
information_schema
mysql
performance_schema
phpmyadmin
saa_system
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: saa_system
Table: wh_patrol_log
Browse
Structure
(current)
SQL
Search
Insert
Export
Import
Privileges
Operations
Tracking
Triggers
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Table structure
Table structure
Settings for the table structure (list of columns).
Table structure
Hide table structure actions
Whether the table structure actions should be hidden.
Show column comments
Whether column comments should be shown in table structure view
Default transformations
Default transformations for Hex
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
2
Default transformations for Substring
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 all …
Default transformations for Bool2Text
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
T F
Default transformations for External
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 -f /dev/null -i -wrap -q 1 1
Default transformations for PreApPend
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Default transformations for DateFormat
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
0 local
Default transformations for Inline
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 100
Default transformations for TextImageLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
100 50
Default transformations for TextLink
Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Table structure
Relation view
wh_patrol_log
#
Name
Type
Collation
Attributes
Null
Default
Comments
Extra
Action
1
id
int(11)
No
None
AUTO_INCREMENT
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
2
check_date
date
No
None
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
3
shift
enum('D', 'N')
utf8mb4_general_ci
No
None
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
4
inspector_name
text
utf8mb4_general_ci
No
None
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
5
status
enum('pending_check', 'pending_approve', 'complete...
utf8mb4_general_ci
No
pending_check
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
6
duration_seconds
int(10)
UNSIGNED
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
7
q1_1_lot
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
8
q1_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
9
q1_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
10
q1_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
11
q1_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
12
q1_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
13
q1_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
14
q1_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
15
q1_2_lot
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
16
q1_2_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
17
q1_2_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
18
q1_2_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
19
q1_2_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
20
q1_2_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
21
q1_2_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
22
q1_2_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
23
q1_3_lot
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
24
q1_3_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
25
q1_3_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
26
q1_3_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
27
q1_3_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
28
q1_3_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
29
q1_3_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
30
q1_3_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
31
q2_1_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
32
q2_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
33
q2_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
34
q2_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
35
q2_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
36
q2_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
37
q2_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
38
q2_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
39
q2_2_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
40
q2_2_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
41
q2_2_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
42
q2_2_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
43
q2_2_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
44
q2_2_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
45
q2_2_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
46
q2_2_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
47
q2_3_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
48
q2_3_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
49
q2_3_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
50
q2_3_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
51
q2_3_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
52
q2_3_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
53
q2_3_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
54
q2_3_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
55
q3_1_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
56
q3_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
57
q3_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
58
q3_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
59
q3_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
60
q3_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
61
q3_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
62
q3_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
63
q3_2_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
64
q3_2_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
65
q3_2_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
66
q3_2_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
67
q3_2_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
68
q3_2_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
69
q3_2_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
70
q3_2_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
71
q3_3_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
72
q3_3_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
73
q3_3_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
74
q3_3_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
75
q3_3_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
76
q3_3_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
77
q3_3_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
78
q3_3_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
79
q4_1_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
80
q4_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
81
q4_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
82
q4_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
83
q4_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
84
q4_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
85
q4_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
86
q4_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
87
q5_1_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
88
q5_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
89
q5_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
90
q5_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
91
q5_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
92
q5_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
93
q5_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
94
q5_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
95
q6_1_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
96
q6_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
97
q6_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
98
q6_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
99
q6_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
100
q6_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
101
q6_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
102
q6_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
103
q7_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
104
q7_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
105
q7_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
106
q7_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
107
q7_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
108
q7_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
109
q7_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
110
q7_2_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
111
q7_2_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
112
q7_2_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
113
q7_2_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
114
q7_2_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
115
q7_2_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
116
q7_2_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
117
q7_3_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
118
q7_3_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
119
q7_3_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
120
q7_3_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
121
q7_3_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
122
q7_3_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
123
q7_3_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
124
q7_4_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
125
q7_4_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
126
q7_4_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
127
q7_4_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
128
q7_4_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
129
q7_4_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
130
q7_4_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
131
q7_5_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
132
q7_5_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
133
q7_5_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
134
q7_5_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
135
q7_5_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
136
q7_5_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
137
q7_5_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
138
q7_6_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
139
q7_6_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
140
q7_6_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
141
q7_6_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
142
q7_6_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
143
q7_6_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
144
q7_6_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
145
q8_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
146
q8_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
147
q8_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
148
q8_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
149
q8_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
150
q8_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
151
q8_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
152
q9_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
153
q9_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
154
q9_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
155
q9_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
156
q9_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
157
q9_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
158
q9_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
159
q10_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
160
q10_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
161
q10_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
162
q10_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
163
q10_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
164
q10_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
165
q10_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
166
q11_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
167
q11_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
168
q11_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
169
q11_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
170
q11_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
171
q11_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
172
q11_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
173
sig_report
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
174
sig_check
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
175
sig_approve
longtext
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
176
created_at
datetime
Yes
current_timestamp()
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
177
q12_1_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
178
q12_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
179
q12_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
180
q12_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
181
q12_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
182
q12_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
183
q12_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
184
q12_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
185
q13_1_lot
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
186
q13_1_status
varchar(10)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
187
q13_1_cause
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
188
q13_1_action
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
189
q13_1_pic
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
190
q13_1_due_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
191
q13_1_follower
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
192
q13_1_follow_date
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
193
q1_1_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
194
q1_1_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
195
q1_1_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
196
q1_2_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
197
q1_2_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
198
q1_2_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
199
q1_3_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
200
q1_3_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
201
q1_3_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
202
q2_1_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
203
q2_1_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
204
q2_1_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
205
q2_2_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
206
q2_2_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
207
q2_2_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
208
q2_3_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
209
q2_3_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
210
q2_3_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
211
q3_1_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
212
q3_1_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
213
q3_1_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
214
q3_2_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
215
q3_2_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
216
q3_2_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
217
q3_3_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
218
q3_3_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
219
q3_3_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
220
q4_1_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
221
q4_1_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
222
q4_1_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
223
q5_1_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
224
q5_1_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
225
q5_1_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
226
q6_1_prod_date_1
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
227
q6_1_prod_date_2
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
228
q6_1_prod_date_3
date
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
229
q2_1_per_box
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
230
q2_1_boxes
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
231
q2_1_remainder
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
232
q2_1_total
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
233
q2_2_per_box
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
234
q2_2_boxes
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
235
q2_2_remainder
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
236
q2_2_total
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
237
q2_3_per_box
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
238
q2_3_boxes
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
239
q2_3_remainder
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
240
q2_3_total
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
241
q4_1_per_box
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
242
q4_1_boxes
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
243
q4_1_remainder
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
244
q4_1_total
int(11)
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
245
q4_1_no
varchar(255)
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
246
q10_1_input
text
utf8mb4_general_ci
Yes
NULL
Change
Drop
More
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Add to central columns
Check all
With selected:
Browse
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Add to central columns
Remove from central columns
Move columns
Move the columns by dragging them up and down.
Preview SQL
Loading…
Error
Print
Propose table structure
Track table
Move columns
Normalize
Add
column(s)
at beginning of table
after id
after check_date
after shift
after inspector_name
after status
after duration_seconds
after q1_1_lot
after q1_1_status
after q1_1_cause
after q1_1_action
after q1_1_pic
after q1_1_due_date
after q1_1_follower
after q1_1_follow_date
after q1_2_lot
after q1_2_status
after q1_2_cause
after q1_2_action
after q1_2_pic
after q1_2_due_date
after q1_2_follower
after q1_2_follow_date
after q1_3_lot
after q1_3_status
after q1_3_cause
after q1_3_action
after q1_3_pic
after q1_3_due_date
after q1_3_follower
after q1_3_follow_date
after q2_1_input
after q2_1_status
after q2_1_cause
after q2_1_action
after q2_1_pic
after q2_1_due_date
after q2_1_follower
after q2_1_follow_date
after q2_2_input
after q2_2_status
after q2_2_cause
after q2_2_action
after q2_2_pic
after q2_2_due_date
after q2_2_follower
after q2_2_follow_date
after q2_3_input
after q2_3_status
after q2_3_cause
after q2_3_action
after q2_3_pic
after q2_3_due_date
after q2_3_follower
after q2_3_follow_date
after q3_1_input
after q3_1_status
after q3_1_cause
after q3_1_action
after q3_1_pic
after q3_1_due_date
after q3_1_follower
after q3_1_follow_date
after q3_2_input
after q3_2_status
after q3_2_cause
after q3_2_action
after q3_2_pic
after q3_2_due_date
after q3_2_follower
after q3_2_follow_date
after q3_3_input
after q3_3_status
after q3_3_cause
after q3_3_action
after q3_3_pic
after q3_3_due_date
after q3_3_follower
after q3_3_follow_date
after q4_1_input
after q4_1_status
after q4_1_cause
after q4_1_action
after q4_1_pic
after q4_1_due_date
after q4_1_follower
after q4_1_follow_date
after q5_1_input
after q5_1_status
after q5_1_cause
after q5_1_action
after q5_1_pic
after q5_1_due_date
after q5_1_follower
after q5_1_follow_date
after q6_1_input
after q6_1_status
after q6_1_cause
after q6_1_action
after q6_1_pic
after q6_1_due_date
after q6_1_follower
after q6_1_follow_date
after q7_1_status
after q7_1_cause
after q7_1_action
after q7_1_pic
after q7_1_due_date
after q7_1_follower
after q7_1_follow_date
after q7_2_status
after q7_2_cause
after q7_2_action
after q7_2_pic
after q7_2_due_date
after q7_2_follower
after q7_2_follow_date
after q7_3_status
after q7_3_cause
after q7_3_action
after q7_3_pic
after q7_3_due_date
after q7_3_follower
after q7_3_follow_date
after q7_4_status
after q7_4_cause
after q7_4_action
after q7_4_pic
after q7_4_due_date
after q7_4_follower
after q7_4_follow_date
after q7_5_status
after q7_5_cause
after q7_5_action
after q7_5_pic
after q7_5_due_date
after q7_5_follower
after q7_5_follow_date
after q7_6_status
after q7_6_cause
after q7_6_action
after q7_6_pic
after q7_6_due_date
after q7_6_follower
after q7_6_follow_date
after q8_1_status
after q8_1_cause
after q8_1_action
after q8_1_pic
after q8_1_due_date
after q8_1_follower
after q8_1_follow_date
after q9_1_status
after q9_1_cause
after q9_1_action
after q9_1_pic
after q9_1_due_date
after q9_1_follower
after q9_1_follow_date
after q10_1_status
after q10_1_cause
after q10_1_action
after q10_1_pic
after q10_1_due_date
after q10_1_follower
after q10_1_follow_date
after q11_1_status
after q11_1_cause
after q11_1_action
after q11_1_pic
after q11_1_due_date
after q11_1_follower
after q11_1_follow_date
after sig_report
after sig_check
after sig_approve
after created_at
after q12_1_input
after q12_1_status
after q12_1_cause
after q12_1_action
after q12_1_pic
after q12_1_due_date
after q12_1_follower
after q12_1_follow_date
after q13_1_lot
after q13_1_status
after q13_1_cause
after q13_1_action
after q13_1_pic
after q13_1_due_date
after q13_1_follower
after q13_1_follow_date
after q1_1_prod_date_1
after q1_1_prod_date_2
after q1_1_prod_date_3
after q1_2_prod_date_1
after q1_2_prod_date_2
after q1_2_prod_date_3
after q1_3_prod_date_1
after q1_3_prod_date_2
after q1_3_prod_date_3
after q2_1_prod_date_1
after q2_1_prod_date_2
after q2_1_prod_date_3
after q2_2_prod_date_1
after q2_2_prod_date_2
after q2_2_prod_date_3
after q2_3_prod_date_1
after q2_3_prod_date_2
after q2_3_prod_date_3
after q3_1_prod_date_1
after q3_1_prod_date_2
after q3_1_prod_date_3
after q3_2_prod_date_1
after q3_2_prod_date_2
after q3_2_prod_date_3
after q3_3_prod_date_1
after q3_3_prod_date_2
after q3_3_prod_date_3
after q4_1_prod_date_1
after q4_1_prod_date_2
after q4_1_prod_date_3
after q5_1_prod_date_1
after q5_1_prod_date_2
after q5_1_prod_date_3
after q6_1_prod_date_1
after q6_1_prod_date_2
after q6_1_prod_date_3
after q2_1_per_box
after q2_1_boxes
after q2_1_remainder
after q2_1_total
after q2_2_per_box
after q2_2_boxes
after q2_2_remainder
after q2_2_total
after q2_3_per_box
after q2_3_boxes
after q2_3_remainder
after q2_3_total
after q4_1_per_box
after q4_1_boxes
after q4_1_remainder
after q4_1_total
after q4_1_no
after q10_1_input
Indexes
Loading
Action
Keyname
Type
Unique
Packed
Column
Cardinality
Collation
Null
Comment
Edit
Rename
Drop
PRIMARY
BTREE
Yes
No
id
20
A
No
Edit
Rename
Drop
idx_check_date
BTREE
No
No
check_date
20
A
No
Create an index on
columns
Loading
Preview SQL
Loading…
Partitions
No partitioning defined!
Information
Space usage
Data
1.5
MiB
Index
16.0
KiB
Overhead
4.0
MiB
Effective
-2,605,056
B
Total
1.5
MiB
Optimize table
Row statistics
Format
dynamic
Collation
utf8mb4_general_ci
Next autoindex
72
Creation
Sep 22, 2026 at 05:06 PM
Last update
Sep 28, 2026 at 07:18 AM
Last check
Sep 28, 2026 at 07:18 AM