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)