indexed all foreign keys and species names