movie
Tables (4)
Movie
- movie_id — INT — Primary key
- title — VARCHAR(255) — NOT NULL
- genre — VARCHAR(100)
- release_date — DATE
- director — VARCHAR(255)
- duration — INT
Review
- review_id — INT — Primary key
- user_id — INT — Foreign key → Subscriber.user_id
- movie_id — INT — Foreign key → Movie.movie_id
- rating — DECIMAL(2, 1)
- comment — TEXT — EX
- review_date — TIMESTAMP
Subscriber
- user_id — INT — Primary key
- username — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- last_login — TIMESTAMP
- email — VARCHAR(255)
WatchHistory
- history_id — INT — Primary key
- user_id — INT — Foreign key → Subscriber.user_id
- movie_id — INT — Foreign key → Movie.movie_id
- watch_date — TIMESTAMP
- watch_duration — INT