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 |