This table is a master list of all the relationship groups that exist in the system. These relationship groups are between resources that are protected and the users in the system.
Column Name | Column Type | Column Description |
---|---|---|
ACRELGRP_ID | INTEGER NOT NULL |
The relationship group ID. |
CONDITIONS | VARCHAR (2500) NULL |
XML document describing the condition for this implicit relationship group. |
DESCRIPTION | VARCHAR (254) NULL |
Reserved for IBM internal use. |
FIELD1 | VARCHAR (64) NULL |
Customizable. |
GRPNAME | VARCHAR (200) NOT NULL |
Name of the relationship group. |
MEMBER_ID | BIGINT NOT NULL |
Foreign key to the MEMBER table for the owner of this relationship group. All relationship groups should be owned by the root organization. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000008 | GRPNAME, MEMBER_ID | Unique Index |
SQL030416034830890 | ACRELGRP_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_37 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_29 | ACRELGRP_ID | ACPOLICY | ACRELGRP_ID | Cascade |
F_54 | ACRELGRP_ID | ACRLGPDESC | ACRELGRP_ID | Cascade |