중고거래 서비스

테이블 (5)

Category (category)

  • ID (id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR
  • Image (image) — BLOB

Item (item)

  • ID (id) — INT — 기본 키 — NOT NULL
  • Location ID (location_id) — INT — 외래 키 → Location.ID — NOT NULL
  • ID (category_id) — INT — 외래 키 → Category.ID — NOT NULL
  • ID (thumbnail_id) — INT — 외래 키 → Thumbnail.ID — NOT NULL
  • Title (name) — VARCHAR
  • Price (price) — INT
  • Description (description) — VARCHAR
  • Field — INT

Location (location)

  • ID (id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR

Thumbnail (thumbnail)

  • ID (id) — INT — 기본 키 — NOT NULL
  • Image (image) — BLOB

User (user)

  • ID (id) — INT — 기본 키 — NOT NULL
  • Location ID (location_id) — INT — 외래 키 → Location.ID — NOT NULL
  • User ID (user_id) — VARCHAR