umc
Tables (12)
food category
- id — bigint — Primary key — NOT NULL
- category_name — varchar
inquiry
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- type — enum
- title — varchar
- content — text
- status — enum
- created_at — DATETIME
- updated_at — DATETIME
- reply — text
- replied_at — DATETIME
mission
- mission_id — bigint — Primary key — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- mission_title (title) — varchar
- mission_content — text
- reward_point (reward_ppint) — int
- end_date — DATETIME
- created_at — DATETIME
notification
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- message — text
- type — enum
- created_at — DATETIME
prefer_food
- id — bigint — Primary key — NOT NULL
- category_id — bigint — Foreign key → food category.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
region
- id — bigint — Primary key — NOT NULL
- region_code — varchar
- name — varchar
- city — varchar
- district — varchar
- neighborhood — varchar
- latitude — double
- longitude — double
- Field
review
- id — bigint — Primary key — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- id (id2) — bigint — Foreign key → store.region_id — NOT NULL
- score — float
- review_content — text
- image_url — text
- created_at — DATETIME
- updated_at — DATETIME
store
- id — bigint — Primary key — NOT NULL
- region_id — bigint — Foreign key → region.id — NOT NULL
- store_name — varchar
- address — varchar
- average_rate (averate_rate) — float
- category_id — bigint
user (User)
- id — bigint — Primary key — NOT NULL
- name — varchar
- birth — DATE
- gender — Enum
- address — varchar
- email — varchar
- point — int
- mission_completed — int
- status — enum
- updated_at — DATETIME
- created_at — DATETIME
- phone_number — varchar
- is_phone_varified (Field) — boolean
user mission
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- mission_id — bigint — Foreign key → mission.mission_id — NOT NULL
- status — enum
- created_at — DATETIME
- updated_at — DATETIME
user notification
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- event_status — enum
- review_status — enum
- inquiry_status — enum
- created_at — DATETIME
- updated_at — DATETIME
user point transaction
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- mission_id — bigint — Foreign key → mission.mission_id — NOT NULL
- type — enum
- amount — int
- related_mission_id — bigint
- created_at — DATETIME
- updated_at — DATETIME