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