I’d like to make a simple application that lets roommates share data about their living situation. Some of the methods would be posting lists of grocery items the house needs, utility bills and their due dates, and times people would like to reserve the common areas, etc.
I’m just starting to lay the ground work and I’m trying to conceptualize the best way to architect the Home/User/Room relationships.
I’m using a stack of NodeJs, Express, MySql (Sequelize), and (probably) React.
I am pretty new to web development, and completely self taught (except for a front end bootcamp) so I was hoping to get some expert opinions what you would – and, if possible, some guidance on how to wire it up in Sequelize (their docs kind of suck).
Here are what seem to be my two best options (bold items would represent a possible SQL table):
Each Home object has an Occupants JSON object which is populated with Users from the Users table.
I create a Room object which defines the relationship between a Home and an Occupant (aka User).
I’m not sure what direction to go in.