campaign_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
campaign_id CHAR 36 √ null
campaigns.id Defined in XMLR
target_tracker_key VARCHAR 36 √ null
target_id CHAR 36 √ null
users.id Defined in XMLR
contacts.id Defined in XMLR
prospects.id Defined in XMLR
leads.id Defined in XMLR
accounts.id Defined in XMLR
target_type VARCHAR 100 √ null
activity_type VARCHAR 100 √ null
activity_date DATETIME 26 √ null
related_id CHAR 36 √ null
contacts.id Defined in XMLR
emails.id Defined in XMLR
leads.id Defined in XMLR
opportunities.id Defined in XMLR
related_type VARCHAR 100 √ null
archived BIT 1 √ 0
hits INT 10 √ 0
list_id CHAR 36 √ null
deleted BIT 1 √ 0
date_modified DATETIME 26 √ null
more_information VARCHAR 100 √ null
marketing_id CHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_camp_campaign_id Performance Asc campaign_id
idx_camp_more_info Performance Asc more_information
idx_camp_tracker Performance Asc target_tracker_key
idx_camplog_deleted Performance Asc deleted
idx_target_id_deleted Performance Asc/Asc target_id + deleted

Relationships

Close relationships within degrees of separation