WebSphere Commerce database table: ACCCMDGRP

This table defines all commands and views that require access control and categorizes them into different groups. This table is deprecated and is provided for backward compatibility only.

Column Descriptions
Column Name Column Type Description
ACCCMDGRP_ID INTEGER NOT NULL This column is a unique table index.
MBRGRP_ID BIGINT NOT NULL This column refers to a group defined in the MBRGRP table.
ACCCMDTYPE_ID CHAR(32) NOT NULL The valid types are defined in ACCCMDTYPE table. Only two types are defined: CONTROLLER and VIEW. CONTROLLER indicates that this entry is for a controller command. VIEW indicates that this entry is for a view.
INTERFACENAME VARCHAR(254) The interface name for the command.
VIEWNAME VARCHAR(254) The name of the view that requires access control.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000004 MBRGRP_ID+INTERFACENAME+VIEWNAME+ACCCMDTYPE_ID Unique Index
SQL060903235113050 ACCCMDGRP_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_11 ACCCMDTYPE_ID ACCCMDTYPE ACCCMDTYPE_ID Cascade
F_12 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_14 ACCCMDGRP_ID ACCCUSTEXC ACCCMDGRP_ID Cascade