dic_form_of_address

26 rows


Description

Dictionary of forms of address for people e.g. Rev. Col)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
form_of_address_id INT 10 √ null
person.form_of_address_id person_form_of_address_fk R
form_of_address VARCHAR 100 √ NULL

Abbreviated form of address e.g. Rev. Dr. Col
form_of_address_full VARCHAR 250 √ NULL

Full form of address e.g. Reverend Doctor Colonel

Indexes

Constraint Name Type Sort Column(s)
dic_form_of_address_s_pk Primary key Asc form_of_address_id
PRIMARY Must be unique Asc form_of_address_id

Relationships

Close relationships within degrees of separation