Reference > Database > WebSphere Commerce database tables > P


WebSphere Commerce database table: POLICYCMD

This table stores command relationship information for a business policy.

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
SQL100520030411400 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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search