Page Comparison

...

Column	Format	Nullable	Description	Definition	Comments
id	integer, primary key		Row identifier	autoincrement
person_id	integer, foreign key		Person this email address is attached to	prc_sor_persons:id
prs_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 name	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-66

  )
• 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-67

  )
• 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-68

  )
• 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-65

  )
• 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-69

  )
• Added primary (

  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-70

  )
• 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-83

  )