datasets

Data license: CC-BY

25 rows where metadataEditedByUserId = 18 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, isArchived, createdAt (date), updatedAt (date), metadataEditedAt (date), dataEditedAt (date)

CREATE TABLE "datasets" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NOT NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"namespace" VARCHAR(255) NOT NULL  ,
	"isPrivate" TINYINT NOT NULL DEFAULT '0' ,
	"createdByUserId" INTEGER NOT NULL  ,
	"metadataEditedAt" DATETIME NOT NULL  ,
	"metadataEditedByUserId" INTEGER NOT NULL  ,
	"dataEditedAt" DATETIME NOT NULL  ,
	"dataEditedByUserId" INTEGER NOT NULL  ,
	"nonRedistributable" TINYINT NOT NULL DEFAULT '0' ,
	"isArchived" TINYINT NOT NULL DEFAULT '0' ,
	"sourceChecksum" VARCHAR(64) NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"version" VARCHAR(255) NULL  ,
	"updatePeriodDays" INTEGER NULL,
	FOREIGN KEY("createdByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("dataEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("metadataEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "datasets_createdByUserId" ON "datasets" ("createdByUserId");
CREATE INDEX "datasets_dataEditedByUserId" ON "datasets" ("dataEditedByUserId");
CREATE INDEX "datasets_metadataEditedByUserId" ON "datasets" ("metadataEditedByUserId");
CREATE UNIQUE INDEX "unique_short_name_version_namespace" ON "datasets" ("shortName", "version", "namespace");