SchemaSpy Analysis of harbinger.public
Generated by SchemaSpy on Wed Sep 09 12:54 EDT 2015
Database Type: PostgreSQL - 9.1.2

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

Table 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 5 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
employee_clinical_role_mappings 2 4
employee_demos 2 5
employee_specialty_mappings 2 5
employees 37 1 6
exam_metadata_types 1 3
exam_priorities 2 3
external_system_role_mappings 2 4
external_system_roles 1 4
external_system_statuses 9 2 5
external_systems 16 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
metasite_associations 2 4
metasites 2 4
modalities 3 3
orders 3 6 9
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 5 2 16
rad_exam_authorizations 2 5
rad_exam_claims 2 4
rad_exam_departments 2 1 5
rad_exam_details 5 11
rad_exam_external_system_statuses 3 5
rad_exam_facts 15 80
rad_exam_metadata 3 6
rad_exam_metrics 1 22
rad_exam_personnel 14 16
rad_exam_times 1 15
rad_exams 11 18 21
rad_pacs_aets 1 3
rad_pacs_bodyparts 1 3
rad_pacs_metadata 7 13
rad_pacs_modalities 1 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 2 2 6
site_classes 7 4 10
site_locations 2 2 6
site_sublocations 4 1 5
sites 13 1 7
specialties 4 1 4
universal_event_types 2 4
visit_diagnoses 2 4
visit_insurance_policies 2 4
visits 10 3 6
         
83 Tables     643  
0 Views     0