Table pacsdb.public.diff_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
diff_task_attrs.diff_task_fk fk_1sbjtesix8hkq310i84lfg0xi R
check_different bool 1
check_missing bool 1
compare_fields varchar 255  √  null
created_time timestamp 29,6
different int4 10
local_aet varchar 255
matches int4 10
missing int4 10
primary_aet varchar 255
query_str varchar 255
secondary_aet varchar 255
updated_time timestamp 29,6
queue_msg_fk int8 19
queue_msg.pk fk_dlrthwe594xvfeta3kyuih3ip R

Table contained 0 rows at Fri Mar 30 13:02 CEST 2018

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc diff_task_pkey
queue_msg_fk Performance Asc fk_dlrthwe594xvfeta3kyuih3ip
check_missing Performance Asc uk_1b3rghtxfl0byme5urnxmd4xl
secondary_aet Performance Asc uk_4esq3qn81u1ww82vsheeiy424
compare_fields Performance Asc uk_d92i2fx5i138fbehp4qfk
queue_msg_fk Must be unique Asc uk_dlrthwe594xvfeta3kyuih3ip
updated_time Performance Asc uk_dyakfsqdbpk1bgme5i9xw20jj
check_different Performance Asc uk_ex8bacv78us242731mpyrigpd
local_aet Performance Asc uk_ji31t9tjovks2hi8c220kvh2o
primary_aet Performance Asc uk_kigvmtftfxwb5ekb5a1d48okh
created_time Performance Asc uk_swm85lyyxy8sr2oot4dcrjck4

Close relationships  within of separation: