Column | Type | Null | Default | Comments |
---|---|---|---|---|
id | mediumint(8) | No | 0 | |
name | char(150) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id | mediumint(8) | No | 0 | |
name | char(60) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id | mediumint(8) | No | 0 | |
title | varchar(90) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id | mediumint(8) | No | 0 | |
title | varchar(255) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id | mediumint(8) | No | 0 | |
name | varchar(255) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id | mediumint(8) | No | 0 | |
title | varchar(255) | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 103383 | A | No | |
date | BTREE | No | No | date | 51691 | A | No | |
actor | BTREE | No | No | actor | 61 | A | No | |
project | BTREE | No | No | project | 320 | A | No | |
objectID | BTREE | No | No | objectID | 20676 | A | No | |
action | BTREE | No | No | action | 95 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 7397 | A | No | |
attend | BTREE | Yes | No | date | A | No | ||
account | 7397 | 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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
attend | BTREE | Yes | No | month | A | 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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 61 | A | No | |
product | BTREE | No | No | product | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 6314 | A | No | |
product | BTREE | No | No | product | 45 | A | No | |
project | BTREE | No | No | project | 217 | A | No | |
status | BTREE | No | No | status | 7 | A | No | |
plan | BTREE | No | No | plan | 5 | A | No | |
story | BTREE | No | No | story | 526 | A | No | |
case | BTREE | No | No | case | 175 | A | No | |
assignedTo | BTREE | No | No | assignedTo | 45 | A | No | |
toStory | BTREE | No | No | toStory | 2 | A | No | |
result | BTREE | No | No | result | 166 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 699 | A | No | |
product | BTREE | No | No | product | 53 | A | No | |
project | BTREE | No | No | project | 233 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | project | A | No | ||
date | A | No | ||||||
task | 2086 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 5375 | A | No | |
case | BTREE | No | No | case | A | No | ||
version | BTREE | No | No | version | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 1 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 504 | A | No | |
unique | BTREE | Yes | No | owner | A | No | ||
module | A | No | ||||||
section | A | No | ||||||
key | 504 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 15 | A | No | |
lastTime | BTREE | No | No | lastTime | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
deploy | mediumint(8) | No | ||
product | mediumint(8) | No | ||
release | mediumint(8) | No | ||
package | varchar(255) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
deploy_product_release | BTREE | Yes | No | deploy | A | No | ||
product | A | No | ||||||
release | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
deploy | mediumint(8) | No | ||
service | mediumint(8) | No | ||
hosts | text | No | ||
remove | text | No | ||
add | text | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 8 | A | No | |
parent | BTREE | No | No | parent | A | No | ||
path | BTREE | No | No | path | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 4 | A | No | |
doc_version | BTREE | Yes | No | doc | A | No | ||
version | 4 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 521 | A | No | |
product | BTREE | No | No | product | A | No | ||
project | BTREE | No | No | project | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
account | char(30) | No | ||
product | mediumint(8) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
account_product | BTREE | Yes | No | account | A | No | ||
product | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 6236 | A | No | |
objectType | BTREE | No | No | objectType | A | No | ||
objectID | BTREE | No | No | objectID | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 19 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
group | mediumint(8) | No | 0 | |
module | char(30) | No | ||
method | char(30) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
group | BTREE | Yes | No | group | A | No | ||
module | A | No | ||||||
method | 4571 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 121834 | A | No | |
action | BTREE | No | No | action | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
year | BTREE | No | No | year | A | No | ||
name | BTREE | No | No | name | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
chatuser | BTREE | Yes | No | cgid | A | 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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 22227 | A | No | |
mgid | BTREE | No | No | gid | 22227 | 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 |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
user | mediumint(8) | No | 0 | |
message | int(11) | No | ||
status | enum('waiting', 'sent', 'readed', 'deleted') | No | waiting |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
user | BTREE | Yes | No | user | A | No | ||
message | 22419 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
objectType | BTREE | No | No | objectType | A | No | ||
obejctID | BTREE | No | No | objectID | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 255 | A | No | |
root | BTREE | No | No | root | A | No | ||
type | BTREE | No | No | type | A | No | ||
path | BTREE | No | No | path | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 93 | A | No | |
objectType_toList_status | BTREE | No | No | objectType | A | No | ||
toList | A | No | ||||||
status | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
account | varchar(30) | No | ||
openID | varchar(255) | No | ||
providerType | varchar(30) | No | ||
providerID | mediumint(8) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
account | BTREE | No | No | account | A | No | ||
providerType | BTREE | No | No | providerType | A | No | ||
providerID | BTREE | No | No | providerID | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
plan | mediumint(8) | No | ||
story | mediumint(8) | No | ||
order | mediumint(9) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
plan_story | BTREE | Yes | No | plan | A | No | ||
story | 1239 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 100 | A | No | |
order | BTREE | No | No | order | A | No | ||
acl | BTREE | No | No | acl | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 415 | A | No | |
product | BTREE | No | No | product | 83 | A | No | |
end | BTREE | No | No | end | 138 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 421 | A | No | |
parent | BTREE | No | No | parent | 3 | A | No | |
begin | BTREE | No | No | begin | 421 | A | No | |
end | BTREE | No | No | end | 421 | A | No | |
status | BTREE | No | No | status | 13 | A | No | |
order | BTREE | No | No | order | 421 | A | No | |
acl | BTREE | No | No | acl | 6 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
project | mediumint(8) | No | ||
product | mediumint(8) | No | ||
branch | mediumint(8) | No | ||
plan | mediumint(8) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | project | A | No | ||
product | 440 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
project | BTREE | Yes | No | project | A | No | ||
story | 1080 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
relationoftasks | BTREE | No | No | project | A | No | ||
task | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 9 | A | No | |
product | BTREE | No | No | product | A | No | ||
build | BTREE | No | No | build | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
repo | mediumint(8) | No | ||
revision | mediumint(8) | No | ||
branch | varchar(255) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
path | BTREE | No | No | path | A | No | ||
parent | BTREE | No | No | parent | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
repo | BTREE | No | No | repo | A | No | ||
revision | A | No |
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 |
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
key | smallint(5) | No | ||
value | char(3) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | key | 2473 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 38647 | A | No | |
object | BTREE | Yes | No | objectType | A | No | ||
objectID | 38647 | A | No | |||||
addedDate | BTREE | No | No | addedDate | A | No | ||
content | FULLTEXT | No | No | content | No | |||
title | FULLTEXT | No | No | title | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 2508 | 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 |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
story | mediumint(9) | No | ||
version | smallint(6) | No | ||
title | varchar(255) | No | ||
spec | text | No | ||
verify | text | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
story | BTREE | Yes | No | story | A | No | ||
version | 9177 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
story | mediumint(8) | No | ||
branch | mediumint(8) | No | ||
stage | varchar(50) | No | ||
stagedBy | char(30) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
story_branch | BTREE | Yes | No | story | A | No | ||
branch | 380 | A | No | |||||
story | BTREE | No | No | story | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
suite | mediumint(8) | No | ||
product | mediumint(8) | No | ||
case | mediumint(8) | No | ||
version | smallint(5) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
suitecase | BTREE | Yes | No | suite | A | No | ||
case | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
task | BTREE | No | No | task | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 2413 | A | No | |
team | BTREE | Yes | No | root | A | No | ||
type | A | No | ||||||
account | 2413 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 22436 | A | No | |
task | BTREE | Yes | No | task | A | No | ||
case | 22436 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
product | BTREE | No | No | product | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 880 | A | No | |
product | BTREE | No | No | product | 58 | A | No | |
build | BTREE | No | No | build | 880 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
year | BTREE | No | No | year | A | No | ||
createdBy | BTREE | No | No | createdBy | A | No |
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 | |
char(90) | No | |||
skype | char(90) | No | ||
char(20) | No | |||
mobile | char(11) | No | ||
phone | char(20) | No | ||
weixin | varchar(90) | No | ||
dingding | varchar(90) | No | ||
slack | varchar(90) | No | ||
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 57 | A | No | |
account | BTREE | Yes | No | account | 57 | A | No | |
dept | BTREE | No | No | dept | A | No | ||
BTREE | No | No | A | No | ||||
commiter | BTREE | No | No | commiter | A | No | ||
deleted | BTREE | No | No | deleted | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id | mediumint(8) | No | ||
account | char(30) | No | ||
listName | varchar(60) | No | ||
userList | text | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
account | BTREE | No | No | account | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
account | char(30) | No | ||
group | mediumint(8) | No | 0 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
account | BTREE | Yes | No | account | A | No | ||
group | 56 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 7 | A | No | |
account | BTREE | No | No | account | A | No | ||
module | BTREE | No | No | module | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 2 | A | No | |
account | BTREE | No | No | account | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
account | char(30) | No | ||
products | mediumtext | No | ||
projects | mediumtext | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
account | BTREE | Yes | No | account | 57 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 2 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 13 | A | No | |
unique | BTREE | Yes | No | app | A | 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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 127 | A | No | |
unique | BTREE | Yes | No | module | A | 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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 42 | A | No | |
type | BTREE | No | No | type | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 303 | A | No | |
unique | BTREE | Yes | No | module | A | 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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 57 | A | No | |
module | BTREE | No | No | module | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
unique | BTREE | Yes | No | objectType | A | No | ||
objectID | A | No | ||||||
linkedType | A | No | ||||||
linkedID | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 6 | A | No | |
type | BTREE | No | No | type | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
moduleversion | BTREE | Yes | No | module | A | No | ||
version | 0 | A | No | |||||
module | BTREE | No | No | module | A | No | ||
version | BTREE | No | No | version | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
actions | bigint(21) | No | 0 | |
day | varchar(10) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
bugopen | bigint(21) | No | 0 | |
day | varchar(10) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
bugresolve | bigint(21) | No | 0 | |
day | varchar(10) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
consumed | double(18,1) | Yes | NULL | |
date | date | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
storyclose | bigint(21) | No | 0 | |
day | varchar(10) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
storyopen | bigint(21) | No | 0 | |
day | varchar(10) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
taskfinish | bigint(21) | No | 0 | |
day | varchar(10) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
taskopen | bigint(21) | No | 0 | |
day | varchar(10) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
userlogin | bigint(21) | No | 0 | |
day | varchar(10) | No |
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 |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
product | mediumint(8) | No | 0 | |
stories | bigint(21) | No | 0 | |
undone | decimal(23,0) | Yes | NULL |
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 |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
project | mediumint(8) | No | 0 | |
stories | bigint(21) | No | 0 | |
undone | decimal(23,0) | Yes | NULL |
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 |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
project | mediumint(8) | No | 0 | |
teams | bigint(21) | No | 0 |