{"spec_id":"idea-dual-identity","title":"Idea Dual Identity — UUID Primary Key + Structured Human Slug","summary":"Ideas currently use a single `id` field that serves two incompatible roles: machine primary","potential_value":0.0,"actual_value":1.0,"estimated_cost":0.0,"actual_cost":1.0,"value_gap":0.0,"cost_gap":1.0,"estimated_roi":0.0,"actual_roi":1.0,"idea_id":"idea-realization-engine","process_summary":"Idea has UUID4 id (immutable) and slug (mutable, unique, URL-safe); Slug auto-derived from name at creation when omitted; Slug max 80 chars, lowercase, diacritics stripped, deduped with -2 suffix; GET /api/ideas/{slug} resolves same idea as GET /api/ideas/{uuid}; PATCH /api/ideas/{id}/slug renames slug and keeps old slug in history","pseudocode_summary":null,"implementation_summary":"api/app/services/idea_service.py (slugify(), update_idea_slug()); api/app/models/idea.py (Idea.slug, Idea.slug_history)","created_by_contributor_id":null,"updated_by_contributor_id":null,"created_at":"2026-04-09T03:10:08.907796Z","updated_at":"2026-04-09T03:10:08.907796Z","content_path":"specs/idea-dual-identity.md","content_hash":"3dc0760107f84b59","workspace_id":"coherence-network"}