당근

테이블 (10)

Device (Untitled8)

  • id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → Member.id — NOT NULL
  • device_token (Field)
  • device_type (Field2)

FavoriteProduct (Untitled3)

  • id (Key3) — 기본 키 — NOT NULL
  • member_id (Key) — bigint — 외래 키 → Member.id — NOT NULL
  • product_id (Key2) — bigint — 외래 키 → Product.id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)

Member (Members)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • nickname (Field)
  • oauth id (Field2)
  • provider (Field3)
  • email (Field4)
  • password (Field5)
  • location (Field6)
  • manner_temp (Field7)
  • is_deleted (Field8)
  • createdAt (Field9)
  • updatedAt (Field10)
  • profile_image (Field11)
  • phone_number (Field12)
  • role (Field13)

Notification (Untitled6)

  • id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → Member.id — NOT NULL
  • notification_type (Field)
  • target_id (Field2)
  • is_read (Field3)

Product (products)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • seller_id (Key2) — bigint — 외래 키 → Member.id — NOT NULL
  • buyer_id (Key3) — bigint — 외래 키 → Member.id — NOT NULL
  • catetory_id (Key4) — 외래 키 → ProductCategory.id — NOT NULL
  • price (Field)
  • title (Field2)
  • description (Field3)
  • location (Field4)
  • state (Field5)
  • thumbnail_image (Field6)
  • view_count (Field7)
  • refresh_count (Field8)
  • created_at (Field9)
  • updated_at (Field10)
  • refresh_at (Field11)
  • like_count (Field12)

ProductCategory (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • created_at (Field2)
  • updated_at (Field3)

ProductImage (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • product_id (Key2) — bigint — 외래 키 → Product.id — NOT NULL
  • image_url (Field)
  • created_at (Field2)
  • updated_at (Field3)

manner (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → Member.id — NOT NULL
  • reviewer_id (Key3) — bigint — 외래 키 → Member.id — NOT NULL
  • score (Field)
  • created_at (Field2)
  • updated_at (Field3)

payment (Untitled7)

  • id (Key) — 기본 키 — NOT NULL
  • id (buyer_id) — bigint — 외래 키 → Member.id — NOT NULL
  • id (product_id) — bigint — 외래 키 → Product.id — NOT NULL

review (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • reviewer_id (Key2) — bigint — 외래 키 → Member.id — NOT NULL
  • reviewee_id (Key3) — bigint — 외래 키 → Member.id — NOT NULL
  • product_id (Key4) — bigint — 외래 키 → Product.id — NOT NULL
  • type (Field)
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)