# Pardot schema ERD

Table and field reference for the Fivetran Pardot connector.

## Table & Field Reference

### tag_object

| Column | Type | Keys |
| --- | --- | --- |
| object_id | Long | PK |
| tag_id | Long | PK, FK |

### list_email_list

| Column | Type | Keys |
| --- | --- | --- |
| role | String | PK |
| list_email_id | Long | PK, FK |
| list_id | Long | PK, FK |

### opportunity_prospect

| Column | Type | Keys |
| --- | --- | --- |
| opportunity_id | Long | PK, FK |
| prospect_id | Long | PK, FK |
| updated_at | Instant |  |

### email_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| created_by_id | Long | FK |
| updated_by_id | Long | FK |
| created_at | Instant |  |
| folder_id | Long |  |
| html_message | String |  |
| is_auto_responder_email | Boolean |  |
| is_drip_email | Boolean |  |
| is_list_email | Boolean |  |
| is_one_to_one_email | Boolean |  |
| name | String |  |
| subject | String |  |
| tag_replacement_language | String |  |
| text_message | String |  |
| tracker_domain_id | Long |  |
| type | String |  |
| updated_at | Instant |  |

### visitor_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| email_id | Long | FK |
| email_template_id | Long | FK |
| list_email_id | Long | FK |
| opportunity_id | String | FK |
| prospect_id | Long | FK |
| visit_id | Long | FK |
| visitor_id | Long | FK |
| created_at | Instant |  |
| custom_redirect_id | Long |  |
| details | String |  |
| file_id | Long |  |
| form_handler_id | Long |  |
| form_id | Long |  |
| landing_page_id | Long |  |
| multivariate_test_variation_id | Long |  |
| paid_search_ad_id | Long |  |
| site_search_query_id | Long |  |
| type | Long |  |
| type_name | String |  |
| updated_at | Instant |  |
| visitor_page_view_id | Long |  |

### reply_to_option

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_custom_field_id | Long | FK |
| email_template_id | Long | FK |
| prospect_custom_field_id | Long | FK |
| user_id | Long | FK |
| address | String |  |
| type | String |  |

### lifecycle_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| is_locked | Boolean |  |
| match_type | String |  |
| name | String |  |
| position | Int |  |
| updated_at | Instant |  |

### form_handler

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| created_by_id | Long | FK |
| updated_by_id | Long | FK |
| created_at | Instant |  |
| embed_code | String |  |
| error_location | String |  |
| folder_id | Long |  |
| is_always_email | Boolean |  |
| is_cookieless | Boolean |  |
| is_data_forwarded | Boolean |  |
| is_deleted | Boolean |  |
| name | String |  |
| salesforce_id | String |  |
| success_location | String |  |
| tracker_domain_id | Long |  |
| updated_at | Instant |  |

### prospect

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| prospect_account_id | Long | FK |
| user_id | Long | FK |
| address_one | String |  |
| address_two | String |  |
| annual_revenue | String |  |
| city | String |  |
| comments | String |  |
| company | String |  |
| country | String |  |
| created_at | Instant |  |
| crm_account_fid | String |  |
| crm_contact_fid | String |  |
| crm_last_sync | Instant |  |
| crm_lead_fid | String |  |
| crm_owner_fid | String |  |
| crm_url | String |  |
| department | String |  |
| email | String |  |
| employees | String |  |
| fax | String |  |
| first_name | String |  |
| grade | String |  |
| industry | String |  |
| is_do_not_call | Boolean |  |
| is_do_not_email | Boolean |  |
| is_permanently_deleted | Boolean |  |
| is_reviewed | Boolean |  |
| is_starred | Boolean |  |
| job_title | String |  |
| last_activity_at | Instant |  |
| last_name | String |  |
| notes | String |  |
| opted_out | Boolean |  |
| password | String |  |
| phone | String |  |
| recent_interaction | String |  |
| salutation | String |  |
| score | Long |  |
| source | String |  |
| state | String |  |
| territory | String |  |
| updated_at | Instant |  |
| website | String |  |
| years_in_business | String |  |
| zip | String |  |

### form_field_progressive

| Column | Type | Keys |
| --- | --- | --- |
| prospect_api_field_id | String | PK |
| form_field_id | Long | PK, FK |

