54
Total Tables
238,980
Total Rows
209.4 MB
Data Size
34.3 MB
Index Size
Database Tables
Schema Table Name Rows Data Size Index Size Total
info_management cpo_ccm_notes 0
32.0 KB
16.0 KB
48.0 KB
info_management github_integration 0
64.0 KB
48.0 KB
112.0 KB
info_management github_sync_log 0
80.0 KB
64.0 KB
144.0 KB
info_management hdsign_access_codes 0
88.0 KB
80.0 KB
168.0 KB
info_management hdsign_audit_log 0
200.0 KB
96.0 KB
296.0 KB
info_management hdsign_form_submissions 0
216.0 KB
128.0 KB
344.0 KB
info_management hdsign_form_templates 0
96.0 KB
80.0 KB
176.0 KB
info_management hdsign_form_versions 0
184.0 KB
64.0 KB
248.0 KB
info_management hdsign_signatures 0
984.0 KB
128.0 KB
1.1 MB
info_management hdsign_updates 0
112.0 KB
64.0 KB
176.0 KB
info_management home_health_nurse 0
96.0 KB
48.0 KB
144.0 KB
info_management practice_fusion_integration 0
48.0 KB
32.0 KB
80.0 KB
info_management practice_fusion_oauth_state 0
80.0 KB
64.0 KB
144.0 KB
info_management practice_fusion_sync_log 0
16.0 KB
8.0 KB
24.0 KB
info_management visit_types 0
80.0 KB
64.0 KB
144.0 KB
patient_management address 116
744.0 KB
312.0 KB
1.0 MB
patient_management appointment 93,266
12.6 MB
9.1 MB
21.8 MB
patient_management billable_item 0
6.3 MB
2.5 MB
8.8 MB
patient_management billing_status 0
48.0 KB
32.0 KB
80.0 KB
patient_management clinical_notes 9,935
5.3 MB
1.8 MB
7.1 MB
patient_management contractor_payment 0
144.0 KB
80.0 KB
224.0 KB
patient_management cpt_pay_rate 1
80.0 KB
32.0 KB
112.0 KB
patient_management document_category 0
80.0 KB
64.0 KB
144.0 KB
patient_management hcpcs_codes 0
32.0 KB
16.0 KB
48.0 KB
patient_management medicare_mapping 832
312.0 KB
160.0 KB
472.0 KB
patient_management medicare_procedure 2,912
5.1 MB
1.6 MB
6.7 MB
patient_management patient 44
1.3 MB
296.0 KB
1.6 MB
patient_management patient_certification 0
456.0 KB
160.0 KB
616.0 KB
patient_management patient_discharge 0
32.0 KB
16.0 KB
48.0 KB
patient_management patient_notes 1,061
88.2 MB
1.9 MB
90.0 MB
patient_management patient_part_b_deductible 154
632.0 KB
312.0 KB
944.0 KB
patient_management patient_problems 0
144.0 KB
80.0 KB
224.0 KB
patient_management pay_period 1,126
176.0 KB
48.0 KB
224.0 KB
patient_management pay_tracker_entry 125,191
9.5 MB
4.1 MB
13.5 MB
patient_management pfid_mapping 4,297
360.0 KB
200.0 KB
560.0 KB
patient_management practice_fusion_document 0
29.1 MB
6.0 MB
35.2 MB
patient_management practice_fusion_patient_mapping 0
24.0 KB
16.0 KB
40.0 KB
patient_management practice_fusion_transcript 0
16.4 MB
784.0 KB
17.1 MB
patient_management practice_fusion_transcript_note 0
18.2 MB
368.0 KB
18.5 MB
patient_management provider_pay_period_status 0
40.0 KB
32.0 KB
72.0 KB
patient_management provider_pay_rate 0
112.0 KB
64.0 KB
176.0 KB
patient_management qmb_data 0
40.0 KB
32.0 KB
72.0 KB
patient_management schedule 2
528.0 KB
144.0 KB
672.0 KB
patient_management visit_document 0
10.8 MB
2.8 MB
13.5 MB
patient_management visit_document_hold 0
24.0 KB
16.0 KB
40.0 KB
patient_management visit_notes 0
96.0 KB
80.0 KB
176.0 KB
practitioner_management practitioner 5
64.0 KB
48.0 KB
112.0 KB
user_management device_token 0
40.0 KB
32.0 KB
72.0 KB
user_management patients_update_log 0
8.0 KB
8.0 KB
16.0 KB
user_management permission 0
48.0 KB
32.0 KB
80.0 KB
user_management revoked_tokens 33
40.0 KB
32.0 KB
72.0 KB
user_management role 0
48.0 KB
32.0 KB
80.0 KB
user_management role_permission 0
40.0 KB
32.0 KB
72.0 KB
user_management user 5
96.0 KB
48.0 KB
144.0 KB
Full Backup

Create a complete backup of all tables with schema and data.

Partial Backup

Select specific tables to backup.

Download SQL

Download a full SQL dump of the database.

Backup History

Loading backup history...

