Table pacsdb.public.stgver_task 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
completed int4 10
created_time timestamp 29,6
failed int4 10
local_aet varchar 255
series_iuid varchar 255  √  null
sop_iuid varchar 255  √  null
storage_ids varchar 255  √  null
stgcmt_policy int4 10  √  null
study_iuid varchar 255
update_location_status bool 1  √  null
updated_time timestamp 29,6
queue_msg_fk int8 19
queue_msg.pk fk_hch5fanx7ejwew2ag2ividq9r R

Table contained 0 rows at Wed Nov 21 11:44 CET 2018

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc stgver_task_pkey
queue_msg_fk Performance Asc fk_hch5fanx7ejwew2ag2ividq9r
updated_time Performance Asc uk_bja5px1r9qts4nydp1a2i61ok
created_time Performance Asc uk_fe2td8g77y54d90w7339ka0ix
queue_msg_fk Must be unique Asc uk_hch5fanx7ejwew2ag2ividq9r
study_iuid + series_iuid + sop_iuid Performance Asc/Asc/Asc uk_iudr0qmrm15i2evq1733h1ace

Close relationships  within of separation: