考虑以下简明模式文件：

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["fieldReference"]
}

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}

model User {
  id            String         @id @default(cuid())
  name          String
  nickname      String?        @unique
  bobId         String?        @unique
  email         String         @unique
  emailVerified DateTime?
  image         String?        @db.VarChar(500)
  title         String?
  description   String?        @db.VarChar(500)
  Reviews       Reviews[]
  ReviewImages  ReviewImages[]
}

model Restaurants {
  id        String   @id @db.VarChar(50)
  poi_nm    String   @db.VarChar(100)
  branch_nm String?  @db.VarChar(100)
  sub_nm    String?  @db.VarChar(100)
  mcate_cd  String?  @db.VarChar(30)
  mcate_nm  String?  @db.VarChar(200)
  pnu       String?  @db.VarChar(30)
  sido_nm   String?  @db.VarChar(100)
  sgg_nm    String?  @db.VarChar(100)
  bemd_nm   String?  @db.VarChar(100)
  ri_nm     String?  @db.VarChar(100)
  beonji    String?  @db.VarChar(20)
  badm_cd   String?  @db.VarChar(30)
  hadm_cd   String?  @db.VarChar(30)
  rd_cd     String?  @db.VarChar(30)
  rd_nm     String?  @db.VarChar(100)
  bld_num   String?  @db.VarChar(30)
  grid_cd   String?  @db.VarChar(30)
  origin    String?  @db.VarChar(200)
  base_ymd  String?  @db.VarChar(20)
  createdAt DateTime @default(now())
  // loc       Unsupported("point")

  Reviews      Reviews[]
  ReviewImages ReviewImages[]

  // @@index(loc, map: "loc")
}

model Reviews {
  id           String      @unique @default(cuid())
  user         User        @relation(fields: [userId], references: [id])
  userId       String      @db.VarChar(255)
  restaurant   Restaurants @relation(fields: [restaurantId], references: [id])
  restaurantId String      @db.VarChar(50)
  title        String      @db.VarChar(300)
  titleLink    String      @unique @db.VarChar(500)
  content      String      @db.Text
  preview      String      @db.VarChar(255)
  createdAt    DateTime    @default(now())
  updatedAt    DateTime    @updatedAt

  ReviewImages ReviewImages[]

  @@id([userId, restaurantId])
}

model ReviewImages {
  id           String      @id @default(cuid())
  urls         String      @db.Text
  user         User        @relation(fields: [userId], references: [id])
  userId       String
  review       Reviews     @relation(fields: [reviewId], references: [id], onDelete: Cascade)
  reviewId     String
  restaurant   Restaurants @relation(fields: [restaurantId], references: [id])
  restaurantId String
  createdAt    DateTime    @default(now())
  updatedAt    DateTime    @updatedAt
}

这个剧本

import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient({
  log: ['query'],
});

async function main() {
  await prisma.user.deleteMany();

  await prisma.user.create({
    data: {
      email: 'test@prisma.io',
      name: 'Test',
      id: '1',
    },
  });

  await prisma.restaurants.create({
    data: {
      id: '1',
      poi_nm: 'test',
    },
  });

  await prisma.reviews.create({
    data: {
      title: 'test',
      content: 'test',
      preview: 'test',
      titleLink: 'test',
      restaurantId: '1',
      userId: '1',
      ReviewImages: {
        create: {
          urls: 'test',
          userId: '1',
          restaurantId: '1',
        },
      },
    },
  });
}

main()
  .catch((e) => {
    throw e;
  })
  .finally(async () => {
    await prisma.$disconnect();
  });

我能够删除审查记录，ReviewImage确实通过Prisma Studio删除。
我会建议您更新到最新的Prisma版本，以防您仍然面临这个问题。