set all foreign key relationships