I have Users, Roles and a many-to-many between them (userroles table).
Users have validRoles and Roles have validUsers. Neither has
CascadeType specified. To my surprise, when I delete a Role, it
deletes from userroles as well. The database has cascade "no action"
on userroles.roleid and userroles.userid.
Why are records in userroles being deleted?