Ricochet360

Explore the interactive ERD

Table & Field Reference

lead_status_related_status

Column	Type	Keys
`index`	Unknown	PK
`lead_status_id`	Unknown	PKFK
`related_status`	Unknown

lead_status_rule

Column	Type	Keys
`index`	Unknown	PK
`lead_status_id`	Unknown	PKFK
`rule`	Unknown

lead_status

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`all_teams`	Unknown
`assign_to_user_in_external_crm`	Unknown
`company_id`	Unknown
`created_at`	Unknown
`deal`	Unknown
`do_not_call`	Unknown
`email_notification`	Unknown
`expiration_event_id`	Unknown
`expiration_rules`	Unknown
`expiration_status_id`	Unknown
`expiration_time`	Unknown
`external_id`	Unknown
`hotkey`	Unknown
`in_big_data`	Unknown
`internal`	Unknown
`lead_types_excluded_from_expiration`	Json
`lock_lead_owner`	Unknown
`name`	Unknown
`override_global_statusing_webhook`	Unknown
`phone_numbers_ivr_id`	Unknown
`popup`	Unknown
`prevent_double_statusing`	Unknown
`rulecreated_at`	Unknown
`ruledefault`	Unknown
`rulefrom_status_id`	Unknown
`ruleid`	Unknown
`rulerules`	Unknown
`ruleto_status_id`	Unknown
`ruleupdated_at`	Unknown
`stop_email`	Unknown
`stop_post`	Unknown
`team_ids`	Json
`unassign`	Unknown
`update_status_in_external_crm`	Unknown
`updated_at`	Unknown
`webhook_id`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`lead_id`	Unknown	FK
`task_id`	Unknown	FK
`user_id`	Unknown	FK
`children`	Json
`company_id`	Unknown
`completed`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`event_id`	Unknown
`first_scheduled_for_st`	Unknown
`first_scheduled_for_ut`	Unknown
`foreign_id`	Unknown
`internal`	Unknown
`next_scheduled_for_st`	Unknown
`next_scheduled_for_ut`	Unknown
`notify_mail`	Unknown
`notify_popup`	Unknown
`on_rabbit`	Unknown
`parent_id`	Unknown
`repeat_interval`	Unknown
`title`	Unknown
`updated_at`	Unknown
`url`	Unknown

call_type

Column	Type	Keys
`id`	Unknown	PK
`contact_type_id`	Unknown
`created_at`	Unknown
`is_queue`	Unknown
`label`	Unknown
`outbound`	Unknown
`priority`	Unknown
`type`	Unknown
`updated_at`	Unknown
`visible`	Unknown

lead_campaign

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`eligible_users`	Json
`name`	Unknown
`private`	Unknown
`tags`	Unknown
`vendor_id`	Unknown

user_call_type

Column	Type	Keys
`index`	Unknown	PK
`id`	Unknown	PKFK
`user_id`	Unknown	PKFK

user_role

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`flag`	Unknown
`label`	Unknown

user_custom_field

Column	Type	Keys
`_fivetran_id`	String	PK
`user_id`	Unknown	FK
`label`	Unknown
`name`	Unknown

user_team

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`call_type_id`	Unknown	FK
`all_users`	Unknown
`block_lead_assignment`	Unknown
`company_id`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`name`	Unknown
`show_on_call_transfers`	Unknown
`state_licensing_for_transfers`	Unknown
`updated_at`	Unknown

user_agent_call_type

Column	Type	Keys
`agent_call_type`	Unknown	PK
`user_id`	Unknown	PKFK

users

