WebSphere Commerce database table: POLICYDESC

This table stores descriptions for a business policy.

Column Descriptions
Column Name Column Type Description
POLICY_ID BIGINT NOT NULL The policy ID.
LANGUAGE_ID INTEGER NOT NULL The language ID. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(508) NOT NULL The policy description.
LONGDESCRIPTION VARCHAR(4000) The policy long description.
TIMECREATED TIMESTAMP Time created.
TIMEUPDATED TIMESTAMP Time updated.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235233790 POLICY_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_611 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_612 POLICY_ID POLICY POLICY_ID Cascade
Related reference