Table pacsdb.public.export_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
created_time timestamp 29,6
device_name varchar 255
exporter_id varchar 255
modalities varchar 255  √  null
num_instances int4 10  √  null
scheduled_time timestamp 29,6
series_iuid varchar 255
sop_iuid varchar 255
study_iuid varchar 255
updated_time timestamp 29,6
version int8 19  √  null
queue_msg_fk int8 19  √  null
queue_msg.pk fk_g6atpiywpo2100kn6ovix7uet R

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

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc export_task_pkey
queue_msg_fk Performance Asc fk_g6atpiywpo2100kn6ovix7uet
created_time Performance Asc uk_7iil4v32vf234i75edsxkdr8f
device_name Performance Asc uk_c5cof80jx0oopvovf3p4jv4l8
study_iuid + series_iuid + sop_iuid Performance Asc/Asc/Asc uk_hb9rftf7opmg56nkg7dkvsdc8
scheduled_time Performance Asc uk_j1t0mj3vlmf5xwt4fs5xida1r
updated_time Performance Asc uk_p5jjs08sdp9oecvr93r2g0kyq
exporter_id Performance Asc uk_q7gmfr3aog1hateydhfeiu7si

Close relationships  within of separation: