DT

Drizzle Team•2y ago

Nelson Sousa

How to reference the same table in the table's definition?

I am defining this table menuItemmenuItem and I want this table to support multi-levels, so I am adding a parentIdparentId column that should reference this own column

id

id

. How should I do it with Drizzle ORM?

My attempt failed with a TypeScript error, as you can see in the printscreen. I am using postgres, if that matters.

Thank you!