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

Skill 16 · SQLite Schema

Subchapter 16.44

Annotation Tag Entity

annotation_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(16)		false	execution_annotation_tags
name	varchar(24)		false
updatedAt	datetime(3)	STRFTIME(‘%Y-%m-%d %H:%M:%f’, ‘NOW’)	false

Name	Definition
IDX_ae51b54c4bb430cf92f48b623f	CREATE UNIQUE INDEX “IDX_ae51b54c4bb430cf92f48b623f” ON “annotation_tag_entity” (“name”)
sqlite_autoindex_annotation_tag_entity_1	PRIMARY KEY (id)

erDiagram

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

"annotation_tag_entity" {
  datetime_3_ createdAt
  varchar_16_ id PK
  varchar_24_ name
  datetime_3_ updatedAt
}
"execution_annotation_tags" {
  INTEGER annotationId PK
  varchar_24_ tagId PK
}