# Healthie schema ERD

Table and field reference for the Fivetran Healthie connector.

## Table & Field Reference

### appointment_type_bookable_group

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

### appointment_type_form_request_after_booking

| Column | Type | Keys |
| --- | --- | --- |
| appointment_type_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| interval | Unknown |  |
| send_trigger | Unknown |  |

### appointment_type_form_request_after_appointment

| Column | Type | Keys |
| --- | --- | --- |
| appointment_type_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| interval | Unknown |  |
| send_trigger | Unknown |  |

### appointment_type_form_request_before_appointment

| Column | Type | Keys |
| --- | --- | --- |
| appointment_type_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| interval | Unknown |  |
| send_trigger | Unknown |  |

### appointment_type_setting_location

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

### appointment_type_setting_contact_type_override

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appointment_type_id | Unknown | PK, FK |
| form_id | Unknown | FK |
| user_id | Unknown | FK |
| id | Unknown |  |
| name | Unknown |  |
| show | Unknown |  |

### appointment_type_setting_calendar_color_scheme

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_type_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| color_code_by | Unknown |  |
| default_color | Unknown |  |

### appointment_type_setting_calendar_color_scheme_color_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_type_id | Unknown | PK, FK |
| code_by_item | Unknown |  |
| code_by_item_name | Unknown |  |
| color | Unknown |  |

### appointment_type_setting_accepted_insurance_plan

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

### appointment_type_provider_connection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_type_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| provider_name | Unknown |  |

### appointment_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| onboarding_flow_user_id | Unknown | FK |
| user_group_id | Unknown | FK |
| user_id | Unknown | FK |
| advance_pricing_for_clients_count | Unknown |  |
| advance_pricing_for_providers_count | Unknown |  |
| appointment_setting_allow_appointment_type_pricing | Unknown |  |
| appointment_setting_allow_clients_to_cancel_appt | Unknown |  |
| appointment_setting_allow_clients_to_reschedule_appt | Unknown |  |
| appointment_setting_allow_external_videochat_urls | Unknown |  |
| appointment_setting_allow_past_appointment_rescheduling | Unknown |  |
| appointment_setting_allow_specific_client_pricing | Unknown |  |
| appointment_setting_allow_specific_provider_pricing | Unknown |  |
| appointment_setting_always_send_confirm_notification | Unknown |  |
| appointment_setting_appt_type_confirmed_email | Unknown |  |
| appointment_setting_appt_type_reminder_email | Unknown |  |
| appointment_setting_appt_type_website_booking_email | Unknown |  |
| appointment_setting_ask_clients_to_confirm | Unknown |  |
| appointment_setting_ask_to_confirm_via_text | Unknown |  |
| appointment_setting_auto_create_cms_1500 | Unknown |  |
| appointment_setting_auto_invoicing | Unknown |  |
| appointment_setting_auto_submit_cms_1500 | Unknown |  |
| appointment_setting_booking_interval_restriction | Unknown |  |
| appointment_setting_buffer | Unknown |  |
| appointment_setting_calendar_interval | Unknown |  |
| appointment_setting_calendar_text | Unknown |  |
| appointment_setting_charge_for_occured_appts | Unknown |  |
| appointment_setting_client_should_call_provider | Unknown |  |
| appointment_setting_clients_have_billing | Unknown |  |
| appointment_setting_confirm_by_default | Unknown |  |
| appointment_setting_confirmed_email | Unknown |  |
| appointment_setting_default_appt_form_to_group | Unknown |  |
| appointment_setting_default_charting_template_id | Unknown |  |
| appointment_setting_default_charting_template_name | Unknown |  |
| appointment_setting_default_group_charting_template_id | Unknown |  |
| appointment_setting_default_to_zoom | Unknown |  |
| appointment_setting_default_video_service | Unknown |  |
| appointment_setting_disallowed_reschedulable_statuses | Unknown |  |
| appointment_setting_end_time | Unknown |  |
| appointment_setting_fb_pixel | Unknown |  |
| appointment_setting_give_notes_name | Unknown |  |
| appointment_setting_hide_insurance_getting_started_info | Unknown |  |
| appointment_setting_hide_link | Unknown |  |
| appointment_setting_id | Unknown |  |
| appointment_setting_insurance_eligibility_integration | Unknown |  |
| appointment_setting_invoice_clients_without_payment_method | Unknown |  |
| appointment_setting_max_days_in_future | Unknown |  |
| appointment_setting_maximum_past_reschedule_time | Unknown |  |
| appointment_setting_minimum_advance_cancel_time | Unknown |  |
| appointment_setting_minimum_advance_reschedule_time | Unknown |  |
| appointment_setting_minimum_advance_schedule_time | Unknown |  |
| appointment_setting_minimum_days_in_advance | Unknown |  |
| appointment_setting_minimum_past_reschedule_time | Unknown |  |
| appointment_setting_only_book | Unknown |  |
| appointment_setting_only_book_even | Unknown |  |
| appointment_setting_only_book_hour | Unknown |  |
| appointment_setting_patient_reschedule_count_cap | Unknown |  |
| appointment_setting_pm_statuses | Unknown |  |
| appointment_setting_prevent_client_booking | Unknown |  |
| appointment_setting_prevent_no_credit_booking | Unknown |  |
| appointment_setting_reminder_email | Unknown |  |
| appointment_setting_reminder_override | Unknown |  |
| appointment_setting_reply_to_provider | Unknown |  |
| appointment_setting_reschedule_max_days_before_date | Unknown |  |
| appointment_setting_reschedule_max_days_from_date | Unknown |  |
| appointment_setting_restore_credit_on_cancel | Unknown |  |
| appointment_setting_same_day_appointments | Unknown |  |
| appointment_setting_send_appointment_cancellation_email | Unknown |  |
| appointment_setting_send_appointment_update_email | Unknown |  |
| appointment_setting_send_booking_notice | Unknown |  |
| appointment_setting_send_email_before_appointment | Unknown |  |
| appointment_setting_send_intake_forms_reminder | Unknown |  |
| appointment_setting_send_push_before_appointment | Unknown |  |
| appointment_setting_send_reminder_four_days_before | Unknown |  |
| appointment_setting_send_reminder_one_day_before | Unknown |  |
| appointment_setting_send_reminder_one_hour_before | Unknown |  |
| appointment_setting_send_reminder_three_days_before | Unknown |  |
| appointment_setting_send_reminder_two_days_before | Unknown |  |
| appointment_setting_send_reminder_two_hours_before | Unknown |  |
| appointment_setting_send_text_reminder_five_minutes_before | Unknown |  |
| appointment_setting_send_text_reminder_four_days_before | Unknown |  |
| appointment_setting_send_text_reminder_one_day_before | Unknown |  |
| appointment_setting_send_text_reminder_one_hour_before | Unknown |  |
| appointment_setting_send_text_reminder_three_days_before | Unknown |  |
| appointment_setting_send_text_reminder_two_days_before | Unknown |  |
| appointment_setting_send_text_reminder_two_hours_before | Unknown |  |
| appointment_setting_set_default_videochat_url | Unknown |  |
| appointment_setting_show_care_plans | Unknown |  |
| appointment_setting_show_cms_1500_s | Unknown |  |
| appointment_setting_show_faxes | Unknown |  |
| appointment_setting_show_insurance_authorization | Unknown |  |
| appointment_setting_show_office_ally | Unknown |  |
| appointment_setting_show_superbills | Unknown |  |
| appointment_setting_start_fb_pixel | Unknown |  |
| appointment_setting_start_time | Unknown |  |
| appointment_setting_times_by_appointment_type | Unknown |  |
| appointment_setting_times_by_contact_type | Unknown |  |
| appointment_setting_times_by_location | Unknown |  |
| appointment_setting_updated_at | Unknown |  |
| appointment_setting_use_client_credit_system | Unknown |  |
| appointment_setting_use_client_sources | Unknown |  |
| appointment_setting_use_zoom_waiting_room | Unknown |  |
| appointment_setting_user_id | Unknown |  |
| appointment_setting_video_url_default_id | Unknown |  |
| appointment_setting_video_url_default_url | Unknown |  |
| appointment_setting_video_url_default_user_id | Unknown |  |
| appointment_setting_video_url_default_video_url_options | Json |  |
| appointment_setting_website_booking_email | Unknown |  |
| appointment_type_cpt_code_cpt_code_id | Unknown |  |
| appointment_type_cpt_code_id | Unknown |  |
| appointment_type_cpt_code_units | Unknown |  |
| auto_increase_charge_for_actual_duration | Unknown |  |
| available_contact_types | Unknown |  |
| bookable_by_groups | Unknown |  |
| bookable_without_group | Unknown |  |
| client_call_provider | Unknown |  |
| clients_can_book | Unknown |  |
| clients_have_credit | Unknown |  |
| cpt_price | Unknown |  |
| created_at | Unknown |  |
| cursor | Unknown |  |
| custom_text_reminder_body | Unknown |  |
| deleted_at | Unknown |  |
| dont_ask_for_reason | Unknown |  |
| embed_question_form_id | Unknown |  |
| has_available_group_appts | Unknown |  |
| has_specific_appointment_settings | Unknown |  |
| is_group | Unknown |  |
| is_waitlist_enabled | Unknown |  |
| length | Unknown |  |
| name | Unknown |  |
| no_availability_message | Unknown |  |
| position | Unknown |  |
| price | Unknown |  |
| pricing | Unknown |  |
| pricing_option | Unknown |  |
| require_in_state_clients | Unknown |  |
| require_specific_providers | Unknown |  |
| row_order | Unknown |  |
| time_on_label | Unknown |  |
| updated_at | LocalDateTime |  |
| valid_state_licensing_for | Unknown |  |

### tagged_user

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

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active_users_count | Unknown |  |
| added_by | Unknown |  |
| archived_users_count | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| org_members_count | Unknown |  |
| updated_at | Unknown |  |

### form_answer_group_auto_score_section

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_answer_group_id | Unknown | PK, FK |
| section_key | Unknown |  |
| section_title | Unknown |  |
| value | Unknown |  |

### form_answer_group_charting_note_addendum

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_answer_group_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| content | Unknown |  |
| created_at | Unknown |  |

### form_answer_group_sign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_answer_group_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |

### form_answer_group_user_connection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_answer_group_id | Unknown | PK, FK |
| user_id | Unknown | FK |

### form_answer_group_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_answer_group_id | Unknown | PK, FK |
| custom_module_id | Unknown | FK |
| user_id | Unknown | FK |
| answer | Unknown |  |
| conditional_custom_module_id | Unknown |  |
| created_at | Unknown |  |
| displayed_answer | Unknown |  |
| filter_type | Unknown |  |
| label | Unknown |  |
| updated_at | Unknown |  |
| value_to_filter | Unknown |  |

### form_answer_group_appointment_attendee

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

### form_answer_group_individual_client_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_answer_group_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| appointment_inclusion_id | Unknown |  |
| attended | Unknown |  |
| content | Unknown |  |
| icd_codes_individual_client_notes | Json |  |
| join_time | Unknown |  |
| leave_time | Unknown |  |

### form_answer_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | FK |
| cms_1500_id | Unknown | FK |
| filler_id | Unknown | FK |
| form_template_id | Unknown | FK |
| locked_by_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| cursor | Unknown |  |
| deleted_at | Unknown |  |
| external_id | Unknown |  |
| finished | Unknown |  |
| frozen | Unknown |  |
| is_group_appt_note | Unknown |  |
| locked_at | Unknown |  |
| name | Unknown |  |
| package_id | Unknown |  |
| record_created_at | Unknown |  |
| updated_at | LocalDateTime |  |

### document_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| document_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| viewed_at | Unknown |  |

### document_shared_user_group

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

### document_shared_user

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

### document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| rel_user_id | Unknown | FK |
| can_only_share | Unknown |  |
| created_at | LocalDateTime |  |
| description | Unknown |  |
| display_name | Unknown |  |
| email_on_welcome | Unknown |  |
| expiring_url | Unknown |  |
| extension | Unknown |  |
| file_content_type | Unknown |  |
| friendly_type | Unknown |  |
| include_in_charting | Unknown |  |
| internal_notes | Unknown |  |
| shared | Unknown |  |
| shared_on_welcome | Unknown |  |
| shared_user_groups_count | Unknown |  |
| shared_users_count | Unknown |  |
| shared_with_dietitian | Unknown |  |
| updated_at | Unknown |  |

### journal_entry_meal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_entry_id | Unknown | PK, FK |
| name | Unknown |  |

### journal_entry_sub_entry_meal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_entry_id | Unknown | PK, FK |
| journal_entry_sub_entry_id | Unknown | PK, FK |
| name | Unknown |  |

### journal_entry_sub_entry_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_entry_id | Unknown | PK, FK |
| journal_entry_sub_entry_id | Unknown | PK, FK |
| author_id | Unknown | FK |
| creator_id | Unknown | FK |
| poster_id | Unknown | FK |
| user_id | Unknown | FK |
| content | Unknown |  |
| created_at | Unknown |  |
| is_reaction | Unknown |  |

### journal_entry_sub_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_entry_id | Unknown | PK, FK |
| added_by_user_id | Unknown | FK |
| poster_id | Unknown | FK |
| category | Unknown |  |
| created_at | Unknown |  |
| default_water_intake_for_entry_user | Unknown |  |
| description | Unknown |  |
| ed_posthunger | Unknown |  |
| ed_prehunger | Unknown |  |
| emotion | Unknown |  |
| entries_in_average | Unknown |  |
| external_id | Unknown |  |
| external_id_type | Unknown |  |
| healthiness_info_hex_value | Unknown |  |
| hide_from_main_feed | Unknown |  |
| image | Unknown |  |
| image_url | Unknown |  |
| metric_stat | Unknown |  |
| name | Unknown |  |
| other_symptom | Unknown |  |
| percieved_hungriness | Unknown |  |
| previous_water_intake_stat | Unknown |  |
| reflection | Unknown |  |
| source | Unknown |  |
| symptom | Unknown |  |
| symptom_name | Unknown |  |
| third_party_source | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| viewed | Unknown |  |

### journal_entry_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_entry_id | Unknown | PK, FK |
| author_id | Unknown | FK |
| creator_id | Unknown | FK |
| poster_id | Unknown | FK |
| user_id | Unknown | FK |
| content | Unknown |  |
| created_at | Unknown |  |
| is_reaction | Unknown |  |

### journal_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| added_by_user_id | Unknown | FK |
| poster_id | Unknown | FK |
| category | Unknown |  |
| created_at | Unknown |  |
| default_water_intake_for_entry_user | Unknown |  |
| description | Unknown |  |
| ed_posthunger | Unknown |  |
| ed_prehunger | Unknown |  |
| emotion | Unknown |  |
| entries_in_average | Unknown |  |
| external_id | Unknown |  |
| external_id_type | Unknown |  |
| has_subentry | Unknown |  |
| healthiness_info_hex_value | Unknown |  |
| hide_from_main_feed | Unknown |  |
| image | Unknown |  |
| image_url | Unknown |  |
| metric_stat | Unknown |  |
| name | Unknown |  |
| other_symptom | Unknown |  |
| percieved_hungriness | Unknown |  |
| previous_water_intake_stat | Unknown |  |
| reflection | Unknown |  |
| source | Unknown |  |
| symptom | Unknown |  |
| symptom_name | Unknown |  |
| third_party_source | Unknown |  |
| type | Unknown |  |
| updated_at | LocalDateTime |  |
| viewed | Unknown |  |

### form_template_custom_module

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_template_id | Unknown | PK, FK |
| parent_custom_module_id | Unknown | FK |
| controls_conditional_module | Unknown |  |
| copied_from_form_name | Unknown |  |
| custom_module_condition_conditional_custom_module_id | Unknown |  |
| custom_module_condition_filter_type | Unknown |  |
| custom_module_condition_id | Unknown |  |
| custom_module_condition_value_to_filter | Unknown |  |
| custom_module_form_section_id | Unknown |  |
| external_id | Unknown |  |
| external_id_type | Unknown |  |
| hipaa_name | Unknown |  |
| is_custom | Unknown |  |
| label | Unknown |  |
| mod_type | Unknown |  |
| option | Unknown |  |
| options_array | Json |  |
| other_module_ids_to_autoscore_on | Unknown |  |
| position | Unknown |  |
| required | Unknown |  |
| sublabel | Unknown |  |

### form_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| last_updated_user_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| cursor | Unknown |  |
| external_id | Unknown |  |
| external_id_type | Unknown |  |
| has_matrix_field | Unknown |  |
| has_non_readonly_module | Unknown |  |
| is_video | Unknown |  |
| metadata | Unknown |  |
| name | Unknown |  |
| prefill | Unknown |  |
| updated_at | LocalDateTime |  |
| uploaded_by_healthie_team | Unknown |  |
| use_for_charting | Unknown |  |
| use_for_program | Unknown |  |

### billing_item_charge_back

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_item_id | Unknown | PK, FK |
| created_at | Unknown |  |
| disputed_amount | Unknown |  |
| evidence_billing_address | Unknown |  |
| evidence_cancellation_policy | Unknown |  |
| evidence_cancellation_policy_disclosure | Unknown |  |
| evidence_cancellation_rebuttal | Unknown |  |
| evidence_customer_communication | Unknown |  |
| evidence_customer_email_address | Unknown |  |
| evidence_customer_name | Unknown |  |
| evidence_fields_to_submit | Unknown |  |
| evidence_product_description | Unknown |  |
| evidence_refund_policy | Unknown |  |
| evidence_refund_policy_disclosure | Unknown |  |
| evidence_refund_refusal_explanation | Unknown |  |
| evidence_uncategorized_file | Unknown |  |
| evidence_uncategorized_text | Unknown |  |
| fee | Unknown |  |
| formatted_reason | Unknown |  |
| formatted_status | Unknown |  |
| reason | Unknown |  |
| response_required_by | Unknown |  |
| status | Unknown |  |
| total_amount | Unknown |  |
| updated_at | Unknown |  |

### billing_item_refund_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_item_id | Unknown | PK, FK |
| currency | Unknown |  |
| refund_amount | Unknown |  |
| refund_date | Unknown |  |
| status | Unknown |  |

### billing_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| provider_id | Unknown | FK |
| recipient_id | Unknown | FK |
| recurring_payment_appointment_id | Unknown | FK |
| recurring_payment_last_billing_item_id | Unknown | FK |
| recurring_payment_paused_by_id | Unknown | FK |
| requested_payment_id | Unknown | FK |
| successful_retried_payment_id | Unknown | FK |
| amount_paid | Unknown |  |
| application_fee_amount | Unknown |  |
| card_source | Unknown |  |
| coupon_code | Unknown |  |
| cpt_codes_super_bills_id | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| cursor | Unknown |  |
| deleted_at | Unknown |  |
| failure_reason | Unknown |  |
| gifted_by | Unknown |  |
| gifted_to | Unknown |  |
| is_canceled | Unknown |  |
| is_recurring | Unknown |  |
| item_position_number | Unknown |  |
| net_payment | Unknown |  |
| next_scheduled_payment_amount | Unknown |  |
| note | Unknown |  |
| offering_coupon_id | Unknown |  |
| offering_id | Unknown |  |
| original_price | Unknown |  |
| payment_medium | Unknown |  |
| receipt_last_sent_at | Unknown |  |
| recurring_payment_amount_paid | Unknown |  |
| recurring_payment_amount_to_pay | Unknown |  |
| recurring_payment_billing_frequency | Unknown |  |
| recurring_payment_billing_items_count | Unknown |  |
| recurring_payment_canceled_at | Unknown |  |
| recurring_payment_canceled_by_id | Unknown |  |
| recurring_payment_created_at | Unknown |  |
| recurring_payment_has_next_payment_date | Unknown |  |
| recurring_payment_has_scheduled_billing_item | Unknown |  |
| recurring_payment_id | Unknown |  |
| recurring_payment_is_canceled | Unknown |  |
| recurring_payment_is_paused | Unknown |  |
| recurring_payment_next_payment_date | Unknown |  |
| recurring_payment_next_restart_payment_date | Unknown |  |
| recurring_payment_offering_coupon_id | Unknown |  |
| recurring_payment_offering_id | Unknown |  |
| recurring_payment_original_price | Unknown |  |
| recurring_payment_paused_at | Unknown |  |
| recurring_payment_payments_remaining | Unknown |  |
| recurring_payment_recipient_id | Unknown |  |
| recurring_payment_repeat_times | Unknown |  |
| recurring_payment_sender_id | Unknown |  |
| recurring_payment_start_at | Unknown |  |
| recurring_payment_updated_at | Unknown |  |
| refund_amount | Unknown |  |
| refund_date | Unknown |  |
| requested_payer_address | Unknown |  |
| requested_payer_email | Unknown |  |
| requested_payer_id | Unknown |  |
| requested_payer_name | Unknown |  |
| sender_id | Unknown |  |
| shown_description | Unknown |  |
| shown_note | Unknown |  |
| state | Unknown |  |
| stripe_charge_id | Unknown |  |
| stripe_error | Unknown |  |
| updated_at | LocalDateTime |  |
| user_package_selection_id | Unknown |  |

### appointment_assigned_group

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

### appointment_attended_client

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| attended | Unknown |  |
| cancelled | Unknown |  |
| confirmed | Unknown |  |
| external_uuid | Unknown |  |
| join_time | Unknown |  |
| leave_time | Unknown |  |

### appointment_attendee

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

### appointment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_type_id | Unknown | FK |
| conversation_id | Unknown | FK |
| filled_embed_form_id | Unknown | FK |
| form_answer_group_id | Unknown | FK |
| initiator_id | Unknown | FK |
| provider_id | Unknown | FK |
| requested_payment_id | Unknown | FK |
| user_id | Unknown | FK |
| actual_duration | Unknown |  |
| add_to_gcal_link | Unknown |  |
| appointment_category | Unknown |  |
| appointment_inclusions_count | Unknown |  |
| appointment_label | Unknown |  |
| appointment_location_id | Unknown |  |
| background_color | Unknown |  |
| can_be_rescheduled | Unknown |  |
| can_client_cancel | Unknown |  |
| can_client_reschedule | Unknown |  |
| client_confirmed | Unknown |  |
| client_updating | Unknown |  |
| confirmed | Unknown |  |
| connected_chart_note_locked | Unknown |  |
| connected_chart_note_string | Unknown |  |
| contact_type | Unknown |  |
| created_at | Unknown |  |
| current_position_in_recurring_series | Unknown |  |
| cursor | Unknown |  |
| date | Unknown |  |
| default_color | Unknown |  |
| deleted_at | Unknown |  |
| end_date | Unknown |  |
| external_id_type | Unknown |  |
| external_videochat_url | Unknown |  |
| has_expanded_vbc_charting_fields | Unknown |  |
| has_in_progress_job | Unknown |  |
| is_blocker | Unknown |  |
| is_group | Unknown |  |
| is_zoom_chat | Unknown |  |
| last_client_conversation_id | Unknown |  |
| last_updated_by_id | Unknown |  |
| length | Unknown |  |
| location | Unknown |  |
| location_resource | Unknown |  |
| max_attendees | Unknown |  |
| metadata | Unknown |  |
| minimum_advance_cancel_time | Unknown |  |
| minimum_advance_reschedule_time | Unknown |  |
| notes | Unknown |  |
| other_party_id | Unknown |  |
| patient_reschedule_count | Unknown |  |
| pm_status | Unknown |  |
| pm_status_changed_at | Unknown |  |
| pm_status_last_changed_by_id | Unknown |  |
| pricing_info_cpt_code_id | Unknown |  |
| pricing_info_price | Unknown |  |
| pricing_info_units | Unknown |  |
| provider_name | Unknown |  |
| reason | Unknown |  |
| recurring_appointment_id | Unknown |  |
| repeat | Unknown |  |
| repeat_interval | Unknown |  |
| repeat_times | Unknown |  |
| resource_id | Unknown |  |
| room_id | Unknown |  |
| scheduled_by | Unknown |  |
| session_id | Unknown |  |
| should_create_cms_1500_for_occurred_appointments | Unknown |  |
| start_date | Unknown |  |
| text_color | Unknown |  |
| time_recurring_override | Unknown |  |
| timezone_abbreviation | Unknown |  |
| title | Unknown |  |
| unauthenticated_ics_link | Unknown |  |
| updated_at | LocalDateTime |  |
| use_zoom | Unknown |  |
| zoom_cloud_recording_urls | Json |  |
| zoom_dial_in_info | Unknown |  |
| zoom_dial_in_info_html | Unknown |  |
| zoom_dial_in_numbers | Json |  |
| zoom_join_url | Unknown |  |
| zoom_meeting_id | Unknown |  |
| zoom_start_url | Unknown |  |

### care_plan_document

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

### care_plan_goal

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

### care_plan_recommendation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| care_plan_id | Unknown | PK, FK |
| recommendation_body | Unknown |  |
| recommendation_type | Unknown |  |
| sanitized_body | Unknown |  |

### care_plan_feature_toggle_custom_metrics

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| care_plan_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| high_warning_threshold | Unknown |  |
| low_warning_threshold | Unknown |  |
| name | Unknown |  |
| should_show | Unknown |  |
| should_show_client | Unknown |  |
| show | Unknown |  |
| show_client | Unknown |  |
| track | Unknown |  |

### care_plan_feature_toggle_initial_custom_metrics_override

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| care_plan_id | Unknown | PK, FK |
| custom_metric_id | Unknown | FK |
| form_id | Unknown | FK |
| user_id | Unknown | FK |
| name | Unknown |  |
| show | Unknown |  |
| show_client | Unknown |  |
| track | Unknown |  |

### care_plan_feature_toggle_metric_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| care_plan_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| high_warning_threshold | Unknown |  |
| low_warning_threshold | Unknown |  |
| name | Unknown |  |
| should_show | Unknown |  |
| should_show_client | Unknown |  |
| show | Unknown |  |
| show_client | Unknown |  |
| track | Unknown |  |

