Table harbinger.public.rad_pacs_metadata
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('rad_pacs_metadata_id_seq'::regclass)
rad_exam_id int8 19
rad_exams.id exams_rad_pacs_metadata_fk R
external_system_id int8 19
external_systems.id rad_pacs_external_system_fk R
image_count int4 10  √  null
first_image timestamptz 35,6  √  null
last_image timestamptz 35,6  √  null
dicom_begin timestamptz 35,6  √  null
dicom_end timestamptz 35,6  √  null
study_comments text 2147483647  √  null
rad_pacs_modality_id int8 19  √  null
rad_pacs_modalities.id modalities_rad_pacs_metadata_fk R
rad_pacs_aet_id int8 19  √  null
rad_pacs_aets.id rad_pacs_aets_rad_pacs_metadata_fk R
rad_pacs_station_name_id int8 19  √  null
rad_pacs_station_names.id rad_pacs_station_names_rad_pacs_metadata_fk R
rad_pacs_speciality_id int8 19  √  null
rad_pacs_specialities.id rad_pacs_specialities_rad_pacs_metadata_fk R
rad_pacs_bodypart_id int8 19  √  null
rad_pacs_bodyparts.id rad_pacs_bodyparts_rad_pacs_metadata_fk R
manufacturer_id int8 19  √  null
manufacturers.id ByRailsConventionConstraint R
equipment_model_id int8 19  √  null
equipment_models.id rad_pacs_metadata_equipment_model_fk R
equipment_serial_number_id int8 19  √  null
equipment_serial_numbers.id rad_pacs_metadata_equipment_serial_number_fk R
software_version_id int8 19  √  null
software_versions.id software_versions_rad_pacs_metadata_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 rad_pacs_metadata_id
external_system_id Performance Asc rad_pacs_metadata_extsys_idx
image_count Performance Asc rad_pacs_metadata_imgcount_idx
rad_exam_id Performance Asc rad_pacs_metadata_rad_exam_id_idx
rad_pacs_aet_id Performance Asc rad_pacs_metadata_rad_pacs_aet_id_idx
rad_pacs_bodypart_id Performance Asc rad_pacs_metadata_rad_pacs_bodypart_id_idx
rad_pacs_modality_id Performance Asc rad_pacs_metadata_rad_pacs_modality_id_idx
rad_pacs_speciality_id Performance Asc rad_pacs_metadata_rad_pacs_speciality_id_idx
rad_pacs_station_name_id Performance Asc rad_pacs_metadata_rad_pacs_station_name_id_idx

Close relationships  within of separation: