New answers tagged postgres
3
Rather than the entities, let's look at the relationships here:
An Item is for exactly one Room; a Room has many Items
An Item is for exactly one Section; a Section has many Items
A Room has many Sections; a Section applies to many Rooms (even in the original hierarchy, your example Section was "Painting", not "Painting the Kitchen")
So ...
Top 50 recent answers are included
Related Tags
postgres × 119database-design × 42
database × 38
relational-database × 16
sql × 14
mysql × 10
java × 9
python × 8
architecture × 7
node.js × 7
design × 6
web-development × 5
django × 5
mongodb × 5
database-development × 5
design-patterns × 4
web-applications × 4
ruby-on-rails × 4
spring × 4
multitenancy × 4
php × 3
rest × 3
sql-server × 3
search × 3
aws × 3