ShoppingMall2

Tables (8)

Customer (고객정보)

  • customer_code (고객번호) — number — Primary key — NOT NULL
  • customer_id (고객아이디) — varchar
  • customer_pw (고객비밀번호) — varchar
  • customer_name (고객성함) — varchar
  • customer_address (고객주소) — varchar
  • customer_birthday (고객생일) — date
  • customer_phone (고객전화번호) — varchar
  • customer_grade (고객등급) — number?
  • customer_date (가입날짜) — date

Delivery (주문내역조회용)

  • delivery_code (배송번호) — number — Primary key — NOT NULL
  • customer_code (고객번호) — number
  • delivery_number (배송조회할때 그 번호) — number
  • delivery_state (배송상태) — ?
  • delivery_date (배송완료시 날짜) — date

Order (주문서 작성용)

  • order_code (주문번호) — number — Primary key — NOT NULL
  • customer_code (고객번호) — number — Foreign key → Customer.customer_code — NOT NULL
  • product_code (상품 번호) — number — Foreign key → Product.product_code — NOT NULL
  • order_product_price (주문상품가격) — number
  • order_product_quantity (주문상품수량) — number
  • order_total_price (결제총액) — number
  • order_date (주문 일자) — date

Product (제품 정보(일종의 관리자용?이 되려나?))

  • product_code (상품 번호) — number — Primary key — NOT NULL
  • product_name (상품 이름) — varchar
  • product_price (상품 가격) — number
  • product_amount (상품 수량) — number
  • product_type (상품 종류) — varchar
  • product_type_code (상품 종류 번호) — number
  • product_img (상품 이미지) — ?
  • product_option (상품 옵션? 사이즈?) — varchar
  • Field

Product Review (제품 리뷰)

  • review_code (리뷰번호) — number — Primary key — NOT NULL
  • product_code (상품번호) — number
  • review_star (리뷰별점) — number?
  • customer_id (고객 아이디) — varchar
  • review_content (리뷰 내용) — varchar
  • review_date (리뷰 작성일) — date
  • customer_grade (고객 등급) — number?
  • review_result (리뷰 도움유무) — ?
  • review_img (리뷰 이미지) — ?

Product Type (상품 목차로 구성하려면.. 얘도?)

  • product_type_code (상품 종류 번호) — number — Primary key — NOT NULL
  • product_type (상품 종류) — varchar
  • parent_product_type_code (상위 상품종류 번호) — number

Untitled

    Wishlist (관심상품)

    • list_code (리스트 번호) — number — Primary key — NOT NULL
    • customer_code (고객 번호) — number
    • product_code (상품 번호) — number
    • list_register (찜등록날짜) — date
    • product_option (상품 옵션) — varchar
    • product_price (상품 가격) — number
    • Field3