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)