ST_STORIES

This table contains all of the stories.

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	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
27	Tag	varchar	254	N	Tag for the Story
28	StreamState	varchar	254	N	StreamState for the Story
29	RichDescription	Text	16	N	Rich Description for the Story
30	StoryStatus	varchar	254	N	Status of the Story
31	IncomingStream	varchar	254	N	Incoming Stream for the Story
32	TargetReleases	Text	16	N	Target Releases for the Story
33	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