Схема БД для хранения датасетов оценки агентов
Документация схемы БД n8n для таблицы agent_eval_dataset: хранение датасетов, источники, маппинг колонок, связь с агентами и прогонами.
Документация схемы БД n8n для таблицы agent_eval_dataset: хранение датасетов, источники, маппинг колонок, связь с агентами и прогонами.
Можно использовать как референс для проектирования собственной схемы хранения тестовых наборов и результатов оценки агентов: структура с columnMapping и datasetSource подходит для реализации A/B-тестирования и регрессионного контроля качества AI-решений.
расшифровка ролика ↓
Title:
URL Source: https://raw.githubusercontent.com/n8n-io/n8n/master/docs/generated/postgres-schema/public.agent_eval_dataset.md
Markdown Content: # public.agent_eval_dataset
## Columns
| Name | Type | Default | Nullable | Children | Parents | Comment | | ---- | ---- | ------- | -------- | -------- | ------- | ------- | | agentId | varchar(36) | | false | | [public.agents](public.agents.md) | | | columnMapping | json | | true | | | Maps dataset columns onto input / expectedOutput / criteria roles | | createdAt | timestamp(3) with time zone | CURRENT_TIMESTAMP(3) | false | | | | | createdById | uuid | | true | | [public.user](public.user.md) | | | datasetRef | json | | false | | | Pointer into the dataset backend (e.g. { dataTableId }); shape varies by datasetSource | | datasetSource | varchar(32) | | false | | | Dataset backend the cases are read from | | description | text | | true | | | | | id | varchar(36) | | false | [public.agent_eval_run](public.agent_eval_run.md) | | | | name | varchar(128) | | false | | | | | updatedAt | timestamp(3) with time zone | CURRENT_TIMESTAMP(3) | false | | | |
## Constraints
| Name | Type | Definition | | ---- | ---- | ---------- | | CHK_agent_eval_dataset_datasetSource | CHECK | CHECK ((("datasetSource")::text = ANY ((ARRAY['data_table'::character varying, 'google_sheets'::character varying])::text[]))) | | FK_9d3a6fd750f7746de453cf4d5ed | FOREIGN KEY | FOREIGN KEY ("agentId") REFERENCES agents(id) ON DELETE CASCADE | | FK_eda9e5fa5558d3f16bc2f6c21b6 | FOREIGN KEY | FOREIGN KEY ("createdById") REFERENCES "user"(id) ON DELETE SET NULL | | PK_ac887efbb3580a577f1442cfa89 | PRIMARY KEY | PRIMARY KEY (id) | | agent_eval_dataset_agentId_not_null | n | NOT NULL "agentId" | | agent_eval_dataset_createdAt_not_null | n | NOT NULL "createdAt" | | agent_eval_dataset_datasetRef_not_null | n | NOT NULL "datasetRef" | | agent_eval_dataset_datasetSource_not_null | n | NOT NULL "datasetSource" | | agent_eval_dataset_id_not_null | n | NOT NULL id | | agent_eval_dataset_name_not_null | n | NOT NULL name | | agent_eval_dataset_updatedAt_not_null | n | NOT NULL "updatedAt" |
## Indexes
| Name | Definition | | ---- | ---------- | | IDX_9d3a6fd750f7746de453cf4d5e | CREATE INDEX "IDX_9d3a6fd750f7746de453cf4d5e" ON public.agent_eval_dataset USING btree ("agentId") | | PK_ac887efbb3580a577f1442cfa89 | CREATE UNIQUE INDEX "PK_ac887efbb3580a577f1442cfa89" ON public.agent_eval_dataset USING btree (id) |
## Relations
```mermaid erDiagram
"public.agent_eval_dataset" }o--|| "public.agents" : "FOREIGN KEY (#quot;agentId#quot;) REFERENCES agents(id) ON DELETE CASCADE" "public.agent_eval_dataset" }o--o| "public.user" : "FOREIGN KEY (#quot;createdById#quot;) REFERENCES #quot;user#quot;(id) ON DELETE SET NULL" "public.agent_eval_run" }o--|| "public.agent_eval_dataset" : "FOREIGN KEY (#quot;datasetId#quot;) REFERENCES agent_eval_dataset(id) ON DELETE CASCADE"
"public.agent_eval_dataset" { varchar_36_ agentId FK json columnMapping timestamp_3__with_time_zone createdAt uuid createdById FK json datasetRef varchar_32_ datasetSource text description varchar_36_ id varchar_128_ name timestamp_3__with_time_zone updatedAt } "public.agents" { varchar_36_ activeVersionId FK boolean availableInMCP timestamp_3__with_time_zone createdAt varchar_36_ id json integrations varchar_128_ name varchar_255_ projectId FK json schema timestamp_3__with_time_zone setupCompletedAt json skills json tools timestamp_3__with_time_zone updatedAt varchar_36_ versionId } "public.user" { timestamp_3__with_time_zone createdAt boolean disabled varchar_255_ email varchar_32_ firstName uuid id date lastActiveAt varchar_32_ lastName boolean mfaEnabled text mfaRecoveryCodes text mfaSecret varchar_255_ password json personalizationAnswers varchar_128_ roleSlug FK json settings timestamp_3__with_time_zone updatedAt } "public.agent_eval_run" { varchar_36_ agentVersionId boolean cancelRequested timestamp_3__with_time_zone completedAt timestamp_3__with_time_zone createdAt uuid createdById FK varchar_36_ datasetId FK varchar_255_ errorCode json errorDetails varchar_36_ id json metrics timestamp_3__with_time_zone runAt varchar_255_ runningInstanceId varchar status timestamp_3__with_time_zone updatedAt } ```
---
> Generated by [tbls](https://github.com/k1LoW/tbls)