95 lines
5.0 KiB
SQL
95 lines
5.0 KiB
SQL
-- 种子数据：常用食物热量库
|
|
-- 主食类
|
|
INSERT IGNORE INTO food_library (name,category,heat,unit,unit_weight,nature,note) VALUES
|
|
('米饭','主食',116,'碗',200,'平','1碗约200克'),
|
|
('白粥','主食',46,'碗',300,'平','1碗约300克'),
|
|
('馒头','主食',223,'个',100,'平','1个约100克'),
|
|
('全麦面包','主食',246,'片',40,'平','1片约40克'),
|
|
('白面包','主食',265,'片',40,'平','1片约40克'),
|
|
('红薯','主食',86,'个',200,'平','1个中等约200克'),
|
|
('玉米(甜)','主食',112,'根',200,'平','1根约200克，推荐晚餐主食'),
|
|
('燕麦','主食',377,'克',30,'平','30g约113大卡'),
|
|
('面条(煮)','主食',110,'碗',250,'平','1碗约250克'),
|
|
('土豆','主食',77,'个',150,'平','1个中等约150克');
|
|
|
|
-- 肉类
|
|
INSERT IGNORE INTO food_library (name,category,heat,unit,unit_weight,nature,note) VALUES
|
|
('鸡胸肉','肉类',133,'克',100,'平','优质低脂蛋白'),
|
|
('鸡腿肉(去皮)','肉类',158,'克',100,'温','去皮后约158大卡'),
|
|
('鸡腿肉(带皮)','肉类',222,'克',100,'温','皮的热量较高'),
|
|
('瘦猪肉','肉类',143,'克',100,'平',''),
|
|
('猪排骨','肉类',264,'克',100,'平','脂肪含量较高'),
|
|
('瘦牛肉','肉类',125,'克',100,'平',''),
|
|
('羊肉(瘦)','肉类',145,'克',100,'温',''),
|
|
('鱼(白肉)','肉类',113,'克',100,'平','如鲈鱼、鳕鱼'),
|
|
('虾仁','肉类',93,'克',100,'平','低脂高蛋白'),
|
|
('鸡蛋(煮)','肉类',144,'克',60,'平','1个约60克/86大卡'),
|
|
('鸡蛋(炒)','肉类',196,'克',60,'平','炒蛋因用油热量更高');
|
|
|
|
-- 蔬菜类
|
|
INSERT IGNORE INTO food_library (name,category,heat,unit,unit_weight,nature,note) VALUES
|
|
('黄瓜','蔬菜',15,'根',200,'凉','清爽低卡'),
|
|
('西红柿','蔬菜',19,'个',150,'平',''),
|
|
('白菜','蔬菜',13,'克',100,'平',''),
|
|
('菠菜','蔬菜',23,'克',100,'凉',''),
|
|
('西兰花','蔬菜',34,'克',100,'平','营养密度高'),
|
|
('生菜','蔬菜',15,'克',100,'凉',''),
|
|
('芹菜','蔬菜',16,'克',100,'凉',''),
|
|
('冬瓜','蔬菜',12,'克',100,'凉','利水消肿'),
|
|
('白萝卜','蔬菜',16,'克',100,'凉',''),
|
|
('木耳(泡发)','蔬菜',27,'克',100,'平',''),
|
|
('香菇','蔬菜',26,'克',100,'平',''),
|
|
('豆腐','蔬菜',81,'克',100,'平',''),
|
|
('豆芽','蔬菜',18,'克',100,'凉',''),
|
|
('秋葵','蔬菜',33,'克',100,'凉','');
|
|
|
|
-- 水果类
|
|
INSERT IGNORE INTO food_library (name,category,heat,unit,unit_weight,nature,note) VALUES
|
|
('桃子','水果',39,'个',200,'温','夏季水果，上火期建议暂停'),
|
|
('苹果','水果',52,'个',200,'平',''),
|
|
('雪梨','水果',51,'个',250,'凉','上火期推荐，润肺'),
|
|
('香蕉','水果',89,'根',150,'平','热量偏高'),
|
|
('西瓜','水果',30,'块',300,'凉','1块约300克'),
|
|
('火龙果(红心)','水果',55,'个',300,'凉','通便效果好'),
|
|
('火龙果(白心)','水果',50,'个',300,'凉',''),
|
|
('山竹','水果',72,'个',80,'凉','降火水果'),
|
|
('圣女果','水果',22,'个',15,'平','低糖水果，推荐加餐'),
|
|
('草莓','水果',32,'颗',20,'平','1颗约20克，低糖'),
|
|
('葡萄','水果',69,'颗',10,'平','糖分较高'),
|
|
('橙子','水果',47,'个',200,'平','维生素C丰富'),
|
|
('蓝莓','水果',57,'盒',125,'平','1盒约125克');
|
|
|
|
-- 乳制品
|
|
INSERT IGNORE INTO food_library (name,category,heat,unit,unit_weight,nature,note) VALUES
|
|
('纯牛奶(全脂)','乳制品',67,'毫升',250,'平','1盒250ml约168大卡'),
|
|
('纯牛奶(脱脂)','乳制品',35,'毫升',250,'平','1盒250ml约88大卡'),
|
|
('无糖酸奶','乳制品',62,'杯',200,'平','1杯200克约124大卡'),
|
|
('低脂酸奶(含糖)','乳制品',95,'杯',200,'平','含糖，热量较高');
|
|
|
|
-- 饮品
|
|
INSERT IGNORE INTO food_library (name,category,heat,unit,unit_weight,nature,note) VALUES
|
|
('白开水','饮品',0,'毫升',500,'平','零热量，多喝'),
|
|
('无糖茶','饮品',0,'毫升',500,'平',''),
|
|
('美式咖啡(无糖)','饮品',2,'杯',300,'平','几乎零卡'),
|
|
('拿铁(无糖)','饮品',126,'杯',300,'平','含牛奶热量');
|
|
|
|
-- 烹饪油及调味品
|
|
INSERT IGNORE INTO food_library (name,category,heat,unit,unit_weight,nature,note) VALUES
|
|
('花生油','调味品',899,'勺',10,'平','1汤勺约10克/90大卡，需计入'),
|
|
('菜籽油','调味品',899,'勺',10,'平','1汤勺约10克/90大卡'),
|
|
('橄榄油','调味品',884,'勺',10,'平','1汤勺约10克/88大卡'),
|
|
('芝麻油','调味品',884,'勺',5,'平','1小勺约5克/44大卡'),
|
|
('白砂糖','调味品',387,'勺',5,'平','1小勺约5克/19大卡'),
|
|
('酱油','调味品',53,'勺',10,'平','1勺约10克'),
|
|
('沙拉酱','调味品',637,'勺',15,'温','热量较高，建议少用'),
|
|
('辣椒酱','调味品',85,'勺',10,'热','上火期慎用');
|
|
|
|
-- 零食类
|
|
INSERT IGNORE INTO food_library (name,category,heat,unit,unit_weight,nature,note) VALUES
|
|
('坚果(混合)','零食',553,'把',30,'平','1把约30克/166大卡，不宜多'),
|
|
('核桃','零食',646,'个',20,'平','1个约20克/129大卡'),
|
|
('瓜子','零食',615,'把',10,'热','容易上火'),
|
|
('薯片','零食',536,'包',50,'平','1小包约50克/268大卡'),
|
|
('巧克力','零食',546,'块',20,'平','1块约20克/109大卡'),
|
|
('苏打饼干','零食',408,'片',10,'平','1片约10克/41大卡');
|