INITIATIVE

Deprecated. Provided for backward compatibility only.

Column Descriptions:

Name	Type	Description
INITIATIVE_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.
CAMPAIGN_ID	INTEGER	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.
STOREENT_ID	INTEGER NOT NULL	Reserved for IBM internal use.
RULE	CLOB (1000000)	Reserved for IBM internal use.
RESULTTYPE	CHAR (1)	Reserved for IBM internal use.
SELLTYPE	INTEGER	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	INITIATIVE_ID	Primary Key
I0000134	NAME+STOREENT_ID	Unique Index
I0000588	STOREENT_ID	Non-Unique Index
I0000589	CAMPAIGN_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_384	CAMPAIGN_ID	CAMPAIGN	CAMPAIGN_ID	Cascade
F_385	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_266	INITIATIVE_ID	CPPMN	INITIATIVE_ID	Cascade