# Ricochet360 schema ERD

Table and field reference for the Fivetran Ricochet360 connector.

## Table & Field Reference

### lead_status_related_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lead_status_id | Unknown | PK, FK |
| related_status | Unknown |  |

### lead_status_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lead_status_id | Unknown | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| 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 |  |

## Relationships

- lead_status_related_status(lead_status_id) → lead_status(id)
- lead_status_rule(lead_status_id) → lead_status(id)
- event(user_id) → users(id)
- event(lead_id) → lead(id)
- event(task_id) → general_task(id)
- user_call_type(id) → call_type(id)
- user_call_type(user_id) → users(id)
- user_role(user_id) → users(id)
- user_custom_field(user_id) → users(id)
- user_team(user_id) → users(id)
- user_team(call_type_id) → call_type(id)
- user_agent_call_type(user_id) → users(id)
- general_task(event_id) → event(id)
- general_task(user_id) → users(id)
- general_task(lead_id) → lead(id)
- general_task(foreign_id) → general_task(id)
- lead_overview(status_id) → lead_status(id)
- lead_overview(owner_id) → users(id)
- lead_overview(lead_id) → lead(id)
- lead_tag(lead_id) → lead(id)
- lead(company_campaign_id) → lead_campaign(id)
- lead(currentowner_id) → users(id)
- lead(currentstatus_id) → lead_status(id)
- lead_status_history(user_id) → users(id)
- lead_status_history(lead_id) → lead(id)
- lead_status_history(status_id) → lead_status(id)
- lead_call_history(user_id) → users(id)
- lead_call_history(call_type_id) → call_type(id)
- lead_call_history(lead_id) → lead(id)
- note_collection(user_id) → users(id)
- note_collection(lead_id) → lead(id)