WebSphere Commerce database table: ACPLGPDESC

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

Column Descriptions
Column Name Column Type Description
ACPOLGRP_ID INTEGER NOT NULL The access control policy group ID. It is a foreign key to the ACPOLGRP 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 The display name of the access control policy group.
DESCRIPTION VARCHAR(700) The description of the access control policy group.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235115130 ACPOLGRP_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1009 ACPOLGRP_ID ACPOLGRP ACPOLGRP_ID Cascade
F_1008 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference