tags
Data license: CC-BY
1 row where parentId = 1517 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | createdAt | updatedAt | parentId | specialType | slug |
---|---|---|---|---|---|---|
375 | Uncategorized | 2017-03-07 18:53:07 | 2022-09-27 14:11:36 | System 1517 | uncategorized |
Advanced export
JSON shape: default, array, newline-delimited, object
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");