찜 상품 erd

테이블 (4)

Basket

  • id (Primary_key) — Long — 기본 키 — NOT NULL
  • user_id (foreign_key) — Long — 외래 키 → USER.id — NOT NULL
  • product_id (foreign_key2) — Long — 외래 키 → Product.id — NOT NULL
  • liked (Field) — Boolean

Product

  • id (Primary_key) — Long — 기본 키 — NOT NULL
  • sku (Field) — String
  • name (Field2) — String
  • price (Field3) — BigDecimal
  • quantity (Field4) — Integer
  • createdAt (Field5) — LocalDateTime
  • updatedAt (Field6) — LocalDateTime
  • deletedAt (Field7) — LocalDateTime

ProductInfo

  • id (Primary_key) — Long — 기본 키 — NOT NULL
  • user_id (Foreign_key) — Long — 외래 키 → USER.id — NOT NULL
  • product_id (Foreign_key2) — Long — 외래 키 → Product.id — NOT NULL
  • totalLiked (Field) — Integer
  • viewed (Field2) — Integer

USER

  • id (Primary_key) — Long — 기본 키 — NOT NULL
  • email (Field) — String
  • name (Field2) — String
  • createdAt (Field3) — LocalDateTime
  • deletedAt (Field4) — LocalDateTime