ST_STORYHISTORY
This table lists the story history - one record 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 |
Time last modified |
7 |
ModifiedUserID |
varchar |
254 |
N |
Creation user |
8 |
RevisionFlags |
int |
4 |
N |
Revision Flags |
9 |
StComment |
text |
16 |
N |
Comment |
10 |
StoryID |
int |
4 |
N |
Story ID |
11 |
AttachmentCount |
int |
4 |
N |
Count of attachments to the Sprint |
12 |
AttachmentNames |
int |
4 |
N |
Names of attachments |
13 |
NotificationCount |
text |
16 |
N |
Count of notifications |
14 |
NotificationNames |
varchar |
254 |
N |
Names of notifications |
15 |
ParentID |
int |
4 |
N |
ParentID of the Story |
16 |
Name |
varchar |
254 |
N |
Name of the Story |
17 |
StoryType |
varchar |
254 |
N |
Type of the Story |
18 |
Risk |
varchar |
254 |
N |
Risk of the Story |
19 |
StoryValue |
varchar |
254 |
N |
StoryValue |
20 |
EstimatedPoints |
Varchar |
254 |
N |
Estimated points for the Story |
21 |
Rank |
Float |
8 |
N |
Rank of the Story |
22 |
StoryOrder |
Float |
8 |
N |
Order of the Story |
23 |
AcceptanceCriteria |
Text |
16 |
N |
Acceptance criteria of the Story |
24 |
Notes |
Text |
16 |
N |
Notes of the Story |
25 |
Sponsor |
varchar |
254 |
N |
Sponsor for the Story |
26 |
Description |
Text |
16 |
N |
Description of the Story |
25 |
Tag |
varchar |
254 |
N |
Tag for the Story |
26 |
StreamState |
varchar |
254 |
N |
StreamState for the Story |
27 |
RichDescription |
Text |
16 |
N |
Rich Description for the Story |
28 |
StoryStatus |
varchar |
254 |
N |
Status of the Story |
29 |
IncomingStream |
varchar |
254 |
N |
Incoming Stream for the Story |
30 |
TargetReleases |
Text |
16 |
N |
Target Releases for the Story |
31 |
DotNotation |
varchar |
254 |
N |
Dotnotation for the Story |
Table Joins
Column | Primary Table | Primary Field | Foreign Table | Foreign Field |
---|---|---|---|---|
1 |
ST_STORIES |
ServerID |
ST_LINKS |
ServerID |
2 |
ST_STORIES |
ID |
ST_LINKS |
ParentObjectID |
1 |
ST_STORIES |
ServerID |
ST_LINKS |
ServerID |
2 |
ST_STORIES |
ID |
ST_LINKS |
ChildObjectID |
1 |
ST_STORIES |
ServerID |
ST_OBJECTACLS |
ServerID |
2 |
ST_STORIES |
ID |
ST_OBJECTACLS |
ObjectID |
1 |
ST_STORIES |
ServerID |
ST_STORYHISTORY |
ServerID |
2 |
ST_STORIES |
ID |
STSTORYHISTORY |
ID |