Collection-Auswahl (Multi-Select aus rag_collections)
Kontext-Limit (3/5/10/15 Quellen)
Temperature (0.0-1.0)
Max Tokens (bis 8192)
Autorenprofil-Auswahl für Schreibstil
Token & Kosten
Pro Nachricht: Input-Tokens, Output-Tokens, Kosten
Pro Session: Token-Summe und Gesamtkosten in Sidebar
Kosten-Berechnung: Opus 4.5 Pricing ($15/1M input, $75/1M output)
Ollama: "lokal" Label statt Token-Zahlen
Datenbank-Schema (ki_content)
chat_sessions
id INT PK AUTO
uuid VARCHAR(36) UNIQUE
session_token VARCHAR(64) UNIQUE
user_id INT NULL
persona_id INT FK NULL
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
last_activity DATETIME DEFAULT CURRENT_TIMESTAMP
model VARCHAR(100) DEFAULT 'claude-opus-4-5-20251101'
context_limit INT DEFAULT 5
temperature DECIMAL(3,2) DEFAULT 0.50
max_tokens INT DEFAULT 4096
title VARCHAR(255) DEFAULT 'Neuer Chat'
author_profile_id INT FK NULL
system_prompt_id INT NULL
updated_at DATETIME ON UPDATE CURRENT_TIMESTAMP
collections TEXT DEFAULT '["documents"]' (JSON-Array)
chat_messages
id INT PK AUTO
session_id INT FK NOT NULL (CASCADE DELETE)
role ENUM('user','assistant','system')
model VARCHAR(100)
content TEXT NOT NULL
start_microtime DECIMAL(16,6)
end_microtime DECIMAL(16,6)
tokens_input INT
tokens_output INT
sources LONGTEXT (JSON)
author_profile_id INT
system_prompt_id INT
collections TEXT (JSON-Array)
context_limit INT
chunks_used LONGTEXT (JSON)
llm_request_id INT FK
created_at DATETIME DEFAULT CURRENT_TIMESTAMP