public.agent_eval_rating

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
comment	text		true
correction	json		true			Optional corrected/edited output supplied by the rater
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
id	varchar(36)		false
ratedById	uuid		true		public.user
resultId	varchar(36)		false		public.agent_eval_result
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
vote	varchar(8)		false			Human feedback direction

Constraints

Name	Type	Definition
CHK_agent_eval_rating_vote	CHECK	CHECK (((vote)::text = ANY ((ARRAY['up'::character varying, 'down'::character varying])::text[])))
FK_9cadae6591c64498f1b58a2cef3	FOREIGN KEY	FOREIGN KEY ("resultId") REFERENCES agent_eval_result(id) ON DELETE CASCADE
FK_e06a7408573a3e152e673977d2c	FOREIGN KEY	FOREIGN KEY ("ratedById") REFERENCES "user"(id) ON DELETE SET NULL
PK_04b7709a435e0c07520ceb37393	PRIMARY KEY	PRIMARY KEY (id)
agent_eval_rating_createdAt_not_null	n	NOT NULL "createdAt"
agent_eval_rating_id_not_null	n	NOT NULL id
agent_eval_rating_resultId_not_null	n	NOT NULL "resultId"
agent_eval_rating_updatedAt_not_null	n	NOT NULL "updatedAt"
agent_eval_rating_vote_not_null	n	NOT NULL vote

Indexes

Name	Definition
IDX_9cadae6591c64498f1b58a2cef	CREATE INDEX "IDX_9cadae6591c64498f1b58a2cef" ON public.agent_eval_rating USING btree ("resultId")
PK_04b7709a435e0c07520ceb37393	CREATE UNIQUE INDEX "PK_04b7709a435e0c07520ceb37393" ON public.agent_eval_rating USING btree (id)

Relations

erDiagram

"public.agent_eval_rating" }o--o| "public.user" : "FOREIGN KEY (#quot;ratedById#quot;) REFERENCES #quot;user#quot;(id) ON DELETE SET NULL"
"public.agent_eval_rating" }o--|| "public.agent_eval_result" : "FOREIGN KEY (#quot;resultId#quot;) REFERENCES agent_eval_result(id) ON DELETE CASCADE"

"public.agent_eval_rating" {
  text comment
  json correction
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  uuid ratedById FK
  varchar_36_ resultId FK
  timestamp_3__with_time_zone updatedAt
  varchar_8_ vote
}
"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_result" {
  timestamp_3__with_time_zone completedAt
  timestamp_3__with_time_zone createdAt
  varchar_255_ errorCode
  json errorDetails
  varchar_36_ id
  json input
  json metrics
  json output
  timestamp_3__with_time_zone runAt
  varchar_36_ runId FK
  integer runIndex
  varchar_255_ sourceRowId
  varchar status
  json toolCalls
  timestamp_3__with_time_zone updatedAt
  json verdict
}

---

Generated by tbls