Example idempotent creation with Prisma

create.ts

// Suppose createData includes all the other required fields,
// and idempotencyKey is received as part of the request payload.

await this.prisma.ctrPayrollCompensation.upsert({
    where: { idempotencyKey },
    create: { ...createData, idepotencyKey },
    update: {}, // Update nothing
});