Table |
cm_names |
---|---|
Description |
Person names |
Column |
Format |
Description |
Definition |
Comments |
---|---|---|---|---|
id |
integer, primary key |
Row identifier |
autoincrement |
|
honorific |
varchar(32) |
Dr, Mr, Ms, etc |
|
|
given |
varchar(128) |
First/Given name(s) |
|
|
middle |
varchar(128) |
Middle name(s) |
|
|
family |
varchar(128) |
Last/Family name(s) |
|
|
suffix |
varchar(32) |
Jr, III, PhD, etc |
|
|
language |
varchar(16) |
Language encoding of this name |
RFC 5646 |
For supported values, see |
type |
varchar(2) |
|
|
|
primary_name |
boolean |
|
|
Exactly one name per CO Person and one per Org Identity should have primary_name true at all times |
co_person_id |
integer, foreign key |
CO Person Record ID |
cm_co_people:id |
Only one of |
org_identity_id |
integer, foreign key |
Org Identity Record ID |
Only one of |