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

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_todo

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	account	char(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	date	date			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	begin	smallint(4)		UNSIGNED ZEROFILL	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	end	smallint(4)		UNSIGNED ZEROFILL	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	feedback	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	type	char(10)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	cycle	tinyint(3)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	idvalue	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	pri	tinyint(3)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	name	char(150)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	desc	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
13	status	enum('wait', 'doing', 'done', 'closed')	utf8_general_ci		No	wait		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
14	private	tinyint(1)			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
15	config	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
16	assignedTo	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
17	assignedBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
18	assignedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
19	finishedBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
20	finishedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
21	closedBy	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
22	closedDate	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	81	A	No
Edit	Drop	account	BTREE	No	No	account		A	No
Edit	Drop	assignedTo	BTREE	No	No	assignedTo		A	No
Edit	Drop	finishedBy	BTREE	No	No	finishedBy		A	No
Edit	Drop	date	BTREE	No	No	date		A	No

Information

Space usage
Data	9	KiB
Index	6	KiB
Total	15	KiB

Row statistics
Format	dynamic
Collation	utf8_general_ci
Rows	81
Row length	113 B
Row size	189 B
Next autoindex	88
Creation	Jul 17, 2019 at 03:48 PM
Last update	Apr 02, 2022 at 08:10 PM
Last check	Jul 17, 2019 at 03:48 PM