Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACCCMDTYPE

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
ACCCMDTYPE_ID CHAR(32) NOT NULL This column defines the valid types for the corresponding column in the ACCCMDGRP table. Only "CONTROLLER" and "VIEW" are defined.
FIELD1 VARCHAR(254) This column is customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030251280 ACCCMDTYPE_ID Primary Key

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_11 ACCCMDTYPE_ID ACCCMDGRP ACCCMDTYPE_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search