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 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. |
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 |