Movie_Reservation

Tables (10)

Likes (관심목록)

  • 관심목록ID (id) — NOT NULL — Primary key — NOT NULL
  • 사용자ID (user_id) — NOT NULL — Foreign key → Users.이메일 — NOT NULL
  • 영화ID (movie_id) — NOT NULL — Foreign key → Movie.영화ID — NOT NULL
  • 생성일 (created_at) — NOT NULL

Movie (영화)

  • 영화ID (id) — NOT NULL — Primary key — NOT NULL
  • 사용자ID (user_email) — NOT NULL — Foreign key → Users.이메일 — NOT NULL
  • 제목 (title) — NOT NULL
  • 설명 (description) — NOT NULL
  • 상영시작일 (release_date) — NOT NULL
  • 상영종료일 (close_date) — NOT NULL
  • 상영시간 (running_time) — NOT NULL
  • 관람연령 (viewing_age) — NULL
  • 장르 (genre) — NOT NULL
  • 감독 (director) — NOT NULL
  • 주연배우 (main_actor) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 수정일 (modified_at) — NULL

Reservation (예매)

  • 예매ID (id) — NOT NULL — Primary key — NOT NULL
  • 이메일 (email) — NOT NULL — Foreign key → Users.이메일 — NOT NULL
  • 상영별좌석ID (screening_seat_id) — NOT NULL — Foreign key → ScreeningSeat.상영별좌석ID — NOT NULL
  • 상영ID (screening_id) — NOT NULL — Foreign key → ScreeningSeat.상영ID — NOT NULL
  • 좌석ID (seat_id) — NOT NULL — Foreign key → ScreeningSeat.좌석ID — NOT NULL
  • 상영관ID (theater_id) — NOT NULL — Foreign key → ScreeningSeat.상영관ID — NOT NULL
  • 예약상태 (reservation_status) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 수정일 (modified_at) — NULL

Review (리뷰)

  • 리뷰ID (id) — NOT NULL — Primary key — NOT NULL
  • 예매ID (reservation_id) — NOT NULL — Foreign key → Reservation.예매ID — NOT NULL
  • 이메일 (email) — NOT NULL — Foreign key → Reservation.이메일 — NOT NULL
  • 상영별좌석ID (screening_seat_id) — NOT NULL — Foreign key → Reservation.상영별좌석ID — NOT NULL
  • 상영ID (screening_id) — NOT NULL — Foreign key → Reservation.상영ID — NOT NULL
  • 좌석ID (seat_id) — NOT NULL — Foreign key → Reservation.좌석ID — NOT NULL
  • 상영관ID (theater_id) — NOT NULL — Foreign key → Reservation.상영관ID — NOT NULL
  • 별점 (star_rating) — NOT NULL
  • 내용 (review_content) — NOT NULL
  • 생성일 (created_at) — NOT NULL
  • 수정일 (modified_at) — NULL

Role (역할)

  • 역할ID (id) — NOT NULL — Primary key — NOT NULL
  • 권한 (role_name) — NOT NULL

Screening (상영)

  • 상영ID (id) — NOT NULL — Primary key — NOT NULL
  • 영화ID (movie_id) — NOT NULL — Foreign key → Movie.영화ID — NOT NULL
  • 상영관ID (theater_id) — NOT NULL — Foreign key → Theater.상영관ID — NOT NULL
  • 상영날짜 (screening_date) — NOT NULL
  • 상영시작시간 (start_time) — NOT NULL
  • 상영종료시간 (end_time) — NOT NULL
  • 티켓가격 (ticket_price) — NOT NULL

ScreeningSeat (상영별예매현황좌석)

  • 상영별좌석ID (id) — NOT NULL — Primary key — NOT NULL
  • 상영ID (screening_id) — NOT NULL — Foreign key → Screening.상영ID — NOT NULL
  • 좌석ID (seat_id) — NOT NULL — Foreign key → Seat.좌석ID — NOT NULL
  • 상영관ID (theater_id) — NOT NULL — Foreign key → Seat.상영관ID — NOT NULL
  • 예약현황 (is_reserved) — NOT NULL

Seat (좌석)

  • 좌석ID (id) — NOT NULL — Primary key — NOT NULL
  • 상영관ID (theater_id) — NOT NULL — Foreign key → Theater.상영관ID — NOT NULL
  • 좌석번호 (seat_number) — NOT NULL

Theater (상영관)

  • 상영관ID (id) — NOT NULL — Primary key — NOT NULL
  • 상영관이름 (theater_name) — NOT NULL
  • 총좌석수 (total_seats) — NOT NULL
  • 좌석행 (seat_row) — NOT NULL
  • 좌석열 (seat_col) — NOT NULL

Users (사용자)

  • 이메일 (email) — UNIQUE — Primary key — NOT NULL
  • 역할ID (id) — NOT NULL — Foreign key → Role.역할ID — NOT NULL
  • 비밀번호 (password) — NOT NULL
  • 이름 (member_name) — NOT NULL
  • 생년월일 (birthday) — NOT NULL
  • 가입일 (created_at) — NOT NULL
  • 수정일 (modified_at) — NULL