You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
145 lines
8.4 KiB
145 lines
8.4 KiB
delete from T_Type;
|
|
delete from T_Commit;
|
|
delete from T_Require;
|
|
delete from T_Belong;
|
|
delete from T_Drugs;
|
|
delete from T_Norms;
|
|
delete from T_Vendor;
|
|
delete from T_User;
|
|
delete from T_Department;
|
|
delete from T_Request;
|
|
|
|
insert into T_Drugs values('10001','0.9%氯化钠注射液',800);
|
|
insert into T_Drugs values('10002','10%葡萄糖注射液',1600);
|
|
insert into T_Drugs values('10003','25%葡萄糖注射液',500);
|
|
insert into T_Drugs values('10004','50%葡萄糖注射液',1250);
|
|
insert into T_Drugs values('10005','氨甲苯酸注射液',323);
|
|
insert into T_Drugs values('10006','多维铁口服溶液',155);
|
|
insert into T_Drugs values('10007','肺力咳合剂(合剂)',697);
|
|
insert into T_Drugs values('10008','妇科洗护敷料（卫材）',52);
|
|
insert into T_Drugs values('10009','妇乐片（片剂）',168);
|
|
insert into T_Drugs values('10010','复方碳酸钙泡腾颗粒',985);
|
|
insert into T_Drugs values('10011','黄体酮注射液(注射剂)',211);
|
|
insert into T_Drugs values('10012','甲硝维参阴道栓(阴道栓)',129);
|
|
insert into T_Drugs values('10013','甲氧氯普胺注射液',681);
|
|
insert into T_Drugs values('10014','康妇凝胶(凝胶剂)',52);
|
|
insert into T_Drugs values('10015','康妇炎胶囊',36);
|
|
insert into T_Drugs values('10016','坤泰胶囊（胶囊)',89);
|
|
insert into T_Drugs values('10017','赖氨葡锌颗粒',67);
|
|
insert into T_Drugs values('10018','利多卡因注射液',225);
|
|
insert into T_Drugs values('10019','氯化钾注射液',569);
|
|
insert into T_Drugs values('10020','米非司酮',44);
|
|
insert into T_Drugs values('10021','屈螺酮炔雌醇片',49);
|
|
insert into T_Drugs values('10022','乳酸钠林格注射液',113);
|
|
insert into T_Drugs values('10023','乳酸依沙吖啶注射液',253);
|
|
insert into T_Drugs values('10024','双歧杆菌四联活菌片（片剂）',55);
|
|
insert into T_Drugs values('10025','维生素AD滴剂',169);
|
|
insert into T_Drugs values('10026','维生素B1',32);
|
|
insert into T_Drugs values('10027','维生素B6',87);
|
|
insert into T_Drugs values('10028','吸入用盐酸氨溴索溶液',12);
|
|
insert into T_Drugs values('10029','硝呋太尔-制霉菌素栓',31);
|
|
insert into T_Drugs values('10030','注射用炎琥宁',462);
|
|
insert into T_Norms values('20003','100ml/瓶');
|
|
insert into T_Norms values('20015','250ml/瓶');
|
|
insert into T_Norms values('20022','20ml/支');
|
|
insert into T_Norms values('20014','0.1g/支');
|
|
insert into T_Norms values('20001','120ml/盒');
|
|
insert into T_Norms values('20012','150ml/盒');
|
|
insert into T_Norms values('20029','5ml*1/支');
|
|
insert into T_Norms values('20008','40片/盒');
|
|
insert into T_Norms values('20007','15袋/盒');
|
|
insert into T_Norms values('20002','20mg/支');
|
|
insert into T_Norms values('20013','8粒/盒');
|
|
insert into T_Norms values('20011','10mg/支');
|
|
insert into T_Norms values('20025','3g*6支/盒');
|
|
insert into T_Norms values('20009','48粒/盒');
|
|
insert into T_Norms values('20004','36粒/盒');
|
|
insert into T_Norms values('20006','15袋/盒');
|
|
insert into T_Norms values('20016','0.1g/支');
|
|
insert into T_Norms values('20024','1g/支');
|
|
insert into T_Norms values('20021','25mg/盒');
|
|
insert into T_Norms values('20005','28片/盒');
|
|
insert into T_Norms values('20010','500ml/瓶');
|
|
insert into T_Norms values('20019','50mg/支');
|
|
insert into T_Norms values('20023','30片/盒');
|
|
insert into T_Norms values('20038','A1500/盒');
|
|
insert into T_Norms values('20056','A2000/盒');
|
|
insert into T_Norms values('20018','100mg/支');
|
|
insert into T_Norms values('20068','15mg/支');
|
|
insert into T_Norms values('20027','3粒/盒');
|
|
insert into T_Norms values('20059','5ml/支');
|
|
insert into T_Vendor values('3067','国药控股','中国上海市黄浦区龙华东路385号','12123052666','陈先生','200023');
|
|
insert into T_Vendor values('3005','博宇医药','吉林市高新北区秀水大街1号办公楼','17235693664','曹女士','100310');
|
|
insert into T_Vendor values('3024','通用技术','黑龙江省庆安县东城区','15136953556','董女士','100320');
|
|
insert into T_Vendor values('3011','珍宝岛公司','北京市海淀区中关村大街11号6层606','13215156893','王先生','100010');
|
|
insert into T_Vendor values('3109','上药科园','郑州经济技术开发区第四大街133号蓬勃大厦第3-5层','16556846115','蔡先生','153100');
|
|
insert into T_Vendor values('3002','科伦药业','成都市新都卫星城工业开发区南二路','15869631468','刘女士','196316');
|
|
insert into T_Vendor values('3098','重药控股','重庆市渝北区金石大道333号','18766961593','李先生','158729');
|
|
insert into T_Vendor values('3025','国药控股吉林市','长春市高新开发区超强街777号','15863856675','谭女士','132001');
|
|
insert into T_Type values('10001','20003',1.61,'3067');
|
|
insert into T_Type values('10002','20015',4.46,'3005');
|
|
insert into T_Type values('10003','20022',1.4,'3005');
|
|
insert into T_Type values('10004','20022',1.45,'3005');
|
|
insert into T_Type values('10005','20014',35,'3024');
|
|
insert into T_Type values('10006','20001',22,'3011');
|
|
insert into T_Type values('10007','20012',26.95,'3011');
|
|
insert into T_Type values('10008','20029',85,'3011');
|
|
insert into T_Type values('10009','20008',38.75,'3011');
|
|
insert into T_Type values('10010','20007',21.06,'3109');
|
|
insert into T_Type values('10011','20002',2.6,'3005');
|
|
insert into T_Type values('10012','20013',19.39,'3011');
|
|
insert into T_Type values('10013','20011',2,'3005');
|
|
insert into T_Type values('10014','20025',66.76,'3011');
|
|
insert into T_Type values('10015','20009',27.97,'3067');
|
|
insert into T_Type values('10016','20004',24.95,'3067');
|
|
insert into T_Type values('10017','20006',20.1,'3024');
|
|
insert into T_Type values('10018','20016',2.23,'3005');
|
|
insert into T_Type values('10019','20024',1.22,'3002');
|
|
insert into T_Type values('10020','20021',4.76,'3005');
|
|
insert into T_Type values('10021','20005',153,'3109');
|
|
insert into T_Type values('10022','20010',14,'3067');
|
|
insert into T_Type values('10023','20019',98,'3098');
|
|
insert into T_Type values('10024','20023',30.13,'3011');
|
|
insert into T_Type values('10025','20038',23.96,'3025');
|
|
insert into T_Type values('10025','20056',25.6,'3011');
|
|
insert into T_Type values('10026','20018',1.12,'3005');
|
|
insert into T_Type values('10027','20018',0.65,'3005');
|
|
insert into T_Type values('10028','20068',8.5,'3067');
|
|
insert into T_Type values('10029','20027',48.9,'3025');
|
|
insert into T_Type values('10030','20059',12.9,'3011');
|
|
insert into T_User values('u1035','陈静','女',28,'13313513112','123','护士');
|
|
insert into T_User values('u1027','张敏','女',31,'16846444183','456','护师');
|
|
insert into T_User values('c1002','李晓','女',43,'15493448635','123456','主任医师');
|
|
insert into T_User values('u1235','薛芷菲','女',26,'12846448353','561616','实习医生');
|
|
insert into T_User values('u1583','马冬寒','男',35,'15684343443','15311f','护士');
|
|
insert into T_User values('u1036','韩荔','女',34,'15339464646','fsds6656','护士');
|
|
insert into T_User values('c1862','赵雪','女',35,'19314313131','fsfsdf586','主任医师');
|
|
insert into T_User values('u1762','钱磊','男',32,'15834644333','etreg2','副主任医师');
|
|
insert into T_User values('u1893','周鑫理','男',29,'16313434331','fhghfgt2','护师');
|
|
insert into T_User values('u1539','姜国栋','男',30,'13185386254','dgdgfddr','护士');
|
|
insert into T_User values('u1273','安南','男',26,'16488436254','dgdgsffsr','护士');
|
|
insert into T_Department values('d12','内科',52,'五');
|
|
insert into T_Department values('d03','骨科',34,'五');
|
|
insert into T_Department values('d01','眼科',12,'二');
|
|
insert into T_Department values('d05','血液化验科',8,'一');
|
|
insert into T_Department values('d16','皮肤科',25,'四');
|
|
insert into T_Belong values('u1035','d12');
|
|
insert into T_Belong values('u1027','d12');
|
|
insert into T_Belong values('c1002','d03');
|
|
insert into T_Belong values('u1235','d12');
|
|
insert into T_Belong values('u1583','d01');
|
|
insert into T_Belong values('u1036','d05');
|
|
insert into T_Belong values('c1862','d16');
|
|
insert into T_Belong values('u1762','d12');
|
|
insert into T_Belong values('u1893','d03');
|
|
insert into T_Belong values('u1539','d16');
|
|
insert into T_Belong values('u1273','d01');
|
|
insert into T_Request values('r1062',50,'2022-06-16 13:20:56');
|
|
insert into T_Request values('r5631',10,'2023-12-06 09:06:13');
|
|
insert into T_Require values('10016','r1062');
|
|
insert into T_Require values('10019','r1062');
|
|
insert into T_Require values('10023','r1062');
|
|
insert into T_Require values('10003','r5631');
|
|
insert into T_Require values('10018','r5631');
|
|
insert into T_Commit values('r1062','c1002');
|
|
insert into T_Commit values('r5631','c1862'); |