some of the foreign key constraints are added