Database Table: ACACTACTGP

This table captures the association between access control actions and action groups.

Column Name Column Type Column Description
ACACTGRP_ID INTEGER
NOT NULL
Action group ID. Foreign key to the ACACTGRP table. Together with the ACACTION_ID, this forms the primary key.
ACACTION_ID INTEGER
NOT NULL
Action ID. Foreign key to the ACACTION table. Together with the ACACTGRP_ID, it forms the primary key.
FIELD1 VARCHAR (128)
NULL
Customizable.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034823320 ACACTGRP_ID, ACACTION_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_3 ACACTGRP_ID ACACTGRP ACACTGRP_ID Cascade
F_4 ACACTION_ID ACACTION ACACTION_ID Cascade

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