Table pacsdb.public.series Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
pk int8 19
instance
series_query_attrs
series_req
body_part varchar 255
completeness int4 10
compress_failures int4 10
compress_params varchar 255  √  null
compress_time timestamp 29,6  √  null
compress_tsuid varchar 255  √  null
created_time timestamp 29,6
expiration_date varchar 255  √  null
expiration_exporter_id varchar 255  √  null
expiration_state int4 10
ext_retrieve_aet varchar 255  √  null
failed_retrieves int4 10
stgver_failures int4 10
inst_purge_state int4 10
inst_purge_time timestamp 29,6  √  null
institution varchar 255
department varchar 255
laterality varchar 255
metadata_update_time timestamp 29,6  √  null
metadata_update_failures int4 10
modality varchar 255
pps_cuid varchar 255
pps_iuid varchar 255
pps_start_date varchar 255
pps_start_time varchar 255
receiving_aet varchar 255  √  null
receiving_pres_addr varchar 255  √  null
rejection_state int4 10
sending_aet varchar 255  √  null
sending_pres_addr varchar 255  √  null
series_custom1 varchar 255
series_custom2 varchar 255
series_custom3 varchar 255
series_desc varchar 255
series_iuid varchar 255
series_no int4 10  √  null
series_size int8 19
sop_cuid varchar 255
station_name varchar 255
stgver_time timestamp 29,6  √  null
tsuid varchar 255
updated_time timestamp 29,6
version int8 19  √  null
dicomattrs_fk int8 19
dicomattrs
inst_code_fk int8 19  √  null
code
dept_code_fk int8 19  √  null
code
metadata_fk int8 19  √  null
metadata
perf_phys_name_fk int8 19  √  null
person_name
study_fk int8 19
study

Table contained 0 rows at Fri Aug 06 17:54 CEST 2021

Indexes:
Column(s) Type Sort
pk Primary key Asc
study_fk Performance Asc
perf_phys_name_fk Performance Asc
dept_code_fk Performance Asc
inst_code_fk Performance Asc
metadata_fk Performance Asc
Performance
compress_time Performance Asc
completeness Performance Asc
metadata_update_failures Performance Asc
series_no Performance Asc
institution Performance Asc
study_fk + series_iuid Must be unique Asc/Asc
compress_failures Performance Asc
series_iuid Performance Asc
inst_purge_time Performance Asc
series_desc Performance Asc
pps_start_time Performance Asc
modality Performance Asc
sending_aet Performance Asc
dicomattrs_fk Must be unique Asc
department Performance Asc
series_custom3 Performance Asc
receiving_pres_addr Performance Asc
inst_purge_state Performance Asc
stgver_time Performance Asc
body_part Performance Asc
sending_pres_addr Performance Asc
series_custom1 Performance Asc
metadata_update_time Performance Asc
expiration_state Performance Asc
failed_retrieves Performance Asc
rejection_state Performance Asc
receiving_aet Performance Asc
sop_cuid Performance Asc
station_name Performance Asc
series_custom2 Performance Asc
pps_start_date Performance Asc
stgver_failures Performance Asc
expiration_date Performance Asc
tsuid Performance Asc
laterality Performance Asc

Close relationships  within of separation: