찜 상품 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