WebSphere Commerce database table: SHDCACRM

This table holds the relationship between the Scheduler Job ID and Initiative schedule ID. This relationship identifies which Job relates to which initiative schedule in order to modify the entry in the INTVSCHED table when an initiative schedule is updated or deleted.


Column Description(s):
Column NameColumn TypeDescription
ESPOT_ID INTEGER NOT NULL The ID of the corresponding e-spot. Foreign key to the EMSPOT table.
JOBID BIGINT NOT NULL The ID of the scheduler job.
SCHED_ID INTEGER NOT NULL The ID of the initiative schedule.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031311060 ESPOT_ID+SCHED_ID Primary Key
I0000909 JOBID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1158 ESPOT_ID EMSPOT EMSPOT_ID Cascade
F_1095 SCHED_ID INTVSCHED INTVSCHED_ID Cascade
F_1094 JOBID SCHCONFIG SCCJOBREFNUM Cascade

Feedback