Table | names |
|---|---|
Description | Names for a Person or External Identity |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| person_id | integer, foreign key | Person ID | people:id | Exactly one entity foreign key is required | |
| external_identity_id | integer, foreign key | External Identity ID | external_identities: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 | |||
| source_name_id | integer, foreign key | External Identity Name that was the source for this Name | names:id | ||
| frozen | boolean | Whether or not Pipeline processing will update this record |
|