Movie_Project

Tables (7)

Movies (Untitled2)

  • id (MovieId) — int — Primary key — NOT NULL — Auto Increment
  • 제목 (Title) — varchar(255) — NOT NULL
  • 상영시간 (Duration) — int

PAYMENT (Untitled7)

  • id (PaymentId) — int — Primary key — NOT NULL — Auto Increment
  • id (ReservationId) — int — Foreign key → RESERVATIONS.id — NOT NULL — Auto Increment
  • id (UserId) — int — Foreign key → RESERVATIONS.id — NOT NULL — Auto Increament
  • id (SeatId) — int — Foreign key → RESERVATIONS.id — NOT NULL — Auto Increment
  • id (ShowtimeId) — int — Foreign key → RESERVATIONS.id — NOT NULL — Auto Increment
  • id (MovieId) — int — Foreign key → RESERVATIONS.id — NOT NULL — Auto Increment
  • id (TheaterId) — int — Foreign key → RESERVATIONS.id — NOT NULL — Auto Increment
  • 금액 (Amount) — int — NOT NULL

RESERVATIONS (Untitled6)

  • id (ReservationId) — int — Primary key — NOT NULL — Auto Increment
  • id (UserId) — int — Foreign key → USERS.id — NOT NULL — Auto Increament
  • id (SeatId) — int — Foreign key → SEATS.id — NOT NULL — Auto Increment
  • id (ShowtimeId) — int — Foreign key → SEATS.id — NOT NULL — Auto Increment
  • id (MovieId) — int — Foreign key → SEATS.id — NOT NULL — Auto Increment
  • id (TheaterId) — int — Foreign key → SEATS.id — NOT NULL — Auto Increment
  • 예약시간 (ReservationTime) — datetime — NOT NULL

SEATS (Untitled5)

  • id (SeatId) — int — Primary key — NOT NULL — Auto Increment
  • id (ShowtimeId) — int — Foreign key → Showtimes.id — NOT NULL — Auto Increment
  • id (MovieId) — int — Foreign key → Showtimes.id — NOT NULL — Auto Increment
  • id (TheaterId) — int — Foreign key → Showtimes.id — NOT NULL — Auto Increment
  • 좌석번호 (SeatNumber) — varchar(10) — NOT NULL
  • 예약 여부 (IsReserved) — boolean — NOT NULL

Showtimes (Untitled4)

  • id (ShowtimeId) — int — Primary key — NOT NULL — Auto Increment
  • id (MovieId) — int — Foreign key → Movies.id — NOT NULL — Auto Increment
  • id (TheaterId) — int — Foreign key → Theaters.id — NOT NULL — Auto Increment
  • 상영시간 (ShowDateTime) — datetime — NOT NULL

Theaters (Untitled3)

  • id (TheaterId) — int — Primary key — NOT NULL — Auto Increment
  • 극장명 (Name) — varchar(255) — NOT NULL

USERS (Untitled)

  • id (UserId) — int — Primary key — NOT NULL — Auto Increament
  • 이름 (Username) — varchar(255) — NOT NULL
  • 비밀번호 (Password) — varchar(255) — NOT NULL