-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathdb.sql
More file actions
7440 lines (7369 loc) · 985 KB
/
db.sql
File metadata and controls
7440 lines (7369 loc) · 985 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 22, 2019 at 11:27 AM
-- Server version: 10.3.15-MariaDB
-- PHP Version: 7.1.30
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `hospital`
--
-- --------------------------------------------------------
--
-- Table structure for table `booking`
--
CREATE TABLE `booking` (
`booking_id` int(11) NOT NULL,
`booking_date` date NOT NULL,
`booking_time` varchar(1024) NOT NULL,
`booking_user` int(11) NOT NULL,
`booking_doctor` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `booking`
--
INSERT INTO `booking` (`booking_id`, `booking_date`, `booking_time`, `booking_user`, `booking_doctor`) VALUES
(3, '2019-10-21', '9Am-10Am', 14, 6),
(4, '2019-10-22', '9Am-10Am', 14, 6),
(5, '2019-10-22', '9Am-10Am', 14, 6),
(6, '2019-10-21', '9Am-10Am', 14, 6),
(7, '2019-10-21', '9Am-10Am', 14, 6),
(8, '2019-10-21', '9Am-10Am', 14, 5),
(9, '2019-10-23', '11Am-11:30Am', 14, 12);
-- --------------------------------------------------------
--
-- Table structure for table `city`
--
CREATE TABLE `city` (
`city_id` int(11) NOT NULL,
`city_name` varchar(512) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `city`
--
INSERT INTO `city` (`city_id`, `city_name`) VALUES
(1, 'Visakhapatnam'),
(2, 'Hyderabad'),
(3, 'Guntur'),
(4, 'Gajuwaka'),
(5, 'Ananthapur'),
(6, 'Rajahmundry'),
(7, 'Bhimavaram'),
(8, 'Chittoor'),
(9, 'Secunderabad'),
(10, 'East Godavari'),
(11, 'Vijayawada'),
(12, 'Khammam'),
(13, 'Kurnool'),
(14, 'Warangal'),
(15, 'Nellore'),
(16, 'Nalgonda'),
(17, 'Tanuku'),
(18, 'Nandyal'),
(19, 'Vizianagaram'),
(20, 'Krishna'),
(21, 'Kakinada'),
(22, 'Karimnagar'),
(23, 'Medak'),
(24, 'Ongole'),
(25, 'Cuddapah'),
(26, 'Ranga Reddy'),
(27, 'Kuppam'),
(28, 'Sangareddi'),
(29, 'Siddipet'),
(30, 'Kothagudem'),
(31, 'Ramachandrapuram'),
(32, 'Amalapuram'),
(33, 'Nizamabad'),
(34, 'West Godavari'),
(35, 'Narasaraopet'),
(36, 'Machilipatnam'),
(37, 'Tenali'),
(38, 'Mahbubnagar'),
(39, 'Srikakulam'),
(40, 'Adilabad'),
(41, 'Eluru'),
(42, 'Hanamkonda'),
(43, 'Prakasam'),
(44, 'Miryalaguda'),
(45, 'Gudivada'),
(46, 'Jagtial'),
(47, 'Madanapalle'),
(48, 'Tirupati'),
(49, 'Gudur'),
(50, 'Vuyyuru'),
(51, 'Proddatur'),
(52, 'Nirmal'),
(53, 'Elluru'),
(54, 'Narsaraopet'),
(55, 'Tirupathi'),
(56, 'Vinukonda'),
(57, 'Dibrugarh'),
(58, 'Guwahati'),
(59, 'Tinsukia'),
(60, 'Jorhat'),
(61, 'Kamrup'),
(62, 'Nagaon'),
(63, 'Mangaldoi'),
(64, 'Sonitpur'),
(65, 'Shillong'),
(66, 'Nalbari'),
(67, 'Bongaigaon'),
(68, 'Sivasagar'),
(69, 'Patna'),
(70, 'Katihar'),
(71, 'Muzaffarpur'),
(72, 'Nawada'),
(73, 'Murliganj'),
(74, 'Bilaspur'),
(75, 'Raipur'),
(76, 'Durg'),
(77, 'Korba'),
(78, 'Delhi'),
(79, 'New Delhi'),
(80, 'Nangloi Jat'),
(81, 'Kalkaji'),
(82, 'Panaji'),
(83, 'Vasco da gama'),
(84, 'Goa'),
(85, 'Margao'),
(86, 'Mapusa'),
(87, 'Bardez'),
(88, 'Ponda'),
(89, 'Salcete'),
(90, 'Daman'),
(91, 'Ahmedabad'),
(92, 'Gandhinagar'),
(93, 'Bharuch'),
(94, 'Surat'),
(95, 'Patan'),
(96, 'Vadodara'),
(97, 'Godhra'),
(98, 'Rajkot'),
(99, 'Mehsana'),
(100, 'Nadiad'),
(101, 'Valsad'),
(102, 'Bhavnagar'),
(103, 'Kalol'),
(104, 'Vapi'),
(105, 'Bhuj'),
(106, 'Kheda'),
(107, 'Surendranagar'),
(108, 'Jamnagar'),
(109, 'Modasa'),
(110, 'Navsari'),
(111, 'Anand'),
(112, 'Kutch'),
(113, 'Bavla'),
(114, 'Bardoli'),
(115, 'Dahod'),
(116, 'Junagadh'),
(117, 'Porbandar'),
(118, 'Jambusar'),
(119, 'Faridabad'),
(120, 'Kurukshetra'),
(121, 'Ambala'),
(122, 'Gurgaon'),
(123, 'Panchkula'),
(124, 'Karnal'),
(125, 'Panipat'),
(126, 'Jind'),
(127, 'Palwal'),
(128, 'Bahadurgarh'),
(129, 'Hisar'),
(130, 'Sonipat '),
(131, 'Jhajjar'),
(132, 'Rewari'),
(133, 'Sonipat'),
(134, 'Yamuna Nagar'),
(135, 'Barwala'),
(136, 'Pehowa'),
(137, 'Rohtak'),
(138, 'Hodal'),
(139, 'Ballabhgarh'),
(140, 'Ranipet'),
(141, 'Kulu'),
(142, 'Nahan'),
(143, 'Solan'),
(144, 'Simla'),
(145, 'Jammu'),
(146, 'Srinagar'),
(147, 'Ranchi'),
(148, 'Jamshedpur'),
(149, 'Dhanbad'),
(150, 'Hazaribagh'),
(151, 'Bokaro'),
(152, 'Mangalore'),
(153, 'Mysore'),
(154, 'Bangalore'),
(155, 'Kundapur'),
(156, 'Kolar'),
(157, 'Mandya'),
(158, 'Davanagere '),
(159, 'Chikkamagaluru'),
(160, 'Dakshina Kannada'),
(161, 'Virajpet'),
(162, 'Ankola'),
(163, 'Challakere'),
(164, 'Hubli'),
(165, 'Ujire'),
(166, 'Raichur'),
(167, 'Hassan'),
(168, 'Channapatna'),
(169, 'Channarayapatna'),
(170, 'Karwar'),
(171, 'Puttur'),
(172, 'Udupi'),
(173, 'Tumkur'),
(174, 'Gulbarga'),
(175, 'Belgaum'),
(176, 'Mulbagal'),
(177, 'Bagalkot'),
(178, 'Bijapur'),
(179, 'Anekal'),
(180, 'Bidar'),
(181, 'Madikeri'),
(182, 'Sullia'),
(183, 'Manipal'),
(184, 'Karkala'),
(185, 'Chitradurga'),
(186, 'Kadur'),
(187, 'Shimoga'),
(188, 'Thirthahalli'),
(189, 'Sirsi'),
(190, 'Sira'),
(191, 'Bangarapet'),
(192, 'Koppal'),
(193, 'Holalkere'),
(194, 'Nipani'),
(195, 'Bantwal'),
(196, 'Uttara Kannada'),
(197, 'Gadag'),
(198, 'Madhugiri'),
(199, 'Chikkaballapur'),
(200, 'Gundlupet'),
(201, 'Tiptur'),
(202, 'Turuvekere'),
(203, 'Kunigal'),
(204, 'Kaupa'),
(205, 'Bellary'),
(206, 'Kumta'),
(207, 'Dandeli'),
(208, 'Dharwad'),
(209, 'Ranibennur'),
(210, 'Doddaballapura'),
(211, 'Bhadravathi'),
(212, 'Kollegal'),
(213, 'Savadatti'),
(214, 'Belthangady'),
(215, 'Sriramapura'),
(216, 'Hiriyur'),
(217, 'Ramanagar'),
(218, 'Gauribidanur'),
(219, 'Gangavati'),
(220, 'Gokak'),
(221, 'Murudeshwara'),
(222, 'Malappuram'),
(223, 'Ernakulam'),
(224, 'Kochi'),
(225, 'Thrissur'),
(226, 'Thiruvananthapuram'),
(227, 'Kozhikode'),
(228, 'Palakkad'),
(229, 'Kollam'),
(230, 'Kasaragod'),
(231, 'Alappuzha'),
(232, 'Pathanamthitta'),
(233, 'Tiruvalla'),
(234, 'Mavelikkara'),
(235, 'Idukki'),
(236, 'Angamaly'),
(237, 'Kottayam'),
(238, 'Wayanad'),
(239, 'Kannur'),
(240, 'Aluva'),
(241, 'Kayamkulam'),
(242, 'Kunnamkulam'),
(243, 'Manjeri'),
(244, 'Perumbavoor'),
(245, 'Cherthala'),
(246, 'Palakkad '),
(247, 'Thiruvananthapuram '),
(248, 'Kakkanad'),
(249, 'Koratty'),
(250, 'Chelakkara'),
(251, 'Ottapalam'),
(252, 'Perintalmanna'),
(253, 'Mallapuram'),
(254, 'Trivandrum'),
(255, 'Calicut'),
(256, 'Jabalpur'),
(257, 'Bhopal'),
(258, 'Indore'),
(259, 'Gwalior'),
(260, 'Dewas'),
(261, 'Katni'),
(262, 'Ujjain'),
(263, 'Ratnapuri'),
(264, 'Sagar'),
(265, 'Mandsaur'),
(266, 'Hoshangabad'),
(267, 'Gadarwara'),
(268, 'Silvassa'),
(269, 'Mumbai'),
(270, 'Sangli'),
(271, 'Thane'),
(272, 'Solapur'),
(273, 'Navi Mumbai'),
(274, 'Buldhana'),
(275, 'Nagpur'),
(276, 'Ahmednagar'),
(277, 'Pune'),
(278, 'Kolhapur'),
(279, 'Aurangabad'),
(280, 'Kalyan'),
(281, 'Malkapur'),
(282, 'Nashik'),
(283, 'Raigad'),
(284, 'Chandrapur'),
(285, 'Jalgaon'),
(286, 'Amravati'),
(287, 'Ichalkaranji'),
(288, 'Sindhudurga'),
(289, 'Jamkhed'),
(290, 'Wardha'),
(291, 'Ratnagiri'),
(292, 'Sangamner'),
(293, 'Akola'),
(294, 'Jalna'),
(295, 'Bhandara'),
(296, 'Satara'),
(297, 'Yavatmal'),
(298, 'Beed'),
(299, 'Latur'),
(300, 'Akkalkot'),
(301, 'Karad'),
(302, 'Nanded'),
(303, 'Pune '),
(304, 'Uran'),
(305, 'Parbhani'),
(306, 'Baramati'),
(307, 'Dhule'),
(308, 'Hingoli'),
(309, 'Miraj'),
(310, 'Rajgat'),
(311, 'Sinnar'),
(312, 'Malegaon'),
(313, 'Phaltan'),
(314, 'Mangalwari'),
(315, 'Gondia'),
(316, 'Rourkela'),
(317, 'Cuttack'),
(318, 'Jagatsinghapur'),
(319, 'Bhubaneswar'),
(320, 'Sambalpur'),
(321, 'Mayurbhanj'),
(322, 'Balangir'),
(323, 'Dhenkanal'),
(324, 'Jajapur'),
(325, 'Bhadrak'),
(326, 'Turumunga'),
(327, 'Bargarh'),
(328, 'Jharsuguda'),
(329, 'Puri'),
(330, 'Kendrapara '),
(331, 'Kendujhar'),
(332, 'Angul'),
(333, 'Kalahandi'),
(334, 'Brahmapur, Odisha'),
(335, 'Ganjam'),
(336, 'Sundargarh'),
(337, 'Khordha'),
(338, 'Rayagada'),
(339, 'Balasore'),
(340, 'Jagatpur'),
(341, 'Berhampur'),
(342, 'Pondicherry'),
(343, 'Amritsar'),
(344, 'Sangrur'),
(345, 'Chandigarh'),
(346, 'Rupnagar'),
(347, 'Jalandhar'),
(348, 'Mohali'),
(349, 'Ludhiana'),
(350, 'Patiala'),
(351, 'Moga'),
(352, 'Nawanshahr'),
(353, 'Barnala'),
(354, 'Bathinda'),
(355, 'Faridkot'),
(356, 'Firozpur'),
(357, 'Khamanon'),
(358, 'Kotkapura'),
(359, 'Mansa'),
(360, 'Kurali'),
(361, 'Gurdaspur'),
(362, 'Hoshiarpur'),
(363, 'Muktsar'),
(364, 'Zirakpur'),
(365, 'Bharatpur'),
(366, 'Jaipur'),
(367, 'Udaipur'),
(368, 'Ajmer'),
(369, 'Kota'),
(370, 'Sri Ganganagar'),
(371, 'Jodhpur'),
(372, 'Bikaner'),
(373, 'Alwar'),
(374, 'Churu'),
(375, 'Sikar'),
(376, 'Dausa'),
(377, 'Pali'),
(378, 'Gangapur'),
(379, 'Bhilwara'),
(380, 'Chittorgarh'),
(381, 'Jhalawar'),
(382, 'Shahjahanpur '),
(383, 'Salem'),
(384, 'Coimbatore'),
(385, 'Madurai'),
(386, 'Tuticorin'),
(387, 'Tirunelveli'),
(388, 'Tiruchirappalli'),
(389, 'Chennai'),
(390, 'Pollachi'),
(391, 'Kuzhithurai'),
(392, 'Theni'),
(393, 'Krishnagiri'),
(394, 'Namakkal'),
(395, 'Erode'),
(396, 'Sivakasi'),
(397, 'Hosur'),
(398, 'Nagapattanam'),
(399, 'Chengalpattu'),
(400, 'Thoothukudi'),
(401, 'Rajapalayam'),
(402, 'Kanchipuram'),
(403, 'Dindigul'),
(404, 'Thiruvallur'),
(405, 'Viluppuram'),
(406, 'Sriperumbudur'),
(407, 'Nagercoil'),
(408, 'Vellore'),
(409, 'Cuddalore'),
(410, 'Virudhunagar'),
(411, 'Karur'),
(412, 'Kumbakonam'),
(413, 'Sivaganga'),
(414, 'Ramanathapuram'),
(415, 'Tirupur'),
(416, 'Mettupalayam'),
(417, 'Thiruvarur'),
(418, 'Kanyakumari'),
(419, 'Devakottai'),
(420, 'Bodinayakkanur'),
(421, 'Ooty'),
(422, 'Aranthangi'),
(423, 'Thanjavur'),
(424, 'Chinnamanur'),
(425, 'Dharmapuri'),
(426, 'Pudukkottai'),
(427, 'Karamadai'),
(428, 'Sirumugai'),
(429, 'Chidambaram'),
(430, 'Karaikudi'),
(431, 'Kotagiri'),
(432, 'Tiruchendur'),
(433, 'Tiruppathur'),
(434, 'Vazhapadi'),
(435, 'Karaikal'),
(436, 'Tiruvannamalai'),
(437, 'Neyveli'),
(438, 'Kovilpatti'),
(439, 'Aruppukkottai'),
(440, 'Maduranthakam'),
(441, 'Coonoor'),
(442, 'Kancheepuram'),
(443, 'Meerut'),
(444, 'Ghaziabad'),
(445, 'Lucknow'),
(446, 'Kanpur'),
(447, 'Aligarh'),
(448, 'Agra'),
(449, 'Bijnor'),
(450, 'Varanasi'),
(451, 'Noida'),
(452, 'Allahabad'),
(453, 'Bareilly'),
(454, 'Mathura'),
(455, 'baghpat'),
(456, 'Jhansi'),
(457, 'Bulandshahr'),
(458, 'Gorakhpur'),
(459, 'Moradabad'),
(460, 'Sitapur'),
(461, 'Firozabad'),
(462, 'Basti'),
(463, 'Azamgarh'),
(464, 'Sonbhadra '),
(465, 'Hapur'),
(466, 'Greater Noida'),
(467, 'Modinagar'),
(468, 'Dadri'),
(469, 'Dhampur'),
(470, 'Shekhpur'),
(471, 'Sikandrabad'),
(472, 'Bhadohi'),
(473, 'Dehradun'),
(474, 'Haldwani'),
(475, 'Rudrapur'),
(476, 'Nainital'),
(477, 'Kashipur'),
(478, 'Roorkee'),
(479, 'Haridwar'),
(480, 'Kolkata'),
(481, 'Howrah'),
(482, 'North 24 Parganas'),
(483, 'Bankura'),
(484, 'Kalyani'),
(485, 'Kharagpur'),
(486, 'Midnapore'),
(487, 'Titagarh'),
(488, 'Hooghly'),
(489, 'Darjeeling'),
(490, 'Barasat'),
(491, 'Jalpaiguri'),
(492, 'Maldah '),
(493, 'Siliguri'),
(494, 'Bardhaman'),
(495, 'Durgapur'),
(496, 'Serampore'),
(497, 'Haldia');
-- --------------------------------------------------------
--
-- Table structure for table `doctor`
--
CREATE TABLE `doctor` (
`doctor_id` int(11) NOT NULL,
`doctor_name` varchar(1024) NOT NULL,
`doctor_address` text NOT NULL,
`doctor_city` varchar(1024) NOT NULL,
`doctor_state` varchar(1024) NOT NULL,
`doctor_type` int(11) NOT NULL,
`doctor_contact` varchar(12) NOT NULL,
`doctor_image` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `doctor`
--
INSERT INTO `doctor` (`doctor_id`, `doctor_name`, `doctor_address`, `doctor_city`, `doctor_state`, `doctor_type`, `doctor_contact`, `doctor_image`) VALUES
(1, 'Ankur Kids Hospital', 'Number 663 Guru Teg Bahadur Nagar, Jalandhar City, Jalandhar - 144001, Near Guru Ravidas Chowk', 'Jalandhar', 'Punjab', 1, '9152542056', 'ankur_hospital_kids.jpg'),
(2, 'Chawla Nursing Home & Maternity Hospital', '9, Lajpat Nagar, Link Road, Jalandhar City, Jalandhar - 144001', 'Jalandhar', 'Punjab', 1, '9152542287', 'chawla-nursing-jalandhar.jpg'),
(3, 'Pmg Children Hospital', 'Mand Complex, Near Adarsh Palace, Jalandhar City, Jalandhar - 144001, Near Kapurthala Chowk', 'Jalandhar', 'Punjab', 1, '9152236013', 'pmg-jalandhar.jpg'),
(4, 'Tagore Hospital & Heart Care Centre Pvt Ltd.', 'Banda Bahadur Nagar, Mahavir Marg, Jalandhar City, Jalandhar - 144001, Near Kapurthala Chowk', 'Jalandhar', 'Punjab', 5, '9152806827', 'tagore-kid.jpg'),
(5, 'Dr. Nitish Garg - CARDIONOVA', ' #292, Near, Guru Nanak Mission Chowk, Lajpat Nagar, Jalandhar, Punjab 144001', 'Jalandhar', 'Punjab', 5, '9736088888', 'default-cardiologists-7.jpg'),
(6, 'Armaan Hospital', '188, Football Chowk, Adarsh Nagar, Jalandhar - 144001', 'Jalandhar', 'Punjab', 5, '01815002000', 'armann.jpg'),
(7, 'Dmc Hospital & Trauma Centre', '57, Shaheed Udham Singh Nagar, Jalandhar City, Opposite TV Centre, Jalandhar - 144001', 'Jalandhar', 'Punjab', 5, '9152768153', 'DMC.jpg'),
(8, 'Rattan Hospital', '280, Shaheed Udham Singh Nagar, Jalandhar City, Jalandhar - 144001', 'Jalandhar', 'Punjab', 5, '9152424413', 'rattan-hospital-jalandhar-city-jalandhar-hospitals-1nvam5vibn.jpg'),
(9, 'Dental Excellence', 'SCO#1, Street No. 2, Sadar Bazar, Jalandhar Cantt, Jalandhar - 144005', 'Jalandhar', 'Punjab', 2, '9501630003', 'dental-excellence-jalandhar-1usrslmhgz.jpg'),
(10, 'Sushma Memorial Super Speciality Dental Hospital', 'Punjabi Bagh Extention, Isharpuri Colony, Mithapur, Jalandhar - 144022, Just Opposite Cure Mall', 'Jalandhar', 'Punajab', 2, '9152607575', 'sushma-memorial-super-speciality-dental-hospital-mithapur-jalandhar-root-canal-doctors-0520pacdro.jpg'),
(11, 'Sara Skin and Laser Clinic', '186-R, 1ST FLOOR, MODEL TOWN MARKET, Model Town, Jalandhar - 144003, OPP NIKU PARK ', 'Jalandhar', 'Punjab', 10, '9152669860', 'sara-skin-and-laser-clinic-model-town-jalandhar-dermatologists-1p4gips.jpg'),
(12, 'Dr. Snehas Skin And Allergy Clinic', 'Shop No 2, Near Indian Oil Petrol Pump, Hoshiarpur Road, Rama Mandi, Jalandhar - 144005, Opposite Union Bank/Primary School', 'Jalandhar', 'Punjab', 10, '9152568699', 'dr-snehas-skin-and-allergy-clinic-rama-mandi-jalandhar-dermatologists-nup8juldo4.jpg'),
(13, 'KGM Bone Hospital', '25 Gurjaipal Nagar, Cool Road, Jalandhar City, Jalandhar - 144001, Near Cool Road', 'Jalandhar', 'Punjab', 24, '9152673397', 'kgm-bone-hospital-jalandhar-city-jalandhar-hospitals-l1vrr.jpeg'),
(14, 'Dr Soneet', 'Plot No 26 to 29, Hp Orthocare Hospital, KMV Road, Jalandhar, Jalandhar - 144004, Near Pathankot By Pass', 'Jalandhar', 'Punjab', 24, '9152896990', 'dr-soneet-jalandhar-jalandhar-orthopaedic-doctors-6njov.jpg');
-- --------------------------------------------------------
--
-- Table structure for table `drugs`
--
CREATE TABLE `drugs` (
`drugs_id` int(11) NOT NULL,
`drugs_name` text NOT NULL,
`drugs_ven` varchar(128) NOT NULL,
`drugs_remarks` text DEFAULT 'N/A',
`drugs_grp_first` varchar(1024) NOT NULL DEFAULT 'N/A',
`drugs_grp_second` varchar(1024) NOT NULL DEFAULT 'N/A'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `drugs`
--
INSERT INTO `drugs` (`drugs_id`, `drugs_name`, `drugs_ven`, `drugs_remarks`, `drugs_grp_first`, `drugs_grp_second`) VALUES
(1, '2FDC (Rifampicin 150mg + Isoniazid 75mg tab', 'V', '', 'Antibacterials', 'Antituberculosis Drugs'),
(2, '2FDC Paed. (isoniazid 30mg + rifampicin 60mg) tab', 'V', '', 'Antibacterials', 'Antituberculosis Drugs'),
(3, '3FDC (Rifampicin 150mg + Isoniazid 75mg+Ethambutol 275) tab', 'V', '', 'Antibacterials', 'Antituberculosis Drugs'),
(4, '3FDC Paed. ( rifampicin 60mg+Isoniazid 30+Pyrazinamide 150)', 'V', '', 'Antibacterials', 'Antituberculosis Drugs'),
(5, '4FDC (Rifampicin 150mg + Isoniazid 75mg + Pyrazinamide 400mg + Ethambutol 275mg) tab', 'V', '', 'Antibacterials', 'Antituberculosis Drugs'),
(6, 'Acenocoumarol ( Nicoumalone)1mg tab', 'E', '', 'Drugs affecting the blood', 'Drugs affecting coagulation'),
(7, 'Acetazolamide 250mg tab', 'E', '', 'Ophthalmological Preparation', 'Carbonic anhydrase inhibitors'),
(8, 'Acyclovir 3% oint. (5g)', 'E', '', '(1)Antibacterials (2)Antiviral drugs ', '(1)Antiherpes (2)Anti infective agents'),
(9, 'Acyclovir 400mg tab', 'E', '', 'Dermatological drugs', 'Antiviral drugs'),
(10, 'Adrenaline 1mg/ml inj 1ml (1:1000)', 'V', '', '(1)Anti-allergies & Drugs used in anaphylaxis (2) Cardiovascular drugs', '(1)Antiarrhythmic (2) Antiasthmatic '),
(11, 'Albendazole 400mg tab.', 'E', '', 'Anti-einfective Drugs', 'Anthelmintics'),
(12, 'Allopurinol 100mg tab.', 'E', '', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(13, 'Aluminium hydroxide 250mg +Magnesium Hydroxide 400mg tab (Antacid)', 'E', 'flavoured and chewable', 'Gastrointestinal drugs', 'Drugs for Dyspepsia and ulcer'),
(14, 'Amikacin sulphate 250mg/2ml inj', 'E', 'Use to be supported by c/s report', 'Antibacterials', 'Other antibacterials'),
(15, 'Amiodarone 200 mg tab.', 'E', '', 'Cardiovascular Drugs', '(1)Antianginal drugs (2)Antiarrhythmic drugs'),
(16, 'Amitriptylline 25mg tab', 'E', '', 'Psychotherapeutic Drugs', 'Drugs used in mood disorders'),
(17, 'Amlodipine 5mg tab', 'E', '', 'Cardiovascular Drugs', '(1) Antianginal drugs (2) Antihypertensive drugs'),
(18, 'Amoxycillin 250mg scored tab/cap.', 'E', '', 'Antibacterials', 'Penicillins'),
(19, 'Ampicillin 500mg/vial inj', 'E', '', 'Antibacterials', 'Penicillins'),
(20, 'Anti Rabies Vaccine with disposable syringe & needle (IM & SC)', 'V', '', 'Vaccines & Immunological products', 'specific'),
(21, 'Anti snake venom serum(viper,cobra,krait) dry powder for inj. 10g', 'V', '3 vials each in snake prevalent areas (BHUs)', '(1)Antidote and other substance used in poisoning (2)Vaccines & Immunological products ', '(1)specific (2)Sera & immunogobulins'),
(22, 'Antihaemorrhoidal oint. With applicator (with steroid)', 'N', '', 'Gastrointestinal drugs', 'Antihaemorrhoidal drugs'),
(23, 'Artemether 80mg/ml inj 1ml', 'V', 'in malaria endemic areas', 'Antibacterials', 'Antimalarials drugs (a) for curative treatment'),
(24, 'Arthemether 20mg+Lumefanthrine 120mg (Coartem ?)', 'E', 'in malaria endemic areas', 'Antibacterials', 'Antimalarials drugs (a) for curative treatment'),
(25, 'Aspirin 75mg enetric coated tab', 'E', '', 'Cardiovascular Drugs', 'Antiplatelet drugs'),
(26, 'Atenolol 50mg tab', 'E', '', 'Cardiovascular Drugs', '(1) Antianginal drugs (2) Antihypertensive drugs'),
(27, 'Atorvastatin 10mg tab', 'E', 'to be used for secondary prevention only', 'Cardiovascular Drugs', 'Lipid regulating drugs'),
(28, 'Atracurium Besylate 10mg/ml inj. 2.5ml', 'E', 'DH where there is functional OT', 'Muscle Relaxants & Cholinesterase inhibitors', '1. Peripherally acting, 2. Non Depolarizing Muscle Relaxants'),
(29, 'Atropine 1% eye ointment, 5g', 'E', '', 'Ophthalmological Preparation', 'Mydriatics & Cycloplegics'),
(30, 'Atropine sulphate 1mg/ml inj (1ml)', 'V', '', 'antidote and other substance used in poisoning ', '(1)Specific (2)Antispasmodic drug'),
(31, 'Baclofen 10mg tab', 'E', '', 'Muscle Relaxants & Cholinesterase inhibitors', 'Centrally acting'),
(32, 'BCG vaccine( dry powder 1ml)', 'V', '', 'Vaccines & Immunological products', 'for universal immunization'),
(33, 'Beclometasone dipropionate inhaler (50mcg/MDI) 200MDI ', 'E', '', 'Drugs acting on the respiratory tract ', 'Antiasthmatic'),
(34, 'Benzathine Benzylpenicillin 24 lakh unit inj.', 'E', '', 'Antibacterials', 'Penicillins'),
(35, 'Benzoic acid powder 450gm', 'N', '', 'Chemicals & Extemporaneous Preparation', ''),
(36, 'Benzyl alcohol (preservative) 500ml', 'N', 'preservative', 'Chemicals & Extemporaneous Preparation', ''),
(37, 'Benzylpenicillin 3g (50lakh unit) inj.', 'E', '', 'Antibacterials', 'Penicillins'),
(38, 'Betahistine 16mg tab', 'E', '', 'Drugs for Meniere\'s Disease', ''),
(39, 'Betamethasone valerate 0.1 % skin cream,15g', 'N', 'supplied to wherever there is a Dermatologist or Orthopaedist', 'Dermatological drugs', 'Anti-inflammatory & antipruritic drugs'),
(40, 'Brimonidine 0.2% eye drops, 10ml', 'E', '', '(1)Ophthalmological Preparation (2)Anti-glaucoma drugs', 'Sympathomimetics'),
(41, 'Bupivacaine 0.5% (heavy) inj. (4ml)', 'E', 'supplied where there is Surgeon and anaesthesiologist', 'Local anaesthetics', ''),
(42, 'Bupivacaine 0.5% (plain) inj. (20ml)', 'E', 'DH where ther is functional OT', 'Local anaesthetics', ''),
(43, 'Calamine powder 450G', 'N', '', '(1)Dermatological drugs (2) Chemicals & Extemporaneous preparation', 'Anti-inflammatory & antipruritic drugs'),
(44, 'Calcium gluconate 10% inj. (10 ml)', 'E', '', 'Vitamins & Minerals', 'Minerals'),
(45, 'Calcium lactate 300mg tab.', 'N', '', 'Vitamins & Minerals', 'Minerals'),
(46, 'Carbamazepine 200mg tab.', 'E', '', 'Anti-epileptics', ''),
(47, 'Carbimazole 5mg tab.', 'E', '', 'Gastrointestinal drugs', 'Antithyroid drugs'),
(48, 'Carvedilol 3.125mg tab', 'E', 'to be used for NYHA class III and IV HF patients and to be prescribed by Medical specialist only', 'Cardiovascular Drugs', 'Drugs used in heart failure'),
(49, 'Cefotaxime 1g/vial inj.(reconstituted with 9.6ml WFI)', 'E', '', 'Antibacterials', 'Other antibacterials'),
(50, 'Ceftriaxone 1g/vial inj.', 'E', 'DH where there is specialized services', 'Antibacterials', 'Other antibacterials'),
(51, 'Ceftriaxone 250mg/vial inj', 'E', 'For syndromic management of STIs only', 'Antibacterials', 'Other antibacterials'),
(52, 'Cephalexin 250mg tab/cap', 'E', '', 'Antibacterials', 'Other antibacterials'),
(53, 'Cephazolin 500mg/vial inj. ', 'E', '', 'Antibacterials', 'Other antibacterials'),
(54, 'Cetirizine 10mg tab.', 'E', '', 'Anti-allergies & Drugs used in anaphylaxis', ''),
(55, 'Charcoal activated powder 450g', 'E', '', 'Antidote & other subts used in poisoining ', 'General '),
(56, 'Charcoal tab', 'N', 'to be prescribed by Radiologist as an antiflatulent during abdominal radiography', 'Antidote & other subts used in poisoining ', '(1)General (2) Radiocontrast media '),
(57, 'Chloramphenicol 0.4% eye drops, 5ml', 'E', '', 'Ophthalmological Preparation', 'Anti infective agents'),
(58, 'Chloramphenicol 1% 250mg eye applicaps', 'E', '', 'Ophthalmological Preparation', 'Anti infective agents'),
(59, 'Chloramphenicol 1g/vial inj.(IV)', 'E', '', 'Antibacterials', 'Other antibacterials'),
(60, 'Chloramphenicol 250mg cap.', 'E', '', 'Antibacterials', 'Other antibacterials'),
(61, 'Chlorhexidine 7.5% + cetrimide 15% conc. soln.', 'E', '', 'Disinfectants & Antiseptics', ''),
(62, 'Chlorine Powder, 500gm ', 'E', '', 'Disinfectants & Antiseptics', 'Chemicals & Extemporaneous preparation'),
(63, 'Chlorobutanol powder (preservative)', 'N', 'preservative', 'Chemicals & Extemporaneous preparation', ''),
(64, 'Chloroform spirit', 'N', '', '(1)Dermatological preparation (2)Chemicals & Extemporaneous preparation', ''),
(65, 'Chloroquine 150mg tab.', 'E', 'in malaria endemic areas', 'Disease Modifying Anti-Rheumatic Drugs (DMARDs)', 'Antimalarials drugs (a) for curative treatment (2) For prophylaxis'),
(66, 'Chlorpromazine 100mg tab', 'E', 'to be supplied to BHU-I also', 'Psychotherapeutic Drugs', 'Drugs used in psychotic disorders'),
(67, 'Chlorpromazine 25mg/ml inj. 2ml', 'E', '', 'Psychotherapeutic Drugs', 'Drugs used in psychotic disorders'),
(68, 'Cinnarizine 15mg tab', 'E', '', 'Drugs for Meniere\'s Disease', ''),
(69, 'Ciprofloxacin 0.3% eye/ear drops, 5ml', 'E', '', 'Ophthalmological Preparation', 'Anti infective agents'),
(70, 'Ciprofloxacin 2mg/ml inj. 100ml', 'E', '', 'Antibacterials', 'Other antibacterials'),
(71, 'Ciprofloxacin 500mg tab.', 'V', '', 'Antibacterials', 'Other antibacterials'),
(72, 'Clobazam 5mg tablet', 'E', '', 'Anti-epileptics', ''),
(73, 'Clobetasol propionate cream 0.05% w/w, 15g', 'E', 'supplied to wherever there is a Dermatologist or Orthopaedist', 'Dermatological drugs', 'Anti-inflammatory & antipruritic drugs'),
(74, 'Clofazimine 100mg cap.', 'V', 'to be supplied to leprosy centres only', 'Antibacterials', 'Antileprosy Drugs'),
(75, 'Clofazimine 50mg cap.', 'V', '', 'Antibacterials', 'Antileprosy Drugs'),
(76, 'Clomiphene 50mg tab.', 'E', 'DH where there is Gynaecologist', 'Gastrointestinal drugs', 'Ovulation inducers'),
(77, 'Clonazepam 0.5mg tablet (CD)', 'E', '', 'Anti-epileptics', ''),
(78, 'Clopidogrel 75mg tablet', 'E', '', 'Cardiovascular Drugs', 'Antiplatelet drugs'),
(79, 'Clotrimazole 1% oint., 15g', 'E', '', 'Dermatological drugs', 'Anti-fungal drugs (topical)'),
(80, 'Clotrimazole 100mg pessary', 'E', '', 'Antibacterials', 'Antifungal Drugs'),
(81, 'Cloxacillin 250mg cap.', 'E', 'Use to be resstricted to reduce emerging drug resistance', 'Antibacterials', 'Penicillins'),
(82, 'Cloxacillin 250mg/vial inj. ', 'E', '', 'Antibacterials', 'Penicillins'),
(83, 'Coal tar solution 450ml', 'N', '', 'Chemicals & Extemporaneous preparation', 'Keratoplastic & keratolytic agents'),
(84, 'Codeine phosphate 15mg tab. (CD)', 'E', 'restricted use', '(1)Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout (2)Drugs acting on respiratory tract (3)Gastrointestinal drugs', '(1)Non-opioids (2)Antitussives (3)Anti-Motility drugs'),
(85, 'Compound benzoin inhalation', 'N', '', 'Drugs acting on the respiratory tract ', 'Decongestant'),
(86, 'Compound solution of sodium lactate inj. (500ml)', 'V', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(87, 'Condom (Male & Female)', 'E', '', '(1)Gastrointestinal drugs (2) Contraceptives', 'Barrier methods'),
(88, 'Conjugated oestrogen 0.625mg tab', 'N', '', '(1)Gastrointestinal drugs (2) Contraceptives', 'Oestrogens'),
(89, 'Copper containing device', 'E', '', '(1)Gastrointestinal drugs (2) Contraceptives', 'Intrauterine devices'),
(90, 'Cyclopentolate 0.5% eye drops, 5ml', 'E', '', 'Ophthalmological Preparation', 'Mydriatics & Cycloplegics'),
(91, 'Cyclophosphamide 200mg/vial inj.', 'E', '', 'Antineoplastic & Immunosuppressive Drugs', 'Cytotoxic drugs'),
(92, 'Cyclophosphamide 50mg tab.', 'E', '', 'Antineoplastic & Immunosuppressive Drugs', 'Cytotoxic drugs'),
(93, 'Cycloserine 250mg tab.', 'V', '', 'Antibacterials', 'Antituberculosis Drugs'),
(94, 'Cyclosporin 100mg cap (Neoral ?)', 'E', 'For renal transplant cases only. Procured by brand name since referred patients are started on this particular brand of cyclosporin', 'Antineoplastic & Immunosuppressive Drugs', 'Immunosuppresants'),
(95, 'Cyclosporin 25mg cap (Neoral ?)', 'E', '', 'Antineoplastic & Immunosuppressive Drugs', 'Immunosuppresants'),
(96, 'Cyclosporin 50mg cap (Neoral ?)', 'E', '', 'Antineoplastic & Immunosuppressive Drugs', 'Immunosuppresants'),
(97, 'Dapsone 50mg tab. ', 'E', 'to be supplied to leprosy centres only', 'Antibacterials', 'Antileprosy Drugs'),
(98, 'Deflazacort 1mg tablet ', 'E', '', 'Gastrointestinal drugs', 'Adrenal hormones &synthetic substitutes'),
(99, 'Deflazacort 6mg tablet ', 'E', '', 'Gastrointestinal drugs', 'Adrenal hormones &synthetic substitutes'),
(100, 'Dexamethasone 4mg/ml inj. (2ml)', 'V', '', 'Anti-allergies & Drugs used in anaphylaxis', 'Adrenal hormones &synthetic substitutes'),
(101, 'Dextrose 10% inj. (500ml)', 'V', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(102, 'Dextrose 25% inj. (100ml)', 'E', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(103, 'Dextrose 5% inj. (500ml)', 'V', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(104, 'Dextrose 5% sodium chloride 0.45% inj (500ml)', 'E', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(105, 'Dextrose 5% sodium chloride 0.9% inj (500ml)', 'V', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(106, 'Diazepam 5mg tab (CD)', 'E', 'BHU to use for detoxificatiion only, drugs liable to abuse, use to be restricted and controlled', 'Psychotherapeutic Drugs', 'Anxiolytics'),
(107, 'Diazepam 5mg/ml inj. (2ml) CD', 'V', 'Drugs liable to abuse, use to be restricted and controlled', '1. Anti-epileptics (2) Psychotherapeutics', 'Anxiolytics'),
(108, 'Diclofenac 100mg suppositories', 'N', 'supply in limited quantities', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(109, 'Diclofenac Sodium 25mg/ml inj. (3ml)', 'E', '', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(110, 'Dicyclomine 10mg (Dicycloverine) tab', 'E', '', 'Gastrointestinal drugs', 'Antispasmodic drugs'),
(111, 'Dicyclomine 10mg/ml (Dicycloverine) inj 2ml', 'E', '', 'Gastrointestinal drugs', 'Antispasmodic drugs'),
(112, 'Digoxin 250mcgmg/ml inj (2ml)', 'E', '', 'Cardiovascular drugs', '(1)Antiarrhythmic drugs (2) Drugs used in heart failure'),
(113, 'Digoxin 250mcg tab', 'V', '', 'Cardiovascular drugs', '(1)Antiarrhythmic drugs (2) Drugs used in heart failure'),
(114, 'Digoxin 50 mcg/ml oral soln.60 ml', 'N', '', 'Cardiovascular drugs', '(1)Antiarrhythmic drugs (2) Drugs used in heart failure'),
(115, 'Dopamine 200mg/5ml inj. ', 'V', '', 'Cardiovascular drugs', 'Drugs used in heart failure'),
(116, 'Doxorubicin 10mg/vial inj.(reconstituted with 5ml WFI)', 'E', '', 'Antineoplastic & Immunosuppressive Drugs', 'Cytotoxic drugs'),
(117, 'Doxycycline 100mg tab/cap.', 'E', '', 'Antibacterials', 'Other antibacterials'),
(118, 'DTP Vaccines 5ml', 'V', '', 'Vaccines & Immunological products', 'for universal immunization'),
(119, 'DTP-Hep B- HIib vaccine (Pentavalent) 0.5ml', 'V', '', 'Vaccines & Immunological products', 'for universal immunization'),
(120, 'Efavirenz 600mg tab', 'V', '', 'Antibacterials', 'Antiretroviral Drugs (1)Nucleoside Reverse Transcriptase Inhibitors (NRTIs)'),
(121, 'Enalapril 5mg tab', 'E', '', 'Cardiovascular drugs', '(1)Antihypertensive drugs (2) Drugs used in heart failure'),
(122, 'Ephedrine 30mg tab', 'E', '', 'Drugs acting on the respiratory tract ', 'Decongestant'),
(123, 'Ephedrine 5mg/ml (1ml) inj 30ml', 'V', 'DH where there is functional OT', 'Cardiovascular Drugs', 'Antianginal drugs'),
(124, 'Ergotamine Tartrate 1mg + Caffeine 100mg tab.', 'N', '', 'Anti-migraine drugs', 'for treatment of acute attack'),
(125, 'Erythromycin Sterate 250mg tab.', 'E', '', 'Antibacterials', 'Other antibacterials'),
(126, 'Ethambutol 400mg tab.', 'E', '', 'Antibacterials', 'Antituberculosis Drugs'),
(127, 'Ethinyloestradiol 50 mcg tab.', 'E', '', '(1)Gastrointestinal drugs (2) Contraceptives', 'Oestrogens'),
(128, 'Ethionamide 250mg tab.', 'V', '', 'Antibacterials', 'Antituberculosis Drugs'),
(129, 'Ethyl Chloride spray with devices (100ml)', 'E', '', 'Local anaesthetics', ''),
(130, 'Etofylline 84.7+Theophylline 25.3 mg/ml (Deriphyllin) inj.2ml', 'V', '', 'Drugs acting on the respiratory tract ', 'Antiasthmatic'),
(131, 'Fenofibrate 200mg tablet', 'E', '', 'Cardiovascular Drugs', 'Lipid regulating drugs'),
(132, 'Fentanyl Citrate 50mcg/ml inj 2ml (CD)', 'V', 'DH where there is functional OT', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(133, 'Ferrous Sulphate 60mg + Folic acid 0.40mg tab.', 'E', '', 'Drugs affecting the blood', 'Antianaemia drugs'),
(134, 'Finasteride 5mg tablet', 'E', '', 'Gastrointestinal drugs', 'Drugs for Benign Prostatic Hypertrophy (BPH)'),
(135, 'Fluconazole 0.3% eye drops , 5ml', 'E', '', 'Ophthalmological Preparation', 'Anti infective agents'),
(136, 'Fluorescin 4% strips (100 strips/pkt)', 'N', '', 'Diagnostic agents', 'ophthalmic drugs'),
(137, 'Fluorouracil 500mg/10ml inj', 'E', '', 'Antineoplastic & Immunosuppressive Drugs', 'Cytotoxic drugs'),
(138, 'Fluoxetine 20mg tab', 'E', 'limited quantity to DH', 'Psychotherapeutic Drugs', 'Drugs used in mood disorders'),
(139, 'Fluphenazine Decanuate 25mg/1ml Inj.', 'E', 'DH can indent using Form III, if required', 'Psychotherapeutic Drugs', 'Drugs used in psychotic disorders'),
(140, 'Folic Acid 5mg tab.', 'E', '', 'Drugs affecting the blood', 'Antianaemia drugs'),
(141, 'Frusemide 10mg/ml inj (2ml)', 'E', '', '(1)Cardiovascular drugs (2)Gastrointestinal drugs', '(1)Antihypertensive drugs (2)Loop diuretics'),
(142, 'Frusemide 40mg tab', 'E', '', '(1)Cardiovascular drugs (2)Gastrointestinal drugs', '(1)Antihypertensive drugs (2)Loop diuretics'),
(143, 'Gamma Benzene Hexachloride 1% (100ml)', 'N', '', 'Dermatological Drugs', 'Scabicides & pediculocides'),
(144, 'Gelofusine? (500ml)', 'E', '', 'Blood Products and Plasma Substitutes', ''),
(145, 'Gentamicin 40mg/ml inj. (2ml)', 'E', '', 'Antibacterials', 'Other antibacterials'),
(146, 'Gentian violet crystals', 'E', '', '(1)Dermatological drugs (2) Chemicals & Extemporaneous preparation', 'Anti-bacterial drugs (topical)'),
(147, 'Glibenclamide 5mg tab.', 'E', '', 'Gastrointestinal drugs', 'Insulins & other antidiabetic agents'),
(148, 'Glipizide 5mg tablet', 'E', '', 'Gastrointestinal drugs', 'Insulins & other antidiabetic agents'),
(149, 'Glutaraldehyde 2% solution (5L)', 'E', '', 'Disinfectants & Antiseptics', ''),
(150, 'Glycerin 450ml', 'N', '', 'Dermatological drugs', 'Miscellaneous'),
(151, 'Glycerin suppository (adult)', 'N', '', 'Gastrointestinal drugs', 'Laxatives'),
(152, 'Griseofulvin 250mg tab.', 'V', '', 'Antibacterials', 'Antifungal Drugs'),
(153, 'Haloperidol 5mg/ml inj. 1ml', 'V', '', 'Psychotherapeutic Drugs', 'Drugs used in psychotic disorders'),
(154, 'Halothane inhalation 250ml/bottle', 'V', 'DH where there is functional OT', 'Anaesthetics, general anaesthetics & oxygen', 'General anaesthetics & oxygen'),
(155, 'Heparin 5000 IU/ml inj (5ml)', 'V', '', 'Drugs affecting the blood', 'Drugs affecting coagulation'),
(156, 'Hepatitis B vaccine (r DNA) 10ml/vial', 'E', 'for high risk patients only', 'Vaccines & Immunological products', 'specific'),
(157, 'Hermin inj (250ml)', 'V', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(158, 'Homatropine 2% eye drops, 5ml', 'N', '', 'Ophthalmological Preparation', 'Mydriatics & Cycloplegics'),
(159, 'Human (soluble) insulin 40 I.U/ml, 10ml', 'V', '', 'Gastrointestinal drugs ', 'Insulins & other antidiabetic agents'),
(160, 'Human Albumin 20%, 100ml ', 'V', '', 'Blood Products and Plasma Substitutes', ''),
(161, 'Human Insulin Isophane 40 I.U/ml, 10ml', 'V', '', 'Gastrointestinal drugs', 'Insulins & other antidiabetic agents'),
(162, 'Human Mixtard (neutral + isophane) 30: 70, 10ml', 'V', '', 'Gastrointestinal drugs', 'Insulins & other antidiabetic agents'),
(163, 'Human Normal Immunoglobulin 16.5% Inj.(HNIG)', 'V', 'procure limited stock, have to maintain all times', 'Vaccines & Immunological products', 'Sera & immunogobulins'),
(164, 'Human Papiloma Vaccines (HPV) ', 'V', '', 'Vaccines & Immunological products', 'for universal immunization'),
(165, 'Human Rabies Immunoglobulin (RIG) 500IU', 'V', 'procure limited stock, have to maintain all times', 'Vaccines & Immunological products', 'Sera & immunogobulins'),
(166, 'Hyaluronidase 1500 iu/ml inj, 1ml', 'E', '', 'Ophthalmic preparations', 'Miscellaneous'),
(167, 'Hydralazine 20mg/1ml inj', 'V', '', 'Cardiovascular drugs', 'Antihypertensive drugs'),
(168, 'Hydralazine 25mg tab', 'E', '', 'Cardiovascular drugs', 'Antihypertensive drugs'),
(169, 'Hydrochlorothiazide 25mg tab', 'V', '', '(1)Cardiovascular drugs (2)Gastrointestinal drugs', '(1)Antihypertensive drugs (2)Drugs used in heart failure (3)Thiazide diuretic'),
(170, 'Hydrocortisone 1% cream, 15g', 'E', '', 'Dermatological drugs', 'Anti-inflammatory & antipruritic drugs'),
(171, 'Hydrocortisone 1% eye ointment (5g)', 'N', '', 'Ophthalmological Preparation', 'Anti-inflammatory agents'),
(172, 'Hydrocortisone acetate 25mg/ml, 5ml inj. ', 'E', 'intra-articular use; wherever there is Orthopaedist', 'Gastrointestinal drugs', 'Adrenal hormones &synthetic substitutes'),
(173, 'Hydrocortisone Sodiumsuccinate 100mg/ml inj.vial ', 'V', 'DH where there is functional OT', 'Gastrointestinal drugs', 'Adrenal hormones &synthetic substitutes'),
(174, 'Hydrogen peroxide 6% (20 volume) plastic bottle 450ml', 'N', '', 'Disinfectants & Antiseptics', ''),
(175, 'Hydroxylpropyl Methylcellulose 2% Inj. (Intra-occular with prefilled syringe)', 'E', 'intra-occular use', 'Ophthalmic preparations', 'Miscellaneous'),
(176, 'Ibuprofen 400mg tab.', 'E', '', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(177, 'Indomethacin 25mg cap.', 'E', '', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(178, 'Iodine Crytsal powder, 25gm', 'E', '', 'Gastrointestinal drugs', 'Antithyroid drugs'),
(179, 'Iohexol 300mg/ml inj. 10ml', 'E', '', 'Diagnostic agents', 'Radiocontrast media'),
(180, 'Iron Dextran (50mg elemental iron/ml) IM, IV inj. 2ml', 'E', '', 'Drugs affecting the blood', 'Antianaemia drugs'),
(181, 'Isoflurane solution 250ml', 'V', 'DH where there is functional OT', 'Anaesthetics, general anaesthetics & oxygen', ''),
(182, 'Isoniazid 100mg tab.', 'E', '', 'Antibacterials', 'Antituberculosis Drugs'),
(183, 'Isoniazid 300mg tab.', 'E', '', 'Antibacterials', 'Antituberculosis Drugs'),
(184, 'Isoprenaline 2mg/ml inj. 1ml', 'V', '', 'Cardiovascular drugs', 'Antiarrhythmic drugs'),
(185, 'Isosorbide dinitrate 10mg tab', 'E', '', 'Cardiovascular Drugs', 'Antianginal drugs'),
(186, 'Isosorbide dinitrate 5mg sublingual tab', 'V', '', 'Cardiovascular Drugs', 'Antianginal drugs'),
(187, 'Kanamycin 500mg/vial inj.', 'V', 'Use to be restricted to reduce emerging drug resistance', 'Antibacterials', 'Antituberculosis Drugs'),
(188, 'Ketamine 50mg/ml inj (10ml)', 'E', '', 'Anaesthetics, general anaesthetics & oxygen', ''),
(189, 'Ketoconazole 200mg tab', 'E', '', 'Antibacterials', 'Antifungal Drugs'),
(190, 'KY jelly', 'N', 'for EMoC use only', 'Dermatological Drugs', 'Miscellaneous'),
(191, 'Lactulose Solution (200ml)', 'E', '', 'Gastrointestinal drugs', 'Laxatives'),
(192, 'Lamivudine 100mg tablet', 'V', '', 'Antibacterials', 'Drugs for Hepatitis B infection'),
(193, 'Lamivudine 150mg tab', 'V', '', 'Antibacterials', 'Antiretroviral Drugs (1)Nucleoside Reverse Transcriptase Inhibitors (NRTIs)'),
(194, 'Lamivudine 50mg/5ml syrup 240ml', 'V', '', 'Antibacterials', 'Antiretroviral Drugs (1)Nucleoside Reverse Transcriptase Inhibitors (NRTIs)'),
(195, 'Lamotrigine 50mg tab', 'E', 'where there is Medical Specialist and Psychiatrist', 'Anti-epileptics', ''),
(196, 'Levetiracetam 500mg tablet ', 'E', 'where there is Medical Specialist and Psychiatrist', 'Anti-epileptics', ''),
(197, 'Levodopa 250mg + Carbidopa 25mg tab.', 'E', '', 'Anti-parkinson drugs', ''),
(198, 'Levonorgestrel 0.3mg + ethinyloestradiol 0.03mg tab', 'E', '', 'Gastrointestinal drugs', 'Hormonal contraceptives'),
(199, 'Levonorgestrel 750mcg tab', 'E', '', 'Gastrointestinal drugs', 'Hormonal contraceptives'),
(200, 'Lignocaine 2% + adrenaline 1:80000 (Dental cartridge) 1.8ml inj', 'E', '', 'Local anaesthetics', ''),
(201, 'Lignocaine 2% + adrenaline 1 in 100,000 inj., 30ml', 'E', 'for Dental use only ', 'Local anaesthetics', ''),
(202, 'Lignocaine 2% + adrenaline 1 in 200,000 inj., 30ml', 'V', 'DH where there is functional OT', 'Local anaesthetics', ''),
(203, 'Lignocaine 2% 30ml/vial inj (plain) with preservative ', 'V', '', 'Local anaesthetics', ''),
(204, 'Lignocaine 2% gel, 30g/tube', 'N', '', 'Local anaesthetics', 'Topical local anaesthetics'),
(205, 'Lignocaine 2% inj (Xylocard (R)) 50ml (presrvative free) ', 'V', '', '(1)Local anaesthetics (2) Cardiovascular drugs', 'Antiarrhythmic drugs'),
(206, 'Lignocaine 4% solution (30ml)', 'E', '', 'Local anaesthetics', ''),
(207, 'Lignocaine 5% (heavy) inj. 2ml', 'E', 'DH where there is fundtional OT', 'Local anaesthetics', ''),
(208, 'Lignocaine HCl 10% spray, 80ml', 'E', '', 'Local anaesthetics', ''),
(209, 'Lopinavir with ritonavir 200/50mg tab', 'V', '', 'Antibacterials', 'Antiretroviral Drugs (1)Protease Inhibitors '),
(210, 'Lorazepam 1mg tab.(CD)', 'E', '', 'Psychotherapeutic Drugs', 'Anxiolytics'),
(211, 'Losartan 25mg tab.', 'E', '', 'Cardiovascular drugs', 'Antihypertensive drugs'),
(212, 'Magnesium sulphate 50% Inj 2ml', 'V', '', 'Gastrointestinal drugs', 'Laxatives'),
(213, 'Magnesium sulphate powder 400 g', 'N', '', 'Gastrointestinal drugs', 'Laxatives'),
(214, 'Mannitol 20% inj (350ml)', 'V', '', 'Gastrointestinal drugs', 'Osmotic diuretic'),
(215, 'Measles Rubella vaccine (dry powder)', 'V', '', 'Vaccines & Immunological products', 'for universal immunization'),
(216, 'Medroxyprogesterone acetate 10mg tab.', 'E', 'DH where there is gynaecologist ', '(1)Gastrointestinal drugs (2) Contraceptives', 'Progesterones'),
(217, 'Medroxyprogesterone acetate depot 150mg/1ml vial inj ', 'E', '', '(1)Gastrointestinal drugs (2) Contraceptives', 'Hormonal contraceptives'),
(218, 'Mefenamic acid 500mg tab.', 'E', 'DH where there is gynaecologist ', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(219, 'Metformin 500mg tab.', 'E', '', 'Gastrointestinal drugs', 'Insulins & other antidiabetic agents'),
(220, 'Methotrexate 2.5mg tab.', 'E', '', 'Disease Modifying Anti-Rheumatic Drugs (DMARDs)', ''),
(221, 'Methoxsalen 0.75% w/v topical solution 25ml', 'N', '', 'Dermatological Drugs', 'Drugs for vitiligo'),
(222, 'Methylcellulose 0.3% eye drops, 10ml', 'E', '', 'Ophthalmic preparations', 'Miscellaneous'),
(223, 'Methyldopa 250mg tab', 'E', '', 'Cardiovascular drugs', 'Antihypertensive drugs'),
(224, 'Methylergometrine 125 mcg tab', 'E', '', 'Drugs used in obstetrics', 'Oxytocics'),
(225, 'Methylergometrine 200 mcg/ml inj (1ml)', 'V', '', 'Drugs used in obstetrics', 'Oxytocics'),
(226, 'Methylsalicylate 450 ml', 'N', '', '(1)Dermatological preparation (2)Chemicals & Extemporaneous preparation', 'Rubifacients'),
(227, 'Metoclopramide 10mg tab', 'E', '', 'Gastrointestinal drugs', 'Antiemetics'),
(228, 'Metoclopramide 10mg/ml inj (2ml)', 'V', '', 'Gastrointestinal drugs', 'Antiemetics'),
(229, 'Metoprolol 25mg tab', 'E', 'To be prescribed by the specialists only for post MI. To be supplied to ICU settings', 'Cardiovascular Drugs', 'Antianginal drugs'),
(230, 'Metronidazole 400mg tab.', 'E', '', 'Antibacterials', '(1) Antiprotozoal Drugs (2) Anti-amoebics & antigiardiaisis drugs'),
(231, 'Metronidazole 5mg/ml inj. 100ml', 'E', '', 'Antibacterials', '(1) Antiprotozoal Drugs (2) Anti-amoebics & antigiardiaisis drugs'),
(232, 'Microbar Oral Suspension', 'N', '', '', ''),
(233, 'Midazolam 1mg/ml inj, 10ml', 'V', 'DH where there is OT', 'Anaesthetics, general anaesthetics & oxygen', ''),
(234, 'Misoprostol 100mcg tab', 'E', 'DH where there is Gynaecologist', 'Drugs used in obstetrics', 'Oxytocics'),
(235, 'Mixed gasgangrene antitoxin inj.', 'V', '', 'Vaccines & Immunological products', 'Sera & immunogobulins'),
(236, 'Morphine 10mg tab. (CD)', 'E', '', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(237, 'Morphine 15mg/ml inj. (1ml) CD', 'E', '', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(238, 'Multi electrolyte 500ml (NS-PD - Lyte) ', 'E', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(239, 'Multivitamin IV inj. (10ml)', 'E', '', 'Vitamins & Minerals', 'Vitamins'),
(240, 'Mycophenolate mofetil 250mg cap(cellcept? ) ', 'E', '', 'Antineoplastic & Immunosuppressive Drugs', 'Immunosuppresants'),
(241, 'Mycophenolate mofetil 500mg cap (cell cept?) ', 'E', '', 'Antineoplastic & Immunosuppressive Drugs', 'Immunosuppresants'),
(242, 'Naloxone 0.4mg/ml, 1ml inj.', 'V', 'DH where there is functional OT', 'antidote and other substance used in poisoning ', 'Specific'),
(243, 'Neomycin + Polymixin + Bacitracin eye ointment 5g ', 'E', '', 'Ophthalmological Preparation', 'Anti infective agents'),
(244, 'Neostigmine 0.5mg/ml inj (1ml)', 'V', 'DH where there is functional OT', 'Muscle Relaxants & Cholinesterase inhibitors', '1. Peripherally acting, 2.Cholinesterase inhibitors'),
(245, 'Nevirapine 200mg tab', 'V', '', 'Antibacterials', 'Antiretroviral Drugs (1)Nucleoside Reverse Transcriptase Inhibitors (NRTIs)'),
(246, 'Nevirapine 50mg/5ml syrup 250ml', 'V', '', 'Antibacterials', 'Antiretroviral Drugs (1)Nucleoside Reverse Transcriptase Inhibitors (NRTIs)'),
(247, 'Niclosamide 500mg tab.', 'E', 'To be used in tape worm infestation', 'Anti-einfective Drugs', 'Anthelmintics'),
(248, 'Nifedipine 20mg SR tab', 'E', '', 'Cardiovascular drugs', 'Antihypertensive drugs'),
(249, 'Nitrofurantoin 100mg tab.', 'E', '', 'Antibacterials', 'Other antibacterials'),
(250, 'Nitrofurazone 0.2% cream', 'E', '', 'Dermatological Drugs', 'Anti-bacterial drugs (topical)'),
(251, 'Nitroglycerin 5mg/ml inj (5ml)', 'V', '', 'Cardiovascular Drugs', 'Antianginal drugs'),
(252, 'Nitrous Oxide inhalation', 'V', 'DH where there is functional OT', 'Anaesthetics, general anaesthetics & oxygen', ''),
(253, 'Norfloxacin 400mg tab .', 'E', '', 'Antibacterials', 'Other antibacterials'),
(254, 'Nystatin 500,000 unit tab', 'N', '', 'Antibacterials', 'Antifungal Drugs'),
(255, 'Ofloxacin 400mg tab/cap', 'V', 'For MDR TB cases only', 'Antibacterials', 'Antituberculosis Drugs'),
(256, 'Olanzapine 10mg tab', 'E', '', 'Psychotherapeutic Drugs', 'Drugs used in psychotic disorders'),
(257, 'Omeprazole 20mg cap', 'E', '', 'Gastrointestinal drugs', 'Pump inhibitor'),
(258, 'Ondansetron 4mg tablet', 'E', '', 'Gastrointestinal drugs', 'Antiemetics'),
(259, 'Ondansetron 2mg/ml inj 4ml ', 'E', 'for cytotoxic induced emesis', 'Gastrointestinal drugs', 'Antiemetics'),
(260, 'Oral Rehydration Salt for 1L (WHO formula)', 'V', '', 'Gastrointestinal drugs', 'Oral rehydration'),
(261, 'Oxybutynin 2.5mg tab', 'E', '', 'Gastrointestinal drugs', 'Drugs for Urinary incontinence'),
(262, 'Oxygen inhalation', 'V', 'type B oxygen cylinder to be supplied to BHU', 'Anaesthetics, general anaesthetics & oxygen', ''),
(263, 'Oxytocin 5 unit / 1ml inj ', 'V', '', 'Drugs used in obstetrics', 'Oxytocics'),
(264, 'Paracetamol 150mg/ml inj (2ml)', 'E', 'To be used in Paediatric & Casualty Units', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', ''),
(265, 'Paracetamol 500mg tab.', 'E', '', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(266, 'Penicillin V 250mg tab.', 'E', '', 'Antibacterials', 'Penicillins'),
(267, 'Pentoxifyllin 400mg tab', 'E', '', 'Cardiovascular Drugs', 'Peripheral vasodilator'),
(268, 'Pethidine 50mg/ml inj. (2ml) CD', 'V', '', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(269, 'Phenobarbital 200mg/ml inj. 1ml (CD)', 'V', 'Drugs liable to abuse, use to be restricted & controlled', 'Anti-epileptics', ''),
(270, 'Phenobarbital 30mg tab.( CD)', 'E', '', 'Anti-epileptics', ''),
(271, 'Phenytoin 100mg tab.', 'E', '', 'Anti-epileptics', ''),
(272, 'Phenytoin 50mg/ml inj 2ml', 'V', 'supply to DH in limited quantity', 'Anti-epileptics', ''),
(273, 'Phytomenadione (vit. K) 10mg/ml inj (1ml)', 'V', '', 'Drugs affecting the blood', 'Drugs affecting coagulation'),
(274, 'Pioglitazone 15mg tab', 'E', 'Use is restricted; to be prescribed only by a Medical specialist', 'Gastrointestinal drugs', 'Insulins & other antidiabetic agents'),
(275, 'Piracetam 400mg cap', 'E', '', 'Neurological Drugs', ''),
(276, 'Podophyllum resin 25g', 'N', '', '(1)Dermatological preparation (2)Chemicals & Extemporaneous preparation', 'Keratoplastic & keratolytic agents'),
(277, 'Poliomyelitis oral solution', 'V', '', 'Vaccines & Immunological products', 'for universal immunization'),
(278, 'Potassium chloride 15% inj. (10ml)', 'V', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Oral '),
(279, 'Potassium chloride powder 450g', 'N', '', 'Chemicals & Extemporaneous preparation', ''),
(280, 'Potassium iodide crystals 450g', 'N', '', '(1)Dermatological preparation (2)Chemicals & Extemporaneous preparation', ''),
(281, 'Potassium permanganate crystals, 450g', 'N', '', '(1)Dinfectants & Antiseptics (2)Chemicals & Extemporaneous preparation', ''),
(282, 'Povidone Iodine Solution 5% w/v,500ml', 'E', '', 'Disinfectants & Antiseptics', ''),
(283, 'Pralidoxime 1g inj', 'V', '', 'Antidote and other substance used in poisoning ', 'Specific'),
(284, 'Prednisolone 20mg tab', 'E', '', 'Anti-allergies & Drugs used in anaphylaxis', 'Adrenal hormones & synthetic substitutes'),
(285, 'Prednisolone 5mg tab', 'V', '', 'Anti-allergies & Drugs used in anaphylaxis', 'Adrenal hormones & synthetic substitutes'),
(286, 'Prednisolone acetate 1% eye drops, 5ml', 'V', '', 'Ophthalmological Preparation', 'Anti infective agents'),
(287, 'Primaquine 7.5mg tab.', 'E', 'in malaria endemic areas', 'Antibacterials', 'Antimalarials drugs (a) for curative treatment'),
(288, 'Procainamide 100mg/ml inj', 'V', '', 'Cardiovascular drugs', 'Antiarrhythmic drugs'),
(289, 'Procaine Benzylpenicillin 3g, 10ml inj.', 'V', '', 'Antibacterials', 'Penicillins'),
(290, 'Promethazine hydrochloride 10mg tab', 'E', '', '(1)Anti-allergies & Drugs used in anaphylaxis (2) Gastrointestinal drugs', 'Antiemetics'),
(291, 'Promethazine hydrochloride 25mg/ml inj (2ml)', 'E', '', '(1)Anti-allergies & Drugs used in anaphylaxis (2) Gastrointestinal drugs', 'Antiemetics'),
(292, 'Propofol 10mg/ml Inj, 10ml', 'V', 'DH where there is functional OT', 'Anaesthetics, general anaesthetics & oxygen', ''),
(293, 'Propranolol 40mg tab.', 'E', '', '(1) Anti-migraine drugs (2)Antianginal drugs (3) Antiarrhythmic drugs', '(1)Prophylaxis (2) Antithyroid drugs'),
(294, 'Protamine Sulphate 10mg/ml inj (5ml)', 'V', '', 'Drugs affecting the blood', 'Drugs affecting coagulation'),
(295, 'Pyrazinamide 500mg tab.', 'V', '', 'Antibacterials', 'Antituberculosis Drugs'),
(296, 'Pyridoxine (Vitamin B6) 25mg tab.', 'E', '', 'Vitamins & Minerals', 'Vitamins'),
(297, 'Quetiapine 100mg tablet', 'E', '', 'Psychotherapeutic Drugs', 'Drugs used in psychotic disorders'),
(298, 'Quinine 200mg tab.', 'V', '', 'Antibacterials', 'Antimalarials drugs (a) for curative treatment'),
(299, 'Quinine 300mg/ml inj 2ml', 'V', '', 'Antibacterials', 'Antimalarials drugs (a) for curative treatment'),
(300, 'Ranitidine 150mg tab', 'E', '', 'Gastrointestinal drugs', 'H2 receptor antagonist'),
(301, 'Ranitidine 150mg/ml inj.(2ml)', 'E', '', 'Gastrointestinal drugs', 'H2 receptor antagonist'),
(302, 'Retinol (Vitamin A) 200,000 unit cap.', 'V', '', 'Vitamins & Minerals', 'Vitamins'),
(303, 'Rifampicin 150mg tab. ', 'V', 'To be supplied to leprosy centres only', 'Antibacterials', '(1) Antileprosy Drugs (2) Anti tuberculosis Drugs'),
(304, 'Rifampicin 300mg tab.', 'V', '', 'Antibacterials', '(1) Antileprosy Drugs (2) Anti tuberculosis Drugs'),
(305, 'Risperidone 2mg tab.', 'E', '', 'Psychotherapeutic Drugs', 'Drugs used in psychotic disorders'),
(306, 'Ritodrine HCl 2mg /ml inj 5ml', 'V', 'To be prescribed by Gynaecologist', 'Drugs used in obstetrics', 'Antioxytocics'),
(307, 'Ritodrine HCl 10mg tab. ', 'E', '', 'Drugs used in obstetrics', 'Antioxytocics'),
(308, 'Salbutamol 4mg tab', 'E', '', 'Drugs acting on the respiratory tract ', 'Antiasthmatic'),
(309, 'Salbutamol metered dose Inhalar (100mcg/MDI) 200MDI ', 'E', '', 'Drugs acting on the respiratory tract ', 'Antiasthmatic'),
(310, 'Salbutamol Respiratory Solution 5mg/ml 15ml', 'V', '', 'Drugs acting on the respiratory tract ', 'Antiasthmatic'),
(311, 'Salicylic acid powder ', 'N', '', '(1)Dermatological preparation (2)Chemicals & Extemporaneous preparation', 'Keratoplastic & keratolytic agents'),
(312, 'Senna 15mg sennosides tab', 'E', '', 'Gastrointestinal drugs', 'Laxatives'),
(313, 'Sevoflurane Solution Inhalation 250ml ', 'V', '', 'Anaesthetics, general anaesthetics & oxygen', ''),
(314, 'Silver sulphadiazine 1% cream 25g', 'E', '', 'Dermatological Drugs', 'Anti-bacterial drugs (topical)'),
(315, 'Sodium amidotriazoate+ meglumin amidotriazoate 10:60 solution (150ml)', 'E', '', 'Diagnostic agents', 'Radiocontrast media'),
(316, 'Sodium bicarbonate 7.5 % inj. (25ml)', 'V', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(317, 'Sodium bicarbonate powder 450g ', 'N', '', 'Chemicals & Extemporaneous preparation', ''),
(318, 'Sodium chloride 0.9% inj (500ml)', 'V', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(319, 'Sodium Citrate powder (0.3 molar) ', 'N', '', '(1)Dermatological preparation (2)Chemicals & Extemporaneous preparation', 'Drugs for Dyspepsia and ulcer'),
(320, 'Sodium Stibogluconate 100mg/30ml inj.', 'E', '', 'Antibacterials', 'Antileishmaniasis drugs'),
(321, 'Sodium Valproate 200mg tab.', 'E', '', 'Anti-epileptics', ''),
(322, 'Spirit (L)', 'E', '', 'Dinfectants & Antiseptics ', ''),
(323, 'Spironolactone 25mg tab', 'E', '', '(1)Cardiovascular drugs (2)Gastrointestinal drugs', '(1)Antihypertensive drugs (2)Drugs used in heart failure (3)Potassium sparing diuretics'),
(324, 'Stavudine 30mg tab', 'V', '', 'Antibacterials', 'Antiretroviral Drugs (1)Nucleoside Reverse Transcriptase Inhibitors (NRTIs)'),
(325, 'Streptomycin 1G/vial inj.(reconstituted with 2ml WFI)', 'E', '', 'Antibacterials', 'Antituberculosis Drugs'),
(326, 'Sulphamethoxazole + trimethoprim 480mg/5ml inj 5ml ', 'E', '', 'Antibacterials', 'Other antibacterials'),
(327, 'Sulphamethoxazole 400mg+Trimethoprim 80mg tab.', 'E', '', 'Antibacterials', 'Other antibacterials'),
(328, 'Sulphur sublime powder 450g ', 'N', '', 'Disinfectants & Antiseptics', '(1)Dermatological preparation (2)Chemicals & Extemporaneous preparation'),
(329, 'Suxamethonium 50mg/ml inj. 2ml', 'V', 'DH where there is functional OT', 'Muscle Relaxants & Cholinesterase inhibitors', '1. Peripherally acting, 2.Depolarizing Muscle Relaxants'),
(330, 'Tacrolimus 1mg tab (Pangraf ? )', 'E', 'For renal transplant cases only. Procured by brand name since referred patients are started on this particular brand of Tacrolimus', 'Antineoplastic & Immunosuppressive Drugs', 'Immunosuppresants'),
(331, 'Tamsulosin 0.4mg tab', 'E', '', 'Gastrointestinal drugs', 'Drugs for Benign Prostatic Hypertrophy (BPH)'),
(332, 'Tenofovir 300mg tablet ', 'E', '', 'Antibacterials', 'Antiretroviral Drugs (1)Nucleoside Reverse Transcriptase Inhibitors (NRTIs)'),
(333, 'Tetanus Immunoglobulin (TIG) 500iu Inj.', 'V', 'procure limited stock, have to maintain all times', 'Vaccines & Immunological products', 'Sera & immunogobulins'),
(334, 'Tetatus Diptheria (Td) inj. 5ml ', 'V', 'RRH', 'Vaccines & Immunological products', 'for universal immunization'),
(335, 'Tetracycline 1% eye ointment', 'E', 'to be used for neonatal conjuntivities', 'Ophthalmological Preparation', 'Anti infective agents'),
(336, 'Theophylline 69mg + Etophylline 231mg (retard tab).', 'E', 'BHU', 'Drugs acting on the respiratory tract ', 'Antiasthmatic'),
(337, 'Thiamine (Vit B1) 100mg/ml inj. (1ml)', 'E', '', 'Vitamins & Minerals', 'Vitamins'),
(338, 'Thiamine 75mg tab', 'E', '', 'Vitamins & Minerals', 'Vitamins'),
(339, 'Thiopental sodium 1g/vial inj.', 'V', 'DH where there is functional OT', 'Anaesthetics, general anaesthetics & oxygen', ''),
(340, 'Thyroxine 100 mcg tab.', 'E', '', 'Gastrointestinal drugs', 'Thyroid hormones'),
(341, 'Timolol maleate 0.5% eye drops, 10ml', 'E', '', 'Ophthalmological Preparation', 'Beta-blockers'),
(342, 'Tobramycin 0.3% eye drops, 5ml', 'V', '', 'Ophthalmological Preparation', 'Anti infective agents'),
(343, 'Tramadol HCl 50mg/ml inj.(CD)', 'E', '', 'Analgesics, Antipyretics, NSAIDs & Drugs used to treat gout', 'Non-opioids'),
(344, 'Tranexamic acid 250mg tab', 'E', 'To be used where ever there is Neuro Surgeon / Gynae', 'Drugs affecting the blood', 'Drugs affecting coagulation'),
(345, 'Tranexamic acid 50mg/ml injection 5ml ', 'E', '', 'Drugs affecting the blood', 'Drugs affecting coagulation'),
(346, 'Triamcinolone acetonide 0.1% cream, 15g', 'E', 'supplied to wherever there is a Dermatologist or Orthopaedist', 'Dermatological drugs', 'Anti-inflammatory & antipruritic drugs'),
(347, 'Triamcinolone Acetonide Inj. 40mg/ml (1ml)', 'E', '', '(1) Gastrointestinal drugs (2) Dermatological drugs', '(1)Adrenal hormones &synthetic substitutes (2)Anti-inflammatory & antipruritic drugs'),
(348, 'Trihexyphenidyl 2mg tab.', 'E', '', 'Anti-parkinson drugs', ''),
(349, 'Tropicamide 1% eye drops, 5ml', 'N', 'Supplied to wherever there is an Ophthalmolist', 'Ophthalmological Preparation', 'Mydriatics & Cycloplegics'),
(350, 'Vancomycin 500mg Inj', 'E', 'Only for VAP/proven MRSA in ICU, Med & Ped wards', 'Antibacterials', 'Other antibacterials'),
(351, 'Vecuronium bromide 4mg/ml inj. 2ml', 'V', 'DH where there is functional OT', 'Muscle Relaxants & Cholinesterase inhibitors', '1. Peripherally acting, 2. Non Depolarizing Muscle Relaxants'),
(352, 'Verapamil 2.5mg/ml inj (2ml)', 'V', '', 'Cardiovascular drugs', 'Antiarrhythmic drugs'),
(353, 'Verapamil 40mg tab', 'E', '', 'Cardiovascular Drugs', '(1)Antianginal drugs (2)Antiarrhythmic drugs'),
(354, 'Vincristine 1mg/ml inj. 1ml', 'E', '', 'Antineoplastic & Immunosuppressive Drugs', 'Cytotoxic drugs'),
(355, 'Vitamin B complex (250mg/10ml inj', 'N', '', 'Vitamins & Minerals', 'Vitamins'),
(356, 'Vitamin B complex tab.', 'E', '', 'Vitamins & Minerals', 'Vitamins'),
(357, 'Vitamin B12 (hydroxycobalamin) 1mg/ml inj, Mecobalamin 500mcg/1ml inj', 'N', '', 'Drugs affecting the blood', '(1)Antianaemia drugs (2)Vitamins'),
(358, 'Vitamin C 100mg/ml inj (5ml)', 'N', '', 'Vitamins & Minerals', 'Vitamins'),
(359, 'Vitamin C 250mg tab.', 'E', '', 'Vitamins & Minerals', 'Vitamins'),
(360, 'Warfarin 1mg tab', 'V', '', 'Drugs affecting the blood', 'Drugs affecting coagulation'),
(361, 'Warfarin 5mg tab.', 'E', '', 'Drugs affecting the blood', 'Drugs affecting coagulation'),
(362, 'Water for injection (5ml) Plastic ', 'V', '', 'Solution for water, Electrolytes & Acid Based Disturbances', 'Parenteral'),
(363, 'White soft paraffin 1kg ', 'E', '', 'Chemicals & Extemporaneous preparation', ''),
(364, 'Zidovudine 300mg tab', 'E', '', 'Antibacterials', 'Antiretroviral Drugs (1)Nucleoside Reverse Transcriptase Inhibitors (NRTIs)'),
(365, 'Zidovudine 50mg/5ml syrup 240ml', 'V', '', 'Antibacterials', 'Antiretroviral Drugs (1)Nucleoside Reverse Transcriptase Inhibitors (NRTIs)'),
(366, 'Zinc oxide powder 450G', 'N', '', '(1)Dermatological (2)Chemicals & Extemporaneous preparation', 'Anti-inflammatory & antipruritic drugs'),
(367, 'Zinc Sulphate 20mg tab', 'E', '', 'Vitamins & Minerals', 'Minerals');
-- --------------------------------------------------------
--
-- Table structure for table `dr_types`
--
CREATE TABLE `dr_types` (
`dr_types_id` int(11) NOT NULL,
`dr_types_title` varchar(1024) NOT NULL,
`dr_types_desc` text NOT NULL,