{
"id": "d1e2f3a4-b5c6-7890-1234-567890abcdef",
"title": "SQL injection in /api/v1/checkout",
"category": "injection",
"severity": "critical",
"state": "open",
"description": "...",
"affected_file": "apps/api/src/checkout/checkout.service.ts",
"affected_code": "...",
"proof_of_concept": "...",
"impact": "...",
"root_cause": "...",
"remediation": "...",
"tags": ["injection", "sql"],
"scan_id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"found_at": "2026-04-13T12:15:00.000Z",
"updated_at": "2026-04-13T12:20:00.000Z",
"triage_thread": [
{
"id": "c0ffee01-feed-4bad-badc-0ffee0000001",
"reaction": null,
"comment": "Confirmed reproducible on staging — cart_id=1' OR '1'='1 returns 200 with full row dump.",
"user_id": "e5a6d7c8-9b0a-1c2d-3e4f-5a6b7c8d9e0f",
"username": "alex",
"source": "api",
"timestamp": "2026-04-13T12:22:00.000Z"
}
],
"mermaid_trace": "graph TD\n A[Request] --> B[checkout.service.ts]\n B --> C[(Postgres)]",
"occurrence_count": 1,
"repo_url": "https://github.com/acme/backend",
"scan_type": "full"
}