# Apollo schema ERD

Table and field reference for the Fivetran Apollo connector.

## Table & Field Reference

### deal_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| display_order | Unknown |  |
| is_closed | Unknown |  |
| is_editable | Unknown |  |
| is_meeting_set | Unknown |  |
| is_won | Unknown |  |
| name | Unknown |  |
| opportunity_pipeline_id | Unknown |  |
| probability | Unknown |  |
| salesforce_id | Unknown |  |
| type | Unknown |  |

### deal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| opportunity_stage_id | Unknown | FK |
| owner_id | Unknown | FK |
| actual_close_date | Unknown |  |
| amount | Unknown |  |
| amount_in_team_currency | Unknown |  |
| closed_date | Unknown |  |
| closed_lost_reason | Unknown |  |
| closed_won_reason | Unknown |  |
| created_at | Unknown |  |
| created_by_id | Unknown |  |
| crm_id | Unknown |  |
| crm_owner_id | Unknown |  |
| crm_record_url | Unknown |  |
| currency_iso_code | Unknown |  |
| currency_name | Unknown |  |
| currency_symbol | Unknown |  |
| current_solutions | Unknown |  |
| deal_probability | Unknown |  |
| deal_source | Unknown |  |
| description | Unknown |  |
| exchange_rate_code | Unknown |  |
| exchange_rate_value | Unknown |  |
| existence_level | Unknown |  |
| forecast_category | Unknown |  |
| is_closed | Unknown |  |
| is_won | Unknown |  |
| last_activity_date | Unknown |  |
| manually_updated_forecast | Unknown |  |
| manually_updated_probability | Unknown |  |
| name | Unknown |  |
| next_step | Unknown |  |
| next_step_date | Unknown |  |
| next_step_last_updated_at | Unknown |  |
| opportunity_contact_roles | Json |  |
| opportunity_rule_config_statuses | Json |  |
| probability | Unknown |  |
| salesforce_id | Unknown |  |
| salesforce_owner_id | Unknown |  |
| source | Unknown |  |
| stage_updated_at | Unknown |  |
| team_id | Unknown |  |
| typed_custom_fields | Json |  |

### contact_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| email | Unknown |  |
| email_md_5 | Unknown |  |
| email_needs_tickling | Unknown |  |
| email_sha_256 | Unknown |  |
| email_status | Unknown |  |
| email_status_unavailable_reason | Unknown |  |
| email_true_status | Unknown |  |
| extrapolated_email_confidence | Unknown |  |
| free_domain | Unknown |  |
| position | Unknown |  |
| source | Unknown |  |
| third_party_vendor_name | Unknown |  |
| vendor_validation_status | Json |  |

