search

gilienv / EssOilDB

Restructuring of Essential Oil Database
Apache License 2.0
8 stars 6 forks source link

infocdata. #63

Open ambarishK opened 4 years ago

ambarishK commented 4 years ago

This one is the main table of the database i.e profile table.

column header -

-icoid -ipid -coid -percentage -ppid -expcid -expmid

petermr commented 4 years ago

REFACTOR

TABLE composition or profiledata This is the chemical data associated with a profile

COLUMNS composition_id profile_id (FK) compound_id (FK) percent (NUMBER) or maybe range plantPart_id (FK) => MOVE to PROFILE condition_id (FK) => MOVE to PROFILE method_id (FK) => MOVE to PROFILE

method VARCHAR not normalized