Fix DB

Fix Database Schema Errors

Fix Prisma schema compilation errors according to code conventions.

FORBIDDEN

NEVER use:

• Prisma enum types (use String with TypeScript union types instead)

Purpose

Fix compilation errors in Prisma schema files to ensure npm run build:prisma passes.

Workflow

┌─────────────────────────────────────┐
│  Step 1: Run Build                  │
│  npm run build:prisma               │
└───────────────┬─────────────────────┘
                │
                ▼
┌─────────────────────────────────────┐
│  Step 2: Parse Errors               │
│  - Syntax errors                    │
│  - Relation errors                  │
│  - Type errors                      │
└───────────────┬─────────────────────┘
                │
                ▼
┌─────────────────────────────────────┐
│  Step 3: Fix by Convention          │
│  Apply code conventions             │
└───────────────┬─────────────────────┘
                │
                ▼
┌─────────────────────────────────────┐
│  Step 4: Re-run Build               │
│  Loop until 0 errors                │
└─────────────────────────────────────┘

Step 1: Run Build

npm run build:prisma 2>&1

Capture all error output.

Step 2: Parse Errors

Common error types:

• Error parsing attribute: Syntax error in decorator
• Error validating field: Invalid field type
• Error validating relation: Missing or invalid relation

Step 3: Fix by Convention

Primary Key Convention

// Standard
id String @id @db.Uuid

Timestamp Convention

created_at DateTime @db.Timestamptz
updated_at DateTime @db.Timestamptz
deleted_at DateTime? @db.Timestamptz

Foreign Key Convention

{parent}_id String @db.Uuid
{parent} {prefix}_{parents} @relation(fields: [{parent}_id], references: [id], onDelete: Cascade)

Union Type Fields (NOT enum)

// DO NOT use Prisma enum
status String  // "active" | "inactive" defined in TypeScript

// WRONG - Never do this
// enum Status { ACTIVE INACTIVE }

Self-referential Relation

parent_id String? @db.Uuid
parent {Model}? @relation("recursive", fields: [parent_id], references: [id], onDelete: Cascade)
children {Model}[] @relation("recursive")

Index Convention

@@index([{parent}_id, status])
@@index([name(ops: raw("gin_trgm_ops"))], type: Gin)

Step 4: Verify

npm run build:prisma

Repeat Steps 2-4 until no errors.

Common Fixes

Exit Condition

• npm run build:prisma completes with no errors
• All models properly defined
• All relations valid