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