Manage data in Database better

**Is your feature request related to a problem? Please describe.**
Right now in development all data is scattered throughout the database where we have different databases for each table this means that it is hard for clients to access data so API's are needed to check user authentication at every step.

**Describe the solution you'd like**
Merge relivant tables into the users table which means that they can access the data client side without going through a api route. Of course we need to be careful to impose restrictions on what the users are allowed to do with the data as we don't want them being able to edit data they're not supposed to

**Describe alternatives you've considered**
Keep using Api Routes and making new tables for each new datatype we need to handle