44 lines
1.6 KiB
Markdown
44 lines
1.6 KiB
Markdown
# Future Evolution: Strategic + Tactical Web Management
|
|
|
|
## Phase 3: Strategic Planning Collections
|
|
|
|
```sql
|
|
-- Future collections for web-based BMad planning management
|
|
bmad_projects {
|
|
id: uuid (primary key)
|
|
name: string (required)
|
|
description: text
|
|
bmad_phase: enum ['planning', 'development', 'review', 'complete']
|
|
planning_documents: json (PRDs, architecture, research)
|
|
user_stories: relation (link to tactical tasks)
|
|
methodology_compliance: json (BMad workflow tracking)
|
|
strategic_metrics: json (high-level KPIs)
|
|
created_at: timestamp (auto)
|
|
}
|
|
|
|
planning_documents {
|
|
id: uuid (primary key)
|
|
title: string (required)
|
|
content: text (rich text/markdown)
|
|
document_type: enum ['prd', 'architecture', 'research', 'validation']
|
|
bmad_project: uuid (foreign key to bmad_projects.id)
|
|
version: integer (document versioning)
|
|
status: enum ['draft', 'review', 'approved', 'archived']
|
|
created_at: timestamp (auto)
|
|
}
|
|
```
|
|
|
|
## Enhanced Task Schema for Cross-Level Links
|
|
```sql
|
|
-- Enhanced tasks collection for strategic/tactical integration
|
|
tasks {
|
|
-- ... existing fields ...
|
|
strategic_level: enum ['epic', 'user_story', 'task', 'subtask']
|
|
bmad_project: uuid (foreign key to bmad_projects.id, nullable)
|
|
parent_user_story: uuid (foreign key to tasks.id, nullable)
|
|
strategic_importance: enum ['low', 'medium', 'high', 'critical']
|
|
-- ... rest of schema
|
|
}
|
|
```
|
|
|
|
This architecture provides a robust foundation for the Directus task management suite while maintaining seamless integration with existing systems and supporting future evolution to unified strategic and tactical web management. |