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