### contact_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| dialer_flags | Json |  |
| dnc_other_info | Json |  |
| dnc_status | Unknown |  |
| position | Unknown |  |
| raw_number | Unknown |  |
| sanitized_number | Unknown |  |
| source_name | Unknown |  |
| status | Unknown |  |
| third_party_vendor_name | Unknown |  |
| type | Unknown |  |
| vendor_validation_statuses | Json |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| account_phone_note | Unknown |  |
| call_opted_out | Unknown |  |
| campaign_status | Json |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| creator_id | Unknown |  |
| crm_id | Unknown |  |
| crm_owner_id | Unknown |  |
| crm_record_url | Unknown |  |
| custom_field_errors | Json |  |
| direct_dial_enrichment_failed_at | Unknown |  |
| direct_dial_status | Unknown |  |
| email_domain_catchall | Unknown |  |
| email_from_customer | Unknown |  |
| email_source | Unknown |  |
| email_unsubscribed | Unknown |  |
| existence_level | Unknown |  |
| first_name | Unknown |  |
| has_email_arcgate_request | Unknown |  |
| has_pending_email_arcgate_request | Unknown |  |
| headline | Unknown |  |
| hubspot_company_id | Unknown |  |
| hubspot_vid | Unknown |  |
| intent_strength | Unknown |  |
| is_likely_to_engage | Unknown |  |
| job_change_event_charged | Unknown |  |
| job_change_event_contact_id | Unknown |  |
| job_change_event_contact_name | Unknown |  |
| job_change_event_created_at | Unknown |  |
| job_change_event_id | Unknown |  |
| job_change_event_is_dismissed | Unknown |  |
| job_change_event_is_processed | Unknown |  |
| job_change_event_new_organization_id | Unknown |  |
| job_change_event_new_organization_name | Unknown |  |
| job_change_event_old_account_id | Unknown |  |
| job_change_event_old_account_name | Unknown |  |
| job_change_event_old_organization_domain | Unknown |  |
| job_change_event_old_organization_id | Unknown |  |
| job_change_event_old_organization_name | Unknown |  |
| job_change_event_old_title | Unknown |  |
| job_change_event_person_id | Unknown |  |
| job_change_event_title | Unknown |  |
| label_ids | Json |  |
| last_activity_date | Unknown |  |
| last_name | Unknown |  |
| linkedin_uid | Unknown |  |
| linkedin_url | Unknown |  |
| merged_crm_ids | Json |  |
| name | Unknown |  |
| organization_alexa_ranking | Unknown |  |
| organization_angellist_url | Unknown |  |
| organization_blog_url | Unknown |  |
| organization_crunchbase_url | Unknown |  |
| organization_facebook_url | Unknown |  |
| organization_founded_year | Unknown |  |
| organization_id | Unknown |  |
| organization_language | Json |  |
| organization_linkedin_uid | Unknown |  |
| organization_linkedin_url | Unknown |  |
| organization_logo_url | Unknown |  |
| organization_name | Unknown |  |
| organization_phone | Unknown |  |
| organization_primary_domain | Unknown |  |
| organization_primary_phone | Json |  |
| organization_primary_phone_number | Unknown |  |
| organization_primary_phone_sanitized_number | Unknown |  |
| organization_primary_phone_source | Unknown |  |
| organization_publicly_traded_exchange | Unknown |  |
| organization_publicly_traded_symbol | Unknown |  |
| organization_sanitized_phone | Unknown |  |
| organization_twitter_url | Unknown |  |
| organization_website_url | Unknown |  |
| original_source | Unknown |  |
| owner_id | Unknown |  |
| person_deleted | Unknown |  |
| person_id | Unknown |  |
| photo_url | Unknown |  |
| present_raw_address | Unknown |  |
| queued_for_crm_push | Unknown |  |
| roles | Json |  |
| rule_config_status | Json |  |
| salesforce_account_id | Unknown |  |
| salesforce_contact_id | Unknown |  |
| salesforce_id | Unknown |  |
| salesforce_lead_id | Unknown |  |
| salesforce_record_url | Unknown |  |
| sanitized_phone | Unknown |  |
| show_intent | Unknown |  |
| source | Unknown |  |
| source_display_name | Unknown |  |
| stage_id | Unknown |  |
| state | Unknown |  |
| suggested_from_rule_engine_config_id | Unknown |  |
| time_zone | Unknown |  |
| title | Unknown |  |
| twitter_url | Unknown |  |
| typed_custom_fields | Json |  |
| updated_at | Instant |  |
| updated_email_true_status | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_account_id | Unknown | FK |
| account_playbook_status | Json |  |
| account_rule_config_status | Json |  |
| account_stage_id | Unknown |  |
| alexa_ranking | Unknown |  |
| angellist_url | Unknown |  |
| blog_url | Unknown |  |
| city | Unknown |  |
| contact_campaign_status_tally | Json |  |
| contact_emailer_campaign_ids | Json |  |
| country | Unknown |  |
| created_at | Instant |  |
| creator_id | Unknown |  |
| crm_owner_id | Unknown |  |
| crm_record_url | Unknown |  |
| crunchbase_url | Unknown |  |
| custom_field_error | Json |  |
| domain | Unknown |  |
| existence_level | Unknown |  |
| facebook_url | Unknown |  |
| founded_year | Unknown |  |
| has_intent_signal_account | Unknown |  |
| hubspot_id | Unknown |  |
| intent_signal_account | Unknown |  |
| intent_strength | Unknown |  |
| label_ids | Json |  |
| languages | Json |  |
| last_activity_date | Unknown |  |
| linkedin_uid | Unknown |  |
| linkedin_url | Unknown |  |
| logo_url | Unknown |  |
| market_cap | Unknown |  |
| modality | Unknown |  |
| name | Unknown |  |
| organization_city | Unknown |  |
| organization_country | Unknown |  |
| organization_id | Unknown |  |
| organization_postal_code | Unknown |  |
| organization_raw_address | Unknown |  |
| organization_state | Unknown |  |
| organization_street_address | Unknown |  |
| original_source | Unknown |  |
| owner_id | Unknown |  |
| phone | Unknown |  |
| phone_status | Unknown |  |
| postal_code | Unknown |  |
| primary_domain | Unknown |  |
| primary_phone_number | Unknown |  |
| primary_phone_sanitized_number | Unknown |  |
| primary_phone_source | Unknown |  |
| publicly_traded_exchange | Unknown |  |
| publicly_traded_symbol | Unknown |  |
| raw_address | Unknown |  |
| salesforce_id | Unknown |  |
| salesforce_record_url | Unknown |  |
| sanitized_phone | Unknown |  |
| show_intent | Unknown |  |
| source | Unknown |  |
| source_display_name | Unknown |  |
| state | Unknown |  |
| street_address | Unknown |  |
| suggest_location_enrichment | Unknown |  |
| team_id | Unknown |  |
| twitter_url | Unknown |  |
| typed_custom_field | Json |  |
| website_url | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ai_credit_limit | Unknown |  |
| apollo_everywhere_search_count | Unknown |  |
| assistant_setting_deal_size_metric | Unknown |  |
| assistant_setting_id | Unknown |  |
| assistant_setting_inactive_account_stage_id | Json |  |
| assistant_setting_inactive_contact_stage_id | Json |  |
| assistant_setting_insight_deal_size_signal | Json |  |
| assistant_setting_insight_sale_cycle_signal | Json |  |
| assistant_setting_insight_win_rate_signal | Json |  |
| assistant_setting_is_persona_recommendation_requested | Unknown |  |
| assistant_setting_job_posting_location | Json |  |
| assistant_setting_job_posting_title | Json |  |
| assistant_setting_latest_funding_day | Unknown |  |
| assistant_setting_max_num_active_account | Unknown |  |
| assistant_setting_max_people_in_sequence_per_account | Unknown |  |
| assistant_setting_num_inactive_days_to_re_engage | Unknown |  |
| assistant_setting_persona_id | Json |  |
| assistant_setting_should_show_persona_banner | Unknown |  |
| assistant_setting_success_case_account_stage_id | Json |  |
| assistant_setting_team_id | Unknown |  |
| assistant_setting_technology_uid | Json |  |
| assistant_setting_territory_company_size_range | Json |  |
| assistant_setting_territory_location | Json |  |
| assistant_setting_territory_location_override | Unknown |  |
| assistant_setting_territory_person_location | Json |  |
| bridge_call | Unknown |  |
| bridge_incoming_call | Unknown |  |
| bridge_incoming_phone_number | Unknown |  |
| bridge_phone_number | Unknown |  |
| chrome_extension_auto_match_salesforce_opportunity | Unknown |  |
| chrome_extension_downloaded | Unknown |  |
| chrome_extension_enable_everywhere | Unknown |  |
| chrome_extension_enable_google_calendar | Unknown |  |
| chrome_extension_enable_hubspot | Unknown |  |
| chrome_extension_enabled_feature | Json |  |
| chrome_extension_everywhere_icon_horizontal_position | Unknown |  |
| chrome_extension_everywhere_icon_vertical_position_in_vh | Unknown |  |
| chrome_extension_exclude_from_website | Json |  |
| chrome_extension_gmail_enable_crm_sidebar | Unknown |  |
| chrome_extension_gmail_enable_email_tool | Unknown |  |
| connected_to_slack | Unknown |  |
| conversation_is_private | Unknown |  |
| created_at | Unknown |  |
| credit_limit | Unknown |  |
| crm_email | Unknown |  |
| crm_requested_to_integrate | Unknown |  |
| current_email_verified | Unknown |  |
| daily_data_request_email | Unknown |  |
| daily_task_email | Unknown |  |
| data_request_email | Unknown |  |
| default_account_overview_layout_id | Unknown |  |
| default_chrome_extension_enable_reminder | Unknown |  |
| default_chrome_extension_log_email_send_to_hubspot | Unknown |  |
| default_chrome_extension_log_email_send_to_salesforce | Unknown |  |
| default_cockpit_layout | Unknown |  |
| default_contact_overview_layout_id | Unknown |  |
| default_crm_home_overview_layout_id | Unknown |  |
| default_gen_pipe_home_overview_layout_id | Unknown |  |
| default_home_overview_layout_id | Unknown |  |
| default_opportunity_overview_layout_id | Unknown |  |
| default_organization_overview_layout_id | Unknown |  |
| default_person_overview_layout_id | Unknown |  |
| default_use_local_number | Unknown |  |
| default_win_close_home_overview_layout_id | Unknown |  |
| deleted | Unknown |  |
| direct_dial_credit_limit | Unknown |  |
| disable_email_linking | Unknown |  |
| dismiss_new_team_suggestion | Unknown |  |
| email | Unknown |  |
| email_oauth_signin_only | Unknown |  |
| enable_click_tracking | Unknown |  |
| enable_desktop_notification | Unknown |  |
| enable_gmail_desktop_notification | Unknown |  |
| enable_one_click_unsubscribe | Unknown |  |
| enable_open_tracking | Unknown |  |
| export_credit_limit | Unknown |  |
| fields_fully_loaded | Unknown |  |
| first_name | Unknown |  |
| free_data_credits_email | Unknown |  |
| has_conference_account | Unknown |  |
| has_hidden_onboarding | Unknown |  |
| has_invited_user | Unknown |  |
| has_uploaded_csv | Unknown |  |
| has_used_enrichment | Unknown |  |
| last_name | Unknown |  |
| linked_bot_conference_account | Unknown |  |
| linked_bot_conference_account_platforms | Json |  |
| linked_crm_name | Unknown |  |
| linked_hubspot | Unknown |  |
| linked_salesforce | Unknown |  |
| linked_salesloft | Unknown |  |
| linked_zoom_conference_account | Unknown |  |
| name | Unknown |  |
| notification_last_created_at | Unknown |  |
| notification_last_read_at | Unknown |  |
| opt_out_html_template | Unknown |  |
| password_needs_reset | Unknown |  |
| permission_set_id | Unknown |  |
| prospect_territory_ids | Json |  |
| record_call | Unknown |  |
| referral_code | Unknown |  |
| request_email_change_to | Unknown |  |
| salesforce_account | Unknown |  |
| salesforce_id | Unknown |  |
| salesforce_instance_url | Unknown |  |
| self_identified_persona | Unknown |  |
| should_include_unsubscribe_link | Unknown |  |
| show_chrome_extension_buying_intent_promo | Unknown |  |
| show_deals_detail_page_updates_modal | Unknown |  |
| subteam_ids | Json |  |
| sync_crm_id | Unknown |  |
| sync_salesforce_id | Unknown |  |
| team_id | Unknown |  |
| territory_is_active | Unknown |  |
| title | Unknown |  |
| toggled_on_territory_ids | Json |  |
| triggered_referral_campaigns | Json |  |
| typed_custom_fields | Json |  |
| zp_contact_id | Unknown |  |
| zp_is_super_analytics_user | Unknown |  |

## Relationships

- deal(owner_id) → users(id)
- deal(opportunity_stage_id) → deal_stage(id)
- deal(account_id) → account(id)
- contact_email(contact_id) → contact(id)
- contact_phone_number(contact_id) → contact(id)
- contact(account_id) → account(id)
- account(parent_account_id) → account(id)