Print view - phpMyAdmin 4.0.8

view_datasource_10

Table comments: VIEW

Column	Type	Null	Default	Comments
id	mediumint(8)	No	0
name	char(150)	No

view_datasource_11

Table comments: VIEW

Column	Type	Null	Default	Comments
id	mediumint(8)	No	0
name	char(60)	No

view_datasource_12

Table comments: VIEW

Column	Type	Null	Default	Comments
id	mediumint(8)	No	0
title	varchar(90)	No

view_datasource_4

Table comments: VIEW

Column	Type	Null	Default	Comments
id	mediumint(8)	No	0
title	varchar(255)	No

view_datasource_5

Table comments: VIEW

Column	Type	Null	Default	Comments
id	mediumint(8)	No	0
name	varchar(255)	No

view_datasource_6

Table comments: VIEW

Column	Type	Null	Default	Comments
id	mediumint(8)	No	0
title	varchar(255)	No

zt_action

Column	Type	Null	Default
id	mediumint(8)	No
objectType	varchar(30)	No
objectID	mediumint(8)	No	0
product	varchar(255)	No
project	mediumint(9)	No
actor	varchar(100)	No
action	varchar(80)	No
date	datetime	No
comment	text	No
extra	text	Yes	NULL
read	enum('0', '1')	No	0
efforted	tinyint(1)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	103165	A	No
date	BTREE	No	No	date	51582	A	No
actor	BTREE	No	No	actor	61	A	No
project	BTREE	No	No	project	319	A	No
objectID	BTREE	No	No	objectID	20633	A	No
action	BTREE	No	No	action	95	A	No

zt_asset

Column	Type	Null	Default
id	mediumint(8)	No
name	varchar(255)	No
status	varchar(30)	No
type	varchar(30)	No
group	varchar(128)	No
createdBy	char(30)	No
createdDate	datetime	No
editedBy	char(30)	No
editedDate	datetime	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_attend

Column	Type	Null
id	mediumint(8)	No
account	char(30)	No
date	date	No
signIn	time	No
signOut	time	No
status	varchar(30)	No
ip	varchar(15)	No
device	varchar(30)	No
client	varchar(20)	No
manualIn	time	No
manualOut	time	No
reason	varchar(30)	No
desc	text	No
reviewStatus	varchar(30)	No
reviewedBy	char(30)	No
reviewedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	7365	A	No
attend	BTREE	Yes	No	date		A	No
attend	BTREE	Yes	No	account	7365	A	No
account	BTREE	No	No	account		A	No
date	BTREE	No	No	date		A	No
status	BTREE	No	No	status		A	No
reason	BTREE	No	No	reason		A	No
reviewStatus	BTREE	No	No	reviewStatus		A	No
reviewedBy	BTREE	No	No	reviewedBy		A	No

zt_attendstat

