mirror of
https://github.com/n8n-io/n8n.git
synced 2026-07-27 19:15:01 +02:00
119 lines
4.1 KiB
Markdown
119 lines
4.1 KiB
Markdown
# agent_eval_dataset
|
|
|
|
## Description
|
|
|
|
<details>
|
|
<summary><strong>Table Definition</strong></summary>
|
|
|
|
```sql
|
|
CREATE TABLE "agent_eval_dataset" ("id" varchar(36) PRIMARY KEY NOT NULL, "name" varchar(128) NOT NULL, "description" text, "agentId" varchar(36) NOT NULL, "datasetSource" varchar(32) NOT NULL, "datasetRef" text NOT NULL, "columnMapping" text, "createdById" varchar, "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_dataset_datasetSource" CHECK ("datasetSource" IN ('data_table', 'google_sheets')), CONSTRAINT "FK_9d3a6fd750f7746de453cf4d5ed" FOREIGN KEY ("agentId") REFERENCES "agents" ("id") ON DELETE CASCADE, CONSTRAINT "FK_eda9e5fa5558d3f16bc2f6c21b6" FOREIGN KEY ("createdById") REFERENCES "user" ("id") ON DELETE SET NULL)
|
|
```
|
|
|
|
</details>
|
|
|
|
## Columns
|
|
|
|
| Name | Type | Default | Nullable | Children | Parents | Comment |
|
|
| ---- | ---- | ------- | -------- | -------- | ------- | ------- |
|
|
| agentId | varchar(36) | | false | | [agents](agents.md) | |
|
|
| columnMapping | TEXT | | true | | | |
|
|
| createdAt | datetime(3) | STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') | false | | | |
|
|
| createdById | varchar | | true | | [user](user.md) | |
|
|
| datasetRef | TEXT | | false | | | |
|
|
| datasetSource | varchar(32) | | false | | | |
|
|
| description | TEXT | | true | | | |
|
|
| id | varchar(36) | | false | [agent_eval_run](agent_eval_run.md) | | |
|
|
| name | varchar(128) | | false | | | |
|
|
| updatedAt | datetime(3) | STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') | false | | | |
|
|
|
|
## Constraints
|
|
|
|
| Name | Type | Definition |
|
|
| ---- | ---- | ---------- |
|
|
| - | CHECK | CHECK ("datasetSource" IN ('data_table', 'google_sheets')) |
|
|
| - (Foreign key ID: 0) | FOREIGN KEY | FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE |
|
|
| - (Foreign key ID: 1) | FOREIGN KEY | FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE |
|
|
| id | PRIMARY KEY | PRIMARY KEY (id) |
|
|
| sqlite_autoindex_agent_eval_dataset_1 | PRIMARY KEY | PRIMARY KEY (id) |
|
|
|
|
## Indexes
|
|
|
|
| Name | Definition |
|
|
| ---- | ---------- |
|
|
| IDX_9d3a6fd750f7746de453cf4d5e | CREATE INDEX "IDX_9d3a6fd750f7746de453cf4d5e" ON "agent_eval_dataset" ("agentId") |
|
|
| sqlite_autoindex_agent_eval_dataset_1 | PRIMARY KEY (id) |
|
|
|
|
## Relations
|
|
|
|
```mermaid
|
|
erDiagram
|
|
|
|
"agent_eval_dataset" }o--|| "agents" : "FOREIGN KEY (agentId) REFERENCES agents (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
|
|
"agent_eval_dataset" }o--o| "user" : "FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
|
|
"agent_eval_run" }o--|| "agent_eval_dataset" : "FOREIGN KEY (datasetId) REFERENCES agent_eval_dataset (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
|
|
|
|
"agent_eval_dataset" {
|
|
varchar_36_ agentId FK
|
|
TEXT columnMapping
|
|
datetime_3_ createdAt
|
|
varchar createdById FK
|
|
TEXT datasetRef
|
|
varchar_32_ datasetSource
|
|
TEXT description
|
|
varchar_36_ id PK
|
|
varchar_128_ name
|
|
datetime_3_ updatedAt
|
|
}
|
|
"agents" {
|
|
varchar_36_ activeVersionId FK
|
|
boolean availableInMCP
|
|
datetime_3_ createdAt
|
|
varchar_36_ id PK
|
|
TEXT integrations
|
|
varchar_128_ name
|
|
varchar_255_ projectId FK
|
|
TEXT schema
|
|
TEXT skills
|
|
TEXT tools
|
|
datetime_3_ updatedAt
|
|
varchar_36_ versionId
|
|
}
|
|
"user" {
|
|
datetime_3_ createdAt
|
|
boolean disabled
|
|
varchar_255_ email
|
|
varchar_32_ firstName
|
|
varchar id PK
|
|
date lastActiveAt
|
|
varchar_32_ lastName
|
|
boolean mfaEnabled
|
|
TEXT mfaRecoveryCodes
|
|
TEXT mfaSecret
|
|
varchar password
|
|
TEXT personalizationAnswers
|
|
varchar_128_ roleSlug FK
|
|
TEXT settings
|
|
datetime_3_ updatedAt
|
|
}
|
|
"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)
|