### form_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by_id | Long | FK |
| form_id | Long | FK |
| updated_by_id | Long | FK |
| created_at | Instant |  |
| css_classes | String |  |
| data_format | String |  |
| error_message | String |  |
| has_dependents | Boolean |  |
| has_progressives | Boolean |  |
| has_values | Boolean |  |
| is_always_display | Boolean |  |
| is_do_not_prefill | Boolean |  |
| is_maintain_initial_value | Boolean |  |
| is_required | Boolean |  |
| label | String |  |
| prospect_api_field_id | String |  |
| sort_order | Int |  |
| type | String |  |
| updated_at | Instant |  |

### email

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| list_email_id | Long | FK |
| campaign_id | Long |  |
| client_type | String |  |
| created_at | Instant |  |
| created_by_id | Long |  |
| list_id | Long |  |
| name | String |  |
| prospect_id | Long |  |
| subject | String |  |

### visitor_page_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| visit_id | Long | FK |
| visitor_id | Long | FK |
| created_at | Instant |  |
| duration_in_seconds | Long |  |
| salesforce_id | String |  |
| title | String |  |
| url | String |  |

### engagement_studio_program

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by_id | Long | FK |
| schedule_created_by_id | Long | FK |
| updated_by_id | Long | FK |
| created_at | Instant |  |
| description | String |  |
| folder_id | Long |  |
| name | String |  |
| prospects_multiple_entry_maximum_entries | Int |  |
| prospects_multiple_entry_minimum_duration_in_days | Int |  |
| recipient_list_ids | String |  |
| salesforce_id | String |  |
| schedule_created_at | Instant |  |
| schedule_start_on | Instant |  |
| schedule_stop_on | Instant |  |
| status | String |  |
| suppression_list_ids | String |  |
| updated_at | Instant |  |
| business_hours_** |  |  |

### form_field_dependent

| Column | Type | Keys |
| --- | --- | --- |
| dependent_form_field_id | Long | PK, FK |
| form_field_id | Long | PK, FK |
| value | String |  |

### landing_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| created_by_id | Long | FK |
| form_id | Long | FK |
| updated_by_id | Long | FK |
| archive_date | LocalDate |  |
| bitly_is_personalized | Boolean |  |
| bitly_short_url | String |  |
| created_at | Instant |  |
| description | String |  |
| folder_id | Long |  |
| is_do_not_index | Boolean |  |
| is_use_redirect_location | Boolean |  |
| layout_table_border | Int |  |
| layout_template_id | Long |  |
| layout_type | String |  |
| name | String |  |
| redirect_location | String |  |
| salesforce_id | String |  |
| title | String |  |
| tracker_domain_id | Long |  |
| updated_at | Instant |  |
| url | String |  |
| vanity_url | String |  |
| vanity_url_path | String |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| closed_at | Instant |  |
| created_at | Instant |  |
| name | String |  |
| probability | Long |  |
| stage | String |  |
| status | String |  |
| type | String |  |
| updated_at | Instant |  |
| value | Double |  |

### external_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by_id | Long | FK |
| prospect_id | Long | FK |
| activity_date | Instant |  |
| created_at | Instant |  |
| extension | String |  |
| extension_salesforce_id | String |  |
| type | String |  |
| type_salesforce_id | String |  |
| value | String |  |

### visit

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| prospect_id | Long | FK |
| visitor_id | Long | FK |
| campaign_parameter | String |  |
| content_parameter | String |  |
| created_at | Instant |  |
| duration_in_seconds | Long |  |
| first_visitor_page_view_at | Instant |  |
| last_visitor_page_view_at | Instant |  |
| medium_parameter | String |  |
| source_parameter | String |  |
| term_parameter | String |  |
| updated_at | Instant |  |
| visitor_page_view_count | Long |  |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by_id | Long | FK |
| updated_by_id | Long | FK |
| created_at | Instant |  |
| field_id | String |  |
| is_analytics_synced | Boolean |  |
| is_record_multiple_responses | Boolean |  |
| is_required | Boolean |  |
| is_use_values | Boolean |  |
| name | String |  |
| salesforce_id | String |  |
| type | String |  |
| updated_at | Instant |  |

### lifecycle_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| next_stage_id | Long | FK |
| previous_stage_id | Long | FK |
| prospect_id | Long | FK |
| created_at | Instant |  |
| seconds_elapsed | Int |  |

### custom_redirect

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| created_by_id | Long | FK |
| updated_by_id | Long | FK |
| bitly_is_personalized | Boolean |  |
| bitly_short_url | String |  |
| created_at | Instant |  |
| destination_url | String |  |
| folder_id | Long |  |
| ga_campaign | String |  |
| ga_content | String |  |
| ga_medium | String |  |
| ga_source | String |  |
| ga_term | String |  |
| name | String |  |
| salesforce_id | String |  |
| tracked_url | String |  |
| tracker_domain_id | Long |  |
| updated_at | Instant |  |
| url | String |  |
| vanity_url | String |  |
| vanity_url_path | String |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by_id | Long | FK |
| parent_campaign_id | String | FK |
| updated_by_id | Long | FK |
| cost | Long |  |
| created_at | Instant |  |
| folder_id | Long |  |
| name | String |  |
| salesforce_id | String |  |
| updated_at | Instant |  |

### prospect_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |

### sender_option

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_custom_field_id | Long | FK |
| email_template_id | Long | FK |
| prospect_custom_field_id | Long | FK |
| user_id | Long | FK |
| address | String |  |
| name | String |  |
| type | String |  |

### list

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| created_by_id | Long | FK |
| updated_by_id | Long | FK |
| created_at | Instant |  |
| description | String |  |
| folder_id | Long |  |
| is_dynamic | Boolean |  |
| is_public | Boolean |  |
| name | String |  |
| title | String |  |
| updated_at | Instant |  |

### list_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| email_template_id | Long | FK |
| client_type | String |  |
| created_at | Instant |  |
| created_by_id | Long |  |
| html_message | String |  |
| is_deleted | Boolean |  |
| is_paused | Boolean |  |
| is_sent | Boolean |  |
| name | String |  |
| operational_email | Boolean |  |
| sent_at | Instant |  |
| subject | String |  |
| text_message | String |  |
| tracker_domain_id | Long |  |
| updated_at | Instant |  |
| updated_by_id | Long |  |

### form_handler_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by_id | Long | FK |
| form_handler_id | Long | FK |
| created_at | Instant |  |
| data_format | String |  |
| error_message | String |  |
| is_maintain_initial_value | Boolean |  |
| is_required | Boolean |  |
| name | String |  |
| prospect_api_field_id | String |  |

### user

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| account | Int |  |
| created_at | Instant |  |
| email | String |  |
| first_name | String |  |
| job_title | String |  |
| last_name | String |  |
| role | String |  |
| updated_at | Instant |  |

### tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| name | String |  |
| updated_at | Instant |  |

### list_membership

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by_id | Long | FK |
| list_id | Long | FK |
| prospect_id | Long | FK |
| updated_by_id | Long | FK |
| created_at | Instant |  |
| opted_out | Boolean |  |
| updated_at | Instant |  |

### visitor

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| prospect_id | Long | FK |
| campaign_parameter | String |  |
| content_parameter | String |  |
| created_at | Instant |  |
| do_not_sell | Boolean |  |
| hostname | String |  |
| ip_address | String |  |
| is_identified | Boolean |  |
| medium_parameter | String |  |
| page_view_count | Long |  |
| source_parameter | String |  |
| term_parameter | String |  |
| updated_at | Instant |  |

### form_field_value

| Column | Type | Keys |
| --- | --- | --- |
| sort_order | Long | PK |
| form_field_id | Long | PK, FK |
| list_id | Long | FK |
| label | String |  |
| profile_id | Long |  |
| value | String |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | FK |
| created_by_id | Long | FK |
| updated_by_id | Long | FK |
| after_form_content | String |  |
| before_form_content | String |  |
| checkbox_alignment | String |  |
| created_at | Instant |  |
| embed_code | String |  |
| folder_id | Long |  |
| font_color | String |  |
| font_family | String |  |
| font_size | String |  |
| is_always_display | Boolean |  |
| is_captcha_enabled | Boolean |  |
| is_cookieless | Boolean |  |
| is_use_redirect_location | Boolean |  |
| label_alignment | String |  |
| layout_template_id | String |  |
| name | String |  |
| radio_alignment | String |  |
| redirect_location | String |  |
| required_character | String |  |
| salesforce_id | String |  |
| show_not_prospect | Boolean |  |
| submit_button_text | String |  |
| thank_you_code | String |  |
| thank_you_content | String |  |
| tracker_domain_id | Long |  |
| updated_at | Instant |  |

