shopping

Tables (9)

Cart (Untitled3)

  • user_id (유저 uuid) — UUID — Foreign key → User.Id — NOT NULL
  • product_id (상품 id) — long — Foreign key → Product.Id — NOT NULL
  • quantity (수량) — itn

Cupon (Untitled6)

  • Id (id) — long — Primary key — NOT NULL
  • code (코드) — UUID
  • name (이름) — String
  • discount (할인율) — int
  • type (종류) — enum
  • max_discount (한도) — int
  • status (상태) — enum
  • create_at (생성일자) — TimeStamp
  • modified_at (수정일자) — TimeStamp

Delivery (Untitled4)

  • Id (uuid) — UUID — Primary key — NOT NULL
  • user_id (유저 uuid) — UUID — Foreign key → User.Id — NOT NULL
  • status (배송 상태) — Enum
  • order_date (주문 날짜) — Date
  • modified_at (수정 날짜) — TimeStamp
  • products (상품) — List<Object>
  • total_price (총 가격) — int
  • discount_rate (할인율) — int
  • cupon (쿠폰) — List<Object>

Order_Product (Untitled5)

  • delivery_id (uuid) — UUID — Foreign key → Delivery.Id — NOT NULL
  • product_id (상품 id) — long — Foreign key → Product.Id — NOT NULL
  • price (가격) — int
  • quantity (수량) — int

Product (Untitled)

  • Id (Key) — long — Primary key — NOT NULL
  • name (제품명) — String
  • price (가격) — int
  • product_info (제품 정보) — String
  • discount_rate (할인율) — int
  • shipping_info (배송정보) — String
  • storage_method (보관 방법) — String
  • expiration_date (소비기한) — String
  • details (제품 상세) — String
  • files (파일 경로) — String
  • create_at (생성일자) — TimeStamp
  • modified_at (수정일자) — TimeStamp
  • deleted_at (삭제일자) — TimeStamp

Quantity (Untitled2)

  • Id (상품 id) — long — Foreign key → Product.Id — NOT NULL
  • quantity (수량) — int

Review (Untitled8)

  • Id (Key) — long — Primary key — NOT NULL
  • user_id (유저 uuid) — UUID — Foreign key → User.Id — NOT NULL
  • product_id (상품 id) — long — Foreign key → Product.Id — NOT NULL
  • files (파일 경로) — String
  • content (내용) — String

User (user)

  • Id (uuid) — UUID — Primary key — NOT NULL
  • user_id (유저 아이디) — String
  • password (비밀번호) — String
  • nickname (닉네임) — String
  • role (역할) — Enum
  • cupons (쿠폰) — List<Object>
  • created_at (생성일자) — TimeStamp
  • modified_at (수정일자) — TimeStamp
  • deleted_at (삭제일자) — TimeStamp

User_Cupon (Untitled7)

  • Id (Key) — long — Primary key — NOT NULL
  • user_id (유저 uuid) — UUID — Foreign key → User.Id — NOT NULL
  • cupon_id (id) — long — Foreign key → Cupon.Id — NOT NULL
  • delivery_id (배송 uuid) — UUID — Foreign key → Delivery.Id — NOT NULL
  • quantity (수량) — int
  • staus (상태) — enum
  • created_at (생성일자) — TimeStamp
  • modified_at (수정일자) — TimeStamp