Prisma•16mo ago

Native types for enums

Hi,
I would like to add a native type to an enum field. Like that :

enum Role {
  USER
  ADMIN
}
model User {
  role Role @db.VarChar(191)
}

enum Role {
  USER
  ADMIN
}
model User {
  role Role @db.VarChar(191)
}

But when I do a

prisma generate

prisma generate

I get the following error :

Attribute not known: "@db.VarChar".

Attribute not known: "@db.VarChar".

Are native types supported for enums?

RaphaelEtim•8/23/24, 8:58 AM

Hi @Baptiste Marchand

Native types are not supported for enum fields. Native type attributes like can only be applied to scalar fields, not enums.

Baptiste MarchandOP•8/23/24, 9:17 AM

Ok thank you for your answer.

FYI, having this feature would be helpful to migrate Prisma 1 codebases where enums are stored as strings.

RaphaelEtim•8/23/24, 12:12 PM

Can you please take a look at this upgrade guide from Prisma 1

Problems and workarounds for Prisma 1 and 2.0 schemas with PostgreSQL