45 lines
42 KiB
SQL
45 lines
42 KiB
SQL
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (230, 18, 3, 10, '王珊', '59', '女', ' 名医', '2015-07-10 00:00:00', 1, ' 2月前感冒,浮肿,尿少,尿中泡沫增多,腹胀,乏力,咽红,咳嗽,痰少质稀', ' 舌淡红', ' 苔薄$苔少', ' 脉细', ' 泌尿系感染', ' 肾风,感冒', ' 风邪犯肺', ' 益气,通络,扶阳', ' 加味葵子茯苓散', ' 冬葵子90g,茯苓30g,滑石30g,芒消15g,甘草7.5g,生肉桂7.5g', ' 印堂,风池,翳风,听宫,听会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (231, 18, 3, 3, '李静', '50', '女', ' 名医', '2014-06-03 00:00:00', 1, ' 灼热,疼痛,腰痛,恶心,乏力,腰酸,尿频,消瘦,口唇淡白$舌淡,舌淡红,苔薄,脉滑', ' 舌淡红', ' 苔薄$苔黄', ' 脉滑$脉数', ' 泌尿系感染', NULL, NULL, ' 益肾,缩泉,宁神,扶阳', NULL, ' 黄芪20g,北沙参15g,麦冬15g,白芍15g,当归12g,熟地黄15g,山萸肉10g,紫苏叶12g,陈皮12g,枳实12g,砂仁6g,牡丹皮12g,炒栀子12g,酸枣仁30g,浮小麦30g,炙甘草6g,炒六神曲20g', ' 承浆,地仓,颊车,大迎,百会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (232, 18, 3, 9, '杨升', '45', '男', ' 名医', '2015-10-23 00:00:00', 1, ' 纳呆,疲乏,蛋白尿', ' 舌红', ' 苔薄$苔黄,苔厚$苔腻', ' 脉滑$脉数,脉细', ' 泌尿系感染', ' 感冒', ' 劳倦伤肾', ' 固冲,调补气血,扶阳', ' 萆薢分清饮', ' 川萆薢6g，黄柏(炒褐色)15g，石菖蒲15g，茯苓3g，白术3g，莲子心2.1g,丹参4.5g,车前子4.5g', ' 丝竹空,承泣,阳白,大椎,环跳', ' 无效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (233, 18, 3, 5, '包宇', '69', '男', ' 名医', '2013-06-05 00:00:00', 1, ' 尿频,小便急迫,排尿疼痛,疼痛,夜间,尿黄,口干,口渴引饮,腰酸$膝软无力,乏力,大便干燥,睡眠不实', ' 舌淡红,舌淡$舌暗', ' 苔薄$苔少', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 湿热证,膀胱湿热气滞证', ' 和中,降逆', NULL, ' 柴胡10g,白芍15g,当归12g,枳壳15g,紫苏梗12g,陈皮12g,醋香附12g,砂仁6g,麦冬15g,黄连6g,瓜蒌皮10g,延胡索12g,甘草6g,柏子仁30g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (234, 18, 3, 8, '安丛宇', '51', '女', ' 名医', '2015-08-08 00:00:00', 1, ' 皮疹稠密,腹痛,便血,胸部胀闷,心悸', ' 舌淡红', ' 苔黄$苔腻,苔厚$苔腻', ' 脉滑$脉数,脉细', ' 泌尿系感染', ' 血证', ' 湿热蕴结肌肤证', ' 补肾,益气,和中,兼治椎体病', NULL, ' 北沙参15g,麦冬15g,赤芍15g,白芍15g,紫苏梗12g,陈皮12g,枳实15g,竹茹10g,瓜蒌皮12g,法半夏9g,龙胆6g,黄连6g,制吴茱萸2g,海螵蛸30g,砂仁6g,炒六神曲15g,延胡索12g,炙甘草6g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (235, 18, 3, 22, '张婧', '50', '女', ' 名医', '2016-02-22 00:00:00', 3, ' 低热,乏力,舌红,苔薄白,苔薄,脉细', ' 舌红', ' 苔薄$苔黄', ' 脉细', ' 泌尿系感染', ' 劳淋', ' 气虚证,湿浊瘀热阻于下', ' 补脾,和中,宁神,兼治少腹胀', NULL, ' 黄芪20g,党参15g,炒苍术15g,茯苓30g,枳实10g,砂仁10g,草豆蔻6g,丹参25g,柴胡10g,白芍15g,当归10g,牡丹皮15g,炒栀子15g,佩兰15g,炒六神曲20g,炮姜3g,炒麦芽30g,炒谷芽30g', ' 风池,百会,四神聪,神门,足三里,内关,太冲,太溪,三阴交,丰隆', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (236, 18, 3, 7, '王学义', '48', '男', ' 名医', '2015-02-07 00:00:00', 1, ' 尿频,灼热,小腹痛,腰酸,头面烘热$汗多,心烦,易怒,口干$口苦,背凉,睡眠不实,大便溏薄', ' 舌红', ' 苔黄$苔腻,苔白$苔腻,苔厚$苔腻', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 下焦湿热证', ' 辟秽化浊,健脾化湿', ' 小蓟饮子', ' 生地黄9g，小蓟9g，滑石9g，木通9g，蒲黄9g，藕节9g，淡竹叶9g，当归9g，山栀子9g，甘草9g', ' 神庭,百会,风池,地仓,颊车,大迎,百会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (237, 18, 3, 17, '黄晶', '68', '女', ' 名医', '2014-05-17 00:00:00', 1, ' 尿频,小便急迫,排尿疼痛,疼痛,夜间,尿黄,口干,口渴引饮,腰酸$膝软无力,乏力,大便干燥,睡眠不实', ' 舌淡红,舌淡$舌暗', ' 苔薄$苔少', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 湿热证', ' 补益心气,平肝,利咽,宁神', NULL, ' 黄芪20g,党参15g,柴胡10g,白芍15g,当归12g,炒苍术15g,茯苓30g,砂仁10g,草豆蔻6g,川芎12g,佩兰15g,枳壳15g,厚朴12g,黄连3g,干姜3g,炒六神曲20g,炒谷芽30g,炒麦芽30g,大腹皮15g,海螵蛸30g,炙甘草6g,延胡索12g', ' 合谷,太冲,膻中,阴陵泉', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (238, 18, 3, 13, '李俊', '44', '男', ' 名医', '2015-02-13 00:00:00', 1, ' 尿频,小便急迫,腰痠痛,腹痛,头面烘热,盗汗,心烦,恶心,大便溏薄,尿黄', ' 舌淡红,舌有齿痕', ' 苔薄$苔黄,苔白$苔腻', ' 脉细,脉滑$脉数', ' 泌尿系感染', ' 热淋', ' 下焦湿热证', ' 潜镇止痫,祛瘀,化痰,平肝', NULL, ' 黄芪20g,柴胡10g,白芍15g,当归12g,熟地黄15g,山萸肉12g,枳实15g,砂仁10g,佩兰15g,木香12g,牡丹皮12g,炒栀子12g,瓜蒌皮10g,炒六神曲20g,炙甘草6g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (239, 18, 3, 29, '赵妍', '73', '女', ' 名医', '2015-03-01 00:00:00', 1, ' 身热,呕吐,神昏,心烦,头昏,手麻,麻木,谵语,气喘,咳嗽,尿频,血尿,消瘦,神清,舌绛,脉细', ' 舌绛', NULL, ' 脉细', ' 泌尿系感染', NULL, ' 湿热证', ' 补益心气,通心络,和中,宁神', NULL, ' 党参15g,炒白术15g,紫苏梗12g,陈皮12g,醋香附12g,枳壳12g,砂仁6g,黄连6g,制吴茱萸2g,海螵蛸30g,蒲公英30g,延胡索12g,炙甘草6g', ' 足三里', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (240, 12, 2, 10, '患者', '59', '女', ' 名医', '2015-07-10 00:00:00', 1, ' 2月前感冒,浮肿,尿少,尿中泡沫增多,腹胀,乏力,咽红,咳嗽,痰少质稀', ' 舌淡红', ' 苔薄$苔少', ' 脉细', ' 泌尿系感染', ' 肾风,感冒', ' 风邪犯肺', ' 益气,通络,扶阳', ' 加味葵子茯苓散', ' 冬葵子90g,茯苓30g,滑石30g,芒消15g,甘草7.5g,生肉桂7.5g', ' 印堂,风池,翳风,听宫,听会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (241, 12, 2, 3, '患者', '50', '女', ' 名医', '2014-06-03 00:00:00', 1, ' 灼热,疼痛,腰痛,恶心,乏力,腰酸,尿频,消瘦,口唇淡白$舌淡,舌淡红,苔薄,脉滑', ' 舌淡红', ' 苔薄$苔黄', ' 脉滑$脉数', ' 泌尿系感染', NULL, NULL, ' 益肾,缩泉,宁神,扶阳', NULL, ' 黄芪20g,北沙参15g,麦冬15g,白芍15g,当归12g,熟地黄15g,山萸肉10g,紫苏叶12g,陈皮12g,枳实12g,砂仁6g,牡丹皮12g,炒栀子12g,酸枣仁30g,浮小麦30g,炙甘草6g,炒六神曲20g', ' 承浆,地仓,颊车,大迎,百会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (242, 12, 2, 9, '患者', '45', '男', ' 名医', '2015-10-23 00:00:00', 1, ' 纳呆,疲乏,蛋白尿', ' 舌红', ' 苔薄$苔黄,苔厚$苔腻', ' 脉滑$脉数,脉细', ' 泌尿系感染', ' 感冒', ' 劳倦伤肾', ' 固冲,调补气血,扶阳', ' 萆薢分清饮', ' 川萆薢6g，黄柏(炒褐色)15g，石菖蒲15g，茯苓3g，白术3g，莲子心2.1g,丹参4.5g,车前子4.5g', ' 丝竹空,承泣,阳白,大椎,环跳', ' 无效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (243, 12, 2, 5, '患者', '69', '男', ' 名医', '2013-06-05 00:00:00', 1, ' 尿频,小便急迫,排尿疼痛,疼痛,夜间,尿黄,口干,口渴引饮,腰酸$膝软无力,乏力,大便干燥,睡眠不实', ' 舌淡红,舌淡$舌暗', ' 苔薄$苔少', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 湿热证,膀胱湿热气滞证', ' 和中,降逆', NULL, ' 柴胡10g,白芍15g,当归12g,枳壳15g,紫苏梗12g,陈皮12g,醋香附12g,砂仁6g,麦冬15g,黄连6g,瓜蒌皮10g,延胡索12g,甘草6g,柏子仁30g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (245, 16, 1, 10, '王珊', '59', '女', ' 名医', '2015-07-10 00:00:00', 1, ' 2月前感冒,浮肿,尿少,尿中泡沫增多,腹胀,乏力,咽红,咳嗽,痰少质稀', ' 舌淡红', ' 苔薄$苔少', ' 脉细', ' 泌尿系感染', ' 肾风,感冒', ' 风邪犯肺', ' 益气,通络,扶阳', ' 加味葵子茯苓散', ' 冬葵子90g,茯苓30g,滑石30g,芒消15g,甘草7.5g,生肉桂7.5g', ' 印堂,风池,翳风,听宫,听会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (246, 16, 1, 3, '李静', '50', '女', ' 名医', '2014-06-03 00:00:00', 1, ' 灼热,疼痛,腰痛,恶心,乏力,腰酸,尿频,消瘦,口唇淡白$舌淡,舌淡红,苔薄,脉滑', ' 舌淡红', ' 苔薄$苔黄', ' 脉滑$脉数', ' 泌尿系感染', NULL, NULL, ' 益肾,缩泉,宁神,扶阳', NULL, ' 黄芪20g,北沙参15g,麦冬15g,白芍15g,当归12g,熟地黄15g,山萸肉10g,紫苏叶12g,陈皮12g,枳实12g,砂仁6g,牡丹皮12g,炒栀子12g,酸枣仁30g,浮小麦30g,炙甘草6g,炒六神曲20g', ' 承浆,地仓,颊车,大迎,百会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (247, 16, 1, 9, '杨升', '45', '男', ' 名医', '2015-10-23 00:00:00', 1, ' 纳呆,疲乏,蛋白尿', ' 舌红', ' 苔薄$苔黄,苔厚$苔腻', ' 脉滑$脉数,脉细', ' 泌尿系感染', ' 感冒', ' 劳倦伤肾', ' 固冲,调补气血,扶阳', ' 萆薢分清饮', ' 川萆薢6g，黄柏(炒褐色)15g，石菖蒲15g，茯苓3g，白术3g，莲子心2.1g,丹参4.5g,车前子4.5g', ' 丝竹空,承泣,阳白,大椎,环跳', ' 无效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (248, 16, 1, 5, '包宇', '69', '男', ' 名医', '2013-06-05 00:00:00', 1, ' 尿频,小便急迫,排尿疼痛,疼痛,夜间,尿黄,口干,口渴引饮,腰酸$膝软无力,乏力,大便干燥,睡眠不实', ' 舌淡红,舌淡$舌暗', ' 苔薄$苔少', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 湿热证,膀胱湿热气滞证', ' 和中,降逆', NULL, ' 柴胡10g,白芍15g,当归12g,枳壳15g,紫苏梗12g,陈皮12g,醋香附12g,砂仁6g,麦冬15g,黄连6g,瓜蒌皮10g,延胡索12g,甘草6g,柏子仁30g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (249, 16, 1, 8, '安丛宇', '51', '女', ' 名医', '2015-08-08 00:00:00', 1, ' 皮疹稠密,腹痛,便血,胸部胀闷,心悸', ' 舌淡红', ' 苔黄$苔腻,苔厚$苔腻', ' 脉滑$脉数,脉细', ' 泌尿系感染', ' 血证', ' 湿热蕴结肌肤证', ' 补肾,益气,和中,兼治椎体病', NULL, ' 北沙参15g,麦冬15g,赤芍15g,白芍15g,紫苏梗12g,陈皮12g,枳实15g,竹茹10g,瓜蒌皮12g,法半夏9g,龙胆6g,黄连6g,制吴茱萸2g,海螵蛸30g,砂仁6g,炒六神曲15g,延胡索12g,炙甘草6g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (250, 16, 1, 22, '张婧', '50', '女', ' 名医', '2016-02-22 00:00:00', 3, ' 低热,乏力,舌红,苔薄白,苔薄,脉细', ' 舌红', ' 苔薄$苔黄', ' 脉细', ' 泌尿系感染', ' 劳淋', ' 气虚证,湿浊瘀热阻于下', ' 补脾,和中,宁神,兼治少腹胀', NULL, ' 黄芪20g,党参15g,炒苍术15g,茯苓30g,枳实10g,砂仁10g,草豆蔻6g,丹参25g,柴胡10g,白芍15g,当归10g,牡丹皮15g,炒栀子15g,佩兰15g,炒六神曲20g,炮姜3g,炒麦芽30g,炒谷芽30g', ' 风池,百会,四神聪,神门,足三里,内关,太冲,太溪,三阴交,丰隆', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (251, 16, 1, 7, '王学义', '48', '男', ' 名医', '2015-02-07 00:00:00', 1, ' 尿频,灼热,小腹痛,腰酸,头面烘热$汗多,心烦,易怒,口干$口苦,背凉,睡眠不实,大便溏薄', ' 舌红', ' 苔黄$苔腻,苔白$苔腻,苔厚$苔腻', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 下焦湿热证', ' 辟秽化浊,健脾化湿', ' 小蓟饮子', ' 生地黄9g，小蓟9g，滑石9g，木通9g，蒲黄9g，藕节9g，淡竹叶9g，当归9g，山栀子9g，甘草9g', ' 神庭,百会,风池,地仓,颊车,大迎,百会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (252, 16, 1, 17, '黄晶', '68', '女', ' 名医', '2014-05-17 00:00:00', 1, ' 尿频,小便急迫,排尿疼痛,疼痛,夜间,尿黄,口干,口渴引饮,腰酸$膝软无力,乏力,大便干燥,睡眠不实', ' 舌淡红,舌淡$舌暗', ' 苔薄$苔少', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 湿热证', ' 补益心气,平肝,利咽,宁神', NULL, ' 黄芪20g,党参15g,柴胡10g,白芍15g,当归12g,炒苍术15g,茯苓30g,砂仁10g,草豆蔻6g,川芎12g,佩兰15g,枳壳15g,厚朴12g,黄连3g,干姜3g,炒六神曲20g,炒谷芽30g,炒麦芽30g,大腹皮15g,海螵蛸30g,炙甘草6g,延胡索12g', ' 合谷,太冲,膻中,阴陵泉', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (253, 16, 1, 13, '李俊', '44', '男', ' 名医', '2015-02-13 00:00:00', 1, ' 尿频,小便急迫,腰痠痛,腹痛,头面烘热,盗汗,心烦,恶心,大便溏薄,尿黄', ' 舌淡红,舌有齿痕', ' 苔薄$苔黄,苔白$苔腻', ' 脉细,脉滑$脉数', ' 泌尿系感染', ' 热淋', ' 下焦湿热证', ' 潜镇止痫,祛瘀,化痰,平肝', NULL, ' 黄芪20g,柴胡10g,白芍15g,当归12g,熟地黄15g,山萸肉12g,枳实15g,砂仁10g,佩兰15g,木香12g,牡丹皮12g,炒栀子12g,瓜蒌皮10g,炒六神曲20g,炙甘草6g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (254, 16, 1, 29, '赵妍', '73', '女', ' 名医', '2015-03-01 00:00:00', 1, ' 身热,呕吐,神昏,心烦,头昏,手麻,麻木,谵语,气喘,咳嗽,尿频,血尿,消瘦,神清,舌绛,脉细', ' 舌绛', NULL, ' 脉细', ' 泌尿系感染', NULL, ' 湿热证', ' 补益心气,通心络,和中,宁神', NULL, ' 党参15g,炒白术15g,紫苏梗12g,陈皮12g,醋香附12g,枳壳12g,砂仁6g,黄连6g,制吴茱萸2g,海螵蛸30g,蒲公英30g,延胡索12g,炙甘草6g', ' 足三里', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (255, 16, 1, 10, '王珊', '59', '女', ' 名医', '2015-07-10 00:00:00', 1, ' 2月前感冒,浮肿,尿少,尿中泡沫增多,腹胀,乏力,咽红,咳嗽,痰少质稀', ' 舌淡红', ' 苔薄$苔少', ' 脉细', ' 泌尿系感染', ' 肾风,感冒', ' 风邪犯肺', ' 益气,通络,扶阳', ' 加味葵子茯苓散', ' 冬葵子90g,茯苓30g,滑石30g,芒消15g,甘草7.5g,生肉桂7.5g', ' 印堂,风池,翳风,听宫,听会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (256, 16, 1, 3, '李静', '50', '女', ' 名医', '2014-06-03 00:00:00', 1, ' 灼热,疼痛,腰痛,恶心,乏力,腰酸,尿频,消瘦,口唇淡白$舌淡,舌淡红,苔薄,脉滑', ' 舌淡红', ' 苔薄$苔黄', ' 脉滑$脉数', ' 泌尿系感染', NULL, NULL, ' 益肾,缩泉,宁神,扶阳', NULL, ' 黄芪20g,北沙参15g,麦冬15g,白芍15g,当归12g,熟地黄15g,山萸肉10g,紫苏叶12g,陈皮12g,枳实12g,砂仁6g,牡丹皮12g,炒栀子12g,酸枣仁30g,浮小麦30g,炙甘草6g,炒六神曲20g', ' 承浆,地仓,颊车,大迎,百会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (257, 16, 1, 9, '杨升', '45', '男', ' 名医', '2015-10-23 00:00:00', 1, ' 纳呆,疲乏,蛋白尿', ' 舌红', ' 苔薄$苔黄,苔厚$苔腻', ' 脉滑$脉数,脉细', ' 泌尿系感染', ' 感冒', ' 劳倦伤肾', ' 固冲,调补气血,扶阳', ' 萆薢分清饮', ' 川萆薢6g，黄柏(炒褐色)15g，石菖蒲15g，茯苓3g，白术3g，莲子心2.1g,丹参4.5g,车前子4.5g', ' 丝竹空,承泣,阳白,大椎,环跳', ' 无效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (258, 16, 1, 5, '包宇', '69', '男', ' 名医', '2013-06-05 00:00:00', 1, ' 尿频,小便急迫,排尿疼痛,疼痛,夜间,尿黄,口干,口渴引饮,腰酸$膝软无力,乏力,大便干燥,睡眠不实', ' 舌淡红,舌淡$舌暗', ' 苔薄$苔少', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 湿热证,膀胱湿热气滞证', ' 和中,降逆', NULL, ' 柴胡10g,白芍15g,当归12g,枳壳15g,紫苏梗12g,陈皮12g,醋香附12g,砂仁6g,麦冬15g,黄连6g,瓜蒌皮10g,延胡索12g,甘草6g,柏子仁30g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (259, 16, 1, 8, '安丛宇', '51', '女', ' 名医', '2015-08-08 00:00:00', 1, ' 皮疹稠密,腹痛,便血,胸部胀闷,心悸', ' 舌淡红', ' 苔黄$苔腻,苔厚$苔腻', ' 脉滑$脉数,脉细', ' 泌尿系感染', ' 血证', ' 湿热蕴结肌肤证', ' 补肾,益气,和中,兼治椎体病', NULL, ' 北沙参15g,麦冬15g,赤芍15g,白芍15g,紫苏梗12g,陈皮12g,枳实15g,竹茹10g,瓜蒌皮12g,法半夏9g,龙胆6g,黄连6g,制吴茱萸2g,海螵蛸30g,砂仁6g,炒六神曲15g,延胡索12g,炙甘草6g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (260, 16, 1, 22, '张婧', '50', '女', ' 名医', '2016-02-22 00:00:00', 3, ' 低热,乏力,舌红,苔薄白,苔薄,脉细', ' 舌红', ' 苔薄$苔黄', ' 脉细', ' 泌尿系感染', ' 劳淋', ' 气虚证,湿浊瘀热阻于下', ' 补脾,和中,宁神,兼治少腹胀', NULL, ' 黄芪20g,党参15g,炒苍术15g,茯苓30g,枳实10g,砂仁10g,草豆蔻6g,丹参25g,柴胡10g,白芍15g,当归10g,牡丹皮15g,炒栀子15g,佩兰15g,炒六神曲20g,炮姜3g,炒麦芽30g,炒谷芽30g', ' 风池,百会,四神聪,神门,足三里,内关,太冲,太溪,三阴交,丰隆', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (261, 16, 1, 7, '王学义', '48', '男', ' 名医', '2015-02-07 00:00:00', 1, ' 尿频,灼热,小腹痛,腰酸,头面烘热$汗多,心烦,易怒,口干$口苦,背凉,睡眠不实,大便溏薄', ' 舌红', ' 苔黄$苔腻,苔白$苔腻,苔厚$苔腻', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 下焦湿热证', ' 辟秽化浊,健脾化湿', ' 小蓟饮子', ' 生地黄9g，小蓟9g，滑石9g，木通9g，蒲黄9g，藕节9g，淡竹叶9g，当归9g，山栀子9g，甘草9g', ' 神庭,百会,风池,地仓,颊车,大迎,百会', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (262, 16, 1, 17, '黄晶', '68', '女', ' 名医', '2014-05-17 00:00:00', 1, ' 尿频,小便急迫,排尿疼痛,疼痛,夜间,尿黄,口干,口渴引饮,腰酸$膝软无力,乏力,大便干燥,睡眠不实', ' 舌淡红,舌淡$舌暗', ' 苔薄$苔少', ' 脉弦,脉细', ' 泌尿系感染', ' 淋证', ' 湿热证', ' 补益心气,平肝,利咽,宁神', NULL, ' 黄芪20g,党参15g,柴胡10g,白芍15g,当归12g,炒苍术15g,茯苓30g,砂仁10g,草豆蔻6g,川芎12g,佩兰15g,枳壳15g,厚朴12g,黄连3g,干姜3g,炒六神曲20g,炒谷芽30g,炒麦芽30g,大腹皮15g,海螵蛸30g,炙甘草6g,延胡索12g', ' 合谷,太冲,膻中,阴陵泉', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (263, 16, 1, 13, '李俊', '44', '男', ' 名医', '2015-02-13 00:00:00', 1, ' 尿频,小便急迫,腰痠痛,腹痛,头面烘热,盗汗,心烦,恶心,大便溏薄,尿黄', ' 舌淡红,舌有齿痕', ' 苔薄$苔黄,苔白$苔腻', ' 脉细,脉滑$脉数', ' 泌尿系感染', ' 热淋', ' 下焦湿热证', ' 潜镇止痫,祛瘀,化痰,平肝', NULL, ' 黄芪20g,柴胡10g,白芍15g,当归12g,熟地黄15g,山萸肉12g,枳实15g,砂仁10g,佩兰15g,木香12g,牡丹皮12g,炒栀子12g,瓜蒌皮10g,炒六神曲20g,炙甘草6g', ' 睛明,攒竹,鱼腰,四白,瞳子髎', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (264, 16, 1, 29, '赵妍', '73', '女', ' 名医', '2015-03-01 00:00:00', 1, ' 身热,呕吐,神昏,心烦,头昏,手麻,麻木,谵语,气喘,咳嗽,尿频,血尿,消瘦,神清,舌绛,脉细', ' 舌绛', NULL, ' 脉细', ' 泌尿系感染', NULL, ' 湿热证', ' 补益心气,通心络,和中,宁神', NULL, ' 党参15g,炒白术15g,紫苏梗12g,陈皮12g,醋香附12g,枳壳12g,砂仁6g,黄连6g,制吴茱萸2g,海螵蛸30g,蒲公英30g,延胡索12g,炙甘草6g', ' 足三里', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (265, 16, 1, 27, '王利伟', '35', '男', ' 名医', '2014-02-27 00:00:00', 1, ' 尿频,纳呆,腰酸,浮肿', ' 舌淡$舌暗,舌红', ' 苔黄$苔腻,根腻', ' 脉滑$脉数,脉弦', ' 泌尿系感染', ' 淋证', ' 脾肾两虚证,湿热下注证', ' 消瘿,降逆,宁神', NULL, ' 黄芪20g,党参15g,炒苍术15g,茯苓30g,法半夏9g,白芷12g,黄芩12g,黄连3g,干姜6g,姜炭10g,肉豆蔻10g,佩兰15g,浙贝母20g,延胡索12g,赤小豆30g', ' 神庭,百会,风池,完骨,膻中,中脘,气海,血海,足三里,通里,三阴交,太溪,阴陵泉,通里,天枢,丰隆,太冲', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (266, 16, 1, 12, '高庆', '27', '男', ' 名医', '2015-02-12 00:00:00', 1, ' 腰痛,四肢肿胀', ' 舌红', ' 苔黄$苔腻,苔厚$苔腻,舌下脉络瘀紫', ' 脉滑$脉数,脉滑$脉数', ' 泌尿系感染', ' 淋证', NULL, ' 调补气血,止痛,扶阳', ' 化阴煎', ' 生地黄6g,熟地黄6g,牛膝6g,猪苓6g,泽泻6g,生黄柏6g,生知母6g,绿豆9g,龙胆草4.5g,车前子3g', ' 百会,四神聪,印堂,悬钟,脾俞,肾俞,太溪,足三里', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (267, 16, 1, 11, '王刚', '48', '男', ' 名医', '2015-07-11 00:00:00', 1, ' 尿频,面色青,舌红,苔黄,苔黄,脉沉', ' 舌红', ' 苔黄$苔腻', ' 脉沉$脉细$脉涩', ' 泌尿系感染', ' 劳淋', ' 湿热证,淋症', ' 和中,制酸,利咽,宁神,化湿,通便', NULL, ' 党参15g,炒白术20g,紫苏梗12g,陈皮12g,醋香附12g,枳实12g,砂仁6g,龙胆6g,黄连6g,制吴茱萸2g,海螵蛸30g,延胡索12g,炒六神曲15g,炙甘草6g', ' 环跳', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (268, 16, 1, 30, '冯瑜', '73', '女', ' 名医', '2015-04-02 00:00:00', 2, ' 咳嗽,有痰,鼻流涕', ' 舌红', ' 苔薄$苔黄,苔白$苔腻', ' 脉滑$脉数', ' 泌尿系感染', ' 咳嗽', ' 湿热证,升降失调', ' 疏肝,益气,敛汗,宁神', NULL, ' 柴胡10g,党参15g,炒苍术15g,白芍15g,当归12g,瓜蒌皮12g,法半夏9g,砂仁10g,丹参25g,草豆蔻6g,黄连6g,枳实12g,枳壳12g,桃仁12g,苦杏仁12g,延胡索12g,海螵蛸30g,炙甘草6g', ' 足三里', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (269, 16, 1, 26, '许向东', '76', '男', ' 名医', '2014-02-26 00:00:00', 1, ' 咳嗽,血尿', ' 舌红', ' 苔薄$苔黄,苔黄$苔腻', ' 脉浮$脉数,脉滑$脉数', ' 泌尿系感染', ' 咳嗽', ' 脾气下陷证', ' 调经,宁神,调补气血,兼治囊肿', NULL, ' 柴胡10g,白芍15g,当归12g,枳实15g,紫苏梗12g,陈皮12g,砂仁6g,柿蒂30g,瓜蒌皮12g,法半夏9g,黄连6g,制吴茱萸2g,海螵蛸30g,蒲公英30g,炙甘草6g', ' 百会,大椎,脑户,关元,神门,太溪,飞扬,太白,丰隆,风池,本神,太冲,曲池', ' 显效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (270, 16, 1, 15, '林凌峰', '59', '男', ' 名医', '2015-01-15 00:00:00', 1, ' 腰痛,尿频,小便急迫,排尿疼痛,余沥不尽,尿色深呈茶色,畏寒,睡眠不实', ' 舌淡$舌暗,舌红', ' 苔薄$苔黄,苔白$苔腻', ' 脉沉$脉细$脉涩,脉细', ' 泌尿系感染', ' 淋证', ' 湿热证,心脾两虚证', ' 调肝降压,降逆,健脾', NULL, ' 党参20g,炒苍术15g,茯苓30g,炒白术30g,紫苏叶12g,荷叶12g,陈皮12g,法半夏9g,佩兰15g,厚朴12g,砂仁6g,川芎12g,草豆蔻6g,黄连6g,炮姜4g,炒六神曲20g,炒麦芽30g,炒谷芽30g', ' 百会,大椎,肾俞,神门,内关,三阴交,四神聪,风池,太溪,足三里,丰隆,太冲,间使,膻中,廉泉,阳陵泉,阴陵泉,翳风,听宫,印堂,天枢,合谷', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (271, 16, 1, 14, '欧阳婷', '75', '女', ' 名医', '2016-02-14 00:00:00', 1, ' 尿频,排尿疼痛,尿灼,手足心热,酸痛,乏力,带下量多,外阴瘙痒,大便粘腻', ' 舌红', ' 苔黄$苔腻,苔厚$苔腻', ' 脉细,脉滑$脉数', ' 泌尿系感染', ' 淋证', ' 阳虚证', ' 益气,宁神,兼治多囊卵巢综合症', NULL, ' 柴胡10g,党参20g,佩兰15g,黄芩12g,法半夏9g,黄连3g,干姜6g,枳实12g,紫苏叶12g,荷叶12g,陈皮12g,砂仁6g,滑石10g,炒六神曲20g,炙甘草6g,炒谷芽30g,炒麦芽30g', ' 合谷,太冲', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (272, 16, 1, 24, '张碧霞', '43', '女', ' 名医', '2015-08-08 00:00:00', 1, ' 灼痛,口苦,舌红,苔薄,脉弦', ' 舌红', ' 苔薄$苔黄', ' 脉弦', ' 泌尿系感染', ' 劳淋', NULL, ' 祛风,通络,兼治椎体病', NULL, ' 柴胡10g,白芍20g,当归12g,山萸肉12g,枳实15g,厚朴12g,砂仁10g,炒六神曲20g,炒谷芽30g,炒麦芽30g,牡丹皮12g,炒栀子15g,瓜蒌皮15g,桃仁12g,苦杏仁12g,延胡索12g,炙甘草6g,熟地黄15g,佩兰12g', ' 关元,风池,大椎,足三里,天枢,血海,三阴交', ' 临床痊愈');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (273, 16, 1, 21, '李月洁', '50', '女', ' 名医', '2016-01-21 00:00:00', 2, ' 血尿,吐痰,咽喉痛,睡眠不实,纳呆', ' 舌红', ' 苔白$苔腻,苔厚$苔腻', ' 脉细,脉弦', ' 泌尿系感染', ' 血证,咳嗽', NULL, ' 宁神,化痰,通络', NULL, ' 柴胡6g,白芍15g,北沙参15g,麦冬15g,枳壳15g,紫苏梗12g,陈皮12g,醋香附12g,龙胆6g,黄连6g,制吴茱萸2g,海螵蛸30g,砂仁6g,木香12g,延胡索12g,炒六神曲15g,甘草6g', ' 神庭,百会,风池,完骨,膻中,中脘,气海,血海,足三里,通里,三阴交,太溪,阴陵泉,通里,天枢,丰隆,太冲', ' 有效');
|
||
INSERT INTO `record` (`record_id`, `some_data_base_id`, `user_id`, `patient_id`, `patient_name`, `patient_age`, `patient_gender`, `doctor_name`, `treatment_time`, `treatment_number`, `clinical_manifestation`, `tongue_nature`, `tongue_coating`, `pulse_condition`, `WM_disease`, `TCM_disease`, `TCM_syndrome`, `therapeutic_method`, `prescription_name`, `medicine_composition`, `acupuncture_point`, `therapeutic_effect`) VALUES (274, 16, 1, 2, '孔玉琴', '31', '女', ' 名医', '2014-02-06 00:00:00', 1, ' 发热,头痛,恶心,纳呆,呕吐,心悸,咳嗽,尿闭,尿少,小便不利,血尿,眼睑水肿,鼻衄,呼吸急促,浮肿,颜面浮肿,大便正常,口唇淡白$舌淡,舌淡红,舌红,苔薄白,苔薄,脉弦,脉缓,脉浮', ' 舌淡红,舌红', ' 苔薄$苔黄', ' 脉弦,脉沉$脉缓,脉浮$脉数', ' 泌尿系感染', ' 水肿', NULL, ' 益气,平肝,通络', NULL, ' 党参20g,柴胡10g,白芍15g,当归12g,枳实15g,砂仁10g,瓜蒌皮12g,法半夏9g,黄连6g,制吴茱萸1g,海螵蛸30g,陈皮12g,炒六神曲20g,延胡索12g,炙甘草6g,蒲公英30g', ' 足三里,内关,三阴交,承泣,颧髎,迎香,口禾髎,人中', ' 有效');
|