Brave Search

stackoverflow.com › questions › 68579505 › how-to-get-enums-in-prisma-client

You can access the user_type enum in your application code like this:

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

let foo: user_type = "superadmin";
// use like any other type/enum

How you plan to connect this to the client-side or send it there is up to you. Typically Prisma types reside in the server-side of your code, not the client-side, so it might be difficult to import prisma types in your client code directly.

This is how Prisma defines the user_type enum under the hood.

// file: node_modules/.prisma/client/index.d.ts
export const user_type: {
  superadmin: 'superadmin',
  admin: 'admin',
  user: 'user'
};

You could just copy and paste this into your client-side code if you like.

Answer from Tasin Ishmam on Stack Overflow

Prisma

prisma.io › home › models › models › models › models

Models | Prisma Documentation

@map and @@map allow you to tune the shape of your Prisma Client API by decoupling model and field names from table and column names in the underlying database. The properties of a model are called fields, which consist of: ... Scalar types (includes enums) that map to columns (relational databases) or document fields (MongoDB) - for example, String or Int

Stack Overflow

stackoverflow.com › questions › 68579505 › how-to-get-enums-in-prisma-client

node.js - How to get enums in prisma client? - Stack Overflow

Top answer

1 of 3

You can access the user_type enum in your application code like this:

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

let foo: user_type = "superadmin";
// use like any other type/enum

This is how Prisma defines the user_type enum under the hood.

// file: node_modules/.prisma/client/index.d.ts
export const user_type: {
  superadmin: 'superadmin',
  admin: 'admin',
  user: 'user'
};

You could just copy and paste this into your client-side code if you like.

2 of 3

When you generate Prisma Client, it generates TypeScript interfaces for your models and enum types.

you can do

import { PrismaClient, user_type } from '@prisma/client'

and this will give you the user_type types declarations

node.js - prisma, unable to get my Enums from @prisma/client

typescript - Query Enum type on Prisma

typescript - how do I find the types to create with a Prisma client?

How do I generate Typescript types with Prisma?

typescript - Share prisma types and enums across multiple projects

More results from stackoverflow.com

Discussions

Specify value for Enum

Problem I want to add a custom value to my Enum types so I can easily provide my FE the key/value pairs for Enum types. My goal is to define an enum like this: enum AlarmTypes { FIRE_ALARM @value("... More on github.com

github.com

March 17, 2022

Enum with custom value

enum FileType { IMAGE_JPEG = "image/jpeg", IMAGE_PNG = "image/png" } PrismaJoinThe official Discord server of Prisma! More on answeroverflow.com

answeroverflow.com

January 31, 2025

Missing generated Enum in typescript definition when Enum isn't used in Prisma table

Bug description Normally, you can simply import Prisma enums as a typescript type like below: import type { MyEnum } from "@prisma/client" However, if the Enum isn't used in any Prism... More on github.com

github.com

June 12, 2024

Recommended Enum usage with Prisma and Zod

interface ItemRequestTableProps { statusFilter: ItemRequestStatusType; } I've started wondering if I should remove the Zod enum/type and simply reference the ItemRequestStatus enum generated by Prisma. More on answeroverflow.com

answeroverflow.com

June 11, 2025

Squash

squash.io › tutorial-on-prisma-enum-with-typescript

Tutorial on Prisma Enum with TypeScript - Squash Labs

October 14, 2023 - These generated types provide a ... at compile-time. Enum types in TypeScript can be used in conjunction with Prisma to define and enforce restricted sets of values for certain fields in your database schema....

Medium

medium.com › @sahiljaggrwal › clean-code-with-prisma-how-to-organize-your-schema-like-a-pro-5e1360a19dae

Organizing Prisma Schema: Splitting Models, Enums, and Types into Separate Files | by sahil jaggarwal | Medium

April 11, 2025 - // enums/role.enum.prisma enum Role { USER ADMIN MODERATOR } // models/user.model.prisma: model User { id String @id @default(auto()) @map("_id") @db.ObjectId name String email String @unique role Role } // types/profile.type.prisma type Profile { bio String website String }

GitHub

github.com › prisma › prisma › issues › 12405

Specify value for Enum · Issue #12405 · prisma/prisma

March 17, 2022 - Problem I want to add a custom value to my Enum types so I can easily provide my FE the key/value pairs for Enum types. My goal is to define an enum like this: enum AlarmTypes { FIRE_ALARM @value("Fire alarm ringing") @map("FIRE") SMOKE_...

Author prisma

Prisma

prisma.io › home › overview of prisma schema › overview of prisma schema › overview of prisma schema

Prisma schema | Prisma Documentation

datasource db { provider = "postgresql" } generator client { provider = "prisma-client" output = "./generated" } model User { id Int @id @default(autoincrement()) createdAt DateTime @default(now()) email String @unique name String? role Role @default(USER) posts Post[] } model Post { id Int @id @default(autoincrement()) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt published Boolean @default(false) title String @db.VarChar(255) author User @relation(fields: [authorId], references: [id]) authorId Int } enum Role { USER ADMIN } Prisma Schema files are written in Prisma Schema Language (PSL).

GitHub

github.com › prisma › prisma › discussions › 26084

Using Enums · prisma/prisma · Discussion #26084

Changing the schema from an enum to a text type in your Prisma model can be a practical solution if you're encountering issues with enum handling. By using a text type, you avoid potential mismatches between the Prisma enum and the PostgreSQL enum.

Author prisma

Medium

medium.com › @kemaltf_ › what-is-schema-in-prisma-1f52ddac630e

What is schema in prisma.. Attention: | by Taufik Kemal | Medium

June 23, 2023 - In Prisma, an “enum” is short for “enumeration” and is a special data type that restricts the values that can be taken by a column in a database.

Find elsewhere

Google Bing Mojeek

Prisma

prisma.io › home › schema api › schema api › schema api

Prisma Schema API | Prisma Documentation

Maps a field name or enum value from the Prisma schema to a column or document field with a different name in the database.

Answer Overflow

answeroverflow.com › m › 1334838010537185371

Enum with custom value - Prisma

January 31, 2025 - enum FileType { IMAGE_JPEG = "image/jpeg", IMAGE_PNG = "image/png" } PrismaJoinThe official Discord server of Prisma!

GitHub

github.com › prisma › prisma › issues › 24510

Missing generated Enum in typescript definition when Enum isn't used in Prisma table · Issue #24510 · prisma/prisma

June 12, 2024 - Bug description Normally, you can simply import Prisma enums as a typescript type like below: import type { MyEnum } from "@prisma/client" However, if the Enum isn't used in any Prisma table column, Prisma doesn't generate the typescript...

Author prisma

Dodatech

tutorials.dodatech.com › home › backend development › prisma › prisma enums

Learn Prisma Enums -- Enum Types in Schema and Queries – DodaTech Tutorials

1 month ago - Implement Prisma enums for type-safe fields, enum values in filters and updates, database-level enum support, and migrating enum changes.

Answer Overflow

answeroverflow.com › m › 1382210489408426037

June 11, 2025 - interface ItemRequestTableProps { statusFilter: ItemRequestStatusType; } I've started wondering if I should remove the Zod enum/type and simply reference the ItemRequestStatus enum generated by Prisma.

GitHub

github.com › prisma › prisma › discussions › 18560

array of enum · prisma/prisma · Discussion #18560

Author prisma

Top answer

1 of 1

Hi @apologeticasteroid 👋

To create a new user with one or more roles, you can pass an array of UserRoleType values when creating the user record. Here is an example of how to create an array of enum type in Prisma ORM

await prisma.user.create({
  data: {
    email: 'user@example.com',
    password: {
      create: {
        hash: 'passwordHash',
      },
    },
    roletype: [UserRoleType.ADMIN, UserRoleType.USER],
  },
});

In the above example, a new user is created with an email and password, and two roles are assigned to the user: ADMIN and USER. The roletype field is initialized with an array containing the two enum values.

RedwoodJS Community

community.redwoodjs.com › get help and help others › show & tell

How to Make SelectFields for Prisma enums in RedwoodJS - Show & Tell - RedwoodJS Community

October 6, 2022 - How to Make SelectFields for Prisma enums in RedwoodJS 👉 Demo: https://rw-office-hours-enum-select-list.netlify.app 👉 GH Repo: [redwood-office-hours/2022-10-05-enum-select-options at main · redwoodjs/redwood-office-hours · GitHub](redwood-office-hours/2022-10-05-enum-select-options at main · redwoodjs/redwood-office-hours · GitHub} The Problem Cannot get values from the enum to make a select control because Redwood generates the enum as a type -- and that m...

reddit.com › r/node › how to do this in prisma (orm)?

r/node on Reddit: How to do this in Prisma (ORM)?

December 21, 2022 -

Has anyone worked with Prisma? How could I tell a model that if it doesn't write the Role field, i by default will be "Customer"?

I get an alert if I do it like this:

: Error validating: This line is not a valid field or attribute definition.

In another ORM like Sequalize it's something like this:

  role: {
    allowNull: false,
    type: DataTypes.STRING,
    defaultValue: 'customer'
  }

This is all the model in Sequalize

const UserSchema = {
  id: {
    allowNull: false,
    autoIncrement: true,
    primaryKey: true,
    type: DataTypes.INTEGER
  },
  email: {
    allowNull: false,
    type: DataTypes.STRING,
    unique: true,
  },
  password: {
    allowNull: false,
    type: DataTypes.STRING
  },
  role: {
    allowNull: false,
    type: DataTypes.STRING,
    defaultValue: 'customer'
  },
  createdAt: {
    allowNull: false,
    type: DataTypes.DATE,
    field: 'create_at',
    defaultValue: Sequelize.NOW
  }
}