당근마켓
테이블 (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