Prisma Schema

Learn how the Prisma schema defines your data sources, generators, and data model. Applies to Prisma ORM v7.

Generators in your Prisma schema specify what assets are generated when the prisma generate command is invoked. This page explains how to configure generators. Applies to Prisma ORM v7.

Learn how the Prisma schema defines your data sources, generators, and data model. Applies to Prisma ORM v6.

Generators in your Prisma schema specify what assets are generated when the prisma generate command is invoked. This page explains how to configure generators. Applies to Prisma ORM v6.

Documentation regarding proper location of Prisma Schema including default naming and multiple files. Applies to Prisma ORM v6.

Learn about the concepts for building your data model with Prisma: Models, scalar types, enums, attributes, functions, IDs, default values and more. Applies to Prisma ORM v7.

Learn about the concepts for building your data model with Prisma: Models, scalar types, enums, attributes, functions, IDs, default values and more. Applies to Prisma ORM v6.

A relation is a connection between two models in the Prisma schema. This page explains how you can define one-to-one, one-to-many and many-to-many relations in Prisma. Applies to Prisma ORM v7.

Circular references or multiple cascade paths can cause validation errors on Microsoft SQL Server and MongoDB. Since the database does not handle these situations out of the box, learn how to solve this problem. Applies to Prisma ORM v7.

Manage relations between records with relation modes in Prisma. Applies to Prisma ORM v7.

A relation is a connection between two models in the Prisma schema. This page explains how you can define one-to-one, one-to-many and many-to-many relations in Prisma. Applies to Prisma ORM v6.

How to define and work with one-to-one relations in Prisma. Applies to Prisma ORM v6.

How to define and work with one-to-many relations in Prisma. Applies to Prisma ORM v6.

How to define and work with many-to-many relations in Prisma. Applies to Prisma ORM v6.

How to define and work with self-relations in Prisma. Applies to Prisma ORM v6.

Referential actions let you define the update and delete behavior of related models on the database level. Applies to Prisma ORM v6.

Circular references or multiple cascade paths can cause validation errors on Microsoft SQL Server and MongoDB. Since the database does not handle these situations out of the box, learn how to solve this problem. Applies to Prisma ORM v6.

Manage relations between records with relation modes in Prisma. Applies to Prisma ORM v6.

How to include views in your Prisma schema. Applies to Prisma ORM v7.

How to use Prisma ORM with multiple database schemas. Applies to Prisma ORM v7.

How to declare and use externally managed tables in Prisma ORM. Applies to Prisma ORM v7.

How to include views in your Prisma schema. Applies to Prisma ORM v6.

How to use Prisma ORM with multiple database schemas. Applies to Prisma ORM v6.

How to declare and use externally managed tables in Prisma ORM. Applies to Prisma ORM v6.

Learn how you can introspect your database to generate a data model into your Prisma schema. Applies to Prisma ORM v6.

How to install and manage PostgreSQL extensions with Prisma ORM using customized migrations, and how to use them in Prisma Client. Applies to Prisma ORM v6.

Learn how you can introspect your database to generate a data model into your Prisma schema. Applies to Prisma ORM v7.

How to install and manage PostgreSQL extensions with Prisma ORM using customized migrations, and how to use them in Prisma Client. Applies to Prisma ORM v7.