Table harbinger.public.scheduling_task_groupings
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('scheduling_task_groupings_id_seq'::regclass)
scheduling_tasks.scheduling_task_grouping_id scheduling_task_scheduling_task_grouping_fk R
task_grouping_identifier text 2147483647
external_system_id int8 19
external_systems.id scheduling_task_gropuing_external_system_fk R
task_name text 2147483647  √  null
task_abbreviation text 2147483647  √  null
specialty_id int8 19  √  null
specialties.id scheduling_task_specialty_fk R
rad_exam_department_id int8 19  √  null
rad_exam_departments.id scheduling_task_rad_exam_department_fk R
service_id int8 19  √  null
services.id scheduling_task_service_fk R
site_id int8 19  √  null
sites.id scheduling_task_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 scheduling_task_grouping_id
external_system_id Performance Asc scheduling_task_groupings_external_system_id_idx
rad_exam_department_id Performance Asc scheduling_task_groupings_rad_exam_department_id_idx
service_id Performance Asc scheduling_task_groupings_service_id_idx
site_id Performance Asc scheduling_task_groupings_site_id_idx
specialty_id Performance Asc scheduling_task_groupings_specialty_id_idx
task_name Performance Asc scheduling_task_groupings_task_name_idx

Close relationships  within of separation: