SQL

CREATE TABLE "User"  (
  "id" TEXT NOT NULL PRIMARY KEY,
  "name" TEXT NOT NULL,
  "email" TEXT NOT NULL,
  "password" TEXT NOT NULL,
  "role" TEXT NOT NULL DEFAULT 'EMPLOYEE',
  "teamId" TEXT,
  "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  "updatedAt" DATETIME NOT NULL,
  CONSTRAINT "User_teamId_fkey" FOREIGN KEY ("teamId") REFERENCES "Team" ("id") ON DELETE SET NULL ON UPDATE CASCADE
)

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ read-only
name TEXT read-only
email TEXT read-only
password TEXT read-only
role TEXT read-only
teamId TEXT ✓ read-only
createdAt DATETIME read-only
updatedAt DATETIME read-only

Foreign Keys

Column Destination
teamId Team.id

Indexes

Name Columns Unique SQL Drop?
User_email_key email ✓ SQL 
CREATE UNIQUE INDEX "User_email_key"
ON "User"("email")
read-only
sqlite_autoindex_User_1 id ✓ SQL
-- no sql found --
 read-only