...
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| person_id | integer, foreign key | Person ID | people:idOne | of person_id or external_identity_id Exactly one entity foreign key is required | |
| external_identity_id | integer, foreign key | External Identity ID | external_identities:idOne of person_id or external_identity_id | Exactly one entity foreign key is required | |
honorific | varchar(32) | Dr, Mr, Ms, etc | Governed by co_settings | ||
given | varchar(128) | First/Given name(s) | Governed by co_settings | ||
middle | varchar(128) | Middle name(s) | Governed by co_settings | ||
family | varchar(128) | Last/Family name(s) | Governed by co_settings | ||
suffix | varchar(32) | Jr, III, PhD, etc | Governed by co_settings | ||
| type_id | integer, foreign key | Type of this name | types:id | | |
language | varchar(16) | Language encoding of this name | For supported values, see | ||
primary_name | boolean | If this is the primary name for the associated entity |
| ||
| display_name | varchar(256) | Preferred rendering of this name, if set |
...