mark project

Tables (6)

Address (배송지)

  • Address_id (배송지 고유번호) — Primary key — NOT NULL
  • user_id (회원고유번호) — Foreign key → User.user_id — NOT NULL
  • address (배송지)
  • createAt (생성날짜)
  • updateAt (수정날짜)

Cart (장바구니)

  • cart_id (장바구니고유번호) — Primary key — NOT NULL
  • createAt (생성날짜)
  • updateAt (수정날짜)
  • quanitiy (수량??)

Order (주문)

  • order_id (주문번호) — Primary key — NOT NULL
  • user_id (회원고유번호) — Foreign key → User.user_id — NOT NULL
  • total_price (주문 총 금액) — 고려해봐야할 것
  • delivery_status (배송상태)
  • req (배송요청사항)
  • createAt (주문날짜)
  • Field

Order_Product (주문상품)

  • order_id (주문번호) — Foreign key → Order.order_id — NOT NULL
  • product_id (상품고유번호) — Foreign key → Product.product_id — NOT NULL
  • price (주문 가격)
  • item_quantity (수량)

Product (상품)

  • product_id (상품고유번호) — Primary key — NOT NULL
  • image (상품이미지)
  • product_name (상품명)
  • product_price (상품가격)
  • product_stock (상품수량)
  • product_info (상품설명)
  • product_cataegory (상품카테고리)
  • createAt (생성날짜)
  • createBy (생성자)
  • updateAt (수정날짜)

User (사용자)

  • user_id (회원고유번호) — Primary key — NOT NULL
  • password (비밀번호)
  • name (이름)
  • phone (전화번호)
  • role (역할)
  • createAt (생성날짜)
  • updateAt (수정날짜)