mirror of
https://github.com/n8n-io/n8n.git
synced 2026-07-27 19:15:01 +02:00
106 lines
3.6 KiB
Markdown
106 lines
3.6 KiB
Markdown
# agent_eval_result
|
|
|
|
## Description
|
|
|
|
<details>
|
|
<summary><strong>Table Definition</strong></summary>
|
|
|
|
```sql
|
|
CREATE TABLE "agent_eval_result" ("id" varchar(36) PRIMARY KEY NOT NULL, "runId" varchar(36) NOT NULL, "sourceRowId" varchar(255), "runIndex" integer, "status" varchar NOT NULL, "input" text, "output" text, "toolCalls" text, "metrics" text, "runAt" datetime(3), "completedAt" datetime(3), "errorCode" varchar(255), "errorDetails" text, "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')), CONSTRAINT "CHK_agent_eval_result_status" CHECK ("status" IN ('new', 'running', 'success', 'error', 'cancelled')), CONSTRAINT "FK_40a2d1248a6d984f442de2fac1b" FOREIGN KEY ("runId") REFERENCES "agent_eval_run" ("id") ON DELETE CASCADE)
|
|
```
|
|
|
|
</details>
|
|
|
|
## Columns
|
|
|
|
| Name | Type | Default | Nullable | Children | Parents | Comment |
|
|
| ---- | ---- | ------- | -------- | -------- | ------- | ------- |
|
|
| completedAt | datetime(3) | | true | | | |
|
|
| createdAt | datetime(3) | STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') | false | | | |
|
|
| errorCode | varchar(255) | | true | | | |
|
|
| errorDetails | TEXT | | true | | | |
|
|
| id | varchar(36) | | false | [agent_eval_rating](agent_eval_rating.md) | | |
|
|
| input | TEXT | | true | | | |
|
|
| metrics | TEXT | | true | | | |
|
|
| output | TEXT | | true | | | |
|
|
| runAt | datetime(3) | | true | | | |
|
|
| runId | varchar(36) | | false | | [agent_eval_run](agent_eval_run.md) | |
|
|
| runIndex | INTEGER | | true | | | |
|
|
| sourceRowId | varchar(255) | | true | | | |
|
|
| status | varchar | | false | | | |
|
|
| toolCalls | TEXT | | true | | | |
|
|
| updatedAt | datetime(3) | STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') | false | | | |
|
|
|
|
## Constraints
|
|
|
|
| Name | Type | Definition |
|
|
| ---- | ---- | ---------- |
|
|
| - | CHECK | CHECK ("status" IN ('new', 'running', 'success', 'error', 'cancelled')) |
|
|
| - (Foreign key ID: 0) | FOREIGN KEY | FOREIGN KEY (runId) REFERENCES agent_eval_run (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE |
|
|
| id | PRIMARY KEY | PRIMARY KEY (id) |
|
|
| sqlite_autoindex_agent_eval_result_1 | PRIMARY KEY | PRIMARY KEY (id) |
|
|
|
|
## Indexes
|
|
|
|
| Name | Definition |
|
|
| ---- | ---------- |
|
|
| IDX_40a2d1248a6d984f442de2fac1 | CREATE INDEX "IDX_40a2d1248a6d984f442de2fac1" ON "agent_eval_result" ("runId") |
|
|
| sqlite_autoindex_agent_eval_result_1 | PRIMARY KEY (id) |
|
|
|
|
## Relations
|
|
|
|
```mermaid
|
|
erDiagram
|
|
|
|
"agent_eval_rating" }o--|| "agent_eval_result" : "FOREIGN KEY (resultId) REFERENCES agent_eval_result (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
|
|
"agent_eval_result" }o--|| "agent_eval_run" : "FOREIGN KEY (runId) REFERENCES agent_eval_run (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
|
|
|
|
"agent_eval_result" {
|
|
datetime_3_ completedAt
|
|
datetime_3_ createdAt
|
|
varchar_255_ errorCode
|
|
TEXT errorDetails
|
|
varchar_36_ id PK
|
|
TEXT input
|
|
TEXT metrics
|
|
TEXT output
|
|
datetime_3_ runAt
|
|
varchar_36_ runId FK
|
|
INTEGER runIndex
|
|
varchar_255_ sourceRowId
|
|
varchar status
|
|
TEXT toolCalls
|
|
datetime_3_ updatedAt
|
|
}
|
|
"agent_eval_rating" {
|
|
TEXT comment
|
|
TEXT correction
|
|
datetime_3_ createdAt
|
|
varchar_36_ id PK
|
|
varchar ratedById FK
|
|
varchar_36_ resultId FK
|
|
datetime_3_ updatedAt
|
|
varchar_8_ vote
|
|
}
|
|
"agent_eval_run" {
|
|
varchar_36_ agentVersionId
|
|
boolean cancelRequested
|
|
datetime_3_ completedAt
|
|
datetime_3_ createdAt
|
|
varchar createdById FK
|
|
varchar_36_ datasetId FK
|
|
varchar_255_ errorCode
|
|
TEXT errorDetails
|
|
varchar_36_ id PK
|
|
TEXT metrics
|
|
datetime_3_ runAt
|
|
varchar_255_ runningInstanceId
|
|
varchar status
|
|
datetime_3_ updatedAt
|
|
}
|
|
```
|
|
|
|
---
|
|
|
|
> Generated by [tbls](https://github.com/k1LoW/tbls)
|