ACRESMEMRL

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

Column Descriptions:

Name	Type	Description
RESOURCEID	BIGINT	The resource ID that has this relationship with the member.
ACRESMEMRL_ID	BIGINT NOT NULL	The resource member relation ID. This is a primary key.
MEMBER_ID	BIGINT NOT NULL	The member ID that has a relationship with the resource.
ACRELATION_ID	INTEGER NOT NULL	The relation ID. It refers to the relation in this record.
ACRESCGRY_ID	INTEGER NOT NULL	The resource category ID that indicates the type of resource.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ACRESMEMRL_ID	Primary Key
I0000011	MEMBER_ID+RESOURCEID+ACRELATION_ID+ACRESCGRY_ID	Unique Index
I0000012	RESOURCEID+ACRELATION_ID+ACRESCGRY_ID	Non-Unique Index
I0000447	ACRESCGRY_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_47	ACRELATION_ID	ACRELATION	ACRELATION_ID	Cascade
F_48	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_49	ACRESCGRY_ID	ACRESCGRY	ACRESCGRY_ID	Cascade

Related reference
Access control data model