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('services_id_seq'::regclass)
card_case_facts.service_id card_case_facts_service_fk R
card_cases.service_id card_cases_service_fk R
rad_exam_facts.scheduling_service_id rad_exam_facts_scheduling_service_id_fk R
rad_exam_facts.service_id rad_exam_facts_service_id_fk R
rad_exams.service_id rad_exam_service_fk R
scheduling_task_groupings.service_id scheduling_task_service_fk R
service text 2147483647  √  null
department_id int8 19 services_department_fk R
site_id int8 19 services_site_fk R
description text 2147483647  √  null
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 services_id
department_id Performance Asc services_department_idx
site_id Performance Asc services_site_idx
service + department_id + site_id Must be unique Asc/Asc/Asc unique_service_department_site

Close relationships  within of separation: