I have created a simple sample project test-link-delete.zip (86.0 KB)
to illustrate my problem. My project does not use the soft delete option. Entities extend BaseUuidEntity with softDelete off. I have a many to many relationship between Student and Club. But when I attempt to delete a Student that belongs to a Club, I get an error:
SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; FK_STUCLU_ON_CLUB table: TESTLINKDELETE_STUDENT_CLUB_LINK
It seems to me that I should be able to delete the Student and have it cascade to the link table. But that is not part of the foreign key. Shouldn’t this be the default functionality? Is there an option for this in Studio that I’m not seeing? Thank you.