# Eloqua schema ERD

Table and field reference for the Fivetran Eloqua connector.

## Table & Field Reference

### contact_list_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Long | PK, FK |
| contact_list_id | Long | PK, FK |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | Long | FK |
| updated_by | String | FK |
| accessed_at | Instant |  |
| actual_cost | BigDecimal |  |
| badge_id | String |  |
| budgeted_cost | BigDecimal |  |
| campaign_category | String |  |
| campaign_type | String |  |
| clr_end_date | String |  |
| created_at | Instant |  |
| crm_id | String |  |
| current_status | String |  |
| description | String |  |
| end_at | Instant |  |
| first_activation | Instant |  |
| folder_id | Long |  |
| is_email_marketing_campaign | Boolean |  |
| is_included_in_roi | Boolean |  |
| is_member_allowed_re_entry | Boolean |  |
| is_read_only | Boolean |  |
| is_synced_with_crm | Boolean |  |
| member_count | Long |  |
| name | String |  |
| product | String |  |
| region | String |  |
| run_as_user_id | Long |  |
| scheduled_for | String |  |
| source_template_id | String |  |
| start_at | Instant |  |
| updated_at | Instant |  |

### event_registration_session_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| event_registration_id | Long | PK, FK |
| data_type | String |  |
| name | String |  |
| type | String |  |
| output_format_** |  |  |

### contact_list_segment_element

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| segment_id | Long | PK, FK |
| contact_list_id | Long | FK |
| count | Long |  |
| is_included | Boolean |  |
| last_calculated_at | Instant |  |
| type | String |  |

### contact_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | String | FK |
| updated_by | String | FK |
| created_at | Instant |  |
| current_status | String |  |
| data_lookup_id | String |  |
| folder_id | Long |  |
| name | String |  |
| scope | String |  |
| type | String |  |
| updated_at | Instant |  |

### event_registration_session_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| event_registration_id | Long | PK, FK |
| session_id | Long | PK, FK |
| session_field_id | Long | FK |
| type | String |  |
| value | String |  |

### event_registration_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| event_registration_id | Long | PK, FK |
| name | String |  |
| participants_limit | Int |  |
| type | String |  |

### email_form

| Column | Type | Keys |
| --- | --- | --- |
| email_id | Long | PK, FK |
| form_id | Long | PK, FK |

### form

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

### form_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| form_id | Long | FK |
| submitted_by_contact_id | Long | FK |
| submitted_at | Instant |  |

### option

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| option_list_id | Long | PK, FK |
| display_name | String |  |
| type | String |  |
| value | String |  |

### event_registration_registrant

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| account_id | Long | FK |
| contact_id | Long | FK |
| event_registration_id | Long | FK |
| created_at | Instant |  |
| custom_object_record_status | String |  |
| is_mapped | String |  |
| name | String |  |
| type | String |  |
| unique_code | String |  |
| updated_at | Instant |  |

### event_registration

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | Long | FK |
| updated_by | Long | FK |
| created_at | Instant |  |
| description | String |  |
| email_address_field_id | Long |  |
| event_group_by_field_id | Long |  |
| folder_id | Long |  |
| name | String |  |
| type | String |  |
| unique_code_field_id | Long |  |
| updated_at | Instant |  |

### contact_activity

| Column | Type | Keys |
| --- | --- | --- |
| activity_type | String | PK |
| id | Long | PK |
| campaign_id | Long | FK |
| contact_id | Long | FK |
| form_id | Long | FK |
| visitor_id | Long | FK |
| activity_date | Instant |  |
| asset_id | Long |  |
| asset_name | String |  |
| asset_type | String |  |
| contact_id_ext | String |  |
| deployment_id | Long |  |
| duration | String |  |
| email_address | String |  |
| email_clicked_thru_link | String |  |
| email_clickthrough_saved_id | String |  |
| email_recipient_id | String |  |
| email_send_type | String |  |
| email_web_link | String |  |
| external_asset_name | String |  |
| external_asset_type | String |  |
| external_id | String |  |
| external_type | String |  |
| first_page_view_url | String |  |
| ip_address | String |  |
| is_web_tracking_opted_in | String |  |
| number_of_pages | Long |  |
| raw_data | String |  |
| referrer_url | String |  |
| smtp_error_code | String |  |
| smtp_message | String |  |
| smtp_status_code | Long |  |
| subject_line | String |  |
| url | String |  |
| visitor_external_id | String |  |
| web_visit_id | String |  |

