PrismaP
Prisma•2y ago•
2 replies
Carlos

I need help with my schema, it doesn’t let me migrate

Hello, I get this error when trying to migrate to my remote database:

Error: P3006

Migration 20240827190544_fix_relations failed to apply cleanly to the shadow database.
Error:
ERROR: foreign key constraint "SubCategory_categoryId_fkey" cannot be implemented
DETAIL: Key columns "categoryId" and "id" are of incompatible types: text and uuid.
0: sql_schema_connector::validate_migrations
with namespaces=None
at schema-engine/connectors/sql-schema-connector/src/lib.rs:325
1: schema_core::state::DevDiagnostic
at schema-engine/core/src/state.rs:276

model Account {
id String @id @default(uuid()) @db.Uuid
name String
balance Float @default(0.0)
userId String @db.Uuid
user User @relation(fields: [userId], references: [id])
transactions Transaction[]
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt

@@index([userId])
}

model Category {
id String @id @default(uuid()) @db.Uuid // Primary key
name String @unique // Unique index on the name field
subCategories SubCategory[] // Relationship to SubCategory
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
transactions Transaction[]
description String? // Optional description field

@@index([name]) // Optional: Index on the name field
}

i am barely new to prisma but I don’t understand what is wrong here
Was this page helpful?