Outreach

Explore the interactive ERD

Table & Field Reference

account

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_owner_id`	Long	FK
`relationship_updater_id`	Long	FK
`buyer_intent_score`	Float
`company_type`	String
`created_at`	Instant
`custom_id`	String
`description`	String
`domain`	String
`external_source`	String
`followers`	Int
`founded_at`	Instant
`industry`	String
`linked_in_employees`	Int
`linked_in_url`	String
`locality`	String
`name`	String
`named`	Boolean
`natural_name`	String
`number_of_employees`	Int
`sharing_team_id`	String
`touched_at`	Instant
`type`	String
`updated_at`	Instant
`website_url`	String

template_cc_recipient

Column	Type	Keys
`email`	String	PK
`template_id`	Long	PKFK

active_step_task

Column	Type	Keys
`sequence_state_id`	Long	PKFK
`task_id`	Long	PKFK

recipient

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`email_hash`	String
`recipient_type`	String
`type`	String
`updated_at`	Instant
`value`	String

email_address

Column	Type	Keys
`id`	Long	PK
`relationship_prospect_id`	Long	FK
`created_at`	Instant
`email`	String
`email_type`	String
`order`	Int
`status`	String
`status_changed_at`	Instant
`type`	String
`unsubscribed_at`	Instant
`updated_at`	Instant

duty

Column	Type	Keys
`id`	Long	PK
`duty_type`	String
`symbolic_name`	String
`type`	String
`updated_at`	Instant

users

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_mailbox_id`	Long	FK
`relationship_profile_id`	Long	FK
`relationship_role_id`	Long	FK
`relationship_updater_id`	Long	FK
`accounts_view_id`	Int
`activity_notifications_disabled`	Boolean
`bounce_warning_email_enabled`	Boolean
`bridge_phone`	String
`bridge_phone_extension`	String
`calls_view_id`	Int
`controlled_tab_default`	String
`created_at`	Instant
`current_sign_in_at`	Instant
`daily_digest_email_enabled`	Boolean
`default_ruleset_id`	Int
`email`	String
`enable_voice_recordings`	Boolean
`first_name`	String
`inbound_bridge_phone`	String
`inbound_bridge_phone_extension`	String
`inbound_call_behavior`	String
`inbound_phone_type`	String
`inbound_voicemail_custom_message_text`	String
`inbound_voicemail_message_text_voice`	String
`inbound_voicemail_prompt_type`	String
`kaia_recordings_view_id`	Int
`keep_bridge_phone_connected`	Boolean
`last_name`	String
`last_sign_in_at`	Instant
`locked`	Boolean
`mailbox_error_email_enabled`	Boolean
`meeting_engagement_notification_enabled`	Boolean
`name`	String
`notifications_enabled`	Boolean
`oce_click_to_dial_everywhere`	Boolean
`oce_gmail_toolbar`	Boolean
`oce_gmail_tracking_state`	String
`oce_salesforce_email_decorating`	Boolean
`oce_salesforce_phone_decorating`	Boolean
`oce_salesforce_phoned_decorating`	Boolean
`oce_universal_task_flow`	Boolean
`oce_window_mode`	Boolean
`opportunities_view_id`	Int
`password_expires_at`	Instant
`phone_country_code`	String
`phone_number`	String
`phone_type`	String
`plugin_alert_notification_enabled`	Boolean
`preferred_voice_region`	String
`prefers_local_presence`	Boolean
`primary_timezone`	String
`prospects_view_id`	Int
`reports_team_perf_view_id`	Int
`reports_view_id`	Int
`scim_external_id`	String
`scim_source`	String
`secondary_timezone`	String
`sender_notifications_excluded`	Boolean
`tasks_view_id`	Int
`teams_view_id`	Int
`tertiary_timezone`	String
`texting_email_notifications`	Boolean
`title`	String
`type`	String
`unknown_reply_email_enabled`	Boolean
`updated_at`	Instant
`user_guid`	String
`username`	String
`users_view_id`	Int
`voicemail_notification_enabled`	Boolean
`weekly_digest_email_enabled`	Boolean

mailing

