movie_booking_system

Tables (7)

Screen (Untitled6)

  • screen_id (Key) — Primary key — NOT NULL
  • theater_id (Key2) — Foreign key → theater.theater_id — NOT NULL
  • movie_id (Key3) — Foreign key → movie.movie_id — NOT NULL
  • screen_number (Field)
  • screen_floor (Field2)
  • seating count (Field4)
  • classification (Field3)

actor (Untitled8)

  • actor (Key) — Primary key — NOT NULL
  • Field

member (Untitled)

  • member_id (Key) — Primary key — NOT NULL
  • nickname (Field2)
  • grade (Field)
  • favorite theater (Field3)

movie (Untitled2)

  • movie_id (Key) — Primary key — NOT NULL
  • movie_name (Field7)
  • released date (Field3)
  • running time (Field4)
  • film rating (Field6)
  • genre (Field5)
  • director (Field)
  • actor (Field2)

order (Untitled7)

  • reservation_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL

theater (Untitled3)

  • theater_id (Key) — Primary key — NOT NULL
  • theater_name (Field3)
  • theater_phone (Field4)
  • location (Field)

ticket (Untitled4)

  • ticket_id (Key) — Primary key — NOT NULL
  • screen_id (Key4) — Foreign key → Screen.screen_id — NOT NULL
  • order_id (Key3) — Foreign key → order.reservation_id — NOT NULL
  • ticket date (Field)
  • ticket hour (Field4)
  • seating number (Field2)
  • price (Field3)