megabox

Tables (8)

heart

  • 좋아요 id (like_id) — integer — Primary key — NOT NULL
  • 리뷰ID (review_id) — integer — Foreign key → review.리뷰ID — NOT NULL
  • 영화ID (movie_id) — integer — Foreign key → review.영화ID — NOT NULL
  • 회원ID (user_id) — integer — Foreign key → review.회원ID — NOT NULL
  • 영화관ID (theater_id) — integer — Foreign key → review.영화관ID — NOT NULL
  • 상태 (status) — integer — NOT NULL

movie

  • 영화ID (movie_id) — integer — Primary key — NOT NULL
  • 영화관ID (theater_id) — integer — Foreign key → theater.영화관ID — NOT NULL
  • 영화 제목 (title) — varchar(20) — NOT NULL
  • 장르 (genre) — varchar(20) — NOT NULL
  • 감독 (director) — varchar(20) — NOT NULL
  • 배우 (actors) — varchar(255) — NOT NULL
  • 평점 (rating) — integer
  • 개봉일 (release_date) — varchar(8) — NOT NULL
  • 상영시간 (running_time) — integer — NOT NULL
  • 예매율 (reservation_rate) — integer — NOT NULL
  • 영화 이미지 (poster_url) — varchar(255) — NOT NULL
  • 연령등급 (age) — integer

review

  • 리뷰ID (review_id) — integer — Primary key — NOT NULL
  • 영화ID (movie_id) — integer — Foreign key → movie.영화ID — NOT NULL
  • 회원ID (user_id) — integer — Foreign key → user.회원ID — NOT NULL
  • 영화관ID (theater_id) — integer — Foreign key → movie.영화관ID — NOT NULL
  • 리뷰 내용 (content) — varchar(255) — NOT NULL
  • 평점 (rating) — integer — NOT NULL
  • 리뷰 생성일 (created_at) — varchar(8) — NOT NULL
  • 추천 수 (recommend_count) — integer

review tag

  • 태그 아이디 (tag_id) — integer — Primary key — NOT NULL
  • 리뷰ID (review_id) — integer — Foreign key → review.리뷰ID — NOT NULL
  • 영화ID (movie_id) — integer — Foreign key → review.영화ID — NOT NULL
  • 회원ID (user_id) — integer — Foreign key → review.회원ID — NOT NULL
  • 영화관ID (theater_id) — integer — Foreign key → review.영화관ID — NOT NULL
  • 태그 (tag) — varchar(255) — NOT NULL

screening_info

  • 날짜 (date) — varchar(8) — Primary key — NOT NULL
  • 시간 (time) — varchar(4) — Primary key — NOT NULL
  • 영화ID (movie_id) — integer — Foreign key → movie.영화ID — NOT NULL
  • 영화관ID (theater_id) — integer — Foreign key → movie.영화관ID — NOT NULL
  • 영화 홀 ID (theater_hall) — integer — Foreign key → theater_hall.영화 홀 ID — NOT NULL

theater

  • 영화관ID (theater_id) — integer — Primary key — NOT NULL
  • 지역 (region) — varchar(20) — NOT NULL
  • 영화관 이름 (theater_name) — varchar(20) — NOT NULL

theater_hall

  • 영화 홀 ID (theater_hall) — integer — Primary key — NOT NULL
  • 영화관ID (theater_id) — integer — Foreign key → theater.영화관ID — NOT NULL
  • 관람 날짜 (date) — varchar(8) — NOT NULL
  • 좌석ID (seat_id) — varchar(20) — NOT NULL
  • 좌석상태 (status) — integer — NOT NULL
  • 좌석수 (seat_num) — integer — NOT NULL
  • 상영관 (theater_name) — integer — NOT NULL

user

  • 회원ID (user_id) — integer — Primary key — NOT NULL
  • 이름 (name) — varchar(20) — NOT NULL
  • 이메일 (email) — varchar(20) — NOT NULL
  • 비밀번호 (password) — varchar(20) — NOT NULL
  • 프로필 사진 (profile_img) — varchar(255)