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
prospects.id Defined in XMLR
accounts.id Defined in XMLR
contacts.id Defined in XMLR
leads.id Defined in XMLR
target_type VARCHAR 100 null
activity_type VARCHAR 100 null
activity_date DATETIME 19 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 19 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