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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000010 | GRPNAME | Unique Index |
SQL030416034832910 | ACRESGRP_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_46 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
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 |