Error: unable to delete candidates because of assistant foreign key

```
Error: ER_ROW_IS_REFERENCED_2: Cannot delete or update a parent row: a foreign key constraint
fails (`elections`.`assistants`, CONSTRAINT `assistant_fk1` FOREIGN KEY (`candidate_rcs_id`)
REFERENCES `candidates` (`rcs_id`) ON DELETE NO ACTION ON UPDATE NO ACTION)
```
