Fix Db

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