(Recent tables) ...
There are no recent tables
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.emVudGFvZXA=
cm9vdA==.emVudGFvZXA=
0
zentaoep
Javascript must be enabled past this point
Server: localhost:3306
»
Database: zentaoep
»
Table: zt_compile
Browse
Structure
SQL
Search
Insert
Export
Import
Operations
Triggers
#
Name
Type
Collation
Attributes
Null
Default
Extra
Action
1
id
mediumint(8)
UNSIGNED
No
None
AUTO_INCREMENT
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
2
name
varchar(50)
utf8_general_ci
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
3
job
mediumint(8)
UNSIGNED
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
4
queue
mediumint(8)
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
5
status
varchar(255)
utf8_general_ci
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
6
logs
text
utf8_general_ci
Yes
NULL
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
7
atTime
varchar(10)
utf8_general_ci
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
8
testtask
mediumint(8)
UNSIGNED
Yes
NULL
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
9
tag
varchar(255)
utf8_general_ci
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
10
times
tinyint(3)
UNSIGNED
No
0
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
11
createdBy
varchar(30)
utf8_general_ci
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
12
createdDate
datetime
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
13
updateDate
datetime
No
None
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
14
deleted
enum('0', '1')
utf8_general_ci
No
0
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Distinct values
Check All
With selected:
Browse
Change
Drop
Primary
Unique
Index
Spatial
Fulltext
Move the columns by dragging them up and down.
Print view
Propose table structure
Move columns
Add
column(s)
At End of Table
At Beginning of Table
After
id
name
job
queue
status
logs
atTime
testtask
tag
times
createdBy
createdDate
updateDate
deleted
Indexes
No index defined!
Action
Keyname
Type
Unique
Packed
Column
Cardinality
Collation
Null
Comment
Edit
Drop
PRIMARY
BTREE
Yes
No
id
0
A
No
Create an index on
columns
Information
Space usage
Data
0
B
Index
1
KiB
Total
1
KiB
Row statistics
Format
dynamic
Collation
utf8_general_ci
Rows
0
Next autoindex
1
Creation
Jan 26, 2021 at 08:10 AM
Last update
Jan 26, 2021 at 08:10 AM