foreign key stuff...not working properly yet

I'm still allowed to insert bs values into stuff that should be
cross-checked on other tables :/