ST_REQS

This table provides the list of requirements.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ID	int	4	Y	ObjectID
3	CreatedTime	datetime	8	N	ObjectID of the root object
4	CreatedUserID	varchar	254	N	Creation time
5	ModifiedTime	datetime	8	N	Creation user
6	ModifiedUserID	varchar	254	N	Time last modified
7	RevisionNumber	int	4	N	Number of revisions
8	RevisionFlags	int	4	N	Revision Flags
9	StComment	text	16	N	Comment
10	ParentRequirementID	int	4	N	ObjectID of Parent Requirement
11	Name	varchar	254	N	Requirement
12	Description	text	16	N	Description
13	AttachmentCount	int	4	N	Attachment Count
14	AttachmentNames	text	16	N	Names of all attachments
15	Status	varchar	254	N	Status
16	Priority	varchar	254	N	Priority
17	RequirementNumber	int	4	N	Requirement Number
18	ResponsibleCount	int	4	N	Number of Responsible users
19	ResponsibleNames	text	16	N
20	Disabled	int	4	N
21	ExternalReference	varchar	762	N	External Reference
22	Type	varchar	254	N	Type
23	Owner	varchar	254	N	Owner
24	RevisedDescription	text	16	N	Revised Description
25	AmbiguitiesFound	int	4	N	Ambiguities Found
26	Comments	text	16	N
27	HighEffort	int	4	N	High Effort
28	ExpectedEffort	int	4	N	Expected Effort
29	LowEffort	int	4	N	Low Effort
30	Notes	text	16	N	Notes
31	ReviewedByNames	text	16	N
32	DotNotation	varchar	254	N	Dot Notation

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_REQS	ServerID	ST_LINKS	ServerID
2	ST_REQS	ID	ST_LINKS	ParentObjectID
1	ST_REQS	ServerID	ST_LINKS	ServerID
2	ST_REQS	ID	ST_LINKS	ChildObjectID
1	ST_REQS	ServerID	ST_OBJECTACLS	ServerID
2	ST_REQS	ID	ST_OBJECTACLS	ObjectID
1	ST_REQS	ServerID	ST_REQHISTORY	ServerID
2	ST_REQS	ID	ST_REQHISTORY	ID