Files
Julien Froidefond 7811453e02 feat(Notes): associate notes with tasks and enhance note management
- Added taskId field to Note model for associating notes with tasks.
- Updated API routes to handle taskId in note creation and updates.
- Enhanced NotesPageClient to manage task associations within notes.
- Integrated task selection in MarkdownEditor for better user experience.
- Updated NotesService to map task data correctly when retrieving notes.
2025-10-10 08:05:32 +02:00

7 lines
217 B
SQL

-- AlterTable
ALTER TABLE "Note" ADD COLUMN "taskId" TEXT;
-- AddForeignKey
ALTER TABLE "Note" ADD CONSTRAINT "Note_taskId_fkey" FOREIGN KEY ("taskId") REFERENCES "tasks"("id") ON DELETE SET NULL ON UPDATE CASCADE;