SQLite Web: dev.db

SQL

CREATE TABLE "Session"  (
  "id" TEXT NOT NULL PRIMARY KEY,
  "sessionToken" TEXT NOT NULL,
  "userId" TEXT NOT NULL,
  "expires" DATETIME NOT NULL,
  CONSTRAINT "Session_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)

Columns

Column	Data type	Primary key	Actions
`id`	`TEXT`	✓	read-only
`sessionToken`	`TEXT`		read-only
`userId`	`TEXT`		read-only
`expires`	`DATETIME`		read-only

Foreign Keys

Column	Destination
`userId`	`User.id`

Indexes

Name	Columns	Unique	SQL	Drop?
Session_sessionToken_key	`sessionToken`	✓	SQL CREATE UNIQUE INDEX "Session_sessionToken_key" ON "Session"("sessionToken")	read-only
sqlite_autoindex_Session_1	`id`	✓	SQL -- no sql found --	read-only