Page History

cm_names

Person names

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 lang.php

type

varchar(2)

When attached to a CO Person, types may be configured on a per-CO basis. See Extending the Registry Data Model.

primary_name

boolean

• true: This name is the primary name for the CO Person or Org Identity
• false: This name is not the primary name

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 co_person_id or org_identity_id may be specified

org_identity_id

integer, foreign key

Org Identity Record ID

cm_org_identities:id

Only one of co_person_id or org_identity_id may be specified