Table pacsdb.public.patient Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
pk int8 19
mpps
mwl_item
patient
study
created_time timestamp 29,6
num_studies int4 10
pat_birthdate varchar 255
pat_custom1 varchar 255
pat_custom2 varchar 255
pat_custom3 varchar 255
pat_sex varchar 255
updated_time timestamp 29,6
version int8 19  √  null
dicomattrs_fk int8 19
dicomattrs
merge_fk int8 19  √  null
patient
patient_id_fk int8 19  √  null
patient_id
pat_name_fk int8 19  √  null
person_name
resp_person_fk int8 19  √  null
person_name

Table contained 0 rows at Mon Oct 24 12:27 CEST 2016

Indexes:
Column(s) Type Sort Anomalies
pk Primary key Asc  
patient_id_fk Performance Asc  
resp_person_fk Performance Asc  
pat_name_fk Performance Asc  
merge_fk Performance Asc  
pat_birthdate Performance Asc  
num_studies Performance Asc  
patient_id_fk Must be unique Asc This unique column is also nullable
pat_custom3 Performance Asc  
pat_sex Performance Asc  
dicomattrs_fk Must be unique Asc  
pat_custom1 Performance Asc  
pat_custom2 Performance Asc  

Close relationships  within of separation: