Added in Version 7.0
The CAMPAIGNTARGET table stores all the information pertaining to campaign targets. This information includes, but is not limited to, campaign target ID, campaign ID, target type, target group name, and status. It links the CAMPAIGN table to records in ACCOUNT, CONTACT, LEAD, and USERINFO tables.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CAMPAIGNTARGETID (PK) |
char(12) |
NOT NULL |
CAMPAIGNTARGET_ID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
CAMPAIGNID (FK) |
char(12) |
NOT NULL |
CAMPAIGNTARGET_CAMPAIGN ID (IE) |
(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 |
|
|
|
|
ENTITYID (FK) |
char(12) |
NULLS |
CAMPAIGNTARGET_ENTITY ID (IE) |
(Many) to (One) |
|
|
(Many) to (One) |
|||||
|
(Many) to (One) |
|||||
|
(Many) to (One) |
|||||
|
TARGETTYPE |
varchar(32) |
NULLS |
|
|
|
|
GROUPNAME |
varchar(32) |
NULLS |
|
|
|
|
INITIALTARGET |
char(1) |
NULLS |
|
|
|
|
STAGE |
varchar(64) |
NULLS |
|
|
|
|
STATUS |
varchar(32) |
NULLS |
|
|