Prisma ORM · Schema

Define models

A model becomes a table. @id marks the primary key, @default sets defaults and @unique adds a unique index.

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  role      Role     @default(USER)
  posts     Post[]
  createdAt DateTime @default(now())
}

enum Role {
  USER
  ADMIN
}

Official Prisma ORM documentation

More schema commands

All schema commands · Prisma ORM cheatsheet

Was this page helpful?