...
- 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?
- Changes to the model are discovered during development and are discussed within Design Forums and/or on OpenMRS Talk. Changes are typically applied via Liquibase.
- 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.
...
- Download an SVG version
- Download an a PNG version
- Download a MySQL Workbench version (requires MySQL Workbench)
...
- Download an SVG version
- Download an a PNG version
- Download a MySQL Workbench version (requires MySQL Workbench)
...
- Download an SVG version
- Download an a PNG version
- Download a MySQL Workbench version (requires MySQL Workbench)
...
- Download an SVG version
- Download an a PNG version
- Download a MySQL Workbench version (requires MySQL Workbench)
...
| 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. |
...