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

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_project

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

The column name 'order' 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	isCat	enum('1', '0')	utf8_general_ci		No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	catID	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	type	varchar(20)	utf8_general_ci		No	sprint		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	parent	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	name	varchar(90)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	code	varchar(45)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	begin	date			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	end	date			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	days	smallint(5)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	status	varchar(10)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	subStatus	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
13	statge	enum('1', '2', '3', '4', '5')	utf8_general_ci		No	1		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
14	pri	enum('1', '2', '3', '4')	utf8_general_ci		No	1		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
15	desc	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
16	openedBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
17	openedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
18	openedVersion	varchar(20)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
19	closedBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
20	closedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
21	canceledBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
22	canceledDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
23	PO	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
24	PM	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
25	QD	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
26	RD	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
27	team	varchar(90)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
28	acl	enum('open', 'private', 'custom')	utf8_general_ci		No	open		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
29	whitelist	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
30	order	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
31	deleted	enum('0', '1')	utf8_general_ci		No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
32	mailto	text	utf8_general_ci		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	445	A	No
Edit	Drop	parent	BTREE	No	No	parent	3	A	No
Edit	Drop	begin	BTREE	No	No	begin	445	A	No
Edit	Drop	end	BTREE	No	No	end	445	A	No
Edit	Drop	status	BTREE	No	No	status	14	A	No
Edit	Drop	order	BTREE	No	No	order	445	A	No
Edit	Drop	acl	BTREE	No	No	acl	7	A	No

Information

Space usage
Data	70.2	KiB
Index	38	KiB
Total	108.2	KiB

Row statistics
Format	dynamic
Collation	utf8_general_ci
Rows	445
Row length	161 B
Row size	249 B
Next autoindex	446
Creation	Jan 26, 2021 at 08:10 AM
Last update	Feb 17, 2025 at 05:44 PM
Last check	Jan 26, 2021 at 08:10 AM