8th-mission1
Tables (8)
Food
- Key (food_id) — int — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(10)
- Field (content) — text
Member
- Key (user_id) — bigint — Primary key — NOT NULL
- 이름 (name) — Varchar(10) — NOT NULL
- 성별 (gender) — Varchar(15)
- 생년월일 (birth) — datetime(6)
- 주소 (address) — text
- Field (points) — int
- Field (status) — varchar(10)
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
MemberFood
- Key (mf_id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Member.Key — NOT NULL
- Key (food_id) — int — Foreign key → Food.Key — NOT NULL
Untitled (Mission)
- Key (mission_id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (dday) — datetime(6)
- Field (price) — int
- Field (points) — int
- Field (content) — text
Untitled (Store)
- Key (store_id) — bigint — Primary key — NOT NULL
- Field (region) — varchar(20)
- Field (name) — varchar(20)
- Field (category) — varchar
- Field (status) — varchar(10)
Untitled (MemberMission)
- Key (mm_id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Member.Key — NOT NULL
- Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (attempt_time) — datetime(6)
- Field (status) — varchar(10)
Untitled (Review)
- Key (review_id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — bigint — Foreign key → Member.Key — NOT NULL
- Field (ratings) — float
- Field (contents) — text
Untitled (Alarm)
- Key (alarm_id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Member.Key — NOT NULL
- Field (is_checked) — boolean
- Field (content) — text
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (type) — varchar(10)