### account

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

### contact_segment

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Long | PK, FK |
| segment_id | Long | PK, FK |

### visitor

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| last_visit_date_and_time | Instant | PK |
| contact_id | Long | FK |
| browser_type | String |  |
| city_from_ip | String |  |
| company_dns_name | String |  |
| company_name_from_ip_1 | String |  |
| country_from_ip | String |  |
| country_name | String |  |
| created_at | Instant |  |
| current_status | String |  |
| current_total_pages | Long |  |
| current_visit_length | Long |  |
| external_id | String |  |
| first_page_in_visit | String |  |
| first_visit_date_and_time | Instant |  |
| host_name | String |  |
| ip_address | String |  |
| isp_from_ip | String |  |
| last_page_in_visit | String |  |
| latitude_from_ip | String |  |
| longitude_from_ip | String |  |
| name | String |  |
| province_from_ip | String |  |
| time_zone | String |  |
| time_zone_offset_min | String |  |
| total_pages | Long |  |
| total_time | Long |  |
| total_visits | Long |  |
| type | String |  |
| zip_code_from_ip | String |  |

### email

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | String | FK |
| updated_by | String | FK |
| archived | String |  |
| bounce_back_email | String |  |
| created_at | Instant |  |
| current_status | String |  |
| html_content_content_source | String |  |
| html_content_html | String |  |
| html_content_type | String |  |
| is_content_protected | Boolean |  |
| is_plain_text_editable | Boolean |  |
| is_private | Boolean |  |
| is_tracked | Boolean |  |
| name | String |  |
| plain_text | String |  |
| render_mode | String |  |
| reply_to_email | String |  |
| reply_to_name | String |  |
| send_plain_text_only | Boolean |  |
| sender_email | String |  |
| sender_name | String |  |
| subject | String |  |
| updated_at | Instant |  |

### event_registration_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| event_registration_id | Long | PK, FK |
| checked_value | String |  |
| data_type | String |  |
| default_value | String |  |
| display_type | String |  |
| internal_name | String |  |
| name | String |  |
| option_list_id | String |  |
| type | String |  |
| unchecked_value | String |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | Long | FK |
| updated_by | Long | FK |
| account_name | String |  |
| address_1 | String |  |
| address_2 | String |  |
| address_3 | String |  |
| bounceback_date | Instant |  |
| business_phone | String |  |
| city | String |  |
| country | String |  |
| created_at | Instant |  |
| current_status | String |  |
| email_address | String |  |
| fax | String |  |
| first_name | String |  |
| is_bounceback | Boolean |  |
| is_subscribed | Boolean |  |
| last_name | String |  |
| mobile_phone | String |  |
| name | String |  |
| postal_code | String |  |
| province | String |  |
| sales_person | String |  |
| subscription_date | Instant |  |
| title | String |  |
| unsubscription_date | Instant |  |
| updated_at | Instant |  |

### contact_filter

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | String | FK |
| updated_by | String | FK |
| created_at | Instant |  |
| current_status | String |  |
| folder_id | Long |  |
| name | String |  |
| scope | String |  |
| statement | String |  |
| type | String |  |
| updated_at | Instant |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | String | FK |
| updated_by | String | FK |
| count | Long |  |
| created_at | Instant |  |
| current_status | String |  |
| folder_id | Long |  |
| is_stale | Boolean |  |
| name | String |  |
| type | String |  |
| updated_at | Instant |  |

### event_registration_registrant_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| event_registration_id | Long | PK, FK |
| registrant_id | Long | PK, FK |
| name | String |  |
| type | String |  |
| value | String |  |

### contact_filter_segment_element

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| segment_id | Long | PK, FK |
| contact_filter_id | Long | FK |
| count | Long |  |
| is_included | Boolean |  |
| last_calculated_at | Instant |  |
| type | String |  |

### option_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_by | String | FK |
| updated_by | String | FK |
| created_at | Instant |  |
| current_status | String |  |
| description | String |  |
| name | String |  |
| permissions | Json |  |
| type | String |  |
| updated_at | Instant |  |

### email_hyperlink

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| email_id | Long | PK, FK |
| href | String |  |
| name | String |  |
| type | String |  |

### user_info

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| city | String |  |
| company_display_name | String |  |
| company_url | String |  |
| country | String |  |
| created_at | Instant |  |
| created_by | Long |  |
| department | String |  |
| description | String |  |
| digital_signature_id | String |  |
| email_address | String |  |
| first_name | String |  |
| folder_id | Long |  |
| is_disabled | Boolean |  |
| job_title | String |  |
| last_name | String |  |
| login_name | String |  |
| name | String |  |
| reply_to_address | String |  |
| sender_display_name | String |  |
| sender_email_address | String |  |
| state | String |  |
| type | String |  |
| updated_at | Instant |  |
| updated_by | Long |  |
| zip_code | String |  |

## Relationships

- contact_list_contact(contact_id) → contact(id)
- contact_list_contact(contact_list_id) → contact_list(id)
- campaign(created_by) → user_info(id)
- campaign(updated_by) → user_info(id)
- event_registration_session_field(event_registration_id) → event_registration(id)
- contact_list_segment_element(segment_id) → segment(id)
- contact_list_segment_element(contact_list_id) → contact_list(id)
- contact_list(created_by) → user_info(id)
- contact_list(updated_by) → user_info(id)
- event_registration_session_field_value(event_registration_id) → event_registration(id)
- event_registration_session_field_value(session_id) → event_registration_session(event_registration_id)
- event_registration_session_field_value(session_field_id) → event_registration_session_field(event_registration_id)
- event_registration_session(event_registration_id) → event_registration(id)
- email_form(email_id) → email(id)
- email_form(form_id) → form(id)
- form_submission(form_id) → form(id)
- form_submission(submitted_by_contact_id) → contact(id)
- option(option_list_id) → option_list(id)
- event_registration_registrant(event_registration_id) → event_registration(id)
- event_registration_registrant(contact_id) → contact(id)
- event_registration_registrant(account_id) → account(id)
- event_registration(created_by) → user_info(id)
- event_registration(updated_by) → user_info(id)
- contact_activity(campaign_id) → campaign(id)
- contact_activity(form_id) → form(id)
- contact_activity(contact_id) → contact(id)
- contact_activity(visitor_id) → visitor(id)
- contact_segment(contact_id) → contact(id)
- contact_segment(segment_id) → segment(id)
- visitor(contact_id) → contact(id)
- email(created_by) → user_info(id)
- email(updated_by) → user_info(id)
- event_registration_field(event_registration_id) → event_registration(id)
- contact(created_by) → user_info(id)
- contact(updated_by) → user_info(id)
- contact_filter(created_by) → user_info(id)
- contact_filter(updated_by) → user_info(id)
- segment(created_by) → user_info(id)
- segment(updated_by) → user_info(id)
- event_registration_registrant_field_value(event_registration_id) → event_registration(id)
- event_registration_registrant_field_value(registrant_id) → event_registration_registrant(id)
- contact_filter_segment_element(segment_id) → segment(id)
- contact_filter_segment_element(contact_filter_id) → contact_filter(id)
- option_list(created_by) → user_info(id)
- option_list(updated_by) → user_info(id)
- email_hyperlink(email_id) → email(id)