Disney Movie Archive
Tables (3)
Movie
- movie_id — INT
- title — VARCHAR(100) — NOT NULL
- release_date — DATE
- genre — VARCHAR(50)
- description — TEXT
Review
- review_id — INT
- user_id — INT — Foreign key → User.user_id
- movie_id — INT — Foreign key → Movie.movie_id
- rating — INT
- comment — TEXT — EX
- created_at — DATETIME
User
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL