중고거래 서비스
테이블 (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