FirstMovie_TeamProject

Tables (25)

benefit

  • benefit_id — INT — Primary key — NOT NULL
  • benefit_category_id — VARCHAR(30) — Foreign key → benefit_category.benefit_category_id — NOT NULL
  • benefit_name — VARCHAR(50) — NOT NULL
  • benefit_image — VARCHAR(255) — NOT NULL — 이미지명으로 불러오기
  • benefit_content — TEXT — NOT NULL

benefit_category

  • benefit_category_id — VARCHAR(30) — Primary key — NOT NULL
  • main_category_name — VARCHAR(50) — NOT NULL
  • middle_category_name — VARCHAR(50) — NOT NULL

cart_payment

  • cart_payment_id — VARCHAR(30) — Primary key — NOT NULL
  • member_id — VARCHAR(30) — Foreign key → member.member_id — NOT NULL — 최대15글자
  • payment_datetime — DATETIME — NOT NULL
  • payment_method — TINYINT — NOT NULL — 0: 카드결제, 1: 카카오페이
  • payment_status — TINYINT — NOT NULL — 0: 결제완료, 1: 환불

cart_payment_detail

  • payment_detail_id — INT — Primary key — NOT NULL
  • member_id — VARCHAR(30) — Foreign key → member.member_id — NOT NULL — 최대15글자
  • product_id — INT — NOT NULL
  • product_count — SMALLINT — NOT NULL

coupon

  • coupon_id — INT — Primary key — NOT NULL
  • coupon_name — VARCHAR(50) — NOT NULL
  • coupon_discount_rate — TINYINT — NOT NULL
  • coupon_expiration_date — SMALLINT — NOT NULL
  • coupon_status — VARCHAR(30) — NOT NULL — 진행중 or 종료

inquire

  • inquire_id — VARCHAR(30) — Primary key — NOT NULL
  • member_id — VARCHAR(30) — Foreign key → member.member_id — NOT NULL — 최대15글자
  • inquire_kind — TINYINT — 0 : 1:1문의 1 : 분실물문의
  • inquire_title — VARCHAR(50) — NOT NULL
  • inquire_content — TEXT — NOT NULL
  • inquire_theater_name — VARCHAR(60)
  • inquire_file — VARCHAR(255)
  • inquire_pw — SMALLINT
  • inquiry_answer — VARCHAR(15) — NOT NULL
  • inquiry_datetime — DATETIME — NOT NULL

inquire_answer

  • inquire_answer_id — INT — Primary key — NOT NULL — 시퀀스사용
  • inquire_id — VARCHAR(30) — Foreign key → inquire.inquire_id — NOT NULL
  • inquire_answer_title — VARCHAR(50) — NOT NULL
  • inquire_answer_content — TEXT — NOT NULL
  • inquire_answer_day — DATETIME — NOT NULL

member

  • member_id — VARCHAR(30) — Primary key — NOT NULL — 최대15글자
  • member_name — VARCHAR(100) — NOT NULL — 국내 최고 긴 이름 30글자
  • member_pw — VARCHAR(50) — NOT NULL — 최대 15글자
  • member_email — VARCHAR(110) — NOT NULL — 구글기준 최대 30글자
  • member_gender — TINYINT — NOT NULL — 0:남성, 1:여성
  • member_birthdate — VARCHAR(40) — NOT NULL — 문자열로 값 저장
  • member_phone — VARCHAR(45) — NOT NULL — 문자열로 값 저장
  • member_email_check — TINYINT — NOT NULL — 0 : 비동의 1 : 동의
  • member_sns_check — TINYINT — NOT NULL — 0 : 비동의 1 : 동의

movie

  • movie_id — SMALLINT — Primary key — NOT NULL
  • movie_genre_id — TINYINT — Foreign key → movie_genre.movie_genre_id — NOT NULL
  • movie_name — VARCHAR(50) — NOT NULL
  • movie_running_time — SMALLINT — NOT NULL
  • movie_production_year — DATE — NOT NULL
  • movie_audience_rating — VARCHAR(30) — NOT NULL
  • movie_image — VARCHAR(255) — NOT NULL
  • director_name — VARCHAR(20) — NOT NULL
  • actor_name — VARCHAR(255) — NOT NULL

movie_genre

  • movie_genre_id — TINYINT — Primary key — NOT NULL
  • movie_genre_name — VARCHAR(50) — NOT NULL

none_exist_seats

  • none_exist_seats_id — TINYINT — Primary key — NOT NULL
  • screen_id — TINYINT — Foreign key → screen.screen_id — NOT NULL
  • screen_row — TINYINT — NOT NULL
  • screen_line — TINYINT — NOT NULL

notice

  • notice_id — INT — Primary key — NOT NULL — 시퀀스사용
  • notice_title — VARCHAR(50) — NOT NULL
  • notice_type — TINYINT — NOT NULL — 0 : 극장 1 : 기타 2: 시스템점검
  • notice_content — TEXT — NOT NULL
  • notice_datetime — DATETIME — NOT NULL
  • notice_kind — TINYINT — NOT NULL — 0 : FAQ 1 : 공지사항

payment

  • payment_id — INT — Primary key — NOT NULL — 결제 id
  • member_id — VARCHAR(30) — Foreign key → member.member_id — NOT NULL — 최대15글자
  • movie_information_id — TINYINT — Foreign key → screen_movie_information.movie_information_id — NOT NULL
  • adult — TINYINT — NOT NULL — 13000원
  • student — TINYINT — NOT NULL — 11000원
  • silver — TINYINT — NOT NULL — 7000원
  • price — MEDIUMINT — NOT NULL
  • pay_discount — MEDIUMINT — NOT NULL — 포인트 + 할인쿠폰 사용 금액
  • refund — TINYINT — NOT NULL — 0 : 환불완료, 1 : 결제완료
  • pay_datetime — DATETIME — NOT NULL
  • Field — VARCHAR(255)

payment_seat

  • payment_seat_id — VARCHAR(20) — Primary key — NOT NULL
  • payment_id — VARCHAR(30) — Foreign key → payment.payment_id — NOT NULL — 결제 id
  • seat_x — TINYINT — NOT NULL
  • seat_y — CHAR(1) — NOT NULL

point

  • point_id — INT — Primary key — NOT NULL — 시퀀스를 사용
  • payment_id — VARCHAR(30) — Foreign key → payment.payment_id — NOT NULL — 결제 id
  • member_id — VARCHAR(30) — Foreign key → member.member_id — NOT NULL — 회원테이블연결
  • point_history — INT — NOT NULL — 포인트가 +, - 된 정보
  • point_date — DATETIME — NOT NULL — 포인트 증감 발생시 기록

product

  • product_id — INT — Primary key — NOT NULL
  • product_category_id — INT — Foreign key → product_category.product_category_id — NOT NULL
  • product_name — VARCHAR(50) — NOT NULL
  • product_image — VARCHAR(255) — NOT NULL
  • product_cost — INT — NOT NULL
  • product_content — VARCHAR(255) — NOT NULL
  • product_quantity — SMALLINT — NOT NULL

product_category

  • product_category_id — INT — Primary key — NOT NULL
  • product_category_name — VARCHAR(100) — NOT NULL

region

  • region_id — TINYINT — Primary key — NOT NULL
  • region — VARCHAR(50) — NOT NULL

rental_inquiry

  • rental_inquiry_id — SMALLINT — Primary key — NOT NULL — 년월일시분초 를 활용
  • rental_inquiry_area — VARCHAR(50) — NOT NULL
  • rental_inquiry_theater — VARCHAR(60) — NOT NULL
  • rental_inquiry_date — DATE — NOT NULL
  • rental_inquiry_start — TIME — NOT NULL
  • rental_inquiry_end — TIME — NOT NULL
  • rental_inquiry_movie — VARCHAR(100) — NOT NULL
  • rental_inquiry_people_count — TINYINT — NOT NULL — 최대 50명
  • rental_inquiry_content — TEXT — NOT NULL — 문의를 하는 이유
  • rental_inquiry_name — VARCHAR(100) — NOT NULL
  • rental_inquiry_phone — VARCHAR(45) — NOT NULL
  • rental_inquiry_pw — INT — NOT NULL — 최대 4자릿수까지
  • rental_inquiry_review — TINYINT — NOT NULL — 0 : 대기 1 : 승인 2 : 미승인
  • rental_inquiry_datetime — DATETIME — NOT NULL

review

  • review_id — INT — Primary key — NOT NULL
  • member_id — VARCHAR(30) — Foreign key → member.member_id — NOT NULL — 최대15글자
  • movie_id — SMALLINT — Foreign key → movie.movie_id — NOT NULL
  • movie_review — TEXT — NOT NULL
  • creation_date — DATETIME — NOT NULL

screen

  • screen_id — TINYINT — Primary key — NOT NULL
  • branch_id — TINYINT — Foreign key → theater_branch.branch_id — NOT NULL
  • screen_location — VARCHAR(20) — NOT NULL — ex) 1관, 2관, 3관
  • screen_row — TINYINT — NOT NULL
  • screen_line — TINYINT — NOT NULL

screen_movie_information

  • movie_information_id — TINYINT — Primary key — NOT NULL
  • movie_id — SMALLINT — Foreign key → movie.movie_id — NOT NULL
  • screen_id — TINYINT — Foreign key → screen.screen_id — NOT NULL
  • branch_id — TINYINT — Foreign key → screen.branch_id — NOT NULL
  • movie_showing_date — DATE — NOT NULL
  • movie_showing_time — TIME — NOT NULL

theater_branch

  • branch_id — TINYINT — Primary key — NOT NULL
  • region_id — INT — Foreign key → region.region_id — NOT NULL
  • branch_name — VARCHAR(50) — NOT NULL
  • branch_address — VARCHAR(255) — NOT NULL
  • branch_number — TINYINT — NOT NULL — 전체 관수
  • branch_img — VARCHAR(255) — 지점 사진

user_having_coupon

  • having_coupon_id — INT — Primary key — NOT NULL
  • member_id — VARCHAR(30) — Foreign key → member.member_id — NOT NULL — 최대15글자
  • coupon_id — INT — Foreign key → coupon.coupon_id — NOT NULL
  • coupon_create_date — DATETIME — NOT NULL
  • coupon_expiration_date — DATETIME — NOT NULL

user_used_coupon

  • member_id — VARCHAR(30) — Foreign key → member.member_id — NOT NULL — 최대15글자
  • coupon_id — INT — Foreign key → coupon.coupon_id — NOT NULL
  • payment_id — VARCHAR(30) — Foreign key → payment.payment_id — NOT NULL — 결제 id
  • coupon_used_date — DATETIME — NOT NULL