Page Comparison

...

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 (

  Jira Legacy
  server JASIG Issue Tracker columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-61

  )
• room_no renamed room (

  Jira Legacy
  server JASIG Issue Tracker columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-62

  )
• postal_code resized (

  Jira Legacy
  server JASIG Issue Tracker columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-63

  )
• Most fields no longer required (

  Jira Legacy
  server JASIG Issue Tracker columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-60

  )
• Added verified (

  Jira Legacy
  server JASIG Issue Tracker columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-64

  )
• language added (

  Jira Legacy
  server JASIG Issue Tracker columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 76221f40-4501-3df1-8578-6c87908cbdf7 key ORII-82

  )