StyleMate

Tables (6)

CART (Untitled3)

  • id (cart_id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → USER.id — NOT NULL
  • 총가격 (totalPrice)

CART_ITEM (Untitled2)

  • id (cart_item_id) — Primary key — NOT NULL
  • id (item_id) — Foreign key → ITEM.id — NOT NULL
  • id (cart_id) — Foreign key → CART.id — NOT NULL
  • 주문수량 (orderQunatity)
  • 아이템총가격 (cart_item_price)

DELIVERY (Untitled6)

  • id (delivery_id) — Primary key — NOT NULL
  • 받는사람 (recipient)
  • 주소 (address)
  • 연락처 (phoneNumber)
  • 요청사항 (request)

ITEM (Untitled)

  • id (item_id) — Primary key — NOT NULL
  • 상품이름 (item_name)
  • 가격 (price)
  • 등록수량 (stockQuantity)
  • 상세내용 (detail)

ORDER (Untitled4)

  • id (order_id) — Primary key — NOT NULL
  • id (cart_id) — Foreign key → CART.id — NOT NULL
  • id (delivery_id) — Foreign key → DELIVERY.id — NOT NULL
  • id (user_id) — Foreign key → USER.id — NOT NULL

USER (Untitled5)

  • id (user_id) — Primary key — NOT NULL
  • 이메일 (email)
  • 패스워드 (password)
  • 이름 (username)
  • 멤버쉽 (membership)
  • 권한 (role)