prs_addresses

Column	Format	Nullable	Description	Definition	Comments
id	integer, primary key		Row identifier	autoincrement
role_record_id	integer, foreign key		SOR Person this address is attached to	prs_sor_persons:id
line1	varchar(100)		Address line 1		Should address lines 1-3 be consolidated?
line2	varchar(100)		Address line 2
line3	varchar(100)		Address line 3
building_id	integer, foreign key		Building	drd_buildings:id
room	varchar(20)		Room
city	varchar(100)		City
region_id	integer, foreign key		State / Region	ctd_regions:id
country_id	integer, foreign key		Country	ctd_countries:id
postal_code	varchar(20)		Postal / ZIP Code
address_t	integer, foreign key		Type of this address	ctx_data_types:id	data_type=ADDRESS
verified	boolean		Whether this address has been verified by the SOR
language	varchar(16)		Language encoding of this address	RFC 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. )
• language added ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )