조직 과제 MPF
테이블 (3)
organization_task (조직 과제)
- id — uuid — 기본 키 — NOT NULL
- parent_id — uuid — 외래 키 → organization_task.id
- tenant_id — uuid — NOT NULL
- title — varchar(200) — NOT NULL
- owner_type — varchar(20) — NOT NULL
- owner_id — uuid — NOT NULL
- organization_id — uuid — NOT NULL
- requester_id — uuid — NOT NULL
- status — varchar(20) — NOT NULL
- period_start — date — NOT NULL
- period_end — date — NOT NULL
- expected_state — text
- visibility — varchar(16) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- completed_at — timestamp
- status_changed_at — timestamp
- deleted_at — timestamp
- description — jsonb
개인 레포트 (Untitled2)
- Key — 기본 키 — NOT NULL
- Field
계획/실행/회고 (Untitled)
- Key — 기본 키 — NOT NULL
- id (조직id) — uuid — 외래 키 → organization_task.id — NOT NULL