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 Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid103383ANo
dateBTREENoNodate51691ANo
actorBTREENoNoactor61ANo
projectBTREENoNoproject320ANo
objectIDBTREENoNoobjectID20676ANo
actionBTREENoNoaction95ANo

zt_asset

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_attend

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid7397ANo
attendBTREEYesNodateANo
account7397ANo
accountBTREENoNoaccountANo
dateBTREENoNodateANo
statusBTREENoNostatusANo
reasonBTREENoNoreasonANo
reviewStatusBTREENoNoreviewStatusANo
reviewedByBTREENoNoreviewedByANo

zt_attendstat

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
attendBTREEYesNomonthANo
account0ANo
accountBTREENoNoaccountANo
monthBTREENoNomonthANo
statusBTREENoNostatusANo

zt_block

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid1019ANo
accountModuleOrderBTREEYesNoaccountANo
moduleANo
order1019ANo
accountBTREENoNoaccountANo

zt_branch

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid61ANo
productBTREENoNoproductANo

zt_bug

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid6314ANo
productBTREENoNoproduct45ANo
projectBTREENoNoproject217ANo
statusBTREENoNostatus7ANo
planBTREENoNoplan5ANo
storyBTREENoNostory526ANo
caseBTREENoNocase175ANo
assignedToBTREENoNoassignedTo45ANo
toStoryBTREENoNotoStory2ANo
resultBTREENoNoresult166ANo

zt_build

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid699ANo
productBTREENoNoproduct53ANo
projectBTREENoNoproject233ANo

zt_burn

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoprojectANo
dateANo
task2086ANo

zt_case

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid12008ANo
productBTREENoNoproduct32ANo
storyBTREENoNostory461ANo
moduleBTREENoNomodule1ANo
fromBugBTREENoNofromBug1ANo

zt_casestep

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid5375ANo
caseBTREENoNocaseANo
versionBTREENoNoversionANo

zt_company

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid1ANo

zt_compile

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_config

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid504ANo
uniqueBTREEYesNoownerANo
moduleANo
sectionANo
key504ANo

zt_cron

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid15ANo
lastTimeBTREENoNolastTimeANo

zt_deploy

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_deployproduct

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
deploy_product_releaseBTREEYesNodeployANo
productANo
release0ANo

zt_deployscope

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

zt_deploystep

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_dept

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid8ANo
parentBTREENoNoparentANo
pathBTREENoNopathANo

zt_doc

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid3ANo
productBTREENoNoproductANo
projectBTREENoNoprojectANo
libBTREENoNolibANo

zt_doccontent

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid4ANo
doc_versionBTREEYesNodocANo
version4ANo

zt_doclib

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid521ANo
productBTREENoNoproductANo
projectBTREENoNoprojectANo

zt_effort

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid18618ANo
projectBTREENoNoproject229ANo
objectIDBTREENoNoobjectID6206ANo
dateBTREENoNodate642ANo
accountBTREENoNoaccount39ANo

zt_entry

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_extension

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
codeBTREEYesNocode0ANo
nameBTREENoNonameANo
installedTimeBTREENoNoinstalledTimeANo

zt_faq

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_feedback

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_feedbackview

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
account_productBTREEYesNoaccountANo
product0ANo

zt_file

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid6236ANo
objectTypeBTREENoNoobjectTypeANo
objectIDBTREENoNoobjectIDANo

zt_group

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid19ANo

zt_grouppriv

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
groupBTREEYesNogroupANo
moduleANo
method4571ANo

zt_history

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid121834ANo
actionBTREENoNoactionANo

zt_holiday

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
yearBTREENoNoyearANo
nameBTREENoNonameANo

zt_host

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_im_chat

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
gidBTREENoNogidANo
nameBTREENoNonameANo
typeBTREENoNotypeANo
publicBTREENoNopublicANo
createdByBTREENoNocreatedByANo
editedByBTREENoNoeditedByANo

