Database Table: ACRESGPRES

This table associates resource groups with resource categories (or the classes of resources). You can use this table to group various resources in a group based on their class names.

Column Name Column Type Column Description
ACRESCGRY_ID INTEGER
NOT NULL
Resource category ID. Foreign key to the ACRESCGRY table.
ACRESGRP_ID INTEGER
NOT NULL
Resource group ID. Foreign key to the ACRESGRP_ID in the ACRESGRP table.
FIELD1 VARCHAR (128)
NULL
Customizable.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034832560 ACRESGRP_ID, ACRESCGRY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_44 ACRESGRP_ID ACRESGRP ACRESGRP_ID Cascade
F_45 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable