how to define array relations ?
i have this pgTable
export const invite = pgTable("invite", {
id: serial("id").primaryKey(),
code: text("code").unique().notNull(),
groupId: integer("group_id").references(() => group.id, { onDelete: "cascade" }).array(),
creatorId: integer("creator_id").references(() => profile.id).notNull(),
createdAt: timestamp("created_at").defaultNow().notNull(),
updatedAt: timestamp("updated_at").defaultNow().notNull(),
});
and usually with a one to many relation, i put a 'many(group)'
but i don't know if/how drizzle requires me to specify that i'm targeting groupId
export const invite = pgTable("invite", {
id: serial("id").primaryKey(),
code: text("code").unique().notNull(),
groupId: integer("group_id").references(() => group.id, { onDelete: "cascade" }).array(),
creatorId: integer("creator_id").references(() => profile.id).notNull(),
createdAt: timestamp("created_at").defaultNow().notNull(),
updatedAt: timestamp("updated_at").defaultNow().notNull(),
});
and usually with a one to many relation, i put a 'many(group)'
but i don't know if/how drizzle requires me to specify that i'm targeting groupId
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
