Table harbinger.public.departments
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('departments_id_seq'::regclass)
employee_clinical_role_mappings.department_id employee_clinical_role_mappings_department_fk R
orders.department_id orders_departments_fk R
services.department_id services_department_fk R
specialties.department_id departments_specialties_fk R
department text 2147483647
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 department_id
department Performance Asc department_idx
department Must be unique Asc unique_department

Close relationships  within of separation: