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
alphabetic_name varchar 255
ideographic_name varchar 255
phonetic_name varchar 255

Table contained 0 rows at Fri Aug 06 17:54 CEST 2021

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc person_name_pkey
Performance alphabetic_name_upper_idx
phonetic_name Performance Asc uk_9nr8ddkp8enufvbn72esyw3n1
ideographic_name Performance Asc uk_ala4l4egord8i2tjvjidoqd1s
alphabetic_name Performance Asc uk_gs2yshbwu0gkd33yxyv13keoh

Close relationships  within of separation: