Table pacsdb.public.retrieve_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
batch_id varchar 255  √  null
completed int4 10
created_time timestamp 29,6
destination_aet varchar 255
device_name varchar 255
error_comment varchar 255  √  null
failed int4 10
local_aet varchar 255
queue_name varchar 255
remaining int4 10
remote_aet varchar 255
scheduled_time timestamp 29,6  √  null
series_iuid varchar 255  √  null
sop_iuid varchar 255  √  null
status_code int4 10
study_iuid varchar 255
updated_time timestamp 29,6
warning int4 10
queue_msg_fk int8 19  √  null
queue_msg.pk fk_mxokt1gw5g1e7rc3ssotvuqix R

Table contained 0 rows at Tue Jan 28 14:54 CET 2020

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc retrieve_task_pkey
queue_msg_fk Performance Asc fk_mxokt1gw5g1e7rc3ssotvuqix
remote_aet Performance Asc uk_3avjusmul00fc3yi1notyh16j
local_aet Performance Asc uk_a26s4yqy4rnpw7nniuyt7tkpo
batch_id Performance Asc uk_ahkqwir2di2jm44jlhi22iw3e
device_name Performance Asc uk_djkqk3dls3xkru1n0c3p5rm3
updated_time Performance Asc uk_e2lo4ep4t4k07njc09anf6xkm
study_iuid Performance Asc uk_gafcma0d5wwdjlq8jueqknlq0
destination_aet Performance Asc uk_jgaej0gm9appih04n09qto8yh
queue_name Performance Asc uk_r866eptnxfw7plhxwtm3vks0e
scheduled_time Performance Asc uk_rqp93vxrhyg09x3ck7vc1mawp
created_time Performance Asc uk_sf2g7oi8cfx89olwch9095hx7

Close relationships  within of separation: