Table Mapping from Oracle to MongoDB - geneseeq/data-migration GitHub Wiki

Summary

This section describes the table mapping from the LIMS Oracle database, to the MongoDB documents. In many cases, the MongoDB key names are modified from the Oracle column names, to reflect the correct English translation of the underlying meaning.

Patient Medical Records

The relationships between various tables in Oracle, with respect to patient records, are shown below:

CRM table relationships in Oracle

The following diagram shows the relationship between the MongoDB documents related to patient medical records, and their corresponding Oracle tables and columns.

Patient Medical Records Data Translation Table