Manage inchikeys in pubchem table
We have to deal with the duality inchikey vs inchikey_pubchem in the table pubchem. We should always work with the field inchikey but this field is not unique. Along with @mduran, we think that a possible solution would be to create a table that merge inchikey entries in the pubchem table to a unique entry that would also have a name and a list of CIDs. We need to see how to deal with synonyms. To create this new table this web could help us: https://www.ebi.ac.uk/unichem/
I'll start testing this possibility.