Once again Thank you for the professional advice!

I ended up I guess with less or more the same implementation you suggested:

Basically the Application Layer code fetches the meta data during start-up or some meta-tables and stores into into Redis, after which all calls fetch it from there ...

here is the fetch

here is the store

and the unit test: and the unit test

The lessons learned from this release was the huge effort one has to undertake when dealing with overall architectural logic change related to the meta data handling of the application.

I hope I achieved a good foundation for the horizontal scalability of the app ...

Once again, thank you for the Wisdom !