I would like some help setting up my database correctly. I´m making a rental app, the users both can rent out stuff, and rent stuff. And there will be a chat function. In the profile page for the users, I want the users to be able to se different lists of:
- Things they have rented out to others/have listed for rent
- Things they have rented FROM others
- Messages
What would be the best way to set ut a database for this, with the correct relationships?
Thanks