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