Table pacsdb.public.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
rel_task_dicomattrs.task_fk fk_pwaoih2f4ay4c00avvt79de7h R
batch_id varchar 255  √  null
check_different bool 1  √  null
check_missing bool 1  √  null
compare_fields varchar 255  √  null
completed int4 10  √  null
created_time timestamp 29,6
destination_aet varchar 255  √  null
device_name varchar 255
different int4 10
error_comment varchar 255  √  null
error_msg varchar 255  √  null
exporter_id varchar 255  √  null
failed int4 10  √  null
local_aet varchar 255  √  null
matches int4 10
missing int4 10
modalities varchar 255  √  null
num_failures int4 10
num_instances int4 10  √  null
outcome_msg varchar 255  √  null
payload bytea 2147483647  √  null
proc_end_time timestamp 29,6  √  null
proc_start_time timestamp 29,6  √  null
query_str varchar 255  √  null
queue_name varchar 255
remaining int4 10  √  null
remote_aet varchar 255  √  null
rq_uri varchar 4000  √  null
rq_host varchar 255  √  null
rq_user_id varchar 255  √  null
scheduled_time timestamp 29,6
series_iuid varchar 255  √  null
sop_iuid varchar 255  √  null
task_status int4 10
status_code int4 10  √  null
storage_ids varchar 255  √  null
stgcmt_policy int4 10  √  null
study_iuid varchar 255  √  null
task_type int4 10
update_location_status bool 1  √  null
updated_time timestamp 29,6
version int8 19  √  null
warning int4 10

Table contained 0 rows at Fri Aug 06 17:54 CEST 2021

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc task_pkey
local_aet Performance Asc uk_17gcm1xo6fkujauguyjfxfb2k
check_different Performance Asc uk_1lchdfbbwkjbg7a6coy5t8iq7
study_iuid + series_iuid + sop_iuid Performance Asc/Asc/Asc uk_6a0y0rsssms4mtm9bpkw8vgl6
created_time Performance Asc uk_76hkd9mjludoohse4g0ru1mg8
task_status Performance Asc uk_7y5ucdiygunyg2nh7qrs70e7k
remote_aet Performance Asc uk_81xi6wnv5b10x3723fxt5bmew
updated_time Performance Asc uk_9htwq4ofarp6m88r3ao0grt8j
task_type Performance Asc uk_a582by7kuyuhk8hi41tkelhrw
destination_aet Performance Asc uk_f7c43c242ybnvcn3o50lrcpkh
batch_id Performance Asc uk_k6dxmm1gu6u23xq03hbk80m4r
device_name Performance Asc uk_m47ruxpag7pq4gtn12lc63yfe
compare_fields Performance Asc uk_ow0nufrtniev7nkh7d0uv5mxe
check_missing Performance Asc uk_pknlk8ggf8lnq38lq3gacvvpt
queue_name Performance Asc uk_r2bcfyreh4n9h392iik1aa6sh
scheduled_time Performance Asc uk_xwqht1afwe7k27iulvggnwwl

Close relationships  within of separation: