Database Table: ACRESGRP

This table stores all the resource groups in the system. The conditions column stores an XML document containing the constraints and attribute value pairs used for grouping the resources.

Column Name Column Type Column Description
ACRESGRP_ID INTEGER
NOT NULL
The resource group ID.
CONDITIONS VARCHAR (2500)
NULL
XML document describing the condition for this implicit resource group.
DESCRIPTION VARCHAR (254)
NULL
Reserved for IBM internal use.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
GRPNAME VARCHAR (254)
NOT NULL
Name of the resource group.
MEMBER_ID BIGINT
NOT NULL
Foreign key to the MEMBER table for the owner of this resource group. All resource groups should be owned by the root organization.
Indexes:
Index Name Indexed Column Names Index Type
I0000010 GRPNAME Unique Index
SQL030416034832910 ACRESGRP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_46 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_33 ACRESGRP_ID ACPOLICY ACRESGRP_ID Cascade
F_43 ACRESGRP_ID ACRESGPDES ACRESGRP_ID Cascade
F_44 ACRESGRP_ID ACRESGPRES ACRESGRP_ID Cascade