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