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 |