Movie
Tables (9)
Genre (Untitled8)
- Key (Genre_id) — varchar — Primary key — NOT NULL
- Field (Genre_name) — varchar
Member (Untitled)
- Key (Member_id) — varchar — Primary key — NOT NULL
- Field (Member_name) — varchar
- Field (person_count) — int
- Field (age) — int
Movie (Untitled3)
- Key (Movie_id) — varchar — Primary key — NOT NULL
- Field (movie_name) — varchar
- Field (total_time) — varchar
Movie_Genre (Untitled9)
- Key (Genre_id) — varchar — Foreign key → Genre.Key — NOT NULL
- Key (Movie_id) — varchar — Foreign key → Movie.Key — NOT NULL
Movie_Theater (Untitled7)
- (theater_id) — varchar — Foreign key → Theater.theater_id — NOT NULL
- Key (Movie_id) — varchar — Foreign key → Movie.Key — NOT NULL
Reservation (Untitled2)
- Key (reserve_id) — varchar — Primary key — NOT NULL
- Field (time) — date
- Field2 (price) — int
- Key (Member_id) — varchar — Foreign key → Member.Key — NOT NULL
- (person_count)
Review (Untitled5)
- Key (review_id) — varchar — Primary key — NOT NULL
- Field (stars) — varchar
- Field2 (coment) — varchar
- Key (Movie_id) — varchar — Foreign key → Movie.Key — NOT NULL
- Key (Member_id) — varchar — Foreign key → Member.Key — NOT NULL
Theater (Untitled6)
- (theater_id) — varchar — Primary key — NOT NULL
- Field (seat_id) — int
Ticket (Untitled4)
- Key (id) — Primary key — NOT NULL
- Key (reserve_id) — varchar — Foreign key → Reservation.Key — NOT NULL
- (theater_id) — varchar — Foreign key → Theater.theater_id — NOT NULL