id | mediumint(8) unsigned |
|
|
|
parent | mediumint(9) |
|
|
0
|
product | mediumint(8) unsigned |
|
|
0
|
branch | mediumint(8) unsigned |
|
|
0
|
module | mediumint(8) unsigned |
|
|
0
|
plan | text |
|
|
|
source | varchar(20) |
|
|
|
sourceNote | varchar(255) |
|
|
|
fromBug | mediumint(8) unsigned |
|
|
0
|
feedback | mediumint(8) unsigned |
|
|
0
|
title | varchar(255) |
|
|
|
keywords | varchar(255) |
|
|
|
type | varchar(30) |
|
|
story
|
pri | tinyint(3) unsigned |
|
|
3
|
estimate | float unsigned |
|
|
|
status | enum | -- |
|
|
subStatus | varchar(30) |
|
|
|
color | char(7) |
|
|
|
stage | enum | -- |
|
wait
|
stagedBy | char(30) |
|
|
|
mailto | text |
|
|
|
openedBy | varchar(30) |
|
|
|
openedDate | datetime |
|
|
|
assignedTo | varchar(30) |
|
|
|
assignedDate | datetime |
|
|
|
lastEditedBy | varchar(30) |
|
|
|
lastEditedDate | datetime |
|
|
|
reviewedBy | varchar(255) |
|
|
|
reviewedDate | date |
|
|
|
closedBy | varchar(30) |
|
|
|
closedDate | datetime |
|
|
|
closedReason | varchar(30) |
|
|
|
toBug | mediumint(8) unsigned |
|
|
|
childStories | varchar(255) |
|
|
|
linkStories | varchar(255) |
|
|
|
duplicateStory | mediumint(8) unsigned |
|
|
|
version | smallint(6) |
|
|
1
|
deleted | enum | -- |
|
0
|