Table harbinger.public.rad_exam_departments
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('rad_exam_departments_id_seq'::regclass)
rad_exam_facts.rad_exam_department_id rad_exam_facts_rad_exam_department_id_fk R
rad_exam_facts.scheduling_rad_exam_department_id rad_exam_facts_scheduling_rad_exam_department_id_fk R
rad_exams.rad_exam_department_id rad_exam_rad_exam_dept_fk R
scheduling_task_groupings.rad_exam_department_id scheduling_task_rad_exam_department_fk R
department text 2147483647
description text 2147483647  √  null
site_id int8 19
sites.id rad_exam_depts_site_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 rad_exam_department_id
department Performance Asc rad_exam_department_idx
department + site_id Performance Asc/Asc rad_exam_depts_dm_idx
site_id Performance Asc rad_exam_depts_site_id_idx

Close relationships  within of separation: