Table harbinger.public.dicom_series
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)
external_system_id int8 19  √  null
external_systems.id dicom_series_external_system_fk R
dicom_study_id int8 19  √  null
dicom_studies.id dicom_series_dicom_study_fk R
series_iuid text 2147483647
rad_pacs_modality_id int8 19  √  null
rad_pacs_modalities.id dicom_series_rad_pacs_modality_fk R
rad_pacs_bodypart_id int8 19  √  null
rad_pacs_bodyparts.id dicom_series_rad_pacs_bodypart_fk R
rad_pacs_aet_id int8 19  √  null
rad_pacs_aets.id dicom_series_rad_pacs_aet_fk R
software_version_id int8 19  √  null
software_versions.id dicom_series_software_version_fk R
manufacturer_id int8 19  √  null
manufacturers.id dicom_series_manufacturer_fk R
equipment_model_id int8 19  √  null
equipment_models.id dicom_series_equipment_model_fk R
equipment_serial_number_id int8 19  √  null
equipment_serial_numbers.id dicom_series_equipment_serial_number_fk R
dicom_protocol_id int8 19  √  null
dicom_protocols.id dicom_series_dicom_protocol_fk R
image_count int4 10  √  null
laterality text 2147483647  √  null
series_begin timestamptz 35,6  √  null
series_end timestamptz 35,6  √  null
dicom_instances jsonb 2147483647 '{}'::jsonb
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_series_id
series_iuid + external_system_id Performance Asc/Asc dicom_series_comp_key_idx
dicom_study_id Performance Asc dicom_series_dicom_study_id_idx

Close relationships  within of separation: