prc_addresses

Column	Format	Nullable	Description	Definition	Comments
id	integer, primary key		Row identifier	autoincrement
role_record_id	integer, foreign key		Calculated role record this email address is attached to	prc_role_records:id
standardized_address_id	integer, foreign key		SOR address that generated this calculated address	prs_addresses: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 IdMS		Verification via (eg) activation key delivery
primary	boolean		Whether this is the primary address for this person
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 ( ORII-66 - Getting issue details... STATUS )
• room_no renamed room ( ORII-67 - Getting issue details... STATUS )
• postal_code resized ( ORII-68 - Getting issue details... STATUS )
• Most fields no longer required ( ORII-65 - Getting issue details... STATUS )
• Added verified ( ORII-69 - Getting issue details... STATUS )
• Added primary ( ORII-70 - Getting issue details... STATUS )
• language added ( ORII-83 - Getting issue details... STATUS )
• Added standardized_address_id ( ORII-90 - Getting issue details... STATUS )