CAMPAIGNCONTACT Table

Deprecated in Version 7.0

The CAMPAIGNCONTACT table contains records for contacts included in marketing campaigns.  

  • CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.

  • The CAMPAIGNCONTACT table has a (Many) to (Many) relationship with the CONTACT and CAMPAIGN tables.

Legend
 

Field Datatype (Length) Allow Nulls Indexes Relationship Related Table and Field

CAMPAIGNCONTACTID (PK)

char(12)

NULLS

CAMPAIGNCONTACT_PRIMARY (AK)

 

 

CAMPAIGNID(FK)

char(12)

NULLS

CAMPAIGNCONTACT_CAMPAIGNID (IE)
CAMPAIGNCONTACT_CAMCON (AK)

(Many) to (One)

CAMPAIGN.CAMPAIGNID

CREATEUSER (FK)

char(12)

NULLS

 

 

USERINFO.USERID

CREATEDATE

datetime(8)

NULLS

 

 

 

MODIFYUSER (FK)

char(12)

NULLS

 

(Many) to (One)

USERINFO.USERID

MODIFYDATE

datetime(8)

NULLS

 

 

 

CONTACTID (FK)

char(12)

NULLS

CAMPAIGNCONTACT_CAMCON (AK)
CAMPAIGNCONTACT_CONTACTID (IE)

(Many) to (One)

CONTACT.CONTACTID

INITIALTARGET

char(1)

NULLS