Table |
cm_email_addresses |
|---|---|
Description |
Email Addresses |
Column |
Format |
Description |
Definition |
Comments |
|---|---|---|---|---|
id |
integer, primary key |
Row identifier |
autoincrement |
|
mail |
varchar(256) |
Internet mail address |
RFC 4524 inetOrgPerson |
|
type |
varchar(2) |
Type of mail, as enumerated |
|
|
verified |
boolean |
Was this address verified? |
|
Verification is via a URL sent to the address |
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 |