mall-spring-project

Tables (32)

address_list (배송지 주소 목록)

  • address_book_id (Key) — int — Primary key — NOT NULL
  • member_code (Key2) — int — Foreign key → member.member_code — NOT NULL
  • address_name (Field) — varchar(45)
  • address (Field2) — varchar(200)
  • recipient_name (Field3) — varchar(45)
  • recipient_phone (Field4) — varchar(45)
  • reg_date (Field5) — date
  • upd_date (Field6) — date
  • delete_yn (Field7) — varchar(10)

answer (고객센터 문의 답변)

  • answer_id (Key) — int — Primary key — NOT NULL
  • inquiry_id (Key3) — int — Foreign key → inquiry.inquiry_id — NOT NULL
  • member_code (Field) — varchar(45)
  • description (Field2) — varchar(200)

answer_image (고객센터 답변 사진)

  • file_id (Key) — int — Primary key — NOT NULL
  • answer_id (Key2) — int — Foreign key → answer.answer_id — NOT NULL
  • inquiry_id (Key3) — int — Foreign key → answer.inquiry_id — NOT NULL
  • original_file_name (Field) — varchar(100)
  • save_file_name (Field2) — varchar(100)
  • size (Field3) — int
  • delete_yn (Field4) — varchar(10)
  • reg_date (Field5) — date
  • delete_date (Field6) — date
  • upd_date (Field7) — date

basket (장바구니)

  • basket_id (Key) — Primary key — NOT NULL
  • member_code (Key2) — int — Foreign key → member.member_code — NOT NULL
  • product_id (Key3) — int — Foreign key → product.product_id — NOT NULL
  • product_option_id (Key4) — int — Foreign key → product_option.product_option_id — NOT NULL

category (카테고리)

  • category_id (Key) — int — Primary key — NOT NULL
  • category_name (Field) — varchar(45)

coupon (쿠폰)

  • coupon_id (Key) — int — Primary key — NOT NULL
  • coupon_name (Field) — varchar(100)
  • discount_rate (Field2) — double
  • start_date (Field3) — date
  • end_date (Field5) — date

coupon_paid (지급된 쿠폰)

  • coupon_paid_id (Key3) — int — Primary key — NOT NULL
  • coupon_id (Key) — int — Foreign key → coupon.coupon_id — NOT NULL
  • member_code (Key2) — int — Foreign key → member.member_code — NOT NULL
  • reg_date (Field2) — date
  • use_yn (Field) — varchar(10)

evaluation_detail (평가 세부정보)

  • evaluation_id (Key) — int — Foreign key → product_evaluation.evaluation_id — NOT NULL
  • evaluation_title (Field) — varchar(100)
  • evaluation_description (Field2) — varchar(200)

inquiry (고객센터 문의)

  • inquiry_id (Key) — int — Primary key — NOT NULL
  • member_code (Key2) — int — Foreign key → member.member_code — NOT NULL
  • inquiry_title (Field) — varchar(100)
  • inquiry_description (Field2) — varchar(200)

inquiry_image (고객센터 문의 사진)

  • file_id (Key) — int — Primary key — NOT NULL
  • inquiry_id (Key2) — int — Foreign key → inquiry.inquiry_id — NOT NULL
  • original_file_name (Field) — varchar(100)
  • save_file_name (Field2) — varchar(100)
  • size (Field3) — int
  • delete_yn (Field4) — varchar(10)
  • reg_date (Field5) — date
  • delete_date (Field6) — date
  • upd_date (Field7) — date

member (회원)

  • member_code (Key) — int — Primary key — NOT NULL
  • member_id (Unique) — varchar(45)
  • member_pw (Field2) — varchar(45)
  • member_name (Field3) — varchar(45)
  • phone (Field4) — varchar(45)
  • email (Field5) — varchar(45)
  • delete_yn (Field) — varchar(10)
  • reg_date (Field7) — date
  • upd_date (Field8) — date

member_auth (Untitled)

  • member_auth_id (Key) — int — Primary key — NOT NULL
  • member_code (Key2) — int — Foreign key → member.member_code — NOT NULL
  • auth (Field2) — varchar(15)
  • reg_date (Field3) — date
  • upd_date (Field4) — date

order (주문)

  • order_id (Key) — int — Primary key — NOT NULL
  • member_code (Key3) — int — Foreign key → member.member_code — NOT NULL
  • product_id (Key2) — int — Foreign key → product.product_id — NOT NULL
  • product_option_id (Key4) — int — Foreign key → product_option.product_option_id — NOT NULL
  • payment_type (Field3) — int
  • total_order_amount (Field2) — int
  • order_date (Field) — date

order_detail (주문 세부정보)

  • order_detail_id (Key) — int — Primary key — NOT NULL
  • order_id (Key2) — int — Foreign key → order.order_id — NOT NULL
  • coupon_paid_id (Key3) — int — Foreign key → coupon_paid.coupon_paid_id — NOT NULL
  • product_id (Key22) — int — Foreign key → order.product_id — NOT NULL
  • product_option_id (Key4) — int — Foreign key → order.product_option_id — NOT NULL
  • order_product_quantity (Field) — int
  • discount_amount (Field2) — int

order_status (주문 상태)

  • order_status_id (Key) — int — Primary key — NOT NULL
  • order_id (Key2) — int — Foreign key → order.order_id — NOT NULL
  • product_id (Key22) — int — Foreign key → order.product_id — NOT NULL
  • product_option_id (Key4) — int — Foreign key → order.product_option_id — NOT NULL
  • order_status (Field) — varchar(45)

payment_deposit (입금 결제)

  • payment_deposit_id (Key) — int — Primary key — NOT NULL
  • order_id (Key2) — int — Foreign key → order.order_id — NOT NULL
  • product_id (Key22) — int — Foreign key → order.product_id — NOT NULL
  • product_option_id (Key4) — int — Foreign key → order.product_option_id — NOT NULL
  • tran_date (Field) — date
  • tran_time (Field2) — date
  • tran_type (Field3) — varchar(45)
  • print_content (Field4) — varchar(200)
  • tran_amt (Field5) — int
  • branch_name (Field6) — varchar(45)
  • remitter_name (Field7) — varchar(45)
  • remitter_bank_code (Field8) — int
  • remitter_account_num (Field9) — varchar(45)

payment_kakao (카카오페이)

  • payment_card_id (Key) — int — Primary key — NOT NULL
  • partner_order_id (Key2) — int — Foreign key → order.order_id — NOT NULL
  • amount_id (Key3) — int — Foreign key → payment_kakao_amount.amount_id — NOT NULL
  • card_info_id (Key4) — int — Foreign key → payment_kakao_card_info.card_info_id — NOT NULL
  • product_id (Key22) — int — Foreign key → order.product_id — NOT NULL
  • product_option_id (Key42) — int — Foreign key → order.product_option_id — NOT NULL
  • aid (Field) — int
  • tid (Field2) — int
  • cid (Field3) — int
  • sid (Field4) — varchar(45)
  • partner_other_id (Field6) — varchar(45)
  • payment_method_type (Field7) — varchar(45)
  • item_name (Field5) — varchar(45)
  • item_code (Field8) — int
  • quantity (Field9) — int
  • created_at (Field10) — date
  • approved_at (Field11) — date
  • payload (Field12) — varchar(200)

payment_kakao_amount (카카오페이 - 결제 금액)

  • amount_id (Key) — int — Primary key — NOT NULL
  • total (Field) — int
  • tax_free (Field2) — int
  • vat (Field3) — int
  • point (Field4) — int
  • discount (Field5) — int

payment_kakao_card_info (카카오페이 - 카드 정보)

  • card_info_id (Key) — int — Primary key — NOT NULL
  • purchase_corp (Field) — varchar(45)
  • purchase_corp_code (Field2) — varchar(45)
  • issuer_corp (Field3) — varchar(45)
  • issuer_corp_code (Field4) — varchar(45)
  • kakaopay_purchase_corp (Field5) — varchar(45)
  • kakaopay_purchase_corp (Field6) — varchar(45)
  • bin (Field7) — varchar(45)
  • card_type (Field8) — varchar(45)
  • install_month (Field9) — int
  • approved_id (Field10) — varchar(45)
  • card_mid (Field11) — varchar(45)
  • interest_free_install (Field12) — varchar(10)
  • card_item_code (Field13) — varchar(45)

product (제품)

  • product_id (Key) — int — Primary key — NOT NULL
  • category_id (Key2) — int — Foreign key → category.category_id — NOT NULL
  • product_name (Field) — varchar(100)
  • product_price (Field2) — int
  • delete_yn (Field7) — varchar(10)
  • reg_date (Field4) — date
  • upd_date (Field5) — date

