[#110] Change shooter foreign key to competitor

Shooting is recorded through Competitor reference not Shooter. Foreign key had to be changed.