### care_plan_feature_toggle_symptom_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| care_plan_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### care_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| patient_id | Unknown | FK |
| user_group_id | Unknown | FK |
| assigned_to | Unknown |  |
| created_at | LocalDateTime |  |
| cursor | Unknown |  |
| description | Unknown |  |
| feature_toggle_activity_level | Unknown |  |
| feature_toggle_allow_apple_health_sync | Unknown |  |
| feature_toggle_allow_clearstep_sync | Unknown |  |
| feature_toggle_allow_community_chat | Unknown |  |
| feature_toggle_allow_dexcom_sync | Unknown |  |
| feature_toggle_allow_direct_chat | Unknown |  |
| feature_toggle_allow_fitbit_sync | Unknown |  |
| feature_toggle_allow_google_fit_sync | Unknown |  |
| feature_toggle_allow_shapa_sync | Unknown |  |
| feature_toggle_allow_withings_sync | Unknown |  |
| feature_toggle_apply_eating_disorder_default | Unknown |  |
| feature_toggle_can_schedule_appointment | Unknown |  |
| feature_toggle_can_track_poop | Unknown |  |
| feature_toggle_can_track_symptom | Unknown |  |
| feature_toggle_can_track_water_intake | Unknown |  |
| feature_toggle_can_view_care_plan | Unknown |  |
| feature_toggle_can_view_document | Unknown |  |
| feature_toggle_can_view_form | Unknown |  |
| feature_toggle_can_view_goal | Unknown |  |
| feature_toggle_can_view_journal_entry | Unknown |  |
| feature_toggle_can_view_package | Unknown |  |
| feature_toggle_can_view_payment | Unknown |  |
| feature_toggle_can_view_program | Unknown |  |
| feature_toggle_created_at | Unknown |  |
| feature_toggle_date_range_preference | Unknown |  |
| feature_toggle_default_water_intake | Unknown |  |
| feature_toggle_do_not_auto_submit_cms_1500 | Unknown |  |
| feature_toggle_email_notification_frequency | Unknown |  |
| feature_toggle_food_categories | Unknown |  |
| feature_toggle_has_any_entry_types | Unknown |  |
| feature_toggle_has_ccda | Unknown |  |
| feature_toggle_id | Unknown |  |
| feature_toggle_last_journal_date_range_preference | Unknown |  |
| feature_toggle_last_journal_from_date | Unknown |  |
| feature_toggle_last_journal_to_date | Unknown |  |
| feature_toggle_line_graph_metric_category | Json |  |
| feature_toggle_line_graph_sleep_category | Json |  |
| feature_toggle_metric_category | Json |  |
| feature_toggle_mirror_category | Json |  |
| feature_toggle_push_notification_frequency | Unknown |  |
| feature_toggle_returned_custom_metrics | Json |  |
| feature_toggle_send_unpaid_invoice_reminder | Unknown |  |
| feature_toggle_seperate_provider_metric_from_client | Unknown |  |
| feature_toggle_show_a_1_c_metric | Unknown |  |
| feature_toggle_show_bf_percent_metric | Unknown |  |
| feature_toggle_show_blood_pressure_metric | Unknown |  |
| feature_toggle_show_blood_sugar_metric | Unknown |  |
| feature_toggle_show_bmi_graph | Unknown |  |
| feature_toggle_show_bmi_growth_chart | Unknown |  |
| feature_toggle_show_bmr_metric | Unknown |  |
| feature_toggle_show_body_temperature_metric | Unknown |  |
| feature_toggle_show_client_a_1_c_metric | Unknown |  |
| feature_toggle_show_client_bf_percent_metric | Unknown |  |
| feature_toggle_show_client_blood_pressure_metric | Unknown |  |
| feature_toggle_show_client_blood_sugar_metric | Unknown |  |
| feature_toggle_show_client_bmi_graph | Unknown |  |
| feature_toggle_show_client_bmi_growth_chart | Unknown |  |
| feature_toggle_show_client_bmr_metric | Unknown |  |
| feature_toggle_show_client_body_temperature_metric | Unknown |  |
| feature_toggle_show_client_harris_benedict | Unknown |  |
| feature_toggle_show_client_height_growth_chart | Unknown |  |
| feature_toggle_show_client_ox_sat_metric | Unknown |  |
| feature_toggle_show_client_waist_circumference_metric | Unknown |  |
| feature_toggle_show_client_weight_growth_chart | Unknown |  |
| feature_toggle_show_client_weight_metric | Unknown |  |
| feature_toggle_show_ed_posthunger | Unknown |  |
| feature_toggle_show_ed_prehunger | Unknown |  |
| feature_toggle_show_food | Unknown |  |
| feature_toggle_show_food_category | Unknown |  |
| feature_toggle_show_food_emotion | Unknown |  |
| feature_toggle_show_food_reflection | Unknown |  |
| feature_toggle_show_harris_benedict | Unknown |  |
| feature_toggle_show_healthiness | Unknown |  |
| feature_toggle_show_height_graph | Unknown |  |
| feature_toggle_show_height_growth_chart | Unknown |  |
| feature_toggle_show_metric | Unknown |  |
| feature_toggle_show_mirror | Unknown |  |
| feature_toggle_show_normal_hunger | Unknown |  |
| feature_toggle_show_note | Unknown |  |
| feature_toggle_show_note_emotion | Unknown |  |
| feature_toggle_show_nutrients_tracking | Unknown |  |
| feature_toggle_show_ox_sat_metric | Unknown |  |
| feature_toggle_show_sleep | Unknown |  |
| feature_toggle_show_waist_circumference_metric | Unknown |  |
| feature_toggle_show_weight_growth_chart | Unknown |  |
| feature_toggle_show_weight_metric | Unknown |  |
| feature_toggle_show_workout | Unknown |  |
| feature_toggle_use_metric_system | Unknown |  |
| feature_toggle_user_group_id | Unknown |  |
| feature_toggle_user_id | Unknown |  |
| feature_toggle_uses_feature_toggle_from_care_plan | Unknown |  |
| feature_toggle_view_not_track | Unknown |  |
| feature_toggle_workout_category | Json |  |
| group_plan_is_active_for_given_user | Unknown |  |
| has_users_with_real_emails | Unknown |  |
| is_active | Unknown |  |
| is_group | Unknown |  |
| is_hidden | Unknown |  |
| is_template | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| closed_by_id | Unknown | FK |
| dietitian_id | Unknown | FK |
| owner_id | Unknown | FK |
| patient_id | Unknown | FK |
| user_group_id | Unknown | FK |
| closed_date | Unknown |  |
| community_chat | Unknown |  |
| community_chat_prefix | Unknown |  |
| created_at | Unknown |  |
| includes_multiple_clients | Unknown |  |
| is_hidden_for_client | Unknown |  |
| last_message_content | Unknown |  |
| last_note_viewed_id | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### user_group_patient_list

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

### user_group_users_with_membership

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

### user_group_recurring_form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_group_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| custom_module_form_id | Unknown |  |
| form_id | Unknown |  |
| form_type | Unknown |  |
| has_connected_recipient | Unknown |  |
| interval | Unknown |  |
| interval_type | Unknown |  |
| is_active | Unknown |  |
| recurrence_end_at | Unknown |  |
| users_and_groups | Unknown |  |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | LocalDateTime |  |
| doc_share_id | Unknown |  |
| invite_code | Unknown |  |
| name | Unknown |  |
| onboarding_flow_id | Unknown |  |

### insurance_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_payer_location_user_id | Unknown | FK |
| user_id | Unknown | FK |
| change_healthcare_eligibility_payer_id | Unknown |  |
| change_healthcare_payer_id | Unknown |  |
| default_payer_location_city | Unknown |  |
| default_payer_location_country | Unknown |  |
| default_payer_location_id | Unknown |  |
| default_payer_location_line_1 | Unknown |  |
| default_payer_location_line_2 | Unknown |  |
| default_payer_location_name | Unknown |  |
| default_payer_location_npi | Unknown |  |
| default_payer_location_other_id | Unknown |  |
| default_payer_location_other_id_qual | Unknown |  |
| default_payer_location_place_of_service_code | Unknown |  |
| default_payer_location_place_of_service_code_name | Unknown |  |
| default_payer_location_place_of_service_id | Unknown |  |
| default_payer_location_place_of_service_name | Unknown |  |
| default_payer_location_state | Unknown |  |
| default_payer_location_to_oneline | Unknown |  |
| default_payer_location_zip | Unknown |  |
| is_accepted | Unknown |  |
| name_and_id | Unknown |  |
| payer_id | Unknown |  |
| payer_name | Unknown |  |

### cpt_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| created_at | Unknown |  |
| cursor | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| is_favorite | Unknown |  |
| last_fee | Unknown |  |
| updated_at | Unknown |  |

### active_patient

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

### user_policy_claim_eligibility_check

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_policy_id | Unknown | PK, FK |
| code | Unknown |  |
| description | Unknown |  |

### user_policy_cpt_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_policy_id | Unknown | PK, FK |
| code | Unknown |  |
| cpt_code_id | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| updated_at | Unknown |  |

### user_policy_icd_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_policy_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| icd_code_id | Unknown |  |
| updated_at | Unknown |  |

### user_policy_benefit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_policy_id | Unknown | PK, FK |
| category | Unknown |  |
| coinsurance | Unknown |  |
| copay | Unknown |  |
| deductible_calendar_year | Unknown |  |
| deductible_year_to_date | Unknown |  |
| telemedicine | Unknown |  |

### user_policy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| insurance_plan_id | Unknown | FK |
| call_reference_date_recorded | Unknown |  |
| call_reference_id | Unknown |  |
| call_reference_notes | Unknown |  |
| call_reference_reference_number | Unknown |  |
| call_reference_time_recorded | Unknown |  |
| call_reference_user_id | Unknown |  |
| coinsurance_value | Unknown |  |
| copay_value | Unknown |  |
| dob_to_use | Unknown |  |
| effective_end | Unknown |  |
| effective_start | Unknown |  |
| group_num | Unknown |  |
| holder_address | Unknown |  |
| holder_dob | Unknown |  |
| holder_first | Unknown |  |
| holder_gender | Unknown |  |
| holder_last | Unknown |  |
| holder_location_city | Unknown |  |
| holder_location_country | Unknown |  |
| holder_location_cursor | Unknown |  |
| holder_location_id | Unknown |  |
| holder_location_line_1 | Unknown |  |
| holder_location_line_2 | Unknown |  |
| holder_location_name | Unknown |  |
| holder_location_npi | Unknown |  |
| holder_location_other_id | Unknown |  |
| holder_location_other_id_qual | Unknown |  |
| holder_location_place_of_service_id | Unknown |  |
| holder_location_state | Unknown |  |
| holder_location_to_oneline | Unknown |  |
| holder_location_user_id | Unknown |  |
| holder_location_zip | Unknown |  |
| holder_mi | Unknown |  |
| holder_name | Unknown |  |
| holder_phone | Unknown |  |
| holder_relationship | Unknown |  |
| insurance_authorization_authorization_number | Unknown |  |
| insurance_authorization_end_on | Unknown |  |
| insurance_authorization_id | Unknown |  |
| insurance_authorization_required | Unknown |  |
| insurance_authorization_start_on | Unknown |  |
| insurance_authorization_unit_type | Unknown |  |
| insurance_authorization_units_authorized | Unknown |  |
| insurance_authorization_units_left | Unknown |  |
| insurance_authorization_units_limit_per_visit | Unknown |  |
| insurance_authorization_units_used | Unknown |  |
| insurance_authorization_updated_at | Unknown |  |
| insurance_authorization_user_id | Unknown |  |
| insurance_authorization_visits_authorized | Unknown |  |
| insurance_authorization_visits_left | Unknown |  |
| insurance_authorization_visits_used | Unknown |  |
| insurance_billing_method | Unknown |  |
| insurance_card_back_id | Unknown |  |
| insurance_card_front_id | Unknown |  |
| latest_eligibility_check_created_at | Unknown |  |
| latest_eligibility_check_id | Unknown |  |
| latest_eligibility_check_policy_id | Unknown |  |
| latest_eligibility_check_response | Unknown |  |
| latest_eligibility_check_response_as_html | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| num | Unknown |  |
| payer_location_city | Unknown |  |
| payer_location_country | Unknown |  |
| payer_location_cursor | Unknown |  |
| payer_location_id | Unknown |  |
| payer_location_line_1 | Unknown |  |
| payer_location_line_2 | Unknown |  |
| payer_location_name | Unknown |  |
| payer_location_npi | Unknown |  |
| payer_location_other_id | Unknown |  |
| payer_location_other_id_qual | Unknown |  |
| payer_location_place_of_service_id | Unknown |  |
| payer_location_state | Unknown |  |
| payer_location_to_oneline | Unknown |  |
| payer_location_user_id | Unknown |  |
| payer_location_zip | Unknown |  |
| policy_phone_number | Unknown |  |
| priority_type | Unknown |  |
| referral_created_at | Unknown |  |
| referral_id | Unknown |  |
| referral_metadata | Unknown |  |
| referral_referral_reason | Unknown |  |
| referral_referring_physician_id | Unknown |  |
| referral_required | Unknown |  |
| referral_updated_at | Unknown |  |
| referral_user_id | Unknown |  |
| same_address_as_client | Unknown |  |
| type_string | Unknown |  |
| updated_at | Unknown |  |

