CAMPAIGN

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
CAMPAIGN_IDINTEGER NOT NULLReserved for IBM internal use.
STOREENT_IDINTEGER NOT NULLReserved for IBM internal use.
NAMEVARCHAR (64) NOT NULLReserved for IBM internal use.
DESCRIPTIONVARCHAR (254)Reserved for IBM internal use.
TYPEINTEGERReserved for IBM internal use.
STATUSCHAR (1)Reserved for IBM internal use.
FIELD1VARCHAR (254)Reserved for IBM internal use.
LASTUPDATETIMESTAMP NOT NULLReserved for IBM internal use.
LASTUPDATEDBYVARCHAR (254) NOT NULLReserved for IBM internal use.
OWNERVARCHAR (64)Reserved for IBM internal use.
OBJECTIVEVARCHAR (254)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CAMPAIGN_IDPrimary Key
I0000060NAME+STOREENT_IDUnique Index
I0000511STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_182STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1041CAMPAIGN_IDEMLCAMPRELCAMPAIGN_IDCascade
F_1047CAMPAIGN_IDPX_PROMOTIONCAMPAIGN_IDCascade
F_384CAMPAIGN_IDINITIATIVECAMPAIGN_IDCascade