[Feature] - Soft delete relations

[Chkhikvadzeg]

export const prisma = new PrismaClient({
  log: ["error"],
});

const allModelNames = Object.keys(Prisma.ModelName).reduce((acc, key) => {
  acc[key] = true;
  return acc;
}, {} as Record<string, boolean>);

prisma.$use(
  createSoftDeleteMiddleware({
    models: allModelNames, // configuration to include all models in soft delete middleware
    defaultConfig: {
      field: "deletedAt",
      allowToOneUpdates: true,
      createValue: (deleted) => {
        if (deleted) return new Date();
        return null;
      },
    },
  })
);

All of the models in my application have translations relation for my multilanguage app. I will provide an example below:

model School {
  id String @id @default(uuid())

  abbreviation String @unique

  schoolDean   User   @relation(fields: [schoolDeanId], references: [id], onDelete: Cascade)
  schoolDeanId String

  programs          Program[]
  academicCalendars AcademicCalendar[]
  translations      SchoolTranslation[] // one to many relation

  deletedAt DateTime?
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
}

model SchoolTranslation {
  id String @id @default(uuid())

  name String

  language   Language @relation(fields: [languageId], references: [id], onDelete: Cascade)
  languageId String

  school   School @relation(fields: [schoolId], references: [id], onDelete: Cascade)
  schoolId String

  deletedAt DateTime?
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt

  @@unique([name, languageId])
}

Is there any way to soft delete the schoolTranslations rows too when deleting school?