MVP
Tables (11)
Untitled (user)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(50)
- Field2 (gender) — varchar(1)
- Field3 (birth) — date
- Field4 (address) — varchar(50)
- Field5 (sns_email) — varchar(20)
- Field (status) — enum('noraml', 'withdrawn')
- Field2 (withdraw_at) — datetime(1)
- Field (signup_at) — datetime(6)
- Field (total_point) — int
- Field (phone_number) — int
Untitled (favorite_food)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (favorite_food) — enum
Untitled (mission)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (content) — varchar(100)
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- Field (expire_at) — datetime(6)
- Field (point) — int
Untitled (store)
- Key (id) — bigint — Primary key — NOT NULL
- Key (favorite_food_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(50)
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- Field
Untitled (region)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(50)
Untitled (user_region_point)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (clear_count) — int
- Field (reward_received_count) — int
Untitled (user_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('completed', 'uncompleted')
- Field2 (completed_at) — datetime(6)
Untitled (review)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (rating) — float
- Field2 (comment) — text
- Field3 (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
Untitled (inquiry)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(100)
- Field2 (comment) — text
- Field3 (created_at) — datetime(6)
- Field (reply_at) — datetime(6)
Untitled (inquiry_reply)
- Key (id) — bigint — Primary key — NOT NULL
- Key (inquiry_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (reply) — comment
Untitled (review_reply)
- Key (id) — bigint — Primary key — NOT NULL
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (content) — text