영화 예매 시스템

테이블 (7)

Hall (관)

  • hall_id (PK) — 기본 키 — NOT NULL
  • theater_id (pk) — 외래 키 → Theater.theater_id — NOT NULL
  • movie_id (Key) — 외래 키 → Movie.movie_id — NOT NULL

Movie (영화)

  • movie_id (Key) — 기본 키 — NOT NULL
  • movie_name (Field)
  • genre (Field2)
  • actor (Field3)
  • ditrector (Field4)

Seat (Untitled)

  • seat_id (Key) — 기본 키 — NOT NULL
  • hall_id (PK) — 외래 키 → Hall.hall_id — NOT NULL

Theater (Untitled2)

  • theater_id (pk) — 기본 키 — NOT NULL
  • count (Field)
  • theater_name (Field2)

Ticket (Untitled7)

  • movie_id (Key) — 외래 키 → Movie.movie_id — NOT NULL
  • theater_id (pk) — 외래 키 → Theater.theater_id — NOT NULL
  • hall_id (PK) — 외래 키 → Hall.hall_id — NOT NULL
  • ticketing_id (Key2) — 외래 키 → reservation.ticket_id — NOT NULL
  • date (Field)
  • seat_id (Key3) — 외래 키 → Seat.seat_id — NOT NULL

member (Untitled3)

  • member_id (PK) — 기본 키 — NOT NULL
  • member_name (Field)
  • member_phone (Field2)
  • member_age (Field3)

reservation (Untitled5)

  • ticket_id (Key) — 기본 키 — NOT NULL
  • member_id (PK) — 외래 키 → member.member_id — NOT NULL