WebSphere Commerce database table: CMDREG

This command registry allows the server to look up an implementation and default parameters for a command interface.

Column Descriptions
Column Name Column Type Description
STOREENT_ID INTEGER NOT NULL The ID for a store. A value of 0 means that this command implementation is applicable to all stores.
INTERFACENAME VARCHAR(254) NOT NULL The command interface name.
DESCRIPTION VARCHAR(254) This is a description for the command.
CLASSNAME VARCHAR(254) The implementation class name for a command.
PROPERTIES VARCHAR(254) The default properties associated with this command. The properties are in the "property1=value1&property2=value2" form where "propertyn" is the name of the property and "valuen" is the value corresponding to the property.
LASTUPDATE TIMESTAMP The last time this entry was updated.
TARGET CHAR(16) DEFAULT 'Local' Indicates where this command is to be executed. Currently the only valid value is Local, which means all commands are executed on the local machine.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235142070 STOREENT_ID+INTERFACENAME Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_243 STOREENT_ID STOREENT STOREENT_ID Cascade
Related reference