Note that in this diagram, the one-to-one mapping between
openmrs_metadata, for example, indicates an inheritance in object design terms: MetadataSource inherits the fields of OpenmrsMetadata. In the database schema, this relationship will be implemented so that the relation
metadata_source, for example, includes all the columns of
Notes on data model design
metadata_sourceis used to define a unique source (authority) for each namespace of metadata terms.
nameshould be fully qualified and universally unique.
metadata_term_mappingtable provides both the term and its mapping to local metadata.
codeshould be unique within the given source.
metadata_classrefers to the Java class for the metadata.
metadata_referenceis a unique reference to the metadata within the class (e.g., uuid)
metadata_setis used to define relating grouping of metadata similar to what OpenMRS has traditionally done within global properties and similar to FHIR's ValueSet for metadata terms.
sort_weightis used to optionally give members of a metadata set a reliable sequence.