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
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
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
sop_cuid varchar 255
src_aet varchar 255  √  null
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.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 Fri Dec 13 14:14 CET 2019

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
compress_time Performance Asc uk_38mfgfnjhan2yhnwqtcrawe4
completeness Performance Asc uk_4lnegvfs65fbkjn7nmg9s8usy
metadata_update_failures Performance Asc uk_6xqpk4cvy49wj41p2qwixro8w
series_no Performance Asc uk_75oc6w5ootkuwyvmrhe3tbown
institution Performance Asc uk_82qea56c0kdhod3b1wu8wbrny
study_fk + series_iuid Must be unique Asc/Asc uk_83y2fx8cou17h3xggxspgikna
compress_failures Performance Asc uk_889438ocqfrvybu3k2eo65lpa
series_iuid Performance Asc uk_9fi64g5jjycg9dp24jjk5txg1
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
stgver_time Performance Asc uk_ftv3ijh2ud6ogoknneyqc6t9i
body_part Performance Asc uk_gwp46ofa26am9ohhccq1ohdj
series_custom1 Performance Asc uk_hm39592a9n7m54dgso17irlhv
metadata_update_time Performance Asc uk_hwkcpd7yv0nca7o918wm4bn69
expiration_state Performance Asc uk_ih49lthl3udoca5opvgsdcerj
failed_retrieves Performance Asc uk_j6aadbh7u93bpmv18s1inrl1r
rejection_state Performance Asc uk_jlgy9ifvqak4g2bxkchismw8x
sop_cuid Performance Asc uk_mrn00m45lkq1xbehmbw5d9jbl
station_name Performance Asc uk_pq1yi70ftxhh391lhcq3e08nf
series_custom2 Performance Asc uk_q3wayt2ke25fdcghaohhrjiu7
pps_start_date Performance Asc uk_rvlxc150uexwmr1l9ojp8fgd
stgver_failures Performance Asc uk_s1vceb8cu9c45j0q8tbldgol9
expiration_date Performance Asc uk_ta3pi6exqft5encv389hwjytw
tsuid Performance Asc uk_tahx0q1ejidnsam40ans7oecx
laterality Performance Asc uk_tbdrfrmkmifsqhpf43065jrbs

Close relationships  within of separation: