WebSphere Commerce database table: ACRESGPDES

This table stores locale specific display information for the ACRESGRP table.

Column Descriptions
Column Name Column Type Description
ACRESGRP_ID INTEGER NOT NULL The resource group ID. Together with the LANGUAGE_ID column, it forms a primary key.
DISPLAYNAME VARCHAR(700) NOT NULL The display name for this resource group.
DESCRIPTION VARCHAR(700) The description of the resource group.
LANGUAGE_ID INTEGER NOT NULL The language ID. It is a primary key, and it is also a foreign key to the LANGUAGE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235119320 ACRESGRP_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_43 ACRESGRP_ID ACRESGRP ACRESGRP_ID Cascade
F_42 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade