This table associates an access control resource
with the relationships that it supports. Given a resource, you can
find out the possible relationships that it can have and also the
table and the columns in which these relationships are stored.
Column Descriptions:
Name | Type | Description |
ACRELATION_ID | INTEGER NOT NULL | The relationship ID. It is a primary key, and a
foreign key to the ACRELATION table. |
ACRESCGRY_ID | INTEGER NOT NULL | The resource category ID. It is a primary key,
and a foreign key to the ACRESCGRY table. |
RESRELTABLE | VARCHAR (64) NOT NULL | The name of the table that stores the member
relationships for a given resource. |
RESRELMEMCOL | VARCHAR (64) NOT NULL | The column in the relationship table that stores
the member ID. |
RESRELKEYCOL | VARCHAR (64) | The column in the relationship table that stores
the resource ID. |
RESRELCOL | VARCHAR (64) | The column in the relationship table that stores
the resource relationship. |
RESJOINCOL | VARCHAR (64) | The column in the main resource table that can be
joined with the RESRELKEYCOL column. |
FIELD1 | VARCHAR (128) | This column is customizable. |
RESOURCETYPE | VARCHAR (64) | The column name in the relationship table that
stores the resource type for which the relationship applies. This
field is used for relationship tables that capture relationships
for more than one type of resource. It would be the string
"ACRESCGRY_ID" for ACRESMEMRL table. |
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> | ACRELATION_ID+ACRESCGRY_ID | Primary Key |
I0000448 | ACRESCGRY_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_51 | ACRELATION_ID | ACRELATION | ACRELATION_ID | Cascade |
F_52 | ACRESCGRY_ID | ACRESCGRY | ACRESCGRY_ID | Cascade |