SchemaSpy - Table harbinger.public.specialties

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

bigserial

√

nextval('specialties_id_seq'::regclass)

card_case_facts.cardiologist_specialty_id	card_case_facts_cardiologist_specialty_id_fk R
card_case_facts.performing_specialty_id	card_case_facts_performing_specialty_fk R
employee_specialty_mappings.specialty_id	specialty_fk R
procedures.specialty_id	specialties_procedures_fk R
rad_exam_facts.procedure_specialty_id	rad_exam_facts_procedure_specialty_id_fk R
rad_exam_facts.radiologist_specialty_id	rad_exam_facts_radiologist_specialty_id_fk R
rad_exam_facts.scheduling_specialty_id	rad_exam_facts_scheduling_specialty_id_fk R
scheduling_task_groupings.specialty_id	scheduling_task_specialty_fk R

department_id

int8

departments_specialties_fk R

specialty

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	specialty_id
department_id	Performance	Asc	specialties_department_id_idx
department_id + specialty	Performance	Asc/Asc	specialties_dm_idx
specialty	Performance	Asc	specialties_idx