SchemaSpy Analysis of harbinger.public
Generated by SchemaSpy on Fri Apr 27 09:43 EDT 2018
Database Type: PostgreSQL - 9.1.2

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

Table / View Children Parents Columns Comments
claim_transaction_cms_modifiers 2 4
claim_transaction_diagnoses 2 4
claim_transaction_facts 17 38
claim_transaction_types 2 3
claim_transactions 6 11 22
claims 4 9 17
clinical_roles 1 1 5
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 3 3
dicom_instances 2 6
dicom_protocols 1 2 5
dicom_series 1 10 17
dicom_studies 1 4 12
employee_clinical_role_mappings 2 4
employee_demos 2 5
employee_specialty_mappings 2 5
employees 39 1 6
equipment_models 3 1 4
equipment_serial_numbers 3 3
exam_metadata_types 1 3
exam_priorities 4 3
external_system_role_mappings 2 4
external_system_roles 1 4
external_system_statuses 10 2 5
external_systems 26 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 5 2 8
manufacturers 4 3
metasite_associations 2 4
metasites 2 4
modalities 3 3
ordering_departments 2 4
orders 3 14 20
patient_demos 3 6
patient_demos_history 3 6
patient_events 7 10
patient_events_history 7 10
patient_mrns 9 2 6
patient_types 1 3
patients 1 5
people 1 4
procedure_hcpcs_mappings 2 4
procedure_modifiers 1 3
procedures 7 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 28 116
rad_exam_metadata 3 6
rad_exam_metrics 1 43
rad_exam_personnel 14 16
rad_exam_times 1 17
rad_exams 13 18 21
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 12
radonc_case_authorizations 2 5
radonc_case_claims 2 4
radonc_cases 2 10 13
reasons 7 1 4
relationship_types 1 3
residents 1 7
resources 3 4 8
scheduling_task_groupings 1 4 9
scheduling_tasks 2 11
site_classes 8 4 10
site_locations 2 2 6
site_sublocations 4 1 5
sites 14 1 7
software_versions 2 3
specialties 6 1 4
universal_event_types 2 4
view_external_cube_exam_facts 145
visit_diagnoses 2 4
visit_insurance_policies 2 4
visits 10 3 6
         
96 Tables     806  
1 View     145