Table pacsdb.public.person_name 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
mwl_item.perf_phys_name_fk fk_44qwwvs50lgpog2cqmicxgt1f R
patient.pat_name_fk fk_rj42ffdtimnrcwmqqlvj24gi2 R
patient.resp_person_fk fk_56r2g5ggptqgcvb3hl11adke2 R
series.perf_phys_name_fk fk_5n4bxxb2xa7bvvq26ao7wihky R
series_req.req_phys_name_fk fk_bcn0jtvurqutw865pwp34pejb R
soundex_code.person_name_fk fk_dh7lahwi99hk6bttrk75x4ckc R
study.ref_phys_name_fk fk_49eet5qgcsb32ktsqrf1mj3x2 R
ups_req.req_phys_name_fk fk_kocdb2pxx2fymu1modhneb4xm R
verify_observer.observer_name_fk fk_105wt9hglqsmtnoxgma9x18vj R
family_name varchar 255  √  null
given_name varchar 255  √  null
i_family_name varchar 255  √  null
i_given_name varchar 255  √  null
i_middle_name varchar 255  √  null
i_name_prefix varchar 255  √  null
i_name_suffix varchar 255  √  null
middle_name varchar 255  √  null
name_prefix varchar 255  √  null
name_suffix varchar 255  √  null
p_family_name varchar 255  √  null
p_given_name varchar 255  √  null
p_middle_name varchar 255  √  null
p_name_prefix varchar 255  √  null
p_name_suffix varchar 255  √  null

Table contained 0 rows at Tue Jan 28 14:54 CET 2020

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc person_name_pkey
Performance family_name_upper_idx
Performance given_name_upper_idx
Performance middle_name_upper_idx
p_family_name Performance Asc uk_2189yvio0mae92hjhgbfwqgvc
p_given_name Performance Asc uk_6cn50unrp2u9xf6authiollrr
given_name Performance Asc uk_byvbmsx5w9jop12gdqldogbwm
middle_name Performance Asc uk_hop27c6p2aiabl0ei6rj7oohi
p_middle_name Performance Asc uk_kungbb1r2qtt9aq0vsb1l68y6
i_family_name Performance Asc uk_l3prcvmx90pdclj84s6uvbblm
i_middle_name Performance Asc uk_lwnfdvx2cknj9ravec592642d
family_name Performance Asc uk_mgrwrswyrk02s1kn86cvpix3m
i_given_name Performance Asc uk_tgh0ek52g7cpioire3qwdweoi

Close relationships  within of separation: