Hi guys I have following setup

model Snippet {

id           String      @id @default(uuid())

title        String

user         _User_        @relation(fields: [_userId_], references: [_id_])

userId       String

technology   _Technology_  @relation(fields: [_technologyId_], references: [_id_])

technologyId String

createdAt    DateTime    @default(now())

updatedAt    DateTime    @updatedAt

Visibility   _Visibility_? @relation(fields: [_visibilityId_], references: [_id_])

visibilityId String?

Tag          _Tag_[]

}

model Tag {

id        String   @id @default(uuid())

name      String

createdAt DateTime @default(now())

updatedAt DateTime @updatedAt

Snippet   _Snippet_? @relation(fields: [_snippetId_], references: [_id_])

snippetId String?

}

Running the migration afterwards like

pnpm prisma migrate dev

Gives me following error: Error: P3006 Migration

20220623223220_update_relation_for_snippet_and_tags

failed to apply cleanly to the shadow database. Error:

db error: ERROR: foreign key constraint "Snippet_tagId_fkey" cannot be implemented

DETAIL: Key columns "tagId" and "id" are of incompatible types: text[] and text.

0: sql_migration_connector::validate_migrations

at migration-engine/connectors/sql-migration-connector/src/lib.rs:272

1: migration_core::state::DevDiagnostic

at migration-engine/core/src/state.rs:250