mirror of
https://github.com/n8n-io/n8n.git
synced 2026-10-17 13:39:44 +02:00
122 lines
4.5 KiB
Markdown
Generated
122 lines
4.5 KiB
Markdown
Generated
# skill_version
|
|
|
|
## Description
|
|
|
|
<details>
|
|
<summary><strong>Table Definition</strong></summary>
|
|
|
|
```sql
|
|
CREATE TABLE "skill_version" ("id" varchar PRIMARY KEY NOT NULL, "skillId" varchar(36) NOT NULL, "version" integer NOT NULL, "name" varchar(128) NOT NULL, "description" varchar(1024) NOT NULL, "instructions" text NOT NULL, "frontmatter" text, "contentHash" varchar(64) NOT NULL, "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 "UQ_93bb78a1eb4e0890fac6b69df95" UNIQUE ("skillId", "version"), CONSTRAINT "CHK_skill_version_version" CHECK ("version" > 0), CONSTRAINT "FK_f87064c0a29efd2d5195328d91a" FOREIGN KEY ("skillId") REFERENCES "skill" ("id") ON DELETE CASCADE, CONSTRAINT "FK_9565d0fbf32cd463f9b47c7adab" FOREIGN KEY ("createdById") REFERENCES "user" ("id") ON DELETE SET NULL)
|
|
```
|
|
|
|
</details>
|
|
|
|
## Columns
|
|
|
|
| Name | Type | Default | Nullable | Children | Parents | Comment |
|
|
| ---- | ---- | ------- | -------- | -------- | ------- | ------- |
|
|
| contentHash | varchar(64) | | false | | | |
|
|
| createdAt | datetime(3) | STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') | false | | | |
|
|
| createdById | varchar | | true | | [user](user.md) | |
|
|
| description | varchar(1024) | | false | | | |
|
|
| frontmatter | TEXT | | true | | | |
|
|
| id | varchar | | false | [agent_skill_dependency](agent_skill_dependency.md) [agent_version_skill_dependency](agent_version_skill_dependency.md) [skill_file](skill_file.md) | | |
|
|
| instructions | TEXT | | false | | | |
|
|
| name | varchar(128) | | false | | | |
|
|
| skillId | varchar(36) | | false | | [skill](skill.md) | |
|
|
| updatedAt | datetime(3) | STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW') | false | | | |
|
|
| version | INTEGER | | false | | | |
|
|
|
|
## Constraints
|
|
|
|
| Name | Type | Definition |
|
|
| ---- | ---- | ---------- |
|
|
| - | CHECK | CHECK ("version" > 0) |
|
|
| - (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 (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE |
|
|
| id | PRIMARY KEY | PRIMARY KEY (id) |
|
|
| sqlite_autoindex_skill_version_1 | PRIMARY KEY | PRIMARY KEY (id) |
|
|
| sqlite_autoindex_skill_version_2 | UNIQUE | UNIQUE (skillId, version) |
|
|
|
|
## Indexes
|
|
|
|
| Name | Definition |
|
|
| ---- | ---------- |
|
|
| sqlite_autoindex_skill_version_1 | PRIMARY KEY (id) |
|
|
| sqlite_autoindex_skill_version_2 | UNIQUE (skillId, version) |
|
|
|
|
## Relations
|
|
|
|
```mermaid
|
|
erDiagram
|
|
|
|
"skill_version" }o--o| "user" : "FOREIGN KEY (createdById) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE SET NULL MATCH NONE"
|
|
"agent_skill_dependency" }o--o| "skill_version" : "FOREIGN KEY (skillVersionId) REFERENCES skill_version (id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE"
|
|
"agent_version_skill_dependency" }o--|| "skill_version" : "FOREIGN KEY (skillVersionId) REFERENCES skill_version (id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE"
|
|
"skill_file" |o--|| "skill_version" : "FOREIGN KEY (skillVersionId) REFERENCES skill_version (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
|
|
"skill_version" }o--|| "skill" : "FOREIGN KEY (skillId) REFERENCES skill (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
|
|
|
|
"skill_version" {
|
|
varchar_64_ contentHash
|
|
datetime_3_ createdAt
|
|
varchar createdById FK
|
|
varchar_1024_ description
|
|
TEXT frontmatter
|
|
varchar id PK
|
|
TEXT instructions
|
|
varchar_128_ name
|
|
varchar_36_ skillId FK
|
|
datetime_3_ updatedAt
|
|
INTEGER version
|
|
}
|
|
"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_skill_dependency" {
|
|
varchar_36_ agentId PK
|
|
datetime_3_ createdAt
|
|
varchar_36_ skillId PK
|
|
varchar skillVersionId FK
|
|
}
|
|
"agent_version_skill_dependency" {
|
|
varchar_36_ agentVersionId PK
|
|
datetime_3_ createdAt
|
|
varchar_36_ skillId PK
|
|
varchar skillVersionId FK
|
|
}
|
|
"skill_file" {
|
|
TEXT content
|
|
datetime_3_ createdAt
|
|
varchar_512_ path PK
|
|
varchar skillVersionId PK
|
|
datetime_3_ updatedAt
|
|
}
|
|
"skill" {
|
|
varchar_36_ agentId FK
|
|
datetime_3_ createdAt
|
|
varchar createdById FK
|
|
varchar_36_ id PK
|
|
varchar_36_ projectId FK
|
|
varchar_16_ source
|
|
datetime_3_ updatedAt
|
|
}
|
|
```
|
|
|
|
---
|
|
|
|
> Generated by [tbls](https://github.com/k1LoW/tbls)
|