zt_im_chatuser

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
chatuserBTREEYesNocgidANo
user0ANo
cgidBTREENoNocgidANo
userBTREENoNouserANo
orderBTREENoNoorderANo
starBTREENoNostarANo
hideBTREENoNohideANo

zt_im_client

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_im_conference

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_im_conferenceaction

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_im_message

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid22227ANo
mgidBTREENoNogid22227ANo
mcgidBTREENoNocgid5ANo
muserBTREENoNouser5ANo
mtypeBTREENoNotype5ANo

zt_im_messagestatus

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
userBTREEYesNouserANo
message22419ANo

zt_im_queue

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_jenkins

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_job

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_lang

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid70ANo
langBTREEYesNolangANo
moduleANo
sectionANo
key70ANo

zt_leave

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
yearBTREENoNoyearANo
typeBTREENoNotypeANo
statusBTREENoNostatusANo
createdByBTREENoNocreatedByANo

zt_lieu

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
yearBTREENoNoyearANo
statusBTREENoNostatusANo
createdByBTREENoNocreatedByANo

zt_log

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
objectTypeBTREENoNoobjectTypeANo
obejctIDBTREENoNoobjectIDANo

zt_module

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid255ANo
rootBTREENoNorootANo
typeBTREENoNotypeANo
pathBTREENoNopathANo

zt_notify

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid93ANo
objectType_toList_statusBTREENoNoobjectTypeANo
toListANo
statusANo

zt_oauth

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
accountBTREENoNoaccountANo
providerTypeBTREENoNoproviderTypeANo
providerIDBTREENoNoproviderIDANo

zt_overtime

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
yearBTREENoNoyearANo
typeBTREENoNotypeANo
statusBTREENoNostatusANo
createdByBTREENoNocreatedByANo

zt_planstory

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
plan_storyBTREEYesNoplanANo
story1239ANo

zt_product

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid100ANo
orderBTREENoNoorderANo
aclBTREENoNoaclANo

zt_productplan

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid415ANo
productBTREENoNoproduct83ANo
endBTREENoNoend138ANo

zt_project

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid421ANo
parentBTREENoNoparent3ANo
beginBTREENoNobegin421ANo
endBTREENoNoend421ANo
statusBTREENoNostatus13ANo
orderBTREENoNoorder421ANo
aclBTREENoNoacl6ANo

zt_projectproduct

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoprojectANo
product440ANo

zt_projectstory

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
projectBTREEYesNoprojectANo
story1080ANo

zt_relation

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
relationBTREEYesNorelationANo
ATypeANo
BTypeANo
AIDANo
BID0ANo

zt_relationoftasks

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
relationoftasksBTREENoNoprojectANo
taskANo

zt_release

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid9ANo
productBTREENoNoproductANo
buildBTREENoNobuildANo

zt_repo

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_repobranch

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
repo_revision_branchBTREEYesNorepoANo
revisionANo
branch0ANo
branchBTREENoNobranchANo
revisionBTREENoNorevisionANo

zt_repofiles

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
pathBTREENoNopathANo
parentBTREENoNoparentANo

zt_repohistory

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
repoBTREENoNorepoANo
revisionANo

zt_report

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid27ANo
codeBTREEYesNocode27ANo

zt_score

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
accountBTREENoNoaccountANo
modelBTREENoNomoduleANo
methodBTREENoNomethodANo

zt_searchdict

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNokey2473ANo

zt_searchindex

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid38647ANo
objectBTREEYesNoobjectTypeANo
objectID38647ANo
addedDateBTREENoNoaddedDateANo
contentFULLTEXTNoNocontentNo
titleFULLTEXTNoNotitleNo

zt_serverroom

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_service

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_story

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid2508ANo
productBTREENoNoproduct96ANo
statusBTREENoNostatus13ANo
assignedToBTREENoNoassignedTo54ANo

zt_storyspec

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
storyBTREEYesNostoryANo
version9177ANo

zt_storystage

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
story_branchBTREEYesNostoryANo
branch380ANo
storyBTREENoNostoryANo

