ST_VIEWS

This table provides the list of views.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ID	int	4	Y	View ID
3	CreatedTime	datetime	8	N	Creation time
4	CreatedUserID	varchar	254	N	Creation user
5	Name	varchar	254	N	Name
6	Description	varchar	254	N	Description
7	ProjectID	int	4	N	Project ID
8	ParentViewID	int	4	N	View ID of Parent view
9	RootMemberID	int	4	N
10	WorkingFolder	varchar	762	N
11	BaseConfigType	int	4	N	Base configuration type from when view was created
12	BaseConfigData	datetime	8	N	Base configuration data from when view was created
13	Flags	int	4	N
14	ShareFlags	int	4	N
15	IsViewPurged	int	4	N
16	IsBranchOnShare	int	4	N	Whether items are Branch on Share
17	IsReadOnly	int	4	N	Whether view is read only
18	ISReference	int	4	N	Whether view is reference
19	ViewHierarchy	text	16	N	View Hierarchy for view

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_VIEWS	ServerID	ST_LABELS	ServerID
2	ST_VIEWS	ID	ST_LABELS	ViewID
1	ST_VIEWS	ServerID	ST_OBJECTACLS	ServerID
2	ST_VIEWS	ID	ST_OBJECTACLS	ObjectID
1	ST_VIEWS	ServerID	ST_PROMOTIONS	ServerID
2	ST_VIEWS	ID	ST_PROMOTIONS	ViewID
1	ST_VIEWS	ServerID	ST_VIEWMEMBER	ServerID
2	ST_VIEWS	ID	ST_VIEWMEMBER	ViewID
1	ST_PROJECTS	ServerID	ST_VIEWS	ServerID
2	STPROJECTS	ID	STVIEWS	ProjectID