Schema + client

Auth only needs two models: people, and the short-lived tokens we email them.

prisma/schema.prisma

model User {
  id           String   @id @default(cuid())
  email        String   @unique
  passwordHash String
  name         String?
  isVerified   Boolean  @default(false)
  createdAt    DateTime @default(now())
  tokens       EmailToken[]
}

model EmailToken {
  id        String    @id @default(cuid())
  token     String    @unique
  purpose   String    // "verify" | "reset"
  expiresAt DateTime
  usedAt    DateTime?
  createdAt DateTime  @default(now())
  userId    String
  user      User      @relation(fields: [userId], references: [id], onDelete: Cascade)
}

npx prisma db push
npx prisma generate

db push creates the tables on Neon. generate builds the client your code imports.

src/db.ts

import { PrismaClient } from "@prisma/client";

export const prisma = new PrismaClient();

One shared client for the whole app. Import prisma in routes — don't open a fresh connection every request.