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 Descriptions

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

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235249950	ESPOT_ID+SCHED_ID	Primary Key
I0000909	JOBID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1158	ESPOT_ID	EMSPOT	EMSPOT_ID	Cascade
F_1095	SCHED_ID	INTVSCHED	INTVSCHED_ID	Cascade
F_1094	JOBID	SCHCONFIG	SCCJOBREFNUM	Cascade