Sorry for the late response Here is the whole schema:

model Event {
  evt_id           String        @id @default(uuid())
  evt_title        String
}

model Organization {
  org_id             String             @id @default(uuid())
  org_name           String
}

And here is the request that fails

const newEvent = await prisma.event.create({
                data: {
                    evt_title: parsedCreateEventSchema.evt_title
                },
            })

as you can see, I am just requesting to create an object, so the id should be calculated without any issue. I have a similar request for the Organizations model that just works fine, this is strange... I have seen other people having the same issue online, but no fix sadly 😞 @Raphael Etim

Also, this is the error I get:

61 try {
→  62     const newEvent = await prisma.event.create(
  Unique constraint failed on the fields: (`evt_id`)

Did you add random records with an id or did you import records and manually set the id on each row?

This is a github discussion link that addresses this similar issue

Actually, I added a relation between the events and the organizations The link from event is

evt_organizer    Organization  @relation(fields: [evt_id], references: [org_id])

and from the organizer its

org_events         Event[]

I guess the evt_id is the same as the org_id (which is an uuid) So the first can be created, but since the org can have many events, I can't create another one (it will have the org_id as evt_id, but it is already in use by the first event)

I need to figure out a way to change this

In fact I need my evt_id to be a proper uuid, not the same as the org's one

The thing was that my relation was wrong