Table harbinger.public.identifiers
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('identifiers_id_seq'::regclass)
employee_id int8 19  √  null
employees.id people_logins_fk R
identifier text 2147483647  √  null
identifier_type_id int8 19
identifier_types.id identifier_type_fk R
external_system_id int8 19
external_systems.id external_system_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 identifiers_id
identifier Performance Asc identifier_ident_idx
identifier_type_id Performance Asc identifier_identtype_idx
Performance identifier_lowered_ident_idx
identifier + external_system_id + identifier_type_id Must be unique Asc/Asc/Asc identifier_unique_idx
employee_id Performance Asc identifiers_employee_id_idx
external_system_id Performance Asc identifiers_external_system_id_idx
identifier_type_id Performance Asc identifiers_identifier_type_id_idx

Close relationships  within of separation: