I wonder what the nutrient_incoming_name table is used for. In particular, it is unclear to me what ‘incoming nutrient data’ are. Are these synonyms for the nutrients used by USDA? Is the file meant to make connections of nutrients from other databases to USDA nutrients?
For example, there are these 15 entries for protein (nutrient_id=1003):
PROTEIN (N X 5.70) D
PROTEIN (N X 6.38) D
PROTEIN(N X 6.25)DUM
Protein - Kjeldahl
PROTEIN(N X 6.25)DUMAS
PROTEIN (N X 5.70) DUMAS
PROTEIN (N X 6.38) DUMAS
Protein - Combustion (N X 6.25)
PROTEIN (N X 5.46) DUMAS
Protein (N x 6.25) Dumas Method
Protein (N x 6.38) Dumas Method
Protein (N x 5.30) Dumas Method
So, will both ‘PROTEIN(N X 6.25)DUMAS’ and ‘Protein (N x 5.30) Dumas Method’ be assigned the same nutrient_id even though they were multiplied by different factors? So if a nutrient in another database has one of these 15 names for protein, does it get converted to the nutrient_id=1003 in the USDA database?