person_name

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pk int8 19 null
instance_req.req_phys_name_fk fk_cqmmps9maltjybl44t4cck404R
mwl_item.perf_phys_name_fk fk_44qwwvs50lgpog2cqmicxgt1fR
patient.pat_name_fk fk_rj42ffdtimnrcwmqqlvj24gi2R
patient.resp_person_fk fk_56r2g5ggptqgcvb3hl11adke2R
series.perf_phys_name_fk fk_5n4bxxb2xa7bvvq26ao7wihkyR
series_req.req_phys_name_fk fk_bcn0jtvurqutw865pwp34pejbR
soundex_code.person_name_fk fk_dh7lahwi99hk6bttrk75x4ckcR
study.ref_phys_name_fk fk_49eet5qgcsb32ktsqrf1mj3x2R
ups_req.req_phys_name_fk fk_kocdb2pxx2fymu1modhneb4xmR
verify_observer.observer_name_fk fk_105wt9hglqsmtnoxgma9x18vjR
alphabetic_name varchar 255 null
id_sequence.name Implied ConstraintR
ideographic_name varchar 255 null
id_sequence.name Implied ConstraintR
phonetic_name varchar 255 null
id_sequence.name Implied ConstraintR

Indexes

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

Relationships

Close relationships within degrees of separation