Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INTVSCHED
This table describes the scheduling of campaign activities and content onto e-Marketing Spots.
Column Name Column Type Description INTVSCHED_ID INTEGER NOT NULL Primary key. INITIATIVE_ID INTEGER NOT NULL The ID of the object assigned to be scheduled to E-Marketing Spot. At present a campaign activity or store content can be scheduled to E-Marketing Spot. EMSPOT_ID INTEGER NOT NULL The ID of the e-Marketing Spot. STARTDATE TIMESTAMP NOT NULL The date before which the campaign activity should not be shown. ENDDATE TIMESTAMP NOT NULL The date beyond which the campaign activity should no longer be shown. PRIORITY INTEGER The priority of this schedule. This value resolves conflicts when multiple campaign activities are scheduled to display in the same e-Marketing Spot. The initiative schedule with the highest priority is displayed. By default, the highest priority is 1. STOREENT_ID INTEGER The ID of the store to which the campaign activity schedule belongs. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030345030 INTVSCHED_ID Primary Key I0000313 EMSPOT_ID Non-Unique Index I0000314 INITIATIVE_ID Non-Unique Index I0000590 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_387 EMSPOT_ID EMSPOT EMSPOT_ID Cascade F_386 INITIATIVE_ID ESMAPOBJ ESMAPOBJ_ID Cascade F_956 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1095 SCHED_ID SHDCACRM INTVSCHED_ID Cascade
Related reference
_vcc_freeselect_bottom_