Currently V1.0 consists of 2 files, for which I suggest actions:
info_p a list of plant and their attributes.
Typically:
key species location year biblio title authors jrnl family habit
JEAcakoprtu2002Roo Acorus calamus Konyo Province,Turkey 1997 VOL. 14,366-368 (Sep/Oct 2002) Volatile Constituents of the Essential Oil of Acorus calamus L. Growth in Konya Province (Turkey). M. Ozcan,A. Akgul,J.C Chalchat. Journal of Essential Oil Research Acoraceae Plant
The key links the two tables and must be preserved during the conversion process. It has no essential role in the future.
The essential fields are:
species => speciestable
location => locationtable
year+biblio+title+authors+jrnl => bibliotable
*family is derivative from species
habit becomes obsolete
It is critical that all three essential fields get unique identifiers so that when creating th V2.0 tables no information is lost.
ACTION create tables and identifiers for plant , location, biblio
info_c a list of compounds and attributes.
Typically:
key compound cas percent plantpart analytical formula chemclass activity Planttype Normal?? systemname
JEMlofl2007Lea 1,8-cineole 470-82-6 3.2 leaf GC-FID and GC/MS C10H18O monoterpene derivative NA Plant Normal 2,2,4-trimethyl-3-oxabicyclo[2.2.2]octane
Currently V1.0 consists of 2 files, for which I suggest actions:
info_pa list of plant and their attributes.Typically:
The key links the two tables and must be preserved during the conversion process. It has no essential role in the future.
The essential fields are:
*
familyis derivative fromspecieshabitbecomes obsoleteIt is critical that all three essential fields get unique identifiers so that when creating th V2.0 tables no information is lost.
ACTION create tables and identifiers for
plant,location,biblioinfo_ca list of compounds and attributes.Typically: