Tag Entity · SQLite Schema · n8n-io/n8n · Skills Docs

Skill 16 · SQLite Schema

Subchapter 16.142

Tag Entity

tag_entity.mdMarkdown2 KBView on GitHub

Description

Name	Type	Default	Nullable	Children	Parents	Comment
createdAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false
id	varchar(36)		false	folder_tag workflows_tags
name	varchar(24)		false
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

erDiagram

"folder_tag" |o--|| "tag_entity" : "FOREIGN KEY (tagId) REFERENCES tag_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"
"workflows_tags" |o--|| "tag_entity" : "FOREIGN KEY (tagId) REFERENCES tag_entity (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE"

"tag_entity" {
  datetime_3_ createdAt
  varchar_36_ id PK
  varchar_24_ name
  datetime_3_ updatedAt
}
"folder_tag" {
  varchar_36_ folderId PK
  varchar_36_ tagId PK
}
"workflows_tags" {
  INTEGER tagId PK
  varchar_36_ workflowId PK
}