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