annotation_tag_entity¶

Description¶

Table Definition

CREATE TABLE "annotation_tag_entity" ("id" varchar(16) PRIMARY KEY NOT NULL, "name" varchar(24) NOT NULL, "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')))

Columns¶

Name	Type	Default	Nullable	Children
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

Constraints¶

Name	Type	Definition
id	PRIMARY KEY	PRIMARY KEY (id)
sqlite_autoindex_annotation_tag_entity_1	PRIMARY KEY	PRIMARY KEY (id)

Indexes¶

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

Relations¶

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
}

Generated by tbls