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

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_feedback

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	product	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
3	module	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
4	title	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
5	desc	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
6	status	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
7	subStatus	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
8	public	enum('0', '1')	utf8_general_ci		No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
9	notify	enum('0', '1')	utf8_general_ci		No	0		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
10	likes	text	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
11	result	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
12	faq	mediumint(8)		UNSIGNED	No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
13	openedBy	char(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
14	openedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
15	reviewedBy	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
16	reviewedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
17	processedBy	char(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
18	processedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
19	closedBy	char(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
20	closedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
21	closedReason	varchar(30)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
22	editedBy	char(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
24	assignedTo	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
25	assignedDate	datetime			No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
26	mailto	varchar(255)	utf8_general_ci		No	None		Change	Drop	Primary Unique Index Spatial Fulltext Distinct values
27	deleted	enum('0', '1')	utf8_general_ci		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	0	A	No

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	Apr 01, 2020 at 02:01 PM
Last update	Apr 01, 2020 at 02:01 PM