Multitenancy Design Proposal

Jump to bottom Edit New page

James Agnew edited this page Jan 13, 2020 · 6 revisions

This page attempts to document the initial design for a scalable multitenancy strategy. This strategy will have several goals:

It can be used to provide logical secure segragation of data (i.e. user performs a search for "find all patients in tenant 123 with name = 'smith'", they should receive only results that actually belong to this tenent
It can be used to create logical partitions of data that can be

The following tables are all related to an individual resource instance in the database:

HFJ_RESOURCE
HFJ_RES_VER
HFJ_RES_TAG
HFJ_FORCED_ID
HFJ_IDX_CMP_STRING_UNIQ
HFJ_SPIDX_COORDS
HFJ_SPIDX_DATE
HFJ_SPIDX_NUMBER
HFJ_SPIDX_QUANTITY
HFJ_SPIDX_STRING
HFJ_SPIDX_TOKEN
HFJ_SPIDX_URI