How to properly design a simple favorites and blocked table?
- by Nils Riedemann
Hey,
i am currently writing a webapp in rails where users can mark items as favorites and also block them. I came up two ways and wondered which one is more common/better way.
1. Separate join tables
Would it be wise to have 2 tables for this? Like:
users_favorites
  - user_id
  - item_id
users_blocked
  - user_id
  - item_id
2. single table
users_marks (or so)
  - users_id
  - item_id
  - type (["fav", "blk"])
Both ways seem to have advantages. Which one would you use and why?