Database Table: ACRELGRP

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000008 GRPNAME, MEMBER_ID Unique Index
SQL030416034830890 ACRELGRP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_37 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
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