WebSphere Commerce database table: POLICY

Each row of this table indicates that the TradingPositions in a TradingPositionContainer are available to customers of Stores where the Contract is deployed, subject to any terms and conditions associated with the Contract.


Column Description(s):
Column NameColumn TypeDescription
POLICY_ID BIGINT NOT NULL The policy ID.
POLICYNAME VARCHAR(128) NOT NULL The unique policy name. It is expected that a store contains the following bootstrap policies:
  • MasterCatalog (one per StoreEntity)
  • CreditLine (one per StoreEntity)
POLICYTYPE_ID CHAR(64) NOT NULL The policy type ID. Foreign key to the POLICYTYPE table.
STOREENT_ID INTEGER NOT NULL The Store or StoreGroup ID.
PROPERTIES VARCHAR(254) Default name value pairs that can be set to the business policy command. For example: n1=v1&n2=v2.
STARTTIME TIMESTAMP Start date of the policy. If null, the policy starts immediately.
ENDTIME TIMESTAMP End date of the policy. If null, no end time.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000189 POLICYNAME+POLICYTYPE_ID+STOREENT_ID Unique Index
SQL050212031256450 POLICY_ID Primary Key
I0000337 POLICYTYPE_ID+STOREENT_ID Non-Unique Index
I0000697 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_609 POLICYTYPE_ID POLICYTYPE POLICYTYPE_ID Cascade
F_608 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_536 POLICY_ID ORDPAYMTHD POLICY_ID Cascade
F_584 POLICY_ID PAYSUMMARY POLICY_ID Cascade
F_610 POLICY_ID POLICYCMD POLICY_ID Cascade
F_612 POLICY_ID POLICYDESC POLICY_ID Cascade
F_613 POLICY_ID POLICYTC POLICY_ID Cascade
F_669 POLICY_ID REFUNDMTHD POLICY_ID Cascade
F_695 POLICY_ID RMA POLICY_ID Cascade
F_1147 POLICY_ID SHIPINFO POLICY_ID Cascade

Feedback