|
Decided in today's call that:
-
model will be stored as a json structure in database
-
user data scope will be implemented using branch mapped to the user
Five points for implementation:
-
use a read-only database user (to avoid any accidental writes/updates)
-
DB structure (tables and columns) to be finalized to store the model
-
DB scripts to populate the model as a json structure to the DB table
-
Logic/joins etc. to be moved from front-end to server side
-
All joins to include a join with user and office to implement user data scoping
|
