# Freshsales schema ERD

Table and field reference for the Fivetran Freshsales connector.

## Table & Field Reference

### contact_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| destroy | Unknown |  |
| is_primary | Unknown |  |
| label | Unknown |  |
| value | Unknown |  |

### contact_system_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| system_tag_name | Unknown |  |

### contact_team_user

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| team_user_id | Unknown | PK, FK |

### contact_sales_account

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| is_primary | Unknown |  |
| partial | Unknown |  |

### contact_appointment

| Column | Type | Keys |
| --- | --- | --- |
| apponitment_id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| appointment_id | Unknown | FK |

### contact_lead_source

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| lead_source_id | Unknown | PK, FK |

### contact_territory

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| territory_id | Unknown | PK, FK |

### contact_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |

### contact_task

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### contact_note

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| note_id | Unknown | PK, FK |

### contact_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| tag_name | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_view_id | Unknown | FK |
| creater_id | Unknown | FK |
| active_sales_sequence | Unknown |  |
| address | Unknown |  |
| avatar | Unknown |  |
| city | Unknown |  |
| completed_sales_sequence | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| customer_fit | Unknown |  |
| department | Unknown |  |
| display_name | Unknown |  |
| do_not_disturb | Unknown |  |
| email | Unknown |  |
| email_status | Unknown |  |
| external_id | Unknown |  |
| facebook | Unknown |  |
| first_campaign | Unknown |  |
| first_medium | Unknown |  |
| first_name | Unknown |  |
| first_seen_chat | Unknown |  |
| first_source | Unknown |  |
| has_authority | Unknown |  |
| is_deleted | Unknown |  |
| job_title | Unknown |  |
| keyword | Unknown |  |
| last_assigned_at | Unknown |  |
| last_campaign | Unknown |  |
| last_contacted | Unknown |  |
| last_contacted_mode | Unknown |  |
| last_contacted_sales_activity_mode | Unknown |  |
| last_contacted_via_chat | Unknown |  |
| last_contacted_via_sales_activity | Unknown |  |
| last_medium | Unknown |  |
| last_name | Unknown |  |
| last_seen | Unknown |  |
| last_seen_chat | Unknown |  |
| last_source | Unknown |  |
| latest_campaign | Unknown |  |
| latest_medium | Unknown |  |
| latest_source | Unknown |  |
| lead_quality | Unknown |  |
| lead_score | Unknown |  |
| linkedin | Unknown |  |
| locale | Unknown |  |
| mcr_id | Unknown |  |
| medium | Unknown |  |
| mobile_number | Unknown |  |
| open_deals_amount | Unknown |  |
| open_deals_count | Unknown |  |
| other_unsubscription_reason | Unknown |  |
| phone_number | Json |  |
| recent_note | Unknown |  |
| record_type_id | Unknown |  |
| sms_subscription_status | Unknown |  |
| state | Unknown |  |
| subscription_status | Unknown |  |
| subscription_type | Unknown |  |
| time_zone | Unknown |  |
| total_session | Unknown |  |
| twitter | Unknown |  |
| unsubscription_reason | Unknown |  |
| updated_at | Unknown |  |
| web_form_id | Unknown |  |
| whatsapp_subscription_status | Unknown |  |
| won_deals_amount | Unknown |  |
| won_deals_count | Unknown |  |
| work_email | Unknown |  |
| work_number | Unknown |  |
| zipcode | Unknown |  |
| custom_** |  |  |

### deal_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| choice_type | Unknown |  |
| deal_pipeline_id | Unknown |  |
| forecast_type | Unknown |  |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |
| probability | Unknown |  |
| updated_at | Unknown |  |

### territory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| level_id | Unknown |  |
| name | Unknown |  |
| parent_territory_id | Unknown |  |
| position | Unknown |  |
| tree_id | Unknown |  |

### contact_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| is_default | Unknown |  |
| is_public | Unknown |  |
| model_class_name | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### account_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| contact_id | Unknown | FK |

### account_task

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| task_id | Unknown | FK |

### account_appointment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| appointment_id | Unknown | FK |