## Relationships

- tag_object(tag_id) → tag(id)
- list_email_list(list_email_id) → list_email(id)
- list_email_list(list_id) → list(id)
- opportunity_prospect(opportunity_id) → opportunity(id)
- opportunity_prospect(prospect_id) → prospect(id)
- email_template(campaign_id) → campaign(id)
- email_template(created_by_id) → user(id)
- email_template(updated_by_id) → user(id)
- visitor_activity(prospect_id) → prospect(id)
- visitor_activity(visitor_id) → visitor(id)
- visitor_activity(email_id) → email(id)
- visitor_activity(opportunity_id) → opportunity(id)
- visitor_activity(visit_id) → visit(id)
- visitor_activity(campaign_id) → campaign(id)
- visitor_activity(list_email_id) → list_email(id)
- visitor_activity(email_template_id) → email_template(id)
- reply_to_option(email_template_id) → email_template(id)
- reply_to_option(user_id) → user(id)
- reply_to_option(prospect_custom_field_id) → custom_field(id)
- reply_to_option(account_custom_field_id) → custom_field(id)
- form_handler(created_by_id) → user(id)
- form_handler(updated_by_id) → user(id)
- form_handler(campaign_id) → campaign(id)
- prospect(campaign_id) → campaign(id)
- prospect(user_id) → user(id)
- prospect(prospect_account_id) → prospect_account(id)
- form_field_progressive(form_field_id) → form_field(id)
- form_field(form_id) → form(id)
- form_field(created_by_id) → user(id)
- form_field(updated_by_id) → user(id)
- email(list_email_id) → list_email(id)
- visitor_page_view(visit_id) → visit(id)
- visitor_page_view(visitor_id) → visitor(id)
- visitor_page_view(campaign_id) → campaign(id)
- engagement_studio_program(created_by_id) → user(id)
- engagement_studio_program(updated_by_id) → user(id)
- engagement_studio_program(schedule_created_by_id) → user(id)
- form_field_dependent(form_field_id) → form_field(id)
- form_field_dependent(dependent_form_field_id) → form_field(id)
- landing_page(campaign_id) → campaign(id)
- landing_page(form_id) → form(id)
- landing_page(created_by_id) → user(id)
- landing_page(updated_by_id) → user(id)
- opportunity(campaign_id) → campaign(id)
- external_activity(prospect_id) → prospect(id)
- external_activity(created_by_id) → user(id)
- visit(visitor_id) → visitor(id)
- visit(prospect_id) → prospect(id)
- custom_field(created_by_id) → user(id)
- custom_field(updated_by_id) → user(id)
- lifecycle_history(prospect_id) → prospect(id)
- lifecycle_history(previous_stage_id) → lifecycle_stage(id)
- lifecycle_history(next_stage_id) → lifecycle_stage(id)
- custom_redirect(created_by_id) → user(id)
- custom_redirect(updated_by_id) → user(id)
- custom_redirect(campaign_id) → campaign(id)
- campaign(parent_campaign_id) → campaign(id)
- campaign(created_by_id) → user(id)
- campaign(updated_by_id) → user(id)
- sender_option(email_template_id) → email_template(id)
- sender_option(user_id) → user(id)
- sender_option(prospect_custom_field_id) → custom_field(id)
- sender_option(account_custom_field_id) → custom_field(id)
- list(campaign_id) → campaign(id)
- list(created_by_id) → user(id)
- list(updated_by_id) → user(id)
- list_email(campaign_id) → campaign(id)
- list_email(email_template_id) → email_template(id)
- form_handler_field(form_handler_id) → form_handler(id)
- form_handler_field(created_by_id) → user(id)
- list_membership(list_id) → list(id)
- list_membership(prospect_id) → prospect(id)
- list_membership(created_by_id) → user(id)
- list_membership(updated_by_id) → user(id)
- visitor(prospect_id) → prospect(id)
- visitor(campaign_id) → campaign(id)
- form_field_value(form_field_id) → form_field(id)
- form_field_value(list_id) → list(id)
- form(created_by_id) → user(id)
- form(updated_by_id) → user(id)
- form(campaign_id) → campaign(id)