(many-to-many via movie_genre) id, name
user_id, movie_id, rating (float), created_at
id, user_id, movie_id, content, likes, created_at
id, title, release_year, runtime, synopsis, poster_url, backdrop_url, tmdb_id (if using TMDb)
(many-to-many via movie_genre) id, name
user_id, movie_id, rating (float), created_at lixmovies
id, user_id, movie_id, content, likes, created_at (many-to-many via movie_genre) id
id, title, release_year, runtime, synopsis, poster_url, backdrop_url, tmdb_id (if using TMDb) tmdb_id (if using TMDb)