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.
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>ACRESCGRY_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_50ACRESCGRY_IDACRESCGRYACRESCGRY_IDCascade