person_name

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pk int8 19 null
instance_req.req_phys_name_fk fk8leut3c0gfxcg6y3lbjlpt2bt R
mwl_item.perf_phys_name_fk fkf5l3x4bfqn3jv8mhj617kidx7 R
patient.pat_name_fk fkig1mwm5jpkyq6733t0hrf56g R
patient.resp_person_fk fkjh4miooi709vj5l6xi8h95f3e R
series.perf_phys_name_fk fk5p2gub2u40fyh2ch6bp6nan4l R
series_req.req_phys_name_fk fk15lid2bqbrsmjatxiq0vug4wq R
soundex_code.person_name_fk fkctukwjaer0axw2jwv3bfj67r2 R
study.ref_phys_name_fk fkndwmntu3lsjd78erctnbposyr R
ups_req.req_phys_name_fk fk1b5veu90oftv8o95nxx2xndpb R
verify_observer.observer_name_fk fk8vo3f94xgum0qajsjqnlnqjo4 R
alphabetic_name varchar 255 null
id_sequence.name Implied Constraint R
ideographic_name varchar 255 null
id_sequence.name Implied Constraint R
phonetic_name varchar 255 null
id_sequence.name Implied Constraint R

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