SCHCMD

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

Column Descriptions:

NameTypeDescription
SCHCMD_IDBIGINT NOT NULLA unique identifier of the defined store scheduler command.
STOREENT_IDINTEGERThe store ID of the URL. Default value should be 0 which represents the site.
PATHINFOVARCHAR (254)The URL.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SCHCMD_IDPrimary Key
I0000758STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_736STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_235SCHCMD_IDCHKARRANGSCHCMD_IDCascade