ACRESPRIM

This table stores the primary resource column names for an access control resource. A given resource can have more than one primary column.

Column Descriptions:

NameTypeDescription
ACRESCGRY_IDINTEGER NOT NULLThe resource ID for which the entry applies.
RESPRIMARYCOLVARCHAR (64) NOT NULLThe column that stores the primary key for a resource.
FIELD1VARCHAR (128)This column is customizable.
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>ACRESCGRY_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_50ACRESCGRY_IDACRESCGRYACRESCGRY_IDCascade