export const ProductTag = pgTable(
"product_tag",
{
id: bigserial("id", { mode: "number" }),
product_id: integer("product_id").notNull(),
tag_id: integer("tag_id").notNull()
},
(table) => ({
product_tag_tag_id_product_id_idx: index(
"product_tag_tag_id_product_id_idx"
).on(table.tag_id, table.product_id),
product_tag_product_id_tag_id_idx: index(
"product_tag_product_id_tag_id_idx"
).on(table.product_id, table.tag_id),
})
);
export const ProductTagRelations = relations(ProductTag, ({ many, one }) => ({
product: one(Product, {
fields: [ProductTag.product_id],
references: [Product.id],
}),
tag: one(Tag, {
fields: [ProductTag.tag_id],
references: [Tag.slug],
}),
}));
export const ProductTag = pgTable(
"product_tag",
{
id: bigserial("id", { mode: "number" }),
product_id: integer("product_id").notNull(),
tag_id: integer("tag_id").notNull()
},
(table) => ({
product_tag_tag_id_product_id_idx: index(
"product_tag_tag_id_product_id_idx"
).on(table.tag_id, table.product_id),
product_tag_product_id_tag_id_idx: index(
"product_tag_product_id_tag_id_idx"
).on(table.product_id, table.tag_id),
})
);
export const ProductTagRelations = relations(ProductTag, ({ many, one }) => ({
product: one(Product, {
fields: [ProductTag.product_id],
references: [Product.id],
}),
tag: one(Tag, {
fields: [ProductTag.tag_id],
references: [Tag.slug],
}),
}));