Drizzle TeamDT
Drizzle Team•3y ago
McPizza

Relationships: Self one-one & one-many

I have a table called convoMessages
Trying to add a self relation of one to one
But also a self relation of one to many

Drizzle Studio is throwing an error of
Error: There are multiple relations between "convoMessages" and "convo_messages". Please specify relation name

I would have thought this syntax is fine:
replies: many(convoMessages),
replyTo: one(convoMessages, {
fields: [convoMessages.replyToId],
references: [convoMessages.id]
}),
image.png
Was this page helpful?