product_answer (제품 문의 답변)

  • product_answer_id (Key) — int — Primary key — NOT NULL
  • inquiry_id (Key2) — int — Foreign key → product_inquiry.product_inquiry_id — NOT NULL
  • member_code (Field) — varchar(45)
  • answer_description (Field2) — varchar(200)

product_answer_image (제품 답변 사진)

  • file_id (Key) — int — Primary key — NOT NULL
  • product_answer_id (Key2) — int — Foreign key → product_answer.product_answer_id — NOT NULL
  • original_file_name (Field) — varchar(100)
  • save_file_name (Field2) — varchar(100)
  • size (Field3) — int
  • delete_yn (Field4) — varchar(10)
  • reg_date (Field5) — date
  • delete_date (Field6) — date
  • upd_date (Field7) — date

product_detail (제품 세부정보)

  • product_detail_id (Key) — int — Primary key — NOT NULL
  • product_id (Key2) — int — Foreign key → product.product_id — NOT NULL
  • product_description (Field) — varchar(1000)

product_detail_image (제품 세부정보 사진)

  • file_id (Key) — int — Primary key — NOT NULL
  • product_detail_id (Key2) — int — Foreign key → product_detail.product_detail_id — NOT NULL
  • product_id (Key22) — int — Foreign key → product_detail.product_id — NOT NULL
  • original_file_name (Field) — varchar(100)
  • save_file_name (Field2) — varchar(100)
  • size (Field3) — int
  • delete_yn (Field4) — varchar(10)
  • reg_date (Field5) — date
  • delete_date (Field6) — date
  • upd_date (Field7) — date

product_evaluation (제품 평가)

  • evaluation_id (Key) — int — Primary key — NOT NULL
  • product_id (Key3) — int — Foreign key → product.product_id — NOT NULL
  • member_code (Key2) — int — Foreign key → member.member_code — NOT NULL
  • score (Field) — int
  • reg_date (Field3) — date
  • upd_date (Field4) — date

product_evaluation_image (제품 평가 사진)

  • file_id (Key) — int — Primary key — NOT NULL
  • evaluation_id (Key2) — int — Foreign key → product_evaluation.evaluation_id — NOT NULL
  • original_file_name (Field) — varchar(100)
  • save_file_name (Field2) — varchar(100)
  • size (Field3) — int
  • delete_yn (Field4) — varchar(10)
  • reg_date (Field5) — date
  • delete_date (Field6) — date
  • upd_date (Field7) — date

product_image (제품 사진)

  • file_id (Key) — int — Primary key — NOT NULL
  • product_id (Key2) — int — Foreign key → product.product_id — NOT NULL
  • original_file_name (Field) — varchar(100)
  • save_file_name (Field2) — varchar(100)
  • size (Field3) — int
  • delete_yn (Field4) — varchar(10)
  • reg_date (Field5) — date
  • delete_date (Field6) — date
  • upd_date (Field7) — date

product_inquiry (제품 문의)

  • product_inquiry_id (Key) — int — Primary key — NOT NULL
  • product_id (Key2) — int — Foreign key → product.product_id — NOT NULL
  • member_code (Key3) — int — Foreign key → member.member_code — NOT NULL
  • inquiry_title (Field) — varchar(100)
  • inquiry_description (Field2) — varchar(200)

product_inquiry_image (제품 문의 사진)

  • file_id (Key) — int — Primary key — NOT NULL
  • product_inquiry_id (Key2) — int — Foreign key → product_inquiry.product_inquiry_id — NOT NULL
  • original_file_name (Field) — varchar(100)
  • save_file_name (Field2) — varchar(100)
  • size (Field3) — int
  • delete_yn (Field4) — varchar(10)
  • reg_date (Field5) — date
  • delete_date (Field6) — date
  • upd_date (Field7) — date

product_inventory (제품 재고)

  • product_inventory_id (Key) — int — Primary key — NOT NULL
  • product_option_id (Key2) — int — Foreign key → product_option.product_option_id — NOT NULL
  • quantity (Field) — int

product_option (제품 옵션)

  • product_option_id (Key) — int — Primary key — NOT NULL
  • product_id (Key2) — int — Foreign key → product.product_id — NOT NULL
  • product_size (Field) — varchar(10)
  • product_color (Field2) — varchar(10)

wish_list (찜 목록)

  • wish_list_id (Key) — int — Primary key — NOT NULL
  • product_id (Key2) — int — Foreign key → product.product_id — NOT NULL
  • member_code (Key3) — int — Foreign key → member.member_code — NOT NULL