Database scheme (select proper primary keys)

[xtracko]

Design a database schema and present it in form of a diagram. The diagram can later serve as a documentation of our future tools.

Currently, we are considering of storing these attributes: SMILES, inchi, common_name, systematic_name, monoisotopic_mass, formula, pathway_association.

Initially, the database schema was presented as one big table but I don't think it will be feasible and we must divide it to 2-3 tables.