never mind i found https://www.prisma.io/docs/guides/database/advanced-database-tasks/cascading-deletes/postgresql

Note the message at the start - with Prisma 3.x most of that should not be necessary any more.