WebSphere Commerce database table: ACRESGPDES

ACRESGPDES

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

Column Descriptions:

Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> ACRESGRP_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_42 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_43 ACRESGRP_ID ACRESGRP ACRESGRP_ID Cascade

Related reference
Access control data model

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Constraint	Columns	Parent Table	Parent Columns	Type
F_42	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_43	ACRESGRP_ID	ACRESGRP	ACRESGRP_ID	Cascade