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 |