tags

Data license: CC-BY

1 row where parentId = 1516 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

CREATE TABLE "tags" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(255) NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"parentId" INTEGER NULL  ,
	"specialType" VARCHAR(255) NULL  ,
	"slug" VARCHAR(512) NULL,
	FOREIGN KEY("parentId") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "dataset_subcategories_name_fk_dst_cat_id_6ce1cc36_uniq" ON "tags" ("name", "parentId");
CREATE INDEX "parentId" ON "tags" ("parentId");