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 Description(s):
Column Name | Column 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 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031155910 |
ACRELATION_ID+ACRESCGRY_ID |
Primary Key |
I0000448 |
ACRESCGRY_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_51 |
ACRELATION_ID |
ACRELATION |
ACRELATION_ID |
Cascade |
F_52 |
ACRESCGRY_ID |
ACRESCGRY |
ACRESCGRY_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.