users

Data license: CC-BY

70 rows sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: isSuperuser, isActive, lastLogin (date), createdAt (date), updatedAt (date), lastSeen (date)

CREATE TABLE "users" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"password" VARCHAR(128) NULL  ,
	"lastLogin" DATETIME NULL  ,
	"isSuperuser" TINYINT NOT NULL DEFAULT '0' ,
	"email" VARCHAR(255) NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"isActive" TINYINT NOT NULL DEFAULT '1' ,
	"fullName" VARCHAR(255) NOT NULL  ,
	"lastSeen" DATETIME NULL
);
CREATE UNIQUE INDEX "email" ON "users" ("email");