Column	Type	Keys
`id`	Long	PK
`relationship_follow_up_sequence_id`	Long	FK
`relationship_mailbox_id`	Long	FK
`relationship_opportunity_id`	Long	FK
`relationship_prospect_id`	Long	FK
`relationship_sequence_id`	Long	FK
`relationship_sequence_state_id`	Long	FK
`relationship_sequence_step_id`	Long	FK
`relationship_task_id`	Long	FK
`relationship_template_id`	Long	FK
`relationship_user_id`	Long	FK
`body_html`	String
`bounced_at`	Instant
`click_count`	Int
`clicked_at`	Instant
`created_at`	Instant
`delivered_at`	Instant
`error_backtrace`	String
`error_reason`	String
`follow_up_task_scheduled_at`	Instant
`follow_up_task_type`	String
`mailbox_address`	String
`mailing_type`	String
`marked_as_spam_at`	Instant
`message_id`	String
`notify_thread_condition`	String
`notify_thread_scheduled_at`	Instant
`notify_thread_status`	String
`open_count`	Int
`opened_at`	Instant
`override_safety_settings`	Boolean
`replied_at`	Instant
`retry_at`	Instant
`retry_count`	Int
`retry_interval`	Int
`scheduled_at`	Instant
`state`	String
`state_changed_at`	Instant
`subject`	String
`track_links`	Boolean
`track_opens`	Boolean
`type`	String
`unsubscribed_at`	Instant
`updated_at`	Instant

template_tag

Column	Type	Keys
`tag_name`	String	PK
`template_id`	Long	PKFK

prospect

Column	Type	Keys
`id`	Long	PK
`relationship_account_id`	Long	FK
`relationship_creator_id`	Long	FK
`relationship_owner_id`	Long	FK
`relationship_persona_id`	Long	FK
`relationship_stage_id`	Long	FK
`relationship_updater_id`	Long	FK
`added_at`	Instant
`address_city`	String
`address_country`	String
`address_state`	String
`address_street`	String
`address_street_2`	String
`address_zip`	String
`angel_list_url`	String
`available_at`	Instant
`call_opted_out`	Boolean
`calls_opt_status`	String
`calls_opted_at`	Instant
`campaign_name`	String
`click_count`	Int
`company`	String
`created_at`	Instant
`date_of_birth`	Instant
`degree`	String
`email_opted_out`	Boolean
`emails_opt_status`	String
`emails_opted_at`	Instant
`engaged_at`	Instant
`engaged_score`	Float
`event_name`	String
`external_id`	String
`external_owner`	String
`external_source`	String
`facebook_url`	String
`first_name`	String
`gender`	String
`github_url`	String
`github_username`	String
`google_plus_url`	String
`graduation_date`	Instant
`job_start_date`	Instant
`last_name`	String
`linked_in_connections`	Int
`linked_in_employees`	Int
`linked_in_id`	String
`linked_in_slug`	String
`linked_in_url`	String
`middle_name`	String
`name`	String
`nickname`	String
`occupation`	String
`open_count`	Int
`opted_out`	Boolean
`opted_out_at`	Instant
`personal_note_1`	String
`personal_note_2`	String
`preferred_contact`	String
`quora_url`	String
`region`	String
`reply_count`	Int
`school`	String
`score`	Float
`sharing_team_id`	String
`source`	String
`specialties`	String
`stack_overflow_id`	String
`stack_overflow_url`	String
`time_zone`	String
`time_zone_iana`	String
`time_zone_inferred`	String
`title`	String
`touched_at`	Instant
`trashed_at`	Instant
`twitter_url`	String
`twitter_username`	String
`type`	String
`updated_at`	Instant
`website_url_1`	String
`website_url_2`	String
`website_url_3`	String

data_connection

Column	Type	Keys
`id`	String	PK
`parent_id`	Long	PK
`parent_type`	String	PK
`type`	String	PK
`connection`	String
`url`	String

prospect_work_phone

Column	Type	Keys
`phone_number`	String	PK
`prospect_id`	Long	PKFK

sequence_state

