조직 과제 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