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 |
