ST_VIEWMEMBER

This table lists the folders that items are in.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ViewID	int	4	N	View ID
3	ItemID	int	4	Y	Item ID
4	ParentFolderID	int	4	N	Item ID of Parent Folder
5	ProjectID	int	4	N	Project ID
6	ClassID	int	4	N	Class ID of Item type
7	TypeName	varchar	254	N	Name of item type
8	ID	int	4	N	Object ID of item
9	ViewVersion	int	4	N	View Version of item
10	RevisionNumber	int	4	N	Revision Number of Item
11	FolderHierarchy	text	16	N	Folder Hierarchy for item

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_VIEWMEMBER	ServerID	ST_AUDITS	ServerID
2	ST_VIEWMEMBER	ItemID	ST_AUDITS	ParentFolderID
1	ST_VIEWMEMBER	ServerID	ST_ITEMLABELS	ServerID
2	ST_VIEWMEMBER	ItemID	ST_ITEMLABELS	ItemID
1	ST_VIEWMEMBER	ServerID	ST_ITEMLINKS	ServerID
2	ST_VIEWMEMBER	ItemID	ST_ITEMLINKS	ItemID
1	STCHANGEPACKAGEHIST	ServerID	STVIEWMEMBER	ServerID
2	ST_CHANGEPACKAGEHISTORY	ID	STVIEWMEMBER	ID
3	ST_CHANGEPACKAGEHIST	RevisionNumber	STVIEWMEMBER	RevisionNumber
1	ST_CRHISTORY	ServerID	ST_VIEWMEMBER	ServerID
2	ST_CRHISTORY	ID	ST_VIEWMEMBER	ID
3	ST_CRHISTORY	RevisionNumber	ST_VIEWMEMBER	RevisionNumber
1	ST_FILEHISTORY	ServerID	ST_VIEWMEMBER	ServerID
2	ST_FILEHISTORY	ID	ST_VIEWMEMBER	ID
3	ST_FILEHISTORY	RevisionNumber	ST_VIEWMEMBER	RevisionNumber
1	ST_FOLDERHISTORY	ServerID	ST_VIEWMEMBER	ServerID
2	ST_FOLDERHISTORY	ID	ST_VIEWMEMBER	ID
3	ST_FOLDERHISTORY	RevisionNumber	ST_VIEWMEMBER	RevisionNumber
1	ST_REQHISTORY	ServerID	ST_VIEWMEMBER	ServerID
2	ST_REQHISTORY	ID	ST_VIEWMEMBER	ID
3	ST_REQHISTORY	RevisionNumber	ST_VIEWMEMBER	RevisionNumber
1	ST_TASKHISTORY	ServerID	ST_VIEWMEMBER	ServerID
2	ST_TASKHISTORY	ID	ST_VIEWMEMBER	ID
3	ST_TASKHISTORY	RevisionNumber	ST_VIEWMEMBER	RevisionNumber
1	ST_TOPICHISTORY	ServerID	ST_VIEWMEMBER	ServerID
2	ST_TOPICHISTORY	ID	ST_VIEWMEMBER	ID
3	ST_TOPICHISTORY	RevisionNumber	ST_VIEWMEMBER	RevisionNumber
1	ST_TRACEHISTORY	ServerID	ST_VIEWMEMBER	ServerID
2	ST_TRACEHISTORY	ID	ST_VIEWMEMBER	ID
3	ST_TRACEHISTORY	RevisionNumber	ST_VIEWMEMBER	RevisionNumber
1	ST_VIEWS	ServerID	ST_VIEWMEMBER	ServerID
2	ST_VIEWS	ID	ST_VIEWMEMBER	ViewID
1	ST_VIEWMEMBER	ServerID	ST_VIEWMEMBERHISTORY	ServerID
2	ST_VIEWMEMBER	ItemID	ST_VIEWMEMBERHISTORY	ItemID