fixed venture foreign keys