CAMPAIGN

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

Column Descriptions:

NameTypeDescription
CAMPAIGN_IDINTEGER NOT NULLReserved for HCL internal use.
STOREENT_IDINTEGER NOT NULLReserved for HCL internal use.
NAMEVARCHAR (64) NOT NULLReserved for HCL internal use.
DESCRIPTIONVARCHAR (254)Reserved for HCL internal use.
TYPEINTEGERReserved for HCL internal use.
STATUSCHAR (1)Reserved for HCL internal use.
FIELD1VARCHAR (254)Reserved for HCL internal use.
LASTUPDATETIMESTAMP NOT NULLReserved for HCL internal use.
LASTUPDATEDBYVARCHAR (254) NOT NULLReserved for HCL internal use.
OWNERVARCHAR (64)Reserved for HCL internal use.
OBJECTIVEVARCHAR (254)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL 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