Column	Type	Keys
`id`	Long	PK
`relationship_account_id`	Long	FK
`relationship_creator_id`	Long	FK
`relationship_mailbox_id`	Long	FK
`relationship_opportunity_id`	Long	FK
`relationship_prospect_id`	Long	FK
`relationship_sequence_id`	Long	FK
`relationship_sequence_step_id`	Long	FK
`active_at`	Instant
`bounce_count`	Int
`call_completed_at`	Instant
`click_count`	Int
`created_at`	Instant
`deliver_count`	Int
`error_reason`	String
`failure_count`	Int
`negative_reply_count`	Int
`neutral_reply_count`	Int
`open_count`	Int
`opt_out_count`	Int
`pause_reason`	String
`positive_reply_count`	Int
`replied_at`	Instant
`reply_count`	Int
`schedule_count`	Int
`state`	String
`state_changed_at`	Instant
`type`	String
`updated_at`	Instant

sequence_step

Column	Type	Keys
`id`	Long	PK
`relationship_call_purpose_id`	Long	FK
`relationship_creator_id`	Long	FK
`relationship_sequence_id`	Long	FK
`relationship_task_priority_id`	Long	FK
`relationship_updater_id`	Long	FK
`bounce_count`	Int
`click_count`	Int
`created_at`	Instant
`date`	Instant
`deliver_count`	Int
`display_name`	String
`failure_count`	Int
`interval`	Int
`negative_reply_count`	Int
`neutral_reply_count`	Int
`open_count`	Int
`opt_out_count`	Int
`order`	Int
`positive_reply_count`	Int
`reply_count`	Int
`schedule_count`	Int
`step_type`	String
`task_autoskip_delay`	Int
`task_note`	String
`type`	String
`updated_at`	Instant

prospect_email

Column	Type	Keys
`email`	String	PK
`prospect_id`	Long	PKFK

task_priority

Column	Type	Keys
`id`	Long	PK
`color`	Long
`created_at`	Instant
`name`	String
`type`	String
`updated_at`	Instant
`weight`	Int

template_to_recipient

Column	Type	Keys
`email`	String	PK
`template_id`	Long	PKFK

account_tag

Column	Type	Keys
`tag_name`	String	PK
`account_id`	Long	PKFK

