WebSphere Commerce database table: POLICYCMD

This table stores command relationship information for a business policy.

Column Descriptions
Column Name Column Type Description
POLICY_ID BIGINT NOT NULL The business policy ID.
BUSINESSCMDCLASS VARCHAR(200) NOT NULL The command that implements this business policy.
PROPERTIES VARCHAR(254) Default name value pairs that can be set to the business policy command. For example: n1=v1&n2=v2. If null, use the properties from the POLICY table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235233570 POLICY_ID+BUSINESSCMDCLASS Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_610 POLICY_ID POLICY POLICY_ID Cascade