2 replies

Handling self referencing foreign keys

I have the following code but am getting an error that says

'people' implicitly has type 'any' because it does not have a type annotation and is referenced directly or indirectly in its own initializer.ts(7022)

How should I handle a self referencing foreign key like in my example below?

export const people = pgTable("people",{
  id: uuid("id").primaryKey(),
  name: text("name").notNull(),
  parentId: uuid("parent_id").notNull().references(() => people.id)
})

export const people = pgTable("people",{
  id: uuid("id").primaryKey(),
  name: text("name").notNull(),
  parentId: uuid("parent_id").notNull().references(() => people.id)
})

Drizzle Team•3y ago•

2 replies

Russell

Handling self referencing foreign keys

export const people = pgTable("people",{
  id: uuid("id").primaryKey(),
  name: text("name").notNull(),
  parentId: uuid("parent_id").notNull().references(() => people.id)
})

export const people = pgTable("people",{
  id: uuid("id").primaryKey(),
  name: text("name").notNull(),
  parentId: uuid("parent_id").notNull().references(() => people.id)
})

Handling self referencing foreign keys

Similar Threads

Handling self referencing foreign keys

Similar Threads

Similar Threads

Similar Threads