This table contains promotion policies.
Column Name | Column Type | Description |
---|---|---|
PX_POLICY_ID | INTEGER NOT NULL | The policy ID. This is a primary key. |
STOREENT_ID | INTEGER NOT NULL | Foreign key to the STOREENT table. This is the ID of the store that owns this policy. |
STATUS | SMALLINT NOT NULL DEFAULT 0 | The current status of a policy. Possible values include: 0: active 1: inactive 2: deleted The default value is 0. |
NAME | VARCHAR(128) NOT NULL | The name of the policy. |
IMPLCLS | VARCHAR(254) NOT NULL | The name of the class that implements this policy. |
XMLPARAM | CLOB | The XML definition of this policy. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000387 | STOREENT_ID+NAME | Unique Index |
SQL050212031301360 | PX_POLICY_ID | Primary Key |
I0000395 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1043 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1045 | PX_POLICY_ID | PX_GRPPOLICY | PX_POLICY_ID | Cascade |
F_1050 | PX_POLICY_ID | PX_PROMOPOLICY | PX_POLICY_ID | Cascade |