做营养管理系统基础数据整理sql文件.zip

INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (1, '名 称', NULL, '可食部分', '能量', '水分', '蛋白质', '脂肪', '膳食纤维', '碳水化物', NULL, '维生素B1', '维生素B2', '烟酸', '维生素E', '钠', '钙', '铁', '类别', '维生素C', NULL, '胆固醇', NULL, 2147483647, '2023-03-05 13:30:47.843312', '2023-03-05 13:30:47.843412', 0, '维生素A'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (2, '大黄米（黍）', NULL, '100', '349', '11.3', '13.6', '2.7', '3.5', '67.6', NULL, '0.3', '0.09', '1.4', '1.79', '1.7', '30', '5.7', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:47.881466', '2023-03-05 13:30:47.881543', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (3, '大麦（元麦）', NULL, '100', '307', '13.1', '10.2', '1.4', '9.9', '63.4', NULL, '0.14', '0.05', '5', '0.25', '1.6', '13', '5.1', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:47.914403', '2023-03-05 13:30:47.914496', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (4, '稻谷（早籼）', NULL, '64', '359', '10.2', '9.9', '2.2', '1.4', '74.8', NULL, '0.14', '0.05', '5', '0.25', '1.6', '13', '5.1', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:47.954260', '2023-03-05 13:30:47.954330', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (5, '稻米（大米）', NULL, '100', '346', '13.3', '7.4', '0.8', '0.7', '77.2', NULL, '0.11', '0.05', '1.9', '0.46', '3.8', '13', '2.3', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:47.986109', '2023-03-05 13:30:47.986166', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (6, '稻米（粳，特级）', NULL, '100', '334', '16.2', '7.3', '0.4', '0.4', '75.3', NULL, '0.08', '0.04', '1.1', '0.76', '6.2', '24', '0.9', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:48.016115', '2023-03-05 13:30:48.016168', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (7, '稻米（粳，标一）', NULL, '100', '343', '13.7', '7.7', '0.6', '0.6', '76.8', NULL, '0.16', '0.08', '1.3', '1.01', '2.4', '11', '1.1', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:48.045736', '2023-03-05 13:30:48.045787', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (8, '稻米（粳，标二）', NULL, '100', '348', '13.2', '8', '0.6', '0', '77.7', NULL, '0.22', '0.05', '2.6', '0.53', '0.9', '3', '0.4', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:48.080818', '2023-03-05 13:30:48.080843', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (9, '稻米（粳，标三）', NULL, '100', '345', '13.9', '7.2', '0.8', '0.4', '77.2', NULL, '0.33', '0.03', '3.6', '0.38', '1.3', '5', '0.7', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:48.110989', '2023-03-05 13:30:48.111005', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (10, '稻米（粳，标四）', NULL, '100', '346', '13.1', '7.5', '0.7', '0.7', '77.4', NULL, '0.14', '0.05', '5.2', '0.39', '1.6', '4', '0.7', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:48.142447', '2023-03-05 13:30:48.142458', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (11, '稻米（早籼，特等）', NULL, '100', '346', '12.9', '9.1', '0.6', '0.7', '76', NULL, '0.13', '0.03', '1.6', '0', '1.3', '6', '0.9', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:48.173210', '2023-03-05 13:30:48.173220', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (12, '稻米（早籼，标一）', NULL, '100', '351', '12.3', '8.8', '1', '0.4', '76.8', NULL, '0.16', '0.05', '2', '0', '1.9', '10', '1.2', '11', '0', NULL, '0', NULL, 2147483647, '2023-03-05 13:30:48.202602', '2023-03-05 13:30:48.202613', 0, '0'); INSERT INTO `FoodComposition` (`id`, `name`, `region`, `edible_part`, `energy`, `water`, `protein`, `fat`, `dietary_fiber`, `carbohydrate`, `retinol_equivalent`, `thiamine`, `riboflavin`, `niacin`, `vitamin_e`, `sodium`, `calcium`, `iron`, `category`, `vitamin_c`, `subclass`, `cholesterol`, `volume_ml`, `order`, `create_time`, `update_time`, `del_flag`, `vitamin_A`) VALUES (13, '稻米