Scenario Preview · 8 tasks, 5 tables, SSE + uploads
Nightmare
Realtime Kanban Live
alice@team
A
Server-Sent Events File Attachments Activity Log 5 Tables User Auth Real-time Sync Drag & Drop 8 Tasks
Backlog 2
Implement SSE endpoint
Critical Backend
Design notification system
High Fullstack
In Progress 2
File upload service
High Backend
Activity feed component
Medium Frontend
Review 2
User authentication
Critical Fullstack
Database migration scripts
High Backend
Done 2
Project setup & config
High DevOps
Database schema design
Critical Backend
Database Schema (5 tables)
users
  • id PK
  • username
  • password_hash
  • created_at
projects
  • id PK
  • name
  • owner_id FK
  • created_at
tasks
  • id PK
  • title
  • description
  • status
  • priority
  • assignee_id FK
  • project_id FK
  • due_date
attachments
  • id PK
  • task_id FK
  • filename
  • filepath
  • uploaded_by FK
  • created_at
activity_log
  • id PK
  • project_id FK
  • user_id FK
  • action
  • target
  • created_at