Column	Type	Null	Default
id	mediumint(8)	No
account	char(30)	No
month	char(10)	No
normal	decimal(12,2)	No	0.00
late	decimal(12,2)	No	0.00
early	decimal(12,2)	No	0.00
absent	decimal(12,2)	No	0.00
trip	decimal(12,2)	No	0.00
egress	decimal(12,2)	No	0.00
lieu	decimal(12,2)	No	0.00
paidLeave	decimal(12,2)	No	0.00
unpaidLeave	decimal(12,2)	No	0.00
timeOvertime	decimal(12,2)	No	0.00
restOvertime	decimal(12,2)	No	0.00
holidayOvertime	decimal(12,2)	No	0.00
deserve	decimal(12,2)	No	0.00
actual	decimal(12,2)	No	0.00
status	char(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
attend	BTREE	Yes	No	month		A	No
attend	BTREE	Yes	No	account	0	A	No
account	BTREE	No	No	account		A	No
month	BTREE	No	No	month		A	No
status	BTREE	No	No	status		A	No

zt_block

Column	Type	Null	Default
id	mediumint(8)	No
account	char(30)	No
module	varchar(20)	No
title	varchar(100)	No
source	varchar(20)	No
block	varchar(20)	No
params	text	No
order	tinyint(3)	No	0
grid	tinyint(3)	No	0
height	smallint(5)	No	0
hidden	tinyint(1)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	1019	A	No
accountModuleOrder	BTREE	Yes	No	account		A	No
				module		A	No
				order	1019	A	No
account	BTREE	No	No	account		A	No

zt_branch

Column	Type	Null	Default
id	mediumint(8)	No
product	mediumint(8)	No
name	varchar(255)	No
order	smallint(5)	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	60	A	No
product	BTREE	No	No	product		A	No

zt_bug

Column	Type	Null	Default
id	mediumint(8)	No
product	mediumint(8)	No	0
branch	mediumint(8)	No	0
module	mediumint(8)	No	0
project	mediumint(8)	No	0
plan	mediumint(8)	No	0
story	mediumint(8)	No	0
storyVersion	smallint(6)	No	1
task	mediumint(8)	No	0
toTask	mediumint(8)	No	0
toStory	mediumint(8)	No	0
title	varchar(255)	No
keywords	varchar(255)	No
severity	tinyint(4)	No	0
pri	tinyint(3)	No
type	varchar(30)	No
os	varchar(30)	No
browser	varchar(30)	No
hardware	varchar(30)	No
found	varchar(30)	No
steps	text	No
status	enum('active', 'resolved', 'closed')	No	active
subStatus	varchar(30)	No
color	char(7)	No
confirmed	tinyint(1)	No	0
activatedCount	smallint(6)	No
activatedDate	datetime	No
mailto	text	Yes	NULL
openedBy	varchar(30)	No
openedDate	datetime	No
openedBuild	varchar(255)	No
assignedTo	varchar(30)	No
assignedDate	datetime	No
deadline	date	No
resolvedBy	varchar(30)	No
resolution	varchar(30)	No
resolvedBuild	varchar(30)	No
resolvedDate	datetime	No
closedBy	varchar(30)	No
closedDate	datetime	No
duplicateBug	mediumint(8)	No
linkBug	varchar(255)	No
case	mediumint(8)	No
caseVersion	smallint(6)	No
feedback	mediumint(8)	No	0
result	mediumint(8)	No
repo	mediumint(8)	No
entry	varchar(255)	No
lines	varchar(10)	No
v1	varchar(40)	No
v2	varchar(40)	No
repoType	varchar(30)	No
testtask	mediumint(8)	No
lastEditedBy	varchar(30)	No
lastEditedDate	datetime	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	6290	A	No
product	BTREE	No	No	product	44	A	No
project	BTREE	No	No	project	216	A	No
status	BTREE	No	No	status	7	A	No
plan	BTREE	No	No	plan	4	A	No
story	BTREE	No	No	story	524	A	No
case	BTREE	No	No	case	174	A	No
assignedTo	BTREE	No	No	assignedTo	44	A	No
toStory	BTREE	No	No	toStory	2	A	No
result	BTREE	No	No	result	165	A	No

zt_build

Column	Type	Null	Default
id	mediumint(8)	No
product	mediumint(8)	No	0
branch	mediumint(8)	No	0
project	mediumint(8)	No	0
name	char(150)	No
scmPath	char(255)	No
filePath	char(255)	No
date	date	No
stories	text	No
bugs	text	No
builder	char(30)	No
desc	text	No
deleted	enum('0', '1')	No	0
mailto	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	696	A	No
product	BTREE	No	No	product	53	A	No
project	BTREE	No	No	project	232	A	No

zt_burn

Column	Type	Null	Default
project	mediumint(8)	No
task	mediumint(8)	No	0
date	date	No
estimate	float	No
left	float	No
consumed	float	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	project		A	No
				date		A	No
				task	2086	A	No

zt_case

Column	Type	Null	Default
id	mediumint(8)	No
product	mediumint(8)	No	0
branch	mediumint(8)	No	0
lib	mediumint(8)	No	0
module	mediumint(8)	No	0
path	mediumint(8)	No	0
story	mediumint(30)	No	0
storyVersion	smallint(6)	No	1
title	varchar(255)	No
precondition	text	No
keywords	varchar(255)	No
pri	tinyint(3)	No	3
type	char(30)	No	1
auto	varchar(10)	No	no
frame	varchar(10)	No
stage	varchar(255)	No
howRun	varchar(30)	No
scriptedBy	varchar(30)	No
scriptedDate	date	No
scriptStatus	varchar(30)	No
scriptLocation	varchar(255)	No
status	char(30)	No	1
subStatus	varchar(30)	No
color	char(7)	No
frequency	enum('1', '2', '3')	No	1
order	tinyint(30)	No	0
openedBy	char(30)	No
openedDate	datetime	No
reviewedBy	varchar(255)	No
reviewedDate	date	No
lastEditedBy	char(30)	No
lastEditedDate	datetime	No
version	tinyint(3)	No	0
linkCase	varchar(255)	No
fromBug	mediumint(8)	No
fromCaseID	mediumint(8)	No
fromCaseVersion	mediumint(8)	No	1
deleted	enum('0', '1')	No	0
lastRunner	varchar(30)	No
lastRunDate	datetime	No
lastRunResult	char(30)	No
mailto	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	12008	A	No
product	BTREE	No	No	product	32	A	No
story	BTREE	No	No	story	461	A	No
module	BTREE	No	No	module	1	A	No
fromBug	BTREE	No	No	fromBug	1	A	No

zt_casestep

Column	Type	Null	Default
id	mediumint(8)	No
parent	mediumint(8)	No	0
case	mediumint(8)	No	0
version	smallint(3)	No	0
type	varchar(10)	No	step
desc	text	No
expect	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	5375	A	No
case	BTREE	No	No	case		A	No
version	BTREE	No	No	version		A	No

zt_company

Column	Type	Null	Default
id	mediumint(8)	No
name	char(120)	Yes	NULL
phone	char(20)	Yes	NULL
fax	char(20)	Yes	NULL
address	char(120)	Yes	NULL
zipcode	char(10)	Yes	NULL
website	char(120)	Yes	NULL
backyard	char(120)	Yes	NULL
guest	enum('1', '0')	No	0
admins	char(255)	Yes	NULL
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	1	A	No

zt_compile

Column	Type	Null	Default
id	mediumint(8)	No
name	varchar(50)	No
job	mediumint(8)	No
queue	mediumint(8)	No
status	varchar(255)	No
logs	text	Yes	NULL
atTime	varchar(10)	No
testtask	mediumint(8)	Yes	NULL
tag	varchar(255)	No
times	tinyint(3)	No	0
createdBy	varchar(30)	No
createdDate	datetime	No
updateDate	datetime	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_config

Column	Type	Null
id	mediumint(8)	No
owner	char(30)	No
module	varchar(30)	No
section	char(30)	No
key	char(30)	No
value	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	502	A	No
unique	BTREE	Yes	No	owner		A	No
				module		A	No
				section		A	No
				key	502	A	No

zt_cron

Column	Type	Null	Default
id	mediumint(8)	No
m	varchar(20)	No
h	varchar(20)	No
dom	varchar(20)	No
mon	varchar(20)	No
dow	varchar(20)	No
command	text	No
remark	varchar(255)	No
type	varchar(20)	No
buildin	tinyint(1)	No	0
status	varchar(20)	No
lastTime	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	15	A	No
lastTime	BTREE	No	No	lastTime		A	No

zt_deploy

Column	Type	Null
id	mediumint(8)	No
begin	datetime	No
end	datetime	No
name	varchar(255)	No
desc	text	No
status	varchar(20)	No
owner	char(30)	No
members	text	No
notify	text	No
cases	text	No
createdBy	char(30)	No
createdDate	datetime	No
result	varchar(20)	No
deleted	enum('0', '1')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_deployproduct

Column	Type	Null
deploy	mediumint(8)	No
product	mediumint(8)	No
release	mediumint(8)	No
package	varchar(255)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
deploy_product_release	BTREE	Yes	No	deploy		A	No
				product		A	No
				release	0	A	No

zt_deployscope

Column	Type	Null
deploy	mediumint(8)	No
service	mediumint(8)	No
hosts	text	No
remove	text	No
add	text	No

zt_deploystep

Column	Type	Null
id	mediumint(8)	No
deploy	mediumint(8)	No
title	varchar(255)	No
begin	datetime	No
end	datetime	No
stage	varchar(30)	No
content	text	No
status	varchar(30)	No
assignedTo	char(30)	No
assignedDate	datetime	No
finishedBy	char(30)	No
finishedDate	datetime	No
createdBy	char(30)	No
createdDate	datetime	No
deleted	enum('0', '1')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_dept

Column	Type	Null	Default
id	mediumint(8)	No
name	char(60)	No
parent	mediumint(8)	No	0
path	char(255)	No
grade	tinyint(3)	No	0
order	smallint(4)	No	0
position	char(30)	No
function	char(255)	No
manager	char(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	8	A	No
parent	BTREE	No	No	parent		A	No
path	BTREE	No	No	path		A	No

zt_doc

Column	Type	Null	Default
id	mediumint(8)	No
product	mediumint(8)	No
project	mediumint(8)	No
lib	varchar(30)	No
module	varchar(30)	No
title	varchar(255)	No
keywords	varchar(255)	No
type	varchar(30)	No
parent	smallint(5)	No	0
path	char(255)	No
grade	tinyint(3)	No	0
order	smallint(5)	No	0
views	smallint(5)	No
collector	text	No
addedBy	varchar(30)	No
addedDate	datetime	No
editedBy	varchar(30)	No
editedDate	datetime	No
mailto	text	Yes	NULL
acl	varchar(10)	No	open
groups	varchar(255)	No
users	text	No
version	smallint(5)	No	1
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	3	A	No
product	BTREE	No	No	product		A	No
project	BTREE	No	No	project		A	No
lib	BTREE	No	No	lib		A	No

zt_doccontent

Column	Type	Null
id	mediumint(8)	No
doc	mediumint(8)	No
title	varchar(255)	No
digest	varchar(255)	No
content	longtext	No
files	text	No
type	varchar(10)	No
version	smallint(5)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	4	A	No
doc_version	BTREE	Yes	No	doc		A	No
doc_version	BTREE	Yes	No	version	4	A	No

zt_doclib

Column	Type	Null	Default
id	smallint(5)	No
type	varchar(30)	No
product	mediumint(8)	No
project	mediumint(8)	No
name	varchar(60)	No
acl	varchar(10)	No	open
groups	varchar(255)	No
users	text	No
main	enum('0', '1')	No	0
collector	text	No
order	tinyint(5)	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	517	A	No
product	BTREE	No	No	product		A	No
project	BTREE	No	No	project		A	No

zt_effort

Column	Type	Null	Default
id	mediumint(8)	No
objectType	varchar(30)	No
objectID	mediumint(8)	No
product	varchar(255)	No
project	mediumint(9)	No
account	varchar(30)	No
work	text	Yes	NULL
date	date	No
left	float	No
consumed	float	No
begin	smallint(4)	No
end	smallint(4)	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	18618	A	No
project	BTREE	No	No	project	229	A	No
objectID	BTREE	No	No	objectID	6206	A	No
date	BTREE	No	No	date	642	A	No
account	BTREE	No	No	account	39	A	No

zt_entry

Column	Type	Null	Default
id	mediumint(8)	No
name	varchar(50)	No
account	varchar(30)	No
code	varchar(20)	No
key	varchar(32)	No
freePasswd	enum('0', '1')	No	0
ip	varchar(100)	No
desc	text	No
createdBy	varchar(30)	No
createdDate	datetime	No
calledTime	int(10)	No	0
editedBy	varchar(30)	No
editedDate	datetime	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_extension

Column	Type	Null	Default
id	mediumint(8)	No
name	varchar(150)	No
code	varchar(30)	No
version	varchar(50)	No
author	varchar(100)	No
desc	text	No
license	text	No
type	varchar(20)	No	extension
site	varchar(150)	No
zentaoCompatible	varchar(100)	No
installedTime	datetime	No
depends	varchar(100)	No
dirs	mediumtext	No
files	mediumtext	No
status	varchar(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
code	BTREE	Yes	No	code	0	A	No
name	BTREE	No	No	name		A	No
installedTime	BTREE	No	No	installedTime		A	No

zt_faq

Column	Type	Null
id	mediumint(9)	No
module	mediumint(9)	No
product	mediumint(9)	No
question	varchar(255)	No
answer	text	No
addedtime	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_feedback

Column	Type	Null	Default
id	mediumint(8)	No
product	mediumint(8)	No
module	mediumint(8)	No
title	varchar(255)	No
desc	text	No
status	varchar(30)	No
subStatus	varchar(30)	No
public	enum('0', '1')	No	0
notify	enum('0', '1')	No	0
likes	text	No
result	mediumint(8)	No
faq	mediumint(8)	No
openedBy	char(30)	No
openedDate	datetime	No
reviewedBy	varchar(255)	No
reviewedDate	datetime	No
processedBy	char(30)	No
processedDate	datetime	No
closedBy	char(30)	No
closedDate	datetime	No
closedReason	varchar(30)	No
editedBy	char(30)	No
editedDate	datetime	No
assignedTo	varchar(255)	No
assignedDate	datetime	No
mailto	varchar(255)	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_feedbackview

Column	Type	Null	Default	Comments
account	char(30)	No
product	mediumint(8)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
account_product	BTREE	Yes	No	account		A	No
account_product	BTREE	Yes	No	product	0	A	No

zt_file

Column	Type	Null	Default
id	mediumint(8)	No
pathname	char(100)	No
title	char(255)	No
extension	char(30)	No
size	int(10)	No	0
objectType	char(30)	No
objectID	mediumint(9)	No
addedBy	char(30)	No
addedDate	datetime	No
downloads	mediumint(8)	No	0
extra	varchar(255)	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	6221	A	No
objectType	BTREE	No	No	objectType		A	No
objectID	BTREE	No	No	objectID		A	No

zt_group

Column	Type	Null	Default
id	mediumint(8)	No
PRJ	mediumint(8)	No	0
name	char(30)	No
role	char(30)	No
desc	char(255)	No
acl	text	Yes	NULL
developer	enum('0', '1')	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	19	A	No

zt_grouppriv

Column	Type	Null	Default
group	mediumint(8)	No	0
module	char(30)	No
method	char(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
group	BTREE	Yes	No	group		A	No
				module		A	No
				method	4571	A	No

zt_history

Column	Type	Null	Default
id	mediumint(8)	No
action	mediumint(8)	No	0
field	varchar(30)	No
old	text	No
new	text	No
diff	mediumtext	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	121348	A	No
action	BTREE	No	No	action		A	No

zt_holiday

Column	Type	Null	Default
id	mediumint(8)	No
name	varchar(30)	No
type	enum('holiday', 'working')	No	holiday
desc	text	No
year	char(4)	No
begin	date	No
end	date	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
year	BTREE	No	No	year		A	No
name	BTREE	No	No	name		A	No

zt_host

Column	Type	Null	Default
id	mediumint(8)	No
assetID	mediumint(8)	No
serverRoom	mediumint(8)	No
cabinet	varchar(128)	No
serverModel	varchar(256)	No
hardwareType	varchar(64)	No
hostType	enum('physical', 'virtual')	No
cpuBrand	varchar(128)	No
cpuModel	varchar(128)	No
cpuNumber	varchar(16)	No
cpuCores	varchar(30)	No
cpuRate	varchar(30)	No
memory	varchar(30)	No
diskType	varchar(30)	No
diskSize	varchar(30)	No
unit	enum('GB', 'TB')	No	GB
privateIP	varchar(128)	No
publicIP	varchar(128)	No
nic	varchar(128)	No
mac	varchar(128)	No
osName	varchar(64)	No
osVersion	varchar(64)	No
webserver	varchar(128)	No
database	varchar(128)	No
language	varchar(16)	No
status	enum('online', 'offline')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_im_chat

Column	Type	Null	Default
id	mediumint(8)	No
gid	char(40)	No
name	varchar(60)	No
type	varchar(20)	No	group
admins	varchar(255)	No
committers	varchar(255)	No
subject	mediumint(8)	No	0
public	enum('0', '1')	No	0
createdBy	varchar(30)	No
createdDate	datetime	No	0000-00-00 00:00:00
editedBy	varchar(30)	No
editedDate	datetime	No	0000-00-00 00:00:00
lastActiveTime	datetime	No	0000-00-00 00:00:00
dismissDate	datetime	No	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
gid	BTREE	No	No	gid		A	No
name	BTREE	No	No	name		A	No
type	BTREE	No	No	type		A	No
public	BTREE	No	No	public		A	No
createdBy	BTREE	No	No	createdBy		A	No
editedBy	BTREE	No	No	editedBy		A	No

zt_im_chatuser

Column	Type	Null	Default
id	mediumint(8)	No
cgid	char(40)	No
user	mediumint(8)	No	0
order	smallint(5)	No	0
star	enum('0', '1')	No	0
hide	enum('0', '1')	No	0
mute	enum('0', '1')	No	0
freeze	enum('0', '1')	No	0
join	datetime	No	0000-00-00 00:00:00
quit	datetime	No	0000-00-00 00:00:00
category	varchar(40)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
chatuser	BTREE	Yes	No	cgid		A	No
chatuser	BTREE	Yes	No	user	0	A	No
cgid	BTREE	No	No	cgid		A	No
user	BTREE	No	No	user		A	No
order	BTREE	No	No	order		A	No
star	BTREE	No	No	star		A	No
hide	BTREE	No	No	hide		A	No

zt_im_client

Column	Type	Null	Default
id	int(11)	No
version	char(30)	No
desc	varchar(100)	No
changeLog	text	No
strategy	varchar(10)	No
downloads	text	No
createdDate	datetime	No
createdBy	varchar(30)	No
editedDate	datetime	No
editedBy	varchar(30)	No
status	enum('released', 'wait')	No	wait

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_im_conference

Column	Type	Null	Default
id	mediumint(8)	No
rid	char(24)	No
cgid	char(40)	No
status	enum('closed', 'open')	No	closed
participants	text	No
openedBy	mediumint(8)	No	0
openedDate	datetime	No	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_im_conferenceaction

Column	Type	Null	Default
id	mediumint(8)	No
rid	char(24)	No
type	enum('create', 'join', 'leave', 'close')	No	create
user	mediumint(8)	No	0
date	datetime	No	0000-00-00 00:00:00

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_im_message

Column	Type	Null	Default
id	mediumint(8)	No
gid	char(40)	No
cgid	char(40)	No
user	varchar(30)	No
date	datetime	No	0000-00-00 00:00:00
order	bigint(8)	No
type	enum('normal', 'broadcast', 'notify')	No	normal
content	text	No
contentType	enum('text', 'plain', 'emotion', 'image', 'file', 'code', 'object')	No	text
data	text	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	22141	A	No
mgid	BTREE	No	No	gid	22141	A	No
mcgid	BTREE	No	No	cgid	5	A	No
muser	BTREE	No	No	user	5	A	No
mtype	BTREE	No	No	type	5	A	No

zt_im_messagestatus

Column	Type	Null	Default
user	mediumint(8)	No	0
message	int(11)	No
status	enum('waiting', 'sent', 'readed', 'deleted')	No	waiting

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
user	BTREE	Yes	No	user		A	No
user	BTREE	Yes	No	message	22328	A	No

zt_im_queue

Column	Type	Null
id	mediumint(8)	No
type	char(30)	No
content	text	No
addDate	datetime	No
processDate	datetime	No
result	text	No
status	char(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_jenkins

Column	Type	Null	Default
id	smallint(8)	No
name	varchar(50)	No
url	varchar(255)	Yes	NULL
account	varchar(30)	Yes	NULL
password	varchar(255)	No
token	varchar(255)	Yes	NULL
createdBy	varchar(30)	No
createdDate	datetime	No
editedBy	varchar(30)	No
editedDate	datetime	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_job

Column	Type	Null	Default
id	mediumint(8)	No
name	varchar(50)	No
repo	mediumint(8)	No
product	mediumint(8)	No
frame	varchar(20)	No
jkHost	mediumint(8)	No
jkJob	varchar(500)	No
triggerType	varchar(255)	No
svnDir	varchar(255)	No
atDay	varchar(20)	Yes	NULL
atTime	varchar(10)	Yes	NULL
customParam	text	Yes	NULL
comment	varchar(255)	Yes	NULL
createdBy	varchar(30)	No
createdDate	datetime	No
editedBy	varchar(30)	No
editedDate	datetime	No
lastExec	datetime	Yes	NULL
lastStatus	varchar(255)	Yes	NULL
lastTag	varchar(255)	Yes	NULL
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_lang

Column	Type	Null	Default
id	mediumint(8)	No
lang	varchar(30)	No
module	varchar(30)	No
section	varchar(30)	No
key	varchar(60)	No
value	text	No
system	enum('0', '1')	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	70	A	No
lang	BTREE	Yes	No	lang		A	No
				module		A	No
				section		A	No
				key	70	A	No

zt_leave

Column	Type	Null	Default
id	mediumint(8)	No
year	char(4)	No
begin	date	No
end	date	No
start	time	No
finish	time	No
hours	float(4,1)	No	0.0
backDate	datetime	No
type	varchar(30)	No
desc	text	No
status	varchar(30)	No
createdBy	char(30)	No
createdDate	datetime	No
reviewedBy	char(30)	No
reviewedDate	datetime	No
level	tinyint(3)	No
assignedTo	varchar(30)	No
reviewers	text	No
backReviewers	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
year	BTREE	No	No	year		A	No
type	BTREE	No	No	type		A	No
status	BTREE	No	No	status		A	No
createdBy	BTREE	No	No	createdBy		A	No

zt_lieu

Column	Type	Null	Default
id	mediumint(8)	No
year	char(4)	No
begin	date	No
end	date	No
start	time	No
finish	time	No
hours	float(4,1)	No	0.0
overtime	char(255)	No
trip	char(255)	No
desc	text	No
status	varchar(30)	No
createdBy	char(30)	No
createdDate	datetime	No
reviewedBy	char(30)	No
reviewedDate	datetime	No
level	tinyint(3)	No
assignedTo	varchar(30)	No
reviewers	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
year	BTREE	No	No	year		A	No
status	BTREE	No	No	status		A	No
createdBy	BTREE	No	No	createdBy		A	No

zt_log

Column	Type	Null
id	mediumint(8)	No
objectType	varchar(30)	No
objectID	mediumint(8)	No
action	mediumint(8)	No
date	datetime	No
url	varchar(255)	No
contentType	varchar(30)	No
data	text	No
result	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
objectType	BTREE	No	No	objectType		A	No
obejctID	BTREE	No	No	objectID		A	No

zt_module

Column	Type	Null	Default
id	mediumint(8)	No
root	mediumint(8)	No	0
branch	mediumint(8)	No	0
name	char(60)	No
parent	mediumint(8)	No	0
path	char(255)	No
grade	tinyint(3)	No	0
order	smallint(5)	No	0
type	char(30)	No
owner	varchar(30)	No
collector	text	No
short	varchar(30)	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	254	A	No
root	BTREE	No	No	root		A	No
type	BTREE	No	No	type		A	No
path	BTREE	No	No	path		A	No

zt_notify

Column	Type	Null	Default
id	mediumint(8)	No
objectType	varchar(50)	No
objectID	mediumint(8)	No
action	mediumint(9)	No
toList	varchar(255)	No
ccList	text	No
subject	varchar(255)	No
data	text	No
createdBy	char(30)	No
createdDate	datetime	No
sendTime	datetime	No
status	varchar(10)	No	wait
failReason	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	85	A	No
objectType_toList_status	BTREE	No	No	objectType		A	No
				toList		A	No
				status		A	No

zt_oauth

Column	Type	Null
account	varchar(30)	No
openID	varchar(255)	No
providerType	varchar(30)	No
providerID	mediumint(8)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
account	BTREE	No	No	account	A	No
providerType	BTREE	No	No	providerType	A	No
providerID	BTREE	No	No	providerID	A	No

zt_overtime

Column	Type	Null	Default
id	mediumint(8)	No
year	char(4)	No
begin	date	No
end	date	No
start	time	No
finish	time	No
hours	float(4,1)	No	0.0
leave	varchar(255)	No
type	varchar(30)	No
desc	text	No
status	varchar(30)	No
rejectReason	varchar(100)	No
createdBy	char(30)	No
createdDate	datetime	No
reviewedBy	char(30)	No
reviewedDate	datetime	No
level	tinyint(3)	No
assignedTo	varchar(30)	No
reviewers	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
year	BTREE	No	No	year		A	No
type	BTREE	No	No	type		A	No
status	BTREE	No	No	status		A	No
createdBy	BTREE	No	No	createdBy		A	No

zt_planstory

Column	Type	Null
plan	mediumint(8)	No
story	mediumint(8)	No
order	mediumint(9)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
plan_story	BTREE	Yes	No	plan		A	No
plan_story	BTREE	Yes	No	story	1239	A	No

zt_product

Column	Type	Null	Default
id	mediumint(8)	No
name	varchar(90)	No
code	varchar(45)	No
line	mediumint(8)	No
type	varchar(30)	No	normal
status	varchar(30)	No
subStatus	varchar(30)	No
desc	text	No
PO	varchar(30)	No
QD	varchar(30)	No
RD	varchar(30)	No
feedback	varchar(30)	No
acl	enum('open', 'private', 'custom')	No	open
whitelist	text	No
createdBy	varchar(30)	No
createdDate	datetime	No
createdVersion	varchar(20)	No
order	mediumint(8)	No
deleted	enum('0', '1')	No	0
mailto	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	100	A	No
order	BTREE	No	No	order		A	No
acl	BTREE	No	No	acl		A	No

zt_productplan

Column	Type	Null	Default
id	mediumint(8)	No
product	mediumint(8)	No
branch	mediumint(8)	No
parent	mediumint(9)	No	0
title	varchar(90)	No
desc	text	No
begin	date	No
end	date	No
order	text	No
deleted	enum('0', '1')	No	0
mailto	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	414	A	No
product	BTREE	No	No	product	82	A	No
end	BTREE	No	No	end	138	A	No

zt_project

Column	Type	Null	Default
id	mediumint(8)	No
isCat	enum('1', '0')	No	0
catID	mediumint(8)	No
type	varchar(20)	No	sprint
parent	mediumint(8)	No	0
name	varchar(90)	No
code	varchar(45)	No
begin	date	No
end	date	No
days	smallint(5)	No
status	varchar(10)	No
subStatus	varchar(30)	No
statge	enum('1', '2', '3', '4', '5')	No	1
pri	enum('1', '2', '3', '4')	No	1
desc	text	No
openedBy	varchar(30)	No
openedDate	datetime	No
openedVersion	varchar(20)	No
closedBy	varchar(30)	No
closedDate	datetime	No
canceledBy	varchar(30)	No
canceledDate	datetime	No
PO	varchar(30)	No
PM	varchar(30)	No
QD	varchar(30)	No
RD	varchar(30)	No
team	varchar(90)	No
acl	enum('open', 'private', 'custom')	No	open
whitelist	text	No
order	mediumint(8)	No
deleted	enum('0', '1')	No	0
mailto	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	417	A	No
parent	BTREE	No	No	parent	3	A	No
begin	BTREE	No	No	begin	417	A	No
end	BTREE	No	No	end	417	A	No
status	BTREE	No	No	status	13	A	No
order	BTREE	No	No	order	417	A	No
acl	BTREE	No	No	acl	6	A	No

zt_projectproduct

Column	Type	Null
project	mediumint(8)	No
product	mediumint(8)	No
branch	mediumint(8)	No
plan	mediumint(8)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	project		A	No
PRIMARY	BTREE	Yes	No	product	436	A	No

zt_projectstory

Column	Type	Null	Default
project	mediumint(8)	No	0
product	mediumint(8)	No
story	mediumint(8)	No	0
version	smallint(6)	No	1
order	smallint(6)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
project	BTREE	Yes	No	project		A	No
project	BTREE	Yes	No	story	1077	A	No

zt_relation

Column	Type	Null
id	int(8)	No
program	mediumint(8)	No
product	mediumint(8)	No
project	mediumint(8)	No
AType	char(30)	No
AID	mediumint(8)	No
AVersion	char(30)	No
relation	char(30)	No
BType	char(30)	No
BID	mediumint(8)	No
BVersion	char(30)	No
extra	char(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
relation	BTREE	Yes	No	relation		A	No
				AType		A	No
				BType		A	No
				AID		A	No
				BID	0	A	No

zt_relationoftasks

Column	Type	Null
id	mediumint(8)	No
project	mediumint(8)	No
pretask	mediumint(8)	No
condition	enum('begin', 'end')	No
task	mediumint(8)	No
action	enum('begin', 'end')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
relationoftasks	BTREE	No	No	project		A	No
relationoftasks	BTREE	No	No	task		A	No

zt_release

Column	Type	Null	Default
id	mediumint(8)	No
product	mediumint(8)	No	0
branch	mediumint(8)	No	0
build	mediumint(8)	No
name	varchar(255)	No
marker	enum('0', '1')	No	0
date	date	No
stories	text	No
bugs	text	No
leftBugs	text	No
desc	text	No
status	varchar(20)	No	normal
subStatus	varchar(30)	No
deleted	enum('0', '1')	No	0
mailto	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	9	A	No
product	BTREE	No	No	product		A	No
build	BTREE	No	No	build		A	No

zt_repo

Column	Type	Null	Default
id	mediumint(9)	No
name	varchar(255)	No
path	varchar(255)	No
prefix	varchar(100)	No
encoding	varchar(20)	No
SCM	varchar(10)	No
client	varchar(100)	No
commits	mediumint(8)	No
account	varchar(30)	No
password	varchar(30)	No
encrypt	varchar(30)	No	plain
acl	text	No
synced	tinyint(1)	No	0
lastSync	datetime	No
desc	text	No
deleted	tinyint(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_repobranch

Column	Type	Null
repo	mediumint(8)	No
revision	mediumint(8)	No
branch	varchar(255)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
repo_revision_branch	BTREE	Yes	No	repo		A	No
				revision		A	No
				branch	0	A	No
branch	BTREE	No	No	branch		A	No
revision	BTREE	No	No	revision		A	No

zt_repofiles

Column	Type	Null
id	int(10)	No
repo	mediumint(8)	No
revision	mediumint(8)	No
path	varchar(255)	No
parent	varchar(255)	No
type	varchar(20)	No
action	char(1)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
path	BTREE	No	No	path		A	No
parent	BTREE	No	No	parent		A	No

zt_repohistory

Column	Type	Null
id	mediumint(9)	No
repo	mediumint(9)	No
revision	varchar(40)	No
commit	mediumint(8)	No
comment	text	No
committer	varchar(100)	No
time	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
repo	BTREE	No	No	repo		A	No
repo	BTREE	No	No	revision		A	No

zt_report

Column	Type	Null	Default
id	mediumint(9)	No
code	varchar(100)	No
name	text	No
module	varchar(100)	No
sql	text	No
vars	text	No
langs	text	No
params	text	No
step	tinyint(1)	No	2
desc	text	No
addedBy	char(30)	No
addedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	27	A	No
code	BTREE	Yes	No	code	27	A	No

zt_score

Column	Type	Null	Default
id	bigint(12)	No
account	varchar(30)	No
module	varchar(30)	No
method	varchar(30)	No
desc	varchar(250)	No
before	int(11)	No	0
score	int(11)	No	0
after	int(11)	No	0
time	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
account	BTREE	No	No	account		A	No
model	BTREE	No	No	module		A	No
method	BTREE	No	No	method		A	No

zt_searchdict

Column	Type	Null	Default	Comments
key	smallint(5)	No
value	char(3)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	key	2472	A	No

zt_searchindex

Column	Type	Null
id	mediumint(8)	No
objectType	char(20)	No
objectID	mediumint(9)	No
title	text	No
content	text	No
addedDate	datetime	No
editedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	38608	A	No
object	BTREE	Yes	No	objectType		A	No
object	BTREE	Yes	No	objectID	38608	A	No
addedDate	BTREE	No	No	addedDate		A	No
content	FULLTEXT	No	No	content			No
title	FULLTEXT	No	No	title			No

zt_serverroom

Column	Type	Null	Default
id	mediumint(8)	No
name	varchar(128)	No
city	varchar(128)	No
line	varchar(20)	No
bandwidth	varchar(128)	No
provider	varchar(128)	No
owner	varchar(30)	No
createdBy	char(30)	No
createdDate	datetime	No
editedBy	char(30)	No
editedDate	datetime	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_service

Column	Type	Null	Default
id	mediumint(8)	No
name	varchar(255)	No
version	varchar(64)	No
color	char(7)	No
desc	text	Yes	NULL
dept	varchar(128)	No
devel	varchar(30)	No
qa	varchar(30)	No
ops	varchar(30)	No
hosts	text	Yes	NULL
softName	varchar(128)	No
softVersion	varchar(128)	No
type	varchar(20)	No
createdBy	char(30)	No
createdDate	datetime	No
editedBy	char(30)	No
editedDate	datetime	No
parent	mediumint(8)	No	0
path	char(255)	No
grade	tinyint(3)	No	0
order	smallint(5)	No	0
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_story

Column	Type	Null	Default
id	mediumint(8)	No
parent	mediumint(9)	No	0
product	mediumint(8)	No	0
branch	mediumint(8)	No	0
module	mediumint(8)	No	0
plan	text	Yes	NULL
source	varchar(20)	No
sourceNote	varchar(255)	No
fromBug	mediumint(8)	No	0
feedback	mediumint(8)	No	0
title	varchar(255)	No
keywords	varchar(255)	No
type	varchar(30)	No	story
pri	tinyint(3)	No	3
estimate	float	No
status	enum('', 'changed', 'active', 'draft', 'closed')	No
subStatus	varchar(30)	No
color	char(7)	No
stage	enum('', 'wait', 'planned', 'projected', 'developing', 'developed', 'testing', 'tested', 'verified', 'released', 'closed')	No	wait
stagedBy	char(30)	No
mailto	text	Yes	NULL
openedBy	varchar(30)	No
openedDate	datetime	No
assignedTo	varchar(30)	No
assignedDate	datetime	No
lastEditedBy	varchar(30)	No
lastEditedDate	datetime	No
reviewedBy	varchar(255)	No
reviewedDate	date	No
closedBy	varchar(30)	No
closedDate	datetime	No
closedReason	varchar(30)	No
toBug	mediumint(8)	No
childStories	varchar(255)	No
linkStories	varchar(255)	No
duplicateStory	mediumint(8)	No
version	smallint(6)	No	1
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	2505	A	No
product	BTREE	No	No	product	96	A	No
status	BTREE	No	No	status	13	A	No
assignedTo	BTREE	No	No	assignedTo	54	A	No

zt_storyspec

Column	Type	Null
story	mediumint(9)	No
version	smallint(6)	No
title	varchar(255)	No
spec	text	No
verify	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
story	BTREE	Yes	No	story		A	No
story	BTREE	Yes	No	version	9170	A	No

zt_storystage

Column	Type	Null
story	mediumint(8)	No
branch	mediumint(8)	No
stage	varchar(50)	No
stagedBy	char(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
story_branch	BTREE	Yes	No	story		A	No
story_branch	BTREE	Yes	No	branch	379	A	No
story	BTREE	No	No	story		A	No

zt_suitecase

Column	Type	Null
suite	mediumint(8)	No
product	mediumint(8)	No
case	mediumint(8)	No
version	smallint(5)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
suitecase	BTREE	Yes	No	suite		A	No
suitecase	BTREE	Yes	No	case	0	A	No

zt_task

Column	Type	Null	Default
id	mediumint(8)	No
parent	mediumint(8)	No	0
project	mediumint(8)	No	0
module	mediumint(8)	No	0
story	mediumint(8)	No	0
storyVersion	smallint(6)	No	1
fromBug	mediumint(8)	No	0
feedback	mediumint(8)	No
name	varchar(255)	No
type	varchar(20)	No
pri	tinyint(3)	No	0
estimate	float	No
consumed	float	No
left	float	No
deadline	date	No
status	enum('wait', 'doing', 'done', 'pause', 'cancel', 'closed')	No	wait
subStatus	varchar(30)	No
color	char(7)	No
mailto	text	Yes	NULL
desc	text	No
openedBy	varchar(30)	No
openedDate	datetime	No
assignedTo	varchar(30)	No
assignedDate	datetime	No
estStarted	date	No
realStarted	datetime	No
finishedBy	varchar(30)	No
finishedDate	datetime	No
finishedList	text	No
canceledBy	varchar(30)	No
canceledDate	datetime	No
closedBy	varchar(30)	No
closedDate	datetime	No
closedReason	varchar(30)	No
lastEditedBy	varchar(30)	No
lastEditedDate	datetime	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	1107	A	No
project	BTREE	No	No	project	138	A	No
story	BTREE	No	No	story	553	A	No
assignedTo	BTREE	No	No	assignedTo	32	A	No
parent	BTREE	No	No	parent	11	A	No

zt_taskestimate

Column	Type	Null	Default
id	mediumint(8)	No
task	mediumint(8)	No	0
date	date	No
left	float	No	0
consumed	float	No
account	char(30)	No
work	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
task	BTREE	No	No	task		A	No

zt_team

Column	Type	Null	Default
id	mediumint(8)	No
root	mediumint(8)	No	0
type	enum('project', 'task')	No	project
account	char(30)	No
role	char(30)	No
limited	char(8)	No	no
join	date	No	0000-00-00
days	smallint(5)	No
hours	float(2,1)	No	0.0
estimate	decimal(12,2)	No	0.00
consumed	decimal(12,2)	No	0.00
left	decimal(12,2)	No	0.00
order	tinyint(3)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	2409	A	No
team	BTREE	Yes	No	root		A	No
				type		A	No
				account	2409	A	No

zt_testreport

Column	Type	Null
id	mediumint(8)	No
product	mediumint(8)	No
project	mediumint(8)	No
tasks	varchar(255)	No
builds	varchar(255)	No
title	varchar(255)	No
begin	date	No
end	date	No
owner	char(30)	No
members	text	No
stories	text	No
bugs	text	No
cases	text	No
report	text	No
objectType	varchar(20)	No
objectID	mediumint(8)	No
createdBy	char(30)	No
createdDate	datetime	No
deleted	enum('0', '1')	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_testresult

Column	Type	Null
id	mediumint(8)	No
run	mediumint(8)	No
case	mediumint(8)	No
version	smallint(5)	No
job	mediumint(8)	No
compile	mediumint(8)	No
caseResult	char(30)	No
stepResults	text	No
lastRunner	varchar(30)	No
date	datetime	No
duration	float	No
xml	text	No
deploy	mediumint(8)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	21871	A	No
case	BTREE	No	No	case	7290	A	No
version	BTREE	No	No	version	5	A	No
run	BTREE	No	No	run	21871	A	No

zt_testrun

Column	Type	Null	Default
id	mediumint(8)	No
task	mediumint(8)	No	0
case	mediumint(8)	No	0
version	tinyint(3)	No	0
assignedTo	char(30)	No
lastRunner	varchar(30)	No
lastRunDate	datetime	No
lastRunResult	char(30)	No
status	char(30)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	22436	A	No
task	BTREE	Yes	No	task		A	No
task	BTREE	Yes	No	case	22436	A	No

zt_testsuite

Column	Type	Null
id	mediumint(8)	No
product	mediumint(8)	No
name	varchar(255)	No
desc	text	No
type	varchar(20)	No
addedBy	char(30)	No
addedDate	datetime	No
lastEditedBy	char(30)	No
lastEditedDate	datetime	No
deleted	enum('0', '1')	No
mailto	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
product	BTREE	No	No	product		A	No

zt_testtask

Column	Type	Null	Default
id	mediumint(8)	No
name	char(90)	No
product	mediumint(8)	No
project	mediumint(8)	No	0
build	char(30)	No
owner	varchar(30)	No
pri	tinyint(3)	No	0
begin	date	No
end	date	No
mailto	text	Yes	NULL
desc	text	No
report	text	No
status	enum('blocked', 'doing', 'wait', 'done')	No	wait
auto	varchar(10)	No	no
subStatus	varchar(30)	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	876	A	No
product	BTREE	No	No	product	58	A	No
build	BTREE	No	No	build	876	A	No

zt_todo

Column	Type	Null	Default
id	mediumint(8)	No
account	char(30)	No
date	date	No
begin	smallint(4)	No
end	smallint(4)	No
feedback	mediumint(8)	No
type	char(10)	No
cycle	tinyint(3)	No	0
idvalue	mediumint(8)	No	0
pri	tinyint(3)	No
name	char(150)	No
desc	text	No
status	enum('wait', 'doing', 'done', 'closed')	No	wait
private	tinyint(1)	No
config	varchar(255)	No
assignedTo	varchar(30)	No
assignedBy	varchar(30)	No
assignedDate	datetime	No
finishedBy	varchar(30)	No
finishedDate	datetime	No
closedBy	varchar(30)	No
closedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	81	A	No
account	BTREE	No	No	account		A	No
assignedTo	BTREE	No	No	assignedTo		A	No
finishedBy	BTREE	No	No	finishedBy		A	No
date	BTREE	No	No	date		A	No

zt_translation

Column	Type	Null
id	mediumint(8)	No
lang	varchar(30)	No
module	varchar(30)	No
key	varchar(100)	No
value	text	No
referer	text	No
status	varchar(30)	No
translator	char(30)	No
translatedTime	datetime	No
reviewer	char(30)	No
reviewedTime	datetime	No
reason	text	No
version	varchar(20)	No
mode	varchar(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
lang_module_key_mode	BTREE	Yes	No	lang		A	No
				module		A	No
				key		A	No
				mode	0	A	No

zt_trip

Column	Type	Null	Default
id	mediumint(8)	No
type	enum('trip', 'egress')	No	trip
customers	varchar(20)	No
name	char(30)	No
desc	text	No
year	char(4)	No
begin	date	No
end	date	No
start	time	No
finish	time	No
from	char(50)	No
to	char(50)	No
createdBy	char(30)	No
createdDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
year	BTREE	No	No	year		A	No
createdBy	BTREE	No	No	createdBy		A	No

zt_user

Column	Type	Null	Default
id	mediumint(8)	No
dept	mediumint(8)	No	0
account	char(30)	No
type	char(30)	No	inside
password	char(32)	No
role	char(10)	No
realname	varchar(100)	No
nickname	char(60)	No
commiter	varchar(100)	No
avatar	char(30)	No
birthday	date	No	0000-00-00
gender	enum('f', 'm')	No	f
email	char(90)	No
skype	char(90)	No
qq	char(20)	No
mobile	char(11)	No
phone	char(20)	No
weixin	varchar(90)	No
dingding	varchar(90)	No
slack	varchar(90)	No
whatsapp	varchar(90)	No
address	char(120)	No
zipcode	char(10)	No
join	date	No	0000-00-00
visits	mediumint(8)	No	0
ip	char(15)	No
last	int(10)	No	0
fails	tinyint(5)	No	0
locked	datetime	No	0000-00-00 00:00:00
feedback	enum('0', '1')	No	0
ranzhi	char(30)	No
ldap	char(30)	No
score	int(11)	No	0
scoreLevel	int(11)	No	0
deleted	enum('0', '1')	No	0
clientStatus	enum('online', 'away', 'busy', 'offline')	No	offline
clientLang	varchar(10)	No	zh-cn

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	57	A	No
account	BTREE	Yes	No	account	57	A	No
dept	BTREE	No	No	dept		A	No
email	BTREE	No	No	email		A	No
commiter	BTREE	No	No	commiter		A	No
deleted	BTREE	No	No	deleted		A	No

zt_usercontact

Column	Type	Null
id	mediumint(8)	No
account	char(30)	No
listName	varchar(60)	No
userList	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
account	BTREE	No	No	account		A	No

zt_usergroup

Column	Type	Null	Default	Comments
account	char(30)	No
group	mediumint(8)	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
account	BTREE	Yes	No	account		A	No
account	BTREE	Yes	No	group	56	A	No

zt_userquery

Column	Type	Null	Default
id	mediumint(8)	No
account	char(30)	No
module	varchar(30)	No
title	varchar(90)	No
form	text	No
sql	text	No
shortcut	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	7	A	No
account	BTREE	No	No	account		A	No
module	BTREE	No	No	module		A	No

zt_usertpl

Column	Type	Null	Default
id	mediumint(8)	No
account	char(30)	No
type	char(30)	No
title	varchar(150)	No
content	text	No
public	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2	A	No
account	BTREE	No	No	account		A	No

zt_userview

Column	Type	Null
account	char(30)	No
products	mediumtext	No
projects	mediumtext	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
account	BTREE	Yes	No	account	57	A	No

zt_webhook

Column	Type	Null	Default
id	mediumint(8)	No
type	varchar(15)	No	default
name	varchar(50)	No
url	varchar(255)	No
domain	varchar(255)	No
secret	varchar(255)	No
contentType	varchar(30)	No	application/json
sendType	enum('sync', 'async')	No	sync
products	text	No
projects	text	No
params	varchar(100)	No
actions	text	No
desc	text	No
createdBy	varchar(30)	No
createdDate	datetime	No
editedBy	varchar(30)	No
editedDate	datetime	No
deleted	enum('0', '1')	No	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2	A	No

zt_workflow

Column	Type	Null	Default
id	mediumint(8)	No
parent	varchar(30)	No
child	varchar(30)	No
type	varchar(10)	No	flow
navigator	varchar(10)	No
app	varchar(20)	No
position	varchar(30)	No
module	varchar(30)	No
table	varchar(50)	No
name	varchar(30)	No
flowchart	text	No
js	text	No
css	text	No
order	smallint(5)	No
buildin	tinyint(1)	No
administrator	text	No
desc	text	No
version	varchar(10)	No	1.0
status	varchar(10)	No	wait
createdBy	varchar(30)	No
createdDate	datetime	No
editedBy	varchar(30)	No
editedDate	datetime	No

Indexes

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

zt_workflowaction

Column	Type	Null	Default	Comments
id	mediumint(8)	No
module	varchar(30)	No
action	varchar(50)	No
name	varchar(50)	No
type	enum('single', 'batch')	No	single
batchMode	enum('same', 'different')	No	different
extensionType	varchar(10)	No	override	none \| extend \| override
open	varchar(20)	No
position	enum('menu', 'browseandview', 'browse', 'view')	No	browseandview
layout	char(20)	No
show	enum('dropdownlist', 'direct')	No	dropdownlist
order	smallint(5)	No
buildin	tinyint(1)	No
conditions	text	No
verifications	text	No
hooks	text	No
linkages	text	No
js	text	No
css	text	No
toList	char(255)	No
desc	text	No
createdBy	varchar(30)	No
createdDate	datetime	No
editedBy	varchar(30)	No
editedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	127	A	No
unique	BTREE	Yes	No	module		A	No
unique	BTREE	Yes	No	action	127	A	No
module	BTREE	No	No	module		A	No
action	BTREE	No	No	action		A	No
order	BTREE	No	No	order		A	No

zt_workflowdatasource

Column	Type	Null	Default
id	mediumint(8)	No
type	enum('system', 'sql', 'func', 'option', 'lang')	No	option
name	varchar(30)	No
datasource	text	No
view	varchar(20)	No
keyField	varchar(50)	No
valueField	varchar(50)	No
createdBy	char(30)	No
createdDate	datetime	No
editedBy	char(30)	No
editedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	42	A	No
type	BTREE	No	No	type		A	No

zt_workflowfield

Column	Type	Null	Default
id	mediumint(8)	No
module	varchar(30)	No
field	varchar(50)	No
type	varchar(20)	No	varchar
length	varchar(10)	No
name	varchar(50)	No
control	varchar(20)	No
options	text	No
default	varchar(100)	No
rules	varchar(255)	No
placeholder	varchar(100)	No
canExport	enum('0', '1')	No	0
canSearch	enum('0', '1')	No	0
isKey	enum('0', '1')	No	0
isValue	enum('0', '1')	No	0
order	smallint(5)	No
buildin	tinyint(1)	No
desc	text	No
readonly	enum('0', '1')	No	0
createdBy	varchar(30)	No
createdDate	datetime	No
editedBy	varchar(30)	No
editedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	303	A	No
unique	BTREE	Yes	No	module		A	No
unique	BTREE	Yes	No	field	303	A	No
module	BTREE	No	No	module	13	A	No
field	BTREE	No	No	field	101	A	No
order	BTREE	No	No	order	50	A	No

zt_workflowlabel

Column	Type	Null
id	mediumint(8)	No
module	varchar(30)	No
code	varchar(30)	No
label	varchar(255)	No
params	text	No
order	tinyint(3)	No
buildin	tinyint(1)	No
createdBy	char(30)	No
createdDate	datetime	No
editedBy	char(30)	No
editedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	57	A	No
module	BTREE	No	No	module		A	No

zt_workflowlayout

Column	Type	Null	Default
id	mediumint(8)	No
module	varchar(30)	No
action	varchar(50)	No
field	varchar(50)	No
order	smallint(5)	No
width	smallint(5)	No
position	text	No
readonly	enum('0', '1')	No	0
mobileShow	enum('0', '1')	No	1
totalShow	enum('0', '1')	No	0
defaultValue	text	No
layoutRules	varchar(255)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	111	A	No
unique	BTREE	Yes	No	module		A	No
				action		A	No
				field	111	A	No
module	BTREE	No	No	module		A	No
action	BTREE	No	No	action		A	No
order	BTREE	No	No	order		A	No

zt_workflowlinkdata

Column	Type	Null
objectType	varchar(30)	No
objectID	mediumint(8)	No
linkedType	varchar(30)	No
linkedID	mediumint(8)	No
createdBy	varchar(30)	No
createdDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
unique	BTREE	Yes	No	objectType		A	No
				objectID		A	No
				linkedType		A	No
				linkedID	0	A	No

zt_workflowrelation

Column	Type	Null
id	mediumint(8)	No
prev	varchar(30)	No
next	varchar(30)	No
field	varchar(50)	No
actions	varchar(20)	No
createdBy	char(30)	No
createdDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

zt_workflowrelationlayout

Column	Type	Null
id	mediumint(8)	No
prev	varchar(30)	No
next	varchar(30)	No
action	varchar(50)	No
field	varchar(50)	No
order	smallint(5)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
unique	BTREE	Yes	No	prev		A	No
				next		A	No
				action		A	No
				field	0	A	No
prev	BTREE	No	No	prev		A	No
next	BTREE	No	No	next		A	No
action	BTREE	No	No	action		A	No
order	BTREE	No	No	order		A	No

zt_workflowrule

Column	Type	Null	Default
id	mediumint(8)	No
type	enum('system', 'regex', 'func')	No	regex
name	varchar(30)	No
rule	text	No
createdBy	char(30)	No
createdDate	datetime	No
editedBy	char(30)	No
editedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	6	A	No
type	BTREE	No	No	type		A	No

zt_workflowsql

Column	Type	Null
id	mediumint(8)	No
module	varchar(30)	No
field	varchar(50)	No
action	varchar(50)	No
sql	text	No
vars	text	No
createdBy	varchar(30)	No
createdDate	datetime	No
editedBy	varchar(30)	No
editedDate	datetime	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
module	BTREE	No	No	module		A	No
field	BTREE	No	No	field		A	No
action	BTREE	No	No	action		A	No

zt_workflowversion

Column	Type	Null
id	mediumint(8)	No
module	varchar(30)	No
version	varchar(10)	No
fields	text	No
actions	text	No
layouts	text	No
sqls	text	No
labels	text	No
table	text	No
datas	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	0	A	No
moduleversion	BTREE	Yes	No	module		A	No
moduleversion	BTREE	Yes	No	version	0	A	No
module	BTREE	No	No	module		A	No
version	BTREE	No	No	version		A	No

ztv_dayactions

Table comments: VIEW

Column	Type	Null	Default	Comments
actions	bigint(21)	No	0
day	varchar(10)	No

ztv_daybugopen

Table comments: VIEW

Column	Type	Null	Default	Comments
bugopen	bigint(21)	No	0
day	varchar(10)	No

ztv_daybugresolve

Table comments: VIEW

Column	Type	Null	Default	Comments
bugresolve	bigint(21)	No	0
day	varchar(10)	No

ztv_dayeffort

Table comments: VIEW

Column	Type	Null	Default	Comments
consumed	double(18,1)	Yes	NULL
date	date	No

ztv_daystoryclose

Table comments: VIEW

Column	Type	Null	Default	Comments
storyclose	bigint(21)	No	0
day	varchar(10)	No

ztv_daystoryopen

Table comments: VIEW

Column	Type	Null	Default	Comments
storyopen	bigint(21)	No	0
day	varchar(10)	No

ztv_daytaskfinish

Table comments: VIEW

Column	Type	Null	Default	Comments
taskfinish	bigint(21)	No	0
day	varchar(10)	No

ztv_daytaskopen

Table comments: VIEW

Column	Type	Null	Default	Comments
taskopen	bigint(21)	No	0
day	varchar(10)	No

ztv_dayuserlogin

Table comments: VIEW

Column	Type	Null	Default	Comments
userlogin	bigint(21)	No	0
day	varchar(10)	No

ztv_productbugs

Table comments: VIEW

Column	Type	Null	Default
product	mediumint(8)	No	0
bugs	bigint(21)	No	0
resolutions	decimal(23,0)	Yes	NULL
seriousBugs	decimal(23,0)	Yes	NULL

ztv_productstories

Table comments: VIEW

Column	Type	Null	Default
product	mediumint(8)	No	0
stories	bigint(21)	No	0
undone	decimal(23,0)	Yes	NULL

ztv_projectbugs

Table comments: VIEW

Column	Type	Null	Default
project	mediumint(8)	No	0
bugs	bigint(21)	No	0
resolutions	decimal(23,0)	Yes	NULL
seriousBugs	decimal(23,0)	Yes	NULL

ztv_projectstories

Table comments: VIEW

Column	Type	Null	Default
project	mediumint(8)	No	0
stories	bigint(21)	No	0
undone	decimal(23,0)	Yes	NULL

ztv_projectsummary

Table comments: VIEW

Column	Type	Null	Default
project	mediumint(8)	No	0
estimate	double	Yes	NULL
consumed	double	Yes	NULL
left	double	Yes	NULL
number	bigint(21)	No	0
undone	decimal(23,0)	Yes	NULL
totalReal	double	Yes	NULL

ztv_projectteams

Table comments: VIEW

Column	Type	Null	Default	Comments
project	mediumint(8)	No	0
teams	bigint(21)	No	0