zt_suitecase

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
suitecaseBTREEYesNosuiteANo
case0ANo

zt_task

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid1107ANo
projectBTREENoNoproject138ANo
storyBTREENoNostory553ANo
assignedToBTREENoNoassignedTo32ANo
parentBTREENoNoparent11ANo

zt_taskestimate

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
taskBTREENoNotaskANo

zt_team

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid2413ANo
teamBTREEYesNorootANo
typeANo
account2413ANo

zt_testreport

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_testresult

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid21871ANo
caseBTREENoNocase7290ANo
versionBTREENoNoversion5ANo
runBTREENoNorun21871ANo

zt_testrun

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid22436ANo
taskBTREEYesNotaskANo
case22436ANo

zt_testsuite

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
productBTREENoNoproductANo

zt_testtask

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid880ANo
productBTREENoNoproduct58ANo
buildBTREENoNobuild880ANo

zt_todo

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid81ANo
accountBTREENoNoaccountANo
assignedToBTREENoNoassignedToANo
finishedByBTREENoNofinishedByANo
dateBTREENoNodateANo

zt_translation

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
lang_module_key_modeBTREEYesNolangANo
moduleANo
keyANo
mode0ANo

zt_trip

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
yearBTREENoNoyearANo
createdByBTREENoNocreatedByANo

zt_user

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid57ANo
accountBTREEYesNoaccount57ANo
deptBTREENoNodeptANo
emailBTREENoNoemailANo
commiterBTREENoNocommiterANo
deletedBTREENoNodeletedANo

zt_usercontact

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
accountBTREENoNoaccountANo

zt_usergroup

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
accountBTREEYesNoaccountANo
group56ANo

zt_userquery

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid7ANo
accountBTREENoNoaccountANo
moduleBTREENoNomoduleANo

zt_usertpl

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid2ANo
accountBTREENoNoaccountANo

zt_userview

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
accountBTREEYesNoaccount57ANo

zt_webhook

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid2ANo

zt_workflow

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid13ANo
uniqueBTREEYesNoappANo
module13ANo
typeBTREENoNotypeANo
appBTREENoNoappANo
moduleBTREENoNomoduleANo
orderBTREENoNoorderANo

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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid127ANo
uniqueBTREEYesNomoduleANo
action127ANo
moduleBTREENoNomoduleANo
actionBTREENoNoactionANo
orderBTREENoNoorderANo

zt_workflowdatasource

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid42ANo
typeBTREENoNotypeANo

zt_workflowfield

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid303ANo
uniqueBTREEYesNomoduleANo
field303ANo
moduleBTREENoNomodule13ANo
fieldBTREENoNofield101ANo
orderBTREENoNoorder50ANo

zt_workflowlabel

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid57ANo
moduleBTREENoNomoduleANo

zt_workflowlayout

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid111ANo
uniqueBTREEYesNomoduleANo
actionANo
field111ANo
moduleBTREENoNomoduleANo
actionBTREENoNoactionANo
orderBTREENoNoorderANo

zt_workflowlinkdata

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

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
uniqueBTREEYesNoobjectTypeANo
objectIDANo
linkedTypeANo
linkedID0ANo

zt_workflowrelation

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

zt_workflowrelationlayout

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
uniqueBTREEYesNoprevANo
nextANo
actionANo
field0ANo
prevBTREENoNoprevANo
nextBTREENoNonextANo
actionBTREENoNoactionANo
orderBTREENoNoorderANo

zt_workflowrule

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid6ANo
typeBTREENoNotypeANo

zt_workflowsql

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
moduleBTREENoNomoduleANo
fieldBTREENoNofieldANo
actionBTREENoNoactionANo

zt_workflowversion

Column Type Null Default Comments
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

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
moduleversionBTREEYesNomoduleANo
version0ANo
moduleBTREENoNomoduleANo
versionBTREENoNoversionANo

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 Comments
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 Comments
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 Comments
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 Comments
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 Comments
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