MovieReservationSystem

Tables (9)

admin (관리자)

  • 관리자id (admin_id) — Primary key — NOT NULL
  • Field (admin_name)

customer (고객)

  • 고객id (customer_id) — Primary key — NOT NULL
  • 티켓id (ticket_id) — Foreign key → ticket.티켓id — NOT NULL
  • 휴대전화 (phone_number)

employee (담당자)

  • 담당자id (employee_id) — Primary key — NOT NULL
  • 담당자이름 (employee_name)

movie (영화)

  • 영화id (movie_id) — Primary key — NOT NULL
  • 영화제목 (movie_title)
  • 영화시작일 (start_date)
  • 영화종료일 (end_date)
  • 영화 상영시간 (movie_period)

screen (상영관)

  • 상영관id (screen_id) — Primary key — NOT NULL
  • 영호관id (theater_id2) — Foreign key → theater.영호관id — NOT NULL
  • 담당자id (employee_id2) — Foreign key → employee.담당자id — NOT NULL
  • 상영관번호 (screen_number)
  • 지점id (theater_id)
  • 담당자id (employee_id)

screenPeriod (상영시간표)

  • 상영시간id (period_id) — Primary key — NOT NULL
  • 상영관id (screen_id2) — Foreign key → screen.상영관id — NOT NULL
  • 영호관id (theater_id2) — Foreign key → screen.영호관id — NOT NULL
  • 티켓id (ticket_id) — Foreign key → ticket.티켓id — NOT NULL
  • 담당자id (employee_id2) — Foreign key → screen.담당자id — NOT NULL
  • 영화id (movie_id2) — Foreign key → movie.영화id — NOT NULL
  • 상영시작시간 (start_time)
  • 상영종료시간 (end_time)
  • 상영관id (screen_id)
  • 영화id (movie_id)

seat (좌석)

  • Key — Primary key — NOT NULL
  • 상영관id (screen_id2) — Foreign key → screen.상영관id — NOT NULL
  • 영호관id (theater_id2) — Foreign key → screen.영호관id — NOT NULL
  • 담당자id (employee_id2) — Foreign key → screen.담당자id — NOT NULL
  • 좌석번호 (seat_number)
  • 좌석종류 (seat_type)
  • 좌석가격 (seat_price)
  • 상영관id (screen_id)

theater (영화관)

  • 영호관id (theater_id) — Primary key — NOT NULL
  • 영화관이름 (theater_name)

ticket (표)

  • 티켓id (ticket_id) — Primary key — NOT NULL
  • 좌석id (seat_id)
  • 고객id (customer_id)
  • 상영시간id (period_id)