Chunk #467

Aus: Schema (Index: 5)

196 Tokens

Synced Status

Taxonomie

Kategorie	Datenbanken
Pfad	Datenbanken > Schema > Tabellenschema
Heading-Pfad	Schema > Datenbank-Schema > task_assignments > SQL

Entities

Name	Typ
task_assignments	TABLE
BIGINT UNSIGNED	DATA_TYPE
VARCHAR	DATA_TYPE
ENUM	DATA_TYPE
DATETIME(6)	DATA_TYPE
TEXT	DATA_TYPE
AUTO_INCREMENT	CONCEPT
FOREIGN KEY	CONCEPT
ON DELETE CASCADE	CONCEPT

Keywords

SQL task assignments database schema table

Inhalt

CREATE TABLE task_assignments (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    task_id BIGINT UNSIGNED NOT NULL,
    assignee VARCHAR(100) NOT NULL,
    assignee_type ENUM('human', 'ollama', 'claude', 'anthropic_api') NOT NULL,
    model_name VARCHAR(100) NULL,
    assigned_by VARCHAR(100) NOT NULL,
    assigned_by_type ENUM('human', 'ai') NOT NULL DEFAULT 'human',
    status ENUM('pending', 'accepted', 'rejected', 'in_progress', 'completed') NOT NULL DEFAULT 'pending',
    assigned_at DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
    accepted_at DATETIME(6) NULL,
    completed_at DATETIME(6) NULL,
    notes TEXT,
    PRIMARY KEY (id),
    CONSTRAINT fk_assignment_task FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Clean Content

```
`CREATE TABLE task_assignments (
 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 task_id BIGINT UNSIGNED NOT NULL,
 assignee VARCHAR(100) NOT NULL,
 assignee_type ENUM('human', 'ollama', 'claude', 'anthropic_api') NOT NULL,
 model_name VARCHAR(100) NULL,
 assigned_by VARCHAR(100) NOT NULL,
 assigned_by_type ENUM('human', 'ai') NOT NULL DEFAULT 'human',
 status ENUM('pending', 'accepted', 'rejected', 'in_progress', 'completed') NOT NULL DEFAULT 'pending',
 assigned_at DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
 accepted_at DATETIME(6) NULL,
 completed_at DATETIME(6) NULL,
 notes TEXT,
 PRIMARY KEY (id),
 CONSTRAINT fk_assignment_task FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;`
```

Metadaten

Analysiert am	20.12.2025 12:39:43
Analyse-Modell	gemma3:4b-it-qat
Embedding-Modell	mxbai-embed-large
Qdrant-ID	`9016c6fa-92c3-4b07-9a5e-ca03ca791d02`
Erstellt	20.12.2025 12:34:42
Aktualisiert	20.12.2025 12:53:37

Alle Chunks | Zur Seite | In Docs anzeigen