sequence_template

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_sequence_step_id`	Long	FK
`relationship_template_id`	Long	FK
`relationship_updater_id`	Long	FK
`bounce_count`	Int
`click_count`	Int
`created_at`	Instant
`deliver_count`	Int
`enabled`	Boolean
`enabled_at`	Instant
`failure_count`	Int
`is_reply`	Boolean
`negative_reply_count`	Int
`neutral_reply_count`	Int
`open_count`	Int
`opt_out_count`	Int
`positive_reply_count`	Int
`reply_count`	Int
`schedule_count`	Int
`type`	String
`updated_at`	Instant

mailing_recipient

Column	Type	Keys
`mailing_id`	Long	PKFK
`recipient_id`	Long	PKFK

user_duty

Column	Type	Keys
`id`	Long	PK
`user_id`	Long	PKFK
`duty_type`	String
`name`	String

user_email_recipients

Column	Type	Keys
`recipient_id`	Long	PKFK
`user_id`	Long	PKFK

user_team

Column	Type	Keys
`team_id`	Long	PKFK
`user_id`	Long	PKFK

template_bcc_recipient

Column	Type	Keys
`email`	String	PK
`template_id`	Long	PKFK

sequence_tag

Column	Type	Keys
`tag_name`	String	PK
`sequence_id`	Long	PKFK

compliance_request

Column	Type	Keys
`id`	Long	PK
`relationship_requester_id`	Long	FK
`batch_compliance_request_uuid`	String
`created_at`	Instant
`object_type`	String
`pii`	Json
`request_object_id`	String
`request_type`	String
`requester_id`	Int
`state`	String
`type`	String
`updated_at`	Instant
`uuid`	String

call_purpose

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`created_at`	Instant
`name`	String
`order`	Int
`type`	String
`updated_at`	Instant

prospect_voip_phone

Column	Type	Keys
`phone_number`	String	PK
`prospect_id`	Long	PKFK

ruleset

Column	Type	Keys
`id`	Long	PK
`relationship_bounced_stage_id`	Long	FK
`relationship_call_task_priority_from_clicks_id`	Long	FK
`relationship_call_task_priority_from_opens_id`	Long	FK
`relationship_call_task_priority_id`	Long	FK
`relationship_completed_stage_id`	Long	FK
`relationship_delivered_stage_id`	Long	FK
`relationship_finished_stage_id`	Long	FK
`relationship_opted_out_stage_id`	Long	FK
`relationship_owner_id`	Long	FK
`relationship_replied_stage_id`	Long	FK
`relationship_started_stage_id`	Long	FK
`apply_completed_stage_in`	Int
`auto_resume_ooto_prospects`	Boolean
`auto_resume_ooto_prospects_expires_in`	Int
`auto_resume_ooto_prospects_in`	Int
`call_opt_out_action`	String
`clicks_needed_before_call_task_created`	Int
`created_at`	Instant
`email_opt_out_action`	String
`include_unsubscribe_links`	Boolean
`meeting_booked_action`	String
`minimum_prospect_touched_interval`	Int
`name`	String
`ooto_auto_extraction_enabled`	Boolean
`opens_needed_before_call_task_created`	Int
`permit_duplicate_prospects`	String
`sequence_exclusivity`	String
`sms_opt_out_action`	String
`sms_received_action`	String
`step_overrides_enabled`	Boolean
`type`	String
`updated_at`	Instant

profile

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`is_admin`	Boolean
`name`	String
`special_id`	String
`type`	String
`updated_at`	Instant

content_category_membership

Column	Type	Keys
`id`	Long	PK
`relationship_content_category_id`	Long	FK
`relationship_creator_id`	Long	FK
`created_at`	Instant
`relationship_content_id`	Long
`relationship_content_type`	String
`type`	String
`updated_at`	Instant

phone_number

Column	Type	Keys
`id`	Long	PK
`relationship_prospect_id`	Long	FK
`country_code`	String
`created_at`	Instant
`extension`	String
`number`	String
`order`	Long
`phone_type`	String
`raw_number`	String
`status`	String
`status_changed_at`	Instant
`type`	String
`updated_at`	Instant

mailbox

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_updater_id`	Long	FK
`relationship_user_id`	Long	FK
`auth_id`	Int
`created_at`	Instant
`editable`	Boolean
`email`	String
`email_hash`	String
`email_provider`	String
`email_signature`	String
`ews_endpoint`	String
`ews_ssl_verify_mode`	Int
`exchange_version`	String
`imap_host`	String
`imap_port`	Int
`imap_ssl`	Boolean
`max_emails_per_day`	Int
`max_mailings_per_day`	Int
`max_mailings_per_week`	Int
`opt_out_message`	String
`opt_out_signature`	String
`password`	String
`prospect_email_exclusions`	String
`provider_id`	Int
`provider_type`	String
`send_disabled`	Boolean
`send_errored_at`	Instant
`send_max_retries`	Int
`send_method`	String
`send_period`	Int
`send_requires_sync`	Boolean
`send_success_at`	Instant
`send_threshold`	Int
`sendgrid_api_key`	String
`sendgrid_webhook_url`	String
`smtp_host`	String
`smtp_password`	String
`smtp_port`	Int
`smtp_ssl`	Boolean
`smtp_username`	String
`sync_active_frequency`	Int
`sync_disabled`	Boolean
`sync_errored_at`	Instant
`sync_finished_at`	Instant
`sync_method`	String
`sync_outreach_folder`	Boolean
`sync_passive_frequency`	Int
`sync_success_at`	Instant
`type`	String
`updated_at`	Instant
`user_id`	Int
`username`	String
`validate_send`	Boolean
`validate_sync`	Boolean

