beemans.51vip.biz / localhost / zentaoep / zt_workflow

cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.emVudGFvZXA=cm9vdA==.emVudGFvZXA=0
zentaoep

Server: localhost:3306 »

Database: zentaoep »

Table: zt_workflow

The column name 'table' is a MySQL reserved keyword.

The column name 'order' is a MySQL reserved keyword.

The column name 'desc' is a MySQL reserved keyword.

#	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	parent	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	child	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	type	varchar(10)	utf8_general_ci		No	flow		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	navigator	varchar(10)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	app	varchar(20)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	position	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	module	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	table	varchar(50)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	name	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	flowchart	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	js	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
13	css	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
14	order	smallint(5)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
15	buildin	tinyint(1)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
16	administrator	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
17	desc	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
18	version	varchar(10)	utf8_general_ci		No	1.0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
19	status	varchar(10)	utf8_general_ci		No	wait		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
20	createdBy	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
21	createdDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
22	editedBy	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
23	editedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values

Check AllWith selected:

Print view

Propose table structure

Move columns

Action	Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
Edit	Drop	PRIMARY	BTREE	Yes	No	id	13	A	No
Edit	Drop	unique	BTREE	Yes	No	app		A	No
module	13	A	No
Edit	Drop	type	BTREE	No	No	type		A	No
Edit	Drop	app	BTREE	No	No	app		A	No
Edit	Drop	module	BTREE	No	No	module		A	No
Edit	Drop	order	BTREE	No	No	order		A	No

Information

Space usage
Data	1.2	KiB
Index	7	KiB
Total	8.2	KiB

Row statistics
Format	dynamic
Collation	utf8_general_ci
Rows	13
Row length	93 B
Row size	645 B
Next autoindex	14
Creation	Jan 26, 2021 at 08:10 AM
Last update	Jan 26, 2021 at 08:10 AM