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
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
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 680 rows at Wed Jun 29 14:02 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc person_name_pkey

Close relationships  within of separation: