movie
Tables (10)
book (예약)
- id (예약) — CHA — Primary key — NOT NULL
- user_id (아이디) — INT — Foreign key → member.id — NOT NULL
- ser_mo (영화목록조회) — ENUM
- cin_detail (영화관상세정보) — CHA
- cho_seat (영화자리선택) — ENUM
- res (예약진행) — CHA
- check_res (예약확인) — CHA
- can_mo (예약취소) — CHA
cinema (영화관)
- id (영화관) — ENUM — Primary key — NOT NULL
- id (영화2) — VARCHA — Foreign key → movie.id — NOT NULL
- id (결제수단선택) — ENUM — Foreign key → movie.id — NOT NULL
- user_id (아이디) — CHA — Foreign key → movie.user_id — NOT NULL
- res (예약) — CHA — Foreign key → movie.res — NOT NULL
- id (상영정보) — VARCHA — Foreign key → movie.id — NOT NULL
- id (위치) — INT — Foreign key → locate.id — NOT NULL
- id (리뷰ID) — INT — Foreign key → locate.id — NOT NULL
- mo_name (영화명) — TEXT — Foreign key → locate.mo_name — NOT NULL
- id (예약2) — CHA — Foreign key → locate.id — NOT NULL
- user_id (아이디2) — CHA — Foreign key → locate.user_id — NOT NULL
- cho_per (결제수단선택2) — CHA — Foreign key → locate.cho_per — NOT NULL
- id (예약22) — CHA — Foreign key → locate.id — NOT NULL
- user_id (아이디22) — CHA — Foreign key → locate.user_id — NOT NULL
- Field
locate (위치)
- id (위치) — INT — Primary key — NOT NULL
- id (리뷰ID) — INT — Foreign key → notion.id — NOT NULL
- mo_name (영화명) — TEXT — Foreign key → notion.mo_name — NOT NULL
- id (예약) — CHA — Foreign key → notion.id — NOT NULL
- user_id (아이디) — CHA — Foreign key → notion.user_id — NOT NULL
- cho_per (결제수단선택) — CHA — Foreign key → notion.cho_per — NOT NULL
- id (예약2) — CHA — Foreign key → notion.id — NOT NULL
- user_id (아이디2) — CHA — Foreign key → notion.user_id — NOT NULL
- X (X좌표) — INT
- Y (Y좌표) — INT
member (유저)
- id (아이디) — INT — Primary key — NOT NULL
- email (이메일) — VARCHA
- pw (패스워드) — VARCHA
- name (이름) — CHA
- phone (전화번호) — INT
- age (나이) — INT
- gender (성별) — ENUM
movie (영화)
- id (영화) — VARCHA — Primary key — NOT NULL
- id (결제수단선택) — ENUM — Foreign key → perchase.id — NOT NULL
- user_id (아이디) — CHA — Foreign key → perchase.user_id — NOT NULL
- res (예약) — CHA — Foreign key → perchase.res — NOT NULL
- id (상영정보) — VARCHA — Foreign key → show_info.id — NOT NULL
- open_date (개봉일) — INT
- rate (예매율) — INT
- Field
notion (알림)
- id (리뷰ID) — INT — Primary key — NOT NULL
- mo_name (영화명) — TEXT — Foreign key → review.user_id — NOT NULL
- id (예약) — CHA — Foreign key → book.id — NOT NULL
- user_id (아이디) — CHA — Foreign key → book.user_id — NOT NULL
- cho_per (결제수단선택) — CHA — Foreign key → perchase.id — NOT NULL
- id (예약2) — CHA — Foreign key → perchase.res — NOT NULL
- user_id (아이디2) — CHA — Foreign key → perchase.user_id — NOT NULL
- id_no (회원가입알림) — CHA
- book_no (예매완료알림) — CHA
- cancle_no (취소알림) — CHA
- refu_no (환불알림) — CHA
- resid_np (회원탈퇴알림) — CHA
perchase (결제)
- id (결제수단선택) — ENUM — Primary key — NOT NULL
- user_id (아이디) — CHA — Foreign key → book.user_id — NOT NULL
- res (예약) — CHA — Foreign key → book.id — NOT NULL
- con_per (결제확인) — CHA
- refu_per (결제취소) — CHA
- refu_law (환불정책) — CHA
review (리뷰)
- id (리뷰ID) — INT — Primary key — NOT NULL
- user_id (아이디) — CHA — Foreign key → member.id — NOT NULL
- mo_name (영화명) — TEXT
- content (리뷰내용) — TEXT
- star (별점) — ENUM
- watch_time (관람일자) — INT
- wri_time (리뷰작성일자) — INT
seat (좌석)
- Key (좌석) — VARCHA — Primary key — NOT NULL
- id (영화관) — ENUM — Foreign key → cinema.id — NOT NULL
- id (상영정보) — VARCHA — Foreign key → cinema.id — NOT NULL
- id (영화2) — VARCHA — Foreign key → cinema.id — NOT NULL
- id (결제수단선택) — ENUM — Foreign key → cinema.id — NOT NULL
- user_id (아이디) — CHA — Foreign key → cinema.user_id — NOT NULL
- res (예약) — CHA — Foreign key → cinema.res — NOT NULL
- id (위치) — INT — Foreign key → cinema.id — NOT NULL
- id (리뷰ID) — INT — Foreign key → cinema.id — NOT NULL
- mo_name (영화명) — TEXT — Foreign key → cinema.mo_name — NOT NULL
- id (예약2) — CHA — Foreign key → cinema.id — NOT NULL
- user_id (아이디2) — CHA — Foreign key → cinema.user_id — NOT NULL
- cho_per (결제수단선택2) — CHA — Foreign key → cinema.cho_per — NOT NULL
- id (예약22) — CHA — Foreign key → cinema.id — NOT NULL
- user_id (아이디22) — CHA — Foreign key → cinema.user_id — NOT NULL
- row (행) — TEXT
- col (열) — INT
show_info (상영정보)
- id (상영정보) — VARCHA — Primary key — NOT NULL
- mo_name (영화명) — VARCHA
- actor (출연배우) — TEXT
- ditector (감독) — TEXT
- age (관람가연령) — INT
- time (상영시간) — INT