This table describes the scheduling of campaign activities and content onto e-Marketing Spots.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031233450 |
INTVSCHED_ID |
Primary Key |
I0000313 |
EMSPOT_ID |
Non-Unique Index |
I0000314 |
INITIATIVE_ID |
Non-Unique Index |
I0000590 |
STOREENT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 Name(s) | Constraint Type |
F_1095 |
SCHED_ID |
SHDCACRM |
INTVSCHED_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.