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 |
|
|
type_id |
varchar(2) |
|
|
|
co_person_id |
integer, foreign key |
CO Person Record ID |
cm_co_people:id |
Only one of |
org_person_id |
integer, foreign key |
Org Person Record ID |
Only one of |