example001SchemaMapping

===[ locale ]===
id___acronym___description________________________________________
0____en_US_____American English___________________________________
1____en_GB_____British English____________________________________

===[ food_group ]===
id___
0____
1____
2____
3____
4____

===[ food_group_details ]===
id___loc___description__________________________________________________________
0____0_____Dairy and Egg Products_______________________________________________
0____1_____Dairy and Egg Products_______________________________________________
1____0_____Spices and Herbs_____________________________________________________
1____1_____Spices and Herbs_____________________________________________________
2____0_____Baby Foods___________________________________________________________
2____1_____Baby Foods___________________________________________________________
3____0_____Fats and Oils________________________________________________________
3____1_____Fats and Oils________________________________________________________
4____0_____Poultry Products_____________________________________________________
4____1_____Poultry Products_____________________________________________________

===[ food_name ]===
id___
0____
1____
2____
3____
4____
5____
6____
7____
8____
9____

===[ food_name_details ]===
id___loc___description__________________________________
0____0_____Butter, salted_______________________________
0____1_____Butter, salted_______________________________
1____0_____Butter, whipped, with salt___________________
1____1_____Butter, whipped, with salt___________________
2____0_____Cheese, blue_________________________________
2____1_____Cheese, blue_________________________________
3____0_____Cheese, brick________________________________
3____1_____Cheese, brick________________________________
4____0_____Cheese, camembert____________________________
4____1_____Cheese, camembert____________________________
5____0_____Cheese, caraway______________________________
5____1_____Cheese, caraway______________________________
6____0_____Cheese, cheddar______________________________
6____1_____Cheese, cheddar______________________________
7____0_____Cheese, cheshire_____________________________
7____1_____Cheese, cheshire_____________________________
8____0_____Milk shakes, thick chocolate_________________
8____1_____Milk shakes, thick chocolate_________________
9____0_____Milk shakes, thick vanilla___________________
9____1_____Milk shakes, thick vanilla___________________

===[ food ]===
id___name_id___carbohydrate_factor___fat_factor___protein_factor___nitrogen_protein_factor___
0____0_________8.87__________________1.89_________4.27_____________2.38______________________
1____1_________1.87__________________2.79_________3.27_____________8.38______________________
2____2_________3.87__________________4.59_________9.27_____________4.38______________________
3____3_________8.87__________________6.79_________5.27_____________4.38______________________
4____4_________3.87__________________2.79_________6.27_____________5.38______________________
5____5_________3.89__________________8.79_________6.27_____________6.36______________________
6____6_________3.12__________________8.13_________4.22_____________6.33______________________
7____7_________3.13__________________0.79_________4.67_____________4.78______________________
8____8_________1.87__________________3.79_________0.27_____________8.38______________________
9____9_________3.87__________________3.69_________8.97_____________3.98______________________

===[ group_of_food ]===
group_id___food_id___
0__________0_________
0__________2_________
0__________3_________
0__________4_________
0__________5_________
0__________6_________
0__________7_________
2__________8_________
2__________9_________
3__________1_________