Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


person_idinteger, foreign keyPerson IDpeople:idExactly one entity foreign key is required
external_identity_idinteger, foreign keyExternal Identity IDexternal_identities:idExactly one entity foreign key is required

mail

varchar(256)

Internet mail address

RFC 5321 Mailbox format

(tick)


description

varchar(128)

Description




verified

boolean

Whether this Email Address has been verified

  • true: Verified
  • false: Not verified


type_idinteger, foreign keyType of this Email Addresstypes:id(tick)
source_email_address_idinteger, foreign keyExternal Identity Email Address that was the source for this Email Addressemail_addresses:id

frozenbooleanWhether or not Pipeline processing will update this record
  • true: No updates
  • false: Updates