당근마켓

테이블 (14)

active_areas (Untitled10)

  • area_id (Key) — 외래 키 → areas.id — NOT NULL
  • user_id (id) — 외래 키 → users.user_id — NOT NULL
  • activated (Field)
  • created_at (Field2)
  • updated_at (Field3)
  • Field4

areas (Untitled9)

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

chat_messages (Untitled8)

  • id — 기본 키 — NOT NULL
  • sender_id — 기본 키 — NOT NULL
  • chat_room_id — 외래 키 → chat_rooms.id — NOT NULL
  • content
  • read_or_not
  • created_at

chat_rooms (Untitled7)

  • id — 기본 키 — NOT NULL
  • seller_id — 외래 키 → products.product_id — NOT NULL
  • buyer_id — 외래 키 → users.user_id — NOT NULL
  • activated
  • created_at

follow_users (Untitled4)

  • follow_users_id — 기본 키 — NOT NULL
  • activated
  • created_at
  • updated_at

manner_evaluation (Untitled13)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (id) — 외래 키 → users.user_id — NOT NULL
  • score (Field)
  • created_at (Field2)

notification_keywords (Untitled12)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (id) — 외래 키 → users.user_id — NOT NULL
  • name (Field)
  • activated (Field2)
  • created_at (Field3)
  • updated_at (Field4)

notifications (Untitled11)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (id) — 외래 키 → users.user_id — NOT NULL
  • title (Field)
  • content (Field2)
  • type (Field3)
  • read_or_not (Field4)
  • created_at (Field5)

products (Untitled3)

  • product_id (seller_id) — 기본 키 — NOT NULL
  • user_id — 외래 키 → users.user_id — NOT NULL
  • title
  • price
  • content
  • status
  • view_count
  • created_at
  • updated_at
  • refreshed_at

products_categories (Untitled6)

  • name

products_images (Untitled5)

  • seller_id — 외래 키 → products.product_id — NOT NULL
  • image_url

reviews (Untitled14)

  • id (Key) — 기본 키 — NOT NULL
  • buyer_id (Field)
  • content (Field2)
  • created_at (Field3)

users (Users)

  • user_id — string — 기본 키 — NOT NULL
  • phone_number
  • nickname
  • manner_rate
  • activated
  • created_at
  • updated_at

users_images (Untitled2)

  • users_images_id — 외래 키 → users.user_id — NOT NULL
  • image_url