Table pacsdb.public.stgver_task 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
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

Table contained 0 rows at Tue Jul 30 14:23 CEST 2019

Indexes:
Column(s) Type Sort
pk Primary key Asc
queue_msg_fk Performance Asc
updated_time Performance Asc
created_time Performance Asc
queue_msg_fk Must be unique Asc
study_iuid + series_iuid + sop_iuid Performance Asc/Asc/Asc

Close relationships  within of separation: