Insert Scripts.sql

USE PollynzDataTech
GO

--INSERT AddressType TABLES
INSERT INTO dbo.AddressType (AddressTypeID,Name)
VALUES
(1, 'Billing'),
(2, 'Home'),
(3, 'Main Office'),
(4, 'Primary')


--INSERT Address TABLES
INSERT INTO dbo.Address(AddressID, AddressTypeID, StreeAddress, City, PostalCode)
VALUES
(532,2,'500-75 Connor Street','Ottawa','K4B 1S2'),
(497,2,'9900 2700 Production Way','Burnaby','V5A 4X1'),
(29781,2,'00 rue Saint-Lazare','Dunkerque','59140'),
(24231,2,'02 place de Fontenoy','Verrieres Le Buisson','91370'),
(19637,2,'035 boulevard du Montparnasse','Verrieres Le Buisson','91370'),
(15671,2,'081 boulevard du Montparnasse','Saint-Denis','93400'),
(13079,2,'081 boulevard du Montparnasse','Seattle','98104'),
(21354,2,'084 boulevard du Montparnasse','Les Ulis','91940'),
(910,2,'1 Corporate Center Drive','Miami','33127'),
(322,2,'1 Mt. Dell Drive','Portland','97205'),
(12037,2,'1 Smiling Tree Court','Los Angeles','90012'),
(20437,2,'1 allée des Princes','Courbevoie','92400'),
(21843,2,'1 avenue des Champs-Elysées','Paris','75017'),
(12753,2,'1 boulevard Beau Marchais','Sèvres','92310'),
(20289,2,'1 cours Mirabeau','Roncq','59223'),
(16455,2,'1 place Beaubernard','Paris','75003'),
(18991,2,'1 place Beaubernard','Paris','75009'),
(27348,2,'1 place Beaubernard','Saint-Denis','93400'),
(26115,2,'1 place Beaubernard','Tremblay-en-France','93290'),
(29410,2,'1 place de Brazaville','Colomiers','31770'),
(26916,2,'1 place de Brazaville','Dunkerque','59140'),
(28885,2,'1 place de Brazaville','Lille','59000'),
(708,2,'1 place de la République','Paris','75017'),
(23902,2,'1 rue de Courtaboeuf','Lieusaint','77127'),
(20814,2,'1 rue de Courtaboeuf','Lille','59000'),
(29062,2,'1 rue de Courtaboeuf','Versailles','78000'),
(21273,2,'1 rue de Fontfroide','Paris','75003'),
(28830,2,'1 rue de l´Avenir','Chatou','78400'),
(17417,2,'1 rue de l´Avenir','Morangis','91420'),
(24416,2,'1 rue de la Cavalerie','Paris La Defense','92081'),
(21700,4,'1 rue de la Cavalerie','Roncq','59223'),
(15839,4,'1 rue de la Cavalerie','Sèvres','92310'),
(23481,4,'1 rue de la Centenaire','Cergy','95000'),
(29507,4,'1 rue de la Centenaire','Colombes','92700'),
(26346,4,'1 rue de la Centenaire','Les Ulis','91940'),
(11774,4,'1 rue de la Centenaire','Lille','59000'),
(22052,4,'1 rue de la Centenaire','Roubaix','59100'),
(28024,4,'1 rue de la Centenaire','Saint-Denis','93400'),
(18707,4,'1 rue de la Centenaire','Versailles','78000'),
(19300,4,'1 rue de Maubeuge','Metz','57000'),
(16304,4,'1 rue de Maubeuge','Morangis','91420'),
(16055,4,'1 rue de Maubeuge','Paris','75007'),
(27160,4,'1 rue de Maubeuge','Paris','75009'),
(19001,4,'1 rue de Maubeuge','Saint Germain en Laye','78100'),
(25114,2,'1 rue de Maubeuge','Villeneuve-d Ascq','59491'),
(26175,2,'1 rue de Varenne','Boulogne-Billancourt','92100'),
(23032,2,'1 rue de Varenne','Dunkerque','59140'),
(23381,2,'1 rue Georges-Clémenceau','Paris','75003'),
(23028,2,'1 rue Lamarck','Versailles','78000'),
(23625,2,'1 rue Pierre-Demoulin','Croix','59170'),
(21822,2,'1 rue Pierre-Demoulin','Les Ulis','91940'),
(22345,2,'1 rue Pierre-Demoulin','Orleans','45000'),
(13410,2,'1 rue Pierre-Demoulin','Paris','75007'),
(15845,2,'1 rue Pierre-Demoulin','Paris','75012'),
(19933,2,'1 rue Ste-Honoré','Saint Ouen','41100'),
(12062,2,'10 Napa Ct.','Lebanon','97355'),
(18835,2,'10 avenue de Norvege','Paris','75005'),
(18016,2,'10 avenue du Port','Roissy en Brie','77680'),
(12138,2,'10 avenue du Président-Kennedy','Paris','75019'),
(29409,2,'10 impasse Ste-Madeleine','Tremblay-en-France','93290'),
(29816,3,'10 place Beaubernard','Verrieres Le Buisson','91370'),
(17611,3,'10 place de Fontenoy','Roubaix','59100'),
(28379,3,'10 route de Marseille','Pantin','93500'),
(22261,3,'10 rue de l´Avenir','Suresnes','92150'),
(25952,3,'10 rue de la Centenaire','Saint-Denis','93400'),
(20955,3,'10 rue de la Comédie','Lille','59000'),
(23045,3,'10 rue de Maubeuge','Orleans','45000'),
(14096,3,'10 rue des Vendangeurs','Saint Germain en Laye','78100'),
(20738,2,'10 rue Lafayette','Paris','75007'),
(24898,2,'10 rue Lauriston','Bobigny','93000'),
(29847,2,'10 rue Philibert-Delorme','Paris','75007'),
(26855,2,'10 rue Pierre-Demoulin','Orleans','45000'),
(20876,2,'10 rue Royale','Courbevoie','92400'),
(16163,2,'10 rue Royale','Sèvres','92310'),
(911,2,'100 Fifth Drive','Millington','38054'),
(27590,2,'100 boulevard d´Albi','Paris','75006'),
(26489,2,'100 rue de la Centenaire','Paris La Defense','92081'),
(18967,2,'100 rue des Rosiers','Everett','98201'),
(18205,2,'100 rue des Rosiers','Pantin','93500'),
(29281,2,'100 rue Descartes','Boulogne-Billancourt','92100'),
(25486,2,'100 rue Jean Mermoz','Paris','75002'),
(25115,2,'100 rue Maillard','Roubaix','59100'),
(15272,2,'1000 Bidweld Street','Haney','V2W 1W2'),
(27558,2,'1001 rue des Bouchers','Paris','75012'),
(18858,2,'1001bis boulevard Saint Germain','Roubaix','59100'),
(26229,2,'1002 N. Spoonwood Court','Berkeley','94704'),
(24883,2,'1002 N. Spoonwood Court','Hervey Bay','4655'),
(19379,2,'1003 Matterhorn Ct','Lebanon','97355'),
(15776,3,'1004 rue des Bouchers','Paris','75019'),
(19638,3,'1005 Fremont Street','Colma','94014'),
(14068,3,'1005 Matterhorn Ct.','Cambridge','CB4 4BZ'),
(21245,3,'1005 Matterhorn Ct.','Mill Valley','94941'),
(25310,3,'1005 Tanager Court','Corvallis','97330'),
(23089,3,'1005 Tanager Court','Milsons Point','2061'),
(21707,3,'1005 Valley Oak Plaza','Langley','V3A 4R2'),
(28674,3,'1005 Valley Oak Plaza','London','SW6 SBY'),
(24412,3,'1005 rue des Bouchers','Colombes','92700'),
(19673,3,'1005 rue des Bouchers','Saint-Denis','93400'),
(19506,3,'1006 Deercreek Ln','Bellflower','90706'),
(21094,3,'1006 Deercreek Ln','Torrance','90505'),
(24427,4,'1007 Cardinet Dr.','El Cajon','92020'),
(22959,4,'1008 Lydia Lane','Burbank','91502'),
(24827,4,'1009 rue des Bouchers','Colomiers','31770'),
(11975,4,'101 Adobe Dr','Coffs Harbour','2450'),
(13715,4,'101 Adobe Dr','Puyallup','98371'),
(215,4,'101 Candy Rd.','Redmond','98052'),
(13669,4,'101 avenue de la Gare','Peterborough','PB12'),
(14087,4,'101 avenue de la Gare','Roissy en Brie','77680'),
(11832,4,'101 avenue des Champs-Elysées','Colombes','92700'),
(21677,4,'101 avenue Reille','Versailles','78000'),
(17455,4,'101 rue de Cambrai','Roubaix','59100'),
(25462,4,'101 rue de Terre Neuve','Paris','75010'),
(17558,4,'101 rue Léo Delibes','Paris','75009'),
(11383,4,'1010 Maple','Baltimore','21201'),
(14597,4,'1010 avenue de l´ Union Centrale','Saint Germain en Laye','78100'),
(21574,4,'1010 impasse Notre-Dame','Orleans','45000'),
(21686,4,'1011 Green St.','Bellingham','98225'),
(24373,4,'1011 Yolanda Circle','Berkeley','94704'),
(21121,4,'1011 Yolanda Circle','N. Vancouver','V7L 4J4'),
(25059,4,'1011 avenue Foch','Pantin','93500'),
(28226,4,'1013 Buchanan Rd','Port Macquarie','2444'),
(28485,4,'1013 Buchanan Rd','Yakima','98901'),
(25633,4,'1013 Holiday Hills Dr.','Bremerton','98312'),
(26683,4,'1013 Holiday Hills Dr.','Gateshead','GA10'),
(20313,4,'1015 Lynwood Drive','Metchosin','V9'),
(11855,4,'1016 Park Avenue','Burbank','91502'),
(15922,4,'1019 Book Road','Rhodes','2138'),
(25529,4,'1019 Buchanan Road','Woodland Hills','91364'),
(18917,4,'1019 Candy Rd.','Coffs Harbour','2450'),
(21281,2,'1019 Carletto Drive','Berkeley','94704'),
(12444,2,'1019 Chance Drive','Sedro Woolley','98284'),
(27779,2,'1019 Kenwal Rd.','Lake Oswego','97034'),
(28433,2,'1019 Mt. Davidson Court','Burien','98168'),
(17038,2,'1019 Mt. Davidson Court','London','SW8 4BG'),
(13354,2,'1019 Pennsylvania Blvd','Marysville','98270'),
(355,2,'102 Silverado Drive','W. Linn','97068'),
(27547,2,'102 Vista Place','Milton Keynes','MK8 8DF'),
(15015,2,'102 Vista Place','Santa Monica','90401'),
(11456,2,'102 rue de Berri','Les Ulis','91940'),
(12359,2,'1020 Book Road','Bremerton','98312'),
(25449,2,'1020 Carletto Drive','Matraville','2036'),
(27683,2,'1020 Carletto Drive','Santa Cruz','95062'),
(19089,2,'1020 quai de Grenelle','Croix','59170'),
(15467,2,'1020 quai de Grenelle','Versailles','78000'),
(33,2,'10203 Acorn Avenue','Calgary','T2P 2G8'),
(11706,2,'1023 Hawkins Street','Lebanon','97355'),
(27149,2,'1023 Hawkins Street','Townsville','4810'),
(26959,2,'1023 Riveria Way','Burbank','91502'),
(12148,2,'1023 Riviera Way','Oxford','OX1'),
(22014,2,'1024 Walnut Blvd.','Colma','94014'),
(29504,2,'1025 Holly Oak Drive','Leeds','LE18'),
(29096,2,'1025 R St.','Kirkland','98033'),
(12787,2,'1025 Yosemite Dr.','Oregon City','97045'),
(24604,2,'1025 Yosemite Dr.','Townsville','4810'),
(27875,2,'10257 avenue de l´Europe','Saint-Denis','93400'),
(21807,2,'1026 Mt. Wilson Pl.','Lynnwood','98036'),
(24165,2,'1026 Mt. Wilson Pl.','South Melbourne','3205'),
(20407,2,'1028 Green View Court','Chula Vista','91910'),
(18329,2,'1028 Green View Court','Oregon City','97045'),
(26805,2,'1028 Indigo Ct.','Issaquah','98027'),
(19489,2,'1028 Indigo Ct.','Warrnambool','3280'),
(24310,2,'1028 Royal Oak Rd.','Burlingame','94010'),
(27838,2,'1029 Birchwood Dr','Burien','98168'),
(14851,2,'1029 Birchwood Dr','Olympia','98501'),
(19207,2,'103 avenue des Champs-Elysées','Paris La Defense','92081'),
(17984,2,'103 rue de Fontfroide','Lille','59000'),
(17950,2,'1030 Ambush Dr.','Bury','PE17'),
(11856,2,'1032 Buena Vista','North Ryde','2113'),
(18817,2,'1032 Coats Road','Stoke-on-Trent','AS23'),
(16962,2,'1032 Cowell Road','Colombes','92700')


--INSERT PAIENTS TABLES
INSERT INTO dbo.Patient (patient_id,AddressID, first_name, last_name, date_of_birth, gender, phone_number, email_address, Emergency_Contact, Insurance_Information)
VALUES
(1,532,'John','Doe','05/15/1980','Male','555-123-4567','johndoe@email.com','Mary Smith','XYZ Insurance'),
(2,497,'Jane','Smith','02/20/1990','Female','555-987-6543','janesmith@email.com','Mike Johnson','ABC Insurance'),
(3,29781,'Robert','Johnson','11/10/1975','Male','555-567-8901','robertjohnson@email.com','Laura Davis','PQR Insurance'),
(4,24231,'Emily','Brown','07/03/1988','Female','555-234-5678','emilybrown@email.com','David Wilson','LMN Insurance'),
(5,19637,'Michael','Davis','09/25/1982','Male','555-345-6789','michaeldavis@email.com','Susan Clark','RST Insurance'),
(6,15671,'Sarah','Clark','04/12/1995','Female','555-789-0123','sarahclark@email.com','Daniel Miller','UVW Insurance'),
(7,13079,'William','Miller','12/30/1987','Male','555-123-8901','williammiller@email.com','Karen Turner','XYZ Insurance'),
(8,21354,'Amanda','Turner','08/05/1972','Female','555-345-6780','amandaturner@email.com','Joseph Hall','ABC Insurance'),
(9,910,'David','Hall','01/17/1993','Male','555-234-5670','davidhall@email.com','Catherine White','PQR Insurance'),
(10,322,'Jennifer','White','03/18/1989','Female','555-567-1234','jenniferwhite@email.com','Thomas Adams','LMN Insurance'),
(11,12037,'Daniel','Adams','06/24/1980','Male','555-123-4567','danieladams@email.com','Michelle Harris','RST Insurance'),
(12,20437,'Laura','Harris','07/27/1985','Female','555-987-6543','lauraharris@email.com','Paul Brown','UVW Insurance'),
(13,21843,'Matthew','Brown','10/02/1992','Male','555-567-8901','matthewbrown@email.com','Emily Smith','XYZ Insurance'),
(14,12753,'Jessica','Smith','09/12/1983','Female','555-234-5678','jessicasmith@email.com','Michael Turner','ABC Insurance'),
(15,20289,'Richard','Turner','04/15/1986','Male','555-345-6789','richardturner@email.com','Sarah Davis','PQR Insurance'),
(16,16455,'Mary','Davis','02/18/1997','Female','555-789-0123','marydavis@email.com','John Johnson','LMN Insurance'),
(17,18991,'Christopher','Johnson','11/23/1978','Male','555-123-8901','christopherjohnson@email.com','Jennifer Miller','RST Insurance'),
(18,27348,'Patricia','Miller','06/03/1984','Female','555-345-6780','patriciamiller@email.com','William Turner','XYZ Insurance'),
(19,26115,'Thomas','Turner','05/08/1989','Male','555-234-5670','thomasturner@email.com','Amanda Clark','ABC Insurance'),
(20,29410,'Elizabeth','Clark','07/21/1982','Female','555-567-1234','elizabethclark@email.com','Robert Hall','PQR Insurance'),
(21,26916,'John','Hall','09/29/1991','Male','555-123-4567','johnhall@email.com','Emily Adams','LMN Insurance'),
(22,28885,'Sarah','Adams','08/07/1994','Female','555-987-6543','sarahadams@email.com','Daniel Harris','RST Insurance'),
(23,708,'William','Harris','03/01/1981','Male','555-567-8901','williamharris@email.com','Jessica Turner','UVW Insurance'),
(24,23902,'Jennifer','Turner','12/12/1988','Female','555-234-5678','jenniferturner@email.com','Matthew Smith','XYZ Insurance'),
(25,20814,'Daniel','Smith','01/05/1987','Male','555-345-6789','danielsmith@email.com','Laura Brown','ABC Insurance'),
(26,29062,'Emily','Brown','05/30/1977','Female','555-789-0123','emilybrown@email.com','Richard White','PQR Insurance'),
(27,21273,'Michael','White','06/24/1980','Male','555-123-8901','michaelwhite@email.com','Mary Davis','LMN Insurance'),
(28,28830,'Amanda','Davis','03/15/1985','Female','555-234-5670','amandadavis@email.com','Christopher Johnson','RST Insurance'),
(29,17417,'Robert','Johnson','07/08/1983','Male','555-567-1234','robertjohnson@email.com','Patricia Turner','UVW Insurance'),
(30,24416,'Laura','Turner','10/19/1996','Female','555-987-6543','lauraturner@email.com','Thomas Hall','XYZ Insurance'),
(31,21700,'Matthew','Hall','08/11/1982','Male','555-567-8901','matthewhall@email.com','Jennifer Adams','ABC Insurance'),
(32,15839,'Jessica','Adams','04/04/1990','Female','555-123-4567','jessicaadams@email.com','John Miller','PQR Insurance'),
(33,23481,'Christopher','Miller','02/02/1984','Male','555-234-5670','christophermiller@email.com','Sarah Harris','LMN Insurance'),
(34,29507,'Patricia','Harris','06/17/1991','Female','555-345-6780','patriciaharris@email.com','William Turner','RST Insurance'),
(35,26346,'David','Turner','12/19/1988','Male','555-789-0123','davidturner@email.com','Emily Smith','XYZ Insurance'),
(36,11774,'Elizabeth','Smith','07/24/1983','Female','555-234-5678','elizabethsmith@email.com','Michael Brown','ABC Insurance'),
(37,22052,'Michael','Brown','11/10/1985','Male','555-345-6789','michaelbrown@email.com','Sarah White','PQR Insurance'),
(38,28024,'William','White','05/15/1994','Male','555-567-1234','williamwhite@email.com','Laura Davis','UVW Insurance'),
(39,18707,'Jennifer','Davis','02/20/1979','Female','555-123-8901','jenniferdavis@email.com','Daniel Johnson','LMN Insurance'),
(40,19300,'Robert','Johnson','09/25/1980','Male','555-987-6543','robertjohnson@email.com','Patricia Turner','RST Insurance'),
(41,16304,'Laura','Turner','04/12/1987','Female','555-234-5670','lauraturner@email.com','Christopher Hall','XYZ Insurance'),
(42,16055,'Matthew','Hall','12/30/1982','Male','555-345-6780','matthewhall@email.com','Jennifer Adams','ABC Insurance'),
(43,27160,'Amanda','Adams','11/23/1989','Female','555-789-0123','amandaadams@email.com','John Smith','PQR Insurance'),
(44,19001,'David','Smith','08/05/1986','Male','555-123-4567','davidsmith@email.com','Jane Turner','LMN Insurance'),
(45,25114,'Elizabeth','Turner','01/17/1991','Female','555-234-5670','elizabethturner@email.com','Robert Davis','UVW Insurance'),
(46,26175,'John','Davis','03/18/1988','Male','555-345-6789','johndavis@email.com','Mary Clark','XYZ Insurance'),
(47,23032,'Sarah','Clark','11/10/1975','Female','555-567-1234','sarahclark@email.com','William Hall','ABC Insurance'),
(48,23381,'Robert','Hall','09/15/1993','Male','555-123-8901','roberthall@email.com','Catherine Johnson','RST Insurance'),
(49,23028,'Laura','Johnson','06/03/1984','Female','555-987-6543','laurajohnson@email.com','Joseph Miller','PQR Insurance'),
(50,23625,'Michael','Miller','10/02/1996','Male','555-567-8901','michaelmiller@email.com','Emily Harris','UVW Insurance'),
(51,21822,'Jennifer','Harris','12/30/1978','Female','555-123-4567','jenniferharris@email.com','Daniel Adams','XYZ Insurance'),
(52,22345,'Daniel','Adams','09/25/1982','Male','555-345-6780','danieladams@email.com','Sarah Turner','ABC Insurance'),
(53,13410,'Emily','Turner','04/15/1985','Female','555-789-0123','emilyturner@email.com','Robert Smith','PQR Insurance'),
(54,15845,'Matthew','Smith','06/24/1980','Male','555-123-8901','matthewsmith@email.com','Jennifer Brown','RST Insurance'),
(55,19933,'Jessica','Brown','12/12/1987','Female','555-987-6543','jessicabrown@email.com','William White','LMN Insurance'),
(56,12062,'Christopher','White','05/08/1991','Male','555-567-1234','christopherwhite@email.com','Elizabeth Turner','UVW Insurance'),
(57,18835,'Patricia','Turner','07/21/1976','Female','555-234-5670','patriciaturner@email.com','David Harris','XYZ Insurance'),
(58,18016,'David','Harris','11/10/1982','Male','555-345-6789','davidharris@email.com','Sarah Davis','ABC Insurance'),
(59,12138,'Elizabeth','Davis','01/05/1989','Female','555-789-0123','elizabethdavis@email.com','Matthew Clark','PQR Insurance'),
(60,29409,'Michael','Clark','08/19/1977','Male','555-123-4567','michaelclark@email.com','Amanda Hall','RST Insurance')

-- INSERT Provider TABLE
INSERT INTO dbo.Provider(provider_id,AddressID,first_name,last_name,specialty,phone_number,email_address,date_of_birth,gender,medical_license_number,specialization,education_and_qualifications,areas_of_expertise,languages_spoken,office_hours,appointment_scheduling,hospital_affiliations)
VALUES
(1,29816,'Dr. John','Smith','Cardiologist','555-123-4567','john.smith@example.com','04/15/1975','Male','MD123456','Cardiology','MD, PhD','Heart diseases, ECG','English, Spanish','Mon-Fri: 9AM-5PM','By appointment','City Hospital, County Hospital'),
(2,17611,'Dr. Jane','Johnson','Pediatrician','555-987-6543','jane.johnson@example.com','02/20/1980','Female','MD789012','Pediatrics','MD','Child health, Immunizations','English','Tue, Thu: 8AM-4PM','By appointment','Local Childrens Clinic'),
(3,28379,'Dr. Robert','Davis','Orthopedic Surgeon','555-567-8901','robert.davis@example.com','11/10/1972','Male','MD567890','Orthopedics','MD','Joint surgery, Fractures','English','Mon-Fri: 8AM-6PM','By appointment','OrthoCare Hospital'),
(4,22261,'Dr. Emily','Brown','Dermatologist','555-234-5678','emily.brown@example.com','07/03/1985','Female','MD234567','Dermatology','MD','Skin conditions, Cosmetic procedures','English','Mon, Wed, Fri: 10AM-6PM','By appointment','SkinHealth Clinic'),
(5,25952,'Dr. Michael','Clark','Neurologist','555-345-6789','michael.clark@example.com','09/25/1978','Male','MD345678','Neurology','MD, PhD','Brain disorders, Neurological tests','English','Tue, Thu: 9AM-5PM','By appointment','NeuroHealth Center'),
(6,20955,'Dr. Sarah','Turner','Obstetrician','555-789-0123','sarah.turner@example.com','04/12/1988','Female','MD789012','Obstetrics','MD','Pregnancy care, Delivery','English','Mon-Fri: 8AM-7PM','By appointment','Maternity Hospital'),
(7,23045,'Dr. William','Miller','Oncologist','555-123-8901','william.miller@example.com','12/30/1970','Male','MD123890','Oncology','MD, PhD','Cancer treatment, Chemotherapy','English','Mon, Wed, Fri: 9AM-5PM','By appointment','CancerCare Center'),
(8,14096,'Dr. Amanda','Harris','Cardiologist','555-345-6780','amanda.harris@example.com','01/17/1980','Female','MD345678','Cardiology','MD','Heart diseases, Cardiac surgeries','English','Tue, Thu: 8AM-4PM','By appointment','Heart Hospital'),
(9,20738,'Dr. David','Adams','Pediatrician','555-234-5670','david.adams@example.com','03/18/1982','Male','MD234567','Pediatrics','MD','Child health, Vaccinations','English','Mon-Fri: 8AM-6PM','By appointment','City Childrens Clinic'),
(10,24898,'Dr. Jennifer','White','Orthopedic Surgeon','555-567-1234','jennifer.white@example.com','07/27/1975','Female','MD567123','Orthopedics','MD','Joint surgeries, Sports injuries','English','Mon, Wed, Fri: 9AM-5PM','By appointment','OrthoCare Hospital'),
(11,29847,'Dr. Daniel','Smith','Dermatologist','555-123-4567','daniel.smith@example.com','09/15/1978','Male','MD123456','Dermatology','MD','Skin disorders, Laser therapy','English','Tue, Thu: 10AM-6PM','By appointment','SkinHealth Clinic'),
(12,26855,'Dr. Laura','Johnson','Neurologist','555-987-6543','laura.johnson@example.com','06/24/1980','Female','MD789012','Neurology','MD, PhD','Brain health, EEG','English','Mon, Wed, Fri: 8AM-4PM','By appointment','NeuroHealth Center'),
(13,20876,'Dr. Matthew','Brown','Obstetrician','555-234-5678','matthew.brown@example.com','09/30/1982','Male','MD567890','Obstetrics','MD','Prenatal care, Labor','English','Mon-Fri: 9AM-5PM','By appointment','Maternity Hospital'),
(14,16163,'Dr. Jessica','Clark','Oncologist','555-345-6789','jessica.clark@example.com','11/05/1978','Female','MD234567','Oncology','MD, PhD','Cancer therapies, Radiation','English','Tue, Thu: 9AM-4PM','By appointment','CancerCare Center'),
(15,911,'Dr. Richard','Turner','Cardiologist','555-123-8901','richard.turner@example.com','03/15/1985','Male','MD123890','Cardiology','MD','Heart health, Echocardiography','English','Mon, Wed, Fri: 8AM-6PM','By appointment','Heart Hospital'),
(16,27590,'Dr. Elizabeth','Miller','Pediatrician','555-567-1234','elizabeth.miller@example.com','08/02/1972','Female','MD567123','Pediatrics','MD','Childcare, Immunizations','English','Mon-Fri: 8AM-5PM','By appointment','City Childrens Clinic'),
(17,26489,'Dr. Kevin','Adams','Orthopedic Surgeon','555-789-0123','kevin.adams@example.com','12/10/1980','Male','MD234567','Orthopedics','MD, PhD','Orthopedic surgeries, Fractures','English','Tue, Thu: 9AM-5PM','By appointment','OrthoCare Hospital'),
(18,18967,'Dr. Olivia','White','Dermatologist','555-987-6543','olivia.white@example.com','07/18/1985','Female','MD789012','Dermatology','MD','Skin care, Laser therapy','English','Mon, Wed, Fri: 10AM-6PM','By appointment','SkinHealth Clinic'),
(19,18205,'Dr. Joseph','Brown','Neurologist','555-234-5678','joseph.brown@example.com','04/25/1977','Male','MD345678','Neurology','MD, PhD','Neurological disorders, EEG','English','Mon, Wed, Fri: 9AM-4PM','By appointment','NeuroHealth Center'),
(20,29281,'Dr. Sophia','Johnson','Obstetrician','555-345-6789','sophia.johnson@example.com','11/01/1982','Female','MD123456','Obstetrics','MD','Maternal care, Delivery','English','Mon-Fri: 8AM-5PM','By appointment','Maternity Hospital'),
(21,25486,'Dr. Benjamin','Clark','Oncologist','555-567-1234','benjamin.clark@example.com','05/12/1974','Male','MD567123','Oncology','MD, PhD','Cancer treatment, Chemotherapy','English','Tue, Thu: 9AM-5PM','By appointment','CancerCare Center'),
(22,25115,'Dr. Olivia','Turner','Cardiologist','555-123-8901','olivia.turner@example.com','03/18/1988','Female','MD123890','Cardiology','MD','Heart diseases, Cardiac surgeries','English','Mon, Wed, Fri: 8AM-4PM','By appointment','Heart Hospital'),
(23,15272,'Dr. William','Miller','Pediatrician','555-789-0123','william.miller@example.com','06/26/1980','Male','MD789012','Pediatrics','MD','Child health, Vaccinations','English','Mon-Fri: 9AM-5PM','By appointment','City Childrens Clinic'),
(24,27558,'Dr. Elizabeth','Adams','Orthopedic Surgeon','555-987-6543','elizabeth.adams@example.com','08/11/1976','Female','MD234567','Orthopedics','MD, PhD','Joint surgeries, Sports injuries','English','Tue, Thu: 8AM-6PM','By appointment','OrthoCare Hospital'),
(25,18858,'Dr. Joseph','White','Dermatologist','555-567-8901','joseph.white@example.com','05/30/1982','Male','MD123456','Dermatology','MD','Skin disorders, Cosmetic procedures','English','Mon, Wed, Fri: 10AM-5PM','By appointment','SkinHealth Clinic'),
(26,26229,'Dr. Sophia','Smith','Neurologist','555-123-4567','sophia.smith@example.com','06/24/1980','Female','MD123890','Neurology','MD, PhD','Brain health, Neurological tests','English','Mon, Wed, Fri: 8AM-7PM','By appointment','NeuroHealth Center'),
(27,24883,'Dr. Benjamin','Johnson','Obstetrician','555-345-6789','benjamin.johnson@example.com','03/15/1985','Male','MD345678','Obstetrics','MD','Pregnancy care, Delivery','English','Tue, Thu: 9AM-5PM','By appointment','Maternity Hospital'),
(28,19379,'Dr. Emily','Brown','Oncologist','555-234-5670','emily.brown@example.com','12/30/1970','Female','MD567123','Oncology','MD, PhD','Cancer treatment, Radiation','English','Mon, Wed, Fri: 8AM-6PM','By appointment','CancerCare Center'),
(29,15776,'Dr. James','Miller','Cardiologist','555-789-0123','james.miller@example.com','11/10/1982','Male','MD789012','Cardiology','MD','Heart diseases, Cardiac surgeries','English','Mon-Fri: 9AM-5PM','By appointment','Heart Hospital'),
(30,19638,'Dr. Sophia','Taylor','Pediatrician','555-567-8901','sophia.taylor@example.com','09/15/1978','Female','MD123456','Pediatrics','MD','Childcare, Immunizations','English','Tue, Thu: 8AM-4PM','By appointment','City Childrens Clinic'),
(31,14068,'Dr. Michael','Davis','Orthopedic Surgeon','555-123-4567','michael.davis@example.com','02/20/1980','Male','MD234567','Orthopedics','MD, PhD','Orthopedic surgeries, Sports injuries','English','Mon, Wed, Fri: 9AM-5PM','By appointment','OrthoCare Hospital'),
(32,21245,'Dr. Olivia','White','Dermatologist','555-987-6543','olivia.white@example.com','11/05/1978','Female','MD567890','Dermatology','MD','Skin care, Cosmetic procedures','English','Mon, Wed, Fri: 9AM-4PM','By appointment','SkinHealth Clinic'),
(33,25310,'Dr. Daniel','Turner','Neurologist','555-123-8901','daniel.turner@example.com','01/17/1980','Male','MD123890','Neurology','MD, PhD','Brain health, EEG','English','Tue, Thu: 10AM-6PM','By appointment','NeuroHealth Center'),
(34,23089,'Dr. Emily','Harris','Obstetrician','555-567-1234','emily.harris@example.com','06/26/1980','Female','MD345678','Obstetrics','MD','Pregnancy care, Labor','English','Mon, Wed, Fri: 8AM-6PM','By appointment','Maternity Hospital'),
(35,21707,'Dr. William','Anderson','Oncologist','555-234-5678','william.anderson@example.com','08/02/1972','Male','MD789012','Oncology','MD, PhD','Cancer treatment, Chemotherapy','English','Mon, Wed, Fri: 8AM-6PM','By appointment','CancerCare Center'),
(36,28674,'Dr. Sophia','Roberts','Cardiologist','555-567-8901','sophia.roberts@example.com','03/15/1985','Female','MD234567','Cardiology','MD','Heart diseases, Echocardiography','English','Mon, Wed, Fri: 8AM-4PM','By appointment','Heart Hospital'),
(37,24412,'Dr. James','Williams','Pediatrician','555-789-0123','james.williams@example.com','12/10/1980','Male','MD567123','Pediatrics','MD','Child health, Vaccinations','English','Mon-Fri: 9AM-5PM','By appointment','City Childrens Clinic'),
(38,19673,'Dr. Olivia','Davis','Orthopedic Surgeon','555-987-6543','olivia.davis@example.com','05/30/1982','Female','MD123456','Orthopedics','MD, PhD','Orthopedic surgeries, Sports injuries','English','Tue, Thu: 8AM-6PM','By appointment','OrthoCare Hospital'),
(39,19506,'Dr. Joseph','Hall','Dermatologist','555-567-1234','joseph.hall@example.com','04/25/1977','Male','MD789012','Dermatology','MD','Skin disorders, Cosmetic procedures','English','Mon, Wed, Fri: 10AM-5PM','By appointment','SkinHealth Clinic'),
(40,21094,'Dr. Elizabeth','Clark','Neurologist','555-123-4567','elizabeth.clark@example.com','06/24/1980','Female','MD123890','Neurology','MD, PhD','Brain health, Neurological tests','English','Mon, Wed, Fri: 9AM-4PM','By appointment','NeuroHealth Center')




--INSERT MedicalStaff TABLES
INSERT INTO dbo.MedicalStaff (StaffID,AddressID, First_Name, Last_Name, Date_Of_Birth, Gender, Contact_Information, Medical_License_Number, Specialization, Employment_History)
VALUES
(1,24427,'John','Doe','05/15/1980','Male','555-123-4567','MD123456','Cardiology','10 years at ABC Hospital'),
(2,22959,'Jane','Smith','02/20/1990','Female','555-987-6543','MD789012','Pediatrics','5 years at XYZ Clinic'),
(3,24827,'Robert','Johnson','11/10/1975','Male','555-567-8901','MD567890','Orthopedics','15 years at LMN Medical Center'),
(4,11975,'Emily','Brown','07/03/1988','Female','555-234-5678','MD234567','Dermatology','8 years at PQR Hospital'),
(5,13715,'Michael','Davis','09/25/1982','Male','555-345-6789','MD345678','Neurology','12 years at RST Clinic'),
(6,215,'Sarah','Clark','04/12/1995','Female','555-789-0123','MD789012','Obstetrics','4 years at UVW Hospital'),
(7,13669,'William','Miller','12/30/1987','Male','555-123-8901','MD123890','Oncology','10 years at ABC Hospital'),
(8,14087,'Amanda','Turner','08/05/1972','Female','555-345-6780','MD345678','Cardiology','20 years at XYZ Clinic'),
(9,11832,'David','Hall','01/17/1993','Male','555-234-5670','MD234567','Pediatrics','7 years at LMN Medical Center'),
(10,21677,'Jennifer','White','03/18/1989','Female','555-567-1234','MD567123','Orthopedics','12 years at PQR Hospital'),
(11,17455,'Daniel','Adams','06/24/1980','Male','555-123-4567','MD123456','Dermatology','14 years at RST Clinic'),
(12,25462,'Laura','Harris','07/27/1985','Female','555-987-6543','MD789012','Neurology','9 years at UVW Hospital'),
(13,17558,'Matthew','Brown','10/02/1992','Male','555-567-8901','MD567890','Obstetrics','6 years at ABC Hospital'),
(14,11383,'Jessica','Smith','09/12/1983','Female','555-234-5678','MD234567','Oncology','11 years at XYZ Clinic'),
(15,14597,'Richard','Turner','04/15/1986','Male','555-345-6789','MD345678','Cardiology','16 years at LMN Medical Center'),
(16,21574,'Mary','Davis','02/18/1997','Female','555-789-0123','MD789012','Pediatrics','5 years at PQR Hospital'),
(17,21686,'Christopher','Johnson','11/23/1978','Male','555-123-8901','MD123890','Orthopedics','18 years at RST Clinic'),
(18,24373,'Patricia','Miller','06/03/1984','Female','555-345-6780','MD345678','Dermatology','12 years at UVW Hospital'),
(19,21121,'Thomas','Turner','05/08/1989','Male','555-234-5670','MD234567','Neurology','20 years at ABC Hospital'),
(20,25059,'Elizabeth','Clark','07/21/1982','Female','555-567-1234','MD567123','Obstetrics','15 years at XYZ Clinic'),
(21,28226,'John','Hall','09/29/1991','Male','555-123-4567','MD123456','Oncology','11 years at LMN Medical Center'),
(22,28485,'Sarah','Adams','08/07/1994','Female','555-987-6543','MD789012','Cardiology','7 years at PQR Hospital'),
(23,25633,'William','Harris','03/01/1981','Male','555-567-8901','MD567890','Pediatrics','9 years at RST Clinic'),
(24,26683,'Jennifer','Turner','12/12/1988','Female','555-234-5678','MD234567','Orthopedics','14 years at UVW Hospital'),
(25,20313,'Daniel','Smith','11/05/1976','Male','555-345-6789','MD345678','Dermatology','8 years at ABC Hospital'),
(26,11855,'Emily','Brown','05/30/1977','Female','555-789-0123','MD789012','Neurology','5 years at XYZ Clinic'),
(27,15922,'Michael','White','06/24/1980','Male','555-123-8901','MD123890','Obstetrics','15 years at LMN Medical Center'),
(28,25529,'Amanda','Davis','03/15/1985','Female','555-234-5670','MD234567','Oncology','8 years at PQR Hospital'),
(29,18917,'Robert','Johnson','07/08/1983','Male','555-567-1234','MD567123','Cardiology','11 years at RST Clinic'),
(30,21281,'Laura','Turner','10/19/1996','Female','555-987-6543','MD789012','Pediatrics','3 years at UVW Hospital'),
(31,12444,'Matthew','Hall','08/11/1982','Male','555-567-8901','MD567890','Orthopedics','13 years at ABC Hospital'),
(32,27779,'Jessica','Adams','04/04/1990','Female','555-123-4567','MD123456','Dermatology','9 years at XYZ Clinic'),
(33,28433,'Christopher','Miller','02/02/1984','Male','555-234-5670','MD234567','Neurology','10 years at LMN Medical Center'),
(34,17038,'Patricia','Harris','06/17/1991','Female','555-345-6780','MD345678','Obstetrics','6 years at PQR Hospital'),
(35,13354,'David','Turner','12/19/1988','Male','555-789-0123','MD789012','Oncology','7 years at RST Clinic'),
(36,355,'Elizabeth','Smith','07/24/1983','Female','555-234-5678','MD234567','Cardiology','11 years at UVW Hospital'),
(37,27547,'Michael','Brown','11/10/1985','Male','555-345-6789','MD345678','Pediatrics','5 years at ABC Hospital'),
(38,15015,'William','White','05/15/1994','Male','555-567-1234','MD567123','Orthopedics','9 years at XYZ Clinic'),
(39,11456,'Jennifer','Davis','02/20/1979','Female','555-123-8901','MD123456','Dermatology','14 years at LMN Medical Center'),
(40,12359,'Robert','Johnson','09/25/1980','Male','555-987-6543','MD789012','Neurology','8 years at PQR Hospital'),
(41,25449,'Laura','Turner','04/12/1987','Female','555-234-5670','MD234567','Obstetrics','10 years at RST Clinic'),
(42,27683,'Matthew','Hall','12/30/1982','Male','555-345-6780','MD345678','Oncology','6 years at UVW Hospital'),
(43,19089,'Amanda','Adams','11/23/1989','Female','555-789-0123','MD789012','Cardiology','13 years at ABC Hospital'),
(44,15467,'David','Smith','08/05/1986','Male','555-123-4567','MD123890','Pediatrics','7 years at XYZ Clinic'),
(45,33,'Elizabeth','Turner','01/17/1991','Female','555-234-5670','MD234567','Orthopedics','10 years at LMN Medical Center'),
(46,11706,'John','Davis','03/18/1988','Male','555-345-6789','MD345678','Dermatology','8 years at PQR Hospital'),
(47,27149,'Sarah','Clark','11/10/1975','Female','555-567-1234','MD567123','Neurology','12 years at RST Clinic'),
(48,26959,'Robert','Hall','09/15/1993','Male','555-123-8901','MD123456','Obstetrics','11 years at UVW Hospital'),
(49,12148,'Laura','Johnson','06/03/1984','Female','555-987-6543','MD789012','Oncology','5 years at ABC Hospital'),
(50,22014,'Michael','Miller','10/02/1996','Male','555-567-8901','MD567890','Cardiology','7 years at XYZ Clinic'),
(51,29504,'Jennifer','Harris','12/30/1978','Female','555-123-4567','MD123890','Pediatrics','10 years at LMN Medical Center'),
(52,29096,'Daniel','Adams','09/25/1982','Male','555-567-1234','MD567123','Orthopedics','9 years at PQR Hospital'),
(53,12787,'Emily','Turner','04/15/1985','Female','555-789-0123','MD789012','Dermatology','11 years at RST Clinic'),
(54,24604,'Matthew','Smith','06/24/1980','Male','555-123-8901','MD123890','Neurology','10 years at UVW Hospital'),
(55,27875,'Jessica','Brown','12/12/1987','Female','555-987-6543','MD789012','Obstetrics','8 years at ABC Hospital'),
(56,21807,'Christopher','White','05/08/1991','Male','555-567-1234','MD567123','Oncology','15 years at XYZ Clinic'),
(57,24165,'Patricia','Turner','07/21/1976','Female','555-123-4567','MD123456','Cardiology','12 years at LMN Medical Center'),
(58,20407,'David','Harris','11/10/1982','Male','555-345-6789','MD345678','Pediatrics','6 years at PQR Hospital'),
(59,18329,'Elizabeth','Davis','01/05/1989','Female','555-789-0123','MD789012','Orthopedics','11 years at RST Clinic'),
(60,26805,'Michael','Clark','08/19/1977','Male','555-123-4567','MD123890','Dermatology','9 years at UVW Hospital'),
(61,19489,'Jennifer','Hall','01/23/1993','Female','555-234-5670','MD234567','Neurology','7 years at ABC Hospital'),
(62,24310,'Daniel','Brown','12/02/1984','Male','555-567-8901','MD567890','Obstetrics','13 years at XYZ Clinic'),
(63,27838,'Laura','Smith','10/01/1992','Female','555-987-6543','MD789012','Oncology','10 years at LMN Medical Center'),
(64,14851,'Matthew','Turner','09/14/1975','Male','555-567-1234','MD567123','Cardiology','11 years at PQR Hospital'),
(65,19207,'Jessica','Davis','06/26/1988','Female','555-123-8901','MD123890','Pediatrics','9 years at RST Clinic'),
(66,17984,'Christopher','Adams','03/30/1979','Male','555-345-6789','MD345678','Orthopedics','8 years at UVW Hospital'),
(67,17950,'Patricia','Harris','04/04/1987','Female','555-789-0123','MD789012','Dermatology','14 years at ABC Hospital'),
(68,11856,'David','Johnson','02/15/1980','Male','555-567-8901','MD567890','Neurology','12 years at XYZ Clinic'),
(69,18817,'Elizabeth','Turner','11/28/1976','Female','555-123-4567','MD123456','Obstetrics','10 years at LMN Medical Center'),
(70,16962,'Michael','Brown','09/05/1982','Male','555-234-5670','MD234567','Oncology','9 years at PQR Hospital')


--INSERT Appointment TABLES
INSERT INTO dbo.Appointment (appointment_id, patient_id, provider_id, appointment_date, appointment_time, appointment_type, Reason_for_Visit, Status, Notes)
VALUES
(1, 1, 1, '2023-09-23', '09:00 AM', 'Checkup', 'Annual checkup', 'Scheduled', 'N/A'),
(2, 2, 2, '2023-09-24', '02:30 PM', 'Consultation', 'Back pain', 'Scheduled', 'Please arrive 15 minutes early'),
(3, 3, 3, '2023-09-25', '10:15 AM', 'Follow-up', 'Medication review', 'Scheduled', 'Bring current medications'),
(4, 4, 4, '2023-09-26', '11:30 AM', 'Checkup', 'Routine checkup', 'Scheduled', 'No fasting required'),
(5, 5, 5, '2023-09-27', '03:45 PM', 'Consultation', 'Allergies', 'Scheduled', 'Bring allergy test results'),
(6, 6, 6, '2023-09-28', '01:00 PM', 'Follow-up', 'Post-surgery', 'Completed', 'Recovery going well'),
(7, 7, 7, '2023-09-29', '02:30 PM', 'Checkup', 'Yearly physical', 'Scheduled', 'Fasting required for blood work'),
(8, 8, 8, '2023-09-30', '09:45 AM', 'Consultation', 'Weight loss', 'Scheduled', 'Diet and exercise history'),
(9, 9, 9, '2023-10-01', '04:15 PM', 'Follow-up', 'Chronic condition', 'Scheduled', 'Recent symptoms'),
(10, 10, 10, '2023-10-02', '08:30 AM', 'Checkup', 'Routine checkup', 'Scheduled', 'Bring insurance card'),
(11, 11, 11, '2023-10-03', '10:30 AM', 'Consultation', 'Skin rash', 'Scheduled', 'Possible allergy trigger'),
(12, 12, 12, '2023-10-04', '02:00 PM', 'Follow-up', 'Post-surgery', 'Completed', 'Incision healing well'),
(13, 13, 13, '2023-10-05', '09:00 AM', 'Checkup', 'Annual checkup', 'Scheduled', 'Blood pressure monitoring'),
(14, 14, 14, '2023-10-06', '03:15 PM', 'Consultation', 'Headaches', 'Scheduled', 'Headache diary'),
(15, 15, 15, '2023-10-07', '11:45 AM', 'Follow-up', 'Medication review', 'Scheduled', 'Any side effects?'),
(16, 16, 16, '2023-10-08', '01:30 PM', 'Checkup', 'Routine checkup', 'Scheduled', 'Recent illness history'),
(17, 17, 17, '2023-10-09', '03:30 PM', 'Consultation', 'Back pain', 'Scheduled', 'Previous treatments'),
(18, 18, 18, '2023-10-10', '10:15 AM', 'Follow-up', 'Post-surgery', 'Completed', 'Surgical wound status'),
(19, 19, 19, '2023-10-11', '09:45 AM', 'Checkup', 'Yearly physical', 'Scheduled', 'Blood test results'),
(20, 20, 20, '2023-10-12', '02:45 PM', 'Consultation', 'Allergies', 'Scheduled', 'Discuss allergy management'),
(21, 21, 21, '2023-10-13', '01:00 PM', 'Follow-up', 'Chronic condition', 'Scheduled', 'Current symptoms'),
(22, 22, 22, '2023-10-14', '11:30 AM', 'Checkup', 'Routine checkup', 'Scheduled', 'Overall health assessment'),
(23, 23, 23, '2023-10-15', '04:30 PM', 'Consultation', 'Weight loss', 'Scheduled', 'Diet and exercise plan'),
(24, 24, 24, '2023-10-16', '10:00 AM', 'Follow-up', 'Post-surgery', 'Completed', 'Recovery progress'),
(25, 25, 25, '2023-10-17', '02:30 PM', 'Checkup', 'Annual checkup', 'Scheduled', 'General health discussion'),
(26, 26, 26, '2023-10-18', '03:45 PM', 'Consultation', 'Skin rash', 'Scheduled', 'Examine skin condition'),
(27, 27, 27, '2023-10-19', '08:45 AM', 'Follow-up', 'Medication review', 'Scheduled', 'Medication adjustments'),
(28, 28, 28, '2023-10-20', '11:15 AM', 'Checkup', 'Routine checkup', 'Scheduled', 'Health history review'),
(29, 29, 29, '2023-10-21', '02:15 PM', 'Consultation', 'Back pain', 'Scheduled', 'Pain management plan'),
(30, 30, 30, '2023-10-22', '09:30 AM', 'Follow-up', 'Post-surgery', 'Completed', 'Follow-up tests needed'),
(31, 31, 31, '2023-10-23', '01:00 PM', 'Checkup', 'Yearly physical', 'Scheduled', 'Physical examination'),
(32, 32, 32, '2023-10-24', '04:00 PM', 'Consultation', 'Allergies', 'Scheduled', 'Allergy testing'),
(33, 33, 33, '2023-10-25', '10:45 AM', 'Follow-up', 'Chronic condition', 'Scheduled', 'Manage chronic illness'),
(34, 34, 34, '2023-10-26', '02:45 PM', 'Checkup', 'Routine checkup', 'Scheduled', 'Health assessment'),
(35, 35, 35, '2023-10-27', '03:30 PM', 'Consultation', 'Weight loss', 'Scheduled', 'Weight management plan'),
(36, 36, 36, '2023-10-28', '09:15 AM', 'Follow-up', 'Medication review', 'Scheduled', 'Medication efficacy'),
(37, 37, 37, '2023-10-29', '11:30 AM', 'Checkup', 'Annual checkup', 'Scheduled', 'Overall health assessment'),
(38, 38, 38, '2023-10-30', '01:45 PM', 'Consultation', 'Skin rash', 'Scheduled', 'Skin examination'),
(39, 39, 39, '2023-10-31', '03:15 PM', 'Follow-up', 'Post-surgery', 'Completed', 'Recovery assessment'),
(40, 40, 40, '2023-11-01', '10:00 AM', 'Checkup', 'Yearly physical', 'Scheduled', 'Medical history review'),
(41, 41, 1, '2023-11-02', '02:30 PM', 'Consultation', 'Allergies', 'Scheduled', 'Allergy management plan'),
(42, 42, 12, '2023-11-03', '11:15 AM', 'Follow-up', 'Chronic condition', 'Scheduled', 'Chronic disease management'),
(43, 43, 13, '2023-11-04', '09:45 AM', 'Checkup', 'Routine checkup', 'Scheduled', 'Physical examination'),
(44, 44, 4, '2023-11-05', '03:45 PM', 'Consultation', 'Weight loss', 'Scheduled', 'Weight loss program'),
(45, 45, 5, '2023-11-06', '01:30 PM', 'Follow-up', 'Medication review', 'Scheduled', 'Medication adjustments'),
(46, 46, 6, '2023-11-07', '02:00 PM', 'Checkup', 'Annual checkup', 'Scheduled', 'Health status evaluation'),
(47, 47, 7, '2023-11-08', '10:30 AM', 'Consultation', 'Skin rash', 'Scheduled', 'Skin examination and treatment'),
(48, 48, 8, '2023-11-09', '09:00 AM', 'Follow-up', 'Post-surgery', 'Completed', 'Postoperative recovery assessment'),
(49, 49, 9, '2023-11-10', '03:00 PM', 'Checkup', 'Yearly physical', 'Scheduled', 'Physical health assessment'),
(50, 50, 5, '2023-11-11', '01:45 PM', 'Consultation', 'Allergies', 'Scheduled', 'Allergy testing and management'),
(51, 51, 1, '2023-11-12', '11:45 AM', 'Follow-up', 'Chronic condition', 'Scheduled', 'Chronic illness management'),
(52, 52, 5, '2023-11-13', '02:15 PM', 'Checkup', 'Routine checkup', 'Scheduled', 'Overall health assessment'),
(53, 53, 3, '2023-11-14', '09:30 AM', 'Consultation', 'Weight loss', 'Scheduled', 'Weight management plan'),
(54, 54, 4, '2023-11-15', '03:30 PM', 'Follow-up', 'Medication review', 'Scheduled', 'Medication efficacy'),
(55, 55, 5, '2023-11-16', '01:00 PM', 'Checkup', 'Annual checkup', 'Scheduled', 'Comprehensive health evaluation'),
(56, 56, 6, '2023-11-17', '04:15 PM', 'Consultation', 'Skin rash', 'Scheduled', 'Skin examination and treatment'),
(57, 57, 7, '2023-11-18', '10:00 AM', 'Follow-up', 'Post-surgery', 'Completed', 'Postoperative recovery assessment'),
(58, 58, 5, '2023-11-19', '02:45 PM', 'Checkup', 'Yearly physical', 'Scheduled', 'Health status evaluation'),
(59, 59, 9, '2023-11-20', '11:30 AM', 'Consultation', 'Allergies', 'Scheduled', 'Allergy testing and management'),
(60, 60, 6, '2023-11-21', '09:00 AM', 'Follow-up', 'Chronic condition', 'Scheduled', 'Chronic illness management'),
(61, 6, 1, '2023-11-22', '03:45 PM', 'Checkup', 'Routine checkup', 'Scheduled', 'Overall health assessment'),
(62, 2, 2, '2023-11-23', '01:30 PM', 'Consultation', 'Weight loss', 'Scheduled', 'Weight management plan'),
(63, 3, 3, '2023-11-24', '10:15 AM', 'Follow-up', 'Medication review', 'Scheduled', 'Medication efficacy'),
(64, 4, 11, '2023-11-25', '02:00 PM', 'Checkup', 'Annual checkup', 'Scheduled', 'Comprehensive health evaluation'),
(65, 5, 11, '2023-11-26', '09:45 AM', 'Consultation', 'Skin rash', 'Scheduled', 'Skin examination and treatment'),
(66, 6, 14, '2023-11-27', '03:30 PM', 'Follow-up', 'Post-surgery', 'Completed', 'Postoperative recovery assessment'),
(67, 7, 12, '2023-11-28', '04:00 PM', 'Checkup', 'Yearly physical', 'Scheduled', 'Health status evaluation'),
(68, 8, 5, '2023-11-29', '01:45 PM', 'Consultation', 'Allergies', 'Scheduled', 'Allergy testing and management'),
(69, 9, 9, '2023-11-30', '11:15 AM', 'Follow-up', 'Chronic condition', 'Scheduled', 'Chronic illness management'),
(70, 10, 7, '2023-12-01', '02:15 PM', 'Checkup', 'Routine checkup', 'Scheduled', 'Overall health assessment'),
(71, 7, 22, '2023-12-02', '03:45 PM', 'Consultation', 'Weight loss', 'Scheduled', 'Weight management plan'),
(72, 7, 21, '2023-12-03', '10:00 AM', 'Follow-up', 'Medication review', 'Scheduled', 'Medication efficacy'),
(73, 7, 16, '2023-12-04', '02:45 PM', 'Checkup', 'Annual checkup', 'Scheduled', 'Comprehensive health evaluation'),
(74, 4, 8, '2023-12-05', '09:30 AM', 'Consultation', 'Skin rash', 'Scheduled', 'Skin examination and treatment'),
(75, 5, 40, '2023-12-06', '04:15 PM', 'Follow-up', 'Post-surgery', 'Completed', 'Postoperative recovery assessment'),
(76, 6, 33, '2023-12-07', '11:30 AM', 'Checkup', 'Yearly physical', 'Scheduled', 'Health status evaluation'),
(77, 7, 22, '2023-12-08', '01:30 PM', 'Consultation', 'Allergies', 'Scheduled', 'Allergy testing and management'),
(78, 8, 24, '2023-12-09', '03:00 PM', 'Follow-up', 'Chronic condition', 'Scheduled', 'Chronic illness management'),
(79, 9, 17, '2023-12-10', '09:45 AM', 'Checkup', 'Routine checkup', 'Scheduled', 'Overall health assessment'),
(80, 20, 15, '2023-12-11', '02:30 PM', 'Consultation', 'Weight loss', 'Scheduled', 'Weight management plan'),
(81, 1, 2, '2023-12-12', '10:45 AM', 'Follow-up', 'Medication review', 'Scheduled', 'Medication efficacy'),
(82, 2, 16, '2023-12-13', '01:15 PM', 'Checkup', 'Annual checkup', 'Scheduled', 'Comprehensive health evaluation');

--INSERT Diagnosis TABLES
INSERT INTO dbo.Diagnosis (diagnosis_id, patient_id, provider_id, diagnosis_date, diagnosis_description, Diagnosis_Code,Diagnosis_Name,Diagnosis_Type,Severity,Treatment_Plan,Medications_Prescribed,Procedures_Recommended,Follow_up_Instructions,Notes,Review_Date,Status)
VALUES
(1, 1, 1, '2023-09-23', 'Common cold', 'J00', 'Viral Upper Respiratory Infection', 'Acute', 'Mild', 'Rest, hydration', 'None', 'None', 'Take over-the-counter cold medicine', 'No complications', '2023-10-01', 'Resolved'),
(2, 2, 2, '2023-09-24', 'Back pain', 'M54.5', 'Low Back Pain', 'Chronic', 'Moderate', 'Physical therapy', 'Muscle relaxants', 'None', 'Follow exercises regularly', 'Regular back pain assessment', '2023-10-01', 'Ongoing'),
(3, 3, 3, '2023-09-25', 'Hypertension', 'I10', 'Essential Hypertension', 'Chronic', 'Severe', 'Medication (ACE inhibitors)', 'Anti-hypertensive drugs', 'None', 'Monitor blood pressure regularly', 'Blood pressure control', '2023-10-01', 'Under Control'),
(4, 4, 4, '2023-09-26', 'Diabetes', 'E11.9', 'Type 2 Diabetes', 'Chronic', 'Moderate', 'Diet and exercise', 'Metformin', 'HbA1c test', 'Follow diet plan and exercise', 'Stable blood sugar levels', '2023-10-01', 'Stable'),
(5, 5, 5, '2023-09-27', 'Allergic Rhinitis', 'J30.1', 'Allergic Rhinitis', 'Chronic', 'Mild', 'Antihistamines', 'Nasal corticosteroids', 'None', 'Avoid allergens', 'Improved with treatment', '2023-10-01', 'Under Control'),
(6, 6, 6, '2023-09-28', 'Post-surgery follow-up', 'Z48.815', 'Postoperative Wound Infection', 'Acute', 'Mild', 'Antibiotics', 'None', 'None', 'Complete antibiotics course', 'Wound healing well', '2023-10-01', 'Resolved'),
(7, 7, 7, '2023-09-29', 'Annual checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(8, 8, 8, '2023-09-30', 'Weight loss consultation', 'E66.9', 'Obesity, Unspecified', 'Chronic', 'Moderate', 'Diet and exercise plan', 'Weight loss medications', 'None', 'Follow diet and exercise plan', 'Weight loss progress', '2023-10-01', 'Ongoing'),
(9, 9, 9, '2023-10-01', 'Chronic migraine', 'G43.919', 'Chronic Migraine without Aura', 'Chronic', 'Severe', 'Migraine management', 'Triptans', 'None', 'Migraine diary', 'Regular migraine assessments', '2023-10-01', 'Under Control'),
(10, 10, 10, '2023-10-02', 'Annual checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(11, 11, 11, '2023-10-03', 'Eczema', 'L30.9', 'Dermatitis, Unspecified', 'Chronic', 'Mild', 'Topical corticosteroids', 'Emollients', 'None', 'Skin care regimen', 'Eczema management', '2023-10-01', 'Under Control'),
(12, 12, 12, '2023-10-04', 'Postoperative follow-up', 'Z48.815', 'Postoperative Wound Infection', 'Acute', 'Mild', 'Antibiotics', 'None', 'None', 'Complete antibiotics course', 'Wound healing well', '2023-10-01', 'Resolved'),
(13, 13, 13, '2023-10-05', 'Annual checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(14, 14, 14, '2023-10-06', 'Headaches', 'R51', 'Headache', 'Chronic', 'Moderate', 'Pain relief medications', 'None', 'None', 'Headache diary', 'Headache management', '2023-10-01', 'Ongoing'),
(15, 15, 15, '2023-10-07', 'Medication review', 'Z71.4', 'Medication abuse counseling', 'Chronic', 'Mild', 'Counseling', 'None', 'None', 'Counseling sessions', 'Medication review progress', '2023-10-01', 'Stable'),
(16, 16, 16, '2023-10-08', 'Checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(17, 17, 17, '2023-10-09', 'Back pain', 'M54.5', 'Low Back Pain', 'Chronic', 'Moderate', 'Physical therapy', 'Muscle relaxants', 'None', 'Follow exercises regularly', 'Regular back pain assessment', '2023-10-01', 'Ongoing'),
(18, 18, 18, '2023-10-10', 'Post-surgery follow-up', 'Z48.815', 'Postoperative Wound Infection', 'Acute', 'Mild', 'Antibiotics', 'None', 'None', 'Complete antibiotics course', 'Wound healing well', '2023-10-01', 'Resolved'),
(19, 19, 19, '2023-10-11', 'Hypertension', 'I10', 'Essential Hypertension', 'Chronic', 'Severe', 'Medication (ACE inhibitors)', 'Anti-hypertensive drugs', 'None', 'Monitor blood pressure regularly', 'Blood pressure control', '2023-10-01', 'Under Control'),
(20, 20, 20, '2023-10-12', 'Diabetes', 'E11.9', 'Type 2 Diabetes', 'Chronic', 'Moderate', 'Diet and exercise', 'Metformin', 'HbA1c test', 'Follow diet plan and exercise', 'Stable blood sugar levels', '2023-10-01', 'Stable'),
(21, 21, 21, '2023-10-13', 'Allergic Rhinitis', 'J30.1', 'Allergic Rhinitis', 'Chronic', 'Mild', 'Antihistamines', 'Nasal corticosteroids', 'None', 'Avoid allergens', 'Improved with treatment', '2023-10-01', 'Under Control'),
(22, 22, 22, '2023-10-14', 'Post-surgery follow-up', 'Z48.815', 'Postoperative Wound Infection', 'Acute', 'Mild', 'Antibiotics', 'None', 'None', 'Complete antibiotics course', 'Wound healing well', '2023-10-01', 'Resolved'),
(23, 23, 23, '2023-10-15', 'Annual checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(24, 24, 24, '2023-10-16', 'Weight loss consultation', 'E66.9', 'Obesity, Unspecified', 'Chronic', 'Moderate', 'Diet and exercise plan', 'Weight loss medications', 'None', 'Follow diet and exercise plan', 'Weight loss progress', '2023-10-01', 'Ongoing'),
(25, 25, 25, '2023-10-17', 'Chronic migraine', 'G43.919', 'Chronic Migraine without Aura', 'Chronic', 'Severe', 'Migraine management', 'Triptans', 'None', 'Migraine diary', 'Regular migraine assessments', '2023-10-01', 'Under Control'),
(26, 26, 26, '2023-10-18', 'Annual checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(27, 27, 27, '2023-10-19', 'Eczema', 'L30.9', 'Dermatitis, Unspecified', 'Chronic', 'Mild', 'Topical corticosteroids', 'Emollients', 'None', 'Skin care regimen', 'Eczema management', '2023-10-01', 'Under Control'),
(28, 28, 28, '2023-10-20', 'Postoperative follow-up', 'Z48.815', 'Postoperative Wound Infection', 'Acute', 'Mild', 'Antibiotics', 'None', 'None', 'Complete antibiotics course', 'Wound healing well', '2023-10-01', 'Resolved'),
(29, 29, 29, '2023-10-21', 'Annual checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(30, 30, 30, '2023-10-22', 'Headaches', 'R51', 'Headache', 'Chronic', 'Moderate', 'Pain relief medications', 'None', 'None', 'Headache diary', 'Headache management', '2023-10-01', 'Ongoing'),
(31, 31, 31, '2023-10-23', 'Medication review', 'Z71.4', 'Medication abuse counseling', 'Chronic', 'Mild', 'Counseling', 'None', 'None', 'Counseling sessions', 'Medication review progress', '2023-10-01', 'Stable'),
(32, 3, 11, '2023-10-24', 'Checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(33, 3, 33, '2023-10-25', 'Back pain', 'M54.5', 'Low Back Pain', 'Chronic', 'Moderate', 'Physical therapy', 'Muscle relaxants', 'None', 'Follow exercises regularly', 'Regular back pain assessment', '2023-10-01', 'Ongoing'),
(34, 4, 4, '2023-10-26', 'Post-surgery follow-up', 'Z48.815', 'Postoperative Wound Infection', 'Acute', 'Mild', 'Antibiotics', 'None', 'None', 'Complete antibiotics course', 'Wound healing well', '2023-10-01', 'Resolved'),
(35, 5, 5, '2023-10-27', 'Hypertension', 'I10', 'Essential Hypertension', 'Chronic', 'Severe', 'Medication (ACE inhibitors)', 'Anti-hypertensive drugs', 'None', 'Monitor blood pressure regularly', 'Blood pressure control', '2023-10-01', 'Under Control'),
(36, 6, 8, '2023-10-28', 'Diabetes', 'E11.9', 'Type 2 Diabetes', 'Chronic', 'Moderate', 'Diet and exercise', 'Metformin', 'HbA1c test', 'Follow diet plan and exercise', 'Stable blood sugar levels', '2023-10-01', 'Stable'),
(37, 3, 7, '2023-10-29', 'Allergic Rhinitis', 'J30.1', 'Allergic Rhinitis', 'Chronic', 'Mild', 'Antihistamines', 'Nasal corticosteroids', 'None', 'Avoid allergens', 'Improved with treatment', '2023-10-01', 'Under Control'),
(38, 8, 8, '2023-10-30', 'Post-surgery follow-up', 'Z48.815', 'Postoperative Wound Infection', 'Acute', 'Mild', 'Antibiotics', 'None', 'None', 'Complete antibiotics course', 'Wound healing well', '2023-10-01', 'Resolved'),
(39, 9, 9, '2023-10-31', 'Annual checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(40, 40, 10, '2023-11-01', 'Weight loss consultation', 'E66.9', 'Obesity, Unspecified', 'Chronic', 'Moderate', 'Diet and exercise plan', 'Weight loss medications', 'None', 'Follow diet and exercise plan', 'Weight loss progress', '2023-10-01', 'Ongoing'),
(41, 11, 1, '2023-11-02', 'Chronic migraine', 'G43.919', 'Chronic Migraine without Aura', 'Chronic', 'Severe', 'Migraine management', 'Triptans', 'None', 'Migraine diary', 'Regular migraine assessments', '2023-10-01', 'Under Control'),
(42, 42, 2, '2023-11-03', 'Annual checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed'),
(43, 43, 4, '2023-11-04', 'Eczema', 'L30.9', 'Dermatitis, Unspecified', 'Chronic', 'Mild', 'Topical corticosteroids', 'Emollients', 'None', 'Skin care regimen', 'Eczema management', '2023-10-01', 'Under Control'),
(44, 2, 24, '2023-11-05', 'Post-surgery follow-up', 'Z48.815', 'Postoperative Wound Infection', 'Acute', 'Mild', 'Antibiotics', 'None', 'None', 'Complete antibiotics course', 'Wound healing well', '2023-10-01', 'Resolved'),
(45, 5, 11, '2023-11-06', 'Annual checkup', 'Z00.00', 'General Medical Examination', 'Acute', 'N/A', 'None', 'None', 'None', 'No specific instructions', 'Routine checkup', '2023-10-01', 'Completed');

--INSERT Prescription TABLES
INSERT INTO dbo.Prescription (prescription_id, patient_id, provider_id, prescription_date, medication_name, dosage, frequency, Prescribing_Physician, Patient_Instructions)
VALUES
(1, 1, 1, '2023-09-23', 'Aspirin', '325mg', 'Once daily', 1, 'Take with food'),
(2, 2, 2, '2023-09-24', 'Ibuprofen', '400mg', 'Every 6 hours', 2, 'Do not exceed recommended dose'),
(3, 3, 3, '2023-09-25', 'Lisinopril', '10mg', 'Once daily', 3, 'Take in the morning'),
(4, 4, 4, '2023-09-26', 'Metformin', '1000mg', 'Twice daily', 4, 'Take with meals'),
(5, 5, 5, '2023-09-27', 'Cetirizine', '10mg', 'Once daily', 5, 'No specific instructions'),
(6, 6, 6, '2023-09-28', 'Amoxicillin', '500mg', 'Three times daily', 6, 'Complete the full course'),
(7, 7, 7, '2023-09-29', 'No medication prescribed', '', '', 7, 'No specific instructions'),
(8, 8, 8, '2023-09-30', 'Orlistat', '120mg', 'Three times daily', 8, 'Take with meals'),
(9, 9, 9, '2023-10-01', 'Sumatriptan', '100mg', 'As needed', 9, 'Take at the onset of migraine'),
(10, 10, 10, '2023-10-02', 'No medication prescribed', '', '', 10, 'No specific instructions'),
(11, 11, 11, '2023-10-03', 'Hydrocortisone cream', '1%', 'Apply as needed', 11, 'Apply to affected areas'),
(12, 12, 12, '2023-10-04', 'Amoxicillin', '500mg', 'Three times daily', 12, 'Complete the full course'),
(13, 13, 13, '2023-10-05', 'No medication prescribed', '', '', 13, 'No specific instructions'),
(14, 14, 14, '2023-10-06', 'Acetaminophen', '500mg', 'As needed', 14, 'Do not exceed recommended dose'),
(15, 15, 15, '2023-10-07', 'No medication prescribed', '', '', 15, 'No specific instructions'),
(16, 16, 16, '2023-10-08', 'No medication prescribed', '', '', 16, 'No specific instructions'),
(17, 17, 17, '2023-10-09', 'Ibuprofen', '400mg', 'Every 6 hours', 17, 'Do not exceed recommended dose'),
(18, 18, 18, '2023-10-10', 'Amoxicillin', '500mg', 'Three times daily', 18, 'Complete the full course'),
(19, 19, 19, '2023-10-11', 'Lisinopril', '10mg', 'Once daily', 19, 'Take in the morning'),
(20, 20, 20, '2023-10-12', 'Metformin', '1000mg', 'Twice daily', 20, 'Take with meals'),
(21, 21, 21, '2023-10-13', 'Cetirizine', '10mg', 'Once daily', 21, 'No specific instructions'),
(22, 22, 22, '2023-10-14', 'Amoxicillin', '500mg', 'Three times daily', 22, 'Complete the full course'),
(23, 23, 23, '2023-10-15', 'No medication prescribed', '', '', 23, 'No specific instructions'),
(24, 24, 24, '2023-10-16', 'No medication prescribed', '', '', 24, 'No specific instructions'),
(25, 25, 25, '2023-10-17', 'Sumatriptan', '100mg', 'As needed', 25, 'Take at the onset of migraine'),
(26, 26, 26, '2023-10-18', 'No medication prescribed', '', '', 26, 'No specific instructions'),
(27, 27, 27, '2023-10-19', 'Hydrocortisone cream', '1%', 'Apply as needed', 27, 'Apply to affected areas'),
(28, 28, 28, '2023-10-20', 'Amoxicillin', '500mg', 'Three times daily', 28, 'Complete the full course'),
(29, 29, 29, '2023-10-21', 'No medication prescribed', '', '', 29, 'No specific instructions'),
(30, 30, 30, '2023-10-22', 'Acetaminophen', '500mg', 'As needed', 30, 'Do not exceed recommended dose'),
(31, 31, 31, '2023-10-23', 'No medication prescribed', '', '', 31, 'No specific instructions'),
(32, 32, 32, '2023-10-24', 'No medication prescribed', '', '', 32, 'No specific instructions'),
(33, 33, 33, '2023-10-25', 'Ibuprofen', '400mg', 'Every 6 hours', 33, 'Do not exceed recommended dose'),
(34, 34, 34, '2023-10-26', 'Amoxicillin', '500mg', 'Three times daily', 34, 'Complete the full course'),
(35, 35, 35, '2023-10-27', 'Lisinopril', '10mg', 'Once daily', 35, 'Take in the morning'),
(36, 36, 36, '2023-10-28', 'Metformin', '1000mg', 'Twice daily', 36, 'Take with meals'),
(37, 37, 37, '2023-10-29', 'Cetirizine', '10mg', 'Once daily', 37, 'No specific instructions'),
(38, 38, 38, '2023-10-30', 'Amoxicillin', '500mg', 'Three times daily', 38, 'Complete the full course'),
(39, 39, 39, '2023-10-31', 'No medication prescribed', '', '', 39, 'No specific instructions'),
(40, 40, 22, '2023-11-01', 'Orlistat', '120mg', 'Three times daily', 40, 'Take with meals'),
(47, 2, 2, '2023-09-24', 'Ibuprofen', '400mg', 'Every 6 hours', 2, 'Do not exceed recommended dose'),
(48, 3, 3, '2023-09-25', 'Lisinopril', '10mg', 'Once daily', 3, 'Take in the morning'),
(49, 4, 4, '2023-09-26', 'Metformin', '1000mg', 'Twice daily', 4, 'Take with meals'),
(50, 5, 5, '2023-09-27', 'Cetirizine', '10mg', 'Once daily', 5, 'No specific instructions'),
(51, 6, 6, '2023-09-28', 'Amoxicillin', '500mg', 'Three times daily', 6, 'Complete the full course'),
(52, 7, 7, '2023-09-29', 'No medication prescribed', '', '', 7, 'No specific instructions'),
(53, 8, 8, '2023-09-30', 'Orlistat', '120mg', 'Three times daily', 8, 'Take with meals'),
(54, 9, 9, '2023-10-01', 'Sumatriptan', '100mg', 'As needed', 9, 'Take at the onset of migraine'),
(55, 10, 10, '2023-10-02', 'No medication prescribed', '', '', 10, 'No specific instructions'),
(56, 11, 11, '2023-10-03', 'Hydrocortisone cream', '1%', 'Apply as needed', 11, 'Apply to affected areas'),
(57, 12, 12, '2023-10-04', 'Amoxicillin', '500mg', 'Three times daily', 12, 'Complete the full course'),
(58, 13, 13, '2023-10-05', 'No medication prescribed', '', '', 13, 'No specific instructions'),
(59, 14, 14, '2023-10-06', 'Acetaminophen', '500mg', 'As needed', 14, 'Do not exceed recommended dose'),
(60, 15, 15, '2023-10-07', 'No medication prescribed', '', '', 15, 'No specific instructions'),
(61, 16, 16, '2023-10-08', 'No medication prescribed', '', '', 16, 'No specific instructions'),
(62, 17, 17, '2023-10-09', 'Ibuprofen', '400mg', 'Every 6 hours', 17, 'Do not exceed recommended dose'),
(63, 18, 18, '2023-10-10', 'Amoxicillin', '500mg', 'Three times daily', 18, 'Complete the full course'),
(64, 19, 19, '2023-10-11', 'Lisinopril', '10mg', 'Once daily', 19, 'Take in the morning'),
(65, 20, 20, '2023-10-12', 'Metformin', '1000mg', 'Twice daily', 20, 'Take with meals'),
(66, 21, 21, '2023-10-13', 'Cetirizine', '10mg', 'Once daily', 21, 'No specific instructions'),
(67, 22, 22, '2023-10-14', 'Amoxicillin', '500mg', 'Three times daily', 22, 'Complete the full course'),
(68, 23, 23, '2023-10-15', 'No medication prescribed', '', '', 23, 'No specific instructions'),
(69, 24, 24, '2023-10-16', 'No medication prescribed', '', '', 24, 'No specific instructions'),
(70, 25, 25, '2023-10-17', 'Sumatriptan', '100mg', 'As needed', 25, 'Take at the onset of migraine'),
(71, 26, 26, '2023-10-18', 'No medication prescribed', '', '', 26, 'No specific instructions'),
(72, 27, 27, '2023-10-19', 'Hydrocortisone cream', '1%', 'Apply as needed', 27, 'Apply to affected areas'),
(73, 28, 28, '2023-10-20', 'Amoxicillin', '500mg', 'Three times daily', 28, 'Complete the full course'),
(74, 29, 29, '2023-10-21', 'No medication prescribed', '', '', 29, 'No specific instructions'),
(75, 30, 30, '2023-10-22', 'Acetaminophen', '500mg', 'As needed', 30, 'Do not exceed recommended dose');

--INSERT Procedure TABLES
INSERT INTO dbo.[Procedure] (procedure_id, patient_id, provider_id, procedure_date, procedure_description, Cost, Duration, Associated_provider, Preoperative_Instructions, Postoperative_Instructions)
VALUES
(1, 1, 1, '2023-09-23', 'Appendectomy', 3500.00, '1 hour', 1, 'Fasting for 12 hours', 'Rest and avoid heavy lifting'),
(2, 2, 2, '2023-09-24', 'Knee Arthroscopy', 2500.00, '45 minutes', 2, 'Fasting for 6 hours', 'Elevate and ice the knee'),
(3, 3, 3, '2023-09-25', 'Cataract Surgery', 4000.00, '30 minutes', 3, 'Fasting for 6 hours', 'Use prescribed eye drops'),
(4, 4, 4, '2023-09-26', 'Colonoscopy', 1200.00, '1 hour', 4, 'Colon cleansing prep', 'Rest and hydrate'),
(5, 5, 5, '2023-09-27', 'Dental Cleaning', 150.00, '30 minutes', 5, 'None', 'Resume normal activities'),
(6, 6, 6, '2023-09-28', 'Hernia Repair', 3200.00, '1 hour', 6, 'Fasting for 6 hours', 'Rest and avoid heavy lifting'),
(7, 7, 7, '2023-09-29', 'MRI Scan', 800.00, '45 minutes', 7, 'None', 'Resume normal activities'),
(8, 8, 8, '2023-09-30', 'Tonsillectomy', 2800.00, '30 minutes', 8, 'Fasting for 12 hours', 'Rest and avoid throat irritants'),
(9, 9, 9, '2023-10-01', 'Endoscopy', 1500.00, '1 hour', 9, 'Fasting for 6 hours', 'Rest and hydrate'),
(10, 10, 10, '2023-10-02', 'Physical Therapy', 300.00, '1 hour', 10, 'None', 'Follow therapist instructions'),
(11, 11, 11, '2023-10-03', 'Dermabrasion', 2200.00, '45 minutes', 11, 'No specific prep', 'Apply ointment as instructed'),
(12, 12, 12, '2023-10-04', 'Knee Replacement', 6000.00, '2 hours', 12, 'Fasting for 8 hours', 'Physical therapy after surgery'),
(13, 13, 13, '2023-10-05', 'X-ray', 250.00, '15 minutes', 13, 'None', 'No specific post-op instructions'),
(14, 14, 14, '2023-10-06', 'Cystoscopy', 1800.00, '30 minutes', 14, 'Fasting for 6 hours', 'Rest and hydrate'),
(15, 15, 15, '2023-10-07', 'Teeth Whitening', 200.00, '1 hour', 15, 'None', 'Avoid staining foods and drinks'),
(16, 16, 16, '2023-10-08', 'Appendectomy', 3500.00, '1 hour', 16, 'Fasting for 12 hours', 'Rest and avoid heavy lifting'),
(17, 17, 17, '2023-10-09', 'Knee Arthroscopy', 2500.00, '45 minutes', 17, 'Fasting for 6 hours', 'Elevate and ice the knee'),
(18, 18, 18, '2023-10-10', 'Cataract Surgery', 4000.00, '30 minutes', 18, 'Fasting for 6 hours', 'Use prescribed eye drops'),
(19, 19, 19, '2023-10-11', 'Colonoscopy', 1200.00, '1 hour', 19, 'Colon cleansing prep', 'Rest and hydrate'),
(20, 20, 20, '2023-10-12', 'Dental Cleaning', 150.00, '30 minutes', 20, 'None', 'Resume normal activities'),
(21, 21, 21, '2023-10-13', 'Hernia Repair', 3200.00, '1 hour', 21, 'Fasting for 6 hours', 'Rest and avoid heavy lifting'),
(22, 22, 22, '2023-10-14', 'MRI Scan', 800.00, '45 minutes', 22, 'None', 'Resume normal activities'),
(23, 23, 23, '2023-10-15', 'Tonsillectomy', 2800.00, '30 minutes', 23, 'Fasting for 12 hours', 'Rest and avoid throat irritants'),
(24, 24, 24, '2023-10-16', 'Endoscopy', 1500.00, '1 hour', 24, 'Fasting for 6 hours', 'Rest and hydrate'),
(25, 25, 25, '2023-10-17', 'Physical Therapy', 300.00, '1 hour', 25, 'None', 'Follow therapist instructions'),
(26, 6, 26, '2023-10-18', 'Dermabrasion', 2200.00, '45 minutes', 26, 'No specific prep', 'Apply ointment as instructed'),
(27, 27, 27, '2023-10-19', 'Knee Replacement', 6000.00, '2 hours', 27, 'Fasting for 8 hours', 'Physical therapy after surgery'),
(28, 28, 28, '2023-10-20', 'X-ray', 250.00, '15 minutes', 28, 'None', 'No specific post-op instructions'),
(29, 29, 29, '2023-10-21', 'Cystoscopy', 1800.00, '30 minutes', 29, 'Fasting for 6 hours', 'Rest and hydrate'),
(30, 3, 30, '2023-10-22', 'Teeth Whitening', 200.00, '1 hour', 30, 'None', 'Avoid staining foods and drinks'),
(31, 31, 31, '2023-10-23', 'Appendectomy', 3500.00, '1 hour', 31, 'Fasting for 12 hours', 'Rest and avoid heavy lifting'),
(32, 32, 32, '2023-10-24', 'Knee Arthroscopy', 2500.00, '45 minutes', 32, 'Fasting for 6 hours', 'Elevate and ice the knee'),
(33, 33, 6, '2023-10-25', 'Cataract Surgery', 4000.00, '30 minutes', 33, 'Fasting for 6 hours', 'Use prescribed eye drops'),
(34, 34, 3, '2023-10-26', 'Colonoscopy', 1200.00, '1 hour', 34, 'Colon cleansing prep', 'Rest and hydrate'),
(35, 35, 5, '2023-10-27', 'Dental Cleaning', 150.00, '30 minutes', 35, 'None', 'Resume normal activities'),
(36, 36, 3, '2023-10-28', 'Hernia Repair', 3200.00, '1 hour', 36, 'Fasting for 6 hours', 'Rest and avoid heavy lifting'),
(37, 37, 7, '2023-10-29', 'MRI Scan', 800.00, '45 minutes', 37, 'None', 'Resume normal activities'),
(38, 38, 8, '2023-10-30', 'Tonsillectomy', 2800.00, '30 minutes', 38, 'Fasting for 12 hours', 'Rest and avoid throat irritants'),
(39, 39, 39, '2023-10-31', 'Endoscopy', 1500.00, '1 hour', 39, 'Fasting for 6 hours', 'Rest and hydrate'),
(40, 11, 4, '2023-11-01', 'Physical Therapy', 300.00, '1 hour', 40, 'None', 'Follow therapist instructions');



--INSERT MedicalHistory TABLES
INSERT INTO dbo.MedicalHistory (medical_history_id, patient_id, diagnosis_id, prescription_id, procedure_id, StaffID, medical_condition, past_medical_history, family_medical_history, Record_Date_and_Time, Diagnosis, Treatment_Plan, Medications_Prescribed, Test_Results, Notes)
VALUES
(1, 1, 1, 1, 1, 1, 'Hypertension', 'None', 'Family history of heart disease', '2023-09-23 08:00:00', 'High blood pressure', 'Lifestyle changes and medication', 'Lisinopril', 'Normal', 'Monitor regularly'),
(2, 2, 2, 2, 2, 2, 'Type 2 Diabetes', 'None', 'None', '2023-09-24 09:15:00', 'Diabetes mellitus', 'Insulin and dietary control', 'Metformin', 'Normal', 'Follow dietary plan'),
(3, 3, 3, 3, 3, 3, 'Asthma', 'Childhood asthma', 'None', '2023-09-25 10:30:00', 'Bronchial asthma', 'Inhaler and avoid triggers', 'Albuterol', 'Normal', 'Carry inhaler always'),
(4, 4, 4, 4, 4, 4, 'Celiac Disease', 'None', 'None', '2023-09-26 11:45:00', 'Celiac disease', 'Gluten-free diet', 'None', 'Positive for celiac antibodies', 'Strict gluten-free diet'),
(5, 5, 5, 5, 5, 5, 'Dental Cavities', 'Previous fillings', 'None', '2023-09-27 13:00:00', 'Dental cavities', 'Fillings and regular checkups', 'None', 'Needs dental fillings', 'Schedule follow-up'),
(6, 6, 6, 6, 6, 6, 'Hernia', 'None', 'None', '2023-09-28 14:15:00', 'Inguinal hernia', 'Surgery recommended', 'None', 'Confirm with surgeon', 'Consult with surgeon'),
(7, 7, 7, 7, 7, 7, 'None', 'None', 'None', '2023-09-29 15:30:00', 'Routine check-up', 'None', 'None', 'Normal', 'Next appointment in six months'),
(8, 8, 8, 8, 8, 8, 'Tonsillitis', 'None', 'None', '2023-09-30 16:45:00', 'Chronic tonsillitis', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with an ENT specialist'),
(9, 9, 9, 9, 9, 9, 'Gastroesophageal Reflux', 'None', 'None', '2023-10-01 18:00:00', 'GERD', 'Lifestyle changes and medication', 'Omeprazole', 'Normal', 'Follow dietary guidelines'),
(10, 10, 10, 10, 10, 10, 'Physical Therapy', 'None', 'None', '2023-10-02 19:15:00', 'Physical therapy', 'Physical therapy exercises', 'None', 'Improved flexibility', 'Follow therapy plan'),
(11, 11, 11, 11, 11, 11, 'Eczema', 'Previous flare-ups', 'Family history of eczema', '2023-10-03 20:30:00', 'Atopic dermatitis', 'Topical creams and avoid triggers', 'Hydrocortisone', 'Improved skin condition', 'Apply creams as needed'),
(12, 12, 12, 12, 12, 12, 'Knee Osteoarthritis', 'None', 'Family history of osteoarthritis', '2023-10-04 21:45:00', 'Osteoarthritis', 'Pain management and physical therapy', 'Ibuprofen', 'Improved mobility', 'Follow pain management plan'),
(13, 13, 13, 13, 13, 13, 'X-ray for Fracture', 'None', 'None', '2023-10-05 23:00:00', 'Fracture evaluation', 'Rest and possibly casting', 'None', 'Diagnosis of fracture', 'Follow orthopedic recommendations'),
(14, 14, 14, 14, 14, 14, 'Bladder Infection', 'None', 'None', '2023-10-06 08:15:00', 'Urinary tract infection', 'Antibiotics', 'Ciprofloxacin', 'Cleared infection', 'Complete antibiotic course'),
(15, 15, 15, 15, 15, 15, 'Dental Cleaning', 'Previous dental fillings', 'None', '2023-10-07 09:30:00', 'Dental cleaning', 'Regular cleanings', 'None', 'Cleaned teeth', 'Schedule next cleaning'),
(16, 16, 16, 16, 16, 16, 'Hernia', 'None', 'None', '2023-10-08 10:45:00', 'Inguinal hernia', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with surgeon'),
(17, 17, 17, 17, 17, 17, 'None', 'None', 'None', '2023-10-09 12:00:00', 'Routine check-up', 'None', 'None', 'Normal', 'Next appointment in six months'),
(18, 18, 18, 18, 18, 18, 'Tonsillitis', 'None', 'None', '2023-10-10 13:15:00', 'Chronic tonsillitis', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with an ENT specialist'),
(19, 19, 19, 19, 19, 19, 'Gastroesophageal Reflux', 'None', 'None', '2023-10-11 14:30:00', 'GERD', 'Lifestyle changes and medication', 'Omeprazole', 'Normal', 'Follow dietary guidelines'),
(20, 20, 20, 20, 20, 20, 'Physical Therapy', 'None', 'None', '2023-10-12 15:45:00', 'Physical therapy', 'Physical therapy exercises', 'None', 'Improved flexibility', 'Follow therapy plan'),
(21, 21, 21, 21, 21, 21, 'Eczema', 'Previous flare-ups', 'Family history of eczema', '2023-10-13 17:00:00', 'Atopic dermatitis', 'Topical creams and avoid triggers', 'Hydrocortisone', 'Improved skin condition', 'Apply creams as needed'),
(22, 22, 22, 22, 22, 22, 'Knee Osteoarthritis', 'None', 'Family history of osteoarthritis', '2023-10-14 18:15:00', 'Osteoarthritis', 'Pain management and physical therapy', 'Ibuprofen', 'Improved mobility', 'Follow pain management plan'),
(23, 23, 23, 23, 23, 23, 'X-ray for Fracture', 'None', 'None', '2023-10-15 19:30:00', 'Fracture evaluation', 'Rest and possibly casting', 'None', 'Diagnosis of fracture', 'Follow orthopedic recommendations'),
(24, 24, 24, 24, 24, 24, 'Bladder Infection', 'None', 'None', '2023-10-16 20:45:00', 'Urinary tract infection', 'Antibiotics', 'Ciprofloxacin', 'Cleared infection', 'Complete antibiotic course'),
(25, 25, 25, 25, 25, 25, 'Dental Cleaning', 'Previous dental fillings', 'None', '2023-10-17 22:00:00', 'Dental cleaning', 'Regular cleanings', 'None', 'Cleaned teeth', 'Schedule next cleaning'),
(26, 26, 26, 26, 26, 26, 'Hernia', 'None', 'None', '2023-10-18 08:15:00', 'Inguinal hernia', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with surgeon'),
(27, 27, 27, 27, 27, 27, 'None', 'None', 'None', '2023-10-19 09:30:00', 'Routine check-up', 'None', 'None', 'Normal', 'Next appointment in six months'),
(28, 28, 28, 28, 28, 28, 'Tonsillitis', 'None', 'None', '2023-10-20 10:45:00', 'Chronic tonsillitis', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with an ENT specialist'),
(29, 29, 29, 29, 29, 29, 'Gastroesophageal Reflux', 'None', 'None', '2023-10-21 12:00:00', 'GERD', 'Lifestyle changes and medication', 'Omeprazole', 'Normal', 'Follow dietary guidelines'),
(30, 30, 30, 30, 30, 30, 'Physical Therapy', 'None', 'None', '2023-10-22 13:15:00', 'Physical therapy', 'Physical therapy exercises', 'None', 'Improved flexibility', 'Follow therapy plan'),
(31, 31, 31, 31, 31, 31, 'Eczema', 'Previous flare-ups', 'Family history of eczema', '2023-10-23 14:30:00', 'Atopic dermatitis', 'Topical creams and avoid triggers', 'Hydrocortisone', 'Improved skin condition', 'Apply creams as needed'),
(32, 32, 32, 32, 32, 32, 'Knee Osteoarthritis', 'None', 'Family history of osteoarthritis', '2023-10-24 15:45:00', 'Osteoarthritis', 'Pain management and physical therapy', 'Ibuprofen', 'Improved mobility', 'Follow pain management plan'),
(33, 33, 33, 33, 33, 33, 'X-ray for Fracture', 'None', 'None', '2023-10-25 17:00:00', 'Fracture evaluation', 'Rest and possibly casting', 'None', 'Diagnosis of fracture', 'Follow orthopedic recommendations'),
(34, 34, 34, 34, 34, 34, 'Bladder Infection', 'None', 'None', '2023-10-26 18:15:00', 'Urinary tract infection', 'Antibiotics', 'Ciprofloxacin', 'Cleared infection', 'Complete antibiotic course'),
(35, 35, 35, 35, 35, 35, 'Dental Cleaning', 'Previous dental fillings', 'None', '2023-10-27 19:30:00', 'Dental cleaning', 'Regular cleanings', 'None', 'Cleaned teeth', 'Schedule next cleaning'),
(36, 36, 36, 36, 36, 36, 'Hernia', 'None', 'None', '2023-10-28 20:45:00', 'Inguinal hernia', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with surgeon'),
(37, 37, 37, 37, 37, 37, 'None', 'None', 'None', '2023-10-29 22:00:00', 'Routine check-up', 'None', 'None', 'Normal', 'Next appointment in six months'),
(38, 38, 38, 38, 38, 38, 'Tonsillitis', 'None', 'None', '2023-10-30 08:15:00', 'Chronic tonsillitis', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with an ENT specialist'),
(39, 39, 39, 39, 39, 39, 'Gastroesophageal Reflux', 'None', 'None', '2023-10-31 09:30:00', 'GERD', 'Lifestyle changes and medication', 'Omeprazole', 'Normal', 'Follow dietary guidelines'),
(40, 40, 40, 40, 40, 40, 'Physical Therapy', 'None', 'None', '2023-11-01 10:45:00', 'Physical therapy', 'Physical therapy exercises', 'None', 'Improved flexibility', 'Follow therapy plan'),
(41, 41, 1, 1, 1, 41, 'Eczema', 'Previous flare-ups', 'Family history of eczema', '2023-11-02 12:00:00', 'Atopic dermatitis', 'Topical creams and avoid triggers', 'Hydrocortisone', 'Improved skin condition', 'Apply creams as needed'),
(42, 42, 2, 2, 2, 42, 'Knee Osteoarthritis', 'None', 'Family history of osteoarthritis', '2023-11-03 13:15:00', 'Osteoarthritis', 'Pain management and physical therapy', 'Ibuprofen', 'Improved mobility', 'Follow pain management plan'),
(43, 43, 3, 3, 3, 43, 'X-ray for Fracture', 'None', 'None', '2023-11-04 14:30:00', 'Fracture evaluation', 'Rest and possibly casting', 'None', 'Diagnosis of fracture', 'Follow orthopedic recommendations'),
(44, 44, 4, 4, 4, 44, 'Bladder Infection', 'None', 'None', '2023-11-05 15:45:00', 'Urinary tract infection', 'Antibiotics', 'Ciprofloxacin', 'Cleared infection', 'Complete antibiotic course'),
(45, 45, 5, 5, 5, 45, 'Dental Cleaning', 'Previous dental fillings', 'None', '2023-11-06 17:00:00', 'Dental cleaning', 'Regular cleanings', 'None', 'Cleaned teeth', 'Schedule next cleaning'),
(46, 46, 6, 6, 6, 46, 'Hernia', 'None', 'None', '2023-11-07 18:15:00', 'Inguinal hernia', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with surgeon'),
(47, 47, 7, 7, 7, 47, 'None', 'None', 'None', '2023-11-08 19:30:00', 'Routine check-up', 'None', 'None', 'Normal', 'Next appointment in six months'),
(48, 48, 8, 8, 8, 48, 'Tonsillitis', 'None', 'None', '2023-11-09 20:45:00', 'Chronic tonsillitis', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with an ENT specialist'),
(49, 49, 9, 9, 9, 49, 'Gastroesophageal Reflux', 'None', 'None', '2023-11-10 22:00:00', 'GERD', 'Lifestyle changes and medication', 'Omeprazole', 'Normal', 'Follow dietary guidelines'),
(50, 50, 10, 10, 10, 50, 'Physical Therapy', 'None', 'None', '2023-11-11 08:15:00', 'Physical therapy', 'Physical therapy exercises', 'None', 'Improved flexibility', 'Follow therapy plan'),
(51, 51, 11, 11, 11, 11, 'Eczema', 'Previous flare-ups', 'Family history of eczema', '2023-11-12 09:30:00', 'Atopic dermatitis', 'Topical creams and avoid triggers', 'Hydrocortisone', 'Improved skin condition', 'Apply creams as needed'),
(52, 52, 12, 12, 12, 12, 'Knee Osteoarthritis', 'None', 'Family history of osteoarthritis', '2023-11-13 10:45:00', 'Osteoarthritis', 'Pain management and physical therapy', 'Ibuprofen', 'Improved mobility', 'Follow pain management plan'),
(53, 53, 13, 13, 13, 13, 'X-ray for Fracture', 'None', 'None', '2023-11-14 12:00:00', 'Fracture evaluation', 'Rest and possibly casting', 'None', 'Diagnosis of fracture', 'Follow orthopedic recommendations'),
(54, 54, 14, 14, 14, 14, 'Bladder Infection', 'None', 'None', '2023-11-15 13:15:00', 'Urinary tract infection', 'Antibiotics', 'Ciprofloxacin', 'Cleared infection', 'Complete antibiotic course'),
(55, 55, 15, 15, 15, 15, 'Dental Cleaning', 'Previous dental fillings', 'None', '2023-11-16 14:30:00', 'Dental cleaning', 'Regular cleanings', 'None', 'Cleaned teeth', 'Schedule next cleaning'),
(56, 56, 16, 16, 16, 16, 'Hernia', 'None', 'None', '2023-11-17 15:45:00', 'Inguinal hernia', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with surgeon'),
(57, 57, 17, 17, 17, 17, 'None', 'None', 'None', '2023-11-18 17:00:00', 'Routine check-up', 'None', 'None', 'Normal', 'Next appointment in six months'),
(58, 58, 18, 18, 18, 18, 'Tonsillitis', 'None', 'None', '2023-11-19 18:15:00', 'Chronic tonsillitis', 'Surgery recommended', 'None', 'Schedule surgery', 'Consult with an ENT specialist'),
(59, 59, 19, 19, 19, 19, 'Gastroesophageal Reflux', 'None', 'None', '2023-11-20 19:30:00', 'GERD', 'Lifestyle changes and medication', 'Omeprazole', 'Normal', 'Follow dietary guidelines'),
(60, 60, 20, 20, 20, 20, 'Physical Therapy', 'None', 'None', '2023-11-21 20:45:00', 'Physical therapy', 'Physical therapy exercises', 'None', 'Improved flexibility', 'Follow therapy plan');

--INSERT Billing TABLES
-- Insert sample data into dbo.Billing table
INSERT INTO dbo.Billing (bill_id, patient_id, provider_id, appointment_id, diagnosis_id, prescription_id, procedure_id, bill_date, bill_amount)
VALUES
(1, 1, 1, 1, 1, 1, 1, '2022-11-01 08:00:00', 250.00),
(2, 2, 2, 2, 2, 2, 2, '2022-11-02 09:15:00', 150.00),
(3, 3, 3, 3, 3, 3, 3, '2022-11-03 10:30:00', 300.00),
(4, 4, 4, 4, 4, 4, 4, '2022-11-04 11:45:00', 180.00),
(5, 5, 5, 5, 5, 5, 5, '2022-11-05 13:00:00', 400.00),
(6, 6, 6, 6, 6, 6, 6, '2022-11-06 14:15:00', 220.00),
(7, 7, 7, 7, 7, 7, 7, '2022-11-07 15:30:00', 275.00),
(8, 8, 8, 8, 8, 8, 8, '2022-11-08 16:45:00', 190.00),
(9, 9, 9, 9, 9, 9, 9, '2022-11-09 18:00:00', 350.00),
(10, 10, 10, 10, 10, 10, 10, '2022-11-10 19:15:00', 230.00),
(11, 11, 11, 11, 11, 11, 11, '2022-11-11 20:30:00', 425.00),
(12, 12, 12, 12, 12, 12, 12, '2022-11-12 08:00:00', 265.00),
(13, 13, 13, 13, 13, 13, 13, '2022-11-13 09:15:00', 175.00),
(14, 14, 14, 14, 14, 14, 14, '2022-11-14 10:30:00', 310.00),
(15, 15, 15, 15, 15, 15, 15, '2022-11-15 11:45:00', 195.00),
(16, 16, 16, 16, 16, 16, 16, '2022-11-16 13:00:00', 420.00),
(17, 17, 17, 17, 17, 17, 17, '2022-11-17 14:15:00', 240.00),
(18, 18, 18, 18, 18, 18, 18, '2022-11-18 15:30:00', 285.00),
(19, 19, 19, 19, 19, 19, 19, '2022-11-19 16:45:00', 200.00),
(20, 20, 20, 20, 20, 20, 20, '2022-11-20 18:00:00', 360.00),
(21, 21, 21, 21, 21, 21, 21, '2022-11-21 19:15:00', 250.00),
(22, 22, 22, 22, 22, 22, 22, '2022-11-22 20:30:00', 435.00),
(23, 23, 23, 23, 23, 23, 23, '2022-11-23 08:00:00', 280.00),
(24, 24, 24, 24, 24, 24, 24, '2022-11-24 09:15:00', 190.00),
(25, 25, 25, 25, 25, 25, 25, '2022-11-25 10:30:00', 320.00),
(26, 26, 26, 26, 26, 26, 26, '2022-11-26 11:45:00', 210.00),
(27, 27, 27, 27, 27, 27, 27, '2022-11-27 13:00:00', 440.00),
(28, 28, 28, 28, 28, 28, 28, '2022-11-28 14:15:00', 260.00),
(29, 29, 29, 29, 29, 29, 29, '2022-11-29 15:30:00', 295.00),
(30, 30, 30, 30, 30, 30, 30, '2022-11-30 16:45:00', 220.00),
(31, 31, 31, 31, 31, 31, 31, '2022-12-01 18:00:00', 375.00),
(32, 32, 32, 32, 32, 32, 32, '2022-12-02 19:15:00', 265.00),
(33, 33, 33, 33, 33, 33, 33, '2022-12-03 20:30:00', 450.00),
(34, 34, 34, 34, 34, 34, 34, '2022-12-04 22:00:00', 295.00),
(35, 35, 35, 35, 35, 35, 35, '2022-12-05 08:15:00', 220.00),
(36, 36, 36, 36, 36, 36, 36, '2022-12-06 09:30:00', 330.00),
(37, 37, 37, 37, 37, 37, 37, '2022-12-07 10:45:00', 230.00),
(38, 38, 38, 38, 38, 38, 38, '2022-12-08 12:00:00', 490.00),
(39, 39, 39, 39, 39, 39, 39, '2022-12-09 13:15:00', 310.00),
(40, 40, 40, 40, 40, 40, 40, '2022-12-10 14:30:00', 265.00),
(41, 1, 1, 1, 1, 1, 1, '2022-12-11 15:45:00', 520.00),
(42, 2, 2, 2, 2, 2, 2, '2022-12-12 17:00:00', 375.00),
(43, 3, 3, 3, 3, 3, 3, '2022-12-13 18:15:00', 250.00),
(44, 4, 4, 4, 4, 4, 4, '2022-12-14 19:30:00', 550.00),
(45, 5, 5, 5, 5, 5, 5, '2022-12-15 20:45:00', 320.00),
(46, 6, 6, 6, 6, 6, 6, '2022-12-16 22:00:00', 235.00),
(47, 7, 7, 7, 7, 7, 7, '2022-12-17 08:15:00', 525.00),
(48, 8, 8, 8, 8, 8, 8, '2022-12-18 09:30:00', 295.00),
(49, 9, 9, 9, 9, 9, 9, '2022-12-19 10:45:00', 260.00),
(50, 10, 10, 10, 10, 10, 10, '2022-12-20 12:00:00', 590.00),
(51, 11, 11, 11, 11, 11, 11, '2022-12-21 13:15:00', 345.00),
(52, 12, 12, 12, 12, 12, 12, '2022-12-22 14:30:00', 275.00),
(53, 13, 13, 13, 13, 13, 13, '2022-12-23 15:45:00', 610.00),
(54, 14, 14, 14, 14, 14, 14, '2022-12-24 17:00:00', 400.00),
(55, 15, 15, 15, 15, 15, 15, '2022-12-25 18:15:00', 290.00),
(56, 16, 16, 16, 16, 16, 16, '2022-12-26 19:30:00', 620.00),
(57, 17, 17, 17, 17, 17, 17, '2022-12-27 20:45:00', 335.00),
(58, 18, 18, 18, 18, 18, 18, '2022-12-28 08:00:00', 270.00),
(59, 19, 19, 19, 19, 19, 19, '2022-12-29 09:15:00', 630.00),
(60, 20, 20, 20, 20, 20, 20, '2022-12-30 10:30:00', 410.00),
(61, 1, 1, 1, 1, 1, 1, '2022-12-31 11:45:00', 310.00),
(62, 2, 2, 2, 2, 2, 2, '2023-01-01 13:00:00', 640.00),
(63, 3, 3, 3, 3, 3, 3, '2023-01-02 14:15:00', 345.00),
(64, 4, 4, 4, 4, 4, 4, '2023-01-03 15:30:00', 280.00),
(65, 5, 5, 5, 5, 5, 5, '2023-01-04 16:45:00', 660.00),
(66, 6, 6, 6, 6, 6, 6, '2023-01-05 18:00:00', 425.00),
(67, 7, 7, 7, 7, 7, 7, '2023-01-06 19:15:00', 290.00),
(68, 8, 8, 8, 8, 8, 8, '2023-01-07 20:30:00', 680.00),
(69, 9, 9, 9, 9, 9, 9, '2023-01-08 08:00:00', 360.00),
(70, 10, 10, 10, 10, 10, 10, '2023-01-09 09:15:00', 315.00),
(71, 3, 3, 3, 3, 3, 3, '2023-01-10 10:30:00', 700.00),
(72, 2, 2, 2, 2, 2, 2, '2023-01-11 11:45:00', 330.00),
(73, 3, 3, 3, 3, 3, 3, '2023-01-12 13:00:00', 295.00),
(74, 4, 4, 4, 4, 4, 4, '2023-01-13 14:15:00', 720.00),
(75, 5, 5, 5, 5, 5, 5, '2023-01-14 15:30:00', 360.00);

--INSERT Insurance TABLES
-- Insert sample data into dbo.Insurance table
INSERT INTO dbo.Insurance (insurance_id, patient_id, insurance_provider, insurance_policy_number, insurance_expiry_date, Claim_Status)
VALUES
(1, 1, 'XYZ Insurance', 'POL-123', '2024-12-31', 'Active'),
(2, 2, 'ABC Insurance', 'POL-456', '2024-11-30', 'In-Active'),
(3, 3, 'LMN Insurance', 'POL-789', '2024-10-31', 'Active'),
(4, 4, 'PQR Insurance', 'POL-987', '2024-09-30', 'In-Active'),
(5, 5, 'DEF Insurance', 'POL-654', '2024-08-31', 'In-Active'),
(6, 6, 'GHI Insurance', 'POL-321', '2024-07-31', 'Active'),
(7, 7, 'JKL Insurance', 'POL-963', '2024-06-30', 'Active'),
(8, 8, 'UVW Insurance', 'POL-852', '2024-05-31', 'In-Active'),
(9, 9, 'MNO Insurance', 'POL-741', '2024-04-30', 'Active'),
(10, 10, 'RST Insurance', 'POL-369', '2024-03-31', 'Active'),
(11, 11, 'WXY Insurance', 'POL-258', '2024-02-29', 'Active'),
(12, 12, 'XYZ Insurance', 'POL-123', '2024-01-31', 'Active'),
(13, 13, 'ABC Insurance', 'POL-456', '2023-12-31', 'Active'),
(14, 14, 'LMN Insurance', 'POL-789', '2023-11-30', 'Active'),
(15, 15, 'PQR Insurance', 'POL-987', '2023-10-31', 'Active'),
(16, 16, 'DEF Insurance', 'POL-654', '2023-09-30', 'Active'),
(17, 17, 'GHI Insurance', 'POL-321', '2023-08-31', 'Active'),
(18, 18, 'JKL Insurance', 'POL-963', '2023-07-31', 'Active'),
(19, 19, 'UVW Insurance', 'POL-852', '2023-06-30', 'In-Active'),
(20, 20, 'MNO Insurance', 'POL-741', '2023-05-31', 'In-Active'),
(21, 21, 'RST Insurance', 'POL-369', '2023-04-30', 'Active'),
(22, 22, 'WXY Insurance', 'POL-258', '2023-03-31', 'Active'),
(23, 23, 'XYZ Insurance', 'POL-123', '2023-02-28', 'Active'),
(24, 24, 'ABC Insurance', 'POL-456', '2023-01-31', 'Active'),
(25, 25, 'LMN Insurance', 'POL-789', '2022-12-31', 'Active'),
(26, 26, 'PQR Insurance', 'POL-987', '2022-11-30', 'Active'),
(27, 27, 'DEF Insurance', 'POL-654', '2022-10-31', 'In-Active'),
(28, 28, 'GHI Insurance', 'POL-321', '2022-09-30', 'In-Active'),
(29, 29, 'JKL Insurance', 'POL-963', '2022-08-31', 'Active'),
(30, 30, 'UVW Insurance', 'POL-852', '2022-07-31', 'Active'),
(31, 31, 'MNO Insurance', 'POL-741', '2022-06-30', 'Active'),
(32, 12, 'RST Insurance', 'POL-369', '2022-05-31', 'Active'),
(33, 33, 'WXY Insurance', 'POL-258', '2022-04-30', 'Active'),
(34, 34, 'XYZ Insurance', 'POL-123', '2022-03-31', 'In-Active'),
(35, 35, 'ABC Insurance', 'POL-456', '2022-02-28', 'Active'),
(36, 36, 'LMN Insurance', 'POL-789', '2022-01-31', 'In-Active'),
(37, 37, 'PQR Insurance', 'POL-987', '2021-12-31', 'Active'),
(38, 38, 'DEF Insurance', 'POL-654', '2021-11-30', 'Active'),
(39, 39, 'GHI Insurance', 'POL-321', '2021-10-31', 'Active'),
(40, 40, 'JKL Insurance', 'POL-963', '2021-09-30', 'Active'),
(41, 1, 'UVW Insurance', 'POL-852', '2021-08-31', 'Active'),
(42, 2, 'MNO Insurance', 'POL-741', '2021-07-31', 'In-Active'),
(43, 3, 'RST Insurance', 'POL-369', '2021-06-30', 'Active'),
(44, 4, 'WXY Insurance', 'POL-258', '2021-05-31', 'Active'),
(45, 5, 'XYZ Insurance', 'POL-123', '2021-04-30', 'Active'),
(46, 6, 'ABC Insurance', 'POL-456', '2021-03-31', 'Active'),
(47, 7, 'LMN Insurance', 'POL-789', '2021-02-28', 'Active'),
(48, 8, 'PQR Insurance', 'POL-987', '2021-01-31', 'Active'),
(49, 9, 'DEF Insurance', 'POL-654', '2020-12-31', 'Active'),
(50, 10, 'GHI Insurance', 'POL-321', '2020-11-30', 'In-Active');