moviemates
Tables (4)
movies
- id (Key) — Long — Primary key — NOT NULL
- title — VARCHAR(40)
- release_date — DATE
- genre — VARCHAR(40)
- duration — int
- review_rating — VARCHAR(40)
- director — VARCHAR(40)
posters
- id — Long — Primary key — NOT NULL
- movie_id — Long
- image_url — VARCHAR(200)
- upload_date — DATE
schedules
- id — Long — Primary key — NOT NULL
- movie_Id (movie_id) — Long
- theater_id — Long
- show_date — DATE
- show_time — TIME
theaters
- id — Long — Primary key — NOT NULL
- name — VARCHAR(40)
- location — VARCHAR(40)
- capacity — int