### account_deal

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| deal_id | Unknown | FK |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_view_id | Unknown | FK |
| owner_id | Unknown | FK |
| parent_sales_account_id | Unknown | FK |
| active_sales_sequence | Unknown |  |
| address | Unknown |  |
| annual_revenue | Unknown |  |
| avatar | Unknown |  |
| city | Unknown |  |
| completed_sales_sequence | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| facebook | Unknown |  |
| is_deleted | Unknown |  |
| last_assigned_at | Unknown |  |
| last_contacted | Unknown |  |
| last_contacted_mode | Unknown |  |
| last_contacted_sales_activity_mode | Unknown |  |
| last_contacted_via_sales_activity | Unknown |  |
| linkedin | Unknown |  |
| name | Unknown |  |
| number_of_employee | Unknown |  |
| open_deals_amount | Unknown |  |
| open_deals_count | Unknown |  |
| phone | Unknown |  |
| recent_note | Unknown |  |
| state | Unknown |  |
| tags | Json |  |
| team_user_id | Unknown |  |
| twitter | Unknown |  |
| updated_at | Unknown |  |
| web_form_id | Unknown |  |
| website | Unknown |  |
| won_deals_amount | Unknown |  |
| won_deals_count | Unknown |  |
| zipcode | Unknown |  |
| custom_** |  |  |

### appointment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creater_id | Unknown | FK |
| checkedin_at | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| from_date | Unknown |  |
| latitude | Unknown |  |
| location | Unknown |  |
| longitude | Unknown |  |
| time_zone | Unknown |  |
| title | Unknown |  |

### appointment_attendee

| Column | Type | Keys |
| --- | --- | --- |
| appointment_attendee_id | Unknown | PK |
| appointment_id | Unknown | PK, FK |

### lead_activity

| Column | Type | Keys |
| --- | --- | --- |
| composite_id | Unknown | PK |
| lead_id | Unknown | FK |
| action_data_email_id | Unknown |  |
| action_data_status | Unknown |  |
| action_data_subject | Unknown |  |
| action_type | Unknown |  |
| actionable_id | Unknown |  |
| actionable_type | Unknown |  |
| additional_timeline_info_is_hard_deleted | Unknown |  |
| additional_timeline_info_name | Unknown |  |
| automation | Unknown |  |
| created_at | Unknown |  |
| targetable_id | Unknown |  |
| targetable_name | Unknown |  |
| targetable_type | Unknown |  |
| user_activity | Unknown |  |

### lead_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### contact_activity_add_info_attendee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| composite_id | Unknown | PK, FK |
| account_id | Unknown |  |
| import_id | Unknown |  |
| secondary_event_id | Unknown |  |
| task_id | Unknown |  |
| user_id | Unknown |  |

### contact_activity_subscription_type_added

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| composite_id | Unknown | PK, FK |
| subscription_type_name | Unknown |  |

### contact_activity

| Column | Type | Keys |
| --- | --- | --- |
| composite_id | Unknown | PK |
| contact_id | Unknown | FK |
| user_id | Unknown | FK |
| action_data_description | Unknown |  |
| action_data_due_date | Unknown |  |
| action_data_outcome | Unknown |  |
| action_data_status | Unknown |  |
| action_data_title | Unknown |  |
| action_type | Unknown |  |
| actionable_id | Unknown |  |
| additional_timeline_info_additional_targetable_count | Unknown |  |
| additional_timeline_info_additional_user_count | Unknown |  |
| additional_timeline_info_callable_targetables | Json |  |
| additional_timeline_info_creater_id | Unknown |  |
| additional_timeline_info_event_type | Unknown |  |
| additional_timeline_info_has_mail | Unknown |  |
| additional_timeline_info_has_multiple_emails | Unknown |  |
| additional_timeline_info_is_deleted | Unknown |  |
| additional_timeline_info_outcome | Unknown |  |
| additional_timeline_info_primary_user_name_avatar | Unknown |  |
| additional_timeline_info_primary_user_name_name | Unknown |  |
| additional_timeline_info_status | Unknown |  |
| additional_timeline_info_targetables_with_email | Json |  |
| additional_timeline_info_team_member_info | Json |  |
| automation | Unknown |  |
| created_at | Unknown |  |
| group_id | Unknown |  |
| group_name | Unknown |  |
| group_type | Unknown |  |
| has_overdue | Unknown |  |
| id | Unknown |  |
| targetable_id | Unknown |  |
| targetable_name | Unknown |  |
| targetable_type | Unknown |  |
| user_activity | Unknown |  |

