This table contains relationships between promotion groups and promotion policies.
Column Description(s):
Column Name | Column Type | Description |
PX_GROUP_ID |
INTEGER NOT NULL |
Foreign key to PX_GROUP table. |
PX_POLICY_ID |
INTEGER NOT NULL |
Foreign key to PX_POLICY table. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031301200 |
PX_GROUP_ID+PX_POLICY_ID |
Primary Key |
I0000396 |
PX_GROUP_ID |
Non-Unique Index |
I0000397 |
PX_POLICY_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1044 |
PX_GROUP_ID |
PX_GROUP |
PX_GROUP_ID |
Cascade |
F_1045 |
PX_POLICY_ID |
PX_POLICY |
PX_POLICY_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.