WebSphere Commerce database table: ACACTION

This table is a master list of all the access control 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 Descriptions
Column Name Column Type Description
ACACTION_ID INTEGER NOT NULL The action ID. This is a primary key.
ACTION VARCHAR(254) NOT NULL This is the action to which this record refers.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000002 ACTION Unique Index
SQL060903235112600 ACACTION_ID Primary Key

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