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.
OPTCOUNTERSMALLINTThe 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