prs_email_addresses

Owned by Benn Oshrin
Last updated: Mar 29, 2014
1 min read
Titleprs_email_addresses
TypeStandardized
DescriptionStandardized email addresses
ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
role_record_idinteger, foreign key(error)SOR Person this address is attached toprs_sor_persons:id 
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 SOR  

 

Migration Notes From OR 1

  • Table renamed from prs_emails (
    Error rendering macro 'jira' : 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. )