Foodb Database Schema Information
foods
Food table that contains external ids, identifiers, etc. The id is food_id
for mapping in contents table
Field Name | Description | Data Type |
---|---|---|
name | Food common name (may be different naming convention in different countries and areas) | string |
name_scientific | Food scientific name. It's a good source for mapping the food | string |
description | Manual written description | text |
public_id | Foodb ID (i.e. it is not food_id that used for mapping in contents table) |
string |
contents
Association between foods table with compounds and nutrients table. Mapping based on source_id
in food_id
Field Name | Description | Data Type |
---|---|---|
source_id | Depends on source_type, it either maps with compound id or nutrient id | integer |
source_type | Nutrient OR Compound | string |
food_id | Food id (i.e. not food public id) | integer |
orig_food_common_name | The original name of the food content (e.g. Coffee, instant, powder) | string |
orig_min, orig_max | minimal concentration of source_id in food_id |
decimal |
orig_content | Either average of origin_min and origin_max; or directly draw from paper and literature | decimal |
orig_unit | Unit (e.g. mg/100g) | decimal |
compounds
This table contains information about compounds, which include the compound properties, external ids, identifiers
Field Name | Description | Data Type |
---|---|---|
public_id | FDB_ID (e.g. FDB000004) | string |
name | compound name | string |
export | 1: currently used in foodb database; 2: current not used in foodb database (safe to ignore) | boolean (1 or 2) |
description | Manual written or computer generated compound description | text |
status | 0: quantified; 1: detected; 2: expected; 3: predicted | integer |
nutrients
This table contains information about nutrients, which include external ids and identifiers
Field Name | Description | Data Type |
---|---|---|
name | Nutrient name | string |
description | Nutrient description | string |
public_id | Foodb nutrient id (i.e. different from nutrient_id ) |
string |