umc_week1_미션
테이블 (8)
Untitled (app_mission)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (store_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (reward_point) — int
- Field (created_at) — datetime(6)
- Field (required_amount) — int
- Field (expiration_date) — datetime(6)
Untitled (app_mission_user)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (mission_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — bigint — 외래 키 → app_user.Key — NOT NULL
- Field (status) — varchar(15)
- Field (completion_date) — datetime(6)
- Field (is_reward_paid) — boolean
Untitled (app_region)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (region_name) — varchar(20)
Untitled (review)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (store_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — bigint — 외래 키 → app_user.Key — NOT NULL
- Field (rating) — decimal(2,1)
- Field (text_content) — text
- Field (created_at) — datetime(6)
- Field (image_url) — varchar(255)
Untitled (app_user_terms)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (user_id) — bigint — 외래 키 → app_user.Key — NOT NULL
- Key (terms_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (agreed_at) — datetime(6)
Untitled (app_store)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (region_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (store_name) — varchar(50)
- Field (address) — varchar(100)
- Field (latitude) — decimot(10,7)
- Field (longitude) — decimal(10,7)
- Field (contact_info) — varchar(20)
- Field (rating) — decimal(2,1)
- Field (review_count) — int
Untitled (app_terms)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (title) — varchar(30)
- Field (content) — text
- Field (version) — varchar(10)
- Field (is_mandatory) — boolean
app_user
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (user_name) — varchar(20)
- Field (gender) — varchar(10)
- Field (birthday) — char(10)
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (address) — varchar(100)
- Field (email) — varchar(50)
- Field (password) — varchar(100)
- Field (preferred_food_type) — varchar(50)
- Field (phone_number) — varchar(15)