WebSphere Commerce database table: PX_POLICY

This table contains promotion policies.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
I0000387 STOREENT_ID+NAME Unique Index
SQL050212031301360 PX_POLICY_ID Primary Key
I0000395 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1043 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign 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

Feedback