Healthie
Explore the interactive ERD
Table & Field Reference
appointment_type_bookable_group
| Column | Type | Keys |
|---|---|---|
appointment_type_id | Unknown | PKFK |
id | Unknown | PKFK |
appointment_type_form_request_after_booking
| Column | Type | Keys |
|---|---|---|
appointment_type_id | Unknown | PKFK |
id | Unknown | PKFK |
interval | Unknown | |
send_trigger | Unknown |
appointment_type_form_request_after_appointment
| Column | Type | Keys |
|---|---|---|
appointment_type_id | Unknown | PKFK |
id | Unknown | PKFK |
interval | Unknown | |
send_trigger | Unknown |
appointment_type_form_request_before_appointment
| Column | Type | Keys |
|---|---|---|
appointment_type_id | Unknown | PKFK |
id | Unknown | PKFK |
interval | Unknown | |
send_trigger | Unknown |
appointment_type_setting_location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_type_id | Unknown | PKFK |
appointment_type_setting_contact_type_override
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
appointment_type_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
code_by_item | Unknown | |
code_by_item_name | Unknown | |
color | Unknown |
appointment_type_setting_accepted_insurance_plan
| Column | Type | Keys |
|---|---|---|
appointment_type_id | Unknown | PKFK |
id | Unknown | PKFK |
appointment_type_provider_connection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_type_id | Unknown | PKFK |
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 | PKFK |
tag_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
user_id | Unknown | FK |
content | Unknown | |
created_at | Unknown |
form_answer_group_sign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_answer_group_id | Unknown | PKFK |
user_id | Unknown | FK |
created_at | Unknown |
form_answer_group_user_connection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_answer_group_id | Unknown | PKFK |
user_id | Unknown | FK |
form_answer_group_answer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_answer_group_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
form_answer_group_individual_client_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_answer_group_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | FK |
viewed_at | Unknown |
document_shared_user_group
| Column | Type | Keys |
|---|---|---|
document_id | Unknown | PKFK |
id | Unknown | PKFK |
document_shared_user
| Column | Type | Keys |
|---|---|---|
document_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
name | Unknown |
journal_entry_sub_entry_meal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
journal_entry_id | Unknown | PKFK |
journal_entry_sub_entry_id | Unknown | PKFK |
name | Unknown |
journal_entry_sub_entry_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
journal_entry_id | Unknown | PKFK |
journal_entry_sub_entry_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
appointment_attended_client
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
care_plan_goal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
care_plan_id | Unknown | PKFK |
care_plan_recommendation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
care_plan_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
user_group_id | Unknown | PKFK |
user_group_users_with_membership
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
user_group_id | Unknown | PKFK |
user_group_recurring_form
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_group_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
user_policy_claim_eligibility_check
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
user_policy_id | Unknown | PKFK |
code | Unknown | |
description | Unknown |
user_policy_cpt_code
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
user_policy_id | Unknown | PKFK |
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 | PKFK |
user_policy_id | Unknown | PKFK |
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 | PKFK |
user_policy_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
appointment_type_id | Unknown | FK |
form_id | Unknown | |
id | Unknown | |
quantity | Unknown |
user_state_license
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
full_state_name | Unknown | |
state | Unknown |
user_other_id
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
label | Unknown | |
organization_id | Unknown | |
other_id | Unknown | |
other_id_qualifier | Unknown |
user_call_reference
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
date_recorded | Unknown | |
notes | Unknown | |
reference_number | Unknown | |
time_recorded | Unknown |
user_custom_email
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
user_upcoming_appointment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
user_id | Unknown | PKFK |
user_next_appointment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
user_id | Unknown | PKFK |
user_profession
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
profession | Unknown | |
profession_category | Unknown |
user_provider
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
user_id | Unknown | PKFK |
user_referral
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
stripe_customer_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
conversation_note
| Column | Type | Keys |
|---|---|---|
conversation_membership_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
name | Unknown |
appointment_summary_history_type
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
appointment_summary_fivetran_id | Unknown | PKFK |
name | Unknown |
appointment_summary_history_type_count
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
appointment_summary_fivetran_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
full_state_name | Unknown | |
state | Unknown |
organization_member_other_id
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_member_id | Unknown | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
organization_member_profession
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_member_id | Unknown | PKFK |
profession | Unknown | |
profession_category | Unknown |
organization_member_provider
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
organization_member_id | Unknown | PKFK |
organization_member_stripe_customer_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_member_id | Unknown | PKFK |
user_id | Unknown | PKFK |
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 |