mirror of
https://github.com/multica-ai/multica.git
synced 2026-06-17 11:48:42 +02:00
68e2a14ba2
Implements the Project concept as a higher-level grouping for issues. Hierarchy: workspace → project → issue → sub-issue. Backend: - Migration 034: project table + issue.project_id FK - sqlc queries for project CRUD - Project handler with list/get/create/update/delete - Issue handler updated to support project_id in create/update - Routes at /api/projects, WebSocket event constants Frontend (new monorepo structure): - @multica/core: Project types, API client methods, queries/mutations, status config, realtime sync - @multica/views: Projects list page, detail page (overview + issues tabs), project picker for issue detail panel - apps/web: Route pages, sidebar navigation entry All TypeScript type checks and tests pass.
21 lines
775 B
SQL
21 lines
775 B
SQL
-- Project table
|
|
CREATE TABLE project (
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
workspace_id UUID NOT NULL REFERENCES workspace(id) ON DELETE CASCADE,
|
|
title TEXT NOT NULL,
|
|
description TEXT,
|
|
icon TEXT,
|
|
status TEXT NOT NULL DEFAULT 'planned'
|
|
CHECK (status IN ('planned', 'in_progress', 'paused', 'completed', 'cancelled')),
|
|
lead_type TEXT CHECK (lead_type IN ('member', 'agent')),
|
|
lead_id UUID,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
|
|
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
|
|
);
|
|
|
|
CREATE INDEX idx_project_workspace ON project(workspace_id);
|
|
|
|
-- Add project_id to issue
|
|
ALTER TABLE issue ADD COLUMN project_id UUID REFERENCES project(id) ON DELETE SET NULL;
|
|
CREATE INDEX idx_issue_project ON issue(project_id);
|