Drizzle Studio : There is not enough information to infer relation

Question

I'm trying to launch drizzle studio but I get the following error :

Error: There is not enough information to infer relation "restaurantsTable.categories"

What have I done wrong ?

schema.ts

export const restaurantsTable = pgTable("restaurants", {
  id: serial("id").primaryKey(),
  [...]
});

export const restaurantTableRelations = relations(restaurantsTable, ({ one, many }) => ({
  menu: many(menuTable),
  categories: many(categoryTable, { relationName: 'categories' }),
}));

export const categoryTable = pgTable("categories", {
  id: serial("id").primaryKey(),
  restaurant_id: integer('restaurant_id').notNull()
});

export const categoryTableRelations = relations(categoryTable, ({ one }) => ({
  menu: one(menuTable, {
    fields: [categoryTable.restaurant_id],
    references: [menuTable.id],
    relationName: 'menu'
  })
}));

Rami Maalouf · Accepted Answer · 2023-12-03 14:13:31Z

21

Faced the same issue, turns out they're strict on defining the relationName on both sides as mentioned in here

Ensuring it's defined on both sides solved my issue

answered Dec 3, 2023 at 14:13

Rami Maalouf

3111 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Drizzle Studio : There is not enough information to infer relation

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related