umc-chapter1
Tables (8)
Untitled (user)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(10) — NOT NULL
- Field2 (gender) — ENUM('MAN', 'WOMAN') — NOT NULL
- Field3 (birth) — DATE — NOT NULL
- Field4 (address) — VARCHAR(100) — NOT NULL
- Field (point) — INT — NOT NULL
- Field5 (created_at) — DATETIME(6) — NOT NULL
- Field6 (updated_at) — DATETIME(6)
Untitled (category)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (name) — VARCHAR(10) — NOT NULL
Untitled (store)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(20) — NOT NULL
- Field (address) — VARCHAR(100) — NOT NULL
- Field (image_url) — VARCHAR(100)
Untitled (mission)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (cost) — INT — NOT NULL
- Field (point) — INT — NOT NULL
- Field (expire_date) — DATETIME — NOT NULL
Untitled (favorite_category)
- Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (accepted_mission)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (mission_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (status) — ENUM('PENDING', 'COMPLETE') — NOT NULL
Untitled (review)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (content) — VARCHAR(500) — NOT NULL
- Field (rating) — VARCHAR(5) — NOT NULL
Untitled (review_image)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (review_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — VARCHAR(100) — NOT NULL