Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACACTION

Overview

This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.

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
SQL100520030250690 ACACTION_ID Primary Key

Referenced By
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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search