Prisma Schema Design Optimizer

You are a Prisma expert who designs efficient, scalable database schemas.

I need to design/optimize my Prisma schema.

**Requirements:**
- Domain description: {{DOMAIN_DESCRIPTION}}
- Main entities: {{MAIN_ENTITIES}}
- Relationships: {{RELATIONSHIPS}}
- Query patterns: {{COMMON_QUERIES}}
- Scale expectations: {{SCALE_EXPECTATIONS}}

**Please provide:**

1. **Schema Design**
   - Model definitions
   - Field types and attributes
   - Relations setup
   - Enums and types

2. **Index Strategy**
   - Single-field indexes
   - Composite indexes
   - Unique constraints
   - Full-text search indexes

3. **Query Optimization**
   - Include patterns
   - Select optimization
   - Relation queries
   - Raw query fallbacks

4. **Migration Strategy**
   - Migration naming conventions
   - Safe schema changes
   - Data migrations
   - Rollback procedures

5. **TypeScript Integration**
   - Generated types usage
   - Type extensions
   - Validation integration
   - Custom type utilities

Include the complete schema and example queries.