sequence

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_owner_id`	Long	FK
`relationship_ruleset_id`	Long	FK
`relationship_updater_id`	Long	FK
`automation_percentage`	Double
`bounce_count`	Int
`click_count`	Int
`created_at`	Instant
`deliver_count`	Int
`description`	String
`duration_in_days`	Int
`enabled`	Boolean
`enabled_at`	Instant
`failure_count`	Int
`finish_on_reply`	Boolean
`last_used_at`	Instant
`locked`	Boolean
`locked_at`	Instant
`max_activations`	Int
`name`	String
`negative_reply_count`	Int
`neutral_reply_count`	Int
`num_contacted_prospects`	Int
`num_replied_prospects`	Int
`open_count`	Int
`opt_out_count`	Int
`positive_reply_count`	Int
`primary_reply_action`	String
`primary_reply_pause_duration`	Int
`reply_count`	Int
`schedule_count`	Int
`schedule_interval_type`	String
`secondary_reply_action`	String
`secondary_reply_pause_duration`	Int
`sequence_step_count`	Int
`sequence_type`	String
`share_type`	String
`throttle_capacity`	Int
`throttle_max_adds_per_day`	Int
`throttle_paused`	Boolean
`throttle_paused_at`	Instant
`transactional`	Boolean
`type`	String
`updated_at`	Instant

content_category

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`allow_sequences`	Boolean
`allow_snippets`	Boolean
`allow_templates`	Boolean
`color`	String
`created_at`	Instant
`name`	String
`type`	String
`updated_at`	Instant

persona

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`description`	String
`name`	String
`type`	String
`updated_at`	Instant

prospect_mobile_phone

Column	Type	Keys
`phone_number`	String	PK
`prospect_id`	Long	PKFK

opportunity_prospect_role

Column	Type	Keys
`id`	Long	PK
`relationship_opportunity_id`	Long	FK
`relationship_prospect_id`	Long	FK
`created_at`	Instant
`primary`	Boolean
`role`	String
`type`	String
`updated_at`	Instant

stage

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_updater_id`	Long	FK
`color`	String
`created_at`	Instant
`name`	String
`order`	Int
`type`	String
`updated_at`	Instant

custom_field

Column	Type	Keys
`id`	String
`properties`	Json
`type`	String

prospect_other_phone

Column	Type	Keys
`phone_number`	String	PK
`prospect_id`	Long	PKFK

task

Column	Type	Keys
`id`	Long	PK
`relationship_account_id`	Long	FK
`relationship_call_id`	Long	FK
`relationship_completer_id`	Long	FK
`relationship_creator_id`	Long	FK
`relationship_mailing_id`	Long	FK
`relationship_opportunity_id`	Long	FK
`relationship_owner_id`	Long	FK
`relationship_prospect_id`	Long	FK
`relationship_sequence_id`	Long	FK
`relationship_sequence_state_id`	Long	FK
`relationship_sequence_step_id`	Long	FK
`relationship_sequence_template_id`	Long	FK
`relationship_task_priority_id`	Long	FK
`relationship_template_id`	Long	FK
`action`	String
`added_at`	Instant
`compiled_sequence_template_html`	String
`completed`	Boolean
`completed_at`	Instant
`created_at`	Instant
`due_at`	Instant
`note`	String
`relationship_subject_id`	Long
`relationship_subject_type`	String
`scheduled_at`	Instant
`state`	String
`state_changed_at`	Instant
`task_type`	String
`type`	String
`updated_at`	Instant

opportunity_stage

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`color`	String
`created_at`	Instant
`is_closed`	Boolean
`name`	String
`order`	Int
`type`	String
`updated_at`	Instant

prospect_home_phone

Column	Type	Keys
`phone_number`	String	PK
`prospect_id`	Long	PKFK

snippet_tag

Column	Type	Keys
`tag_name`	String	PK
`snippet_id`	Long	PKFK

call_disposition

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`created_at`	Instant
`name`	String
`order`	Int
`outcome`	String
`type`	String
`updated_at`	Instant

call_tag

Column	Type	Keys
`tag_name`	String	PK
`call_id`	Long	PKFK

favorite

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_user_id`	Long	FK
`created_at`	Instant
`target_type`	String
`type`	String
`updated_at`	Instant

role

Column	Type	Keys
`id`	Long	PK
`relationship_parent_role_id`	Long	FK
`created_at`	Instant
`name`	String
`type`	String
`updated_at`	Instant

mail_alias

Column	Type	Keys
`id`	Long	PK
`relationship_mailbox_id`	Long	FK
`can_send`	Boolean
`created_at`	Instant
`email`	String
`email_hash`	String
`type`	String
`updated_at`	Instant

template

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_owner_id`	Long	FK
`relationship_updater_id`	Long	FK
`archived`	Boolean
`archived_at`	Instant
`body_html`	String
`body_text`	String
`bounce_count`	Int
`click_count`	Int
`created_at`	Instant
`deliver_count`	Int
`failure_count`	Int
`last_used_at`	Instant
`name`	String
`negative_reply_count`	Int
`neutral_reply_count`	Int
`open_count`	Int
`opt_out_count`	Int
`positive_reply_count`	Int
`reply_count`	Int
`schedule_count`	Int
`share_type`	String
`subject`	String
`track_links`	Boolean
`track_opens`	Boolean
`type`	String
`updated_at`	Instant

