messages                       : id, tenant_id, sender_id, recipient_id, subject, content, message_type, status, is_external, delivery_status, change_note, created_at, updated_at
teleconsultations              : id, tenant_id, patient_id,  clinician_id, topic, description, status, scheduled_at, started_at, ended_at, consent_recording_consent, consent_treatment_consent, platform, connection_fallback, clinical_outcome, outcome_type, change_note, created_by, created_at, updated_at
roles                          : id, tenant_id, key, name, level, scope, description, is_system, created_at, updated_at, is_active
payments                       : id, tenant_id, invoice_id, deposit_id, payment_reference, amount, remaining_amount, status, gateway, mode, payment_point_code, change_note, created_by, created_at, updated_at
document_signatories           : id, tenant_id, name, title, role, is_active, change_note, created_at, updated_at
patient_education_responses    : id, tenant_id, patient_id, material_id, response_text, response_type, concern_level, routed_to_team, routed_at, change_note, created_at, updated_at
stock_movements                : id, tenant_id, product_id, order_id, user_id, movement_type, quantity_delta, batch_number, batch_expiry, reason, note, created_at
role_permissions               : id, role_id, permission_id, is_granted, change_note, created_by, created_at, updated_at
payroll_runs                   : id, tenant_id, run_name, period_start, period_end, base_total, allowances_total, deductions_total, net_total, status, payment_reference, change_note, processed_by, created_at, updated_at
payroll_items                  : id, tenant_id, payroll_run_id, employee_id, item_type, description, amount, quantity, change_note, created_at, updated_at
public_booking_slots           : id, tenant_id, public_clinician_id, date, start_time, end_time, capacity, booked_count, is_active, change_note, created_at, updated_at
public_careers                 : id, tenant_id, title, slug, description, requirements, department, location, application_link, is_active, change_note, created_at, updated_at
public_clinicians              : id, tenant_id, user_id, first_name, last_name, middle_name, specialty, qualifications, bio, photo_path, slug, is_featured, change_note, created_at, updated_at
metrics                        : id, tenant_id, name, description, metric_type, formula, source, denominator, is_active, is_public, disclosure_note, created_at, updated_at
message_preferences            : id, tenant_id, user_id, preference_type, is_enabled, is_sms_enabled, is_email_enabled, is_push_enabled, change_note, created_at, updated_at
invoice_approvals              : id, tenant_id, invoice_id, initiated_by, supervisor_approved_by, manager_approved_by, initiated_at, supervisor_approved_at, manager_approved_at, status, remarks, created_at, updated_at, proposed_changes
invoices                       : id, tenant_id, patient_id, service_tariff_id, reference, amount, paid_amount, status, payment_channel, transaction_reference, change_note, created_by, updated_by, issued_at, paid_at, voided_at, created_at, updated_at, product_item_id
