ST_FOLDERS

This table provides the folders.

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 since branching
8	RevisionFlags	int	4	N	Revision Flags
9	StComment	text	16	N	Comment
10	RootObjectID	int	4	N	ObjectID of the root object
11	ParentObjectID	int	4	N	Object ID of item from which this item is branched from
12	ParentRevision	int	4	N
13	PathRevision	int	4	N	Revision of branching (0 means no branching)
14	ViewID	int	4	N	View ID
15	DotNotation	varchar	254	N	Dot notation
16	Name	varchar	762	N	Folder name
17	Description	varchar	762	N	Description
18	WorkingFolder	varchar	762	N	Working Folder
19	ExcludeFlags	varchar	254	N	Files to be Excluded
20	ExcludeSpec	varchar	762	N	Exclude Spec
21	CreateProjectID	int	4	N

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_FOLDERS	ServerID	ST_FOLDERHISTORY	ServerID
2	ST_FOLDERS	ID	ST_FOLDERHISTORY	ID
1	ST_FOLDERS	ServerID	ST_LINKS	ServerID
2	ST_FOLDERS	ID	ST_LINKS	ParentObjectID
1	ST_FOLDERS	ServerID	ST_LINKS	ServerID
2	ST_FOLDERS	ID	ST_LINKS	ChildObjectID
1	ST_FOLDERS	ServerID	ST_OBJECTACLS	ServerID
2	STFOLDERS	ID	STOBJECTACLS	ObjectID