WebSphere Commerce database table: ACRELDESC

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

Column Descriptions
Column Name Column Type Description
ACRELATION_ID INTEGER NOT NULL The relation ID. It is a foreign key to the ACRELATION table. Together with the LANGUAGE_ID column, it forms a primary key.
DISPLAYNAME VARCHAR(254) NOT NULL A locale-specific display name of the relationship. Together with the LANGUAGE_ID column, it forms a unique key.
DESCRIPTION VARCHAR(254) The description of the relationship.
LANGUAGE_ID INTEGER NOT NULL The language ID. It is a foreign key to the LANGUAGE table. Together with the ACRELATION _ID column, it forms a primary key. For a list of language components, see the LANGUAGE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235117640 ACRELATION_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_36 ACRELATION_ID ACRELATION ACRELATION_ID Cascade
F_35 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade