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