Relations on non unique fields

model Contents {
  id         Int
  language   Languages
  content    String
  content_id Int
  type       ContentType
  challenges_names Challenges[] @relation("challenges_name_content")
  challenges_logo Challenges[] @relation("challenges_logo_content")
  challenges_badges Challenges[] @relation("challenges_badge_content")
  challenges_chapters_name Challenges_Chapters[]

  @@id([id])
  @@index([content_id])
  @@schema("system")
  @@unique([content_id, language])
}

model Challenges {
  id Int
  name_content Contents @relation("challenges_name_content", fields: [name_content_id], references: [content_id])  
  name_content_id Int
  logo_content Contents @relation("challenges_logo_content", fields: [logo_content_id], references: [content_id])
  logo_content_id Int
  badge_content Contents @relation("challenges_badge_content", fields: [badge_content_id], references: [content_id])
  badge_content_id Int
  color String
  secondary_color String
  super_challenge_json Json[]
  countries Json[]

  chapters Challenges_Chapters[]

  @@id([id])

  @@schema("system")
}