Diagnostics: detecting @unique constraint on foreign-key in one-to-many relationships

[S4d3ngineer]

Suggested solution

Inform user when @unique constraint is used on foreign key.

Additional context

I believe that using @unique key in described scenario is unwanted behavior. In the example below setting @unique field on authorId field makes it impossible for User to have multiple Posts.

model User {
  id    Int    @id @default(autoincrement())
  posts Post[]
}

model Post {
  id       Int  @id @default(autoincrement())
  author   User @relation(fields: [authorId], references: [id])
  authorId Int  @unique
}

Diagnostic should detect this just as it is detects when @unique is not set on foreign key in one-to-one relationship.