user have one profile and profile have one user
model User {
id Int @id @default(autoincrement())
email String @unique
profile Profile?
}
model Profile {
name String
gender String
age String
// it should be @unique coz we want one Profile only reference one User
userId Int @unique
user User @relation(fields: [userId], refrences: [id])
}
one-to-one relation with multi fields
model User {
firstName String
lastName String
profile Profile?
@@id([firstName, lastName])
}
model Profile {
name String
gender String
age String
userFirstName String
userLastName String
user User @relation(fields: [userFirstName, userLastName], refrences: [firstName, lastName])
@@unique([userFirstName, userLastName])
}