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

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_action

The column name 'read' 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	objectType	varchar(30)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	objectID	mediumint(8)		UNSIGNED	No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	product	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	project	mediumint(9)			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	actor	varchar(100)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	action	varchar(80)	utf8_general_ci		No			Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	date	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	comment	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	extra	text	utf8_general_ci		Yes	NULL		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	read	enum('0', '1')	utf8_general_ci		No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	efforted	tinyint(1)			No	0		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	103302	A	No
Edit	Drop	date	BTREE	No	No	date	51651	A	No
Edit	Drop	actor	BTREE	No	No	actor	61	A	No
Edit	Drop	project	BTREE	No	No	project	319	A	No
Edit	Drop	objectID	BTREE	No	No	objectID	20660	A	No
Edit	Drop	action	BTREE	No	No	action	95	A	No

Information

Space usage
Data	4.6	MiB
Index	5.2	MiB
Total	9.9	MiB

Row statistics
Format	dynamic
Collation	utf8_general_ci
Rows	103,302
Row length	46 B
Row size	100 B
Next autoindex	103,303
Creation	Jan 26, 2021 at 08:10 AM
Last update	Nov 29, 2024 at 10:04 AM
Last check	Jan 26, 2021 at 08:10 AM