WebSphere Commerce database table: CHKCMD

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

Column Descriptions
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235140840 CHKCMD_ID Primary Key
I0000534 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_236 STOREENT_ID STOREENT STOREENT_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_234 CHKCMD_ID CHKARRANG CHKCMD_ID Cascade