3번용
테이블 (4)
Untitled (store)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (region_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — varchar(50)
- Field2 (address) — varchar(50)
- Field3 (score) — float
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
Untitled (reigion)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(20)
- Field2 (created_at) — datetime(6)
- Field3 (updated_at) — datetime(6)
Untitled (member_mission)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (mission_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (status) — varchar(15)
- Field2 (created_at) — datetime(6)
- Field3 (updated_at) — datetime(6)
Untitled (mission)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (store_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (reward) — int
- Field2 (deadline) — datetime
- Field (mission_spec) — text
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)