public.skill_version

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
contentHash	varchar(64)		false			sha256 of name, description, instructions, frontmatter and files. Save creates no version when the content matches the latest one
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
createdById	uuid		true		public.user	Author. NULL after the author is deleted
description	varchar(1024)		false
frontmatter	json		true			SKILL.md frontmatter fields other than name and description, e.g. allowed-tools
id	uuid		false	public.agent_skill_dependency public.agent_version_skill_dependency public.skill_file
instructions	text		false
name	varchar(128)		false			Free-text skill name, as it was when this version was saved
skillId	varchar(36)		false		public.skill
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
version	integer		false			1..n per skill. A Save that changes the content adds one; none ever changes

Constraints

Name	Type	Definition
CHK_skill_version_version	CHECK	CHECK ((version > 0))
FK_9565d0fbf32cd463f9b47c7adab	FOREIGN KEY	FOREIGN KEY ("createdById") REFERENCES "user"(id) ON DELETE SET NULL
FK_f87064c0a29efd2d5195328d91a	FOREIGN KEY	FOREIGN KEY ("skillId") REFERENCES skill(id) ON DELETE CASCADE
PK_05167d59ac7599128e22400172d	PRIMARY KEY	PRIMARY KEY (id)
UQ_93bb78a1eb4e0890fac6b69df95	UNIQUE	UNIQUE ("skillId", version)
skill_version_contentHash_not_null	n	NOT NULL "contentHash"
skill_version_createdAt_not_null	n	NOT NULL "createdAt"
skill_version_description_not_null	n	NOT NULL description
skill_version_id_not_null	n	NOT NULL id
skill_version_instructions_not_null	n	NOT NULL instructions
skill_version_name_not_null	n	NOT NULL name
skill_version_skillId_not_null	n	NOT NULL "skillId"
skill_version_updatedAt_not_null	n	NOT NULL "updatedAt"
skill_version_version_not_null	n	NOT NULL version

Indexes

Name	Definition
PK_05167d59ac7599128e22400172d	CREATE UNIQUE INDEX "PK_05167d59ac7599128e22400172d" ON public.skill_version USING btree (id)
UQ_93bb78a1eb4e0890fac6b69df95	CREATE UNIQUE INDEX "UQ_93bb78a1eb4e0890fac6b69df95" ON public.skill_version USING btree ("skillId", version)

Relations

erDiagram

"public.skill_version" }o--o| "public.user" : "FOREIGN KEY (#quot;createdById#quot;) REFERENCES #quot;user#quot;(id) ON DELETE SET NULL"
"public.agent_skill_dependency" }o--o| "public.skill_version" : "FOREIGN KEY (#quot;skillVersionId#quot;) REFERENCES skill_version(id)"
"public.agent_version_skill_dependency" }o--|| "public.skill_version" : "FOREIGN KEY (#quot;skillVersionId#quot;) REFERENCES skill_version(id)"
"public.skill_file" }o--|| "public.skill_version" : "FOREIGN KEY (#quot;skillVersionId#quot;) REFERENCES skill_version(id) ON DELETE CASCADE"
"public.skill_version" }o--|| "public.skill" : "FOREIGN KEY (#quot;skillId#quot;) REFERENCES skill(id) ON DELETE CASCADE"

"public.skill_version" {
  varchar_64_ contentHash
  timestamp_3__with_time_zone createdAt
  uuid createdById FK
  varchar_1024_ description
  json frontmatter
  uuid id
  text instructions
  varchar_128_ name
  varchar_36_ skillId FK
  timestamp_3__with_time_zone updatedAt
  integer version
}
"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_skill_dependency" {
  varchar_36_ agentId FK
  timestamp_3__with_time_zone createdAt
  varchar_36_ skillId FK
  uuid skillVersionId FK
}
"public.agent_version_skill_dependency" {
  varchar_36_ agentVersionId FK
  timestamp_3__with_time_zone createdAt
  varchar_36_ skillId FK
  uuid skillVersionId FK
}
"public.skill_file" {
  text content
  timestamp_3__with_time_zone createdAt
  varchar_512_ path
  uuid skillVersionId FK
  timestamp_3__with_time_zone updatedAt
}
"public.skill" {
  varchar_36_ agentId FK
  boolean availableToAssistant
  timestamp_3__with_time_zone createdAt
  uuid createdById FK
  varchar_36_ id
  varchar_36_ projectId FK
  varchar_16_ source
  timestamp_3__with_time_zone updatedAt
}

---

Generated by tbls