Column	Type	Keys
`id`	Unknown	PK
`address`	Unknown
`assigned_phone`	Unknown
`cam_q_state_eligibility`	Unknown
`chat_chime`	Unknown
`city`	Unknown
`company_id`	Unknown
`created_at`	Unknown
`daily_ricochets`	Unknown
`default_email_client`	Unknown
`default_signature`	Unknown
`default_smtp_credentials_id`	Unknown
`deleted_at`	Unknown
`disable_call_recording`	Unknown
`email`	Unknown
`email_custom`	Unknown
`email_custom_2`	Unknown
`email_custom_3`	Unknown
`email_from_name`	Unknown
`enable_access_to_support_pages_in_ahoy`	Unknown
`enable_local_caller_id_on_manual_calls`	Unknown
`enable_sms_chime_notification`	Unknown
`enable_sms_desktop_notification`	Unknown
`enable_tone_on_ivr`	Unknown
`enable_vm_notification`	Unknown
`enabled_for_dm`	Unknown
`enabled_for_predictive_calls`	Unknown
`enabled_for_public_campaigns`	Unknown
`enabled_for_queue_calls`	Unknown
`enabled_for_state_routed_calls`	Unknown
`external_crm_id`	Unknown
`external_crm_password`	Unknown
`first_name`	Unknown
`fishbowl_ui_locked_height`	Unknown
`fishbowl_ui_locked_state`	Unknown
`fishbowl_ui_sticky`	Unknown
`gravatar`	Unknown
`inbound_caps`	Unknown
`is_admin`	Unknown
`is_super_admin`	Unknown
`last_name`	Unknown
`last_status_change_at`	Unknown
`lead_managament_action_position`	Unknown
`lead_managament_bold_text`	Unknown
`lead_management_new_interface_settings_alert`	Unknown
`lead_pull_cap`	Unknown
`name`	Unknown
`notified_about_chatbot`	Unknown
`office_id`	Unknown
`phone`	Unknown
`phone_1`	Unknown
`plivo_sip`	Unknown
`plivo_user`	Unknown
`restrict_calls_to_tagged_leads`	Unknown
`ringtone_inbound`	Unknown
`ringtone_loop_on_inbound`	Unknown
`ringtone_outbound`	Unknown
`service_created_at`	Unknown
`service_id`	Unknown
`service_name`	Unknown
`service_title`	Unknown
`service_updated_at`	Unknown
`show_inbound_dashboard`	Unknown
`signature`	Unknown
`softphone`	Unknown
`state`	Unknown
`states`	Unknown
`status`	Unknown
`team_member_status`	Unknown
`twilio_sip_pass`	Unknown
`twilio_sip_user`	Unknown
`use_ip_restrictions`	Unknown
`view_company_vm`	Unknown
`volume_inbound`	Unknown
`volume_outbound`	Unknown
`zip`	Unknown
`custom_`

general_task

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	FK
`foreign_id`	Unknown	FK
`lead_id`	Unknown	FK
`user_id`	Unknown	FK
`address`	Json
`appointment_type_id`	Unknown
`card_type`	Unknown
`category`	Unknown
`company_id`	Unknown
`completed`	Unknown
`conference_number`	Unknown
`created_at`	Unknown
`created_at_military`	Unknown
`deleted_at`	Unknown
`description`	Unknown
`end_date`	Unknown
`end_time`	Unknown
`event_calendars`	Unknown
`first_scheduled_for_st`	Unknown
`first_scheduled_for_ut`	Unknown
`follow`	Unknown
`img_url`	Unknown
`internal`	Unknown
`invitees`	Unknown
`lead_key`	Unknown
`mail`	Unknown
`next_scheduled_for_st`	Unknown
`next_scheduled_for_ut`	Unknown
`note`	Unknown
`on_rabbit`	Unknown
`owner`	Unknown
`parameters`	Json
`parent_id`	Unknown
`phone_to_call`	Unknown
`popup`	Unknown
`priority`	Unknown
`remind_time`	Unknown
`reminder_type`	Unknown
`repeat_days`	Unknown
`repeat_interval`	Unknown
`repeat_quantity`	Unknown
`repeat_stop`	Unknown
`repeat_type`	Unknown
`secret_code`	Unknown
`start_date`	Unknown
`start_time`	Unknown
`status`	Unknown
`sync_calendar`	Unknown
`tags`	Unknown
`task_date`	Unknown
`task_name`	Unknown
`task_owner`	Unknown
`task_type`	Unknown
`time_without_call`	Unknown
`title`	Unknown
`updated_at`	Unknown
`updated_at_military`	Unknown

lead_overview

Column	Type	Keys
`_fivetran_id`	String	PK
`lead_id`	Unknown	FK
`owner_id`	Unknown	FK
`status_id`	Unknown	FK
`calls_campaign_queue`	Unknown
`calls_dripdial_queue`	Unknown
`calls_inbound`	Unknown
`calls_real_time`	Unknown

lead_tag

Column	Type	Keys
`id`	Unknown	PK
`lead_id`	Unknown	PKFK
`label`	Unknown
`manual_created`	Unknown
`routing`	Unknown

lead

