cinema

Tables (7)

Member (회원)

  • Id (Key) — Long — Primary key — NOT NULL
  • name (이름) — String
  • phone_number (전화번호) — String
  • email (이메일) — String

Movie (영화)

  • ID (Key) — Long — Primary key — NOT NULL
  • title (영화제목) — String
  • rating (영상물등급) — Enum
  • release_date (개봉일) — Timestamp
  • thumbnail (썸네일주소) — String
  • genre (장르) — Enum
  • runtime_minutes (러닝타임) — Integer

Reservation (예매)

  • id (Key) — Long — Primary key — NOT NULL
  • reserved_at (예매시간) — Timestamp
  • member_id (회원) — Long — Foreign key → Member.Id — NOT NULL
  • Screening_id (상영) — Long — Foreign key → Screening.Id — NOT NULL

Screening (상영)

  • Id (Key) — Long — Primary key — NOT NULL
  • start_time (상영 시작 시간) — Timestamp
  • end_time (상영 종료 시간) — Timestamp
  • movie_id (영화) — Long — Foreign key → Movie.ID — NOT NULL
  • theater_Id (상영관) — Long — Foreign key → Theater.Id — NOT NULL

Seat (좌석)

  • Id (Long) — Primary key — NOT NULL
  • seat_row (행) — String
  • seat_col (열) — String
  • status (상태) — Enum
  • theater_Id (상영관) — Long — Foreign key → Theater.Id — NOT NULL

Theater (상영관)

  • Id (Key) — Long — Primary key — NOT NULL
  • name (상영관이름)

reservation_seat (예매 좌석)

  • Id (Key) — Primary key — NOT NULL
  • reservation_id (예매) — Long — Foreign key → Reservation.id — NOT NULL
  • seat_Id (좌석) — Long — Foreign key → Seat.Id — NOT NULL