CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
Deprecated in Version 7.0
The CONTACTRESPONSE table contains records for contacts who have responded to marketing campaigns. The information includes the Contact ID, response date, campaign ID, response method, and if the contact was included in the target audience for the campaign.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CONTACTRESPONSEID (PK) |
char(12) |
NULLS |
CONTACTRESPONSE_PRIMARY (AK) |
|
|
|
CONTACTID(FK) |
char(12) |
NULLS |
CONTACTRESPONSE_CONTACTID (IE) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
RESPONSEDATE |
datetime(8) |
NULLS |
|
|
|
|
RESPONSEMETHOD |
varchar(32) |
NULLS |
|
|
|
|
CAMPAIGNID(FK) |
char(12) |
NULLS |
CONTACTRESPONSE_CAMPAIGNID (IE) |
|
|
|
CAMPAIGNCONTACTID (FK) |
char(12) |
NULLS |
|
|
|
|
RESPONDED |
int(4) |
NULLS |
|
|
|