PickFlo
Tables (3)
movies
- movie_id — INT — NOT NULL
- movie_code — INT — NOT NULL
- movie_title — VARCHAR(100) — NOT NULL
- movie_overview — VARCHAR(3000)
- movie_rating — DECIMAL(4, 2) — NOT NULL
- movie_release_date — DATE — NOT NULL
- movie_runtime — INT — NOT NULL
- movie_img — VARCHAR(1000)
movies_people
- movie_person_job — VARCHAR(10) — Primary key — NOT NULL
- movie_id — INT — Foreign key → movies.movie_id — NOT NULL
- person_id — INT — Foreign key → people.person_id — NOT NULL
people
- person_id — INT
- person_name — VARCHAR(30) — NOT NULL