WebSphere Commerce database table: ACCCMDTYPE

WebSphere Commerce database table: ACCCMDTYPE

This table defines all the valid ACCCMDTYPE_ID that can be used in the ACCCMDGRP table. This table is deprecated and is provided for backward compatibility only.

Column Descriptions
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

SQL060903235113190 ACCCMDTYPE_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type

F_11 ACCCMDTYPE_ID ACCCMDGRP ACCCMDTYPE_ID Cascade

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.