Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACPOLDESC

This table stores locale-specific information for the ACPOLICY table.

Column Name Column Type Description
ACPOLICY_ID INTEGER NOT NULL The policy ID. It is a foreign key to the ACPOLICY table.
LANGUAGE_ID INTEGER NOT NULL The language ID. It is a foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table.
DISPLAYNAME VARCHAR(700) NOT NULL This column contains a locale-specific description of the policy.
DESCRIPTION VARCHAR(700) This column contains a description of the policy. This field is optional.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030252590 ACPOLICY_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_27 ACPOLICY_ID ACPOLICY ACPOLICY_ID Cascade
F_28 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search