ST_SPRINTS

This table lists all of the sprints.

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
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_LINKS	ServerID
2	ST_SPRINTS	ID	ST_LINKS	ParentObjectID
1	ST_SPRINTS	ServerID	ST_LINKS	ServerID
2	ST_SPRINTS	ID	ST_LINKS	ChildObjectID
1	ST_SPRINTS	ServerID	ST_OBJECTACLS	ServerID
2	ST_SPRINTS	ID	ST_OBJECTACLS	ObjectID
1	ST_SPRINTS	ServerID	ST_SPRINTHISTORY	ServerID
2	ST_SPRINTS	ID	ST_SPRINTHISTORY	ID