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
created_time timestamp 29,6
expiration_date varchar 255  √  null
ext_retrieve_aet varchar 255  √  null
failed_retrieves int4 10
failed_iuids varchar 4000  √  null
institution varchar 255
department varchar 255
laterality varchar 255
modality varchar 255
pps_cuid varchar 255
pps_iuid varchar 255
pps_start_date varchar 255
pps_start_time varchar 255
rejection_state int4 10
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
src_aet varchar 255  √  null
station_name varchar 255
updated_time timestamp 29,6
version int8 19  √  null
dicomattrs_fk int8 19
dicomattrs
inst_code_fk int8 19  √  null
code
perf_phys_name_fk int8 19  √  null
person_name
study_fk int8 19
study

Table contained 0 rows at Mon Oct 24 12:27 CEST 2016

Indexes:
Column(s) Type Sort
pk Primary key Asc
study_fk Performance Asc
perf_phys_name_fk Performance Asc
inst_code_fk Performance Asc
series_no Performance Asc
institution Performance Asc
study_fk + series_iuid Must be unique Asc/Asc
series_desc Performance Asc
pps_start_time Performance Asc
modality Performance Asc
dicomattrs_fk Must be unique Asc
department Performance Asc
series_custom3 Performance Asc
body_part Performance Asc
series_custom1 Performance Asc
failed_retrieves Performance Asc
rejection_state Performance Asc
station_name Performance Asc
series_custom2 Performance Asc
pps_start_date Performance Asc
expiration_date Performance Asc
laterality Performance Asc
failed_iuids Performance Asc

Close relationships  within of separation: