MovieMate
Tables (6)
Genres
- genre_id — INT
- genre_name — VARCHAR(50) — NOT NULL
MovieGenres
- mg_id — INT
- movie_id — INT — Foreign key → Movies.movie_id — NOT NULL
- genre_id — INT — Foreign key → Genres.genre_id — NOT NULL
Movies
- movie_id — INT
- title — VARCHAR(200) — NOT NULL
- release_year — INT
- director — VARCHAR(100)
- description — TEXT
- poster_url — VARCHAR(255)
Reviews
- review_id — INT
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- movie_id — INT — Foreign key → Movies.movie_id — NOT NULL
- rating — INT
- comment — TEXT — EX
- created_at — TIMESTAMP
Users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
Watchlist
- watchlist_id — INT
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- movie_id — INT — Foreign key → Movies.movie_id — NOT NULL
- added_at — TIMESTAMP
- status — VARCHAR(20)