ㄴㅇㄹ
Tables (5)
mission_assigned
- id — INT — NOT NULL
- mission_default_id — INT — NOT NULL
- Field — INT — NOT NULL
- Field2 — DATE — NOT NULL — 미션이 할당된 날짜 (예: '2025-07-08')
- Field3 — mission_status — NOT NULL — started, completed, skipped
- Field4 — DATETIME — NOT NULL
- id2 — INT — NOT NULL — NOT NULL
- id3 — INT — NOT NULL
mission_clover
- id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — VARCHAR(100) — NOT NULL
- category — Category — NOT NULL
- difficulty — Difficulty — NOT NULL
mission_my
- id — INT — NOT NULL
- user_id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- alarm_time — TIME — 알림이 없으면 NULL
- repeat_days — JSON — NOT NULL — '"MON
- id2 — INT — NOT NULL — NOT NULL
mission_my_record
- id — INT — NOT NULL
- my_mission_id — INT
- target_date — DATE
- status — ENUM — 'pending', 'completed
- skipped, — `id2` — NOT NULL
users
- id — INT — NOT NULL — NOT NULL
- email — INT