When you face the problem bigserial doesn't exist when giving it in prisma datatype then

Run the command npx prisma migrate dev --create only

It will generate a migration.sql file inside the generated file changed all BIGSERIAL to BIGINT

And now run the command npx prisma migrate dev