DDIP_수정
테이블 (6)
USER (user)
- Key (user_id) — int — 기본 키 — NOT NULL
- Field (password) — string — NOT NULL
- Field (name) — string — NOT NULL
- Field (email) — string — NOT NULL
- Field (tel) — string — NOT NULL
- Field (certification) — ENUM — NOT NULL
- Field (gender) — ENUM — NOT NULL
- Field (address) — string
- Field (createdAt) — date — NOT NULL
- Field (updatedAt) — date — NOT NULL
Untitled (market)
- Key (market_id) — int — 기본 키 — NOT NULL
- Field (login_id) — string — NOT NULL
- Field (password) — string — NOT NULL
- Field (name) — string — NOT NULL
- Field (tel_market) — string — NOT NULL
- Field (location) — string — NOT NULL
- Field (createdAt) — date — NOT NULL
- Field (updatedAt) — date — NOT NULL
Untitled (product)
- Key (product_id) — int — 기본 키 — NOT NULL
- Key (market_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — string — NOT NULL
- Field (manufacturer) — string — NOT NULL
- Field (category) — ENUM — NOT NULL
- Field (image) — json — NOT NULL
- Field (price) — string — NOT NULL
- Field (total_quantity) — int — NOT NULL
- Field (description) — string — NOT NULL
- Field (createdAt) — date — NOT NULL
- Field (updatedAt) — date — NOT NULL
Untitled (ddip_list)
- Key (ddip_list_id) — int — 기본 키 — NOT NULL
- Key (user_id) — int — 외래 키 → USER.Key — NOT NULL
- Key (ddip_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (quantity) — int — NOT NULL
- Field (payment) — int — NOT NULL
- Field (pay_successed) — bool — NOT NULL
- Field (pay_date) — date — NOT NULL
- Field (QR_verified) — bool — NOT NULL
- Field (createdAt) — data — NOT NULL
- Field (updatedAt) — data — NOT NULL
Untitled (location)
- Key (location_id) — int — 기본 키 — NOT NULL
- Key (user_id) — int — 외래 키 → USER.Key — NOT NULL
- Field (location) — string — NOT NULL
- Field (createdAt) — date — NOT NULL
- Field (updatedAt) — date — NOT NULL
- Field (latitude) — float — NOT NULL
- Field2 (longitude) — float — NOT NULL
Untitled (ddip)
- Key (ddip_id) — int — 기본 키 — NOT NULL
- Key (product_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (status) — ENUM — NOT NULL