Theater

Tables (10)

CUSTOMER

  • customer_id — INT
  • name — VARCHAR(100)
  • phone_number — VARCHAR(20) — NOT NULL

EMPLOYEE

  • employee_id — INT
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • position — VARCHAR(50)

MOVIE

  • movie_id — INT
  • title — VARCHAR(200) — NOT NULL
  • running_min — INT — NOT NULL
  • show_start_date — DATE — NOT NULL
  • show_end_date — DATE — NOT NULL
  • rating — VARCHAR(10)

SCREEN

  • screen_id — INT
  • theater_id — INT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • capacity — INT — NOT NULL
  • employee_id — INT

SCREENING

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

SEAT

  • seat_id — INT
  • screen_id — INT — NOT NULL
  • row_label — VARCHAR(5) — NOT NULL
  • seat_number — INT — NOT NULL
  • seat_code — VARCHAR(10) — NOT NULL
  • seat_type_id — INT — NOT NULL

SEAT_PRICE

  • screen_id — INT — Primary key — NOT NULL
  • seat_type_id — INT — Primary key — NOT NULL
  • base_price — DECIMAL(10,0) — NOT NULL

SEAT_TYPE

  • seat_type_id — INT
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200)

THEATER

  • theater_id — INT
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(200)
  • phone — VARCHAR(20)

TICKET

  • ticket_id — INT
  • screening_id — INT — NOT NULL
  • seat_id — INT — NOT NULL
  • customer_id — INT — NOT NULL
  • purchase_time — DATETIME — NOT NULL
  • price_paid — DECIMAL(10,0) — NOT NULL
  • masked_phone — VARCHAR(30)