당근
테이블 (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)