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