Table | cm_email_addresses |
---|---|
Description | Email Addresses |
Column | Format | Description | Definition | Comments |
---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
varchar(256) | Internet mail address | RFC 4524 inetOrgPerson |
| |
description | varchar(128) | Description | Added in Registry v3.1.0. | |
type | varchar(32) | Type of mail, as enumerated |
| When attached to a CO Person, types may be configured on a per-CO basis. See Extending the Registry Data Model. See also Recommendations For Email Addresses. |
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 |
, |
may be specified | ||||
org_identity_id | integer, foreign key | Org Identity Record ID | Only one |
of | ||||
co_department_id | integer, foreign key | CO Department Record ID | cm_co_departments:id | Only one of co_person_id |
, org_identity_id |
, or co_department_id may be specified. Added in Registry v3.1.0. | |||
source_email_address_id | integer, foreign key | If Pipelines are in use, the Email Address ID for the Org Identity Email Address that created this Name | cm_email_addresses:id |
Added in Registry v2.0.0. |