WebSphere Commerce database table: SCHCMD

The URLsthat can be used as a scheduled job by a store. This is for the Scheduler menu in the Administration Console.


Column Description(s):
Column NameColumn TypeDescription
SCHCMD_ID BIGINT NOT NULL A unique identifier of the defined store scheduler command.
STOREENT_ID INTEGER The store ID of the URL. Default value should be 0 which represents the site.
PATHINFO VARCHAR(254) The URL.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031309840 SCHCMD_ID Primary Key
I0000758 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_736 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_235 SCHCMD_ID CHKARRANG SCHCMD_ID Cascade

Feedback