영화예매 시스템

테이블 (10)

Food (Untitled5)

  • Food_id (PK) — 기본 키 — NOT NULL
  • Food_name (Field)
  • food_price (Field2)

Food_order (Untitled7)

  • food_order_id (Key2) — 기본 키 — NOT NULL
  • Food_id (PK) — 외래 키 → Food.Food_id — NOT NULL
  • order_id (Key) — 외래 키 → Order.order_id — NOT NULL
  • count (Field)

Grade (Untitled10)

  • grade_id (Key) — 기본 키 — NOT NULL
  • grade_step (Field)
  • grade_benefit (Field2)

Member (Untitled3)

  • member_id (PK) — 기본 키 — NOT NULL
  • member_name (.)
  • member_phonenumber (Field)
  • / (Field2)

Movie (Untitled2)

  • movie_id (PK) — 기본 키 — NOT NULL
  • movie_name (.)
  • movie_genre (Field)
  • / (Field2)

Movie_Theater (Untitled6)

  • Movie_Theater_id (Key) — 기본 키 — NOT NULL
  • movie_id (PK) — 외래 키 → Movie.movie_id — NOT NULL
  • theater_id (pk2) — 외래 키 → Theater (상영관).theater_id — NOT NULL
  • Field

Order (Untitled9)

  • order_id (Key) — 기본 키 — NOT NULL
  • member_id (PK2) — 외래 키 → Member.member_id — NOT NULL

Reservation (Untitled4)

  • reservation_id (PK) — 기본 키 — NOT NULL
  • member_id (FK) — 외래 키 → Member.member_id — NOT NULL
  • Ticket_id (Key) — 외래 키 → Ticket.Ticket_id — NOT NULL
  • reservation_time (Field)
  • reservation_price (Field2)
  • reservation_event (Field3)
  • count (티켓 수량) (Field4)

Theater (상영관) (Untitled)

  • theater_id (pk) — 기본 키 — NOT NULL
  • theater_num (Field)
  • theater_floor (Field2)
  • Field3

Ticket (Untitled8)

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