observation table

[petermr]

Will need discussion with Gita. Currently looks like:

observation. The primary scientific record extracted from the literature. Will contain:

• plant

• plant parts

• compound List

• percentages (these two will be coupled in some way)

• location

• bibliographic record

• conditions

• year of experiment (probably a field)

[petermr]

Plant+plantPart should be primary. key for observation

[petermr]

Suggest that "condition" is a freeform attribute. Then normalize to controlled vocabulary (e.g. "hydrodistillation")

[petermr]

Looks like some of this is "sample treatment". maybe a separate table for this.