SQL

CREATE TABLE "Account"  (
  "id" TEXT NOT NULL PRIMARY KEY,
  "userId" TEXT NOT NULL,
  "type" TEXT NOT NULL,
  "provider" TEXT NOT NULL,
  "providerAccountId" TEXT NOT NULL,
  "refresh_token" TEXT,
  "access_token" TEXT,
  "expires_at" INTEGER,
  "token_type" TEXT,
  "scope" TEXT,
  "id_token" TEXT,
  "session_state" TEXT,
  CONSTRAINT "Account_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ read-only
userId TEXT read-only
type TEXT read-only
provider TEXT read-only
providerAccountId TEXT read-only
refresh_token TEXT ✓ read-only
access_token TEXT ✓ read-only
expires_at INTEGER ✓ read-only
token_type TEXT ✓ read-only
scope TEXT ✓ read-only
id_token TEXT ✓ read-only
session_state TEXT ✓ read-only

Foreign Keys

Column Destination
userId User.id

Indexes

Name Columns Unique SQL Drop?
Account_provider_providerAccountId_key
  • provider
  • providerAccountId
 ✓ SQL 
CREATE UNIQUE INDEX "Account_provider_providerAccountId_key"
ON "Account"("provider", "providerAccountId")
read-only
sqlite_autoindex_Account_1 id ✓ SQL
-- no sql found --
 read-only