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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000004 MBRGRP_ID+INTERFACENAME+VIEWNAME+ACCCMDTYPE_ID Unique Index
SQL050212031152220 ACCCMDGRP_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_11 ACCCMDTYPE_ID ACCCMDTYPE ACCCMDTYPE_ID Cascade
F_12 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_14 ACCCMDGRP_ID ACCCUSTEXC ACCCMDGRP_ID Cascade

Feedback