Chunk #469

Aus: Schema (Index: 7)

Taxonomie

Entities

Keywords

Inhalt

CREATE TABLE task_results (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    task_id BIGINT UNSIGNED NOT NULL,
    assignment_id BIGINT UNSIGNED NULL,
    executor VARCHAR(100) NOT NULL,
    executor_type ENUM('human', 'ollama', 'claude', 'anthropic_api') NOT NULL,
    model_name VARCHAR(100) NULL,
    request TEXT,
    response LONGTEXT,
    request_timestamp DATETIME(6) NOT NULL,
    response_timestamp DATETIME(6) NULL,
    duration_ms INT UNSIGNED NULL,
    tokens_input INT UNSIGNED NULL,
    tokens_output INT UNSIGNED NULL,
    tokens_total INT UNSIGNED NULL,
    cost_usd DECIMAL(10,6) NULL,
    status ENUM('success', 'error', 'partial') NOT NULL DEFAULT 'success',
    error_message TEXT NULL,
    created_at DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
    PRIMARY KEY (id),
    CONSTRAINT fk_result_task FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE,
    CONSTRAINT fk_result_assignment FOREIGN KEY (assignment_id) REFERENCES task_assignments(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Clean Content

```
`CREATE TABLE task_results (
 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 task_id BIGINT UNSIGNED NOT NULL,
 assignment_id BIGINT UNSIGNED NULL,
 executor VARCHAR(100) NOT NULL,
 executor_type ENUM('human', 'ollama', 'claude', 'anthropic_api') NOT NULL,
 model_name VARCHAR(100) NULL,
 request TEXT,
 response LONGTEXT,
 request_timestamp DATETIME(6) NOT NULL,
 response_timestamp DATETIME(6) NULL,
 duration_ms INT UNSIGNED NULL,
 tokens_input INT UNSIGNED NULL,
 tokens_output INT UNSIGNED NULL,
 tokens_total INT UNSIGNED NULL,
 cost_usd DECIMAL(10,6) NULL,
 status ENUM('success', 'error', 'partial') NOT NULL DEFAULT 'success',
 error_message TEXT NULL,
 created_at DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
 PRIMARY KEY (id),
 CONSTRAINT fk_result_task FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE,
 CONSTRAINT fk_result_assignment FOREIGN KEY (assignment_id) REFERENCES task_assignments(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;`
```

Metadaten

Alle Chunks | Zur Seite | In Docs anzeigen