Table pacsdb.public.patient 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
mpps.patient_fk fk_ofg0lvfxad6r5oigw3y6da27u R
mwl_item.patient_fk fk_vkxtls2wr17wgxnxj7b2fe32 R
patient.merge_fk fk_sk77bwjgaoetvy1pbcgqf08g R
study.patient_fk fk_e3fdaqhw7u60trs5aspf4sna9 R
created_time timestamp 29,6
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.pk fk_5lgndn3gn7iug3kuewiy9q124 R
merge_fk int8 19  √  null
patient.pk fk_sk77bwjgaoetvy1pbcgqf08g R
patient_id_fk int8 19  √  null
patient_id.pk fk_39gahcxyursxfxe2ucextr65s R
pat_name_fk int8 19  √  null
person_name.pk fk_rj42ffdtimnrcwmqqlvj24gi2 R

Table contained 361 rows at Wed Jun 29 14:02 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name Anomalies
pk Primary key Asc patient_pkey  
patient_id_fk Must be unique Asc uk_39gahcxyursxfxe2ucextr65s This unique column is also nullable
dicomattrs_fk Must be unique Asc uk_5lgndn3gn7iug3kuewiy9q124  

Close relationships  within of separation: