Table pacsdb.public.hl7psu_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
aet varchar 255
created_time timestamp 29,6
device_name varchar 255
scheduled_time timestamp 29,6  √  null
study_iuid varchar 255  √  null
mpps_fk int8 19  √  null
mpps.pk fk_pev4urgkk7id2h1ijhv8domjx R

Table contained 0 rows at Wed Nov 21 11:44 CET 2018

Indexes:
Column(s) Type Sort Constraint Name Anomalies
pk Primary key Asc hl7psu_task_pkey  
mpps_fk Performance Asc fk_pev4urgkk7id2h1ijhv8domjx  
study_iuid Must be unique Asc uk_p5fraoqdbaywmlyumaeo16t56 This unique column is also nullable
device_name Performance Asc uk_t0y05h07d9dagn9a4a9s4a5a4  

Close relationships  within of separation: