ST_ITEMLABELS

This table provides the list of item and label relationships.

Column Field Type Length Primary Description

1

ServerID

int

4

Y

Server ID

2

ID

int

4

Y

Label ID

3

ItemID

int

4

Y

Item ID

4

ClassID

int

4

N

Class ID of item type

5

ObjectID

int

4

N

Object ID of item

6

ViewID

int

4

N

View ID

7

RevisionTime

datetime

8

N

Time of the revision label is attached to

8

RevisionNumber

int

4

N

Revision Number of item

9

ViewVersion

int

4

N

View Version of item

10

ProjectID

int

4

N

ProjectID

Table Joins

Column Primary Table Primary Field Foreign Table Foreign Field

1

ST_LABELS

ServerID

ST_ITEMLABELS

ServerID

2

ST_LABELS

ID

ST_ITEMLABELS

ID

1

ST_VIEWMEMBER

ServerID

ST_ITEMLABELS

ServerID

2

STVIEWMEMBER

ItemID

STITEMLABELS

ItemID