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 |