WebSphere Commerce database table: ACPOLDESC

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031153600 ACPOLICY_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_27 ACPOLICY_ID ACPOLICY ACPOLICY_ID Cascade
F_28 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback