Table harbinger.public.sites
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('sites_id_seq'::regclass)
card_case_facts.site_id card_case_facts_site_fk R
card_cases.site_id card_cases_site_fk R
claim_transaction_facts.site_id claim_transaction_facts_site_id_fk R
claims.site_id claim_site_fk R
metasite_associations.site_id sites_metasite_associations_fk R
orders.site_id orders_site_fk R
rad_exam_departments.site_id rad_exam_depts_site_fk R
rad_exam_facts.scheduling_site_id rad_exam_facts_scheduling_site_id_fk R
rad_exam_facts.site_id rad_exam_facts_site_id_fk R
rad_exams.site_id rad_exam_site_fk R
radonc_cases.site_id radonc_cases_site_fk R
resources.site_id resource_site_fk R
scheduling_task_groupings.site_id scheduling_task_site_fk R
services.site_id services_site_fk R
site_classes.site_id sites_site_classes_fk R
site_locations.site_id site_location_fk R
visits.site_id visits_site_fk R
site text 2147483647
name text 2147483647  √  null
cms_gpci_id int8 19  √  null site_cms_gpci_fk R
cms_facility bool 1  √  null
application_visible bool 1 true
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Column(s) Type Sort Constraint Name
id Primary key Asc site_id
cms_gpci_id Performance Asc fki_site_cms_gpci_fk
site Performance Asc site_idx

Close relationships  within of separation: