CAMPAIGN

Deprecated. Provided for backward compatibility only.

Column Descriptions:

Name	Type	Description
CAMPAIGN_ID	INTEGER NOT NULL	Reserved for IBM internal use.
STOREENT_ID	INTEGER NOT NULL	Reserved for IBM internal use.
NAME	VARCHAR (64) NOT NULL	Reserved for IBM internal use.
DESCRIPTION	VARCHAR (254)	Reserved for IBM internal use.
TYPE	INTEGER	Reserved for IBM internal use.
STATUS	CHAR (1)	Reserved for IBM internal use.
FIELD1	VARCHAR (254)	Reserved for IBM internal use.
LASTUPDATE	TIMESTAMP NOT NULL	Reserved for IBM internal use.
LASTUPDATEDBY	VARCHAR (254) NOT NULL	Reserved for IBM internal use.
OWNER	VARCHAR (64)	Reserved for IBM internal use.
OBJECTIVE	VARCHAR (254)	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CAMPAIGN_ID	Primary Key
I0000060	NAME+STOREENT_ID	Unique Index
I0000511	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_182	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1041	CAMPAIGN_ID	EMLCAMPREL	CAMPAIGN_ID	Cascade
F_1047	CAMPAIGN_ID	PX_PROMOTION	CAMPAIGN_ID	Cascade
F_384	CAMPAIGN_ID	INITIATIVE	CAMPAIGN_ID	Cascade