Backlog
2
Implement SSE endpoint
Design notification system
In Progress
2
File upload service
Activity feed component
Review
2
User authentication
Database migration scripts
Done
2
Project setup & config
Database schema design
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