New db schema has being designed with oversight from @dvarrazzo :

https://docs.google.com/document/d/1GSFxDd2W-6k_CJKa_SoEEhymwzZRisY7QWyaTb_A9PY/edit?usp=sharing

Now in the process of making all endpoints query new table.

We have decided to stick to pure SQL on recommendation of @dvarrazzo for efficiency and transparency.