Chunk #607
Aus: Installation (Index: 2)
279
Tokens
Synced
Status
Taxonomie
| Kategorie | Installation |
|---|---|
| Pfad | Installation > MCP-Tasks Installation > Datenbankdesign |
| Heading-Pfad | Installation > MCP-Tasks Installation > 5. Datenbank vorbereiten > Task-Tabellen erstellen |
Entities
| Name | Typ |
|---|---|
| tasks | TECHNOLOGY|DATABASE |
| task_assignments | DATABASE |
| ENUM | CONFIGURATION |
| INT | DATA_TYPE |
| VARCHAR | DATA_TYPE |
| TEXT | DATA_TYPE |
| DATETIME | DATA_TYPE |
| AUTO_INCREMENT | DATABASE |
| PRIMARY KEY | DATABASE |
| FOREIGN KEY | DATABASE |
| ON DELETE SET NULL | DATABASE |
| ON DELETE CASCADE | DATABASE |
| INDEX | DATABASE |
Keywords
Inhalt
```
`-- Haupttabelle
CREATE TABLE IF NOT EXISTS tasks (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
description TEXT,
type ENUM('human_task', 'ai_task', 'mixed') DEFAULT 'ai_task',
status ENUM('pending', 'in_progress', 'completed', 'failed', 'cancelled') DEFAULT 'pending',
parent_task_id INT DEFAULT NULL,
due_date DATETIME DEFAULT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (parent_task_id) REFERENCES tasks(id) ON DELETE SET NULL,
INDEX idx_status (status),
INDEX idx_type (type)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Zuweisungen
CREATE TABLE IF NOT EXISTS task_assignments (
id INT AUTO_INCREMENT PRIMARY KEY,
task_id INT NOT NULL,
assignee VARCHAR(100) NOT NULL,
assignee_type ENUM('human', 'ollama', 'claude', 'anthropic_api') NOT NULL,
model_name VARCHAR(100) DEFAULT NULL,
notes TEXT,
assigned_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE,
INDEX idx_task_id (task_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Clean Content
```
`-- Haupttabelle
CREATE TABLE IF NOT EXISTS tasks (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
description TEXT,
type ENUM('human_task', 'ai_task', 'mixed') DEFAULT 'ai_task',
status ENUM('pending', 'in_progress', 'completed', 'failed', 'cancelled') DEFAULT 'pending',
parent_task_id INT DEFAULT NULL,
due_date DATETIME DEFAULT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (parent_task_id) REFERENCES tasks(id) ON DELETE SET NULL,
INDEX idx_status (status),
INDEX idx_type (type)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Zuweisungen
CREATE TABLE IF NOT EXISTS task_assignments (
id INT AUTO_INCREMENT PRIMARY KEY,
task_id INT NOT NULL,
assignee VARCHAR(100) NOT NULL,
assignee_type ENUM('human', 'ollama', 'claude', 'anthropic_api') NOT NULL,
model_name VARCHAR(100) DEFAULT NULL,
notes TEXT,
assigned_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE,
INDEX idx_task_id (task_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Metadaten
| Analysiert am | 20.12.2025 12:47:06 |
|---|---|
| Analyse-Modell | gemma3:4b-it-qat |
| Embedding-Modell | mxbai-embed-large |
| Qdrant-ID | 4020fa3c-c935-461b-8d26-822d66e5b329 |
| Erstellt | 20.12.2025 12:34:42 |
| Aktualisiert | 20.12.2025 12:53:40 |