Table harbinger.public.dicom_studies
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('dicom_studies_id_seq'::regclass)
dicom_series.dicom_study_id dicom_series_dicom_study_fk R
accession text 2147483647  √  null
accession_external_system_id int8 19  √  null
external_systems.id dicom_study_accession_external_system_fk R
external_system_id int8 19
external_systems.id dicom_study_external_system_fk R
study_iuid text 2147483647
rad_exam_id int8 19  √  null
rad_exams.id dicom_study_rad_exams_fk R
card_case_id int8 19  √  null
card_cases.id dicom_studies_card_case_fk R
procedure_id int8 19  √  null
procedures.id dicom_study_procedure_id_fk R
study_begin timestamptz 35,6  √  null
study_end timestamptz 35,6  √  null
image_count int4 10  √  null
series_count int4 10  √  null
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 dicom_study_id
card_case_id Performance Asc dicom_studies_card_case_idx
rad_exam_id Performance Asc dicom_studies_rad_exam_id_idx
accession + accession_external_system_id Performance Asc/Asc dicom_study_accession_lookup_idx
study_iuid + external_system_id Performance Asc/Asc dicom_study_comp_key_idx

Close relationships  within of separation: