Database Table: ACACTION

This table is a master list of all the actions in the system. Typically the actions map to the controller commands and views in the system. This table stores all the actions that can be performed on the resources in the system.

Column Name Column Type Column Description
ACACTION_ID INTEGER
NOT NULL
Action ID. This is a Primary Key.
ACTION VARCHAR (254)
NOT NULL
This is the action that this record refers to.
Indexes:
Index Name Indexed Column Names Index Type
I0000002 ACTION Unique Index
SQL030416034824350 ACACTION_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_38 ACACTION_ID ACRESACT ACACTION_ID Cascade
F_4 ACACTION_ID ACACTACTGP ACACTION_ID Cascade
F_6 ACACTION_ID ACACTDESC ACACTION_ID Cascade