Downloads Documentation Community Contribute Demo






Show Sidebar
Login | Register

Ticket #316 (closed enhancement: fixed)

Opened 2 years ago

Last modified 1 year ago

Restructure Relationship Tables

Reported by: bwolfe Assigned to: bwolfe
Priority: major Milestone: OpenMRS 1.2
Component: OpenMRS Code Base Keywords:
Cc: Introductory Ticket:

Description (Last modified by bwolfe)

The relationship tables need to be both disambiguated and multidirectional.

relationship

  • relationship_id
  • person_a
  • person_b
  • relationship_type_id
  • creator/changed/voided

relationship_type

  • relationship_type_id
  • a_is_to_b
  • b_is_to_a
  • preferred
  • weight
  • description
  • creator/changed/voided

Should be done after the person/patient/user rewrite - #315

Change History

02/09/07 14:21:59 changed by bwolfe

  • owner changed from somebody to bwolfe.
  • status changed from new to assigned.
  • description changed.

02/09/07 14:22:11 changed by bwolfe

  • description changed.

02/09/07 14:22:18 changed by bwolfe

  • description changed.

02/09/07 15:02:29 changed by bmamlin

  • description changed.

:o)

04/17/07 12:59:08 changed by bwolfe

  • description changed.

Added description, preferred, and weight columns to relationship_type table.

06/25/07 15:24:22 changed by bwolfe

  • status changed from assigned to closed.
  • resolution set to fixed.

This is the current schema as of the 1.1 release.