While this table does not have a field defined as a primary key, the TARGETRESPONSEID field should be unique and considered a primary key.
Added in Version 7.0
The TARGETRESPONSE table stores information related to campaign target responses. This table contains information including, but not limited to, the campaign target ID, campaign ID, response date, response method, lead source, and campaign stage.
The TARGETRESPONSE table has a (One) to (Many) relationship with the RESPONSEPRODUCT table.
|
|
While this table does not have a field defined as a primary key, the TARGETRESPONSEID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
TARGETRESPONSEID |
char(12) |
NOT NULL |
TARGETRESPONSE_TARGETRESPONSEID (IE) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
CAMPAIGNTARGETID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
CAMPAIGNID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
RESPONSEDATE |
datetime(8) |
NULLS |
|
|
|
|
RESPONSEMETHOD |
varchar(32) |
NULLS |
|
|
|
|
COMMENTS |
varchar(255) |
NULLS |
|
|
|
|
LEADSOURCE |
varchar(32) |
NULLS |
|
|
|
|
STAGE |
varchar(64) |
NULLS |
|
|
|
|
CLICKDATE |
datetime(8) |
NULLS |
|
|
|
|
CLICKURL |
varchar(128) |
NULLS |
|
|
|
|
CLICKLINKNAME |
varchar(32) |
NULLS |
|
|
|
|
RESPONDED |
char(1) |
NULLS |
|
|
|
|
CONTACTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
LEADID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
INTEREST |
varchar(64) |
NULLS |
|
|
|
|
INTERESTLEVEL |
varchar(64) |
NULLS |
|
|
|
|
STATUS |
varchar(64) |
NULLS |
|
|
|