Apollo

Explore the interactive ERD

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	PKFK
`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	PKFK
`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