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 |