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
completeness int4 10
created_time timestamp 29,6
expiration_date varchar 255  √  null
ext_retrieve_aet varchar 255  √  null
failed_retrieves 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
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
series_size int8 19
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
metadata_fk int8 19  √  null
metadata.pk fk_pu4p7k1o9hleuk9rmxvw2ybj6 R
perf_phys_name_fk int8 19  √  null
person_name.pk fk_5n4bxxb2xa7bvvq26ao7wihky R
study_fk int8 19
study.pk fk_1og1krtgxfh207rtqjg0r7pbd R

Table contained 0 rows at Thu Dec 21 12:28 CET 2017

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc series_pkey
study_fk Performance Asc fk_1og1krtgxfh207rtqjg0r7pbd
perf_phys_name_fk Performance Asc fk_5n4bxxb2xa7bvvq26ao7wihky
inst_code_fk Performance Asc fk_oiq81nulcmtg6p85iu31igtf5
metadata_fk Performance Asc fk_pu4p7k1o9hleuk9rmxvw2ybj6
Performance series_desc_upper_idx
completeness Performance Asc uk_4lnegvfs65fbkjn7nmg9s8usy
series_no Performance Asc uk_75oc6w5ootkuwyvmrhe3tbown
institution Performance Asc uk_82qea56c0kdhod3b1wu8wbrny
study_fk + series_iuid Must be unique Asc/Asc uk_83y2fx8cou17h3xggxspgikna
inst_purge_time Performance Asc uk_a8vyikwd972jomyb3f6brcfh5
series_desc Performance Asc uk_achxn1rtfm3fbkkswlsyr75t0
pps_start_time Performance Asc uk_amr00xwlatxewgj1sjp5mnf76
modality Performance Asc uk_b126hub0dc1o9dqp6awoispx2
dicomattrs_fk Must be unique Asc uk_bdj2kuutidekc2en6dckev7l6
department Performance Asc uk_bqu32v5v76p4qi0etptnrm0pc
series_custom3 Performance Asc uk_d8b8irasiw8eh9tsigmwkbvae
inst_purge_state Performance Asc uk_er4ife08f6eaki91gt3hxt5e
body_part Performance Asc uk_gwp46ofa26am9ohhccq1ohdj
series_custom1 Performance Asc uk_hm39592a9n7m54dgso17irlhv
metadata_update_time Performance Asc uk_hwkcpd7yv0nca7o918wm4bn69
failed_retrieves Performance Asc uk_j6aadbh7u93bpmv18s1inrl1r
rejection_state Performance Asc uk_jlgy9ifvqak4g2bxkchismw8x
station_name Performance Asc uk_pq1yi70ftxhh391lhcq3e08nf
series_custom2 Performance Asc uk_q3wayt2ke25fdcghaohhrjiu7
pps_start_date Performance Asc uk_rvlxc150uexwmr1l9ojp8fgd
expiration_date Performance Asc uk_ta3pi6exqft5encv389hwjytw
laterality Performance Asc uk_tbdrfrmkmifsqhpf43065jrbs

Close relationships  within of separation: