public.ai_preference

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
content	text		false			Instruction text injected into AI prompts
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
createdById	uuid		true		public.user	Author. NULL after the author is deleted
id	uuid		false
projectId	varchar(36)		true		public.project	Set for a project preference. NULL otherwise
source	varchar(16)		false			Surface that wrote the row: ui (settings), aia (assistant), mcp (client)
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
userId	uuid		true		public.user	Set for a personal preference. NULL otherwise

Constraints

Name	Type	Definition
CHK_ai_preference_single_target	CHECK	CHECK ((("userId" IS NULL) OR ("projectId" IS NULL)))
CHK_ai_preference_source	CHECK	CHECK (((source)::text = ANY ((ARRAY['ui'::character varying, 'aia'::character varying, 'mcp'::character varying])::text[])))
FK_4ea340a1847ad0e40a0b0360fe4	FOREIGN KEY	FOREIGN KEY ("projectId") REFERENCES project(id) ON DELETE CASCADE
FK_aeb2ce3354b55bd61c8d7e17169	FOREIGN KEY	FOREIGN KEY ("createdById") REFERENCES "user"(id) ON DELETE SET NULL
FK_e9059770c01bfda6062d78d9f8e	FOREIGN KEY	FOREIGN KEY ("userId") REFERENCES "user"(id) ON DELETE CASCADE
PK_e7dbbeec9da3e06f6a20669e6e7	PRIMARY KEY	PRIMARY KEY (id)
ai_preference_content_not_null	n	NOT NULL content
ai_preference_createdAt_not_null	n	NOT NULL "createdAt"
ai_preference_id_not_null	n	NOT NULL id
ai_preference_source_not_null	n	NOT NULL source
ai_preference_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_4ea340a1847ad0e40a0b0360fe	CREATE INDEX "IDX_4ea340a1847ad0e40a0b0360fe" ON public.ai_preference USING btree ("projectId")
IDX_e9059770c01bfda6062d78d9f8	CREATE INDEX "IDX_e9059770c01bfda6062d78d9f8" ON public.ai_preference USING btree ("userId")
PK_e7dbbeec9da3e06f6a20669e6e7	CREATE UNIQUE INDEX "PK_e7dbbeec9da3e06f6a20669e6e7" ON public.ai_preference USING btree (id)

Relations

erDiagram

"public.ai_preference" }o--o| "public.user" : "FOREIGN KEY (#quot;createdById#quot;) REFERENCES #quot;user#quot;(id) ON DELETE SET NULL"
"public.ai_preference" }o--o| "public.project" : "FOREIGN KEY (#quot;projectId#quot;) REFERENCES project(id) ON DELETE CASCADE"
"public.ai_preference" }o--o| "public.user" : "FOREIGN KEY (#quot;userId#quot;) REFERENCES #quot;user#quot;(id) ON DELETE CASCADE"

"public.ai_preference" {
  text content
  timestamp_3__with_time_zone createdAt
  uuid createdById FK
  uuid id
  varchar_36_ projectId FK
  varchar_16_ source
  timestamp_3__with_time_zone updatedAt
  uuid userId FK
}
"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.project" {
  timestamp_3__with_time_zone createdAt
  uuid creatorId FK
  json customTelemetryTags
  varchar_512_ description
  json icon
  varchar_36_ id
  varchar_255_ name
  varchar_36_ type
  timestamp_3__with_time_zone updatedAt
}

---

Generated by tbls