Table pacsdb.public.stgcmt_result 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
created_time timestamp 29,6
device_name varchar 255
exporter_id varchar 255  √  null
msg_id varchar 255  √  null
num_failures int4 10  √  null
num_instances int4 10  √  null
series_iuid varchar 255  √  null
sop_iuid varchar 255  √  null
stgcmt_status int4 10
study_iuid varchar 255
transaction_uid varchar 255
updated_time timestamp 29,6

Table contained 0 rows at Fri May 31 14:18 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc stgcmt_result_pkey
msg_id Performance Asc uk_4iih0m0ueyvaim3033di45ems
device_name Performance Asc uk_7ltjgxoijy15rrwihl8euv7vh
transaction_uid Must be unique Asc uk_ey6qpep2qtiwayou7pd0vj22w
batch_id Performance Asc uk_f718gnu5js0mdg39q6j7fklia
exporter_id Performance Asc uk_gu96kxnbf2p84d1katepo0btq
stgcmt_status Performance Asc uk_nyoefler7agcmxc8t8yfngq7e
study_iuid Performance Asc uk_p65blcj4h0uh2itb0bp49mc07
updated_time Performance Asc uk_qko59fn9pb87j1eu070ilfkhm