Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACRLGPDESC

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

Column Name Column Type Description
ACRELGRP_ID INTEGER NOT NULL The relationship group ID. It is a foreign key to the ACRELGRP table.

Together with the LANGUAGE_ID column, it forms a primary key.

LANGUAGE_ID INTEGER NOT NULL The language ID. It is a foreign key to the LANGUAGE table.

Together with the ACRELGRP_ID column, it forms a primary key.

DISPLAYNAME VARCHAR(128) NOT NULL The locale-specific display name of the relationship group.
DESCRIPTION VARCHAR(254) The locale-specific description of the relationship group.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030255550 ACRELGRP_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_54 ACRELGRP_ID ACRELGRP ACRELGRP_ID Cascade
F_53 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search