koreanfood
Tables (12)
food_category
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
mission
- id — BIGINT — Primary key — NOT NULL
- store_id — BIGINT — Foreign key → store.id — NOT NULL
- region_id — BIGINT — Foreign key → region.id — NOT NULL
- detail — TEXT
- min_order_amount — INT — NOT NULL
- reward_type — VARCHAR(10) — NOT NULL
- reward — INT
- reward_rate — DECIMAL(5,2)
- deadline — DATETIME
- status — VARCHAR(10) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
region
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
review
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- store_id — BIGINT — Foreign key → store.id — NOT NULL
- user_mission_id — BIGINT — Foreign key → user_mission.id
- score — DECIMAL(2,1) — NOT NULL
- detail — TEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
review_image
- id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → review.id — NOT NULL
- image_url — TEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
store
- id — BIGINT — Primary key — NOT NULL
- region_id — BIGINT — Foreign key → region.id — NOT NULL
- category_id — BIGINT — Foreign key → food_category.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- address — VARCHAR(50)
- score — DECIMAL(2,1) — NOT NULL
- review_count — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
terms
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- body — TEXT
- is_required — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- region_id — BIGINT — Foreign key → region.id
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- birth_date — DATE
- phone — VARCHAR(20)
- phone_verified_at — DATETIME(6)
- address — VARCHAR(50)
- address_detailed — VARCHAR(50)
- point — INT — NOT NULL
- status — VARCHAR(10) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- inactive_at — DATETIME(6)
user_agree
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- terms_id — BIGINT — Foreign key → terms.id — NOT NULL
- is_agreed — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
user_mission
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- mission_id — BIGINT — Foreign key → mission.id — NOT NULL
- status — VARCHAR(15) — NOT NULL
- started_at — DATETIME(6) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- completed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
user_prefer
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- category_id — BIGINT — Foreign key → food_category.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
user_region_progress
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- region_id — BIGINT — Foreign key → region.id — NOT NULL
- success_count — INT — NOT NULL
- bonus_count — INT — NOT NULL
- updated_at — DATETIME(6) — NOT NULL