This table contains the sprint history records - one for each revision.
|
Column |
Field |
Type |
Length |
Primary |
Description |
|---|---|---|---|---|---|
|
1 |
ServerID |
Int |
4 |
Y |
Server ID |
|
2 |
ID |
Int |
4 |
Y |
ObjectID |
|
3 |
RevisionNumber |
Int |
4 |
Y |
Number of revisions |
|
4 |
CreatedTime |
datetime |
8 |
N |
ObjectID of the root object |
|
5 |
CreatedUserID |
varchar |
254 |
N |
Creation time |
|
6 |
ModifiedTime |
datetime |
8 |
N |
Creation user |
|
7 |
ModifiedUserID |
varchar |
254 |
N |
Time last modified |
|
8 |
RevisionFlags |
Int |
4 |
N |
Revision Flags |
|
9 |
StComment |
Text |
16 |
N |
Comment |
|
10 |
RootObjectID |
Int |
4 |
N |
Root object ID |
|
11 |
ParentObjectID |
Int |
4 |
N |
Parent object ID |
|
12 |
ParentRevision |
Int |
4 |
N |
Revision number of Parent |
|
13 |
PathRevision |
Int |
4 |
N |
Path revision |
|
14 |
ViewID |
Int |
4 |
N |
View ID |
|
15 |
DotNotation |
varchar |
254 |
N |
Dot notation of Sprint object |
|
16 |
SprintID |
Int |
4 |
N |
ID of the Sprint |
|
17 |
AttachmentCount |
Int |
4 |
N |
Count of attachments to the Sprint |
|
18 |
AttachmentNames |
Int |
4 |
N |
Names of attachments |
|
19 |
NotificationCount |
Text |
16 |
N |
Count of notifications |
|
20 |
NotificationNames |
varchar |
254 |
N |
Names of notifications |
|
21 |
Name |
Text |
16 |
N |
Name of the Sprint |
|
22 |
Description |
Text |
254 |
N |
Description |
|
23 |
Owner |
varchar |
254 |
N |
Owner of the sprint |
|
24 |
StartDate |
datetime |
8 |
N |
Start Date |
|
25 |
EndDate |
datetime |
8 |
N |
End Date |
| Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
|---|---|---|---|---|
|
1 |
ST_SPRINTS |
ServerID |
ST_SPRINTHISTORY |
ServerID |
|
2 |
ST_SPRINTS |
ID |
ST_SPRINTHISTORY |
ID |
|
1 |
ST_SPRINTHISTORY |
ServerID |
ST_VIEWMEMBER |
ServerID |
|
2 |
ST_SPRINTHISTORY |
ID |
ST_VIEWMEMBER |
ID |
|
3 |
ST_SPRINTHISTORY |
RevisionNumber |
STVIEWMEMBER |
RevisionNumber |