Reference > Database > WebSphere Commerce database tables > S
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 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 SQL100520030428520 ESPOT_ID+SCHED_ID Primary Key I0000909 JOBID Non-Unique Index I0001287 SCHED_ID 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 _vcc_freeselect_bottom_