Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACRESGPDES

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

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
SQL100520030254370 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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search