Mapping V1.0 to V2.0

[petermr]

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