Added in Version 7.0
The CAMPAIGNPRODUCT table stores all the information pertaining to products assigned to campaigns. This information includes, but is not limited to, campaign product ID, campaign ID, product name, and product family.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CAMPAIGNPRODUCTID (PK) |
char(12) |
NOT NULL |
CAMPAIGNPRODUCT_ID_PK (CA) |
|
|
|
CAMPAIGNID (FK) |
char(12) |
NOT NULL |
CAMPAIGNPRODUCT_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 |
|
|
|
|
NAME |
varchar(64) |
NULLS |
|
|
|
|
PRODUCTID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ACTUALID |
varchar(64) |
NULLS |
|
|
|
|
FAMILY |
varchar(32) |
NULLS |
|
|
|