export const ProductTable = pgTable(
'product',
{
id: serial('id').primaryKey().unique(),
categoryId: integer('category_id').references(() => CategoryTable.id),
...
},
(table) => {
return {
nameIdx: index('name_idx').on(table.name),
};
},
);
export const ProductRelations = relations(ProductTable, ({ one, many }) => ({
category: one(CategoryTable, {
fields: [ProductTable.categoryId],
references: [CategoryTable.id]
}),
images: many(ProductImageTable),
}));
export const ProductTable = pgTable(
'product',
{
id: serial('id').primaryKey().unique(),
categoryId: integer('category_id').references(() => CategoryTable.id),
...
},
(table) => {
return {
nameIdx: index('name_idx').on(table.name),
};
},
);
export const ProductRelations = relations(ProductTable, ({ one, many }) => ({
category: one(CategoryTable, {
fields: [ProductTable.categoryId],
references: [CategoryTable.id]
}),
images: many(ProductImageTable),
}));