ST_PROMOTIONS

This table provides the list of promotion states.

Column	Field	Type	Length	Primary	Description
1	ServerID	int	4	Y	Server ID
2	ViewID	int	4	Y	View ID
3	ID	int	4	Y	Promotion state ID
4	Name	varchar	254	N	Name
5	CreatedTime	datetime	8	N	Creation time
6	CreatedUserID	varchar	254	N	Creation user
7	LabelID	varchar	254	N	Linked label
8	Description	varchar	254	N	Description

Table Joins

Column	Primary Table	Primary Field	Foreign Table	Foreign Field
1	ST_VIEWS	ServerID	ST_PROMOTIONS	ServerID
2	STVIEWS	ID	STPROMOTIONS	ViewID