Inserting records into related tables

export const product = mysqlTable('product', {
    id: serial('id').primaryKey(),
    name: varchar('name', { length: 256 }),
    description: varchar('description', { length: 256 }),
});

export const productVariant = mysqlTable('product_variant', {
    id: serial('id').primaryKey(),
    productId: int('product_id'),
    name: varchar('name', { length: 256 }),
    description: varchar('description', { length: 256 }),
});

export const variantAsset = mysqlTable('variant_asset', {
    id: serial('id').primaryKey(),
    variantId: int('variant_id'),
    assetName: varchar('asset_name', { length: 256 })
});

const newProduct = await db.insert(product).values({
  name: 'Product name',
  description: 'Product description',
});

const newProductVariant = await db.insert(productVariant).values({
 ** productId: newProduct.insertId**,
  name: 'Variant name',
  description: 'Variant description',
});

const newVariantAsset = await db.insert(variantAsset).values({
 ** variantId: newProductVariant.insertId,**
  assetName: 'Asset Name',
});