🔒 Closed Database design for Watchlist, Favorites, Watched

Status
Not open for further replies.

Red-Eyed XaXa

Honorary Poster
May tatlong feature akong gusto idagdag which is watchlist,favorites, and watched para sa movies and tv shows.
Ano po marerecommend niyong design?
-> Gagawa ako ng tatlong table pero same column lang sila (user_id, movie_id,media_type).
-> Or isang table nalang pero apat ang column (user_id, movie_id, media_type, status ).
Yung status column mag dedetermine kung Watchlist, Watched, or Favorite ng user yung movie or tv show.
 
Status
Not open for further replies.

About this Thread

  • 2
    Replies
  • 409
    Views
  • 2
    Participants
Last reply from:
Red-Eyed XaXa

Trending Topics

Online now

Members online
629
Guests online
1,059
Total visitors
1,688

Forum statistics

Threads
2,287,419
Posts
29,044,583
Members
1,216,522
Latest member
mrshanks
Back
Top