Table pacsdb.public.series Generated by
SchemaSpy
Legend: SourceForge.net
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
pk int8 19
instance.series_fk fk_s4tgrew4sh4qxoupmk3gihtrk R
series_query_attrs.series_fk fk_eiwosf6pcc97n6y282cv1n54k R
series_req.series_fk fk_bdkjk6ww0ulrb0nhf41c7liwt R
body_part varchar 255
created_time timestamp 29,6
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
series_custom1 varchar 255
series_custom2 varchar 255
series_custom3 varchar 255
series_desc varchar 255
series_iuid varchar 255
series_no varchar 255
src_aet varchar 255  √  null
station_name varchar 255
updated_time timestamp 29,6
version int8 19  √  null
dicomattrs_fk int8 19
dicomattrs.pk fk_bdj2kuutidekc2en6dckev7l6 R
inst_code_fk int8 19  √  null
code.pk fk_oiq81nulcmtg6p85iu31igtf5 R
perf_phys_name_fk int8 19  √  null
person_name.pk fk_5n4bxxb2xa7bvvq26ao7wihky R
study_fk int8 19
study.pk fk_1og1krtgxfh207rtqjg0r7pbd R
rejection_state int4 10
failed_retrieves int4 10  √  null
failed_iuids varchar 4000  √  null
expiration_date varchar 255  √  null

Table contained 993 rows at Wed Jun 29 14:02 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc series_pkey
study_fk + series_iuid Must be unique Asc/Asc uk_83y2fx8cou17h3xggxspgikna
dicomattrs_fk Must be unique Asc uk_bdj2kuutidekc2en6dckev7l6
rejection_state Performance Asc uk_jlgy9ifvqak4g2bxkchismw8x

Close relationships  within of separation: