Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CMDREG
This command registry allows the server to look up an implementation and default parameters for a command interface.
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 SQL100520030315620 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