### sales_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creater_id | Unknown | FK |
| owner_id | Unknown | FK |
| sales_activity_outcome_id | Unknown | FK |
| sales_activity_type_id | Unknown | FK |
| checkedin_at | Unknown |  |
| conversation_time | Unknown |  |
| created_at | Unknown |  |
| end_date | Unknown |  |
| import_id | Unknown |  |
| latitude | Unknown |  |
| location | Unknown |  |
| longitude | Unknown |  |
| note | Unknown |  |
| remote_id | Unknown |  |
| start_date | Unknown |  |
| targetable_id | Unknown |  |
| targetable_type | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| updater_id | Unknown |  |
| custom_** |  |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| display_name | Unknown |  |
| email | Unknown |  |
| is_active | Unknown |  |
| mobile_number | Unknown |  |
| work_number | Unknown |  |

### sales_activity_outcome

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sales_activity_type_id | Unknown | FK |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### industry_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### lead_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| current_user_permissions | Json |  |
| is_default | Unknown |  |
| model_class_name | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### deal_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### lead_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| choice_type | Unknown |  |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creater_id | Unknown | FK |
| lead_view_id | Unknown | FK |
| collab_context_has_slack_view_access | Unknown |  |
| collab_context_message_id | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| has_access | Unknown |  |
| html_content | Unknown |  |
| targetable_id | Unknown |  |
| targetable_type | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| custom_** |  |  |

### business_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### sales_activity_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| internal_name | Unknown |  |
| is_checkedin | Unknown |  |
| is_checkedin_mandatory | Unknown |  |
| is_default | Unknown |  |
| is_outcome_mandatory | Unknown |  |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |
| show_in_conversation | Unknown |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_code | Unknown |  |
| currency_type | Unknown |  |
| exchange_rate | Unknown |  |
| is_active | Unknown |  |
| partial | Unknown |  |
| schedule_info | Unknown |  |

### marketing_contact

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | Unknown | FK |
| marketing_id | Unknown | FK |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creater_id | Unknown | FK |
| owner_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### account_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| current_user_permissions | Json |  |
| is_default | Unknown |  |
| is_public | Unknown |  |
| model_class_name | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### marketing

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### deal_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_id | Unknown | PK, FK |
| contact_id | Unknown | FK |

### deal_sales_activity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_id | Unknown | PK, FK |
| sales_activity_id | Unknown | FK |

### deal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_pipeline_id | Unknown | FK |
| deal_stage_id | Unknown | FK |
| deal_type_id | Unknown | FK |
| deal_view_id | Unknown | FK |
| sales_account_id | Unknown | FK |
| active_sales_sequence | Unknown |  |
| age | Unknown |  |
| amount | Unknown |  |
| avatar | Unknown |  |
| base_currency_amount | Unknown |  |
| closed_date | Unknown |  |
| completed_sales_sequence | Unknown |  |
| created_at | Unknown |  |
| deal_prediction | Unknown |  |
| deal_prediction_last_updated_at | Unknown |  |
| deal_product_id | Unknown |  |
| expected_close | Unknown |  |
| expected_deal_value | Unknown |  |
| fc_widget_collaboration_auth_token | Unknown |  |
| fc_widget_collaboration_convo_token | Unknown |  |
| fc_widget_collaboration_encoded_jwt_token | Unknown |  |
| forecast_category | Unknown |  |
| freddy_forecast_metric | Unknown |  |
| has_product | Unknown |  |
| is_deleted | Unknown |  |
| last_assigned_at | Unknown |  |
| last_contacted_sales_activity_mode | Unknown |  |
| last_contacted_via_sales_activity | Unknown |  |
| last_deal_prediction | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| probability | Unknown |  |
| recent_note | Unknown |  |
| rotten_day | Unknown |  |
| stage_updated_time | Unknown |  |
| tags | Json |  |
| team_user_id | Json |  |
| upcoming_activities_time | Unknown |  |
| updated_at | Unknown |  |
| web_form_id | Unknown |  |
| custom_** |  |  |

