div_id INT surveyed. div_desc VARCHAR region_id INT region_desc VARCHAR food ndb_no INT ndb_no Contains all foods surveyed {46 nutrients} {46 DOUBLEs} for their nutritional data. unit_conversion ndb_no INT ndb_no Contains what unit from_name VARCHAR conversions were available from_value DOUBLE from the dataset. to_name VARCHAR to_value DOUBLE food_food_group ndb_no INT ndb_no Relates foods to their food fg_id INT groups through id pairs. food_subgroup_group fsg_id INT fsg_id Relates food groups to food fg_id INT subgroups through id pairs. user_input uid INT uid Can be used to store a query date DATE date made by a particular user of time TIME time UID at a particular DATE and ndb_no INT TIME. fsg_id INT mkg_id INT price_year YEAR price_quarter INT weight_g DOUBLE visitors identifier VARCHAR identifier Can be used to track visitors, uid INT possibly for persistent statistics over time for the user.
div_id div_desc region_id region_desc INT VARCHAR INT VARCHAR surveyed. food ndb_no {46 nutrients} INT {46 DOUBLEs} ndb_no Contains all foods surveyed for their nutritional data. unit_conversion ndb_no from_name from_value to_name to_value INT VARCHAR DOUBLE VARCHAR DOUBLE ndb_no Contains what unit conversions were available from the dataset. food_food_group ndb_no fg_id INT INT ndb_no Relates foods to their food groups through id pairs. food_subgroup_group fsg_id fg_id INT INT fsg_id Relates food groups to food subgroups through id pairs. user_input uid date time ndb_no fsg_id mkg_id price_year price_quarter weight_g INT DATE TIME INT INT INT YEAR INT DOUBLE uid date time Can be used to store a query made by a particular user of UID at a particular DATE and TIME. visitors identifier uid VARCHAR INT identifier Can be used to track visitors, possibly for persistent statistics over time for the user.
FoodWaster_report.docx