movie

Tables (9)

MEMBER

  • member_id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • membership_grade — VARCHAR(20)

MOVIE

  • movie_id — INT
  • title — VARCHAR(255) — NOT NULL
  • director — VARCHAR(100)
  • genre — VARCHAR(100)
  • rating — VARCHAR(20)
  • running_time_min — INT

PAYMENT

  • reservation_id — INT
  • payment_method — VARCHAR(50) — NOT NULL
  • payment_status — VARCHAR(20) — NOT NULL
  • payment_time — DATETIME — NOT NULL
  • approval_number — VARCHAR(100)

RESERVATION

  • reservation_id — INT
  • member_id — INT — NOT NULL
  • showing_id — INT — NOT NULL
  • reservation_time — DATETIME — NOT NULL
  • total_amount — DECIMAL(10, 2) — NOT NULL

SCREEN

  • screen_id — INT
  • theater_id — INT — NOT NULL
  • screen_name — VARCHAR(50) — NOT NULL
  • total_seats — INT — NOT NULL

SEAT

  • seat_id — INT
  • screen_id — INT — NOT NULL
  • seat_row — VARCHAR(10) — NOT NULL
  • seat_number — INT — NOT NULL
  • seat_type — VARCHAR(20)

SHOWING

  • showing_id — INT
  • movie_id — INT — NOT NULL
  • screen_id — INT — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL

THEATER

  • theater_id — INT
  • theater_name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(255) — NOT NULL

TICKET

  • ticket_id — INT
  • reservation_id — INT — NOT NULL
  • seat_id — INT — NOT NULL