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