Table harbinger.public.card_case_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('card_case_personnel_id_seq'::regclass)
card_case_id int8 19
card_cases.id card_case_personnel_card_case_fk R
scheduler_id int8 19  √  null
employees.id card_case_personnel_scheduler_fk R
signin_id int8 19  √  null
employees.id card_case_personnel_signin_fk R
checkin_id int8 19  √  null
employees.id card_case_personnel_checkin_fk R
anesthesiologist_id int8 19  √  null
employees.id card_case_personnel_anesthesiologist_fk R
assisting_physician1_id int8 19  √  null
employees.id card_case_personnel_assisting_physician1_fk R
assisting_physician2_id int8 19  √  null
employees.id card_case_personnel_assisting_physician2_fk R
assisting_physician3_id int8 19  √  null
employees.id card_case_personnel_assisting_physician3_fk R
begin_case_id int8 19  √  null
employees.id card_case_personnel_begin_case_fk R
end_case_id int8 19  √  null
employees.id card_case_personnel_end_case_fk R
performing_id int8 19  √  null
employees.id card_case_personnel_performing_fk R
attending_id int8 19  √  null
employees.id card_case_personnel_attending_fk R
ordering_id int8 19  √  null
employees.id card_case_personnel_ordering_fk R
authorizing_id int8 19  √  null
employees.id card_case_personnel_authorizing_fk R
nurse1_id int8 19  √  null
employees.id card_case_personnel_nurse1_fk R
nurse2_id int8 19  √  null
employees.id card_case_personnel_nurse2_fk R
nurse3_id int8 19  √  null
employees.id card_case_personnel_nurse3_fk R
technologist_id int8 19  √  null
employees.id card_case_personnel_technologist_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 card_case_personnel_id
anesthesiologist_id Performance Asc card_case_personnel_anesthesiologist_idx
assisting_physician1_id Performance Asc card_case_personnel_assisting_physician1_idx
assisting_physician2_id Performance Asc card_case_personnel_assisting_physician2_idx
assisting_physician3_id Performance Asc card_case_personnel_assisting_physician3_idx
attending_id Performance Asc card_case_personnel_attending_idx
authorizing_id Performance Asc card_case_personnel_authorizing_idx
begin_case_id Performance Asc card_case_personnel_begin_case_idx
card_case_id Performance Asc card_case_personnel_card_case_idx
checkin_id Performance Asc card_case_personnel_checkin_idx
end_case_id Performance Asc card_case_personnel_end_case_idx
nurse1_id Performance Asc card_case_personnel_nurse1_idx
nurse2_id Performance Asc card_case_personnel_nurse2_idx
nurse3_id Performance Asc card_case_personnel_nurse3_idx
ordering_id Performance Asc card_case_personnel_ordering_idx
performing_id Performance Asc card_case_personnel_performing_idx
scheduler_id Performance Asc card_case_personnel_scheduler_idx
signin_id Performance Asc card_case_personnel_signin_idx
technologist_id Performance Asc card_case_personnel_technologist_idx

Close relationships  within of separation: