1주차
테이블 (17)
Untitled (user_region_mission)
- Key (user_id) — int — 외래 키 → user.Key — NOT NULL
- Key (mission_id) — int — 외래 키 → mission.Key — NOT NULL
- Key (region_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (mission_count) — int
- Field (reward_point) — int
Untitled (user_mission)
- Field (complete) — boolean
- Field (complete_date) — datetime
- Key (mission_id) — int — 외래 키 → mission.Key — NOT NULL
- Key (user_id) — int — 외래 키 → user.Key — NOT NULL
Untitled (region)
- Key (id) — int — 기본 키 — NOT NULL
- Field (name) — varchar(30)
Untitled (alarm_inquire_reply)
- Key (id) — int — 기본 키 — NOT NULL
- Field (title) — text
- Field (body) — text
- Key (alarm_id) — int — 외래 키 → alarm.Key — NOT NULL
- Field (created_at) — datetime(6)
Untitled (alarm_review_reply)
- Key (id) — int — 기본 키 — NOT NULL
- Field (title) — text
- Field (body) — text
- Key (alarm_id) — int — 외래 키 → alarm.Key — NOT NULL
- Field (created_at) — datetime(6)
Untitled (new_event)
- Key (id) — int — 기본 키 — NOT NULL
- Field (title) — text
- Field (body) — title
- Key (alarm_id) — int — 외래 키 → alarm.Key — NOT NULL
- Field (created_at) — datetime(6)
alarm
- Key (id) — int — 기본 키 — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (is_confirmed) — boolean
- Key (user_id) — int — 외래 키 → user.Key — NOT NULL
food_type
- Key (id) — int — 기본 키 — NOT NULL
- Field (type) — varchar(20)
inquire
- Key (id) — int — 기본 키 — NOT NULL
- Field (title) — varchar(20)
- Field (text) — text
- Field (image) — text
- Field (created_at) — datetime(6)
- Field (status) — varchar(10)
- Key (user_id) — int — 외래 키 → user.Key — NOT NULL
inquire_reply
- Key (id) — int — 기본 키 — NOT NULL
- Field (text) — text
- Field (updated_at) — datetime(6)
- Field (created_at) — datetime(6)
- Key (inquire_id) — int — 외래 키 → inquire.Key — NOT NULL
mission
- Key (id) — int — 기본 키 — NOT NULL
- Field (detail) — text
- Field (deadline) — datetime
- Field (store_type) — varchar(20)
- Field (min_price) — int
- Field (certification_num) — int
- Field (reward_point) — int
- Key (store_id) — int — 외래 키 → store.Key — NOT NULL
- Key (region_id) — int — 외래 키 → Untitled.Key — NOT NULL
review
- Key (id) — int — 기본 키 — NOT NULL
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (text) — text
- Field (image) — text
- Field (rating) — int
- Key (store_id) — int — 외래 키 → store.Key — NOT NULL
- Key (user_id) — int — 외래 키 → user.Key — NOT NULL
review_img
- Key (id) — int — 기본 키 — NOT NULL
- Field (ing_url) — text
- Key (review_id) — int — 외래 키 → review.Key — NOT NULL
review_reply
- Key (id) — int — 기본 키 — NOT NULL
- Field (user_id) — int
- Field (test) — text
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Key (review_id) — int — 외래 키 → review.Key — NOT NULL
store
- Key (id) — int — 기본 키 — NOT NULL
- Field (name) — varchar
- Field (address) — text
- Field (store_status) — varchar(10)
- Field (food_type) — varchar(20)
- Field (rating_avg) — float
user
- Key (id) — int — 기본 키 — NOT NULL
- Field (name) — varchar(20)
- Field2 (gender) — varchar(10)
- Field3 (email) — text
- Field4 (phone_num) — text
- Field5 (birth) — datetime(6)
- Field6 (address) — text
- Field (total_points) — int
user_food_type
- Key (id) — int — 기본 키 — NOT NULL
- Key (user_id) — int — 외래 키 → user.Key — NOT NULL
- Key (food_type_id) — int — 외래 키 → food_type.Key — NOT NULL