Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

2
I need some help with a movie wish list type of schema.
Post Body

So I'm trying to wrap my head around how to relate the different table in my schema. The idea is this:

  • Users -- Can Have many lists

  • List -- Can have 0 or Many movies -- Has one owner -- Can be shared with 0 or Many other users

  • Movies -- Can be watched by 0 or Many users -- Can have 1 or Many genres -- Can be in 1 or Many lists

I have no idea if that's a good approach or not, but aside from other misc details, that's the core of what I want to accomplish.

How can I relate these tables in such a way that, I can actually make it work?

This is what I have so far. It's not exactly what I've described above, but I think it's close.

Schema

Author
Account Strength
100%
Account Age
10 years
Verified Email
No
Verified Flair
No
Total Karma
11,703
Link Karma
2,112
Comment Karma
9,326
Profile updated: 15 hours ago
Posts updated: 8 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
7 years ago