당근마켓

테이블 (3)

User (user)

  • user_id — long — 기본 키 — NOT NULL
  • Field (user_name) — varchar
  • Field (phone_number) — varchar
  • Field (email) — varchar
  • Field (password) — varchar
  • Field (join_date) — varchar
  • Key (product_id) — long — 외래 키 → product.Key — NOT NULL
  • Key2 (seller_id) — long — 외래 키 → product.Key2 — NOT NULL

product

  • Key (product_id) — long — 기본 키 — NOT NULL
  • Key2 (seller_id) — long — 기본 키 — NOT NULL
  • Field (product_name) — varchar
  • Field (product_info) — varchar
  • Field (price) — long
  • Field (create_date) — datetime

transaction

  • Key (transaction_id) — long — 기본 키 — NOT NULL
  • user_id — long — 외래 키 → User.user_id — NOT NULL
  • Field (product_id) — long
  • Field (buyer_id) — long
  • Field (seller_id) — long
  • Field (transaction_date) — datetime
  • Field (transaction_amount) — long
  • Field (transaction_status) — char