INSERT tb_Doctor
	(D_ID 							
	,D_No 				
	,D_Name
	,D_Sex
	,D_Password
	,DoctorNo
	,WorkYear
	,D_Tel)
	VALUES
	('350123198812304495','100001','李金成','男','123456','300001','6','13210554159')
	,('356457194901282648','100002','肖月茹','女','123456','300002','20','15415454115')
	,('482524195703261663','100003','林晓娜','女','123456','300003','18','13565426556')
	,('154547198912260048','100004','王辉','男','123456','300004','3','18812451544')
	,('694837197706072669','100005','唐露露','女','123456','300005','15','19184178136');

INSERT tb_Patient
	(P_ID						
	,P_No			
	,P_Name
	,P_Birthdate
	,P_Sex
	,P_Password
	,Address
	,P_Tel
	,IfChronic
	,IfTakePills
	,PayType)
	VALUES
	('154515195605255236','200001','姚成辉','1956-05-25','男','123456','福建省福州市马尾区祥林路口1号','16467959956','否','否','医保')
	,('894596199703296991','200002','冯军','1997-03-29','男','123456','浙江省杭州市复兴路19号','14494698745','否','否','自费')
	,('461549196607293649','200003','张亦如','1966-07-29','女','123456','广东省广州市番禺区如美公寓1栋302','16419446631','是','是','医保')	
	,('198454199910256389','200004','陈丹丹','1999-10-25','女','123456','福建省龙岩市宝胜路695号','18924658713','否','否','医保')	
	,('448614198506030721','200005','郑立均','1985-06-03','男','123456','福建省福州市仓山区宝丽商贸有限公司3楼15号','19184178136','否','否','自费');		

INSERT tb_Medicine
	(M_No 							
	,M_Name 				
	,M_Price
	,M_Type
	,M_Number
	,Functions
	,Dosage
	,SideEffect
	,Attention)
	VALUES
	('1000000001','姜枣祛寒颗粒15g*10袋','19.8','中药','49','发散驱寒，和胃温中。用于风寒感冒，胃寒疼痛。','口服，一次1~2袋，1日2~3次。','尚不明确','尚不明确')
	,('1000000002','999三九感冒灵颗粒10g*9袋','13.5','中药','106','解热镇痛。用于感冒引起的头痛，发热，鼻塞，流涕，咽痛。','口服，一次10克（1袋），1日3次。','偶见皮疹、荨麻疹、药热及粒细胞减少；详见说明书。','尚不明确')
	,('1000000003','六味地黄丸360丸','18','中药','6','滋阴补肾。用于肾阴亏损，头晕耳鸣，腰膝酸软，骨蒸潮热，盗汗遗精','口服，一次8丸，1日3次。','尚不明确','尚不明确')
	,('1000000004','足光散20g*3袋','4.5','中药','28','清热燥湿，杀虫效汗。用于湿热下注所致的角化型手足癣及臭汗症。','外用，取药粉40克加沸水1000~1500毫升，1日1次。','尚不明确','水疱型、糜烂型手足癣禁用。儿童、孕妇禁用。本品为外用药，禁止内服。切勿接触眼睛、口腔等黏膜处、皮肤破溃处禁用。')
	,('1000000005','999三九皮炎平复方醋酸地塞米松乳膏20g','12.5','复方制剂','37','用于局限性瘙痒症，神经性皮炎，接触性皮炎脂溢性皮炎以及慢性湿疹。','外用，1日1~2次，取少量涂于患处，并轻揉片刻。','长期使用可致皮肤萎缩，毛细血管扩张，色素沉着以及继发感染，偶见过敏反应。','患处已破溃、化脓、或有明显渗出者禁用，详见说明书。')
	,('1000000006','苯磺酸氨氯地平片降压药5mg*14片','4.8','化学药','97','1.高血压（单独或与其他药物合并使用）。2.心绞痛：尤其自发性心绞痛（单独或与其他药物合并使用）。','通常口服起始剂量为5mg，每日一次，最大不超过10mg，详见说明书。','','对二氢吡啶类钙拮抗剂过敏者禁用。');

INSERT tb_Instrument
	(Ins_No
	,Ins_Name
	,Ins_Number
	,Ins_State)
	VALUES
	('2000000001','血压测量仪','9','现有')
	,('2000000002','体温计','16','借完')
	,('2000000003','体重秤','18','现有')
	,('2000000004','血糖测试仪','7','现有')
	,('2000000005','真空拔罐器','23','现有');

INSERT tb_Ask
	(Ask_No
	,Asker
	,Ask
	,Answerer
	,Answer)
	VALUES
	('3000000001','陈丹丹','感冒流清涕应该吃什么药','','')
	,('3000000002','冯军','发烧了可以用冰块敷脸吗？','李金成','你好，发烧的时候一般需要采取物理降温，用冰块敷额头有一定效果的。')
	,('3000000003','陈丹丹','皮肤瘙痒起红疙瘩是怎么回事','王辉','皮肤瘙痒起红疙瘩一般是内分泌失调或者皮脂分泌过旺所致，也可能是对药物、化妆品或粉尘等产生的过敏反应，要加强对皮肤的护理，并积极做检查和治疗。')
	,('3000000004','姚成辉','小孩手背被开水烫伤怎么处理','','')
	,('3000000005','张亦如','配送药物多久可以到家里','林晓娜','我们会根据药库与所填地址的距离选择近的发货，2天之内便能到家。');
	
INSERT tb_Reservation
	(Res_No
	,ResPatientNo
	,ResTime
	,ResAddress
	,ResDoctorNo
	,Main_Say)
	VALUES
	('4000000001','200001','2019-03-17','福建省福州市马尾区祥林路口1号','100005','已经感冒咳嗽了一星期，吃药也不见好')
	,('4000000002','200003','2019-03-15','广东省广州市番禺区如美公寓1栋302','100002','发现血压升高6月，经常性头晕1周。')
	,('4000000003','200001','2019-03-10','福建省福州市马尾区祥林路口1号','100004','喉咙瘙痒，感觉有异物。')
	,('4000000004','200003','2019-02-16','广东省广州市番禺区如美公寓1栋302','100002','身上皮肤多处出现红肿瘙痒现象')
	,('4000000005','200004','2019-03-16','福建省龙岩市宝胜路695号','100003','发现血压升高2月');
	
INSERT tb_Recipe
	(Recipe_No
	,Recipe_DNo
	,Recipe_PNo
	,Temperature
	,BP
	,Height
	,Weight
	,Recipe_Time
	,Recipe_MNo
	,Judge
	,Total)
	VALUES
	('5000000001','100005','200001','','','','','2019-03-17','1000000002','风寒感冒','13.5')
	,('5000000002','100002','200003','','156','','','2019-03-15','1000000006','原发性高血压','4.8')
	,('5000000003','100004','200001','','','','','2019-03-10','1000000002','风寒感冒','13.5')
	,('5000000004','100002','200003','','','','','2019-02-16','1000000005','皮肤湿疹所致','12.5')
	,('5000000005','100003','200004','','142','','','2019-03-16','1000000006','原发性高血压','4.8');
	
INSERT tb_History
	(H_PNo
	,H_PName
	,Ill_History
	,H_Time
	,H_DNo
	,Allergic_History)
	VALUES
	('200001','姚成辉','风寒感冒','2019-03-17','100005','无')
	,('200002','冯军','无','','无','无')
	,('200003','张亦如','皮肤湿疹所致','2019-02-16','100002','无')
	,('200004','陈丹丹','原发性高血压','2019-03-16','100003','无')
	,('200005','郑立均','无','','无','无');