Total Tasks
5
In Progress
1
Completed
1
Sprint Velocity
20%
Active Sprint: Sprint 1 - Foundation & PostgreSQL
Backlog
To Do
In Progress
In Review
Done
Status Breakdown (PostgreSQL Group By)
Live Audit & Activity Logs
PostgreSQL Enterprise Schema Overview
Relational DDL with Foreign Keys, Cascades, Indexes & Views
Core Tables
- •
users(UUID, RBAC, Auth) - •
workspaces(Organizations) - •
workspace_members(Roles) - •
projects(Unique Key & Lead) - •
sprints(Date range & Status) - •
tasks(Order, Hours, Points)
Relations & Logs
- •
labels&task_labels(M:N) - •
comments(Task Discussions) - •
time_logs(Granular tracking) - •
activity_logs(Audit Stream)
PostgreSQL Features
- • Native PostgreSQL Enums
- • Composite B-Tree Indexes
- • PL/pgSQL Timestamp Triggers
- • Analytical Summary Views (
vw_project_summary)