WebSphere Commerce database table: CHKCMD

CHKCMD

This table contains information about check commands, which can be used by a store to determine whether scheduled jobs require execution. This information is for the Scheduler menu in the Administration Console.

Column Descriptions:

Name Type Description
CHKCMD_ID INTEGER NOT NULL Unique identifier of the check command.
STOREENT_ID INTEGER The store associated with the check command. The default value is 0, which is the site.
DISPLAYNAME VARCHAR (254) The key which symbolizes what the check command does.
INTERFACENAME VARCHAR (254) The interface of the check 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
<SYSTEM-GENERATED> CHKCMD_ID Primary Key
I0000534 STOREENT_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_236 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_234 CHKCMD_ID CHKARRANG CHKCMD_ID Cascade

Related reference
Scheduler data model

Name	Type	Description
CHKCMD_ID	INTEGER NOT NULL	Unique identifier of the check command.
STOREENT_ID	INTEGER	The store associated with the check command. The default value is 0, which is the site.
DISPLAYNAME	VARCHAR (254)	The key which symbolizes what the check command does.
INTERFACENAME	VARCHAR (254)	The interface of the check 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
<SYSTEM-GENERATED>	CHKCMD_ID	Primary Key
I0000534	STOREENT_ID	Non-Unique Index