This is table is intended for customization, which
contains the relationship between a promotion policy with a
promotion. This table is not used with default implementation.
Column Descriptions:
| Name | Type | Description |
| PX_PROMOTION_ID | INTEGER NOT NULL | Foreign key to PX_PROMOTION table. |
| PX_POLICY_ID | INTEGER NOT NULL | Foreign key to PX_PPOLICY table. |
| RELATION | SMALLINT NOT NULL DEFAULT 0 | The type of relationships between promotions and
policies. Possible values include:
0: applicable
1: exempted
The default value is 0. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| I0000402 | PX_PROMOTION_ID | Non-Unique Index |
| I0000403 | PX_POLICY_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1049 | PX_PROMOTION_ID | PX_PROMOTION | PX_PROMOTION_ID | Cascade |
| F_1050 | PX_POLICY_ID | PX_POLICY | PX_POLICY_ID | Cascade |