This table contains additional authoring
information that is managed by the Promotions tool in the
Management Center user interface.
Column Descriptions:
| Name | Type | Description |
| PX_PROMOTION_ID | INTEGER NOT NULL | Primary key of the table and foreign key to the
PX_PROMOTION table. |
| COMMENTS | VARCHAR (254) | Administrative description of the promotion. |
| PROMOTIONTYPE | VARCHAR (254) NOT NULL | Promotion rule type. |
| DAILYSTARTTIME | TIMESTAMP | Daily start time (for example: 2000/01/01). |
| DAILYENDTIME | TIMESTAMP | Daily end time (for example: 2000/01/01). |
| WEEKDAY_SUN | SMALLINT | Flag to indicate that the promotion is available
on Sunday. |
| WEEKDAY_MON | SMALLINT | Flag to indicate that the promotion is available
on Monday. |
| WEEKDAY_TUE | SMALLINT | Flag to indicate that the promotion is available
on Tuesday. |
| WEEKDAY_WED | SMALLINT | Flag to indicate that the promotion is available
on Wednesday. |
| WEEKDAY_THU | SMALLINT | Flag to indicate that the promotion is available
on Thursday. |
| WEEKDAY_FRI | SMALLINT | Flag to indicate that the promotion is available
on Friday. |
| WEEKDAY_SAT | SMALLINT | Flag to indicate that the promotion is available
on Saturday. |
| CTLPARAM | VARCHAR (32) | Additional control information for the user
interface. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
| ADMINSTVENAME | VARCHAR (254) | Administrative name of the promotion. |
| UP_ADMINSTVENAME | VARCHAR (254) | The equivalent value of the ADMINSTVENAME column
in upper case characters. This column is used only for DB2 (LUW)
database-types to enhance performance of text-based searches issued
from Management Center. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | PX_PROMOTION_ID | Primary Key |
| I0001219 | ADMINSTVENAME | Non-Unique Index |
| IPF00025 | UP_ADMINSTVENAME | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3544 | PX_PROMOTION_ID | PX_PROMOTION | PX_PROMOTION_ID | Cascade |