prc_email_addresses

Owned by Benn Oshrin
Last updated: Mar 30, 2014
1 min read
Titleprc_email_addresses
TypeCalculated
DescriptionCalculated email addresses
ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
person_idinteger, foreign key(error)Person this email address is attached toprc_sor_persons:id 
standardized_email_address_idinteger, foreign key(tick)SOR email address that generated this calculated email address  
addressvarchar(100)(error)Email address  
address_tinteger, foreign key(error)Type of this address

ctx_data_types:id

data_type=EMAIL

verifiedboolean(tick)Whether this address has been verified by the IdMS Verification via (eg) activation key delivery
primaryboolean(error)Whether this is the primary email address for this person  

 

Migration Notes From OR 1

  • Table renamed from prc_emails (
    Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
    )
  • Added standardized_email_address_id ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • Added verified ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • Added primary ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )