당근마켓 erd

테이블 (6)

Category (category)

  • category_id (PK) — bigint — 기본 키 — NOT NULL
  • item_id (FK) — bigint — 기본 키
  • category_id (FK2) — varchar(20) — 기본 키
  • name (Field) — varchar(30)
  • price (Field2) — bigint
  • item_id (PK2) — bigint — 외래 키 → Item.item_id — NOT NULL
  • item_id (PK3) — bigint — 외래 키 → Item.item_id — NOT NULL
  • category (FK23) — bigint — 외래 키 → Item.category
  • Chat_id (PK4) — bigint — 외래 키 → Item.Chat_id — NOT NULL

Chat (chats)

  • Chat_id (PK) — bigint — 기본 키 — NOT NULL
  • item (FK) — bigint
  • sender (FK2) — bigint
  • receiver (Fk3) — bigint
  • content (Field) — text
  • timestamp (Field2) — timestamp
  • last_message (Field3) — one to on
  • user_id (PK2) — bigint — 외래 키 → User.user_id — NOT NULL
  • trans_id (PK22) — bigint — 외래 키 → User.trans_id — NOT NULL

Image (images)

  • image_id (PK) — bigint — 기본 키 — NOT NULL
  • item_id (FK) — bigint
  • images (Field) — imagefield
  • item_id (PK2) — bigint — 외래 키 → Item.item_id — NOT NULL
  • Chat_id (PK4) — bigint — 외래 키 → Item.Chat_id — NOT NULL

Item (items)

  • item_id (PK) — bigint — 기본 키 — NOT NULL
  • Chat_id (PK4) — bigint — 외래 키 → Chat.Chat_id — NOT NULL
  • seller_name (FK) — bigint
  • category (FK2) — bigint
  • upload_date (Field) — timestamp
  • title (Field2) — varchar(70)
  • content (Field3) — text
  • price (Field4) — bigint
  • hope_loc (Field5) — varchar(40)
  • views (Field6) — bigint
  • image_url (Field7) — varchar(200)
  • chat_count (Field8) — bigint
  • is_end (Field9) — boolean
  • user_id (PK2) — bigint — 외래 키 → User.user_id — NOT NULL
  • trans_id (PK3) — bigint — 외래 키 → Transaction.trans_id — NOT NULL
  • trans_id (PK22) — bigint — 외래 키 → User.trans_id — NOT NULL

Transaction (transactions)

  • trans_id (PK) — bigint — 기본 키 — NOT NULL
  • buyer_name (FK) — bigint
  • item_id (FK2) — bigint

User (users)

  • user_id (PK) — bigint — 기본 키 — NOT NULL
  • trans_id (PK2) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • password (Field2) — varchar(20)
  • region (Field3) — varchar(30)
  • trans_id (PK3) — bigint — 외래 키 → Transaction.trans_id — NOT NULL