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