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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034823320 | ACACTGRP_ID, ACACTION_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|