### deal_payment_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### deal_pipeline_config

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_pipeline_id | Unknown | PK, FK |
| field_name | Unknown |  |
| highligh | Unknown |  |
| position | Unknown |  |

### deal_pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| deal_pipeline_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### deal_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| aggregated_field | Unknown |  |
| is_default | Unknown |  |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |
| rotting_days | Unknown |  |

### contact_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| forecast_type | Unknown |  |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### deal_reason

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| partial | Unknown |  |
| position | Unknown |  |

### deal_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| current_user_permissions | Json |  |
| is_default | Unknown |  |
| is_public | Unknown |  |
| model_class_name | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### lead_team_user

| Column | Type | Keys |
| --- | --- | --- |
| lead_id | Unknown | PK, FK |
| team_user_id | Unknown | PK, FK |

### lead_lead_source

| Column | Type | Keys |
| --- | --- | --- |
| lead_id | Unknown | PK, FK |
| lead_source_id | Unknown | PK, FK |

### lead_lead_stage

| Column | Type | Keys |
| --- | --- | --- |
| lead_id | Unknown | PK, FK |
| lead_stage_id | Unknown | PK, FK |

### lead_territory

| Column | Type | Keys |
| --- | --- | --- |
| lead_id | Unknown | PK, FK |
| territory_id | Unknown | PK, FK |

### lead_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| lead_id | Unknown | PK, FK |

### lead_task

| Column | Type | Keys |
| --- | --- | --- |
| lead_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### lead_appointment

| Column | Type | Keys |
| --- | --- | --- |
| appointment_id | Unknown | PK, FK |
| lead_id | Unknown | PK, FK |

### lead_note

| Column | Type | Keys |
| --- | --- | --- |
| lead_id | Unknown | PK, FK |
| note_id | Unknown | PK, FK |

### lead_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lead_id | Unknown | PK, FK |
| lead_view_id | Unknown | PK, FK |
| _destroy | Unknown |  |
| is_primary | Unknown |  |
| label | Unknown |  |
| value | Unknown |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | FK |
| lead_view_id | Unknown | FK |
| active_sales_sequences | Unknown |  |
| address | Unknown |  |
| avatar | Unknown |  |
| city | Unknown |  |
| company | Unknown |  |
| completed_sales_sequences | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| deal | Unknown |  |
| department | Unknown |  |
| display_name | Unknown |  |
| do_not_disturb | Unknown |  |
| email | Unknown |  |
| email_status | Unknown |  |
| facebook | Unknown |  |
| first_name | Unknown |  |
| has_authority | Unknown |  |
| is_deleted | Unknown |  |
| job_title | Unknown |  |
| keyword | Unknown |  |
| last_assigned_at | Unknown |  |
| last_contacted | Unknown |  |
| last_contacted_mode | Unknown |  |
| last_contacted_sales_activity_mode | Unknown |  |
| last_contacted_via_chat | Unknown |  |
| last_contacted_via_sales_activity | Unknown |  |
| last_name | Unknown |  |
| last_seen | Unknown |  |
| lead_quality | Unknown |  |
| lead_score | Unknown |  |
| linkedin | Unknown |  |
| medium | Unknown |  |
| mobile_number | Unknown |  |
| phone_numbers | Json |  |
| recent_note | Unknown |  |
| record_type_id | Unknown |  |
| stage_updated_time | Unknown |  |
| state | Unknown |  |
| subscription_status | Unknown |  |
| tags | Json |  |
| time_zone | Unknown |  |
| twitter | Unknown |  |
| updated_at | Unknown |  |
| web_form_ids | Unknown |  |
| work_number | Unknown |  |
| zipcode | Unknown |  |
| custom_** |  |  |

## Relationships

