adding series as a foreign key on the event