Table harbinger.public.employees
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('employees_id_seq'::regclass)
card_case_facts.anesthesiologist_id card_case_facts_anesthesiologist_fk R
card_case_facts.attending_id card_case_facts_attending_fk R
card_case_facts.cardiologist_id card_case_facts_cardiologist_id_fk R
card_case_facts.ordering_id card_case_facts_ordering_fk R
card_case_facts.ordering_provider_id card_case_facts_ordering_provider_fk R
card_case_facts.performing_id card_case_facts_performing_fk R
card_case_facts.resident_id card_case_facts_resident_id_fk R
card_case_facts.scheduler_id card_case_facts_scheduler_fk R
card_case_facts.technologist_id card_case_facts_technologist_fk R
card_case_personnel.anesthesiologist_id card_case_personnel_anesthesiologist_fk R
card_case_personnel.assisting_physician1_id card_case_personnel_assisting_physician1_fk R
card_case_personnel.assisting_physician2_id card_case_personnel_assisting_physician2_fk R
card_case_personnel.assisting_physician3_id card_case_personnel_assisting_physician3_fk R
card_case_personnel.attending_id card_case_personnel_attending_fk R
card_case_personnel.authorizing_id card_case_personnel_authorizing_fk R
card_case_personnel.begin_case_id card_case_personnel_begin_case_fk R
card_case_personnel.checkin_id card_case_personnel_checkin_fk R
card_case_personnel.end_case_id card_case_personnel_end_case_fk R
card_case_personnel.nurse1_id card_case_personnel_nurse1_fk R
card_case_personnel.nurse2_id card_case_personnel_nurse2_fk R
card_case_personnel.nurse3_id card_case_personnel_nurse3_fk R
card_case_personnel.ordering_id card_case_personnel_ordering_fk R
card_case_personnel.performing_id card_case_personnel_performing_fk R
card_case_personnel.scheduler_id card_case_personnel_scheduler_fk R
card_case_personnel.signin_id card_case_personnel_signin_fk R
card_case_personnel.technologist_id card_case_personnel_technologist_fk R
card_reports.card1_id card_reports_card1_fk R
card_reports.card2_id card_reports_card2_fk R
card_reports.card3_id card_reports_card3_fk R
card_reports.card4_id card_reports_card4_fk R
card_reports.transcriptionist_id card_reports_transcriptionist_fk R
claim_transaction_facts.billing_employee_id claim_transaction_facts_billing_employee_id_fk R
claim_transaction_facts.ordering_employee_id claim_transaction_facts_ordering_employee_id_fk R
claim_transaction_facts.performing_employee_id claim_transaction_facts_performing_employee_id_fk R
claim_transaction_facts.posting_employee_id claim_transaction_facts_posting_employee_id_fk R
claim_transactions.billing_employee_id claim_transaction_billing_employee_fk R
claim_transactions.ordering_employee_id claim_transaction_ordering_employee_fk R
claim_transactions.performing_employee_id claim_transaction_performing_employee_fk R
claim_transactions.posting_employee_id claim_transaction_posting_employee_fk R
employee_clinical_role_mappings.employee_id employee_clinical_role_mappings_employee_fk R
employee_demos.employee_id employee_demos_employee_fk R
employee_specialty_mappings.employee_id employee_specialty_mappings_employee_fk R
identifiers.employee_id people_logins_fk R
orders.ordering_provider_id orders_ordering_provider_fk R
patient_events.operator_employee_id patient_events_operator_employee_id R
patient_events_history.operator_employee_id patient_events_history_operator_employee_id R
rad_exam_facts.ordering_provider_id rad_exam_facts_ordering_provider_id_fk R
rad_exam_facts.radiologist_id rad_exam_facts_radiologist_id_fk R
rad_exam_facts.resident_id rad_exam_facts_resident_id_fk R
rad_exam_facts.scheduler_id rad_exam_facts_scheduler_id_fk R
rad_exam_facts.technologist_id rad_exam_facts_technologist_id_fk R
rad_exam_personnel.assisting_tech1_id rep_atech1_emp_fk R
rad_exam_personnel.assisting_tech2_id rep_atech2_emp_fk R
rad_exam_personnel.assisting_tech3_id rep_atech3_emp_fk R
rad_exam_personnel.attending_id people_exam_personnel_fk8 R
rad_exam_personnel.authorizing_id people_exam_personnel_fk10 R
rad_exam_personnel.begin_exam_id people_exam_personnel_fk4 R
rad_exam_personnel.checkin_id people_exam_personnel_fk2 R
rad_exam_personnel.end_exam_id people_exam_personnel_fk5 R
rad_exam_personnel.ordering_id people_exam_personnel_fk9 R
rad_exam_personnel.performing_id people_exam_personnel_fk7 R
rad_exam_personnel.scheduler_id people_exam_personnel_fk R
rad_exam_personnel.signin_id people_exam_personnel_fk1 R
rad_exam_personnel.technologist_id rep_tech_emp_fk R
rad_reports.rad1_id people_reports_fk1 R
rad_reports.rad2_id people_reports_fk2 R
rad_reports.rad3_id people_reports_fk3 R
rad_reports.rad4_id people_reports_fk4 R
rad_reports.transcriptionist_id people_reports_fk R
residents.employee_id people_residents_fk R
name text 2147483647  √  null
active bool 1  √  true
person_id int8 19
people.id people_clinicians_fk R
fte float8 17,17  √  1.0
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 employee_id
Performance employee_lowered_names_idx
name Performance Asc employee_name_idx
person_id Performance Asc employees_person_id_idx

Close relationships  within of separation: