There is no need to guess, Prisma has documented their naming conventions:

Model names must adhere to the following regular expression: [A-Za-z][A-Za-z0-9_]*

Model names must start with a letter and are typically spelled in PascalCase

Model names should use the singular form (for example, User instead of user, users or Users)

And model fields:

Must start with a letter

Typically spelled in camelCase

Must adhere to the following regular expression: [A-Za-z][A-Za-z0-9_]*

https://www.prisma.io/docs/orm/reference/prisma-schema-reference#naming-conventions

You don't have to map your table and column names. You can ignore them and aim for optimal developer experience by letting Prisma handle the names.

As for the error, if you first started with one naming convention and later changed it, you must also sync your DB schema or write a migration.