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
Wishlist (관심상품)
- list_code (리스트 번호) — number — Primary key — NOT NULL
- customer_code (고객 번호) — number
- product_code (상품 번호) — number
- list_register (찜등록날짜) — date
- product_option (상품 옵션) — varchar
- product_price (상품 가격) — number
- Field3