Table | email_addresses |
---|---|
Description | Email Addresses for a Person or External Identity |
Column | Format | Description | Definition | Required | Comments |
---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | ||
person_id | integer, foreign key | Person ID | people:id | Exactly one entity foreign key is required | |
external_identity_id | integer, foreign key | External Identity ID | external_identities:id | Exactly one entity foreign key is required | |
varchar(256) | Internet mail address | RFC 5321 Mailbox format | |||
description | varchar(128) | Description | |||
verified | boolean | Whether this Email Address has been verified |
| ||
type_id | integer, foreign key | Type of this Email Address | types:id | ||
source_email_address_id | integer, foreign key | External Identity Email Address that was the source for this Email Address | email_addresses:id | ||
frozen | boolean | Whether or not Pipeline processing will update this record |
|