Table harbinger.public.site_classes
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('site_classes_id_seq'::regclass)
card_case_facts.site_class_id card_case_facts_site_class_fk R
card_cases.site_class_id card_cases_site_class_fk R
claim_transaction_facts.site_class_id claim_transaction_facts_site_class_id_fk R
claims.site_class_id claim_site_class_fk R
orders.site_class_id orders_site_class_fk R
patient_events.site_class_id patient_events_site_class_fk R
patient_events_history.site_class_id patient_events_history_site_class_fk R
rad_exam_facts.site_class_id rad_exam_facts_site_class_id_fk R
rad_exams.site_class_id rad_exam_site_class_fk R
radonc_cases.site_class_id radonc_cases_site_class_fk R
site_class text 2147483647
external_system_id int8 19
external_systems.id site_classes_external_system_id_fk R
name text 2147483647  √  null
site_id int8 19
sites.id sites_site_classes_fk R
trauma bool 1
ed bool 1
patient_type_id int8 19
patient_types.id patient_types_site_classes_fk R
cms_facility_type_id int8 19  √  null
cms_facility_types.id site_classes_cms_facility_type_fk R
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc site_class_id
site_class + external_system_id Performance Asc/Asc site_class_dm_idx
site_class Performance Asc site_class_idx
cms_facility_type_id Performance Asc site_classes_cms_facility_type_idx
external_system_id Performance Asc site_classes_extsys_idx
patient_type_id Performance Asc site_classes_patient_type_id_idx
site_id Performance Asc site_classes_side_id_idx

Close relationships  within of separation: