Fix Prisma Schema MongoDB Native Type Warnings

[Community-Programmer]

Description

The Prisma schema has multiple warnings about MongoDB native type mismatches that will become errors in future Prisma versions.

Current Behavior

• Warning messages during Prisma operations
• Potential future breaking changes

Expected Behavior

• Clean Prisma schema without warnings
• Proper MongoDB native type mappings

Affected Files

• prisma/schema.prisma

Acceptance Criteria

• All Prisma warnings resolved
• Schema validation passes
• Database relationships work correctly
• No breaking changes to existing data

[Luc-ay]

I’d like to take on this issue. The Prisma schema warnings about MongoDB native type mismatches could cause compatibility problems in future versions. I’ll review the affected fields and update their definitions to match MongoDB’s expected native types (e.g., adding @db.ObjectId where required) to ensure schema stability.