search

micronutrientsupport / database-architecture

The Postgres database code for the MAPS tool
3 stars 0 forks source link

Report FCT_source_id for each micronutrient used #318

Closed rbroth closed 1 year ago

rbroth commented 2 years ago

When matching food consumption data to food composition data (FCTs), we choose the "best" FCT per micronutrient. We also want to report which FCT was used e.g. "This meal of cassava contained Xmg of Vitamin C, as per Food Comp. Table #33, and Ymg of Vitamin d, as per FCT #11".

Previously, we reported only one Food Composition table used (in view household_intake). This, and dependent views, will have to be modified.

bgsandan commented 1 year ago

Resolved in hierarchical match algorithm