### user_additional_sidebar_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| icon | Unknown |  |
| label | Unknown |  |
| open_in_iframe | Unknown |  |
| show | Unknown |  |
| svg_url | Unknown |  |
| target | Unknown |  |
| url | Unknown |  |

### user_appointment_type_credit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| appointment_type_id | Unknown | FK |
| form_id | Unknown |  |
| id | Unknown |  |
| quantity | Unknown |  |

### user_state_license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| full_state_name | Unknown |  |
| state | Unknown |  |

### user_other_id

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| label | Unknown |  |
| organization_id | Unknown |  |
| other_id | Unknown |  |
| other_id_qualifier | Unknown |  |

### user_call_reference

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| date_recorded | Unknown |  |
| notes | Unknown |  |
| reference_number | Unknown |  |
| time_recorded | Unknown |  |

### user_custom_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email_type | Unknown |  |
| greeting | Unknown |  |
| message_body | Unknown |  |
| name | Unknown |  |
| reactivation_wait_days | Unknown |  |
| subject | Unknown |  |
| updated_at | Unknown |  |

### user_diagnosis

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| icd_code_id | Unknown | FK |
| active | Unknown |  |
| custom_module_id | Unknown |  |
| end_date | Unknown |  |
| first_symptom_date | Unknown |  |
| icd_codes_cms_1500_s_id | Unknown |  |
| icd_codes_super_bill_id | Unknown |  |
| is_primary | Unknown |  |
| updated_at | Unknown |  |

### user_care_team_provider_id

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

### user_upcoming_appointment

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

### user_next_appointment

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

### user_profession

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| profession | Unknown |  |
| profession_category | Unknown |  |

### user_provider

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

### user_referral

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| created_at | Unknown |  |
| id | Unknown |  |
| referral_reason | Unknown |  |
| referring_physician_accepts_insurance | Unknown |  |
| referring_physician_business_name | Unknown |  |
| referring_physician_created_at | Unknown |  |
| referring_physician_email | Unknown |  |
| referring_physician_fax_number | Unknown |  |
| referring_physician_first_name | Unknown |  |
| referring_physician_full_name | Unknown |  |
| referring_physician_id | Unknown |  |
| referring_physician_last_name | Unknown |  |
| referring_physician_location | Json |  |
| referring_physician_notes | Unknown |  |
| referring_physician_npi | Unknown |  |
| referring_physician_other_id | Unknown |  |
| referring_physician_other_id_qualifier | Unknown |  |
| referring_physician_phone_number | Unknown |  |
| referring_physician_referrals_count | Unknown |  |
| referring_physician_speciality | Unknown |  |
| referring_physician_updated_at | Unknown |  |
| referring_physician_website | Unknown |  |
| updated_at | Unknown |  |

### user_other_organization_member

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

### stripe_customer_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| bank_type | Unknown |  |
| card_type | Unknown |  |
| card_type_label | Unknown |  |
| country | Unknown |  |
| expiration | Unknown |  |
| expiring_next_month | Unknown |  |
| last_four | Unknown |  |
| source_status | Unknown |  |
| source_type | Unknown |  |
| stripe_id | Unknown |  |
| zip | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dietitian_id | Unknown | FK |
| user_group_id | Unknown | FK |
| active | Unknown |  |
| active_patients_count | Unknown |  |
| age | Unknown |  |
| any_incomplete_onboarding_steps | Unknown |  |
| any_shared_documents | Unknown |  |
| archived_at | Unknown |  |
| assign_tasks_seen | Unknown |  |
| blast_seen | Unknown |  |
| calendar_timezone | Unknown |  |
| can_see_insurance_authorization | Unknown |  |
| card_issues_count | Unknown |  |
| client_related_insurance_change_healthcare_eligibility_payer_id | Unknown |  |
| client_related_insurance_change_healthcare_payer_id | Unknown |  |
| client_related_insurance_default_payer_location_id | Unknown |  |
| client_related_insurance_id | Unknown |  |
| client_related_insurance_is_accepted | Unknown |  |
| client_related_insurance_name_and_id | Unknown |  |
| client_related_insurance_payer_id | Unknown |  |
| client_related_insurance_payer_name | Unknown |  |
| client_related_object_full_name | Unknown |  |
| client_related_object_id | Unknown |  |
| client_source_id | Unknown |  |
| client_source_readable_source | Unknown |  |
| client_source_ref_source | Unknown |  |
| client_source_ref_source_other | Unknown |  |
| client_source_ref_type | Unknown |  |
| client_source_related_object_name | Unknown |  |
| created_at | Unknown |  |
| credit_balance | Unknown |  |
| cursor | Unknown |  |
| date_of_birth | Unknown |  |
| default_onboarding_flow_id | Unknown |  |
| default_pharmacy_city | Unknown |  |
| default_pharmacy_id | Unknown |  |
| default_pharmacy_latitude | Unknown |  |
| default_pharmacy_line_1 | Unknown |  |
| default_pharmacy_line_2 | Unknown |  |
| default_pharmacy_longitude | Unknown |  |
| default_pharmacy_name | Unknown |  |
| default_pharmacy_phone_number | Unknown |  |
| default_pharmacy_state | Unknown |  |
| default_pharmacy_zip | Unknown |  |
| default_stripe_customer_detail_id | Unknown |  |
| doc_share_id | Unknown |  |
| dosespot_notification_count | Unknown |  |
| email | Unknown |  |
| expired_client_cards_count | Unknown |  |
| expiring_client_cards_count | Unknown |  |
| first_client_entry_date | Unknown |  |
| first_name | Unknown |  |
| first_name_last_initial | Unknown |  |
| full_legal_name | Unknown |  |
| full_legal_name_with_preferred | Unknown |  |
| full_name | Unknown |  |
| gender | Unknown |  |
| gender_identity | Unknown |  |
| goals_count | Unknown |  |
| group_name | Unknown |  |
| has_completed_intake_forms | Unknown |  |
| has_future_availabilities | Unknown |  |
| has_insurance_pay | Unknown |  |
| has_invalid_dosespot_info | Unknown |  |
| has_user_groups | Unknown |  |
| insurance_authorization_number | Unknown |  |
| insurance_chart_info_earliest_date_title | Unknown |  |
| insurance_chart_info_earliest_date_value | Unknown |  |
| insurance_chart_info_latest_date_title | Unknown |  |
| insurance_chart_info_latest_date_value | Unknown |  |
| insurance_chart_info_left_section_width | Unknown |  |
| insurance_chart_info_middle_date_title | Unknown |  |
| insurance_chart_info_middle_date_value | Unknown |  |
| insurance_chart_info_right_section_width | Unknown |  |
| insurance_end_on | Unknown |  |
| insurance_id | Unknown |  |
| insurance_start_on | Unknown |  |
| insurance_unit_type | Unknown |  |
| insurance_units_authorized | Unknown |  |
| insurance_units_left | Unknown |  |
| insurance_units_limit_per_visit | Unknown |  |
| insurance_units_used | Unknown |  |
| insurance_updated_at | Unknown |  |
| insurance_user_id | Unknown |  |
| insurance_visits_authorized | Unknown |  |
| insurance_visits_left | Unknown |  |
| insurance_visits_used | Unknown |  |
| is_active_provider | Unknown |  |
| is_first_time_provider | Unknown |  |
| is_org | Unknown |  |
| is_owner | Unknown |  |
| is_patient | Unknown |  |
| is_super_admin | Unknown |  |
| last_active | Unknown |  |
| last_activity | Unknown |  |
| last_name | Unknown |  |
| last_sign_in_at | Unknown |  |
| legal_name | Unknown |  |
| license_num | Unknown |  |
| linked_relatives | Json |  |
| medications_count | Unknown |  |
| money_owed | Unknown |  |
| name | Unknown |  |
| next_appt_date | Unknown |  |
| next_onboarding_step_id | Unknown |  |
| next_required_step | Unknown |  |
| npi | Unknown |  |
| onc_gender_identity | Unknown |  |
| organization_id | Unknown |  |
| organization_membership_id | Unknown |  |
| patients_count | Unknown |  |
| phone_number | Unknown |  |
| preferred_language | Unknown |  |
| prescriptions_count | Unknown |  |
| primary_ethnicity | Unknown |  |
| primary_ethnicity_code | Unknown |  |
| primary_race | Unknown |  |
| primary_race_code | Unknown |  |
| pronouns | Unknown |  |
| quick_notes | Unknown |  |
| record_identifier | Unknown |  |
| referring_provider_id | Unknown |  |
| referring_provider_name | Unknown |  |
| referring_provider_npi | Unknown |  |
| sex | Unknown |  |
| sexual_orientation | Unknown |  |
| sexual_orientation_code | Unknown |  |
| skipped_bank_account | Unknown |  |
| stripe_id | Unknown |  |
| stripe_person_id | Unknown |  |
| subscription | Json |  |
| super_bill_address | Unknown |  |
| tasks_count | Unknown |  |
| timezone | Unknown |  |
| updated_at | LocalDateTime |  |
| user_location_id | Unknown |  |

### metric_data_point

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| created_at | Unknown |  |
| entry_id | Unknown |  |
| flex_value | Unknown |  |
| value | Unknown |  |

### metric_data

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| category | Unknown |  |
| category_label | Unknown |  |
| has_entry | Unknown |  |
| max | Unknown |  |
| min | Unknown |  |
| xtick_type | Unknown |  |
| ytick_type | Unknown |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_id | Unknown | FK |
| creator_id | Unknown | FK |
| document_id | Unknown | FK |
| recipient_id | Unknown | FK |
| user_id | Unknown | FK |
| attached_audio_url | Unknown |  |
| attached_image_url | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| creator_display_name | Unknown |  |
| cursor | Unknown |  |
| deleted_by_user | Unknown |  |
| document_name | Unknown |  |
| image_name | Unknown |  |
| is_autoresponse | Unknown |  |
| on_behalf_user_id | Unknown |  |
| scheduled_at | Unknown |  |
| scheduled_conversation_id | Unknown |  |
| task_id | Unknown |  |
| updated_at | Unknown |  |
| viewed | Unknown |  |

### conversation_invitee

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

### conversation_note

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

### conversation_membership

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_id | Unknown | FK |
| creator_id | Unknown | FK |
| user_id | Unknown | FK |
| archived | Unknown |  |
| conversation_role | Unknown |  |
| created_at | Unknown |  |
| cursor | Unknown |  |
| display_avatar | Unknown |  |
| display_name | Unknown |  |
| display_name_and_initial | Unknown |  |
| display_other_user_first_name | Unknown |  |
| display_other_user_name | Unknown |  |
| last_task_id | Unknown |  |
| updated_at | LocalDateTime |  |
| user_list_as_display_name | Unknown |  |
| viewed | Unknown |  |

### requested_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | FK |
| billing_item_id | Unknown | FK |
| cms_1500_id | Unknown | FK |
| recipient_id | Unknown | FK |
| sender_id | Unknown | FK |
| cms_1500_service_date | Unknown |  |
| currency | Unknown |  |
| cursor | Unknown |  |
| date_to_show | LocalDateTime |  |
| debt | Unknown |  |
| debt_decimal | Unknown |  |
| details | Unknown |  |
| email_sent_at | Unknown |  |
| invoice_id | Unknown |  |
| invoice_type | Unknown |  |
| is_manually_paid | Unknown |  |
| is_preview | Unknown |  |
| notes | Unknown |  |
| offering_id | Unknown |  |
| other_requested_payer_address | Unknown |  |
| other_requested_payer_email | Unknown |  |
| other_requested_payer_id | Unknown |  |
| other_requested_payer_name | Unknown |  |
| paid_at | Unknown |  |
| paid_percent | Unknown |  |
| price | Unknown |  |
| requested_payer_address | Unknown |  |
| requested_payer_email | Unknown |  |
| requested_payer_id | Unknown |  |
| requested_payer_name | Unknown |  |
| requested_payment_template_active | Unknown |  |
| requested_payment_template_id | Unknown |  |
| requested_payment_template_name | Unknown |  |
| service_date | Unknown |  |
| services_provided | Unknown |  |
| status | Unknown |  |
| user_package_selection_id | Unknown |  |

### appointment_summary_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appointment_summary_fivetran_id | Unknown | PK, FK |
| count_cancelled | Unknown |  |
| count_late_cancellation | Unknown |  |
| count_no_status | Unknown |  |
| count_noshow | Unknown |  |
| count_occurred | Unknown |  |
| count_rescheduled | Unknown |  |
| date | Unknown |  |

### appointment_summary_history_provider

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appointment_summary_fivetran_id | Unknown | PK, FK |
| name | Unknown |  |

### appointment_summary_history_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appointment_summary_fivetran_id | Unknown | PK, FK |
| name | Unknown |  |

### appointment_summary_history_type_count

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appointment_summary_fivetran_id | Unknown | PK, FK |
| appointment_count | Unknown |  |
| name | Unknown |  |

### appointment_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| avg_per_day | Unknown |  |
| avg_per_day_percent_diff | Unknown |  |
| busiest_days_of_week | Json |  |
| cache_generation_in_progress | Unknown |  |
| percent_diff | Unknown |  |
| total_count | Unknown |  |

### icd_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| cursor | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| is_favorite | Unknown |  |
| updated_at | Unknown |  |

### cms_1500_cpt_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cms_1500_id | Unknown | PK, FK |
| cpt_code_id | Unknown | FK |
| created_at | Unknown |  |
| epsdt | Unknown |  |
| family_planning_service | Unknown |  |
| fee | Unknown |  |
| mod_1 | Unknown |  |
| mod_2 | Unknown |  |
| mod_3 | Unknown |  |
| mod_4 | Unknown |  |
| pointers | Json |  |
| service_date | Unknown |  |
| service_end_date | Unknown |  |
| units | Unknown |  |
| updated_at | Unknown |  |

### cms_1500_icd_code

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

### cms_1500

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_answer_group_id | Unknown | FK |
| patient_id | Unknown | FK |
| rendering_provider_id | Unknown | FK |
| accept_assignment | Unknown |  |
| additional_text | Unknown |  |
| adjustment | Unknown |  |
| amount_paid | Unknown |  |
| amount_reimbursed | Unknown |  |
| billing_provider_id | Unknown |  |
| check_numbers | Unknown |  |
| client_responsibility | Unknown |  |
| client_responsibility_removed | Unknown |  |
| client_sig_on_file | Unknown |  |
| copay | Unknown |  |
| copay_still_owed | Unknown |  |
| cpt_code_names | Unknown |  |
| created_at | LocalDateTime |  |
| date_of_service | Unknown |  |
| dietitian_id | Unknown |  |
| include_referrer_information | Unknown |  |
| insured_sig_on_file | Unknown |  |
| nineteen_reserved | Unknown |  |
| organization_info_id | Unknown |  |
| orig_ref_number | Unknown |  |
| paid_out_at | Unknown |  |
| patient_account_num | Unknown |  |
| primary_plan_name | Unknown |  |
| reasons | Unknown |  |
| referral_info_auto_accident_state | Unknown |  |
| referral_info_case_date | Unknown |  |
| referral_info_case_qualifier | Unknown |  |
| referral_info_condition_related_to | Unknown |  |
| referral_info_hospitalization_end | Unknown |  |
| referral_info_hospitalization_start | Unknown |  |
| referral_info_id | Unknown |  |
| referral_info_other_associated_date | Unknown |  |
| referral_info_other_associated_qualifier | Unknown |  |
| referral_info_prior_auth_number | Unknown |  |
| referral_info_ref_provider_first | Unknown |  |
| referral_info_ref_provider_last | Unknown |  |
| referral_info_ref_provider_middle | Unknown |  |
| referral_info_ref_provider_npi | Unknown |  |
| referral_info_ref_provider_other_id | Unknown |  |
| referral_info_ref_provider_other_id_qual | Unknown |  |
| referral_info_ref_provider_qual | Unknown |  |
| referral_info_referral_date | Unknown |  |
| referral_info_referring_physician_id | Unknown |  |
| referral_info_unable_to_work_end | Unknown |  |
| referral_info_unable_to_work_start | Unknown |  |
| reimbursed_at | Unknown |  |
| rendering_provider_other_id_object_id | Unknown |  |
| rendering_provider_other_id_object_label | Unknown |  |
| rendering_provider_other_id_object_organization_id | Unknown |  |
| rendering_provider_other_id_object_other_id | Unknown |  |
| rendering_provider_other_id_object_other_id_qualifier | Unknown |  |
| rendering_provider_other_id_object_user_id | Unknown |  |
| resubmission_code | Unknown |  |
| service_location_id | Unknown |  |
| status | Unknown |  |
| tend_reserved | Unknown |  |
| total_charge | Unknown |  |
| updated_by_sftp | Unknown |  |
| use_indiv_npi | Unknown |  |

### organization_member_additional_sidebar_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_member_id | Unknown | PK, FK |
| icon | Unknown |  |
| label | Unknown |  |
| open_in_iframe | Unknown |  |
| show | Unknown |  |
| svg_url | Unknown |  |
| target | Unknown |  |
| url | Unknown |  |

### organization_member_appointment_type_credit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_member_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| appointment_type_id | Unknown | FK |
| form_id | Unknown |  |
| id | Unknown |  |
| quantity | Unknown |  |

### organization_member_state_license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_member_id | Unknown | PK, FK |
| full_state_name | Unknown |  |
| state | Unknown |  |

### organization_member_other_id

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_member_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| label | Unknown |  |
| organization_id | Unknown |  |
| other_id | Unknown |  |
| other_id_qualifier | Unknown |  |

### organization_member_call_reference

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_member_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| date_recorded | Unknown |  |
| notes | Unknown |  |
| reference_number | Unknown |  |
| time_recorded | Unknown |  |

### organization_member_custom_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_member_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email_type | Unknown |  |
| greeting | Unknown |  |
| message_body | Unknown |  |
| name | Unknown |  |
| reactivation_wait_days | Unknown |  |
| subject | Unknown |  |
| updated_at | Unknown |  |

### organization_member_care_team_provider_id

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

### organization_member_profession

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_member_id | Unknown | PK, FK |
| profession | Unknown |  |
| profession_category | Unknown |  |

### organization_member_provider

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

### organization_member_stripe_customer_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_member_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| bank_type | Unknown |  |
| card_type | Unknown |  |
| card_type_label | Unknown |  |
| country | Unknown |  |
| expiration | Unknown |  |
| expiring_next_month | Unknown |  |
| last_four | Unknown |  |
| source_status | Unknown |  |
| source_type | Unknown |  |
| stripe_id | Unknown |  |
| zip | Unknown |  |

### organization_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dietitian_id | Unknown | FK |
| user_group_id | Unknown | FK |
| active | Unknown |  |
| active_patients_count | Unknown |  |
| any_incomplete_onboarding_steps | Unknown |  |
| any_shared_documents | Unknown |  |
| archived_at | Unknown |  |
| assign_tasks_seen | Unknown |  |
| blast_seen | Unknown |  |
| calendar_timezone | Unknown |  |
| can_see_insurance_authorization | Unknown |  |
| card_issues_count | Unknown |  |
| client_related_insurance_change_healthcare_eligibility_payer_id | Unknown |  |
| client_related_insurance_change_healthcare_payer_id | Unknown |  |
| client_related_insurance_default_payer_location_id | Unknown |  |
| client_related_insurance_id | Unknown |  |
| client_related_insurance_is_accepted | Unknown |  |
| client_related_insurance_name_and_id | Unknown |  |
| client_related_insurance_payer_id | Unknown |  |
| client_related_insurance_payer_name | Unknown |  |
| client_related_object_full_name | Unknown |  |
| client_related_object_id | Unknown |  |
| client_source_id | Unknown |  |
| client_source_readable_source | Unknown |  |
| client_source_ref_source | Unknown |  |
| client_source_ref_source_other | Unknown |  |
| client_source_ref_type | Unknown |  |
| client_source_related_object_name | Unknown |  |
| created_at | Unknown |  |
| credit_balance | Unknown |  |
| cursor | Unknown |  |
| date_of_birth | Unknown |  |
| default_onboarding_flow_id | Unknown |  |
| default_pharmacy_city | Unknown |  |
| default_pharmacy_id | Unknown |  |
| default_pharmacy_latitude | Unknown |  |
| default_pharmacy_line_1 | Unknown |  |
| default_pharmacy_line_2 | Unknown |  |
| default_pharmacy_longitude | Unknown |  |
| default_pharmacy_name | Unknown |  |
| default_pharmacy_phone_number | Unknown |  |
| default_pharmacy_state | Unknown |  |
| default_pharmacy_zip | Unknown |  |
| default_stripe_customer_detail_id | Unknown |  |
| doc_share_id | Unknown |  |
| dosespot_notification_count | Unknown |  |
| email | Unknown |  |
| expired_client_cards_count | Unknown |  |
| expiring_client_cards_count | Unknown |  |
| first_client_entry_date | Unknown |  |
| first_name | Unknown |  |
| first_name_last_initial | Unknown |  |
| full_legal_name | Unknown |  |
| full_legal_name_with_preferred | Unknown |  |
| full_name | Unknown |  |
| gender | Unknown |  |
| gender_identity | Unknown |  |
| goals_count | Unknown |  |
| group_name | Unknown |  |
| has_completed_intake_forms | Unknown |  |
| has_future_availabilities | Unknown |  |
| has_insurance_pay | Unknown |  |
| has_invalid_dosespot_info | Unknown |  |
| has_user_groups | Unknown |  |
| insurance_authorization_number | Unknown |  |
| insurance_chart_info_earliest_date_title | Unknown |  |
| insurance_chart_info_earliest_date_value | Unknown |  |
| insurance_chart_info_latest_date_title | Unknown |  |
| insurance_chart_info_latest_date_value | Unknown |  |
| insurance_chart_info_left_section_width | Unknown |  |
| insurance_chart_info_middle_date_title | Unknown |  |
| insurance_chart_info_middle_date_value | Unknown |  |
| insurance_chart_info_right_section_width | Unknown |  |
| insurance_end_on | Unknown |  |
| insurance_id | Unknown |  |
| insurance_start_on | Unknown |  |
| insurance_unit_type | Unknown |  |
| insurance_units_authorized | Unknown |  |
| insurance_units_left | Unknown |  |
| insurance_units_limit_per_visit | Unknown |  |
| insurance_units_used | Unknown |  |
| insurance_updated_at | Unknown |  |
| insurance_user_id | Unknown |  |
| insurance_visits_authorized | Unknown |  |
| insurance_visits_left | Unknown |  |
| insurance_visits_used | Unknown |  |
| is_active_provider | Unknown |  |
| is_first_time_provider | Unknown |  |
| is_org | Unknown |  |
| is_owner | Unknown |  |
| is_patient | Unknown |  |
| is_super_admin | Unknown |  |
| last_active | Unknown |  |
| last_activity | Unknown |  |
| last_name | Unknown |  |
| last_sign_in_at | Unknown |  |
| legal_name | Unknown |  |
| license_num | Unknown |  |
| medications_count | Unknown |  |
| money_owed | Unknown |  |
| name | Unknown |  |
| next_onboarding_step_id | Unknown |  |
| next_required_step | Unknown |  |
| npi | Unknown |  |
| onc_gender_identity | Unknown |  |
| organization_id | Unknown |  |
| organization_membership_id | Unknown |  |
| patients_count | Unknown |  |
| phone_number | Unknown |  |
| preferred_language | Unknown |  |
| prescriptions_count | Unknown |  |
| primary_ethnicity | Unknown |  |
| primary_ethnicity_code | Unknown |  |
| primary_race | Unknown |  |
| primary_race_code | Unknown |  |
| pronouns | Unknown |  |
| quick_notes | Unknown |  |
| record_identifier | Unknown |  |
| referring_provider_id | Unknown |  |
| referring_provider_name | Unknown |  |
| referring_provider_npi | Unknown |  |
| sex | Unknown |  |
| sexual_orientation | Unknown |  |
| sexual_orientation_code | Unknown |  |
| skipped_bank_account | Unknown |  |
| stripe_id | Unknown |  |
| stripe_person_id | Unknown |  |
| subscription | Json |  |
| super_bill_address | Unknown |  |
| tasks_count | Unknown |  |
| updated_at | LocalDateTime |  |
| user_location_id | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| cursor | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| name | Unknown |  |
| npi | Unknown |  |
| other_id | Unknown |  |
| other_id_qual | Unknown |  |
| place_of_service_code | Unknown |  |
| place_of_service_code_name | Unknown |  |
| place_of_service_id | Unknown |  |
| place_of_service_name | Unknown |  |
| state | Unknown |  |
| to_oneline | Unknown |  |
| zip | Unknown |  |

### availability

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_location_id | Unknown | FK |
| appointment_type_id | Unknown | FK |
| resource_id | Unknown | FK |
| user_id | Unknown | FK |
| contact_type_id | Unknown |  |
| created_at | Unknown |  |
| day_of_week | Unknown |  |
| duration_string | Unknown |  |
| end_on | Unknown |  |
| is_repeating | Unknown |  |
| origin_start_date | Unknown |  |
| range_end | Unknown |  |
| range_start | Unknown |  |
| repeating_availability_id | Unknown |  |
| timezone_abbr | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- appointment_type_bookable_group(id) → user_group(id)
- appointment_type_bookable_group(appointment_type_id) → appointment_type(id)
- appointment_type_form_request_after_booking(id) → form_template(id)
- appointment_type_form_request_after_booking(appointment_type_id) → appointment_type(id)
- appointment_type_form_request_after_appointment(id) → form_template(id)
- appointment_type_form_request_after_appointment(appointment_type_id) → appointment_type(id)
- appointment_type_form_request_before_appointment(id) → form_template(id)
- appointment_type_form_request_before_appointment(appointment_type_id) → appointment_type(id)
- appointment_type_setting_location(appointment_type_id) → appointment_type(id)
- appointment_type_setting_contact_type_override(form_id) → form_template(id)
- appointment_type_setting_contact_type_override(user_id) → users(id)
- appointment_type_setting_contact_type_override(appointment_type_id) → appointment_type(id)
- appointment_type_setting_calendar_color_scheme(user_id) → users(id)
- appointment_type_setting_calendar_color_scheme(appointment_type_id) → appointment_type(id)
- appointment_type_setting_calendar_color_scheme_color_code(appointment_type_id) → appointment_type(id)
- appointment_type_setting_accepted_insurance_plan(id) → insurance_plan(id)
- appointment_type_setting_accepted_insurance_plan(appointment_type_id) → appointment_type(id)
- appointment_type_provider_connection(user_id) → users(id)
- appointment_type_provider_connection(appointment_type_id) → appointment_type(id)
- appointment_type(user_group_id) → user_group(id)
- appointment_type(user_id) → users(id)
- appointment_type(onboarding_flow_user_id) → users(id)
- tagged_user(id) → users(id)
- tagged_user(tag_id) → tags(id)
- form_answer_group_auto_score_section(form_answer_group_id) → form_answer_group(id)
- form_answer_group_charting_note_addendum(user_id) → users(id)
- form_answer_group_charting_note_addendum(form_answer_group_id) → form_answer_group(id)
- form_answer_group_sign(user_id) → users(id)
- form_answer_group_sign(form_answer_group_id) → form_answer_group(id)
- form_answer_group_user_connection(user_id) → users(id)
- form_answer_group_user_connection(form_answer_group_id) → form_answer_group(id)
- form_answer_group_answer(user_id) → users(id)
- form_answer_group_answer(custom_module_id) → form_template_custom_module(id)
- form_answer_group_answer(form_answer_group_id) → form_answer_group(id)
- form_answer_group_appointment_attendee(id) → users(id)
- form_answer_group_appointment_attendee(form_answer_group_id) → form_answer_group(id)
- form_answer_group_individual_client_note(user_id) → users(id)
- form_answer_group_individual_client_note(form_answer_group_id) → form_answer_group(id)
- form_answer_group(cms_1500_id) → cms_1500(id)
- form_answer_group(user_id) → users(id)
- form_answer_group(locked_by_id) → users(id)
- form_answer_group(appointment_id) → appointment(id)
- form_answer_group(form_template_id) → form_template(id)
- form_answer_group(filler_id) → users(id)
- document_view(user_id) → users(id)
- document_view(document_id) → document(id)
- document_shared_user_group(id) → user_group(id)
- document_shared_user_group(document_id) → document(id)
- document_shared_user(id) → users(id)
- document_shared_user(document_id) → document(id)
- document(owner_id) → users(id)
- document(rel_user_id) → users(id)
- journal_entry_meal(journal_entry_id) → journal_entry(id)
- journal_entry_sub_entry_meal(journal_entry_sub_entry_id) → journal_entry_sub_entry(id)
- journal_entry_sub_entry_meal(journal_entry_id) → journal_entry_sub_entry(journal_entry_id)
- journal_entry_sub_entry_comment(author_id) → users(id)
- journal_entry_sub_entry_comment(poster_id) → users(id)
- journal_entry_sub_entry_comment(creator_id) → users(id)
- journal_entry_sub_entry_comment(user_id) → users(id)
- journal_entry_sub_entry_comment(journal_entry_sub_entry_id) → journal_entry_sub_entry(id)
- journal_entry_sub_entry_comment(journal_entry_id) → journal_entry_sub_entry(journal_entry_id)
- journal_entry_sub_entry(added_by_user_id) → users(id)
- journal_entry_sub_entry(poster_id) → users(id)
- journal_entry_sub_entry(journal_entry_id) → journal_entry(id)
- journal_entry_comment(author_id) → users(id)
- journal_entry_comment(poster_id) → users(id)
- journal_entry_comment(creator_id) → users(id)
- journal_entry_comment(user_id) → users(id)
- journal_entry_comment(journal_entry_id) → journal_entry(id)
- journal_entry(added_by_user_id) → users(id)
- journal_entry(poster_id) → users(id)
- form_template_custom_module(parent_custom_module_id) → form_template_custom_module(id)
- form_template_custom_module(form_template_id) → form_template(id)
- form_template(user_id) → users(id)
- form_template(last_updated_user_id) → users(id)
- billing_item_charge_back(billing_item_id) → billing_item(id)
- billing_item_refund_item(billing_item_id) → billing_item(id)
- billing_item(successful_retried_payment_id) → billing_item(id)
- billing_item(requested_payment_id) → requested_payment(id)
- billing_item(recipient_id) → users(id)
- billing_item(provider_id) → users(id)
- billing_item(recurring_payment_last_billing_item_id) → billing_item(id)
- billing_item(recurring_payment_paused_by_id) → users(id)
- billing_item(recurring_payment_appointment_id) → appointment(id)
- appointment_assigned_group(id) → user_group(id)
- appointment_assigned_group(appointment_id) → appointment(id)
- appointment_attended_client(user_id) → users(id)
- appointment_attended_client(appointment_id) → appointment(id)
- appointment_attendee(id) → users(id)
- appointment_attendee(appointment_id) → appointment(id)
- appointment(user_id) → users(id)
- appointment(conversation_id) → conversation_membership(conversation_id)
- appointment(initiator_id) → users(id)
- appointment(appointment_type_id) → appointment_type(id)
- appointment(filled_embed_form_id) → form_answer_group(id)
- appointment(form_answer_group_id) → form_answer_group(id)
- appointment(provider_id) → users(id)
- appointment(requested_payment_id) → requested_payment(id)
- care_plan_document(id) → document(id)
- care_plan_document(care_plan_id) → care_plan(id)
- care_plan_goal(care_plan_id) → care_plan(id)
- care_plan_recommendation(care_plan_id) → care_plan(id)
- care_plan_feature_toggle_custom_metrics(user_id) → users(id)
- care_plan_feature_toggle_custom_metrics(care_plan_id) → care_plan(id)
- care_plan_feature_toggle_initial_custom_metrics_override(custom_metric_id) → care_plan_feature_toggle_custom_metrics(id)
- care_plan_feature_toggle_initial_custom_metrics_override(form_id) → form_template(id)
- care_plan_feature_toggle_initial_custom_metrics_override(user_id) → users(id)
- care_plan_feature_toggle_initial_custom_metrics_override(care_plan_id) → care_plan(id)
- care_plan_feature_toggle_metric_category(user_id) → users(id)
- care_plan_feature_toggle_metric_category(care_plan_id) → care_plan(id)
- care_plan_feature_toggle_symptom_option(care_plan_id) → care_plan(id)
- care_plan(user_group_id) → user_group(id)
- care_plan(patient_id) → users(id)
- care_plan(creator_id) → users(id)
- conversation(user_group_id) → user_group(id)
- conversation(dietitian_id) → users(id)
- conversation(patient_id) → users(id)
- conversation(owner_id) → users(id)
- conversation(closed_by_id) → users(id)
- user_group_patient_list(id) → users(id)
- user_group_patient_list(user_group_id) → user_group(id)
- user_group_users_with_membership(id) → users(id)
- user_group_users_with_membership(user_group_id) → user_group(id)
- user_group_recurring_form(user_id) → users(id)
- user_group_recurring_form(user_group_id) → user_group(id)
- insurance_plan(user_id) → users(id)
- insurance_plan(default_payer_location_user_id) → users(id)
- active_patient(id) → users(id)
- active_patient(user_id) → users(id)
- user_policy_claim_eligibility_check(user_policy_id) → user_policy(id)
- user_policy_claim_eligibility_check(user_id) → user_policy(user_id)
- user_policy_cpt_code(user_policy_id) → user_policy(id)
- user_policy_cpt_code(user_id) → user_policy(user_id)
- user_policy_icd_code(user_policy_id) → user_policy(id)
- user_policy_icd_code(user_id) → user_policy(user_id)
- user_policy_benefit(user_policy_id) → user_policy(id)
- user_policy_benefit(user_id) → user_policy(user_id)
- user_policy(user_id) → users(id)
- user_policy(insurance_plan_id) → insurance_plan(id)
- user_additional_sidebar_item(user_id) → users(id)
- user_appointment_type_credit(user_id) → users(id)
- user_appointment_type_credit(appointment_type_id) → appointment_type(id)
- user_state_license(user_id) → users(id)
- user_other_id(user_id) → users(id)
- user_call_reference(user_id) → users(id)
- user_custom_email(user_id) → users(id)
- user_diagnosis(user_id) → users(id)
- user_diagnosis(icd_code_id) → icd_code(id)
- user_care_team_provider_id(user_id) → users(id)
- user_upcoming_appointment(id) → appointment(id)
- user_upcoming_appointment(user_id) → users(id)
- user_next_appointment(id) → appointment(id)
- user_next_appointment(user_id) → users(id)
- user_profession(user_id) → users(id)
- user_provider(id) → users(id)
- user_provider(user_id) → users(id)
- user_referral(user_id) → users(id)
- user_other_organization_member(id) → users(id)
- user_other_organization_member(user_id) → users(id)
- stripe_customer_detail(user_id) → users(id)
- users(user_group_id) → user_group(id)
- users(dietitian_id) → users(id)
- metric_data_point(_fivetran_id) → metric_data(_fivetran_id)
- note(user_id) → users(id)
- note(document_id) → document(id)
- note(conversation_id) → conversation(id)
- note(recipient_id) → users(id)
- note(creator_id) → users(id)
- conversation_invitee(id) → users(id)
- conversation_invitee(conversation_membership_id) → conversation_membership(id)
- conversation_note(id) → note(id)
- conversation_note(conversation_membership_id) → conversation_membership(id)
- conversation_membership(user_id) → users(id)
- conversation_membership(conversation_id) → conversation(id)
- conversation_membership(creator_id) → users(id)
- requested_payment(cms_1500_id) → cms_1500(id)
- requested_payment(billing_item_id) → billing_item(id)
- requested_payment(sender_id) → users(id)
- requested_payment(appointment_id) → appointment(id)
- requested_payment(recipient_id) → users(id)
- appointment_summary_history(appointment_summary_fivetran_id) → appointment_summary(_fivetran_id)
- appointment_summary_history_provider(appointment_summary_fivetran_id) → appointment_summary(_fivetran_id)
- appointment_summary_history_type(appointment_summary_fivetran_id) → appointment_summary(_fivetran_id)
- appointment_summary_history_type_count(appointment_summary_fivetran_id) → appointment_summary(_fivetran_id)
- cms_1500_cpt_code(cpt_code_id) → cpt_code(id)
- cms_1500_cpt_code(cms_1500_id) → cms_1500(id)
- cms_1500_icd_code(id) → icd_code(id)
- cms_1500_icd_code(cms_1500_id) → cms_1500(id)
- cms_1500(patient_id) → users(id)
- cms_1500(rendering_provider_id) → users(id)
- cms_1500(form_answer_group_id) → form_answer_group(id)
- organization_member_additional_sidebar_item(organization_member_id) → organization_member(id)
- organization_member_appointment_type_credit(user_id) → users(id)
- organization_member_appointment_type_credit(appointment_type_id) → appointment_type(id)
- organization_member_appointment_type_credit(organization_member_id) → organization_member(id)
- organization_member_state_license(organization_member_id) → organization_member(id)
- organization_member_other_id(user_id) → organization_member(id)
- organization_member_other_id(organization_member_id) → organization_member(id)
- organization_member_call_reference(user_id) → users(id)
- organization_member_call_reference(organization_member_id) → organization_member(id)
- organization_member_custom_email(user_id) → users(id)
- organization_member_custom_email(organization_member_id) → organization_member(id)
- organization_member_care_team_provider_id(organization_member_id) → organization_member(id)
- organization_member_profession(organization_member_id) → organization_member(id)
- organization_member_provider(id) → organization_member(id)
- organization_member_provider(organization_member_id) → organization_member(id)
- organization_member_stripe_customer_detail(user_id) → users(id)
- organization_member_stripe_customer_detail(organization_member_id) → organization_member(id)
- organization_member(user_group_id) → user_group(id)
- organization_member(dietitian_id) → users(id)
- location(user_id) → users(id)
- availability(user_id) → users(id)
- availability(appointment_location_id) → location(id)
- availability(appointment_type_id) → appointment_type(id)
- availability(resource_id) → users(id)