search

gilienv / EssOilDB

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

Inconsistency in `pfid` in `tables/plant/import` table #89

Open petermr opened 4 years ago

petermr commented 4 years ago 
pid pname   scientificName (gbif)   Normalized name Details pfid    phid    Error   kingdom phylum  class   order   family  genus   species     Synonym 

...

4   Abies sachalinensis Abies sachalinensis Mast.   Abies sachalinensis Mast.   71  1       Plantae Tracheophyta    Pinopsida   Pinales Pinaceae    Abies   Abies sachalinensis     #N/A
5   Acacia caven    Acacia caven (Molina) Molina    Acacia caven    (Molina) Molina 19  1       Plantae Tracheophyta    Magnoliopsida   Fabales Fabaceae    Vachellia   Vachellia caven     Vachellia caven GBIF 2685484

What is pfid? Is it documented anywhere? We need documentation attached to this table. If it means "plant family id" then the rows above have inconsistent values for pfid and family

ACTION do we need pfid at all? It can be deduced from the species

Shruthi-M commented 4 years ago

Greetings Sir! pfid is a foreign key to the previous family table. According to me, pfid does not have to be included in the table as the family is specifically mentioned.