ACRESGPDES

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

Column Descriptions:

NameTypeDescription
ACRESGRP_IDINTEGER NOT NULLThe resource group ID. Together with the LANGUAGE_ID column, it forms a primary key.
DISPLAYNAMEVARCHAR (700) NOT NULLThe display name for this resource group.
DESCRIPTIONVARCHAR (700)The description of the resource group.
LANGUAGE_IDINTEGER NOT NULLThe language ID. It is a primary key, and it is also a foreign key to the LANGUAGE table.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ACRESGRP_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_42LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_43ACRESGRP_IDACRESGRPACRESGRP_IDCascade