Column	Type	Keys
`id`	Unknown	PK
`company_campaign_id`	Unknown	FK
`currentowner_id`	Unknown	FK
`currentstatus_id`	Unknown	FK
`additional_cash`	Unknown
`additional_notes`	Unknown
`address_1`	Unknown
`address_2`	Unknown
`application_taken`	Unknown
`areacode_id`	Unknown
`areacode_state_id`	Unknown
`bankruptcy`	Unknown
`best_time_to_call`	Unknown
`bid_price`	Unknown
`birth_date`	Unknown
`campaign_id`	Unknown
`city`	Unknown
`close_date`	Unknown
`closing_date`	Unknown
`co_borrower_first_name`	Unknown
`co_borrower_last_name`	Unknown
`company_id`	Unknown
`company_name`	Unknown
`completed_drip_dial`	Unknown
`connection`	Unknown
`consumer_comments`	Unknown
`country`	Unknown
`created_at`	Unknown
`credit_profile`	Unknown
`credit_range`	Unknown
`cur_interest_rate`	Unknown
`current_loan_amount`	Unknown
`current_loan_type`	Unknown
`current_rate`	Unknown
`current_term`	Unknown
`currentowner_email`	Unknown
`currentowner_first_name`	Unknown
`currentowner_last_name`	Unknown
`deleted_at`	Unknown
`department`	Unknown
`description`	Unknown
`division`	Unknown
`do_not_call`	Unknown
`down_payment`	Unknown
`email`	Unknown
`email_opt_out`	Unknown
`employer`	Unknown
`employment_length`	Unknown
`environment`	Unknown
`external_crm_lead_id`	Unknown
`facebook`	Unknown
`fax`	Unknown
`first_mortgage_balance`	Unknown
`first_name`	Unknown
`follow`	Unknown
`ftc_end`	Unknown
`ftc_start`	Unknown
`g_plus`	Unknown
`gross_monthly_income`	Unknown
`has_restricted_tags`	Unknown
`hoa_fee`	Unknown
`home_value`	Unknown
`img_url`	Unknown
`income`	Unknown
`industry`	Unknown
`intended_property_use`	Unknown
`ip_address`	Unknown
`is_being_called`	Unknown
`is_inbound`	Unknown
`is_outbound`	Unknown
`is_test`	Unknown
`l_user_id`	Unknown
`landing_page`	Unknown
`languages`	Unknown
`last_called_at`	Unknown
`last_name`	Unknown
`last_statused_at`	Unknown
`lead_id`	Unknown
`lead_import_id`	Unknown
`lead_key`	Unknown
`lead_source`	Unknown
`lead_type`	Unknown
`linkedin`	Unknown
`lmb_lead_id`	Unknown
`loan_purpose`	Unknown
`loan_to_value`	Unknown
`main_state`	Unknown
`main_state_id`	Unknown
`manager_name`	Unknown
`marital_status`	Unknown
`military_eligibility`	Unknown
`minimum_payment`	Unknown
`modified_by`	Unknown
`monthly_debt_payments`	Unknown
`mortgage_one_interest`	Unknown
`mortgage_two`	Unknown
`mortgage_two_interest`	Unknown
`no_employees`	Unknown
`notes`	Unknown
`notified`	Unknown
`occupational_status`	Unknown
`office_id`	Unknown
`office_phone`	Unknown
`order_number`	Unknown
`owner`	Unknown
`phone`	Unknown
`phone_1`	Unknown
`phone_2`	Unknown
`phone_3`	Unknown
`pref_call_time`	Unknown
`product`	Unknown
`property_address`	Unknown
`property_city`	Unknown
`property_description`	Unknown
`property_state`	Unknown
`property_state_id`	Unknown
`property_type`	Unknown
`property_value`	Unknown
`property_zip`	Unknown
`prospect_id`	Unknown
`pulled_timestamp`	Unknown
`purchase_price`	Unknown
`purchase_year`	Unknown
`reference_id`	Unknown
`refinance_expectation`	Unknown
`revenue`	Unknown
`sale_made`	Unknown
`second_mortgage_balance`	Unknown
`secondary_email`	Unknown
`simplybook`	Unknown
`skype_id`	Unknown
`sms`	Unknown
`spouse_first_name`	Unknown
`spouse_last_name`	Unknown
`ssn`	Unknown
`stage`	Unknown
`stand`	Unknown
`stars`	Unknown
`state`	Unknown
`state_id`	Unknown
`stoppost`	Unknown
`time_without_call`	Unknown
`title`	Unknown
`twitter`	Unknown
`updated_at`	Unknown
`uuid`	Unknown
`va_status`	Unknown
`velocify_lead_id`	Unknown
`vendor_id`	Unknown
`vendor_name`	Unknown
`website`	Unknown
`whisper_message`	Unknown
`zip`	Unknown
`custom_`

lead_status_history

Column	Type	Keys
`id`	Unknown	PK
`lead_id`	Unknown	FK
`status_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`created_at_military`	Unknown
`deleted_at`	Unknown
`external`	Unknown
`in_big_data`	Unknown
`previous_status_id`	Unknown
`updated_at`	Unknown
`updated_at_military`	Unknown

lead_call_history

Column	Type	Keys
`id`	Unknown	PK
`call_type_id`	Unknown	FK
`lead_id`	Unknown	FK
`user_id`	Unknown	FK
`call_queue_id`	Unknown
`call_recordings`	Json
`call_status`	Unknown
`call_uuid`	Unknown
`caller_id`	Unknown
`campaign_id`	Unknown
`campaign_name`	Unknown
`created_at`	Unknown
`created_at_military`	Unknown
`duration`	Unknown
`hangup_cause`	Unknown
`hijacked_a_call`	Unknown
`hijacked_by_call_id`	Unknown
`ivr_phone_description`	Unknown
`ivr_phone_name`	Unknown
`phone`	Unknown
`record_url`	Unknown
`ricochet_number`	Unknown
`spam_likely`	Unknown
`spam_score`	Unknown
`state_routed`	Unknown
`to_id`	Unknown

note_collection

Column	Type	Keys
`id`	Unknown	PK
`lead_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`note`	Unknown