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

« Previous Version 6 Next »

Titleprc_addresses
TypeCalculated
DescriptionCalculated physical addresses
ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
person_idinteger, foreign key(error)Person this email address is attached toprc_sor_persons:id 
prs_address_idinteger, foreign key(tick)SOR address that generated this calculated addressprs_addresses:id 
line1varchar(100)(error)Address line 1 (question) Should address lines 1-3 be consolidated?
line2varchar(100)(tick)Address line 2  
line3varchar(100)(tick)Address line 3  
building_idinteger, foreign key(tick)Buildingdrd_buildings:id 
roomvarchar(20)(tick)Room  
cityvarchar(100)(tick)City  
region_idinteger, foreign key(tick)State / Regionctd_regions:id 
country_idinteger, foreign key(tick)Countryctd_countries:id 
postal_codevarchar(20)(tick)Postal / ZIP Code  
address_tinteger, foreign key(error)Type of this address

ctx_data_types:id

data_type=ADDRESS

verifiedboolean(tick)Whether this address has been verified by the IdMS Verification via (eg) activation key delivery
primaryboolean(error)Whether this is the primary address for this person  
languagevarchar(16)(tick)Language encoding of this addressRFC 5646 

 

Migration Notes From OR 1

  • bldg_no renamed building_id and made a foreign key (
    Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
    )
  • room_no renamed room ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • postal_code resized ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • Most fields no longer required ( 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. )
  • language added ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • No labels