person_name

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pk int8 19 null
instance_req.req_phys_name_fk fk8leut3c0gfxcg6y3lbjlpt2btR
mwl_item.perf_phys_name_fk fkf5l3x4bfqn3jv8mhj617kidx7R
patient.pat_name_fk fkig1mwm5jpkyq6733t0hrf56gR
patient.resp_person_fk fkjh4miooi709vj5l6xi8h95f3eR
series.perf_phys_name_fk fk5p2gub2u40fyh2ch6bp6nan4lR
series_req.req_phys_name_fk fk15lid2bqbrsmjatxiq0vug4wqR
soundex_code.person_name_fk fkctukwjaer0axw2jwv3bfj67r2R
study.ref_phys_name_fk fkndwmntu3lsjd78erctnbposyrR
ups_req.req_phys_name_fk fk1b5veu90oftv8o95nxx2xndpbR
verify_observer.observer_name_fk fk8vo3f94xgum0qajsjqnlnqjo4R
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
idx9nr8ddkp8enufvbn72esyw3n1 Performance Asc phonetic_name
idxala4l4egord8i2tjvjidoqd1s Performance Asc ideographic_name
idxgs2yshbwu0gkd33yxyv13keoh Performance Asc alphabetic_name

Relationships

Close relationships within degrees of separation