Database Migrations
Migrations update your database structure without losing data. Review each migration before running.
Available Migrations
Migration Description Status Actions
add_appointment_id_to_pf_transcript Add appointment_id field to practice_fusion_transcript table to link SOAP notes to local visits. Pending Required
add_billed_cpt_imported_column Migration script to add billed_cpt_imported column to pay_tracker_entry table. Pending Required
add_document_category_table Migration: Add document_category table for custom document categories Pending Required
add_file_hash_to_hdsign_updates Database migration Pending Required
add_hdsign_form_submissions Migration to add hdsign_form_submissions table and update hdsign_signatures. Pending Required
add_hold_fields_to_patient Database migration Pending Required
add_kanji_categories Migration to add category column and seed tsu/day counters. Pending Required
add_kanji_leaderboard Migration to add kanji leaderboard table. Pending Required
add_leaderboard_session_id Add session_id column to kanji_leaderboard table. Pending Required
add_medicare_rate_to_cpt Add medicare_rate column to cpt_pay_rate table. Pending Required
add_patient_discharge_table Database migration Pending Required
add_pay_tracker_description_column Migration script to add description column and make cpt_code nullable: Pending Required
add_pay_tracker_source_and_pay_date Migration script to add new columns to pay tracker tables: Pending Required
add_pf_encounter_fields_to_appointment Add Practice Fusion encounter fields to appointment table. Pending Required
add_pf_encounter_guid_to_clinical_notes Add pf_encounter_guid column to clinical_notes table for linking to transcripts. Pending Required
add_practice_fusion_documents Migration: Add practice_fusion_document table Pending Required
add_practice_fusion_guid_to_patient Add Practice Fusion GUID field to patient table migration Pending Required
add_practice_fusion_oauth_state Add practice_fusion_oauth_state table for OAuth state management. Pending Required
add_practice_fusion_system_app_columns Migration: Add System App columns to Practice Fusion integration table Pending Required
add_practice_fusion_transcripts Add Practice Fusion transcript/encounter storage tables Pending Required
add_practitioner_linking Add practitioner linking fields to Appointment and Practitioner models. Pending Required
add_provider_pay_period_status Migration script to add provider_pay_period_status table. Pending Required
add_provider_role_and_user_practitioner_link Migration to add provider role, permissions, and link users to practitioners. Pending Required
add_rbac_tables Migration: Add Role-Based Access Control (RBAC) tables and update User table Pending Required
add_scheduling_features Database migration Pending Required
add_signed_document_to_certification Database migration Pending Required
add_title_to_cpt_pay_rate Add title column to cpt_pay_rate table for concise display names. Pending Required
add_user_settings_column Migration to add settings JSON column to user table. Pending Required
add_visit_document_hold_table Migration: Add visit_document_hold table for tracking hold status on visits Pending Required
add_visit_document_table Migration: Add visit_document table for storing documents attached to visits Pending Required
add_visit_id_to_hdsign_submissions Migration to add visit_id column to hdsign_form_submissions table. Pending Required
add_visit_types Migration: Add visit_types table for configuring visit types and required forms. Pending Required
alter_billable_item_source_id_to_string Migration to change source_id column from INTEGER to VARCHAR(50). Pending Required
alter_visit_document_nullable_appointment Migration: Make appointment_id nullable in visit_document table Pending Required
create_billing_status_table Database migration Pending Required
create_clinical_notes_tables Create clinical notes and patient problems tables for storing Practice Fusion data locally. Pending Required
create_contractor_payment_table Create contractor_payment table for tracking non-visit contractor payments. Pending Required
create_cpo_ccm_notes_table Database migration Pending Required
create_github_integration_tables Database migration Pending Required
create_hcpcs_codes_table Migration to create HCPCS codes lookup table and normalize patient_certification table Pending Required
create_hdsign_forms_tables Migration: Create HDSign Forms Tables Pending Required
create_hdsign_update_tables Database migration Pending Required
create_home_health_nurse_table Database migration Pending Required
create_kanji_practice_tables Migration script to create kanji practice tables. Pending Required
create_patient_notes_table Migration: Create patient_notes table for storing encounter/visit notes Pending Required
create_pay_tracker_tables Migration script to create pay tracker tables. Pending Required
create_practice_fusion_tables Migration: Create Practice Fusion integration tables Pending Required
create_schedule_table Migration: Create schedule table for multi-day schedule planning Pending Required
create_visit_notes_table Database migration Pending Required
expand_tsu_counters Expand tsu counters to 1-99. Pending Required
fix_hhn_auto_increment Database migration Pending Required
fix_numbers_audio Fix audio paths for numbers category. Pending Required
import_json_templates_to_database Migration to import JSON file templates into the database. Pending Required
seed_hdsign_templates Seed HDSign templates with Treatment Consent and Annual Wellness Visit forms. Pending Required
update_practitioners_table Database migration Pending Required
update_provider_emails Add business emails to provider accounts for Entra ID integration. Pending Required
Database Tools
Data Import
Remove Duplicates: Clean up duplicate appointments | Analyze Names: Fix name matching issues | Upload CSV: Import data from CSV files | Reset Database: Complete data reset (use with caution)