ACRSCGDES

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


Column Descriptions:

Name Type Description
LANGUAGE_ID INTEGER NOT NULL The language ID of the locale for which this display name is valid. For a list of language components, see the LANGUAGE table.
ACRESCGRY_ID INTEGER NOT NULL The resource ID.
DISPLAYNAME VARCHAR (700) NOT NULL The locale-specific display name.
DESCRIPTION VARCHAR (700) The description for this resource category. This field is optional.
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> LANGUAGE_ID+ACRESCGRY_ID Primary Key
I0000449 ACRESCGRY_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_55 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade
F_56 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference
Access control data model