Table harbinger.public.rad_exam_personnel
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_personnel_id_seq'::regclass)
rad_exam_id int8 19
rad_exams.id exams_exam_personnel_fk R
scheduler_id int8 19  √  null
employees.id people_exam_personnel_fk R
signin_id int8 19  √  null
employees.id people_exam_personnel_fk1 R
checkin_id int8 19  √  null
employees.id people_exam_personnel_fk2 R
technologist_id int8 19  √  null
employees.id rep_tech_emp_fk R
assisting_tech1_id int8 19  √  null
employees.id rep_atech1_emp_fk R
assisting_tech2_id int8 19  √  null
employees.id rep_atech2_emp_fk R
assisting_tech3_id int8 19  √  null
employees.id rep_atech3_emp_fk R
begin_exam_id int8 19  √  null
employees.id people_exam_personnel_fk4 R
end_exam_id int8 19  √  null
employees.id people_exam_personnel_fk5 R
performing_id int8 19  √  null
employees.id people_exam_personnel_fk7 R
attending_id int8 19  √  null
employees.id people_exam_personnel_fk8 R
ordering_id int8 19  √  null
employees.id people_exam_personnel_fk9 R
authorizing_id int8 19  √  null
employees.id people_exam_personnel_fk10 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_personnel_id
assisting_tech1_id Performance Asc rad_exam_personnel_atech1_id_idx
assisting_tech2_id Performance Asc rad_exam_personnel_atech2_id_idx
assisting_tech3_id Performance Asc rad_exam_personnel_atech3_id_idx
attending_id Performance Asc rad_exam_personnel_attending_idx
authorizing_id Performance Asc rad_exam_personnel_authorizing_idx
begin_exam_id Performance Asc rad_exam_personnel_begin_exam_id_idx
checkin_id Performance Asc rad_exam_personnel_checkin_id_idx
end_exam_id Performance Asc rad_exam_personnel_end_exam_idx
ordering_id Performance Asc rad_exam_personnel_ordering_id_idx
performing_id Performance Asc rad_exam_personnel_performing_idx
rad_exam_id Performance Asc rad_exam_personnel_rad_exam_id_idx
scheduler_id Performance Asc rad_exam_personnel_scheduler_id_idx
signin_id Performance Asc rad_exam_personnel_signin_id_idx
technologist_id Performance Asc rad_exam_personnel_technologist_id_idx

Close relationships  within of separation: