ACRELDESC

This table stores the locale-specific information for the access control relationships which are stored in the ACRELATION table.

Column Descriptions:

NameTypeDescription
ACRELATION_IDINTEGER NOT NULLThe relation ID. It is a foreign key to the ACRELATION table. Together with the LANGUAGE_ID column, it forms a primary key.
DISPLAYNAMEVARCHAR (254) NOT NULLA locale-specific display name of the relationship. Together with the LANGUAGE_ID column, it forms a unique key.
DESCRIPTIONVARCHAR (254)The description of the relationship.
LANGUAGE_IDINTEGER NOT NULLThe language ID. It is a foreign key to the LANGUAGE table. Together with the ACRELATION _ID column, it forms a primary key. For a list of language components, see 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>ACRELATION_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_35LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_36ACRELATION_IDACRELATIONACRELATION_IDCascade