WebSphere Commerce database table: SRCH

SRCH_CMDREG

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

Column Descriptions:

Name Type Description
SRCH_CMDREG_ID BIGINT NOT NULL Primary key
INTERFACENAME VARCHAR (256) NOT NULL The command interface name
TENANT_ID BIGINT NOT NULL DEFAULT 0 The customer ID in a multi-tenant environment
STOREENT_ID INTEGER NOT NULL DEFAULT 0 The ID for a store. A value of 0 means that this command implementation is applicable to all stores.
PROPERTIES VARCHAR (256) The default properties associated with this command.
The properties are in the "property1=value1&property2=value2" form,
where the property is the name of the property,
and the value is the value corresponding to the property.
TARGET VARCHAR (256) 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.
CLASSNAME VARCHAR (256) The implementation class name for a command
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
P_0044 SRCH_CMDREG_ID Primary Key
I0001540 INTERFACENAME+TENANT_ID+STOREENT_ID Unique Index

Name	Type	Description
SRCH_CMDREG_ID	BIGINT NOT NULL	Primary key
INTERFACENAME	VARCHAR (256) NOT NULL	The command interface name
TENANT_ID	BIGINT NOT NULL DEFAULT 0	The customer ID in a multi-tenant environment
STOREENT_ID	INTEGER NOT NULL DEFAULT 0	The ID for a store. A value of 0 means that this command implementation is applicable to all stores.
PROPERTIES	VARCHAR (256)	The default properties associated with this command. The properties are in the "property1=value1&property2=value2" form, where the property is the name of the property, and the value is the value corresponding to the property.
TARGET	VARCHAR (256)	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.
CLASSNAME	VARCHAR (256)	The implementation class name for a command
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Name	Column Names	Type
P_0044	SRCH_CMDREG_ID	Primary Key
I0001540	INTERFACENAME+TENANT_ID+STOREENT_ID	Unique Index