Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Titleprc_email_addresses
TypeCalculated
DescriptionCalculated email addresses
ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
role_record_idinteger, foreign key(error)SOR Person this email address is attached toprc_sor_persons:id 
prs_email_address_idinteger, foreign key(tick)SOR email address that generated this calculated email address  
addressvarchar(5)(error)Email address  
address_tvarchar(100)(error)Type of this address

ctx_data_types:id

data_type=EMAIL

verifiedvarchar(100)(tick)Whether this address has been verified by the IdMS Verification via (eg) activation key delivery

 

Migration Notes From OR 1

  • Table renamed from prc_emails 
  • Added prs_email_address_id
  • Added verified
  • No labels