Table pacsdb.public.queue_msg 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
diff_task.queue_msg_fk fk_dlrthwe594xvfeta3kyuih3ip R
export_task.queue_msg_fk fk_g6atpiywpo2100kn6ovix7uet R
retrieve_task.queue_msg_fk fk_mxokt1gw5g1e7rc3ssotvuqix R
stgver_task.queue_msg_fk fk_hch5fanx7ejwew2ag2ividq9r R
batch_id varchar 255  √  null
created_time timestamp 29,6
device_name varchar 255
error_msg varchar 255  √  null
msg_body bytea 2147483647
msg_id varchar 255
msg_props varchar 4000
num_failures int4 10
outcome_msg varchar 255  √  null
priority int4 10
proc_end_time timestamp 29,6  √  null
proc_start_time timestamp 29,6  √  null
queue_name varchar 255
scheduled_time timestamp 29,6
msg_status int4 10
updated_time timestamp 29,6
version int8 19  √  null

Table contained 0 rows at Fri Dec 13 14:14 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc queue_msg_pkey
queue_name Performance Asc uk_b5mbe6jenklf1r5wp5csrvf67
updated_time Performance Asc uk_gsdfgth9kxjat98cmabtj8x1h
created_time Performance Asc uk_jfyulc3fo7cmn29sbha0l72m3
msg_id Must be unique Asc uk_k520j369nwx6rpbkvlp4kn623
device_name Performance Asc uk_kvtxqtdow67hcr2wv8irtdwqy
batch_id Performance Asc uk_ln9rs61la03lhvgiv8c2wehnr
msg_status Performance Asc uk_o8pu8axwpcm4chqxy75y09gpo

Close relationships  within of separation: