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