Table pacsdb.public.ian_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
calling_aet varchar 255
device_name varchar 255
ian_dests varchar 255
scheduled_time timestamp 29,6  √  null
study_iuid varchar 255  √  null
mpps_fk int8 19  √  null
mpps.pk fk_1fuh251le2hid2byw90hd1mly R

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
pk Primary key Asc ian_task_pkey  
mpps_fk Performance Asc fk_1fuh251le2hid2byw90hd1mly  
device_name Performance Asc uk_5shiir23exao1xpy2n5gvasrh  
study_iuid Must be unique Asc uk_dq88edcjjxh7h92f89y5ueast This unique column is also nullable

Close relationships  within of separation: