The CONTACT_LEADSOURCE table stores a reference to the lead source that referred the contact.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CONTACTID (PK)(FK) |
STANDARDID |
NOT NULL |
CONTACT_LEADSOURCE_COMPOSITE_PK (CA) |
(Many) to (One) |
|
|
LEADSOURCEID (PK)(FK) |
STANDARDID |
NOT NULL |
CONTACT_LEADSOURCE_COMPOSITE_PK (CA) |
(Many) to ( One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
CREATEUSER(FK) |
STANDARDID |
NULLS |
|
(Many) to ( One) |
|
|
LEADDATE |
datetime |
NULLS |
|
|
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER(FK) |
STANDARDID |
NULLS |
|
(Many) to ( One) |