4 replies

Self-Relation in Drizzle ORM?

I'm trying to create a folder/file structure in postgresql with drizzle orm
I have the following table:

export const folder = pgTable("folders", {
    id: uuid("id").primaryKey(),
    name: varchar("name", {length: 64}).notNull(),
    parent: uuid("parent").references(() => folder.id),
    owner: uuid("owner").references(() => user.id),
    color: varchar("color", {length: 7}).notNull(),
    level: integer("level").notNull(),
    createdAt: timestamp("createdAt").defaultNow().notNull(),
    updatedAt: timestamp("updatedAt").defaultNow().notNull()
})

export const folder = pgTable("folders", {
    id: uuid("id").primaryKey(),
    name: varchar("name", {length: 64}).notNull(),
    parent: uuid("parent").references(() => folder.id),
    owner: uuid("owner").references(() => user.id),
    color: varchar("color", {length: 7}).notNull(),
    level: integer("level").notNull(),
    createdAt: timestamp("createdAt").defaultNow().notNull(),
    updatedAt: timestamp("updatedAt").defaultNow().notNull()
})

but im getting this error in typescript

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

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

Sorry if I overlooked something, I'm new to drizzle

Drizzle Team•2y ago•

4 replies

piton

Self-Relation in Drizzle ORM?

I'm trying to create a folder/file structure in postgresql with drizzle orm
I have the following table:

export const folder = pgTable("folders", {
    id: uuid("id").primaryKey(),
    name: varchar("name", {length: 64}).notNull(),
    parent: uuid("parent").references(() => folder.id),
    owner: uuid("owner").references(() => user.id),
    color: varchar("color", {length: 7}).notNull(),
    level: integer("level").notNull(),
    createdAt: timestamp("createdAt").defaultNow().notNull(),
    updatedAt: timestamp("updatedAt").defaultNow().notNull()
})

export const folder = pgTable("folders", {
    id: uuid("id").primaryKey(),
    name: varchar("name", {length: 64}).notNull(),
    parent: uuid("parent").references(() => folder.id),
    owner: uuid("owner").references(() => user.id),
    color: varchar("color", {length: 7}).notNull(),
    level: integer("level").notNull(),
    createdAt: timestamp("createdAt").defaultNow().notNull(),
    updatedAt: timestamp("updatedAt").defaultNow().notNull()
})

but im getting this error in typescript

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

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

Sorry if I overlooked something, I'm new to drizzle

Self-Relation in Drizzle ORM?

Similar Threads

Self-Relation in Drizzle ORM?

Similar Threads

Similar Threads

Similar Threads