Reference > Database > WebSphere Commerce database tables > S


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 Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030427140 SCHCMD_ID Primary Key
I0000758 STOREENT_ID Non-Unique Index

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

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_235 SCHCMD_ID CHKARRANG SCHCMD_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search