Structuring a Database is one of the biggest struggles I’ve seen when starting a new project.
There are questions like:
- Should it be a belongsTo or belongsToMany relationship?
- Maybe I use polymorphic relationships?
- Should I have one large table with 20 columns or divide that into multiple smaller ones?
- What would be the query performance for structure X?
- etc.