Chunk #465

Aus: Schema (Index: 3)

Taxonomie

Entities

Keywords

Inhalt

CREATE TABLE tasks (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    uuid VARCHAR(36) NOT NULL,
    title VARCHAR(255) NOT NULL,
    description TEXT,
    type ENUM('human_task', 'ai_task', 'mixed') NOT NULL DEFAULT 'human_task',
    status ENUM('pending', 'in_progress', 'completed', 'failed', 'cancelled') NOT NULL DEFAULT 'pending',
    created_by VARCHAR(100) NOT NULL,
    created_by_type ENUM('human', 'ai') NOT NULL DEFAULT 'human',
    parent_task_id BIGINT UNSIGNED NULL,
    due_date DATETIME NULL,
    created_at DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
    updated_at DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
    completed_at DATETIME(6) NULL,
    metadata JSON,
    PRIMARY KEY (id),
    UNIQUE KEY uk_uuid (uuid),
    CONSTRAINT fk_parent_task FOREIGN KEY (parent_task_id) REFERENCES tasks(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Clean Content

```
`CREATE TABLE tasks (
 id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 uuid VARCHAR(36) NOT NULL,
 title VARCHAR(255) NOT NULL,
 description TEXT,
 type ENUM('human_task', 'ai_task', 'mixed') NOT NULL DEFAULT 'human_task',
 status ENUM('pending', 'in_progress', 'completed', 'failed', 'cancelled') NOT NULL DEFAULT 'pending',
 created_by VARCHAR(100) NOT NULL,
 created_by_type ENUM('human', 'ai') NOT NULL DEFAULT 'human',
 parent_task_id BIGINT UNSIGNED NULL,
 due_date DATETIME NULL,
 created_at DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
 updated_at DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
 completed_at DATETIME(6) NULL,
 metadata JSON,
 PRIMARY KEY (id),
 UNIQUE KEY uk_uuid (uuid),
 CONSTRAINT fk_parent_task FOREIGN KEY (parent_task_id) REFERENCES tasks(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;`
```

Metadaten

Alle Chunks | Zur Seite | In Docs anzeigen