ㅁㄴㅇ

Tables (9)

Actor

  • actor_id — INT
  • casting_date — DATE

Booking

  • booking_id — INT
  • member_id — INT
  • booking_date — DATE
  • payment_method — VARCHAR(50)

Booking_Detail

  • booking_id — INT
  • seat_id — INT

Member

  • member_id — INT
  • name — VARCHAR(255)
  • phone_number — VARCHAR(20)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • region — VARCHAR(255)

Movie

  • movie_id — INT
  • title — VARCHAR(255)
  • genre — VARCHAR(50)
  • director — VARCHAR(255)
  • release_date — DATE
  • production_company — VARCHAR(255)

Performance

  • movie_id — INT
  • actor_id — INT
  • performance_number — INT

Screening

  • screening_id — INT
  • movie_id — INT
  • theater_id — INT
  • screening_date — DATE
  • auditorium_name — VARCHAR(255)
  • screening_time — TIME

Seat

  • seat_id — INT
  • theater_id — INT
  • row — CHAR(1)
  • number — INT
  • seat_name — VARCHAR(50)

Theater

  • theater_id — INT
  • name — VARCHAR(255)
  • location — VARCHAR(255)
  • auditorium_count — INT