Database Table: SCHCMD

The URL commands that can be used as a scheduled job by a store. This is for the scheduler menu in the Administration Console.

Column Name Column Type Column Description
PATHINFO VARCHAR (254)
NULL
The URL command.
SCHCMD_ID BIGINT
NOT NULL
A unique identifier of the defined store scheduler command.
STOREENT_ID INTEGER
NULL
The store ID of the URL command. Default value should be 0 which represents the site.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035101460 SCHCMD_ID Primary Key
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