"There's not enough information to infer relation"

export const userRoomsRelations = relations(
userRoomsTable,
({ one, many }) => ({
owner: one(usersTable, {
fields: [userRoomsTable.ownerId],
references: [usersTable.id]
}),
furniture: many(placedFurnitureTable),
homeMetadata: one(homesMetadataTable, {
fields: [userRoomsTable.id],
references: [homesMetadataTable.roomId]
}),
farmMetadata: one(farmsMetadataTable, {
fields: [userRoomsTable.id],
references: [farmsMetadataTable.roomId]
}),
})
);
export const userRoomsRelations = relations(
userRoomsTable,
({ one, many }) => ({
owner: one(usersTable, {
fields: [userRoomsTable.ownerId],
references: [usersTable.id]
}),
furniture: many(placedFurnitureTable),
homeMetadata: one(homesMetadataTable, {
fields: [userRoomsTable.id],
references: [homesMetadataTable.roomId]
}),
farmMetadata: one(farmsMetadataTable, {
fields: [userRoomsTable.id],
references: [farmsMetadataTable.roomId]
}),
})
);
I'm getting the error in the title when opening Drizzle Studio. I'm sure it's because of this relation I just added, but I can't tell what's wrong
2 Replies
⚡Z.E.U.S⚡
⚡Z.E.U.S⚡7d ago
Hey @pato ! Did you add relations for other tables too?
pato
patoOP7d ago
yes eventually i discovered thats what i had to do not that it made much sense to me but yeah

Did you find this page helpful?