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.
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.