Table harbinger.public.employee_specialty_mappings
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('employee_specialty_mappings_id_seq'::regclass)
employee_id int8 19
employees.id employee_specialty_mappings_employee_fk R
specialty_id int8 19
specialties.id specialty_fk R
primary_specialty bool 1  √  false
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_specialty_mappings_id
employee_id Performance Asc employee_specialty_mappings_employee_id_idx
specialty_id Performance Asc employee_specialty_mappings_specialty_id_idx

Close relationships  within of separation: