Database Table: INTVSCHED

This table describes the scheduling of initiatives onto e-Marketing Spots.

Column Name Column Type Column Description
EMSPOT_ID INTEGER
NOT NULL
The ID of the e-Marketing Spot.
ENDDATE TIMESTAMP
NOT NULL
The date beyond which the initiative should no longer be shown.
INITIATIVE_ID INTEGER
NOT NULL
The ID of the initiative.
INTVSCHED_ID INTEGER
NOT NULL
Primary key.
PRIORITY INTEGER
NULL
Reserved for IBM internal use.
STARTDATE TIMESTAMP
NOT NULL
The date before which the initiative should not be shown.
STOREENT_ID INTEGER
NULL
The ID of the store to which the initiative schedule belongs.
Indexes:
Index Name Indexed Column Names Index Type
I0000313 EMSPOT_ID Non-Unique Index
I0000314 INITIATIVE_ID Non-Unique Index
SQL030416034945840 INTVSCHED_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_386 INITIATIVE_ID INITIATIVE INITIATIVE_ID Cascade
F_387 EMSPOT_ID EMSPOT EMSPOT_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
Not Applicable