- contact_email(contact_id) → contact(id)
- contact_system_tag(contact_id) → contact(id)
- contact_team_user(team_user_id) → users(id)
- contact_team_user(contact_id) → contact(id)
- contact_sales_account(id) → account(id)
- contact_sales_account(contact_id) → contact(id)
- contact_appointment(appointment_id) → appointment(id)
- contact_appointment(contact_id) → contact(id)
- contact_lead_source(lead_source_id) → lead_source(id)
- contact_lead_source(contact_id) → contact(id)
- contact_territory(territory_id) → territory(id)
- contact_territory(contact_id) → contact(id)
- contact_campaign(campaign_id) → campaign(id)
- contact_campaign(contact_id) → contact(id)
- contact_task(task_id) → task(id)
- contact_task(contact_id) → contact(id)
- contact_note(note_id) → note(id)
- contact_note(contact_id) → contact(id)
- contact_tag(contact_id) → contact(id)
- contact(creater_id) → users(id)
- contact(contact_view_id) → contact_view(id)
- contact_view(user_id) → users(id)
- account_contact(contact_id) → contact(id)
- account_contact(account_id) → account(id)
- account_task(task_id) → task(id)
- account_task(account_id) → account(id)
- account_appointment(appointment_id) → appointment(id)
- account_appointment(account_id) → account(id)
- account_deal(deal_id) → deal(id)
- account_deal(account_id) → account(id)
- account(owner_id) → users(id)
- account(parent_sales_account_id) → account(id)
- account(account_view_id) → account_view(id)
- appointment(creater_id) → users(id)
- appointment_attendee(appointment_id) → appointment(id)
- lead_activity(lead_id) → lead(id)
- contact_activity_add_info_attendee(composite_id) → contact_activity(composite_id)
- contact_activity_subscription_type_added(composite_id) → contact_activity(composite_id)
- contact_activity(user_id) → users(id)
- contact_activity(contact_id) → contact(id)
- sales_activity(sales_activity_outcome_id) → sales_activity_outcome(id)
- sales_activity(owner_id) → users(id)
- sales_activity(sales_activity_type_id) → sales_activity_type(id)
- sales_activity(creater_id) → users(id)
- sales_activity_outcome(sales_activity_type_id) → sales_activity_type(id)
- lead_view(user_id) → users(id)
- note(creater_id) → users(id)
- note(lead_view_id) → lead_view(id)
- marketing_contact(id) → contact(id)
- marketing_contact(marketing_id) → marketing(id)
- task(owner_id) → users(id)
- task(creater_id) → users(id)
- account_view(user_id) → users(id)
- deal_contact(contact_id) → contact(id)
- deal_contact(deal_id) → deal(id)
- deal_sales_activity(sales_activity_id) → sales_activity(id)
- deal_sales_activity(deal_id) → deal(id)
- deal(deal_stage_id) → deal_stage(id)
- deal(sales_account_id) → account(id)
- deal(deal_pipeline_id) → deal_pipeline(id)
- deal(deal_type_id) → deal_type(id)
- deal(deal_view_id) → deal_view(id)
- deal_pipeline_config(deal_pipeline_id) → deal_pipeline(id)
- deal_pipeline_stage(id) → deal_stage(id)
- deal_pipeline_stage(deal_pipeline_id) → deal_pipeline(id)
- deal_view(user_id) → users(id)
- lead_team_user(team_user_id) → users(id)
- lead_team_user(lead_id) → lead(id)
- lead_lead_source(lead_source_id) → lead_source(id)
- lead_lead_source(lead_id) → lead(id)
- lead_lead_stage(lead_stage_id) → lead_stage(id)
- lead_lead_stage(lead_id) → lead(id)
- lead_territory(territory_id) → territory(id)
- lead_territory(lead_id) → lead(id)
- lead_campaign(campaign_id) → campaign(id)
- lead_campaign(lead_id) → lead(id)
- lead_task(task_id) → task(id)
- lead_task(lead_id) → lead(id)
- lead_appointment(appointment_id) → appointment(id)
- lead_appointment(lead_id) → lead(id)
- lead_note(note_id) → note(id)
- lead_note(lead_id) → lead(id)
- lead_email(lead_view_id) → lead_view(id)
- lead_email(lead_id) → lead(id)
- lead(deal_id) → deal(id)
- lead(lead_view_id) → lead_view(id)