Struct Project

internal/flowdb/db.go:131–140

(idx_tasks_session_id is a partial UNIQUE index that requires a dedupe pass against existing data — a flat CREATE UNIQUE INDEX would fail on any DB that has two tasks sharing a session_id. migrateTasksSessionIDUnique handles both the dedupe and the index creation as one idempotent step.) ----------

// Project mirrors the projects table.
type Project struct {
	Slug       string
	Name       string
	Status     string
	Priority   string
	WorkDir    string
	CreatedAt  string
	UpdatedAt  string
	ArchivedAt sql.NullString
}

// Task mirrors the tasks table. ProjectSlug is nullable for floating tasks.
type Task struct {