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
export_task.queue_msg_fk fk_g6atpiywpo2100kn6ovix7uet R
retrieve_task.queue_msg_fk fk_mxokt1gw5g1e7rc3ssotvuqix R
created_time timestamp 29,6
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 Thu Dec 21 12:28 CET 2017

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
msg_id Must be unique Asc uk_k520j369nwx6rpbkvlp4kn623
msg_status Performance Asc uk_o8pu8axwpcm4chqxy75y09gpo

Close relationships: