Database Table: ACRESACT

This table captures the relationship between resources and actions. Given a resource, we can find out the associated actions from this table.

Column Name Column Type Column Description
ACACTION_ID INTEGER
NOT NULL
Action ID. This is a Primary Key. Foreign key to the ACACTION table.
ACRESCGRY_ID INTEGER
NOT NULL
Resource category ID. This is a Primary Key. Foreign key to the ACRESCGRY table
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034831260 ACRESCGRY_ID, ACACTION_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_38 ACACTION_ID ACACTION ACACTION_ID Cascade
F_39 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade

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