WebSphere Commerce database table: ACPLGPDESC

ACPLGPDESC

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

Column Descriptions:

Name 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 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> ACPOLGRP_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1008 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_1009 ACPOLGRP_ID ACPOLGRP ACPOLGRP_ID Cascade

Related reference
Access control data model

Name	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 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_1008	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_1009	ACPOLGRP_ID	ACPOLGRP	ACPOLGRP_ID	Cascade