Skip to main content

Data Model

Core Entities​

Account​

Stored in accounts. Created by adm_account_research.

  • company_name, ticker, industry, engineering_headcount
  • tech_stack, ai_tools, leadership (CTO, CDO, etc.)
  • ai_philosophy, recent_blog_posts, source_urls

Health Score​

Stored in health_scores. One document per computation.

  • account_id, computed_at, score (0–100)
  • sub_scores: usage_rate, sentiment, engagement, support
  • risk_level, trend, recommendations

ROI Model​

Stored in roi_models. One per account per scenario.

  • account_id, scenario (conservative | base | aggressive)
  • seats, roi_multiple, payback_months
  • savings: productivity, bug_remediation, onboarding

Metrics Model​

Stored in metrics_models. One per account per phase per scenario.

  • account_id, phase, scenario
  • DORA projections: deployment_frequency, lead_time, mttr, change_failure_rate
  • cursor_improvement_ranges (from constants)

Deployment Plan​

Stored in deployment_plans. One per account.

  • account_id, phases (pilot, expansion, full)
  • Each phase: target_seats, success_criteria, champion_plan, risks

Relationships​

accounts (1) ──< health_scores
accounts (1) ──< roi_models
accounts (1) ──< metrics_models
accounts (1) ──  deployment_plans (1)
accounts (1) ──< adoption_reports
accounts (1) ──< escalations