Polymorphic Association

export const products = pgTable('products', {
    id: serial().primaryKey(),
    name: text().notNull(),
    slug: text().notNull().unique(),
    // VDE: SKU-Code, Cla-Val: Model
    model: text().notNull(),
    brand: text().notNull(),
    // VDE Product does not have a description
    description: text(),
    categoryId: integer('category_id').notNull(),
    keySpecs: json('key_specs').$type<Record<string, string>>().notNull().default({}),
    specifications: json().$type<Record<string, string>>().notNull().default({}),
    createdAt: timestamp('created_at', { precision: 3, mode: 'date' }).notNull().defaultNow(),
    updatedAt: timestamp('updated_at', { precision: 3, mode: 'date' })
        .notNull()
        .defaultNow()
        .$onUpdateFn(() => new Date())
})

export const productsRelations = relations(products, ({ one, many }) => ({
    category: one(categories, {
        fields: [products.categoryId],
        references: [categories.id]
    }),
    images: many(images, {
        relationName: 'productImages',
        condition
    })
}))

export const mediaOwnerType = pgEnum('media_owner_type', ['product', 'category'])

export const images = pgTable(
    'images',
    {
        id: serial().primaryKey(),
        url: text().notNull(),
        name: varchar({ length: 256 }).notNull(),
        position: integer().notNull().default(0),
        bytes: integer().notNull(),
        ownerId: integer('owner_id').notNull(),
        ownerType: mediaOwnerType('owner_type').notNull(),
        createdAt: timestamp('created_at', { precision: 3, mode: 'date' }).notNull().defaultNow(),
        updatedAt: timestamp('updated_at', { precision: 3, mode: 'date' })
            .notNull()
            .defaultNow()
            .$onUpdateFn(() => new Date())
    },
    t => [index('owner_position_idx').on(t.ownerId, t.ownerType, t.position)]
)