I want to use FK as id（as a composite key） about prisma HOT 3 CLOSED

What is the Prisma context of your question? What Prisma schema do you get when you introspect your database that has that behavior?

(Aside: The SQL you are sharing does not show any foreign key, so does not match the ERD or the issue title)

from prisma.

That is not a valid Prisma schema (for multiple reasons, we do not support : after the field name and no @@unique or @@map outside of models).

Can you please clarify your issue or question? Thanks.

from prisma.

thank you for response :)
This is what it looks like when written in prisma schema.

model Areas {
  id String @id
  name String
  weatherForecasts WeatherForecasts[]
}
model WeatherForecasts{
  areas Areas @relation(fields: [areasId], references: [id], onDelete: Cascade)
  areasId String @unique @map("areas_id")
  date String
  temperature: Int
  createdAt DateTime @default(now()) @map("created_at")
  updatedAt DateTime? @updateAt @map("updated_at")
}

@@unique([date, areasId])
@@map("weather_forecasts")

from prisma.