Issue Tracker

Build a Linear-style issue tracker: ## Database Schema model Issue { id String @id @default(cuid()) identifier String @unique // e.g., "ENG-123" title String description String? // Markdown/JSON for rich text status String // backlog, todo, in_progress, done, canceled priority Int // 0=none, 1=urgent, 2=high, 3=medium, 4=low projectId String project Project @relation(fields: [projectId], references: [id]) assigneeId String? assignee User? @relation("Assignee", fields: [assigneeId], references: [id]) creatorId String creator User @relation("Creator", fields: [creatorId], references: [id]) parentId String? parent Issue? @relation("Subtasks", fields: [parentId], references: [id]) subtasks Issue[] @relation("Subtasks") labels Label[] comments Comment[] estimate Int? // Story points or hours dueDate DateTime? sortOrder Float // For manual ordering within status createdAt DateTime @default(now()) updatedAt DateTime @updatedAt completedAt DateTime? @@index([projectId, status]) @@index([assigneeId]) @@index([status, sortOrder]) } model Project { id String @id @default(cuid()) name String key String @unique // e.g., "ENG" description String? teamId String team Team @relation(fields: [teamId], references: [id]) issues Issue[] issueCount Int @default(0) // For identifier generation createdAt DateTime @default(now()) } model Comment { id String @id @default(cuid()) body String issueId String issue Issue @relation(fields: [issueId], references: [id]) authorId String author User @relation(fields: [authorId], references: [id]) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt } model Label { id String @id @default(cuid()) name String color String issues Issue[] } ## Core Features ### Issue List View - Infinite scroll with virtualization (react-window) - Filterable by status, assignee, label, priority, project - Sortable by created, updated, priority - Inline editing of title, status, assignee, priority - Multi-select with bulk actions ### Board View - Kanban columns by status - Drag-and-drop between columns (dnd-kit) - Swimlanes by assignee or priority (optional) - WIP limits per column (visual indicator) - Quick create in any column ### Issue Detail - Full-width drawer (not modal—keeps context) - Rich text editor with markdown shortcuts - Activity feed (comments + changes) - Subtasks list with progress - Keyboard navigation (j/k for prev/next) ### Command Palette (Cmd+K) - Create issue - Search issues (fuzzy match) - Jump to project/view - Change status/assignee/priority - Quick filters ### Keyboard Shortcuts - c: Create issue - /: Search - g then b: Go to board - g then l: Go to list - Arrows: Navigate - Enter: Open issue - Esc: Close/back ## Optimistic Updates All mutations should update UI immediately: 1. Apply change to local state 2. Send to server 3. If error, rollback with toast Use Tanstack Query mutations with optimistic updates.