Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: POLICYDESC
This table stores descriptions for a business policy.
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 SQL100520030411580 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
_vcc_freeselect_bottom_