{
  "_meta": {
    "version": "1.0.0",
    "created": "2026-04-18",
    "description": "Oracle Template Seed Database — canonical chapter/subchapter taxonomy and seed JSON examples for the Project Velocity Oracle platform",
    "total_chapters": 6,
    "total_subchapters": 24,
    "total_seed_examples": 36
  },
  "chapters": [
    {
      "chapter_id": "ch-001",
      "name": "Market Intelligence",
      "description": "Components for real estate market analysis, pricing trends, demand signals, and competitive landscape.",
      "sort_order": 1,
      "subchapters": [
        {
          "subchapter_id": "sub-001-01",
          "name": "Pricing Trends",
          "description": "Price per sqft trends, AED/m² benchmarks, quarterly movement charts.",
          "sort_order": 1
        },
        {
          "subchapter_id": "sub-001-02",
          "name": "Demand Signals",
          "description": "Search volume, inquiry rate, site visit frequency, and absorption rate components.",
          "sort_order": 2
        },
        {
          "subchapter_id": "sub-001-03",
          "name": "Competitive Landscape",
          "description": "Developer comparison, project pipeline mapping, competitive unit mix analysis.",
          "sort_order": 3
        },
        {
          "subchapter_id": "sub-001-04",
          "name": "Location Index",
          "description": "District-level scores, proximity analysis, infrastructure readiness.",
          "sort_order": 4
        }
      ]
    },
    {
      "chapter_id": "ch-002",
      "name": "Lead Intelligence",
      "description": "Components for lead profiling, scoring, pipeline health, and behaviour tracking.",
      "sort_order": 2,
      "subchapters": [
        {
          "subchapter_id": "sub-002-01",
          "name": "Lead Profile",
          "description": "Buyer persona cards, nationality, budget bracket, preferred property type.",
          "sort_order": 1
        },
        {
          "subchapter_id": "sub-002-02",
          "name": "QD Score",
          "description": "Qualification-Desire score breakdown, historical trend, per-dimension scores.",
          "sort_order": 2
        },
        {
          "subchapter_id": "sub-002-03",
          "name": "Pipeline Health",
          "description": "Pipeline stage distribution, velocity, stall alerts, probability weighting.",
          "sort_order": 3
        },
        {
          "subchapter_id": "sub-002-04",
          "name": "Engagement History",
          "description": "Touchpoint timeline, dwell time heat maps, content interaction logs.",
          "sort_order": 4
        }
      ]
    },
    {
      "chapter_id": "ch-003",
      "name": "Communication Intelligence",
      "description": "Components surfacing insights from calls, messages, transcripts, and follow-up commitments.",
      "sort_order": 3,
      "subchapters": [
        {
          "subchapter_id": "sub-003-01",
          "name": "Call Summary",
          "description": "Transcript summary, speaker diarization, key-phrase extraction.",
          "sort_order": 1
        },
        {
          "subchapter_id": "sub-003-02",
          "name": "Promise Tracker",
          "description": "Promises made during calls, follow-up dates, commitment confidence.",
          "sort_order": 2
        },
        {
          "subchapter_id": "sub-003-03",
          "name": "WhatsApp Thread",
          "description": "Business WhatsApp message thread summaries, sentiment per message.",
          "sort_order": 3
        },
        {
          "subchapter_id": "sub-003-04",
          "name": "Reminder Surface",
          "description": "Due follow-ups, overdue reminders, NemoClaw-suggested next actions.",
          "sort_order": 4
        }
      ]
    },
    {
      "chapter_id": "ch-004",
      "name": "Inventory Analytics",
      "description": "Components for property inventory insight, availability, and absorption.",
      "sort_order": 4,
      "subchapters": [
        {
          "subchapter_id": "sub-004-01",
          "name": "Property Card",
          "description": "Single-property summary card with unit details, pricing, media reference.",
          "sort_order": 1
        },
        {
          "subchapter_id": "sub-004-02",
          "name": "Availability Matrix",
          "description": "Bed-type × availability grid with unit count and price band.",
          "sort_order": 2
        },
        {
          "subchapter_id": "sub-004-03",
          "name": "Absorption Rate",
          "description": "Sales velocity per project and developer over rolling windows.",
          "sort_order": 3
        },
        {
          "subchapter_id": "sub-004-04",
          "name": "Inventory Comparison",
          "description": "Side-by-side comparison of two or more properties on key metrics.",
          "sort_order": 4
        }
      ]
    },
    {
      "chapter_id": "ch-005",
      "name": "Operational Metrics",
      "description": "System-level, team-level, and showroom-level operational performance components.",
      "sort_order": 5,
      "subchapters": [
        {
          "subchapter_id": "sub-005-01",
          "name": "Showroom Traffic",
          "description": "Visitor count, zone dwell time, peak hour distribution.",
          "sort_order": 1
        },
        {
          "subchapter_id": "sub-005-02",
          "name": "Team Performance",
          "description": "Agent-level QD scores, conversion rates, call volume, follow-up compliance.",
          "sort_order": 2
        },
        {
          "subchapter_id": "sub-005-03",
          "name": "Campaign Metrics",
          "description": "Catalyst campaign reach, engagement rate, cost-per-lead, ROAS.",
          "sort_order": 3
        },
        {
          "subchapter_id": "sub-005-04",
          "name": "System Health",
          "description": "Backend queue depth, GPU utilization, transcription job latency.",
          "sort_order": 4
        }
      ]
    },
    {
      "chapter_id": "ch-006",
      "name": "Calendar and Follow-Up",
      "description": "Components for scheduling, action planning, and NemoClaw-derived follow-up surfaces.",
      "sort_order": 6,
      "subchapters": [
        {
          "subchapter_id": "sub-006-01",
          "name": "Calendar View",
          "description": "Personal calendar view with communication-derived events and reminders.",
          "sort_order": 1
        },
        {
          "subchapter_id": "sub-006-02",
          "name": "Action Queue",
          "description": "Prioritized action list for an agent, ordered by urgency and lead value.",
          "sort_order": 2
        },
        {
          "subchapter_id": "sub-006-03",
          "name": "Follow-Up Plan",
          "description": "Structured follow-up plan derived from call outcomes and NemoClaw insights.",
          "sort_order": 3
        },
        {
          "subchapter_id": "sub-006-04",
          "name": "Reminder Cards",
          "description": "Surface-agnostic reminder card applicable to tablet and phone edge.",
          "sort_order": 4
        }
      ]
    }
  ],
  "seed_examples": [
    {
      "example_id": "ex-001",
      "chapter_id": "ch-001",
      "subchapter_id": "sub-001-01",
      "title": "Dubai Marina — Price Per Sqft Trend (12-Month)",
      "quality_notes": "Canonical example. Use for pricing trend chart templates.",
      "is_canonical": true,
      "template_name": "Pricing Trend Chart",
      "component_type": "line_chart",
      "accepted_shapes": ["time_series"],
      "example_json": {
        "componentType": "line_chart",
        "title": "Dubai Marina — AED/sqft Trend",
        "subtitle": "12-Month Rolling Average",
        "dataSource": {
          "type": "inventory_aggregate",
          "district": "Dubai Marina",
          "metric": "avg_price_per_sqft",
          "window": "12M"
        },
        "visualization": {
          "xAxis": "month",
          "yAxis": "aed_per_sqft",
          "format": "currency_aed",
          "annotations": [
            { "date": "2025-10", "label": "Off-plan surge", "type": "event" }
          ],
          "trend_line": true,
          "confidence_band": false
        },
        "style": {
          "accentColor": "#2563EB",
          "gridLines": "subtle"
        }
      }
    },
    {
      "example_id": "ex-002",
      "chapter_id": "ch-001",
      "subchapter_id": "sub-001-02",
      "title": "Inquiry Velocity — Downtown Dubai (30-Day)",
      "quality_notes": "Use for demand signal bar charts.",
      "is_canonical": true,
      "template_name": "Demand Signal Bar",
      "component_type": "bar_chart",
      "accepted_shapes": ["categorical_count"],
      "example_json": {
        "componentType": "bar_chart",
        "title": "Inquiry Volume — Downtown Dubai",
        "subtitle": "Last 30 Days by Week",
        "dataSource": {
          "type": "crm_aggregate",
          "district": "Downtown Dubai",
          "metric": "inquiry_count",
          "window": "30D",
          "groupBy": "week"
        },
        "visualization": {
          "xAxis": "week",
          "yAxis": "inquiry_count",
          "format": "integer",
          "comparison": { "enabled": true, "label": "Prior 30D", "style": "ghost_bar" }
        },
        "style": {
          "accentColor": "#10B981",
          "barRadius": 4
        }
      }
    },
    {
      "example_id": "ex-003",
      "chapter_id": "ch-002",
      "subchapter_id": "sub-002-02",
      "title": "Lead QD Score Card — Mohammed Al-Rashid",
      "quality_notes": "Canonical single-lead QD score breakdown card.",
      "is_canonical": true,
      "template_name": "QD Score Card",
      "component_type": "metric_card_group",
      "accepted_shapes": ["qd_score_breakdown"],
      "example_json": {
        "componentType": "metric_card_group",
        "title": "QD Score",
        "subtitle": "Qualification × Desire",
        "dataSource": {
          "type": "sentinel_qd",
          "leadId": "{{lead_id}}"
        },
        "visualization": {
          "layout": "2x2_grid",
          "cards": [
            { "dimension": "overall", "label": "Overall QD", "format": "percentage" },
            { "dimension": "qualification", "label": "Qualification", "format": "percentage" },
            { "dimension": "desire", "label": "Desire", "format": "percentage" },
            { "dimension": "velocity", "label": "Engagement Velocity", "format": "trend_arrow" }
          ],
          "threshold_colors": {
            "high": "#10B981",
            "medium": "#F59E0B",
            "low": "#EF4444"
          }
        }
      }
    },
    {
      "example_id": "ex-004",
      "chapter_id": "ch-003",
      "subchapter_id": "sub-003-01",
      "title": "Call Summary Card — Diarized Transcript with Key Phrases",
      "quality_notes": "Canonical call summary. Use for communication intelligence panels.",
      "is_canonical": true,
      "template_name": "Call Summary Card",
      "component_type": "communication_summary",
      "accepted_shapes": ["transcript_summary"],
      "example_json": {
        "componentType": "communication_summary",
        "title": "Call Summary",
        "dataSource": {
          "type": "edge_communication_event",
          "eventId": "{{event_id}}",
          "channel": "pstn"
        },
        "visualization": {
          "layout": "timeline_with_phrases",
          "show_speaker_labels": true,
          "show_duration": true,
          "show_sentiment": true,
          "key_phrase_highlight": true,
          "sections": ["summary", "promises", "key_phrases", "next_action"]
        }
      }
    },
    {
      "example_id": "ex-005",
      "chapter_id": "ch-003",
      "subchapter_id": "sub-003-02",
      "title": "Promise Tracker — Lead Follow-Up Commitments",
      "quality_notes": "Canonical promise tracker. Use for follow-up reminder surfaces.",
      "is_canonical": true,
      "template_name": "Promise Tracker Table",
      "component_type": "data_table",
      "accepted_shapes": ["communication_facts"],
      "example_json": {
        "componentType": "data_table",
        "title": "Promises and Commitments",
        "dataSource": {
          "type": "edge_memory_facts",
          "leadId": "{{lead_id}}",
          "factTypes": ["promise", "follow_up_date", "decision_maker_note"]
        },
        "visualization": {
          "columns": [
            { "key": "fact_text", "label": "Commitment", "width": "flex" },
            { "key": "effective_date", "label": "Due", "format": "date_relative" },
            { "key": "confidence", "label": "Confidence", "format": "percentage" },
            { "key": "extracted_from", "label": "Source", "format": "badge" }
          ],
          "row_actions": ["mark_done", "create_calendar_event"],
          "sort": { "column": "effective_date", "direction": "asc" }
        }
      }
    },
    {
      "example_id": "ex-006",
      "chapter_id": "ch-004",
      "subchapter_id": "sub-004-01",
      "title": "Property Card — Sobha One Tower A",
      "quality_notes": "Canonical property card. Use for inventory summaries.",
      "is_canonical": true,
      "template_name": "Property Summary Card",
      "component_type": "property_card",
      "accepted_shapes": ["inventory_property"],
      "example_json": {
        "componentType": "property_card",
        "title": "Property Summary",
        "dataSource": {
          "type": "inventory_property",
          "propertyId": "{{property_id}}"
        },
        "visualization": {
          "layout": "hero_with_stats",
          "sections": [
            "project_name",
            "developer_name",
            "location_map_pin",
            "price_bands",
            "unit_mix_summary",
            "amenity_chips",
            "media_carousel"
          ],
          "cta": { "label": "Schedule Viewing", "action": "create_calendar_event" }
        }
      }
    },
    {
      "example_id": "ex-007",
      "chapter_id": "ch-005",
      "subchapter_id": "sub-005-01",
      "title": "Showroom Traffic Heatmap",
      "quality_notes": "Canonical traffic component. Use for operational dashboards.",
      "is_canonical": true,
      "template_name": "Showroom Traffic Heatmap",
      "component_type": "heatmap",
      "accepted_shapes": ["zone_time_matrix"],
      "example_json": {
        "componentType": "heatmap",
        "title": "Showroom Zone Traffic",
        "subtitle": "Today — Live",
        "dataSource": {
          "type": "sentinel_live",
          "metric": "visitor_dwell_time",
          "groupBy": ["zone", "hour"]
        },
        "visualization": {
          "xAxis": "hour_of_day",
          "yAxis": "zone_name",
          "value": "avg_dwell_minutes",
          "colorScale": { "low": "#EFF6FF", "high": "#1D4ED8" },
          "annotations": true
        }
      }
    },
    {
      "example_id": "ex-008",
      "chapter_id": "ch-006",
      "subchapter_id": "sub-006-04",
      "title": "Phone Edge Reminder Card — Follow-Up Due",
      "quality_notes": "Designed for narrow phone edge surfaces. Minimal data footprint.",
      "is_canonical": true,
      "template_name": "Reminder Card",
      "component_type": "compact_alert_card",
      "accepted_shapes": ["insight_recommendation"],
      "example_json": {
        "componentType": "compact_alert_card",
        "title": "Follow-Up Reminder",
        "dataSource": {
          "type": "insight_recommendations",
          "leadId": "{{lead_id}}",
          "status": "pending",
          "limit": 1
        },
        "visualization": {
          "layout": "single_card_narrow",
          "fields": ["summary", "suggested_action", "target_system"],
          "actions": ["accept", "dismiss", "snooze_1h"],
          "urgency_indicator": true,
          "surface_target": ["iphone_edge", "android_phone_edge"]
        }
      }
    }
  ],
  "kimi_synthetic_plan": {
    "description": "Downstream Kimi synthetic data expansion plan consuming this seed DB",
    "expansion_targets": [
      {
        "chapter_id": "ch-001",
        "subchapter_id": "sub-001-01",
        "seed_example_ids": ["ex-001"],
        "requested_count": 50,
        "model": "kimi",
        "diversity_axes": ["district", "property_type", "time_window"]
      },
      {
        "chapter_id": "ch-002",
        "subchapter_id": "sub-002-02",
        "seed_example_ids": ["ex-003"],
        "requested_count": 100,
        "model": "kimi",
        "diversity_axes": ["lead_nationality", "budget_bracket", "pipeline_stage"]
      },
      {
        "chapter_id": "ch-003",
        "subchapter_id": "sub-003-01",
        "seed_example_ids": ["ex-004"],
        "requested_count": 200,
        "model": "kimi",
        "diversity_axes": ["call_outcome", "property_type", "language"]
      },
      {
        "chapter_id": "ch-004",
        "subchapter_id": "sub-004-01",
        "seed_example_ids": ["ex-006"],
        "requested_count": 150,
        "model": "kimi",
        "diversity_axes": ["developer_name", "district", "bedrooms"]
      }
    ],
    "quality_gate": {
      "min_acceptance_confidence": 0.8,
      "human_review_required_for_canonical": true,
      "auto_accept_below_count": 20
    }
  }
}
