EPIC-03: Work Items - Core CRUD & Properties

[steilerDev]

Epic: Work Items - Core CRUD & Properties

Epic ID: EPIC-03
Priority: Must Have
Sprint Suggestion: Sprint 2

Description

Implement the core work item management system, which is the central entity of the application. This covers creating, reading, updating, and deleting work items with all their core properties: identification, status tracking, scheduling (dates, duration, constraints), tags, notes, and subtasks/checklists. This epic focuses on the data model and CRUD operations; budget linkage is in EPIC-05, dependency/timeline features are in EPIC-06, and document links are in EPIC-08.

Requirements Coverage

• Section 2.1: Work Items Management - Core Properties
  • Unique ID, title, description
  • Status: Not Started, In Progress, Completed, Blocked
  • Scheduling: Start date, end date, duration (calculated or manual)
  • "Start after" date (earliest possible start constraint)
  • "Start before" date (latest possible start constraint)
  • Tags: Custom labels for organization
  • Timestamps: Created at, updated at
• Section 2.1: Additional Features
  • Notes
  • Subtasks/checklist items
• Section 2.1: Core Properties - Dependencies (data model only)
  • Predecessor/successor relationships (data model; visualization is in EPIC-06)
• Section 4: User Stories - Work Items
  • Create work items with start/end dates to plan construction timeline
  • See "start after" and "start before" constraints for vendor/weather constraints
  • Assign work items to any registered user
• Section 3.4: Usability
  • Keyboard shortcuts for power users (work item management context)

Dependencies

• EPIC-01: Authentication & User Management (need users for assignment and access control)
• EPIC-02: Application Shell & Infrastructure (need database and app shell)

Stories

• 3.1: Work Items Database Schema & Migration #87 — 3.1: Work Items Database Schema & Migration [Must Have]
• 3.2: Work Items CRUD API #88 — 3.2: Work Items CRUD API [Must Have] — depends on 3.1: Work Items Database Schema & Migration #87
• 3.3: Tag Management API & UI #89 — 3.3: Tag Management API & UI [Must Have] — depends on 3.1: Work Items Database Schema & Migration #87
• 3.4: Work Item Notes & Subtasks API #90 — 3.4: Work Item Notes & Subtasks API [Must Have] — depends on 3.2: Work Items CRUD API #88
• 3.5: Work Items List Page #91 — 3.5: Work Items List Page [Must Have] — depends on 3.2: Work Items CRUD API #88, 3.3: Tag Management API & UI #89
• 3.6: Work Item Detail & Edit Page #92 — 3.6: Work Item Detail & Edit Page [Must Have] — depends on 3.4: Work Item Notes & Subtasks API #90, 3.5: Work Items List Page #91
• 3.7: Work Item Dependencies API & UI #93 — 3.7: Work Item Dependencies API & UI [Must Have] — depends on 3.2: Work Items CRUD API #88
• 3.8: Keyboard Shortcuts for Work Items #94 — 3.8: Keyboard Shortcuts for Work Items [Should Have] — depends on 3.5: Work Items List Page #91, 3.6: Work Item Detail & Edit Page #92

Implementation Order

#87 (Schema) ──┬──> #88 (CRUD API) ──┬──> #90 (Notes/Subtasks) ──┐
               │                      │                            │
               │                      ├──> #93 (Dependencies) ────┤
               │                      │                            │
               └──> #89 (Tags) ──────┘                            │
                                      │                            │
                                      └──> #91 (List Page) ───────┤
                                                                   │
                                                              #92 (Detail Page)
                                                                   │
                                                              #94 (Keyboard Shortcuts)

Goals

• Full CRUD for work items (create, read, update, delete)
• All core properties editable: title, description, status, dates, duration, constraints
• Tag management (create, assign, remove custom tags)
• Notes per work item (add, edit, delete)
• Subtasks/checklist items per work item
• Work item assignment to registered users
• Dependency management (predecessor/successor with cycle detection)
• List view of work items with filtering, sorting, search, and pagination
• Detail/edit view with inline editing
• Keyboard shortcuts for common work item operations