Have a "Status" and "Role" columns. Status could be "Approved" or "Pending", and Role could be "Manager" or "Member".
This was done without changing anything in the DB, only FE/BE changes. Extracting the info from values such as "approved_mgr" to be "Status --> Approved, Role --> Manager".
Tradeoffs
To enable this split, the jade code is a bit less pretty. Maybe someone could advice how to make this more nicely.
Proposed solution
Have a "Status" and "Role" columns. Status could be "Approved" or "Pending", and Role could be "Manager" or "Member". This was done without changing anything in the DB, only FE/BE changes. Extracting the info from values such as "approved_mgr" to be "Status --> Approved, Role --> Manager".
Tradeoffs
To enable this split, the jade code is a bit less pretty. Maybe someone could advice how to make this more nicely.
Testing Done
Yes