Hi, just starting out with Prisma. Is it possible ...
# orm-helpn
Naresh Bhatia
10/29/2021, 2:22 AMHi, just starting out with Prisma. Is it possible to model a one-to-one relationship with the same PK in both tables? The examples in docs produce a FK in one table pointing to a PK in another.
r
Ryan
10/29/2021, 7:09 AM@Naresh Bhatia 👋
Do you mean more than a single one-to-one relationship pointing to the same PK?
Ryan
10/29/2021, 7:10 AMn
Naresh Bhatia
10/29/2021, 2:50 PMHi @Ryan, I meant a single one-to-one relation which would generate something like this:
Copy code
CREATE TABLE "User" (
id SERIAL PRIMARY KEY
);
CREATE TABLE "Profile" (
id SERIAL PRIMARY KEY,
FOREIGN KEY ("id") REFERENCES "User"(id)
);Naresh Bhatia
10/30/2021, 4:55 AMHi @Ryan, digging deeper what if I write my schema like this:
Copy code
model User {
id String @id @default(uuid())
name String
}
model Profile {
id String @id
picture String
} Copy code
// Create a User
const user = prisma.user.create({
data: { name: 'John Smith' }
})
// Create a profile for the user
// Note that profile.id = user.id
const profile = prisma.profile.create({
data: { id: user.id, picture: 'https://...' }
})r
Ryan
11/01/2021, 7:05 AMYes the fetching will be more complicated. Why not use a foreign key type approach directly instead. That would make it much easier.
✅ 1