ACRLGPDESC

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


Column Descriptions:

Name Type Description
ACRELGRP_ID INTEGER NOT NULL The relationship group ID. It is a foreign key to the ACRELGRP table. Together with the LANGUAGE_ID column, it forms a primary key.
LANGUAGE_ID INTEGER NOT NULL The language ID. It is a foreign key to the LANGUAGE table. Together with the ACRELGRP_ID column, it forms a primary key.
DISPLAYNAME VARCHAR (128) NOT NULL The locale-specific display name of the relationship group.
DESCRIPTION VARCHAR (254) The locale-specific description of the relationship 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> ACRELGRP_ID+LANGUAGE_ID Primary Key


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_53 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_54 ACRELGRP_ID ACRELGRP ACRELGRP_ID Cascade