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 |