ST_LABELS
This table provides the list of labels.
Column | Field | Type | Length | Primary | Description |
---|---|---|---|---|---|
1 |
ServerID |
int |
4 |
Y |
Server ID |
2 |
ID |
int |
4 |
Y |
Label ID |
3 |
ViewID |
int |
4 |
N |
View ID |
4 |
Name |
varchar |
762 |
N |
Label Name |
5 |
LabelTime |
datetime |
8 |
N |
Configuration Time for label |
6 |
IsViewLabel |
int |
4 |
N |
Whether this is a view label or revision label |
7 |
IsBuildLabel |
int |
4 |
N |
Whether this is a build label |
8 |
IsLocked |
int |
4 |
N |
Whether this is frozen |
9 |
IsDeleted |
int |
4 |
N |
Whether this is deleted |
10 |
Description |
varchar |
762 |
N |
Description |
11 |
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_VIEWS |
ServerID |
ST_LABELS |
ServerID |
2 |
STVIEWS |
ID |
STLABELS |
ViewID |