영화관

테이블 (9)

고객 (Customer)

  • customer_id (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(50) — NOT NULL
  • phone_number (Field2) — VARCHAR(20) — NOT NULL

담당자 (Employee)

  • employee_id (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(50) — NOT NULL
  • rolee (Field2) — VARCHAR(50) — NOT NULL

상영관 (Screen)

  • screen_id — INT — 기본 키 — NOT NULL
  • theater_id — INT — NOT NULL
  • screen_name — VARCHAR(50) — NOT NULL
  • employee_id — INT
  • theater_id (Key) — INT — 외래 키 → 지점.theater_id — NOT NULL
  • employee_id (Key2) — INT — 외래 키 → 담당자.employee_id — NOT NULL

상영시간 (ScreenPeriod)

  • screen_period_id (Key) — INT — 기본 키 — NOT NULL
  • screen_id (Field) — INT — NOT NULL
  • movie_id (Field2) — INT — NOT NULL
  • start_time (Field3) — DATETIME — NOT NULL
  • end_time (Field4) — DATETIME — NOT NULL
  • screen_id — INT — 외래 키 → 상영관.screen_id — NOT NULL
  • movie_id (Key2) — INT — 외래 키 → 영화.movie_id — NOT NULL

영화 (Movie)

  • movie_id (Key) — INT — 기본 키 — NOT NULL
  • title (Field) — VARCHAR(100) — NOT NULL
  • start_date (Field2) — DATE — NOT NULL
  • end_date (Field3) — DATE — NOT NULL

예약 (Reservation)

  • reservation_id (Key) — INT — 기본 키 — NOT NULL
  • screen_period (Field) — INT — NOT NULL
  • seat_id (Field2) — ENUM — NOT NULL
  • Screen_period_id (Key2) — INT — 외래 키 → 상영시간.screen_period_id — NOT NULL
  • seat_id (Key3) — INT — 외래 키 → 좌석.seat_id — NOT NULL

좌석 (Seat)

  • seat_id (Key) — INT — 기본 키 — NOT NULL
  • screen_id (Field) — INT — NOT NULL
  • location (Field2) — VARCHAR(10) — NOT NULL
  • seat_type (Field3) — VARCHAR(20 — NOT NULL
  • price (Field4) — DECIMAL(10, 2) — NOT NULL
  • screen_id — INT — 외래 키 → 상영관.screen_id — NOT NULL

지점 (Theater)

  • theater_id (Key) — INT — 기본 키 — NOT NULL
  • theater_name (Field) — VARCHAR(200) — NOT NULL
  • address (Field2) — VARCHAR(200) — NOT NULL

티켓 (Ticket)

  • ticket_id (Key) — VARCHAR(20) — 기본 키 — NOT NULL
  • customer_id (Field) — INT — NOT NULL
  • Screen_period_id (Field2) — INT — NOT NULL
  • seat_id (Field3) — INT — NOT NULL
  • purchase_time (Field4) — DATETIME — NOT NULL
  • customer_id (Key2) — INT — 외래 키 → 고객.customer_id — NOT NULL
  • Screen_period_id (Key3) — INT — 외래 키 → 상영시간.screen_period_id — NOT NULL
  • seat_id (Key4) — INT — 외래 키 → 좌석.seat_id — NOT NULL