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 |