opportunity_tag

Column	Type	Keys
`tag_name`	String	PK
`opportunity_id`	Long	PKFK

event

Column	Type	Keys
`id`	Long	PK
`relationship_account_id`	Long	FK
`relationship_call_id`	Long	FK
`relationship_mailing_id`	Long	FK
`relationship_opportunity_id`	Long	FK
`relationship_prospect_id`	Long	FK
`relationship_task_id`	Long	FK
`relationship_user_id`	Long	FK
`body`	String
`created_at`	Instant
`event_at`	Instant
`external_url`	String
`name`	String
`payload`	Json
`request_city`	String
`request_device`	String
`request_host`	String
`request_proxied`	Boolean
`request_region`	String
`type`	String
`updated_at`	Instant

snippet

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_owner_id`	Long	FK
`relationship_updater_id`	Long	FK
`body_html`	String
`body_text`	String
`created_at`	Instant
`name`	String
`share_type`	String
`type`	String
`updated_at`	Instant

content_category_ownership

Column	Type	Keys
`id`	Long	PK
`relationship_content_category_id`	Long	FK
`relationship_creator_id`	Long	FK
`relationship_owner_id`	Long	FK
`created_at`	Instant
`type`	String
`updated_at`	Instant

prospect_tag

Column	Type	Keys
`tag_name`	String	PK
`prospect_id`	Long	PKFK

prospect_favorite

Column	Type	Keys
`favorite_id`	Long	PKFK
`prospect_id`	Long	PKFK

call

Column	Type	Keys
`id`	Long	PK
`relationship_call_disposition_id`	Long	FK
`relationship_call_purpose_id`	Long	FK
`relationship_opportunity_id`	Long	FK
`relationship_phone_number_id`	Long	FK
`relationship_prospect_id`	Long	FK
`relationship_sequence_id`	Long	FK
`relationship_sequence_state_id`	Long	FK
`relationship_sequence_step_id`	Long	FK
`relationship_task_id`	Long	FK
`relationship_user_id`	Long	FK
`answered_at`	Instant
`completed_at`	Instant
`created_at`	Instant
`dialed_at`	Instant
`direction`	String
`external_vendor`	String
`from`	String
`note`	String
`outcome`	String
`recording_url`	String
`returned_at`	Instant
`sequence_action`	String
`should_record_call`	Boolean
`state`	String
`state_changed_at`	Instant
`to`	String
`type`	String
`uid`	String
`updated_at`	Instant
`user_call_type`	String
`vendor_call_id`	String
`voicemail_recording_url`	String

opportunity

Column	Type	Keys
`id`	Long	PK
`relationship_account_id`	Long	FK
`relationship_creator_id`	Long	FK
`relationship_opportunity_stage_id`	Long	FK
`relationship_owner_id`	Long	FK
`relationship_stage_id`	Long	FK
`relationship_updater_id`	Long	FK
`amount`	Int
`close_date`	Instant
`created_at`	Instant
`currency_type`	String
`description`	String
`external_created_at`	Instant
`map_link`	String
`map_next_steps`	String
`map_status`	String
`name`	String
`next_step`	String
`opportunity_type`	String
`probability`	Int
`prospecting_rep_id`	String
`sharing_team_id`	String
`touched_at`	Instant
`type`	String
`updated_at`	Instant

mailing_reference

Column	Type	Keys
`reference`	String	PK
`mailing_id`	Long	PKFK

active_step_mailing

Column	Type	Keys
`mailing_id`	Long	PKFK
`sequence_state_id`	Long	PKFK

team

Column	Type	Keys
`id`	Long	PK
`relationship_creator_id`	Long	FK
`relationship_updater_id`	Long	FK
`color`	String
`created_at`	Instant
`name`	String
`scim_external_id`	String
`scim_source`	String
`type`	String
`updated_at`	Instant