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 | 

                                                        
                                                        
                                                        
                                                        
                                                        
                                                                    
                                                                    
                                        
                                        