Chunk #438
Aus: Protokoll (Index: 2)
202
Tokens
Synced
Status
Taxonomie
| Kategorie | Datenbanken |
|---|---|
| Pfad | Datenbanken > Schema > Protokollierung |
| Heading-Pfad | Protokoll > KI-Protokoll > Datenbank-Schema |
Entities
| Name | Typ |
|---|---|
| protokoll | DATABASE |
| id | COLUMN |
| timestamp | COLUMN |
| request_ip | COLUMN |
| client_name | COLUMN |
| request | COLUMN |
| request_timestamp | COLUMN |
| response | COLUMN |
| response_timestamp | COLUMN |
| duration_ms | COLUMN |
| tokens_input | COLUMN |
| tokens_output | COLUMN |
| tokens_total | COLUMN |
| model_name | COLUMN |
| status | COLUMN |
| error_message | COLUMN |
Keywords
Inhalt
CREATE TABLE protokoll (
id bigint(20) NOT NULL AUTO_INCREMENT,
timestamp datetime(6) DEFAULT current_timestamp(6),
request_ip varchar(45) NOT NULL,
client_name varchar(255) NOT NULL,
request text NOT NULL,
request_timestamp datetime(6) NOT NULL,
response text DEFAULT NULL,
response_timestamp datetime(6) DEFAULT NULL,
duration_ms int(10) unsigned DEFAULT NULL,
tokens_input int(10) unsigned DEFAULT NULL,
tokens_output int(10) unsigned DEFAULT NULL,
tokens_total int(10) unsigned DEFAULT NULL,
model_name varchar(255) DEFAULT NULL,
status enum('pending','completed','error') DEFAULT 'pending',
error_message text DEFAULT NULL,
PRIMARY KEY (id),
KEY idx_timestamp (timestamp),
KEY idx_client_name (client_name),
KEY idx_status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;Clean Content
```
`CREATE TABLE protokoll (
id bigint(20) NOT NULL AUTO_INCREMENT,
timestamp datetime(6) DEFAULT current_timestamp(6),
request_ip varchar(45) NOT NULL,
client_name varchar(255) NOT NULL,
request text NOT NULL,
request_timestamp datetime(6) NOT NULL,
response text DEFAULT NULL,
response_timestamp datetime(6) DEFAULT NULL,
duration_ms int(10) unsigned DEFAULT NULL,
tokens_input int(10) unsigned DEFAULT NULL,
tokens_output int(10) unsigned DEFAULT NULL,
tokens_total int(10) unsigned DEFAULT NULL,
model_name varchar(255) DEFAULT NULL,
status enum('pending','completed','error') DEFAULT 'pending',
error_message text DEFAULT NULL,
PRIMARY KEY (id),
KEY idx_timestamp (timestamp),
KEY idx_client_name (client_name),
KEY idx_status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`
```
Metadaten
| Analysiert am | 20.12.2025 12:38:22 |
|---|---|
| Analyse-Modell | gemma3:4b-it-qat |
| Embedding-Modell | mxbai-embed-large |
| Qdrant-ID | fcc85494-70b8-4a85-8d85-087d33a2b7ea |
| Erstellt | 20.12.2025 12:34:42 |
| Aktualisiert | 20.12.2025 12:53:36 |