SchemaSpy Analysis of harbinger.public
Generated by SchemaSpy on Tue Aug 16 14:31 UTC 2022
Database Type: PostgreSQL - 13.2 (Debian 13.2-1.pgdg100+1)

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Comments
application_categories 1 5
application_credentials 1 7
application_information 1 2 15
backend_statuses 7
card_case_authorizations 2 5
card_case_claim_transactions 2 4
card_case_claims 2 4
card_case_details 5 11
card_case_facts 21 118
card_case_metadata 3 6
card_case_metrics 1 23
card_case_personnel 18 20
card_case_procedure_mappings 2 4
card_case_times 1 30
card_cases 12 17 20
card_reports 6 7 14
claim_transaction_cms_modifiers 2 4
claim_transaction_diagnoses 2 4
claim_transaction_facts 17 38
claim_transaction_types 2 3
claim_transactions 7 11 22
claims 5 9 17
clinical_roles 1 4
cms_facility_types 1 5
cms_gpci 1 1 9
cms_hcpcs_code_revisions 2 4
cms_hcpcs_codes 3 3 14
cms_modifiers 2 3
configuration_variables 4
demographic_types 4 3
departments 4 3
dicom_protocols 1 2 5
dicom_series 10 18
dicom_studies 1 5 13
employee_clinical_role_mappings 3 5
employee_demos 2 5
employee_specialty_mappings 2 5
employees 70 1 6
equipment_models 3 1 4
equipment_serial_numbers 3 3
exam_metadata_types 3 3
exam_priorities 6 3
external_system_role_mappings 2 4
external_system_roles 1 4
external_system_statuses 12 2 5
external_systems 28 1 6
icd_code_revisions 1 5
icd_codes 2 1 5
identifier_types 1 3
identifiers 3 6
insurance_carrier_demographics 2 5
insurance_carrier_plan_groupings 2 3
insurance_carrier_plans 2 2 6
insurance_carriers 5 1 4
insurance_policies 6 2 8
job_metrics_logs 11
locales 6
manufacturers 5 3
metasite_associations 2 4
metasites 2 4
modalities 4 3
order_metadata 3 6
order_procedure_mappings 2 4
ordering_departments 2 4
orders 6 13 19
patient_demos 3 6
patient_demos_history 3 6
patient_events 7 10
patient_events_history 7 10
patient_mrns 12 2 6
patient_types 1 3
patients 3 5
people 1 4
procedure_hcpcs_mappings 2 4
procedure_modifiers 2 3
procedures 9 2 15
provider_groups 2 1 5
rad_exam_authorizations 2 5
rad_exam_claim_transactions 2 4
rad_exam_claims 2 4
rad_exam_departments 4 1 5
rad_exam_details 5 11
rad_exam_external_system_statuses 3 5
rad_exam_facts 32 130
rad_exam_metadata 3 6
rad_exam_metrics 1 44
rad_exam_personnel 14 16
rad_exam_times 1 17
rad_exams 13 19 22
rad_pacs_aets 4 3
rad_pacs_bodyparts 3 3
rad_pacs_metadata 11 19
rad_pacs_modalities 4 3
rad_pacs_specialities 1 3
rad_pacs_station_names 1 3
rad_reports 6 7 14
radonc_case_authorizations 2 5
radonc_case_claims 2 4
radonc_cases 2 10 13
reasons 10 1 4
relationship_types 1 3
residents 1 7
resources 5 4 8
scheduling_task_groupings 1 5 10
scheduling_tasks 2 11
services 6 2 6
site_classes 10 4 10
site_locations 2 2 6
site_sublocations 5 1 5
sites 17 1 7
software_versions 2 3
specialties 8 1 4
universal_event_types 2 4
view_external_cube_exam_facts 150
visit_diagnoses 2 4
visit_insurance_policies 2 4
visits 11 3 6
         
116 Tables     1,146  
1 View     150