ST_SPRINTHISTORY

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

Table Joins

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