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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000002 ACTION Unique Index
SQL050212031151790 ACACTION_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback