Insert_Script.sql

set search_path to MyPharmacyStore;


--Manufacturer 


INSERT INTO Manufacturer VALUES ('12334455566','AK Pharma','12Z68Q','B232 ABC Sector, Vatva, Ahmedabad, Gujarat','911023456789');
INSERT INTO Manufacturer VALUES ('12345678912','Stallion Pharma','A41IPQ','G371 Industrial Area, Changodar, Ahmedabad, Gujarat','919099234567');
INSERT INTO Manufacturer VALUES ('12345678913','West Coast Pharma','L759S7','M222 Bsafal Business Park, Prahaladnagar, Ahmedabad, Gujarat','913243423342');
INSERT INTO Manufacturer VALUES ('12345678914','Cipla Pharma','985DFP','K322 Industrial Area, Changodar, Ahmedabad, Gujarat','919676856858');
INSERT INTO Manufacturer VALUES ('23456789123','Zydus Pharma','Q7625P','Zydus Head Office, Vaishnav Devi Circle, Ahmedabad, Gujarat','915685685887');
INSERT INTO Manufacturer VALUES ('23456789124','Torrent Pharma','W78F9T','Torrent Head Office, IIMA Road, Ahmedabad, Gujarat','918565655675');
INSERT INTO Manufacturer VALUES ('23456789125','Soham Pharma','78DCS6','Z33 Jalandhar Business Sector, PQR Road, Jalandhar, Punjab','918556556757');
INSERT INTO Manufacturer VALUES ('30941324893','Silis Pharma',’8547JK’,'TZ11 SMZ Corporate Park, Jaipur, Rajasthan','311312312312');
INSERT INTO Manufacturer VALUES ('34567891245','Sagar Laborato'PW789F'ries',’452K9O’,'M24 Pharma Business Hub, Borivalli, Mumbai, Maharashtra','913891819333');
INSERT INTO Manufacturer VALUES ('45678901234','Danadams Pharma','9S7GP4','Danadams Head Office, Oreleens Road, Sunacadal, Lagos','651308080809');
INSERT INTO Manufacturer VALUES ('45678900234','Sehat-E-Zafran Labs','E694L4','P433 ADNEC Business Center, Abu Dhabi, UAE','651231312312');
INSERT INTO Manufacturer VALUES ('45678900034','Vatican Bells Pharma',4D985T','Bells Pharma Building, Querada Road, Borceda, Lagos','221321321313');
INSERT INTO Manufacturer VALUES ('13579086421','Justeen Pharmaceuticals','QPO896','Justeen Pharma Head Office, Kosad Road, Nigeria','2333123113333');
INSERT INTO Manufacturer VALUES ('99886778934','Saham Pharma','PW7856','D323 Mecall Business Hub, KB Road, Lahore, Pakistan','901232312312');
INSERT INTO Manufacturer VALUES ('42739230089','Sak Kam Pharma','P89F67','Tu Tue Hong, Philm Se Hat, Beijing, China','863123131232');
INSERT INTO Manufacturer VALUES ('13412342314','Swiss Pharmaceuticals','PE856G','100A Cordova, Senterzen Street, Geneva','411232312333');
INSERT INTO Manufacturer VALUES ('67132648713','KTZ Pharma Ltd','P7492L','Prot Hat Ne, Sim Te Lar Road, Myanmar','866868168687');
INSERT INTO Manufacturer VALUES ('71389479813','Hong Phat Pharma','78FDG9','15 Procon Estate, Industrial District, Druskel Road, Shanghai','543810899899');
INSERT INTO Manufacturer VALUES ('28402342389','Lupin Pharmaceuticals','PRE78F','Lupin Head Office, DBS Road, Sector 8, New Delhi','919999139919');




--Product


INSERT INTO Product VALUES ('ABC012', 'Ibuprofen', 100, '12334455566', 'Medicine');
INSERT INTO Product VALUES ('BCD123', 'Naproxen', 100, '12334455566', 'Medicine');
INSERT INTO Product VALUES ('CDE234', 'Ketoprofen', 100, '12345678912', 'Medicine');
INSERT INTO Product VALUES ('DEF345', 'Nimesulide', 100, '12345678913', 'Medicine');
INSERT INTO Product VALUES ('EFG456', 'Choline Salicylate', 100, '23456789123', 'Medicine');
INSERT INTO Product VALUES ('FGH567', 'Magnesium Salicylate', 100, '23456789124', 'Medicine');
INSERT INTO Product VALUES ('GHI678', 'Sodium Salicylate', 100, '23456789124', 'Medicine');
INSERT INTO Product VALUES ('HIJ789', 'Metamizole', 100, '23456789124', 'Medicine');
INSERT INTO Product VALUES ('IJK890', 'Nabumetone', 100, '12334455566', 'Medicine');
INSERT INTO Product VALUES (‘JKL901', 'Phenazone ', 100, '12345678912', 'Medicine');
INSERT INTO Product VALUES ('KLM011', 'Paracetamol', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('LMN122', 'Amoxicillin', 100, '12345678912', 'Medicine');
INSERT INTO Product VALUES ('MNO233', 'Doxycycline', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('NOP344', 'Cephalexin', 100, '12345678914', 'Medicine');
INSERT INTO Product VALUES ('OPQ455', 'Ciprofloxacin', 100, '12345678914', 'Medicine');
INSERT INTO Product VALUES ('PQR566', 'Clindamycin', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('QRS677', 'Metronidazole', 100, 23456789125', 'Medicine');
INSERT INTO Product VALUES ('RST788', 'Azithromycin', 100, '12345678914', 'Medicine');
INSERT INTO Product VALUES ('STU899', 'Sulfamethoxazole', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('TUV900', 'Trimethoprim', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('UVW124', 'Clavulanate', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('VWX136', 'Levofloxacin', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('WXY148', 'Augmentin', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('XYZ150', 'Amoxil', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('YZA162', 'Cipro', 100, '12345678914', 'Medicine');
INSERT INTO Product VALUES ('ZAB174', 'Keflex', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('ABB186', 'Levaquin', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('BCC198', 'Zithromax', 100, '12345678914', 'Medicine');
INSERT INTO Product VALUES ('CDD100', 'Avelox', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('DEE012', 'Cleocin', 100, '30941324893', 'Medicine');
INSERT INTO Product VALUES ('EFF123', 'Flagyl', 100, '99886778934', 'Medicine');
INSERT INTO Product VALUES ('FGG234', 'Bactrim', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('GHH345', 'Amoxicillin', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('HII456', 'Ampicillin', 100, '99886778934', 'Medicine');
INSERT INTO Product VALUES ('IJJ567', 'Dicloxacillin', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('JKK678', 'Oxacillin', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('KLL789', 'Penicillin V Potassium', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('LMM890', 'Codeine', 100, '28402342389', 'Medicine');
INSERT INTO Product VALUES ('MNN901', 'OxyContin', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('NOO011', 'Vicodin', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('OPP122', 'Lortab', 100, '28402342389', 'Medicine');
INSERT INTO Product VALUES ('PQQ233', 'Dolophine', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('QRR344', 'Exalgo', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('RSS455', 'Methadose', 100, '42739230089', 'Medicine');
INSERT INTO Product VALUES ('STT566', 'Avinza', 100, '12345678914', 'Medicine');
INSERT INTO Product VALUES ('TUU677', 'Kadian', 100, '30941324893', 'Medicine');
INSERT INTO Product VALUES ('UVV788', 'Allegra ODT', 100, '30941324893', 'Medicine');
INSERT INTO Product VALUES ('VWW899', 'Q-Dryl', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('WXX900', 'Phenergan', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('XYY124', 'Benadryl Children's Allergy', 100, '23456789125', 'Medicine');
INSERT INTO Product VALUES ('YZZ136', 'Banophen', 100, '30941324893', 'Medicine');
INSERT INTO Product VALUES ('ZAA148', 'Hyzine', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('ABD150', 'Nytol', 100, '30941324893', 'Medicine');
INSERT INTO Product VALUES ('ADB162', 'Claritin', 100, '30941324893', 'Medicine');
INSERT INTO Product VALUES ('ACB174', 'Aller-Ease', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('BCE186', 'Abacavir', 100, '12345678914', 'Medicine');
INSERT INTO Product VALUES ('BEC198', 'Aciclovir', 100, '13579086421', 'Medicine');
INSERT INTO Product VALUES ('EBC224', 'Adefovir', 100, '30941324893', 'Medicine');
INSERT INTO Product VALUES ('ECB236', 'Amantadine', 100, '30941324893', 'Medicine');
INSERT INTO Product VALUES ('DEG248', 'Ampligen', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('GDE250', 'Amprenavir', 100, '23456789124', 'Medicine');
INSERT INTO Product VALUES ('EDG262', 'Arbidol', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('FIH274', 'Atazanavir', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('IHF286', 'Opticure Eye Drop', 100, '23456789124', 'Medicine');
INSERT INTO Product VALUES ('FHI298', 'Softeron Gold Tablet', 100, '23456789124', 'Medicine');
INSERT INTO Product VALUES ('HIF200', 'Propofol', 100, '34567891245', 'Medicine');
INSERT INTO Product VALUES ('JKO300', 'Ketamine', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('OKJ311', 'Etomidate', 100, '13579086421', 'Medicine');
INSERT INTO Product VALUES ('KJO324', 'Numbex Cream', 100, '45678900034', 'Medicine');
INSERT INTO Product VALUES ('BTS336', 'Sleeping pills', 100, '13579086421', 'Medicine');
INSERT INTO Product VALUES ('TCS348', 'Diazepam', 100, '34567891245', 'Medicine');
INSERT INTO Product VALUES ('MBB350', 'Midazolam', 100, '34567891245', 'Medicine');
INSERT INTO Product VALUES ('TMC362', 'Amytal', 100, '12345678914', 'Medicine');
INSERT INTO Product VALUES ('TGB374', 'Brevital', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('HIM386', 'Surital', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('HNM398', 'Chlorpromazine', 100, '45678901234', 'Medicine');
INSERT INTO Product VALUES ('JNJ400', 'Diazepam', 100, '12345678914', 'Medicine');
INSERT INTO Product VALUES ('BNR411', 'Alprazolam', 100, '23456789124', 'Medicine');
INSERT INTO Product VALUES ('PNR424', 'OneTouch', 100, '45678900234', 'Healthcare');
INSERT INTO Product VALUES ('IIT436', 'Omron', 100, '45678900234', 'Healthcare');
INSERT INTO Product VALUES ('LOL448', 'Opti-free', 100, '45678900234', 'Healthcare');
INSERT INTO Product VALUES ('LMA450', 'Ocean', 100, '23456789124', 'Healthcare');
INSERT INTO Product VALUES ('ROF462', 'Chloraseptic', 100, '13579086421', 'Healthcare');
INSERT INTO Product VALUES (‘WOW474', 'Band-Aid', 100, '13579086421', 'Healthcare');
INSERT INTO Product VALUES ('SYX486', 'Neosporin', 100, '99886778934', 'Healthcare');
INSERT INTO Product VALUES ('RTL498', 'Solarcaine', 100, '13579086421', 'Healthcare');
INSERT INTO Product VALUES ('RTT500', 'Crest','Oral Care', 100, '99886778934', 'Healthcare');
INSERT INTO Product VALUES ('ERT511', 'Abreva','Oral Care', 100, '12345678914', 'Healthcare');
INSERT INTO Product VALUES ('DRT524', 'Listerine','Oral Care', 100, '34567891245', 'Healthcare');
INSERT INTO Product VALUES ('XRT536', 'Ensure', 100, '34567891245', 'Healthcare');
INSERT INTO Product VALUES ('CRT548', 'Centrum', 100, '71389479813', 'Healthcare');
INSERT INTO Product VALUES ('CRR550', 'One A Day Prenatal', 100, '34567891245', 'Healthcare');
INSERT INTO Product VALUES ('GRR562', 'Midol Complete', 100, '45678900234', 'Healthcare');
INSERT INTO Product VALUES ('GST574', 'First Response', 100, '13579086421', 'Healthcare');
INSERT INTO Product VALUES ('GDP586', 'AZO Standard', 100, '13579086421', 'Healthcare');
INSERT INTO Product VALUES ('GNP598', 'Capzasin', 100, '99886778934', 'Healthcare');
INSERT INTO Product VALUES ('PLZ600', 'Insta Glucose', 100, '45678900234', 'Healthcare');
INSERT INTO Product VALUES ('EWW611, 'Nature Made', 100, '45678900234', 'Healthcare');
INSERT INTO Product VALUES ('UTU624', 'Moov', 100, '45678901234', 'Healthcare');
INSERT INTO Product VALUES ('UTC636', 'Volini, 100, '45678901234', 'Healthcare');
INSERT INTO Product VALUES ('GMT648', 'Vicks VapoRub', 100, '23456789124', 'Healthcare');
INSERT INTO Product VALUES ('AMS650', 'Zandu Balm', 100, '23456789124', 'Healthcare');
INSERT INTO Product VALUES ('AIM662', 'Nexfen Plus Gel', 100, '67132648713', 'Healthcare');
INSERT INTO Product VALUES ('NET674', 'AVA('ABC123', Biothrax)', 100, '67132648713', 'Vaccine');
INSERT INTO Product VALUES ('IND686', 'VaxChora', 100, '42739230089', 'Vaccine');
INSERT INTO Product VALUES ('DEL698', 'Td('ABC123', Tenivac)', 100, '30941324893', 'Vaccine');
INSERT INTO Product VALUES ('KNP700', 'Havrix', 100, '45678900234', 'Vaccine');
INSERT INTO Product VALUES ('LKO711', 'Engerix-B', 100, '45678901234', 'Vaccine');
INSERT INTO Product VALUES ('AGR724', 'Fluad', 100,'45678901234', 'Vaccine');
INSERT INTO Product VALUES ('KAL736', 'MMR ('ABC123', M-M-R II)', 100, '99886778934', 'Vaccine');
INSERT INTO Product VALUES ('KOL748', 'MMRV ('ABC123', ProQuad)', 100, '30941324893', 'Vaccine');
INSERT INTO Product VALUES ('HYD750, 'YF-Vax', 100, '45678901234', 'Vaccine');
INSERT INTO Product VALUES ('AGO762', 'Vivotif', 100, '12345678914', 'Vaccine');
INSERT INTO Product VALUES ('ALO747', 'Infanrix', 100, '23456789124', 'Vaccine');
INSERT INTO Product VALUES ('ALU786', 'Vaccinia ('ABC123', ACAM2000)', 100, '23456789124', 'Vaccine');
INSERT INTO Product VALUES ('ALS798', 'Imovax Rabies', 100, '13579086421', 'Vaccine');
INSERT INTO Product VALUES ('HIT800', 'Ipol', 100, '34567891245', 'Vaccine');
INSERT INTO Product VALUES ('KIL811', 'PCV13 ('ABC123', Prevnar13), 100, '13579086421', 'Vaccine');
INSERT INTO Product VALUES ('DIL824', 'Ixiaro', 100, '34567891245', 'Vaccine');




--Healthcare 


INSERT INTO Healthcare VALUES (‘PNR424','Diagnostics');
INSERT INTO Healthcare VALUES (‘IIT436','Diagnostics');
INSERT INTO Healthcare VALUES ('LOL448','Eyes, ears, nose, and throat');
INSERT INTO Healthcare VALUES (‘LMA450','Eyes, ears, nose, and throat');
INSERT INTO Healthcare VALUES ('ROF462','Eyes, ears, nose, and throat');
INSERT INTO Healthcare VALUES ('WOW474','First Aid');
INSERT INTO Healthcare VALUES ('SYX486','First Aid');
INSERT INTO Healthcare VALUES ('RTL498','First Aid');
INSERT INTO Healthcare VALUES ('RTT500','Oral Care');
INSERT INTO Healthcare VALUES ('ERT511','Oral Care');
INSERT INTO Healthcare VALUES ('DRT524','Oral Care');
INSERT INTO Healthcare VALUES ('XRT536','Vitamins and Supplements');
INSERT INTO Healthcare VALUES ('CRT548','Vitamins and Supplements');
INSERT INTO Healthcare VALUES ('CRR550','Vitamins and Supplements');
INSERT INTO Healthcare VALUES ('GRR562','Women health');
INSERT INTO Healthcare VALUES ('GST574','Women health');
INSERT INTO Healthcare VALUES ('GDP586','Women health');
INSERT INTO Healthcare VALUES ('GNP598','Diabetes Health');
INSERT INTO Healthcare VALUES ('PLZ600','Diabetes Health');
INSERT INTO Healthcare VALUES ('EWW611','Diabetes Health');
INSERT INTO Healthcare VALUES ('UTU624','Anti inflammatory');
INSERT INTO Healthcare VALUES ('UTC636','Anti inflammatory');
INSERT INTO Healthcare VALUES ('GMT648','Anti inflammatory');
INSERT INTO Healthcare VALUES ('AMS650','Anti inflammatory');
INSERT INTO Healthcare VALUES ('AIM662','Anti inflammatory');




--Vaccine 


INSERT INTO Vaccine VALUES ('NET674','Anthrax');
INSERT INTO Vaccine VALUES ('IND686','Cholera');
INSERT INTO Vaccine VALUES ('DEL698','Diphtheria');
INSERT INTO Vaccine VALUES ('KNP700','Hepatitis A');
INSERT INTO Vaccine VALUES ('LKO711','Hepatitis B');
INSERT INTO Vaccine VALUES ('AGR724','Seasonal Influenza');
INSERT INTO Vaccine VALUES ('KAL736','Measles');
INSERT INTO Vaccine VALUES ('KOL748','Mumps');
INSERT INTO Vaccine VALUES ('HYD750','Yellow Fever');
INSERT INTO Vaccine VALUES ('AGO762','Typhoid fever');
INSERT INTO Vaccine VALUES ('ALO774','Tetanus');
INSERT INTO Vaccine VALUES ('ALU786','Smallpox');
INSERT INTO Vaccine VALUES ('ALS798','Rabies');
INSERT INTO Vaccine VALUES ('HIT800','Polio');
INSERT INTO Vaccine VALUES ('KIL811,'Pneumococcal');
INSERT INTO Vaccine VALUES ('DIL824','Japanese Encephalitis');




--Medicine 


INSERT INTO Medicine VALUES ('ABC012', 'Antipyretics');
INSERT INTO Medicine VALUES ('BCD123', 'Antipyretics');
INSERT INTO Medicine VALUES ('CDE234', 'Antipyretics');
INSERT INTO Medicine VALUES ('DEF345', 'Antipyretics');
INSERT INTO Medicine VALUES ('EFG456', 'Antipyretics');
INSERT INTO Medicine VALUES ('FGH567', 'Antipyretics');
INSERT INTO Medicine VALUES ('GHI678', 'Antipyretics');
INSERT INTO Medicine VALUES ('HIJ789', 'Antipyretics');
INSERT INTO Medicine VALUES ('IJK890', 'Antipyretics');
INSERT INTO Medicine VALUES ('JKL901', 'Antipyretics');
INSERT INTO Medicine VALUES ('KLM011', 'Antibiotic');
INSERT INTO Medicine VALUES ('LMN122', 'Antibiotic');
INSERT INTO Medicine VALUES ('MNO233', 'Antibiotic');
INSERT INTO Medicine VALUES ('NOP344', 'Antibiotic');
INSERT INTO Medicine VALUES ('OPQ455', 'Antibiotic');
INSERT INTO Medicine VALUES ('PQR566', 'Antibiotic');
INSERT INTO Medicine VALUES ('QRS677', 'Antibiotic');
INSERT INTO Medicine VALUES ('RST788', 'Antibiotic');
INSERT INTO Medicine VALUES ('STU899', 'Antibiotic');
INSERT INTO Medicine VALUES ('TUV900', 'Antibiotic');
INSERT INTO Medicine VALUES ('UVW124', 'Antibiotic');
INSERT INTO Medicine VALUES ('VWX136', 'Antibiotic');
INSERT INTO Medicine VALUES ('WXY148', 'Antibiotic');
INSERT INTO Medicine VALUES ('XYZ150', 'Antibiotic');
INSERT INTO Medicine VALUES ('YZA162','Antibiotic');
INSERT INTO Medicine VALUES ('ZAB174', 'Antibiotic');
INSERT INTO Medicine VALUES ('ABB186', 'Antibiotic');
INSERT INTO Medicine VALUES ('BCC198', 'Antibiotic');
INSERT INTO Medicine VALUES ('CDD100', 'Antibiotic');
INSERT INTO Medicine VALUES ('DEE012', 'Antibiotic');
INSERT INTO Medicine VALUES ('EFF123', 'Antibiotic');
INSERT INTO Medicine VALUES ('FGG234'', 'Antibiotic');
INSERT INTO Medicine VALUES ('GHH345', 'Antibiotic');
INSERT INTO Medicine VALUES ('HII456', 'Antibiotic');
INSERT INTO Medicine VALUES ('IJJ567', 'Antibiotic');
INSERT INTO Medicine VALUES ('JKK678', 'Antibiotic');
INSERT INTO Medicine VALUES ('KLL789', 'Antibiotic');
INSERT INTO Medicine VALUES ('LMM890', 'Analgesic');
INSERT INTO Medicine VALUES ('MNN901', 'Analgesic');
INSERT INTO Medicine VALUES ('NOO011', 'Analgesic');
INSERT INTO Medicine VALUES ('OPP122', 'Analgesic');
INSERT INTO Medicine VALUES ('PQQ233', 'Analgesic');
INSERT INTO Medicine VALUES ('QRR344', 'Analgesic');
INSERT INTO Medicine VALUES ('RSS455', 'Analgesic');
INSERT INTO Medicine VALUES ('STT566', 'Analgesic');
INSERT INTO Medicine VALUES ('TUU677', 'Analgesic');
INSERT INTO Medicine VALUES ('UVV788', 'Antihistamine');
INSERT INTO Medicine VALUES ('VWW899', 'Antihistamine');
INSERT INTO Medicine VALUES ('WXX900', 'Antihistamine');
INSERT INTO Medicine VALUES ('XYY124', 'Antihistamine');
INSERT INTO Medicine VALUES ('YZZ136', 'Antihistamine');
INSERT INTO Medicine VALUES ('ZAA148', 'Antihistamine');
INSERT INTO Medicine VALUES ('ABD150', 'Antihistamine');
INSERT INTO Medicine VALUES ('ADB162', 'Antihistamine');
INSERT INTO Medicine VALUES ('ACB174', 'Antihistamine');
INSERT INTO Medicine VALUES ('BCE186', 'Antiviral');
INSERT INTO Medicine VALUES ('BEC198', 'Antiviral');
INSERT INTO Medicine VALUES ('EBC224', 'Antiviral');
INSERT INTO Medicine VALUES ('ECB236', 'Antiviral');
INSERT INTO Medicine VALUES ('DEG248', 'Antiviral');
INSERT INTO Medicine VALUES ('GDE250', 'Antiviral');
INSERT INTO Medicine VALUES ('EDG262', 'Antiviral');
INSERT INTO Medicine VALUES ('FIH274', 'Antiviral');
INSERT INTO Medicine VALUES ('IHF286', 'Antiviral');
INSERT INTO Medicine VALUES ('FHI298', 'Antiviral');
INSERT INTO Medicine VALUES ('HIF200', 'Anesthetic');
INSERT INTO Medicine VALUES ('JKO300', 'Anesthetic');
INSERT INTO Medicine VALUES ('OKJ311', 'Anesthetic');
INSERT INTO Medicine VALUES ('KJO324', 'Anesthetic');
INSERT INTO Medicine VALUES ('BTS336', 'Anesthetic');
INSERT INTO Medicine VALUES ('TCS348', 'Anesthetic');
INSERT INTO Medicine VALUES ('MBB350', 'Anesthetic');
INSERT INTO Medicine VALUES ('TMC362', 'Anesthetic');
INSERT INTO Medicine VALUES ('TGB374', 'Anesthetic');
INSERT INTO Medicine VALUES ('HIM386', 'Anesthetic');
INSERT INTO Medicine VALUES ('HNM398', 'Tranquilizers');
INSERT INTO Medicine VALUES ('JNJ400', 'Tranquilizers');
INSERT INTO Medicine VALUES ('BNR411', 'Tranquilizers');




--Distributor 


INSERT INTO Distributor VALUES ('SP0001','Vitarich@gmail.com','Vineeth','07AAACB5343E1Z3','Gurgoan');
INSERT INTO Distributor VALUES ('SP0002','Vitnach@gmail.com','Anirudh','24AAACB5343E1Z7','Gujarat');
INSERT INTO Distributor VALUES ('SP0003','Finamin@gmail.com','Chinthan','06AAACB5343E1Z5','Karnal');
INSERT INTO Distributor VALUES ('SG0001','Omsergy@gmail.com','Anand','29AAACB5343E2ZW',Vijayawada');
INSERT INTO Distributor VALUES ('SY0001','Exicof@gmail.com','Amith','32AAACB5343E1ZA','Mangaluru');
INSERT INTO Distributor VALUES ('SG0002','Parabufen@gmail.com','Ruchith','27AAACB5343E1Z1','Calicut');
INSERT INTO Distributor VALUES ('SG0003','Tinizoa@gmail.com','Phalguni','23AAACB5343E1Z9','Agra');
INSERT INTO Distributor VALUES ('SG0004','Norseptin@gmail.com','Janvi','03AAACB5343E1ZB','Amaravati');
INSERT INTO Distributor VALUES ('SP0005','Amoxyn@gmail.com','Amoxycillin Oral Suspension','Syrup','BOT','1x1','M','B');
INSERT INTO Distributor VALUES ('SG0005','Rhinacet@gmail.com','Bindu','33AAACB5343E1Z8','Nagpur');
INSERT INTO Distributor VALUES ('SG0006','Desloratadine@gmail.com','Zeel','36AAACB5343E1Z2','Pune');
INSERT INTO Distributor VALUES ('SG0007','Atorvastatin@gmail.com','Harin','36AAACB5343E1Z2','Gunur');
INSERT INTO Distributor VALUES ('SG0008','Montehist@gmail.com','Parth','19AAACB5343E1ZY','Bangalur');
INSERT INTO Distributor VALUES ('SG0009','Omecid@gmail.com','Aravind','37AADCB2230M2ZR','Shimla');
INSERT INTO Distributor VALUES ('SG0010','Zetry@gmail.com','Purvil','07AADCB2230M1ZV',Kanpur');
INSERT INTO Distributor VALUES ('SG0011','Lotenz@gmail.com','Prashanth','24AADCB2230M1Z2','Lucknow');
INSERT INTO Distributor VALUES ('SG0012','Coldrest@gmail.com','Nikunj','06AADCB2230M1ZX','Manali');
INSERT INTO Distributor VALUES ('SG0013','Albex@gmail.com','Mohil','29AADCB2230M1ZP','Dharmashala');
INSERT INTO Distributor VALUES ('SG0014','Ultramol250@gmail.com','Aniket','32AADCB2230M1Z2','Ananthapur');
INSERT INTO Distributor VALUES ('SG0015','Ultramol@gmail.com','Jay','27AADCB2230M1ZT','Patna');
INSERT INTO Distributor VALUES ('SG0016','Q-Bact@gmail.com','Rutwik','23AADCB2230M1Z1','Calcutta');
INSERT INTO Distributor VALUES ('SG0017','Q-Bact@gmail.com','Rohan','21AADCB2230M1Z5','Bhuvaneshwar');




--Warehouse 


INSERT INTO warehouse VALUES ('VT001','6/76, Nr Aggarwal Sweets, Rajinder Nagar Delhi',’SP0001’,10000);
INSERT INTO warehouse VALUES ('VT002','Har Indl Est, A-1 Dhanraj Mill Compound, Delisle Road Mumbai','SP0002',50000);
INSERT INTO warehouse VALUES ('PC001',' 101, Star Delta Indl Est, A K Rd, Andheri Mumbai','SP0003',20000);
INSERT INTO warehouse VALUES ('NB001','139, Bapu Kothe Street, Mandvi chennai','SG0001',20000);
INSERT INTO warehouse VALUES ('NB002','17, Radhika Society, Giaan Chowk Panaji - 174044 vijayawada','SY0001',30000);
INSERT INTO warehouse VALUES ('PR001','37, Manoj Society, Chinchwad Nagpur - 333793 Madhyapradesh','SG0002',50000);
INSERT INTO warehouse VALUES ('PR002','402 - Swarna Jayanti Sadan Deluxe, Dr. B.D. Marg, New Delhi ','SG0003',10000);
INSERT INTO warehouse VALUES ('PR003','Peevees Mirage, Nilambur P.O., Malappuram District, Kerala','SG0004',10000);
INSERT INTO warehouse VALUES ('NB003','K-1553, Palam Vihar, Gurgaon, Haryana','SP0005',40000);
INSERT INTO warehouse VALUES ('NB004','Prabhat Lodge, Lower Kelston, Shimla','SG0005',10000);
INSERT INTO warehouse VALUES ('NB005','Anjanam, Easwara Vilasam Road, Thiruvananthapuram','SG0006',40000);
INSERT INTO warehouse VALUES ('NB006','647, 'Savindhan' Gandhi Nagar, Near. Guru Nanak Hospital, Bandra (East),Mumbai ','SG0007',30000);
INSERT INTO warehouse VALUES ('OR001','Bungalow No. 2, Panama Chowk, Gandhi Nagar, Jammu.','SG0009',15000);
INSERT INTO warehouse VALUES ('OR002','H. No. 94, Ellora Enclave, Dayal Bagh, Thana New Agra, Distt. Agra, Uttar Pradesh.','SG0011',11000);
INSERT INTO warehouse VALUES ('OR003','LKRB Road, Bye-Lane-3, House No. 5, Nabin Nagar, Guwahati, P.S. Geetanagar, Distt. - Kamrup (M), Assam.','SG0012',20000);
INSERT INTO warehouse VALUES ('OR004','151- Janta Kuteer, Dharmshala Road, Hardoi (U.P.)','SG0013',10000);
INSERT INTO warehouse VALUES ('OR005','H No. 7, Sector 8-A, Chandigarh ',’SP0013’,10000);
INSERT INTO warehouse VALUES ('OR006','86, Ramlal Bazar, Kishalay School Lane,Haltu, Kolkata.','SG0014',30000);
INSERT INTO warehouse VALUES ('OR007','Door No. 18, 29th Street, Thillai Ganga Nagar, Nanganallur, Chennai','SG0015',20000);
INSERT INTO warehouse VALUES ('NB007','Village Bhunder, P.O. Sardulgarh, District Mansa (Punjab)','SG0016',15000);
INSERT INTO warehouse VALUES ('OR008','H.No. 3, Bhagadattapur, Amarnath Temple path Beltola, Guwahati.','SG0017',35000);
INSERT INTO warehouse VALUES ('OR009','Old No. 37/135, New 10/135, Salem Main Road, Mettur Dam, Salem District, Tamil Nadu ','SG0018',15000);
INSERT INTO warehouse VALUES ('NB008','Jupiter Innovision Centre, 54, Richmond Road, Bengaluru','SG0019',10000);
INSERT INTO warehouse VALUES ('NB009','Yashodhan, 212/51, Rambaug Colony,Navi-Peth,Pune','SG0020',25000);
INSERT INTO warehouse VALUES ('NB010','16A Dowhill Road, Ward No. 6, P.O. & P.S.- Kurseong, Dist-Darjeeling, West Bengal','SG0010',20000);
INSERT INTO warehouse VALUES ('NB011','H.No.8-2-269/5/29, Sagar Society, Road No.2, Banjara Hills, Hyderabad',’SG0008',30000);




--Attendant 


INSERT INTO Attendant VALUES ('A01','Anandhi','D','VT001',’9284571548’);
INSERT INTO Attendant VALUES ('A02','Aradhya','D','PR001',’8521476248’);
INSERT INTO Attendant VALUES ('A03','Ananya','D','PC001',’7584624589’);
INSERT INTO Attendant VALUES ('A04','Tara','D','NB001',’8541279845’);
INSERT INTO Attendant VALUES ('A05','Anushka','D','VT002',’8541279658’);
INSERT INTO Attendant VALUES ('A06','Deepika','D','PR002',’9658741248’);
INSERT INTO Attendant VALUES ('A07','Alia','D','PR003',’9874574894’);
INSERT INTO Attendant VALUES ('A08','Pooja','N','PR003',’7484157498’);
INSERT INTO Attendant VALUES ('A09','Shradha','N','VT002',’74100258741’);
INSERT INTO Attendant VALUES ('A10','Anushka','N','PR003',’8541762458’);
INSERT INTO Attendant VALUES ('A11','Kajol','D','NB004',’7498561478’);
INSERT INTO Attendant VALUES ('A12','Kareena','N','NB004',’8457149876’);
INSERT INTO Attendant VALUES ('A13','Katrina','D','NB005',’9875487948’);
INSERT INTO Attendant VALUES ('A14','Priyanka','N','NB005',’8549678419’);
INSERT INTO Attendant VALUES ('A15','Madhuri','D','NB006',’8549621478’);
INSERT INTO Attendant VALUES ('A16','Samantha','N','NB006',’8549678415’);
INSERT INTO Attendant VALUES ('A17','Sameera','D','OR001',’9674158746’);
INSERT INTO Attendant VALUES ('A18','Rashi','D','OR002',’9826547159’);
INSERT INTO Attendant VALUES ('A19','Shreya','D','NB003',’7568410298’);
INSERT INTO Attendant VALUES ('A20','Jenelia','D','SG0011',’8541267984’);




--Batch 


INSERT INTO Batch VALUES ('07/05/2019','2250000','BT001','ABC012','07/04/2018');
INSERT INTO Batch VALUES ('05/08/2019','2100000','BT002','BCD123','05/07/2018');
INSERT INTO Batch VALUES ('21/01/2020','1600000','BT003','CDE234','21/12/2018');
INSERT INTO Batch VALUES ('14/03/2019','150000','BT004,'DEF345','14/02/2018');
INSERT INTO Batch VALUES ('18/03/2019','1600000','BT005','EFG456','18/02/2018');
INSERT INTO Batch VALUES ('16/06/2020','1500000','BT006','FGH567','16/05/2019');
INSERT INTO Batch VALUES ('10/06/2019','1500000'','BT007','GHI678','10/05/2018');
INSERT INTO Batch VALUES ('28/04/2019','4100000','BT008','HIJ789','28/03/2018');
INSERT INTO Batch VALUES ('14/04/2019','12000000','BT009','IJK890','14/03/2018');
INSERT INTO Batch VALUES ('10/04/2019','6500000','BT010','JKL901','10/03/2018');
INSERT INTO Batch VALUES ('09/12/2019','500000','BT011','KLM011','09/11/2018');
INSERT INTO Batch VALUES ('03/01/2019','200000','BT012','LMN122','03/11/2017');
INSERT INTO Batch VALUES ('26/04/2019','3000000','BT013','MNO233','26/03/2018');
INSERT INTO Batch VALUES ('22/09/2019','100000','BT014','NOP344','22/08/2018');
INSERT INTO Batch VALUES ('25/04/2019','750000','BT015','OPQ455','25/03/2018');
INSERT INTO Batch VALUES ('13/12/2019','1800000','BT016','PQR566','13/11/2018');
INSERT INTO Batch VALUES ('17/04/2019','8185000','BT017','QRS677','17/03/2018');
INSERT INTO Batch VALUES ('24/08/2019','5000000','BT018','RST788','24/07/2018');
INSERT INTO Batch VALUES ('02/07/2019','200000','BT019','STU899','02/06/2018');




--Bought_From 


INSERT INTO Bought_From VALUES ('10/12/2018','50','10','ABC012','SP0001','VT001','BT001');
INSERT INTO Bought_From VALUES ('05/09/2018','210','20','BCD123','SP0002','VT002','BT002');
INSERT INTO Bought_From VALUES ('21/04/2019','145','4','CDE234','SG0001','PC001','BT003');
INSERT INTO Bought_From VALUES ('30/01/2019','82','9','DEF345','SY0001','NB001','BT004');
INSERT INTO Bought_From VALUES ('14/06/2018','64','6','EFG456','SG0002','NB002','BT005');
INSERT INTO Bought_From VALUES ('18/03/2019','950','34','FGH567','SG0004','PR001','BT006');
INSERT INTO Bought_From VALUES ('19/09/2018','84','7','GHI678','SG0005','PR002','BT007');
INSERT INTO Bought_From VALUES ('16/11/2019’,'540','17','HIJ789','SG0006','PR003','BT008');
INSERT INTO Bought_From VALUES ('10/10/2018','510','13','IJK890','SG0007','NB003','BT009');
INSERT INTO Bought_From VALUES ('28/06/2018','18','2','JKL901','SG0008','NB004','BT010');
INSERT INTO Bought_From VALUES ('14/07/2018','320','16','KLM011','SG0009','NB005','BT011');
INSERT INTO Bought_From VALUES ('19/08/2018','50','4','LMN122','SG0010','NB006','BT012');
INSERT INTO Bought_From VALUES ('09/01/2019','48','6','MNO233','SG0011','OR001','BT013');
INSERT INTO Bought_From VALUES ('03/05/2018','32','4','NOP344','SG0012','OR002','BT014');
INSERT INTO Bought_From VALUES ('26/09/2018','420','21','OPQ455','SG0013','OR003','BT015');
INSERT INTO Bought_From VALUES ('31/12/2018','520','14','PQR566','SG0014','OR004','BT016');
INSERT INTO Bought_From VALUES ('25/05/2018','630','9','QRS677','SG0015','OR005','BT017');
INSERT INTO Bought_From VALUES ('13/02/2019,'100','10','RST788','SG0016','OR006','BT018');
INSERT INTO Bought_From VALUES ('17/06/2018','330','11','STU899','SG0017','OR007','BT019');
INSERT INTO Bought_From VALUES ('24/10/2018','180','6','TUV900','SG0018','OR008','BT020');
INSERT INTO Bought_From VALUES ('02/08/2018','72','8','UVW124','SG0001','OR009','BT021');




--Membership 


INSERT INTO Membership VALUES ('PSQ10000','6','50','Vinay');
INSERT INTO Membership VALUES ('PSQ10001','2','40','Priya');
INSERT INTO Membership VALUES ('PSQ10002','4','25','Vinodh');
INSERT INTO Membership VALUES ('PSQ10003','6','25','Phalguni');
INSERT INTO Membership VALUES ('PSQ10004','5','30','Om');
INSERT INTO Membership VALUES ('PSQ10005','2','20','Tarun');
INSERT INTO Membership VALUES ('PSQ10006','1','25','Nooran');
INSERT INTO Membership VALUES ('PSQ10007','2','30','Payal');
INSERT INTO Membership VALUES ('PSQ10008','4','20','Amith');
INSERT INTO Membership VALUES ('PSQ10009','2','50','Rhea');
INSERT INTO Membership VALUES ('PSQ10010','2','25','Atarv');
INSERT INTO Membership VALUES ('PSQ10011','5','50','Monith');
INSERT INTO Membership VALUES ('PSQ10012','1','40','Varun');
INSERT INTO Membership VALUES ('PSQ10013','6','25','Zeel');
INSERT INTO Membership VALUES ('PSQ10014','4','50','Alekya');
INSERT INTO Membership VALUES ('PSQ10015','2','30','Umesh');
INSERT INTO Membership VALUES ('PSQ10016','4','30','Chandini');
INSERT INTO Membership VALUES ('PSQ10017','6','25','Urvi');
INSERT INTO Membership VALUES ('PSQ10018','1','40','Lohitha');
INSERT INTO Membership VALUES ('PSQ10019','3','25','Karthik');




--Customer 


INSERT INTO Customer VALUES ('01PD','Vinay','789546318','M','10','PSQ10000');
INSERT INTO Customer VALUES ('02PD','Vinodh','9874658794','M','16','PSQ10001');
INSERT INTO Customer VALUES ('03PD','Phalguni','8741975864','F','45','PSQ10002');
INSERT INTO Customer VALUES ('04PD','Om','9685687412','M','19','PSQ10003');
INSERT INTO Customer VALUES ('05PD','payal','9398219817','F','30','PSQ10004');
INSERT INTO Customer VALUES ('06PD','Priya','8046719824','F','25','PSQ10005');
INSERT INTO Customer VALUES ('07PD','Tarun ','7541893548','M','65','PSQ10006');
INSERT INTO Customer VALUES ('08PD','Noran','9855748918','M','40','PSQ10007');
INSERT INTO Customer VALUES ('09PD','Amith','8214567089','M','45','PSQ10008');
INSERT INTO Customer VALUES ('10PD','Rhea','7415784198','F','34''PSQ10009');
INSERT INTO Customer VALUES ('11PD','Deshimukh','7401247895','M','10','PSQ10010');
INSERT INTO Customer VALUES ('12PD','Atarv','9578461247','M','15','PSQ10011');
INSERT INTO Customer VALUES ('13PD','Monith','7418745187','M','40''PSQ10012');
INSERT INTO Customer VALUES ('14PD','Varun','8471564798','M','40','PSQ10013’);
INSERT INTO Customer VALUES ('15PD','Zeel','9875648798','F','41','PSQ10014');
INSERT INTO Customer VALUES ('15PD','Lohitha','9874187498','F','41','PSQ10015');
INSERT INTO Customer VALUES ('16PD','Chandini','7489756148','F','24','PSQ10016');
INSERT INTO Customer VALUES ('17PD','Alekya','9856748159','F','15','PSQ10017’);
INSERT INTO Customer VALUES ('18PD','Umesh','8475612478','M','24','PSQ10018');
INSERT INTO Customer VALUES ('19PD','Urvi','7418745698','F','40','PSQ10019');
INSERT INTO Customer VALUES ('20PD','karthik','9853001475','M','32','PSQ10019');




--Employee 


INSERT INTO Employee VALUES ('SSN001','Praneeth ','5000','15/10/2018');
INSERT INTO Employee VALUES ('SSN002','Vineeth','7000','15/10/2018');
INSERT INTO Employee VALUES ('SSN003','Prakash','7000','21/09/2017');
INSERT INTO Employee VALUES ('SSN004','Shradha','5000','15/03/2011');
INSERT INTO Employee VALUES ('SSN005','Ranbir','6000','20/05/2015');
INSERT INTO Employee VALUES ('SSN006','Ranveer','4000','30/12/2014');
INSERT INTO Employee VALUES ('SSN007','Rahul','6000','05/09/2016');
INSERT INTO Employee VALUES ('SSN009','Lalitha','4000','22/11/2014');
INSERT INTO Employee VALUES ('SSN010','Niharika','6000','14/01/2016');
INSERT INTO Employee VALUES ('SSN011','Yashvi','5000','04/12/2009');
INSERT INTO Employee VALUES ('SSN012','Karan','8000','09/02/2016');
INSERT INTO Employee VALUES ('SSN013','Brinda','4000','09/06/2014');
INSERT INTO Employee VALUES ('SSN014','Bhavik','5000','24/04/2012');
INSERT INTO Employee VALUES ('SSN015','Hareesh','2000','25/06/2013');
INSERT INTO Employee VALUES ('SSN016','Nithin','4000','26/05/2015');
INSERT INTO Employee VALUES ('SSN017','Laksh','6000','09/04/2012');
INSERT INTO Employee VALUES ('SSN018','Rakesh','5000','20/06/2017');
INSERT INTO Employee VALUES ('SSN019','Dharmesh','4000','30/12/2018');




--Sold_To 


INSERT INTO Sold_To VALUES ('ABC012','01-09-18','07/05/2018','10','34567891245','225000','01PD','BT001', ‘SSN001’);
INSERT INTO Sold_To VALUES ('BCD123','02-09-18','05/08/2018','8','45678901234','210000','02PD','BT002','SSN002');
INSERT INTO Sold_To VALUES ('CDE234','03-09-18','21/01/2019','6','45678900234','160000','03PD','BT003','SSN003');
INSERT INTO Sold_To VALUES ('DEF345','04-09-18','14/03/2018','7','45678900034','15000','04PD','BT004','SSN004');
INSERT INTO Sold_To VALUES ('EFG456','05-09-18','18/03/2018','4','13579086421','160100','20PD','BT005','SSN005');
INSERT INTO Sold_To VALUES ('FGH567','06-09-18','16/06/2019','6','99886778934','150000','05PD','BT006','SSN006');
INSERT INTO Sold_To VALUES ('GHI678','07-09-18','10/06/2018','7','42739230089','150000','06PD','BT007','SSN007');
INSERT INTO Sold_To VALUES ('HIJ789','08-09-18','28/04/2018','6','13412342314','410000','07PD','BT008','SSN008');
INSERT INTO Sold_To VALUES ('IJK890','09-09-18','14/04/2018','5','67132648713','1200000','08PD','BT009','SSN009');
INSERT INTO Sold_To VALUES ('JKL901','10-09-18','10/04/2018','4','71389479813','650000','09PD','BT010','SSN010');
INSERT INTO Sold_To VALUES ('KLM011','11-09-18','09/12/2018','8','28402342389','50000','10PD','BT011','SSN011');
INSERT INTO Sold_To VALUES ('LMN122','12-09-18','03/01/2018','6','34567891245','20000','11PD','BT012','SSN012');
INSERT INTO Sold_To VALUES ('MNO233','13-09-18','26/04/2018','5','45678901234','300000','12PD','BT013','SSN013');
INSERT INTO Sold_To VALUES ('NOP344','14-09-18','22/09/2018','8','45678900234','10000','13PD','BT014','SSN014');
INSERT INTO Sold_To VALUES ('OPQ455','15-09-18','25/04/2018','4','45678900034','75000','14PD','BT015','SSN015');
INSERT INTO Sold_To VALUES ('PQR566','16-09-18','13/12/2018','7','13579086421','180000','15PD','BT016','SSN016');
INSERT INTO Sold_To VALUES ('QRS677','17-09-18','17/04/2018','7','99886778934','818500','16PD,'BT017','SSN017');
INSERT INTO Sold_To VALUES ('RST788','18-09-18','24/08/2018','5','42739230089','500000','17PD','BT018','SSN018');
INSERT INTO Sold_To VALUES ('STU899','19-09-18','02/07/2018','8','13412342314','21000','18PD','BT019','SSN019);




--Doctor 


INSERT INTO Doctor VALUES ('GN0001','7418749682','Kamineni Hosp, L B Nagar Hyderabad, Andhra Pradesh','Mithun');
INSERT INTO Doctor VALUES ('GN0002','8471547624','Shop No 2, Shripati Chhaya, M.g.road, Near Saraswati Marathi School, Thane (w) Mumbai,Maharashtra','Maya');
INSERT INTO Doctor VALUES ('GN0003','9874578418','Minerva Compound, Bunder Road, Sewri (east) Mumbai, Maharashtra','Varun');
INSERT INTO Doctor VALUES ('GN0004','9578416347','238/3 1st Floor, Punja Sharif Delhi, Delhi','Prashanth');
INSERT INTO Doctor VALUES ('GN0005','8574164789','118, Vasant Apartment, Vasant Vihar Delhi','Kirthan');
INSERT INTO Doctor VALUES ('GN0006','9576201487','24/a/2, Brindavan Soc, Brindavan Rd, Thane (west) Mumbai, Maharashtra','Surya');
INSERT INTO Doctor VALUES ('GN0007','7451249874','102, Lb Road, Double Junction, Double Junction Bangalore, Karnataka','Sandesh');
INSERT INTO Doctor VALUES ('GN0008','8476201498','Shop No 5, Tapi Baug, C.s.road, Near Jari Mari Garden, Opp Anand Nagar, Dahisar Mumbai, Maharashtra','Umesh');
INSERT INTO Doctor VALUES ('GN0009','8012468874','4035 - 36, Haryana Building, Chawri Bazar Delhi, Delhi','Jathin');
INSERT INTO Doctor VALUES ('GN0010','9417854687','7-1-59/4, Above Syndicate Bank, Ameerpet Hyderabad, Andhra Pradesh,','Daivik');
INSERT INTO Doctor VALUES ('GN0011','7012204568','F 4 1st Floor, Part 3 Delhi, Delhi','Anirudh');
INSERT INTO Doctor VALUES ('GN0012','7489658749','H-17/242, Rohini Delhi, Delhi, ','Anil');
INSERT INTO Doctor VALUES ('GN0013','7685598014','Shop No 1, Super Gas Bldg, S V Road, Dahisar Mumbai, Maharashtra','Dev');
INSERT INTO Doctor VALUES ('GN0014','9686203578','0, 0, Gidc, Por Ramangamdi Vadodara, Gujarat','Harsha');
INSERT INTO Doctor VALUES ('GN0015','8501476259','14-15, Sterling Industrial Estat, Opp.gati Transport, Vasai (west) Mumbai, Maharashtra','Keerthi');
INSERT INTO Doctor VALUES ('GN0016','8401357985','2/3, Koli Samaj Bldg, Sewri (east) Mumbai, Maharashtra,','Gagan');
INSERT INTO Doctor VALUES ('GN0017','9685569823','50-56, Shivananda Building, 1st Floor, Mamulpet Bangalore, Karnataka','Lahari');
INSERT INTO Doctor VALUES ('GN0018','9398821918','A1 Kasturi Plaza Manpada Road, Manpada Mumbai, Maharashtra','Mahesh');




--Referred_By 


INSERT INTO Referred_By VALUES ('GN0001','01PD','000001');
INSERT INTO Referred_By VALUES ('GN0002','02PD','000002');
INSERT INTO Referred_By VALUES ('GN0003','03PD','000003');
INSERT INTO Referred_By VALUES ('GN0004','04PD','000004');
INSERT INTO Referred_By VALUES ('GN0005','05PD','000005');
INSERT INTO Referred_By VALUES ('GN0006','06PD','000006');
INSERT INTO Referred_By VALUES ('GN0007','07PD','000007');
INSERT INTO Referred_By VALUES ('GN0008','08PD','000008');
INSERT INTO Referred_By VALUES ('GN0009','09PD','000010');
INSERT INTO Referred_By VALUES ('GN0010','10PD','000009');
INSERT INTO Referred_By VALUES ('GN0011','11PD','000011');
INSERT INTO Referred_By VALUES ('GN0012'12PD','000012');
INSERT INTO Referred_By VALUES ('GN0013','13PD','000013');
INSERT INTO Referred_By VALUES ('GN0014','14PD','000014');
INSERT INTO Referred_By VALUES ('GN0015','15PD','000015');
INSERT INTO Referred_By VALUES ('GN0016','16PD','000016');
INSERT INTO Referred_By VALUES ('GN0017','17PD','000017');
INSERT INTO Referred_By VALUES ('GN0018''18PD','000018');




--Qualification 


INSERT INTO Qualification VALUES ('GN0001'','MBBS');
INSERT INTO Qualification VALUES ('GN0002','BDS');
INSERT INTO Qualification VALUES ('GN0003','MBBS');
INSERT INTO Qualification VALUES ('GN0004','BUMS');
INSERT INTO Qualification VALUES ('GN0005','BHMS ');
INSERT INTO Qualification VALUES ('GN0006','MS');
INSERT INTO Qualification VALUES ('GN0007','BHMS ');
INSERT INTO Qualification VALUES ('GN0008','BUMS');
INSERT INTO Qualification VALUES ('GN0009','MBBS');
INSERT INTO Qualification VALUES ('GN0010','MBBS');
INSERT INTO Qualification VALUES ('GN0011','BDS');
INSERT INTO Qualification VALUES ('GN0012','BHMS ');
INSERT INTO Qualification VALUES ('GN0013','MBBS');
INSERT INTO Qualification VALUES ('GN0014','BDS');
INSERT INTO Qualification VALUES ('GN0015','MS');
INSERT INTO Qualification VALUES ('GN0016','MBBS');