Documentation Index
Fetch the complete documentation index at: https://docs.encoreos.io/llms.txt
Use this file to discover all available pages before exploring further.
Generated file. Do not hand-edit sections below; re-run npm run db:docs:generate:prod.
- Generated at:
<GENERATED_AT>
- Source:
config/reports.json (remote-catalog)
- Environment: prod
- Supabase project:
<SUPABASE_PROJECT_ID>
- Tables: 883
- Views: 25
- Functions: 793
- Triggers: 1286
Inventory by Core
| Core | Tables |
|---|
| PF | 177 |
| CE | 32 |
| RH | 51 |
| FA | 103 |
| HR | 144 |
| GR | 70 |
| FW | 63 |
| FM | 29 |
| LO | 29 |
| IT | 37 |
| CL | 76 |
| PM | 71 |
| OTHER | 1 |
PF tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
pf_ai_conversations | public | 11 | 2 | 2 | 4 | enabled |
pf_ai_prompt_feedback | public | 11 | 1 | 3 | 6 | enabled |
pf_ai_skill_overrides | public | 13 | 2 | 4 | 4 | enabled |
pf_ai_skills | public | 33 | 8 | 3 | 4 | enabled |
pf_ai_usage_logs | public | 15 | 2 | 2 | 2 | enabled |
pf_approval_chain_templates | public | 15 | 7 | 3 | 4 | enabled |
pf_audit_logs | public | 16 | 5 | 3 | 3 | enabled |
pf_bulk_operation_items | public | 12 | 4 | 4 | 4 | enabled |
pf_bulk_operations | public | 24 | 4 | 4 | 4 | enabled |
pf_business_processes | public | 24 | 8 | 3 | 4 | enabled |
pf_calendar_sync_config | public | 12 | 2 | 3 | 4 | enabled |
pf_chatbot_configs | public | 22 | 3 | 3 | 5 | enabled |
pf_chatbot_messages | public | 7 | 3 | 2 | 2 | enabled |
pf_chatbot_sessions | public | 17 | 4 | 1 | 4 | enabled |
pf_code_crosswalks | public | 12 | 4 | 1 | 1 | enabled |
pf_code_favorites | public | 7 | 4 | 2 | 3 | enabled |
pf_code_modifiers | public | 14 | 4 | 3 | 4 | enabled |
pf_code_recent | public | 7 | 4 | 2 | 3 | enabled |
pf_code_sets | public | 14 | 3 | 3 | 4 | enabled |
pf_condition_evaluation_cache | public | 10 | 4 | 1 | 4 | enabled |
pf_condition_evaluation_metrics | public | 9 | 3 | 1 | 4 | enabled |
pf_condition_evaluation_metrics_archive | public | 10 | 2 | 1 | 2 | enabled |
pf_conversation_members | public | 15 | 5 | 4 | 4 | enabled |
pf_conversations | public | 22 | 7 | 4 | 4 | enabled |
pf_cpt_codes | public | 12 | 6 | 1 | 4 | enabled |
pf_credential_vault | public | 11 | 5 | 2 | 4 | enabled |
pf_credentials | public | 13 | 2 | 3 | 1 | enabled |
pf_custom_field_definitions | public | 24 | 3 | 4 | 2 | enabled |
pf_custom_metric_values | public | 6 | 4 | 2 | 2 | enabled |
pf_custom_metrics | public | 19 | 4 | 3 | 4 | enabled |
pf_custom_object_fields | public | 12 | 3 | 3 | 8 | enabled |
pf_custom_object_records | public | 9 | 1 | 4 | 4 | enabled |
pf_custom_objects | public | 17 | 3 | 4 | 4 | enabled |
pf_custom_roles | public | 11 | 2 | 3 | 4 | enabled |
pf_dashboard_shares | public | 14 | 2 | 4 | 4 | enabled |
pf_dashboard_templates | public | 17 | 1 | 3 | 4 | enabled |
pf_data_lifecycle_events | public | 10 | 4 | 3 | 1 | enabled |
pf_data_lineage | public | 15 | 6 | 1 | 4 | enabled |
pf_data_lineage_archive | public | 18 | 4 | 0 | 2 | enabled |
pf_data_migration_connections | public | 17 | 2 | 3 | 4 | enabled |
pf_data_migration_mappings | public | 14 | 3 | 3 | 4 | enabled |
pf_data_migration_runs | public | 26 | 3 | 4 | 4 | enabled |
pf_department_sharepoint_config | public | 16 | 4 | 4 | 4 | enabled |
pf_department_teams_config | public | 16 | 4 | 4 | 4 | enabled |
pf_departments | public | 18 | 2 | 6 | 4 | enabled |
pf_document_approvals | public | 15 | 2 | 4 | 4 | enabled |
pf_document_embeddings | public | 14 | 6 | 3 | 4 | enabled |
pf_document_expiration_log | public | 8 | 3 | 3 | 2 | enabled |
pf_document_permissions | public | 11 | 3 | 3 | 2 | enabled |
pf_document_template_versions | public | 11 | 4 | 4 | 2 | enabled |
pf_document_templates | public | 20 | 8 | 4 | 4 | enabled |
pf_document_versions | public | 13 | 2 | 2 | 2 | enabled |
pf_documents | public | 30 | 6 | 6 | 4 | enabled |
pf_edge_function_metrics | public | 7 | 2 | 0 | 0 | enabled |
pf_entity_field_config_versions | public | 8 | 3 | 3 | 2 | enabled |
pf_entity_field_configs | public | 19 | 2 | 4 | 4 | enabled |
pf_export_files | public | 13 | 6 | 3 | 2 | enabled |
pf_export_requests | public | 20 | 4 | 3 | 4 | enabled |
pf_export_templates | public | 15 | 5 | 3 | 4 | enabled |
pf_feature_flag_usage | public | 9 | 5 | 3 | 2 | enabled |
pf_feature_flags | public | 16 | 7 | 4 | 4 | enabled |
pf_field_interaction_stats | public | 12 | 2 | 2 | 6 | enabled |
pf_field_permissions | public | 9 | 2 | 1 | 4 | enabled |
pf_form_analytics_events | public | 15 | 1 | 5 | 2 | enabled |
pf_form_completion_metrics | public | 15 | 2 | 3 | 3 | enabled |
pf_gesture_analytics_events | public | 10 | 4 | 2 | 2 | enabled |
pf_github_webhook_events | public | 2 | 1 | 0 | 0 | enabled |
pf_google_workspace_connections | public | 24 | 5 | 4 | 4 | enabled |
pf_google_workspace_mappings | public | 14 | 4 | 4 | 4 | enabled |
pf_google_workspace_sync_runs | public | 16 | 4 | 3 | 1 | enabled |
pf_google_workspace_user_links | public | 18 | 8 | 5 | 4 | enabled |
pf_hcpcs_codes | public | 12 | 6 | 1 | 4 | enabled |
pf_health_alert_configs | public | 18 | 1 | 4 | 5 | enabled |
pf_health_alert_history | public | 15 | 1 | 4 | 3 | enabled |
pf_health_metrics | public | 15 | 7 | 1 | 4 | enabled |
pf_icd10_codes | public | 15 | 7 | 1 | 4 | enabled |
pf_import_batches | public | 14 | 2 | 3 | 3 | enabled |
pf_inbox_snoozes | public | 9 | 3 | 4 | 4 | enabled |
pf_index_cleanup_audit | public | 10 | 1 | 0 | 1 | enabled |
pf_integration_credentials | public | 7 | 2 | 1 | 1 | enabled |
pf_integrations | public | 22 | 3 | 3 | 4 | enabled |
pf_ip_allowlist | public | 12 | 3 | 3 | 5 | enabled |
pf_ip_blocklist | public | 12 | 4 | 3 | 5 | enabled |
pf_knowledge_base | public | 20 | 6 | 5 | 4 | enabled |
pf_legal_holds | public | 14 | 4 | 3 | 4 | enabled |
pf_letterheads | public | 27 | 6 | 3 | 4 | enabled |
pf_marketplace_ratings | public | 11 | 2 | 5 | 4 | enabled |
pf_message_read_receipts | public | 4 | 2 | 3 | 4 | enabled |
pf_messages | public | 25 | 6 | 7 | 4 | enabled |
pf_module_permissions | public | 9 | 5 | 0 | 4 | enabled |
pf_module_presets | public | 18 | 7 | 4 | 5 | enabled |
pf_module_settings | public | 71 | 2 | 4 | 4 | enabled |
pf_notification_batches | public | 12 | 1 | 2 | 1 | enabled |
pf_notification_delivery_log | public | 11 | 2 | 1 | 2 | enabled |
pf_notification_preferences | public | 11 | 2 | 1 | 4 | enabled |
pf_notification_templates | public | 15 | 2 | 3 | 3 | enabled |
pf_notifications | public | 25 | 5 | 5 | 5 | enabled |
pf_oauth_providers | public | 17 | 2 | 3 | 4 | enabled |
pf_oauth_state | public | 5 | 2 | 0 | 1 | enabled |
pf_oauth_tokens | public | 17 | 2 | 5 | 4 | enabled |
pf_object_categories | public | 13 | 2 | 3 | 4 | enabled |
pf_object_favorites | public | 7 | 2 | 4 | 3 | enabled |
pf_object_metadata | public | 18 | 3 | 4 | 4 | enabled |
pf_object_permissions | public | 15 | 2 | 3 | 4 | enabled |
pf_org_dashboard_defaults | public | 13 | 3 | 4 | 4 | enabled |
pf_org_data_sync_events | public | 18 | 5 | 2 | 6 | enabled |
pf_org_hierarchies | public | 15 | 5 | 2 | 4 | enabled |
pf_organizations | public | 32 | 5 | 0 | 3 | enabled |
pf_outbound_webhooks | public | 20 | 2 | 4 | 4 | enabled |
pf_page_layout_fields | public | 10 | 1 | 1 | 4 | enabled |
pf_page_layout_sections | public | 9 | 1 | 1 | 4 | enabled |
pf_page_layout_templates | public | 13 | 3 | 3 | 4 | enabled |
pf_page_layout_versions | public | 7 | 4 | 3 | 4 | enabled |
pf_page_layout_visibility_rules | public | 10 | 3 | 5 | 4 | enabled |
pf_page_layout_wizards | public | 12 | 3 | 3 | 4 | enabled |
pf_page_layouts | public | 13 | 3 | 3 | 4 | enabled |
pf_patient_identities | public | 7 | 3 | 3 | 4 | enabled |
pf_payer_code_rules | public | 14 | 4 | 3 | 4 | enabled |
pf_picklist_default_definitions | public | 9 | 2 | 0 | 4 | enabled |
pf_picklist_default_items | public | 10 | 3 | 1 | 4 | enabled |
pf_picklist_items | public | 10 | 3 | 1 | 4 | enabled |
pf_picklists | public | 14 | 4 | 3 | 4 | enabled |
pf_process_execution_snapshots | public | 15 | 4 | 2 | 1 | enabled |
pf_profiles | public | 19 | 7 | 3 | 4 | enabled |
pf_provisioning_requests | public | 18 | 4 | 5 | 4 | enabled |
pf_provisioning_steps | public | 10 | 3 | 1 | 4 | enabled |
pf_provisioning_templates | public | 10 | 3 | 2 | 4 | enabled |
pf_push_subscriptions | public | 13 | 2 | 4 | 4 | enabled |
pf_query_performance_logs | public | 14 | 4 | 2 | 2 | enabled |
pf_quota_violations | public | 12 | 4 | 3 | 2 | enabled |
pf_rate_limit_state | public | 9 | 4 | 2 | 1 | enabled |
pf_rate_limit_violations | public | 14 | 6 | 3 | 1 | enabled |
pf_rate_limits | public | 15 | 6 | 3 | 4 | enabled |
pf_report_executions | public | 15 | 1 | 2 | 2 | enabled |
pf_report_permissions | public | 10 | 3 | 2 | 4 | enabled |
pf_report_runs | public | 17 | 1 | 2 | 3 | enabled |
pf_report_schedules | public | 24 | 1 | 4 | 4 | enabled |
pf_reports | public | 20 | 1 | 4 | 6 | enabled |
pf_resource_quotas | public | 14 | 6 | 3 | 4 | enabled |
pf_resource_usage | public | 9 | 5 | 1 | 4 | enabled |
pf_retention_log | public | 9 | 2 | 0 | 1 | enabled |
pf_retention_policies | public | 12 | 5 | 3 | 4 | enabled |
pf_role_permissions | public | 10 | 3 | 5 | 4 | enabled |
pf_security_alert_configs | public | 17 | 4 | 3 | 5 | enabled |
pf_security_alert_delivery_failures | public | 11 | 4 | 4 | 2 | enabled |
pf_security_events | public | 17 | 7 | 3 | 3 | enabled |
pf_settings_audit | public | 11 | 1 | 2 | 4 | enabled |
pf_signature_requests | public | 29 | 2 | 7 | 4 | enabled |
pf_signatures | public | 20 | 1 | 4 | 4 | enabled |
pf_sites | public | 19 | 3 | 1 | 3 | enabled |
pf_sla_thresholds | public | 18 | 4 | 4 | 4 | enabled |
pf_sla_violations | public | 17 | 4 | 4 | 2 | enabled |
pf_swim_lane_diagram_versions | public | 8 | 4 | 3 | 4 | enabled |
pf_swim_lane_diagrams | public | 22 | 5 | 4 | 5 | enabled |
pf_task_automation_rules | public | 15 | 4 | 4 | 4 | enabled |
pf_task_comments | public | 8 | 1 | 4 | 4 | enabled |
pf_task_dependencies | public | 8 | 5 | 5 | 4 | enabled |
pf_task_templates | public | 14 | 3 | 3 | 4 | enabled |
pf_task_time_entries | public | 12 | 4 | 5 | 4 | enabled |
pf_tasks | public | 20 | 4 | 6 | 4 | enabled |
pf_teams_notification_config | public | 14 | 4 | 3 | 4 | enabled |
pf_tenant_domains | public | 10 | 4 | 3 | 4 | enabled |
pf_user_activation_requests | public | 12 | 4 | 5 | 4 | enabled |
pf_user_dashboard_preferences | public | 8 | 2 | 2 | 4 | enabled |
pf_user_devices | public | 18 | 4 | 4 | 4 | enabled |
pf_user_invitations | public | 12 | 2 | 3 | 4 | enabled |
pf_user_role_assignments | public | 12 | 8 | 5 | 4 | enabled |
pf_user_sessions | public | 17 | 6 | 6 | 3 | enabled |
pf_validation_rule_executions | public | 9 | 3 | 3 | 2 | enabled |
pf_validation_rules | public | 14 | 3 | 3 | 4 | enabled |
pf_webhook_deliveries | public | 23 | 1 | 3 | 1 | enabled |
pf_wizard_analytics_events | public | 15 | 2 | 3 | 2 | enabled |
pf_wizard_executions | public | 20 | 2 | 4 | 2 | enabled |
pf_wizard_marketplace_listings | public | 20 | 1 | 4 | 4 | enabled |
pf_wizard_org_defaults | public | 13 | 2 | 3 | 4 | enabled |
pf_wizard_template_versions | public | 18 | 2 | 5 | 4 | enabled |
pf_wizard_templates | public | 22 | 6 | 7 | 4 | enabled |
CE tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
ce_activities | public | 18 | 9 | 5 | 4 | enabled |
ce_calendar_connections | public | 22 | 6 | 7 | 4 | enabled |
ce_calendar_events | public | 18 | 6 | 5 | 4 | enabled |
ce_calls | public | 35 | 12 | 6 | 3 | enabled |
ce_campaigns | public | 23 | 7 | 3 | 4 | enabled |
ce_contact_segments | public | 14 | 5 | 3 | 4 | enabled |
ce_contacts | public | 23 | 9 | 5 | 4 | enabled |
ce_email_accounts | public | 23 | 9 | 6 | 4 | enabled |
ce_email_messages | public | 32 | 13 | 6 | 4 | enabled |
ce_email_templates | public | 17 | 6 | 3 | 4 | enabled |
ce_email_tracking_events | public | 7 | 5 | 2 | 1 | enabled |
ce_event_attendees | public | 17 | 7 | 6 | 4 | enabled |
ce_events | public | 23 | 7 | 4 | 4 | enabled |
ce_lead_assignment_queue | public | 12 | 7 | 5 | 4 | enabled |
ce_lead_stages | public | 12 | 5 | 1 | 4 | enabled |
ce_leads | public | 33 | 13 | 11 | 4 | enabled |
ce_module_settings | public | 68 | 7 | 5 | 4 | enabled |
ce_partner_contacts | public | 8 | 6 | 3 | 4 | enabled |
ce_partner_contracts | public | 21 | 8 | 4 | 4 | enabled |
ce_partner_milestones | public | 14 | 4 | 3 | 4 | enabled |
ce_partner_progress | public | 20 | 7 | 5 | 4 | enabled |
ce_partners | public | 28 | 9 | 5 | 4 | enabled |
ce_referral_sources | public | 16 | 8 | 5 | 4 | enabled |
ce_ringcentral_extensions | public | 15 | 6 | 4 | 4 | enabled |
ce_ringcentral_subscriptions | public | 12 | 4 | 1 | 1 | enabled |
ce_ringout_sessions | public | 16 | 6 | 7 | 4 | enabled |
ce_sms_consent | public | 16 | 6 | 4 | 4 | enabled |
ce_sms_messages | public | 30 | 9 | 8 | 4 | enabled |
ce_sms_templates | public | 17 | 4 | 3 | 4 | enabled |
ce_unmatched_calls | public | 9 | 4 | 3 | 4 | enabled |
ce_web_form_submissions | public | 26 | 7 | 7 | 4 | enabled |
ce_web_forms | public | 23 | 5 | 4 | 4 | enabled |
RH tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
rh_alumni | public | 21 | 2 | 6 | 4 | enabled |
rh_alumni_engagement | public | 18 | 1 | 6 | 4 | enabled |
rh_attendance_records | public | 19 | 3 | 8 | 4 | enabled |
rh_audit_findings | public | 20 | 1 | 6 | 4 | enabled |
rh_audit_schedules | public | 19 | 1 | 5 | 4 | enabled |
rh_beds | public | 17 | 5 | 5 | 4 | enabled |
rh_census_snapshots | public | 17 | 2 | 3 | 4 | enabled |
rh_chore_assignments | public | 20 | 1 | 7 | 4 | enabled |
rh_compliance_checklists | public | 21 | 1 | 8 | 4 | enabled |
rh_compliance_requirements | public | 21 | 2 | 5 | 4 | enabled |
rh_curfew_checks | public | 18 | 1 | 6 | 4 | enabled |
rh_discharge_checklists | public | 17 | 1 | 6 | 4 | enabled |
rh_discharge_documents | public | 19 | 1 | 7 | 4 | enabled |
rh_discharge_plans | public | 22 | 2 | 6 | 4 | enabled |
rh_eligibility_checklists | public | 48 | 2 | 12 | 4 | enabled |
rh_episode_payment_status | public | 12 | 2 | 2 | 4 | enabled |
rh_episode_phases | public | 17 | 1 | 6 | 7 | enabled |
rh_episode_programs | public | 15 | 2 | 6 | 7 | enabled |
rh_episodes | public | 27 | 8 | 7 | 4 | enabled |
rh_follow_up_contacts | public | 17 | 1 | 6 | 4 | enabled |
rh_follow_up_schedules | public | 15 | 2 | 6 | 4 | enabled |
rh_med_storage_audits | public | 28 | 1 | 7 | 4 | enabled |
rh_milestone_completions | public | 15 | 2 | 8 | 6 | enabled |
rh_module_settings | public | 33 | 2 | 3 | 4 | enabled |
rh_outcome_assessments | public | 18 | 1 | 8 | 4 | enabled |
rh_outcome_checkpoints | public | 15 | 2 | 5 | 4 | enabled |
rh_outcome_indicators | public | 16 | 2 | 5 | 4 | enabled |
rh_outcome_measurements | public | 17 | 3 | 7 | 4 | enabled |
rh_participation_metrics | public | 21 | 2 | 3 | 4 | enabled |
rh_passes | public | 41 | 2 | 11 | 4 | enabled |
rh_phase_milestones | public | 15 | 1 | 6 | 7 | enabled |
rh_phase_privileges | public | 14 | 2 | 5 | 7 | enabled |
rh_program_phases | public | 14 | 2 | 5 | 7 | enabled |
rh_programs | public | 20 | 2 | 7 | 7 | enabled |
rh_referrals | public | 21 | 1 | 6 | 4 | enabled |
rh_report_definitions | public | 19 | 2 | 4 | 4 | enabled |
rh_residences | public | 24 | 3 | 4 | 4 | enabled |
rh_resident_agreements | public | 24 | 2 | 5 | 4 | enabled |
rh_resident_profiles | public | 17 | 3 | 4 | 4 | enabled |
rh_schedule_instances | public | 18 | 2 | 6 | 4 | enabled |
rh_schedule_templates | public | 20 | 2 | 5 | 4 | enabled |
rh_shift_notes | public | 19 | 1 | 5 | 4 | enabled |
rh_significant_event_actions | public | 22 | 1 | 7 | 4 | enabled |
rh_significant_event_investigations | public | 19 | 2 | 5 | 4 | enabled |
rh_significant_event_types | public | 17 | 2 | 3 | 4 | enabled |
rh_significant_events | public | 31 | 1 | 9 | 4 | enabled |
rh_staff_assignments | public | 16 | 1 | 5 | 4 | enabled |
rh_staff_trainings | public | 19 | 1 | 4 | 4 | enabled |
rh_transport_requests | public | 20 | 1 | 5 | 4 | enabled |
rh_uds_random_schedule | public | 16 | 1 | 5 | 4 | enabled |
rh_uds_tests | public | 27 | 2 | 8 | 4 | enabled |
FA tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
fa_1099_forms | public | 19 | 4 | 6 | 3 | enabled |
fa_account_balances | public | 11 | 2 | 4 | 4 | enabled |
fa_account_mappings | public | 12 | 4 | 5 | 4 | enabled |
fa_account_types | public | 13 | 2 | 3 | 4 | enabled |
fa_accounts | public | 25 | 4 | 5 | 4 | enabled |
fa_alert_thresholds | public | 19 | 3 | 3 | 4 | enabled |
fa_approval_thresholds | public | 13 | 2 | 4 | 4 | enabled |
fa_ar_payment_applications | public | 11 | 1 | 5 | 4 | enabled |
fa_asset_depreciation | public | 16 | 6 | 5 | 4 | enabled |
fa_asset_disposals | public | 20 | 4 | 7 | 4 | enabled |
fa_asset_transfers | public | 17 | 4 | 5 | 2 | enabled |
fa_bad_debt_reserves | public | 13 | 2 | 4 | 4 | enabled |
fa_bank_accounts | public | 35 | 11 | 6 | 4 | enabled |
fa_bank_reconciliations | public | 23 | 2 | 6 | 4 | enabled |
fa_bank_statement_lines | public | 27 | 13 | 6 | 8 | enabled |
fa_bank_statements | public | 17 | 2 | 3 | 4 | enabled |
fa_budget_alerts | public | 20 | 1 | 7 | 4 | enabled |
fa_budget_approvals | public | 10 | 1 | 3 | 4 | enabled |
fa_budget_lines | public | 14 | 2 | 6 | 4 | enabled |
fa_budget_scenarios | public | 14 | 6 | 4 | 4 | enabled |
fa_budget_template_shares | public | 8 | 5 | 4 | 4 | enabled |
fa_budget_templates | public | 19 | 6 | 5 | 4 | enabled |
fa_budgets | public | 21 | 4 | 7 | 4 | enabled |
fa_card_transactions | public | 17 | 6 | 6 | 4 | enabled |
fa_cash_forecasts | public | 16 | 5 | 3 | 4 | enabled |
fa_cash_positions | public | 16 | 5 | 3 | 4 | enabled |
fa_category_mappings | public | 19 | 11 | 7 | 4 | enabled |
fa_close_checklists | public | 20 | 7 | 7 | 4 | enabled |
fa_close_documentation | public | 20 | 6 | 6 | 4 | enabled |
fa_close_periods | public | 23 | 7 | 7 | 4 | enabled |
fa_close_tasks | public | 28 | 8 | 9 | 4 | enabled |
fa_collection_activities | public | 13 | 6 | 5 | 4 | enabled |
fa_collection_queue | public | 13 | 7 | 5 | 4 | enabled |
fa_credit_applications | public | 10 | 1 | 5 | 4 | enabled |
fa_credit_lines | public | 22 | 5 | 5 | 4 | enabled |
fa_credit_memo_lines | public | 14 | 3 | 5 | 8 | enabled |
fa_credit_memos | public | 21 | 5 | 6 | 4 | enabled |
fa_customer_payments | public | 20 | 4 | 5 | 4 | enabled |
fa_customers | public | 23 | 3 | 4 | 4 | enabled |
fa_dashboard_definitions | public | 9 | 2 | 3 | 4 | enabled |
fa_dashboard_widgets | public | 16 | 3 | 3 | 4 | enabled |
fa_fiscal_periods | public | 13 | 2 | 3 | 4 | enabled |
fa_fiscal_years | public | 11 | 2 | 3 | 4 | enabled |
fa_fixed_assets | public | 45 | 8 | 11 | 3 | enabled |
fa_forecast_lines | public | 17 | 6 | 9 | 4 | enabled |
fa_forecast_versions | public | 10 | 5 | 3 | 4 | enabled |
fa_funds | public | 16 | 2 | 3 | 4 | enabled |
fa_grant_drawdowns | public | 21 | 6 | 4 | 4 | enabled |
fa_import_jobs | public | 11 | 2 | 3 | 4 | enabled |
fa_indirect_cost_pools | public | 18 | 5 | 3 | 4 | enabled |
fa_indirect_cost_rates | public | 18 | 6 | 5 | 4 | enabled |
fa_investments | public | 21 | 6 | 6 | 4 | enabled |
fa_invoice_lines | public | 14 | 3 | 5 | 8 | enabled |
fa_invoices | public | 23 | 7 | 6 | 4 | enabled |
fa_journal_entries | public | 21 | 3 | 7 | 4 | enabled |
fa_journal_entry_lines | public | 13 | 4 | 5 | 4 | enabled |
fa_kpi_definitions | public | 17 | 4 | 3 | 4 | enabled |
fa_kpi_history | public | 10 | 4 | 3 | 4 | enabled |
fa_module_settings | public | 67 | 2 | 3 | 4 | enabled |
fa_payment_applications | public | 7 | 1 | 3 | 4 | enabled |
fa_payment_batches | public | 16 | 1 | 4 | 4 | enabled |
fa_payment_plan_audit_log | public | 12 | 4 | 4 | 2 | enabled |
fa_payment_plan_installments | public | 20 | 6 | 6 | 4 | enabled |
fa_payment_plans | public | 36 | 7 | 9 | 4 | enabled |
fa_payments | public | 15 | 1 | 5 | 4 | enabled |
fa_period_close_audit | public | 7 | 3 | 3 | 1 | enabled |
fa_plaid_sync_log | public | 21 | 5 | 4 | 3 | enabled |
fa_plaid_transfer_intents | public | 5 | 4 | 2 | 2 | enabled |
fa_pm_event_log | public | 9 | 5 | 2 | 3 | enabled |
fa_po_amendments | public | 12 | 2 | 3 | 4 | enabled |
fa_po_receipt_lines | public | 7 | 1 | 2 | 4 | enabled |
fa_po_receipts | public | 16 | 2 | 6 | 4 | enabled |
fa_programs | public | 13 | 2 | 3 | 4 | enabled |
fa_project_budgets | public | 22 | 4 | 8 | 4 | enabled |
fa_project_expenses | public | 19 | 5 | 5 | 4 | enabled |
fa_project_revenue | public | 17 | 4 | 5 | 4 | enabled |
fa_projects | public | 34 | 7 | 6 | 4 | enabled |
fa_purchase_order_lines | public | 18 | 3 | 5 | 8 | enabled |
fa_purchase_orders | public | 25 | 3 | 7 | 4 | enabled |
fa_ramp_connections | public | 16 | 3 | 5 | 4 | enabled |
fa_reconciliation_adjustments | public | 11 | 1 | 4 | 4 | enabled |
fa_reconciliation_matches | public | 14 | 3 | 5 | 6 | enabled |
fa_recurring_entries | public | 16 | 1 | 3 | 4 | enabled |
fa_recurring_invoice_lines | public | 19 | 4 | 6 | 4 | enabled |
fa_recurring_invoices | public | 24 | 5 | 4 | 4 | enabled |
fa_recurring_transaction_templates | public | 17 | 6 | 4 | 4 | enabled |
fa_report_annotations | public | 11 | 4 | 4 | 4 | enabled |
fa_report_definitions | public | 11 | 2 | 2 | 4 | enabled |
fa_report_favorites | public | 6 | 4 | 3 | 3 | enabled |
fa_report_recipients | public | 7 | 1 | 1 | 4 | enabled |
fa_report_runs | public | 20 | 1 | 3 | 4 | enabled |
fa_report_schedules | public | 16 | 1 | 3 | 4 | enabled |
fa_report_versions | public | 11 | 3 | 3 | 4 | enabled |
fa_rolling_forecasts | public | 18 | 5 | 4 | 4 | enabled |
fa_scenario_budget_lines | public | 17 | 6 | 9 | 4 | enabled |
fa_tax_distributions | public | 18 | 4 | 4 | 4 | enabled |
fa_tax_reports | public | 19 | 3 | 5 | 4 | enabled |
fa_tax_years | public | 15 | 3 | 4 | 4 | enabled |
fa_transaction_rules | public | 25 | 4 | 7 | 4 | enabled |
fa_vendor_bill_lines | public | 15 | 3 | 6 | 8 | enabled |
fa_vendor_bills | public | 22 | 5 | 7 | 4 | enabled |
fa_vendors | public | 30 | 3 | 5 | 4 | enabled |
fa_w2_forms | public | 27 | 4 | 6 | 3 | enabled |
HR tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
hr_aca_compliance | public | 19 | 4 | 3 | 4 | enabled |
hr_aca_employee_coverage | public | 11 | 5 | 3 | 4 | enabled |
hr_analytics_cache | public | 8 | 6 | 1 | 4 | enabled |
hr_applications | public | 24 | 3 | 7 | 4 | enabled |
hr_availability_preferences | public | 14 | 1 | 4 | 4 | enabled |
hr_background_check_providers | public | 21 | 5 | 3 | 4 | enabled |
hr_background_check_webhook_dlq | public | 24 | 3 | 5 | 4 | enabled |
hr_background_check_webhooks | public | 20 | 6 | 6 | 4 | enabled |
hr_background_checks | public | 32 | 9 | 6 | 4 | enabled |
hr_benefits_dependents | public | 23 | 1 | 6 | 4 | enabled |
hr_benefits_eligibility_rules | public | 20 | 2 | 4 | 4 | enabled |
hr_benefits_enrollment_dependents | public | 9 | 3 | 3 | 4 | enabled |
hr_benefits_enrollments | public | 25 | 1 | 7 | 4 | enabled |
hr_benefits_guides | public | 16 | 4 | 5 | 4 | enabled |
hr_benefits_life_events | public | 19 | 5 | 5 | 4 | enabled |
hr_benefits_open_enrollment_periods | public | 20 | 1 | 3 | 4 | enabled |
hr_benefits_plans | public | 32 | 1 | 5 | 4 | enabled |
hr_candidate_communications | public | 25 | 7 | 6 | 4 | enabled |
hr_candidate_portal_accounts | public | 22 | 7 | 4 | 4 | enabled |
hr_candidate_portal_sessions | public | 9 | 4 | 2 | 2 | enabled |
hr_candidates | public | 29 | 4 | 4 | 4 | enabled |
hr_career_paths | public | 16 | 5 | 5 | 4 | enabled |
hr_clinical_oversight_relationships | public | 17 | 7 | 7 | 4 | enabled |
hr_clinical_oversight_requirements | public | 17 | 5 | 5 | 4 | enabled |
hr_clinical_oversight_sessions | public | 26 | 7 | 7 | 4 | enabled |
hr_cobra_elections | public | 21 | 4 | 2 | 4 | enabled |
hr_cobra_events | public | 20 | 5 | 4 | 4 | enabled |
hr_communication_templates | public | 16 | 5 | 3 | 4 | enabled |
hr_compensation_analyses | public | 21 | 4 | 7 | 4 | enabled |
hr_competency_framework_skills | public | 14 | 2 | 5 | 2 | enabled |
hr_competency_frameworks | public | 12 | 1 | 4 | 2 | enabled |
hr_credential_alerts | public | 9 | 1 | 3 | 2 | enabled |
hr_credential_renewal_workflows | public | 30 | 3 | 11 | 4 | enabled |
hr_credential_requirements | public | 13 | 1 | 5 | 2 | enabled |
hr_credential_types | public | 19 | 2 | 3 | 4 | enabled |
hr_deduction_types | public | 16 | 8 | 1 | 4 | enabled |
hr_disciplinary_actions | public | 25 | 1 | 6 | 4 | enabled |
hr_document_access_logs | public | 11 | 1 | 3 | 2 | enabled |
hr_employee_bank_accounts | public | 26 | 7 | 5 | 4 | enabled |
hr_employee_credentials | public | 20 | 4 | 7 | 4 | enabled |
hr_employee_deductions | public | 23 | 7 | 5 | 4 | enabled |
hr_employee_leave_balances | public | 16 | 2 | 5 | 4 | enabled |
hr_employee_preferences | public | 11 | 2 | 4 | 3 | enabled |
hr_employee_sites | public | 11 | 2 | 5 | 2 | enabled |
hr_employee_skills | public | 21 | 2 | 8 | 4 | enabled |
hr_employee_tax_info | public | 21 | 4 | 4 | 3 | enabled |
hr_employee_teams | public | 11 | 2 | 4 | 2 | enabled |
hr_employees | public | 45 | 15 | 11 | 5 | enabled |
hr_employer_tax_config | public | 24 | 3 | 3 | 4 | enabled |
hr_engagement_action_plans | public | 20 | 8 | 7 | 4 | enabled |
hr_engagement_analytics | public | 17 | 4 | 4 | 4 | enabled |
hr_engagement_surveys | public | 20 | 5 | 4 | 4 | enabled |
hr_enrollment_reminder_logs | public | 9 | 4 | 5 | 2 | enabled |
hr_entra_sync_log | public | 13 | 6 | 3 | 2 | enabled |
hr_entra_sync_pending_changes | public | 17 | 3 | 5 | 4 | enabled |
hr_entra_unmatched_users | public | 24 | 6 | 5 | 4 | enabled |
hr_exit_interviews | public | 20 | 5 | 7 | 4 | enabled |
hr_federal_tax_brackets | public | 13 | 7 | 3 | 4 | enabled |
hr_fica_config | public | 15 | 5 | 3 | 4 | enabled |
hr_fmla_cases | public | 21 | 2 | 5 | 4 | enabled |
hr_grievances | public | 19 | 1 | 6 | 4 | enabled |
hr_hire_transitions | public | 12 | 2 | 7 | 3 | enabled |
hr_holidays | public | 9 | 3 | 3 | 4 | enabled |
hr_incidents | public | 23 | 2 | 6 | 4 | enabled |
hr_interview_feedback | public | 20 | 2 | 5 | 4 | enabled |
hr_interviews | public | 20 | 2 | 5 | 4 | enabled |
hr_investigations | public | 21 | 1 | 7 | 4 | enabled |
hr_job_board_integrations | public | 27 | 4 | 7 | 4 | enabled |
hr_job_board_postings | public | 21 | 4 | 5 | 4 | enabled |
hr_job_description_agreements | public | 17 | 5 | 7 | 4 | enabled |
hr_job_postings | public | 30 | 4 | 7 | 4 | enabled |
hr_leadership_programs | public | 21 | 5 | 5 | 4 | enabled |
hr_leave_accrual_tiers | public | 11 | 2 | 4 | 4 | enabled |
hr_leave_policies | public | 22 | 2 | 3 | 4 | enabled |
hr_leave_requests | public | 25 | 5 | 8 | 5 | enabled |
hr_merit_increases | public | 21 | 5 | 6 | 4 | enabled |
hr_module_settings | public | 104 | 2 | 5 | 2 | enabled |
hr_offboarding_checklist_items | public | 13 | 1 | 4 | 3 | enabled |
hr_offboarding_instances | public | 15 | 1 | 4 | 2 | enabled |
hr_offer_approvals | public | 12 | 1 | 3 | 4 | enabled |
hr_offer_counteroffers | public | 19 | 1 | 4 | 4 | enabled |
hr_offer_templates | public | 22 | 1 | 5 | 4 | enabled |
hr_offers | public | 34 | 3 | 9 | 4 | enabled |
hr_onboarding_instances | public | 13 | 2 | 5 | 4 | enabled |
hr_onboarding_task_instances | public | 19 | 1 | 8 | 3 | enabled |
hr_onboarding_tasks | public | 16 | 2 | 4 | 2 | enabled |
hr_onboarding_tasks_audit | public | 8 | 0 | 0 | 4 | enabled |
hr_onboarding_templates | public | 13 | 1 | 5 | 2 | enabled |
hr_pay_adjustments | public | 18 | 1 | 6 | 4 | enabled |
hr_pay_calendar_events | public | 15 | 5 | 5 | 4 | enabled |
hr_pay_rates | public | 17 | 2 | 5 | 4 | enabled |
hr_pay_schedules | public | 23 | 4 | 3 | 4 | enabled |
hr_pay_stubs | public | 16 | 6 | 6 | 4 | enabled |
hr_payment_batches | public | 21 | 5 | 5 | 4 | enabled |
hr_payment_checks | public | 15 | 5 | 5 | 4 | enabled |
hr_payment_items | public | 19 | 6 | 6 | 4 | enabled |
hr_payroll_audit_log | public | 15 | 1 | 4 | 2 | enabled |
hr_payroll_deduction_items | public | 11 | 4 | 5 | 2 | enabled |
hr_payroll_exports | public | 12 | 1 | 4 | 4 | enabled |
hr_payroll_line_items | public | 36 | 2 | 6 | 4 | enabled |
hr_payroll_runs | public | 27 | 1 | 6 | 3 | enabled |
hr_performance_competencies | public | 16 | 5 | 5 | 4 | enabled |
hr_performance_cycles | public | 19 | 6 | 4 | 4 | enabled |
hr_performance_feedback | public | 21 | 6 | 7 | 4 | enabled |
hr_performance_goals | public | 20 | 6 | 5 | 4 | enabled |
hr_performance_improvement_plans | public | 21 | 6 | 6 | 4 | enabled |
hr_performance_reviews | public | 24 | 6 | 7 | 4 | enabled |
hr_position_skill_requirements | public | 14 | 2 | 5 | 2 | enabled |
hr_positions | public | 21 | 3 | 3 | 4 | enabled |
hr_reference_emails | public | 14 | 3 | 3 | 4 | enabled |
hr_references | public | 46 | 10 | 6 | 4 | enabled |
hr_salary_bands | public | 18 | 4 | 4 | 4 | enabled |
hr_sharepoint_memberships | public | 18 | 5 | 5 | 4 | enabled |
hr_shift_assignments | public | 15 | 2 | 5 | 4 | enabled |
hr_shift_swap_requests | public | 14 | 1 | 7 | 4 | enabled |
hr_shift_templates | public | 19 | 1 | 5 | 4 | enabled |
hr_shifts | public | 18 | 1 | 7 | 4 | enabled |
hr_site_geofence | public | 15 | 4 | 4 | 4 | enabled |
hr_skills_assessments | public | 17 | 1 | 6 | 3 | enabled |
hr_skills_library | public | 17 | 3 | 4 | 2 | enabled |
hr_sms_consent_logs | public | 22 | 5 | 8 | 4 | enabled |
hr_ssn_access_log | public | 11 | 1 | 3 | 2 | enabled |
hr_succession_plans | public | 22 | 7 | 7 | 4 | enabled |
hr_survey_responses | public | 14 | 5 | 4 | 4 | enabled |
hr_talent_pipelines | public | 21 | 6 | 7 | 4 | enabled |
hr_tax_documents | public | 18 | 2 | 6 | 6 | enabled |
hr_tax_form_items | public | 17 | 3 | 7 | 4 | enabled |
hr_tax_form_runs | public | 25 | 3 | 5 | 4 | enabled |
hr_tax_form_state_items | public | 12 | 4 | 4 | 4 | enabled |
hr_team_members | public | 10 | 2 | 4 | 2 | enabled |
hr_teams_memberships | public | 19 | 5 | 5 | 4 | enabled |
hr_time_exceptions | public | 17 | 1 | 6 | 4 | enabled |
hr_time_punches | public | 17 | 1 | 5 | 4 | enabled |
hr_timesheet_entries | public | 15 | 1 | 4 | 5 | enabled |
hr_timesheets | public | 19 | 2 | 5 | 4 | enabled |
hr_total_compensation_statements | public | 22 | 4 | 4 | 4 | enabled |
hr_workload_accuracy_tracking | public | 13 | 1 | 2 | 2 | enabled |
hr_workload_approvals | public | 17 | 1 | 6 | 3 | enabled |
hr_workload_calculations | public | 16 | 1 | 5 | 4 | enabled |
hr_workload_driver_versions | public | 10 | 1 | 2 | 2 | enabled |
hr_workload_drivers | public | 25 | 1 | 7 | 4 | enabled |
hr_workload_forecasts | public | 20 | 2 | 5 | 4 | enabled |
hr_workload_pto_patterns | public | 14 | 1 | 3 | 4 | enabled |
hr_workload_scenarios | public | 14 | 1 | 5 | 4 | enabled |
GR tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
gr_accreditation_audit_links | public | 9 | 2 | 4 | 4 | enabled |
gr_accreditation_caps | public | 17 | 7 | 7 | 4 | enabled |
gr_accreditation_compliance_links | public | 9 | 2 | 4 | 4 | enabled |
gr_accreditation_evidence | public | 20 | 1 | 7 | 4 | enabled |
gr_accreditation_mock_surveys | public | 14 | 4 | 5 | 4 | enabled |
gr_accreditation_standards | public | 17 | 2 | 5 | 4 | enabled |
gr_accreditation_surveys | public | 23 | 1 | 5 | 4 | enabled |
gr_accreditation_tracer_packs | public | 15 | 4 | 6 | 4 | enabled |
gr_accreditations | public | 20 | 1 | 4 | 4 | enabled |
gr_ai_audit_prep | public | 17 | 1 | 3 | 4 | enabled |
gr_ai_compliance_suggestions | public | 18 | 1 | 5 | 4 | enabled |
gr_ai_gap_analyses | public | 17 | 1 | 3 | 4 | enabled |
gr_ai_risk_assessments | public | 19 | 1 | 3 | 4 | enabled |
gr_audit_checklists | public | 15 | 2 | 3 | 4 | enabled |
gr_audit_corrective_actions | public | 16 | 1 | 7 | 4 | enabled |
gr_audit_evidence | public | 13 | 1 | 7 | 3 | enabled |
gr_audit_findings | public | 20 | 1 | 8 | 4 | enabled |
gr_audit_team_assignments | public | 9 | 2 | 3 | 4 | enabled |
gr_audits | public | 21 | 4 | 5 | 4 | enabled |
gr_board_minutes | public | 16 | 3 | 5 | 4 | enabled |
gr_board_resolutions | public | 18 | 5 | 6 | 3 | enabled |
gr_ceu_credits | public | 21 | 1 | 6 | 6 | enabled |
gr_coi_attestations | public | 16 | 5 | 5 | 3 | enabled |
gr_compliance_checks | public | 20 | 1 | 7 | 4 | enabled |
gr_compliance_evidence | public | 21 | 1 | 7 | 4 | enabled |
gr_compliance_remediation | public | 26 | 1 | 10 | 4 | enabled |
gr_compliance_submissions | public | 21 | 1 | 7 | 4 | enabled |
gr_contract_alerts | public | 18 | 1 | 5 | 4 | enabled |
gr_contract_amendments | public | 22 | 2 | 6 | 4 | enabled |
gr_contract_milestones | public | 16 | 1 | 5 | 4 | enabled |
gr_contract_obligations | public | 22 | 1 | 6 | 4 | enabled |
gr_contract_types | public | 13 | 2 | 2 | 4 | enabled |
gr_contracts | public | 42 | 5 | 6 | 4 | enabled |
gr_holiday_calendar | public | 5 | 3 | 1 | 4 | enabled |
gr_incident_corrective_actions | public | 19 | 5 | 9 | 3 | enabled |
gr_incident_findings | public | 12 | 3 | 4 | 2 | enabled |
gr_incident_investigations | public | 21 | 4 | 7 | 3 | enabled |
gr_incident_regulatory_reports | public | 21 | 5 | 7 | 4 | enabled |
gr_incident_risk_links | public | 10 | 5 | 5 | 3 | enabled |
gr_incidents | public | 24 | 7 | 8 | 4 | enabled |
gr_module_settings | public | 63 | 2 | 3 | 4 | enabled |
gr_policies | public | 25 | 5 | 9 | 4 | enabled |
gr_policy_acknowledgments | public | 17 | 1 | 7 | 4 | enabled |
gr_policy_assignments | public | 17 | 1 | 7 | 4 | enabled |
gr_policy_regulatory_links | public | 12 | 1 | 4 | 4 | enabled |
gr_policy_versions | public | 12 | 2 | 5 | 3 | enabled |
gr_procedure_executions | public | 18 | 7 | 6 | 3 | enabled |
gr_procedure_policy_links | public | 8 | 5 | 4 | 3 | enabled |
gr_procedure_steps | public | 18 | 6 | 4 | 4 | enabled |
gr_procedure_templates | public | 19 | 5 | 4 | 5 | enabled |
gr_procedure_versions | public | 13 | 5 | 4 | 2 | enabled |
gr_procedures | public | 23 | 10 | 7 | 4 | enabled |
gr_qi_improvements | public | 18 | 1 | 9 | 4 | enabled |
gr_qi_metric_measurements | public | 11 | 1 | 4 | 4 | enabled |
gr_qi_metrics | public | 18 | 1 | 4 | 4 | enabled |
gr_qi_pdsa_cycles | public | 26 | 2 | 6 | 4 | enabled |
gr_qi_project_templates | public | 17 | 1 | 3 | 4 | enabled |
gr_qi_projects | public | 18 | 1 | 5 | 4 | enabled |
gr_regulatory_bodies | public | 14 | 2 | 2 | 4 | enabled |
gr_regulatory_reporting_rules | public | 14 | 3 | 3 | 4 | enabled |
gr_regulatory_requirements | public | 24 | 1 | 6 | 4 | enabled |
gr_risk_assessments | public | 14 | 1 | 3 | 4 | enabled |
gr_risk_links | public | 13 | 5 | 7 | 4 | enabled |
gr_risk_mitigations | public | 22 | 1 | 7 | 4 | enabled |
gr_risks | public | 24 | 2 | 6 | 4 | enabled |
gr_training_completions | public | 21 | 1 | 8 | 4 | enabled |
gr_training_courses | public | 25 | 1 | 5 | 5 | enabled |
gr_training_enrollments | public | 18 | 2 | 5 | 6 | enabled |
gr_training_policy_links | public | 10 | 2 | 5 | 3 | enabled |
gr_whistleblower_reports | public | 15 | 5 | 5 | 3 | enabled |
FW tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
fw_action_templates | public | 13 | 1 | 3 | 4 | enabled |
fw_api_connections | public | 22 | 2 | 3 | 4 | enabled |
fw_approval_assignments | public | 21 | 2 | 9 | 4 | enabled |
fw_approval_chains | public | 14 | 2 | 6 | 4 | enabled |
fw_approval_delegations | public | 12 | 1 | 4 | 4 | enabled |
fw_approval_history | public | 11 | 1 | 5 | 2 | enabled |
fw_approval_requests | public | 23 | 1 | 7 | 4 | enabled |
fw_approval_steps | public | 18 | 2 | 4 | 4 | enabled |
fw_automation_actions | public | 7 | 1 | 1 | 2 | enabled |
fw_automation_logs | public | 9 | 1 | 2 | 1 | enabled |
fw_automation_rules | public | 24 | 1 | 5 | 4 | enabled |
fw_business_calendars | public | 12 | 3 | 3 | 4 | enabled |
fw_calendar_holidays | public | 8 | 4 | 2 | 4 | enabled |
fw_debug_sessions | public | 14 | 1 | 6 | 4 | enabled |
fw_domain_events | public | 11 | 1 | 2 | 2 | enabled |
fw_execution_logs | public | 13 | 1 | 5 | 3 | enabled |
fw_form_fields | public | 16 | 2 | 2 | 6 | enabled |
fw_form_permissions | public | 7 | 3 | 2 | 2 | enabled |
fw_form_portal_config | public | 31 | 3 | 4 | 4 | enabled |
fw_form_submission_signatures | public | 11 | 2 | 5 | 2 | enabled |
fw_form_submissions | public | 21 | 6 | 5 | 4 | enabled |
fw_form_template_ratings | public | 12 | 2 | 4 | 4 | enabled |
fw_form_templates | public | 24 | 3 | 5 | 4 | enabled |
fw_form_versions | public | 11 | 3 | 3 | 4 | enabled |
fw_forms | public | 19 | 3 | 4 | 3 | enabled |
fw_kpi_configurations | public | 11 | 2 | 3 | 4 | enabled |
fw_kpi_report_schedules | public | 12 | 2 | 3 | 4 | enabled |
fw_kpi_snapshots | public | 9 | 4 | 2 | 1 | enabled |
fw_module_settings | public | 33 | 2 | 3 | 5 | enabled |
fw_page_templates | public | 23 | 2 | 3 | 4 | enabled |
fw_portal_rate_limits | public | 10 | 2 | 1 | 4 | enabled |
fw_portal_submissions | public | 22 | 3 | 3 | 3 | enabled |
fw_query_whitelist | public | 13 | 2 | 3 | 4 | enabled |
fw_sandbox_executions | public | 20 | 1 | 6 | 4 | enabled |
fw_signature_audit_log | public | 10 | 1 | 3 | 2 | enabled |
fw_subflows | public | 15 | 1 | 3 | 4 | enabled |
fw_submission_attachments | public | 11 | 1 | 2 | 3 | enabled |
fw_submission_notes | public | 7 | 1 | 3 | 4 | enabled |
fw_submission_sections | public | 17 | 4 | 5 | 4 | enabled |
fw_template_update_notifications | public | 11 | 1 | 4 | 4 | enabled |
fw_test_cases | public | 25 | 2 | 7 | 4 | enabled |
fw_test_coverage | public | 19 | 2 | 5 | 4 | enabled |
fw_test_datasets | public | 18 | 1 | 5 | 4 | enabled |
fw_test_scenarios | public | 19 | 2 | 6 | 4 | enabled |
fw_workflow_alert_rules | public | 21 | 2 | 5 | 4 | enabled |
fw_workflow_alerts | public | 20 | 1 | 7 | 3 | enabled |
fw_workflow_approvals | public | 15 | 1 | 4 | 4 | enabled |
fw_workflow_best_practices | public | 10 | 2 | 0 | 4 | enabled |
fw_workflow_compliance_scores | public | 16 | 4 | 4 | 4 | enabled |
fw_workflow_definitions | public | 12 | 2 | 4 | 4 | enabled |
fw_workflow_events | public | 12 | 2 | 0 | 1 | enabled |
fw_workflow_executions | public | 24 | 2 | 4 | 4 | enabled |
fw_workflow_notification_preferences | public | 19 | 2 | 3 | 4 | enabled |
fw_workflow_notification_rules | public | 17 | 2 | 5 | 4 | enabled |
fw_workflow_optimization_suggestions | public | 25 | 4 | 6 | 4 | enabled |
fw_workflow_path_analytics | public | 20 | 2 | 4 | 4 | enabled |
fw_workflow_performance_metrics | public | 22 | 2 | 4 | 4 | enabled |
fw_workflow_template_ratings | public | 12 | 2 | 4 | 4 | enabled |
fw_workflow_template_usage | public | 10 | 1 | 3 | 4 | enabled |
fw_workflow_template_versions | public | 12 | 2 | 3 | 3 | enabled |
fw_workflow_templates | public | 23 | 3 | 4 | 4 | enabled |
fw_workflow_version_comparisons | public | 30 | 2 | 4 | 4 | enabled |
fw_workflow_versions | public | 11 | 2 | 3 | 2 | enabled |
FM tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
fm_asset_depreciation | public | 14 | 2 | 4 | 4 | enabled |
fm_asset_locations | public | 15 | 1 | 5 | 2 | enabled |
fm_asset_maintenance_history | public | 19 | 2 | 4 | 2 | enabled |
fm_assets | public | 47 | 5 | 5 | 4 | enabled |
fm_fleet_drivers | public | 22 | 5 | 4 | 4 | enabled |
fm_fleet_fuel_logs | public | 21 | 5 | 5 | 4 | enabled |
fm_fleet_maintenance_schedules | public | 22 | 5 | 4 | 4 | enabled |
fm_fleet_mileage_logs | public | 10 | 4 | 4 | 4 | enabled |
fm_fleet_reservations | public | 14 | 6 | 5 | 4 | enabled |
fm_fleet_trips | public | 20 | 6 | 5 | 4 | enabled |
fm_fleet_vehicles | public | 27 | 9 | 5 | 4 | enabled |
fm_inventory_item_locations | public | 10 | 2 | 5 | 4 | enabled |
fm_inventory_items | public | 25 | 5 | 5 | 4 | enabled |
fm_inventory_locations | public | 13 | 2 | 4 | 4 | enabled |
fm_inventory_transactions | public | 22 | 1 | 8 | 2 | enabled |
fm_module_settings | public | 40 | 2 | 3 | 4 | enabled |
fm_pm_completions | public | 12 | 2 | 4 | 2 | enabled |
fm_pm_schedules | public | 17 | 1 | 7 | 4 | enabled |
fm_pm_template_checklist_items | public | 11 | 2 | 4 | 4 | enabled |
fm_pm_template_materials | public | 10 | 2 | 5 | 4 | enabled |
fm_pm_templates | public | 19 | 2 | 4 | 4 | enabled |
fm_vendor_certifications | public | 21 | 1 | 5 | 4 | enabled |
fm_vendor_sites | public | 10 | 2 | 5 | 4 | enabled |
fm_vendor_work_orders | public | 30 | 2 | 7 | 4 | enabled |
fm_vendors | public | 37 | 5 | 4 | 4 | enabled |
fm_work_order_attachments | public | 16 | 1 | 3 | 3 | enabled |
fm_work_order_history | public | 13 | 1 | 3 | 2 | enabled |
fm_work_order_materials | public | 18 | 1 | 5 | 4 | enabled |
fm_work_orders | public | 49 | 9 | 8 | 4 | enabled |
LO tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
lo_accountability_chart | public | 11 | 2 | 3 | 5 | enabled |
lo_assessment_recipients | public | 8 | 2 | 3 | 4 | enabled |
lo_assessment_responses | public | 11 | 2 | 3 | 4 | enabled |
lo_assessment_schedules | public | 15 | 1 | 4 | 4 | enabled |
lo_assessments | public | 12 | 1 | 4 | 4 | enabled |
lo_feedback | public | 14 | 1 | 7 | 4 | enabled |
lo_gwc_assessments | public | 18 | 1 | 5 | 5 | enabled |
lo_issue_discussions | public | 9 | 1 | 4 | 4 | enabled |
lo_issues | public | 18 | 3 | 7 | 4 | enabled |
lo_knowledge_article_versions | public | 10 | 2 | 3 | 2 | enabled |
lo_knowledge_articles | public | 19 | 3 | 4 | 4 | enabled |
lo_knowledge_categories | public | 13 | 2 | 4 | 4 | enabled |
lo_meeting_action_items | public | 12 | 1 | 6 | 4 | enabled |
lo_meeting_attendees | public | 10 | 2 | 5 | 4 | enabled |
lo_meetings | public | 16 | 2 | 3 | 4 | enabled |
lo_module_settings | public | 36 | 2 | 3 | 5 | enabled |
lo_one_on_ones | public | 16 | 1 | 5 | 4 | enabled |
lo_quarterly_rocks | public | 27 | 1 | 7 | 6 | enabled |
lo_rock_assignments | public | 10 | 2 | 5 | 4 | enabled |
lo_rock_milestones | public | 20 | 1 | 6 | 5 | enabled |
lo_role_definitions | public | 16 | 1 | 5 | 5 | enabled |
lo_scorecard_metrics | public | 19 | 1 | 5 | 4 | enabled |
lo_scorecard_values | public | 11 | 2 | 5 | 4 | enabled |
lo_scorecards | public | 11 | 2 | 4 | 4 | enabled |
lo_seat_assignments | public | 12 | 2 | 5 | 5 | enabled |
lo_strategic_goals | public | 21 | 2 | 6 | 5 | enabled |
lo_todo_comments | public | 7 | 1 | 3 | 4 | enabled |
lo_todos | public | 18 | 2 | 6 | 4 | enabled |
lo_vision_documents | public | 13 | 2 | 4 | 6 | enabled |
IT tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
it_access_accounts | public | 16 | 1 | 4 | 4 | enabled |
it_asset_assignments | public | 21 | 2 | 7 | 4 | enabled |
it_asset_maintenance | public | 15 | 1 | 5 | 4 | enabled |
it_assets | public | 43 | 2 | 4 | 4 | enabled |
it_change_approvals | public | 13 | 1 | 4 | 4 | enabled |
it_change_blackouts | public | 11 | 1 | 3 | 4 | enabled |
it_change_history | public | 11 | 1 | 3 | 2 | enabled |
it_change_implementations | public | 17 | 8 | 6 | 4 | enabled |
it_change_requests | public | 30 | 5 | 7 | 4 | enabled |
it_change_tasks | public | 16 | 1 | 3 | 4 | enabled |
it_change_templates | public | 18 | 1 | 3 | 4 | enabled |
it_compliance_requirements | public | 16 | 1 | 3 | 4 | enabled |
it_dashboard_preferences | public | 11 | 2 | 2 | 4 | enabled |
it_knowledge_base | public | 18 | 1 | 3 | 4 | enabled |
it_knowledge_base_versions | public | 10 | 4 | 3 | 2 | enabled |
it_license_assignments | public | 14 | 1 | 6 | 4 | enabled |
it_licenses | public | 30 | 1 | 4 | 4 | enabled |
it_module_settings | public | 65 | 2 | 3 | 2 | enabled |
it_onboarding_instances | public | 18 | 1 | 6 | 4 | enabled |
it_onboarding_task_instances | public | 20 | 2 | 5 | 4 | enabled |
it_onboarding_tasks | public | 14 | 2 | 2 | 4 | enabled |
it_onboarding_templates | public | 15 | 1 | 3 | 4 | enabled |
it_patch_deployments | public | 10 | 2 | 4 | 4 | enabled |
it_purchase_request_items | public | 14 | 1 | 3 | 4 | enabled |
it_purchase_requests | public | 31 | 2 | 8 | 4 | enabled |
it_report_definitions | public | 20 | 1 | 2 | 4 | enabled |
it_report_runs | public | 19 | 1 | 4 | 4 | enabled |
it_security_incidents | public | 16 | 1 | 4 | 4 | enabled |
it_security_patches | public | 15 | 2 | 4 | 4 | enabled |
it_sla_policies | public | 14 | 2 | 3 | 4 | enabled |
it_ticket_attachments | public | 11 | 1 | 5 | 2 | enabled |
it_ticket_comments | public | 9 | 1 | 3 | 2 | enabled |
it_tickets | public | 27 | 6 | 8 | 4 | enabled |
it_vendor_contracts | public | 20 | 2 | 4 | 4 | enabled |
it_vendors | public | 25 | 2 | 3 | 4 | enabled |
it_vulnerabilities | public | 16 | 1 | 3 | 4 | enabled |
it_vulnerability_assets | public | 9 | 2 | 5 | 4 | enabled |
CL tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
cl_988_transfers | public | 21 | 4 | 6 | 4 | enabled |
cl_aftercare_plans | public | 17 | 4 | 5 | 4 | enabled |
cl_allergies | public | 16 | 4 | 5 | 4 | enabled |
cl_assessment_instruments | public | 15 | 4 | 3 | 4 | enabled |
cl_assessment_sections | public | 13 | 4 | 4 | 4 | enabled |
cl_assessments | public | 24 | 8 | 9 | 4 | enabled |
cl_between_session_checkins | public | 11 | 3 | 3 | 3 | enabled |
cl_biometrics | public | 14 | 5 | 5 | 4 | enabled |
cl_care_gaps | public | 18 | 5 | 5 | 4 | enabled |
cl_cds_alerts | public | 18 | 6 | 6 | 3 | enabled |
cl_cds_rules | public | 17 | 4 | 4 | 4 | enabled |
cl_consent_requests | public | 16 | 6 | 6 | 4 | enabled |
cl_consents | public | 22 | 7 | 6 | 4 | enabled |
cl_controlled_substance_inventory | public | 22 | 8 | 7 | 4 | enabled |
cl_data_exchange_log | public | 15 | 3 | 3 | 2 | enabled |
cl_designated_contacts | public | 16 | 4 | 5 | 4 | enabled |
cl_disclosure_log | public | 13 | 5 | 5 | 4 | enabled |
cl_environmental_assessments | public | 22 | 6 | 6 | 4 | enabled |
cl_family_notification_log | public | 16 | 3 | 6 | 2 | enabled |
cl_fhir_resources | public | 14 | 5 | 4 | 4 | enabled |
cl_follow_up_contacts | public | 14 | 5 | 6 | 4 | enabled |
cl_group_attendance | public | 16 | 5 | 5 | 4 | enabled |
cl_group_curricula | public | 12 | 3 | 3 | 4 | enabled |
cl_group_sessions | public | 22 | 6 | 5 | 4 | enabled |
cl_inbasket_item_activity | public | 8 | 3 | 3 | 2 | enabled |
cl_inbasket_items | public | 20 | 7 | 6 | 4 | enabled |
cl_incidents | public | 18 | 5 | 4 | 4 | enabled |
cl_loinc_codes | public | 14 | 1 | 0 | 1 | enabled |
cl_medication_adherence | public | 18 | 6 | 6 | 4 | enabled |
cl_medication_education | public | 19 | 5 | 6 | 4 | enabled |
cl_medication_reconciliations | public | 17 | 7 | 6 | 4 | enabled |
cl_medications | public | 38 | 7 | 7 | 4 | enabled |
cl_metabolic_monitoring_events | public | 13 | 4 | 4 | 4 | enabled |
cl_module_settings | public | 31 | 3 | 3 | 4 | enabled |
cl_moud_enrollments | public | 15 | 3 | 6 | 4 | enabled |
cl_moud_medication_events | public | 17 | 4 | 5 | 4 | enabled |
cl_moud_monitoring_events | public | 14 | 6 | 5 | 4 | enabled |
cl_note_templates | public | 13 | 2 | 3 | 4 | enabled |
cl_note_treatment_goals | public | 6 | 5 | 4 | 4 | enabled |
cl_order_results | public | 24 | 6 | 6 | 4 | enabled |
cl_order_templates | public | 13 | 3 | 3 | 4 | enabled |
cl_orders | public | 25 | 9 | 8 | 4 | enabled |
cl_outcome_measures | public | 23 | 7 | 6 | 4 | enabled |
cl_pathway_definitions | public | 14 | 2 | 4 | 4 | enabled |
cl_pathway_progress | public | 16 | 4 | 5 | 4 | enabled |
cl_patient_charts | public | 16 | 7 | 5 | 4 | enabled |
cl_patient_submissions | public | 15 | 3 | 5 | 4 | enabled |
cl_pdmp_configuration | public | 13 | 3 | 3 | 4 | enabled |
cl_pdmp_queries | public | 21 | 6 | 8 | 4 | enabled |
cl_pending_lab_results | public | 22 | 9 | 7 | 4 | enabled |
cl_pharmacies | public | 15 | 3 | 0 | 4 | enabled |
cl_prescriptions | public | 30 | 5 | 4 | 4 | enabled |
cl_problems | public | 16 | 4 | 5 | 4 | enabled |
cl_program_attendance_summaries | public | 13 | 1 | 4 | 4 | enabled |
cl_program_enrollments | public | 11 | 1 | 5 | 4 | enabled |
cl_program_outcomes | public | 21 | 8 | 4 | 4 | enabled |
cl_program_schedules | public | 14 | 1 | 4 | 4 | enabled |
cl_progress_notes | public | 39 | 7 | 8 | 4 | enabled |
cl_readmission_risk_scores | public | 13 | 4 | 5 | 4 | enabled |
cl_reference_labs | public | 23 | 3 | 3 | 4 | enabled |
cl_reference_ranges | public | 18 | 3 | 3 | 4 | enabled |
cl_report_definitions | public | 15 | 2 | 3 | 4 | enabled |
cl_report_runs | public | 12 | 3 | 3 | 4 | enabled |
cl_risk_screenings | public | 17 | 6 | 5 | 4 | enabled |
cl_safety_plans | public | 27 | 5 | 6 | 4 | enabled |
cl_sdoh_screenings | public | 14 | 5 | 5 | 4 | enabled |
cl_social_referrals | public | 18 | 7 | 6 | 4 | enabled |
cl_standing_order_protocols | public | 13 | 3 | 4 | 4 | enabled |
cl_treatment_goal_bank | public | 14 | 4 | 4 | 4 | enabled |
cl_treatment_goals | public | 18 | 3 | 5 | 4 | enabled |
cl_treatment_interventions | public | 13 | 3 | 5 | 4 | enabled |
cl_treatment_plan_signatures | public | 12 | 5 | 5 | 4 | enabled |
cl_treatment_plan_templates | public | 12 | 4 | 3 | 4 | enabled |
cl_treatment_plans | public | 25 | 5 | 7 | 4 | enabled |
cl_vital_signs | public | 18 | 5 | 5 | 4 | enabled |
cl_warm_handoffs | public | 15 | 4 | 7 | 4 | enabled |
PM tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
pm_appeal_submissions | public | 18 | 3 | 6 | 3 | enabled |
pm_appeal_templates | public | 14 | 3 | 4 | 3 | enabled |
pm_appointment_reminders | public | 12 | 3 | 4 | 3 | enabled |
pm_appointments | public | 28 | 8 | 6 | 4 | enabled |
pm_audit_log | public | 11 | 5 | 2 | 1 | enabled |
pm_auth_reviews | public | 14 | 3 | 4 | 4 | enabled |
pm_batch_jobs | public | 14 | 4 | 2 | 3 | enabled |
pm_carc_codes | public | 6 | 1 | 0 | 1 | enabled |
pm_charges | public | 27 | 10 | 9 | 4 | enabled |
pm_claim_denials | public | 25 | 7 | 10 | 3 | enabled |
pm_claim_lines | public | 24 | 4 | 5 | 4 | enabled |
pm_claim_notes | public | 9 | 3 | 4 | 4 | enabled |
pm_claims | public | 31 | 10 | 8 | 4 | enabled |
pm_clearinghouse_config | public | 22 | 5 | 4 | 4 | enabled |
pm_code_modifier_rules | public | 12 | 3 | 3 | 4 | enabled |
pm_contracted_rates | public | 14 | 4 | 4 | 4 | enabled |
pm_emergency_contacts | public | 13 | 4 | 4 | 4 | enabled |
pm_encounters | public | 22 | 6 | 8 | 4 | enabled |
pm_era_files | public | 21 | 6 | 5 | 4 | enabled |
pm_fee_schedule_entries | public | 13 | 4 | 4 | 4 | enabled |
pm_fee_schedules | public | 13 | 4 | 4 | 4 | enabled |
pm_financial_assistance_applications | public | 15 | 4 | 4 | 4 | enabled |
pm_gfe_appointment_cpt_mapping | public | 10 | 4 | 3 | 4 | enabled |
pm_gfe_disputes | public | 13 | 4 | 4 | 4 | enabled |
pm_good_faith_estimates | public | 16 | 5 | 5 | 4 | enabled |
pm_group_definitions | public | 21 | 5 | 6 | 4 | enabled |
pm_group_enrollments | public | 16 | 6 | 5 | 4 | enabled |
pm_group_schedule | public | 20 | 5 | 7 | 4 | enabled |
pm_guarantors | public | 15 | 4 | 4 | 4 | enabled |
pm_insurance_policies | public | 15 | 4 | 5 | 4 | enabled |
pm_module_settings | public | 44 | 3 | 4 | 3 | enabled |
pm_patient_addresses | public | 19 | 4 | 4 | 4 | enabled |
pm_patient_financial_assessments | public | 19 | 5 | 5 | 4 | enabled |
pm_patient_site_transfers | public | 12 | 4 | 6 | 4 | enabled |
pm_patient_statements | public | 20 | 5 | 5 | 4 | enabled |
pm_patients | public | 25 | 11 | 4 | 4 | enabled |
pm_payer_contracts | public | 15 | 5 | 4 | 4 | enabled |
pm_payer_enrollments | public | 15 | 7 | 6 | 4 | enabled |
pm_payers | public | 12 | 3 | 3 | 4 | enabled |
pm_payment_applications | public | 18 | 7 | 6 | 4 | enabled |
pm_payment_plans | public | 15 | 5 | 4 | 4 | enabled |
pm_payments | public | 25 | 10 | 8 | 4 | enabled |
pm_portal_sessions | public | 9 | 4 | 2 | 4 | enabled |
pm_portal_users | public | 20 | 6 | 5 | 4 | enabled |
pm_prior_authorizations | public | 33 | 7 | 10 | 4 | enabled |
pm_provider_caseloads | public | 12 | 4 | 4 | 4 | enabled |
pm_provider_enrollment_events | public | 8 | 2 | 3 | 4 | enabled |
pm_provider_enrollments | public | 18 | 6 | 4 | 4 | enabled |
pm_provider_identifier_validations | public | 10 | 2 | 2 | 4 | enabled |
pm_provider_schedules | public | 17 | 6 | 5 | 4 | enabled |
pm_provider_time_off | public | 17 | 5 | 6 | 4 | enabled |
pm_rarc_codes | public | 6 | 1 | 0 | 1 | enabled |
pm_rcm_benchmarks | public | 14 | 2 | 3 | 4 | enabled |
pm_rcm_snapshots | public | 12 | 4 | 4 | 4 | enabled |
pm_referral_documents | public | 11 | 3 | 3 | 4 | enabled |
pm_referrals | public | 52 | 11 | 6 | 4 | enabled |
pm_scrub_rule_definitions | public | 10 | 2 | 0 | 1 | enabled |
pm_scrub_rule_overrides | public | 13 | 4 | 5 | 4 | enabled |
pm_site_billing_config | public | 16 | 6 | 6 | 4 | enabled |
pm_sliding_fee_schedules | public | 13 | 4 | 3 | 4 | enabled |
pm_statement_deliveries | public | 12 | 4 | 4 | 2 | enabled |
pm_statement_runs | public | 12 | 4 | 3 | 4 | enabled |
pm_superbills | public | 12 | 5 | 5 | 4 | enabled |
pm_telehealth_configuration | public | 17 | 4 | 3 | 4 | enabled |
pm_telehealth_sessions | public | 35 | 9 | 8 | 4 | enabled |
pm_transaction_batches | public | 18 | 7 | 4 | 4 | enabled |
pm_transaction_log | public | 12 | 7 | 5 | 4 | enabled |
pm_vbp_incentive_payments | public | 13 | 3 | 4 | 4 | enabled |
pm_vbp_measures | public | 16 | 3 | 4 | 4 | enabled |
pm_vbp_programs | public | 14 | 4 | 4 | 3 | enabled |
pm_waitlist | public | 15 | 4 | 6 | 4 | enabled |
OTHER tables
| Table | Schema | Columns | Indexes | FKs | Policies | RLS |
|---|
fpl_thresholds | public | 6 | 3 | 0 | 1 | enabled |
