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