ACACTDESC

This table stores locale-specific information for Access Control actions which are stored in the ACACTION table.

Column Descriptions:

NameTypeDescription
ACACTION_IDINTEGER NOT NULLThe action ID. It is a foreign key to the ACACTION table. Together with the LANGUAGE_ID column, it forms the primary key.
DISPLAYNAMEVARCHAR (700) NOT NULLThe display name for the action.
DESCRIPTIONVARCHAR (700)The description of this action.
LANGUAGE_IDINTEGER NOT NULLThe language ID. It is a foreign key to the LANGUAGE table. Together with the ACACTION_ID column, it forms the 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>ACACTION_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_5LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_6ACACTION_IDACACTIONACACTION_IDCascade