Planner - 피드백 반영
테이블 (5)
category
- category_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- color — VARCHAR(20)
- sort_order — INT — NOT NULL
- is_default — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
task
- task_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- category_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- priority — ENUM('HIGH','MEDIUM','LOW') — NOT NULL
- is_starred — TINYINT(1) — NOT NULL
- deadline — DATE
- estimated_time — INT
- status — ENUM('TODO','IN_PROGRESS','DONE') — NOT NULL
- repeat_type — ENUM('NONE','DAILY','WEEKLY','MONTHLY') — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user
- user_id — BIGINT — 기본 키 — NOT NULL
- social_provider — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- recommended_daily_time — INT
x1
- id — BIGINT — 기본 키 — NOT NULL
x2
- id — BIGINT — 기본 키 — NOT NULL