campaigns


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
accounts.campaign_id Defined in XML R
campaign_log.campaign_id Defined in XML R
campaign_trkrs.campaign_id Defined in XML R
campaigns_audit.parent_id Defined in XML R
contacts.campaign_id Defined in XML R
email_marketing.campaign_id Defined in XML R
emailman.campaign_id Defined in XML R
leads.campaign_id Defined in XML R
notes.parent_id Defined in XML R
opportunities.campaign_id Defined in XML R
prospect_list_campaigns.campaign_id Defined in XML R
prospects.campaign_id Defined in XML R
securitygroups_records.record_id Defined in XML R
surveyresponses.campaign_id Defined in XML R
name VARCHAR 255 √ NULL
date_entered DATETIME 19 √ NULL
date_modified DATETIME 19 √ NULL
modified_user_id CHAR 36 √ NULL
users.id Defined in XML R
created_by CHAR 36 √ NULL
users.id Defined in XML R
deleted BOOLEAN 3 √ 0
assigned_user_id CHAR 36 √ NULL
users.id Defined in XML R
tracker_key INT 10 √ null
tracker_count INT 10 √ 0
refer_url VARCHAR 255 √ 'http://'
tracker_text VARCHAR 255 √ NULL
start_date DATE 10 √ NULL
end_date DATE 10 √ NULL
status VARCHAR 100 √ NULL
impressions INT 10 √ 0
currency_id CHAR 36 √ NULL
budget DOUBLE 22 √ NULL
expected_cost DOUBLE 22 √ NULL
actual_cost DOUBLE 22 √ NULL
expected_revenue DOUBLE 22 √ NULL
campaign_type VARCHAR 100 √ NULL
objective TEXT 65535 √ NULL
content TEXT 65535 √ NULL
frequency VARCHAR 100 √ NULL
survey_id CHAR 36 √ NULL
surveys.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
camp_auto_tracker_key Performance Asc tracker_key
idx_campaign_name Performance Asc name
idx_survey_id Performance Asc survey_id

Relationships

Close relationships within degrees of separation