Freshsales

Explore the interactive ERD

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

contact_team_user

Column	Type	Keys
`contact_id`	Unknown	PKFK
`team_user_id`	Unknown	PKFK

contact_sales_account

Column	Type	Keys
`contact_id`	Unknown	PKFK
`id`	Unknown	PKFK
`is_primary`	Unknown
`partial`	Unknown

contact_appointment

Column	Type	Keys
`apponitment_id`	Unknown	PK
`contact_id`	Unknown	PKFK
`appointment_id`	Unknown	FK

contact_lead_source

Column	Type	Keys
`contact_id`	Unknown	PKFK
`lead_source_id`	Unknown	PKFK

contact_territory

Column	Type	Keys
`contact_id`	Unknown	PKFK
`territory_id`	Unknown	PKFK

contact_campaign

Column	Type	Keys
`campaign_id`	Unknown	PKFK
`contact_id`	Unknown	PKFK

contact_task

Column	Type	Keys
`contact_id`	Unknown	PKFK
`task_id`	Unknown	PKFK

contact_note

Column	Type	Keys
`contact_id`	Unknown	PKFK
`note_id`	Unknown	PKFK

contact_tag

Column	Type	Keys
`index`	Unknown	PK
`contact_id`	Unknown	PKFK
`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	PKFK
`contact_id`	Unknown	FK

account_task

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`task_id`	Unknown	FK

account_appointment

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`appointment_id`	Unknown	FK

account_deal

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`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	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`contact_id`	Unknown	FK

deal_sales_activity

Column	Type	Keys
`index`	Unknown	PK
`deal_id`	Unknown	PKFK
`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	PKFK
`field_name`	Unknown
`highligh`	Unknown
`position`	Unknown

deal_pipeline_stage

Column	Type	Keys
`deal_pipeline_id`	Unknown	PKFK
`id`	Unknown	PKFK

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

lead_lead_source

Column	Type	Keys
`lead_id`	Unknown	PKFK
`lead_source_id`	Unknown	PKFK

lead_lead_stage

Column	Type	Keys
`lead_id`	Unknown	PKFK
`lead_stage_id`	Unknown	PKFK

lead_territory

Column	Type	Keys
`lead_id`	Unknown	PKFK
`territory_id`	Unknown	PKFK

lead_campaign

Column	Type	Keys
`campaign_id`	Unknown	PKFK
`lead_id`	Unknown	PKFK

lead_task

Column	Type	Keys
`lead_id`	Unknown	PKFK
`task_id`	Unknown	PKFK

lead_appointment

Column	Type	Keys
`appointment_id`	Unknown	PKFK
`lead_id`	Unknown	PKFK

lead_note

Column	Type	Keys
`lead_id`	Unknown	PKFK
`note_id`	Unknown	PKFK

lead_email

Column	Type	Keys
`id`	Unknown	PK
`lead_id`	Unknown	PKFK
`lead_view_id`	Unknown	PKFK
`_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_`