carbon-nono

Tables (8)

ADDRESS (Untitled6)

  • Field (도시) — String
  • Field2 (도로명) — String
  • Field3 (우편번호) — String
  • Field (상세주소) — String
  • Field

CATEGORY (Category)

  • 카테고리ID (category_id) — Long — Primary key — NOT NULL
  • Field (이름) — String
  • Field2 (상품) — List
  • Field3 (부모) — Category
  • Field (자식) — L:ist
  • Field

Category_item (Untitled7)

  • 카테고리ID (category_id) — Long — Foreign key → CATEGORY.카테고리ID — NOT NULL
  • 상품ID (item_id) — Long — Foreign key → Product.상품ID — NOT NULL

DELIVERY (Untitled4)

  • 주문ID (delivery_id) — Long — Primary key — NOT NULL
  • 주문 (order) — Order
  • 주소 (address) — Address
  • 상태 (status) — DeliveryStatus

MEMBER (Untitled2)

  • 회원ID (member_id) — Long — Primary key — NOT NULL
  • 이름 (name) — String
  • 주소 (address) — Address
  • 주문 (order) — List

ORDER (Untitled3)

  • 주문ID (orderID) — Long — Primary key — NOT NULL
  • 주문날짜 (orderDate) — Date
  • 주문상태 (status) — OrderStatus — ORDER(주문) CANCLE(취소)
  • 회원ID (member_id) — Long — Foreign key → MEMBER.회원ID — NOT NULL
  • 주문ID (delivery_id) — Long — Foreign key → DELIVERY.주문ID — NOT NULL

ORDER_ITEM (Untitled5)

  • Key (id) — Long — Primary key — NOT NULL
  • 회원ID (orderID) — Long — Foreign key → ORDER.주문ID — NOT NULL
  • 상품ID (item_id) — Long — Foreign key → Product.상품ID — NOT NULL
  • Field3 (가격) — Integer
  • Field (갯수) — Integer

Product (Untitled)

  • 상품ID (item_id) — Long — Primary key — NOT NULL
  • 상품명 (name) — String
  • 브랜드 (brand) — String
  • 가격 (price) — Long
  • 상세설명 (description) — String
  • 활성화 (isActive) — boolean
  • 상품이미지 (imageLink) — List<String>
  • 카테고리 (categories) — String
  • 친환경 (isEcoFriendly) — boolean
  • 탄소배출량 (carbonEmission) — Integer
  • 재고수량 (stockQuantity) — Integer