[ENH] Emotional valence field in EMC episode schema

[OppaAI]

Summary

EMC stores what GRACE experienced but not how she felt about it. Adding emotional valence to episode schema would allow GRACE to remember not just what happened but her emotional state during that interaction.

Current Behavior

EMC stores: timestamp, date, role, content, embedding

No emotional context is captured — GRACE has no memory of how she felt about past topics.

Proposed Enhancement

Add emotional_valence field to the episodes table:

CREATE TABLE IF NOT EXISTS episodes (
    id               INTEGER PRIMARY KEY,
    timestamp        TEXT NOT NULL,
    date             TEXT NOT NULL,
    role             TEXT NOT NULL,
    content          TEXT NOT NULL,
    embedding        TEXT NOT NULL,
    emotional_valence REAL DEFAULT 0.0,  -- -1.0 (negative) to +1.0 (positive)
    emotional_label  TEXT,               -- "curious", "happy", "concerned" etc
    created_at       TEXT DEFAULT (datetime('now'))
);

Cosmos could generate the emotional valence from the content during the 11pm reflection.

Impact

• GRACE remembers how she felt about past topics
• More natural, human-like memory
• Could influence future responses — GRACE is more cautious about topics that previously felt negative
• Enables emotional arc tracking over time

Notes

• Implement in M2 when EMC schema gets extended for multimodal
• Emotional valence scoring could be a Cosmos inference task during 11pm reflection