ACRESMEMRL

This is an access control table that stores resource-member relationships for resources of different types.

Column Descriptions:

NameTypeDescription
RESOURCEIDBIGINTThe resource ID that has this relationship with the member.
ACRESMEMRL_IDBIGINT NOT NULLThe resource member relation ID. This is a primary key.
MEMBER_IDBIGINT NOT NULLThe member ID that has a relationship with the resource.
ACRELATION_IDINTEGER NOT NULLThe relation ID. It refers to the relation in this record.
ACRESCGRY_IDINTEGER NOT NULLThe resource category ID that indicates the type of resource.
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>ACRESMEMRL_IDPrimary Key
I0000011 MEMBER_ID+RESOURCEID+ACRELATION_ID+ACRESCGRY_IDUnique Index
I0000012RESOURCEID+ACRELATION_ID+ACRESCGRY_IDNon-Unique Index
I0000447ACRESCGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_47ACRELATION_IDACRELATIONACRELATION_IDCascade
F_48MEMBER_IDMEMBERMEMBER_IDCascade
F_49ACRESCGRY_IDACRESCGRYACRESCGRY_IDCascade