Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • What is the difference between retire and void columns?
    • Metadata within OpenMRS (information used to configure & support data entry such as concepts, locations, encounter types, etc.) can be marked as retired when it should no longer be used. Data (actually clinical data about patients) within OpenMRS is marked as voided when it has been deleted or otherwise invalidated by a user. Tables with retire attributes contain metadata; tables with void attributes contain data.
  • What are the conventions for changing the OpenMRS data model definition?
  • We really like your data model image. How does OpenMRS make it?
    • Historically, we've used MySQL Workbench to make images; however, it is a laborious task to make the model legible.

...

...

...

...

...

Note

Many tables in the data model have columns like created_by, retired_by, voided_by, etc. which have foreign key relationships with user.user_id. These links are not shown in the diagrams for the sake of clarity.

...