dic_person_suffix

3 rows


Description

Dictionary of suffixes for peoples names (e.g. Jr. Sr. Esq.)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_suffix_id INT 10 √ null
person.person_suffix_id person_suffix_fk R
suffix VARCHAR 100 null

Abbreviated suffix e.g. Jr. Esq.
suffix_full VARCHAR 250 null

Full version of suffix e.g. Junior, Esquire

Indexes

Constraint Name Type Sort Column(s)
dic_person_suffix_s_pk Primary key Asc person_suffix_id
PRIMARY Must be unique Asc person_suffix_id

Relationships

Close relationships within degrees of separation