figured out why foreign keys were not being enforced.