PlanHub

테이블 (3)

sub_task

  • id — bigint — 기본 키 — NOT NULL
  • task_id — bigint — 외래 키 → task.id — NOT NULL
  • item — varchar(200) — NOT NULL
  • check — varchar(8) — NOT NULL
  • sort — int — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — datetime — NOT NULL
  • updated_by — bigint — NOT NULL

task

  • id — bingint — 기본 키 — NOT NULL
  • user_id — bingint — 외래 키 → 회원.id — NOT NULL
  • upper_id — bingint — 외래 키 → task.id — NOT NULL
  • title — varchar(200) — NOT NULL
  • count — int — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — bigint — NOT NULL
  • updated_at — datetime — NOT NULL
  • updated_by — bigint — NOT NULL

회원 (users)

  • id — bigint — 기본 키 — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • expired_at — datetime — NOT NULL