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