> My expectation now is that when deleting player '1' from table 'players', the group assignment for player '1' in 'game_group_members' should be deleted as well, due to the 'ON DELETE CASCADE' constraint. The *enforcement* of foreign keys is *off* by default (IIRC, for historical compatibility reasons). It can be turned on, however: <https://sqlite.org/pragma.html#pragma_foreign_keys>