I have a type named Order. and there is a field named status which is an enum., I checked the postgres database, the status field is not there. Does prisma store that somewhere else?

I think prisma create a custome type in db

I connected to the postgres instance using dbeaver. I can't find any table which stores those enum values.

in dbeaver extend your public schema then Data Types, you'll see defined enums there