INSERT INTO physician VALUES ('123456789','Smith, Mary','Cardiology','123 Main St.','Arlington','TX','76019',null);

INSERT INTO physician VALUES ('234567890','Jones, Jerry','Opthamology','55 Border St.','Arlington','TX','76022',null);

INSERT INTO physician VALUES ('345678901','Seuss, Melvin','Orthopedics','999 Ham Ave','Ft. Worth','TX','74111','123456789');

INSERT INTO physician VALUES ('456789012','Crane, Frazier','Psychiatry','123 Main St.','Arlington','TX','76019','234567890');

INSERT INTO physician VALUES ('567890123','Crane, Niles','Dermatology','55443 Daphny St.','Seattle','WA','99221','123456789');


INSERT INTO patient VALUES ('987654321','Bush, George','555 6th St.','Austin','TX','43221','123456789');
INSERT INTO patient VALUES ('876543210','Gore, Al','2233 J Street','Washington','DC','11111','234567890');
INSERT INTO patient VALUES ('765432109','Perot, Ross','99 EDS Lane','Dallas','TX','79901','345678901');
INSERT INTO patient VALUES ('654321098','Clinton, Hilary','200 5th Ave.','New York','NY','10012','123456789');
INSERT INTO patient VALUES ('543210987','Clinton, Bill','690 State St.','Little Rock','AK','39221','234567890');
INSERT INTO patient VALUES ('432109876','Lieberman, Joe','761 Elm St.','Hartford','CN','22122','123456789');
INSERT INTO patient VALUES ('321098765','Cheney, Dick','111 Cooper St.','Los Angeles','CA','50505','123456789');
INSERT INTO patient VALUES ('210987654','Bush, Jeb','555 6th St.','Austin','TX','43221','123456789');
INSERT INTO patient VALUES ('109876543','Nader, Ralph','224 Green St.','New York','NY','10110','345678901');
INSERT INTO patient VALUES ('098765432','Bush, Barbara','555 6th St.','Austin','TX','43221','234567890');
INSERT INTO patient VALUES ('998877665','Gore, Tipper','2233 J Street','Washington','DC','11111','123456789');
INSERT INTO patient VALUES ('887766554','McPherson, Elle','100 Star St.','Los Angeles','CA','50502','123456789');
INSERT INTO patient VALUES ('776655443','Lopez, Jennifer','9012 Sorolla Ave.','Coral Gables','FL','33034','456789012');
INSERT INTO patient VALUES ('665544332','T, Ice','4210 Rap Ave.','Los Angeles','CA','50512','345678901');
INSERT INTO patient VALUES ('554433221','Smith, Emmitt','22 Back St.','Dallas','TX','64444','345678901');
INSERT INTO patient VALUES ('443322110','Smith, Bessie','1324 Blues St.','Memphis','TN','80212','234567890');
INSERT INTO patient VALUES ('332211009','Schumann, Clara','12 Ivory Street','New Orleans','LA','44432','345678901');
INSERT INTO patient VALUES ('332211009','Schumann, Clara','12 Ivory Street','New Orleans','LA','44432','345678901');
INSERT INTO patient VALUES ('221100998','Beethoven, L.V.','9 Symphony St.','Boston','MA','22661','567890123');
INSERT INTO patient VALUES ('110090887','Ross, Diana','678 Motown Street','Detroit','MI','72212','123456789');
INSERT INTO patient VALUES ('009988776','Lennon, John','211 W. Central Park Ave.','New York','NY','10021','345678901');
INSERT INTO patient VALUES ('019283746','Ono, Yoko','211 W. Central Pk.','New York','NY','10021','345678901');
INSERT INTO patient VALUES ('102938475','Shakespeare, Bill','198 Avon St.','New London','CN','22112','123456789');
INSERT INTO patient VALUES ('293847560','Marlowe, Chris','657 Picadilly St.','San Francisco','CA','33221','567890123');
INSERT INTO patient VALUES ('394857601','Curie, Marie','98 Nucleus Ave.','Chicago','IL','40029','456789012');
INSERT INTO patient VALUES ('564738291','Einstein, Al','7344 EMC2 St.','Princeton','NJ','31192','123456789');
INSERT INTO patient VALUES ('847560192','Pavlova, Anna','70 Pointe Lane','Moscow','ID','77653','123456789');
INSERT INTO patient VALUES ('758493026','Baryshnikov, Mike','76 Jump St.','El Paso','TX','79902','567890123');
INSERT INTO patient VALUES ('648392015','Pavorotti, Luciano','99 Aria Ave.','Venice Beach','CA','22110','456789012');
INSERT INTO patient VALUES ('567483920','Norman, Jessie','7720 Mozart Lane','Albuquerque','NM','44322','567890123');



INSERT INTO illness VALUES ('OBA1234567','Broken Left Arm',159.99);
INSERT INTO illness VALUES ('OBA2345678','Broken Right Arm',169.99);
INSERT INTO illness VALUES ('OBH3456789','Broken Finger',279.99);
INSERT INTO illness VALUES ('OBL1234567','Broken Left Leg',249.99);
INSERT INTO illness VALUES ('OBL2345678','Broken Right Leg',259.99);
INSERT INTO illness VALUES ('OBL3456789','Broken Right Leg',99.99);
INSERT INTO illness VALUES ('OBH4567890','Bruised Ego',1029.99);
INSERT INTO illness VALUES ('OBH5678901','Broken Heart',2076.99);
INSERT INTO illness VALUES ('OPT9876543','Bad Eyesight',429.99);
INSERT INTO illness VALUES ('OPT8765432','Really Bad Eyesight',1229.99);
INSERT INTO illness VALUES ('OPT7654321','Almost Blind',1899.99);
INSERT INTO illness VALUES ('OPT6543210','Blind as a Bat',4236.06);
INSERT INTO illness VALUES ('SDO1234567','Hypochandria',5089.98);
INSERT INTO illness VALUES ('SDO9654321','Simple Obnoxiousness',9678.78);
INSERT INTO illness VALUES ('SDO7654321','Neurosis',469.01);
INSERT INTO illness VALUES ('SDO6543210','Psychosis',769.02);
INSERT INTO illness VALUES ('SDO5432109','Schizophrenia',1522.03);
INSERT INTO illness VALUES ('SDO4321987','Bad Manners',423.26);
INSERT INTO illness VALUES ('SDO3219876','Bad Breath',1009.23);
INSERT INTO illness VALUES ('IMH0011223','Heartlessness',1.99);
INSERT INTO illness VALUES ('IMH1122334','Mild Heart Attack',900.57);
INSERT INTO illness VALUES ('IMH2233445','Severe Heart Attack',700.87);
INSERT INTO illness VALUES ('IMH3344556','Ouch, That Hurts',378.16,4);
INSERT INTO illness VALUES ('IMH4455667','The Big One',1200.99);
INSERT INTO illness VALUES ('IMH5566778','Severe Death',45171.34);
INSERT INTO illness VALUES ('SKD1098765','Skin Irritation',198.76);
INSERT INTO illness VALUES ('SKD0987654','Dermatitis',298.79);
INSERT INTO illness VALUES ('SKD9876543','Acne',399.80);
INSERT INTO illness VALUES ('SKD8765432','Major Acne',728.34);
INSERT INTO illness VALUES ('SKD7654321','Man, thats bad skin',1024.99);



INSERT INTO prescription VALUES ('A11223344','Aspirin',6.27);
INSERT INTO prescription VALUES ('A22334455','Tylenol',8.99);
INSERT INTO prescription VALUES ('A33445566','Placebo',16.22);
INSERT INTO prescription VALUES ('A12344556','Bedrest',92.79);
INSERT INTO prescription VALUES ('A44556677','Cup of Tea',16.12);
INSERT INTO prescription VALUES ('A55667788','TLC',187.01);
INSERT INTO prescription VALUES ('A77889900','Expensive Stuff',2000.99);
INSERT INTO prescription VALUES ('B12345678','Analgesic',21.39)
INSERT INTO prescription VALUES ('B23456789','Antibiotic',19.87);
INSERT INTO prescription VALUES ('B34567890','Retin-A', 24.96);
INSERT INTO prescription VALUES ('B45678901','Retin-B',31.91);
INSERT INTO prescription VALUES ('B56789012','Anti-Inflam.',6.23);
INSERT INTO prescription VALUES ('B67890123','Anti-Establish',9.89);
INSERT INTO prescription VALUES ('C99887766','Maalox',2.44);
INSERT INTO prescription VALUES ('C88776655','Fairy dust,12.08);
INSERT INTO prescription VALUES ('C77665544','Nitro Glycerin',8.14);
INSERT INTO prescription VALUES ('C66554433','Useless Stuff',2.34);
INSERT INTO prescription VALUES ('D10293847','Percodan',14.76);
INSERT INTO prescription VALUES ('D20394857','Opium',32.76);
INSERT INTO prescription VALUES ('D30495867','Codeine',27.33);
INSERT INTO prescription VALUES ('D40596871','Strong Stuff',39.18);
INSERT INTO prescription VALUES ('D50697812','Bad Stuff',19.99);
INSERT INTO prescription VALUES ('E98767543','Prozac',28.08);
INSERT INTO prescription VALUES ('E87675432','Double Prozac',57.76);
INSERT INTO prescription VALUES ('E76754321','Thorazine',54.77);
INSERT INTO prescription VALUES ('E77665544','Propofol',8.14);
INSERT INTO prescription VALUES ('E66554433','Painful Stuff',12.34);
INSERT INTO prescription VALUES ('E10293847','Oxicoden',15.12);
INSERT INTO prescription VALUES ('ED20394857','Angel Dust',19.99);
INSERT INTO prescription VALUES ('ED30495867','Demerol',22.22);
INSERT INTO prescription VALUES ('F40596871,'Worthless Stuff',9.18);
INSERT INTO prescription VALUES ('FD50697812','Unknown stuff',9.99);
INSERT INTO prescription VALUES ('FE98767543','Unwanted Stuff',8.08);
INSERT INTO prescription VALUES ('FE87675432','Sugary Stuff',7.76);
INSERT INTO prescription VALUES ('FE76754321','Zanex',24.77);


   INSERT INTO treatment VALUES ('443322110','OPT7654321','A33445566',2,'2012-5-29');
   INSERT INTO treatment VALUES ('776655443','SDO1234567','C66554433',1,'2012-8-14');
   INSERT INTO treatment VALUES ('876543210','OPT9876543','A44556677',2,'2012-8-14');
   INSERT INTO treatment VALUES ('765432109','SDO4321987','A33445566',1,'2012-8-28');
   INSERT INTO treatment VALUES ('654321098','OBH3456789','A11223344',2,'2012-8-28');
   INSERT INTO treatment VALUES ('998877665','SDO1234567','A11223344',4,'2012-8-29');
   INSERT INTO treatment VALUES ('998877665','SDO1234567','A33445566',5,'2012-9-1');
   INSERT INTO treatment VALUES ('998877665','SDO1234567','A77889900',2,'2012-9-12');
   INSERT INTO treatment VALUES ('998877665','SDO1234567','A55667788',3,'2012-9-13');
   INSERT INTO treatment VALUES ('432109876','OBH4567890','A12344556',9,'2012-9-20');
   INSERT INTO treatment VALUES ('765432109','SDO1234567','A77889900',5,'2012-9-29');
   INSERT INTO treatment VALUES ('765432109','SDO7654321','E98767543',2,'2012-9-30');
   INSERT INTO treatment VALUES ('776655443','SDO1234567','A12344556',3,'2012-10-2');
   INSERT INTO treatment VALUES ('776655443','SDO1234567','A11223344',5,'2012-10-5');
   INSERT INTO treatment VALUES ('776655443','SDO1234567','A77889900',4,'2012-10-10');
   INSERT INTO treatment VALUES ('665544332','SDO4321987','E66554433',7,'2012-10-11');
   INSERT INTO treatment VALUES ('665544332','IMH3344557','FE76754321',1,'2012-9-10');
   INSERT INTO treatment VALUES ('987654321','OBH4567890','E98767543',2,'2012-9-10');
   INSERT INTO treatment VALUES ('109876543','OBL3456789','A12344556',1,'2012-9-20');
   INSERT INTO treatment VALUES ('109876543','OBL3456789','A22334455',3,'2012-9-21');
   INSERT INTO treatment VALUES ('332211009','SDO7654321','A55667788',2,'2012-9-20');
   INSERT INTO treatment VALUES ('776655443','SDO7654321','E98767543',1,'2012-9-27');
   INSERT INTO treatment VALUES ('554433221','OBA1234567','A11223344',4,'2012-10-01');
   INSERT INTO treatment VALUES ('554433221','OBA1234567','A12344556',2,'2012-10-01');
   INSERT INTO treatment VALUES ('554433221','OBA1234567','A44556677',10,'2012-10-01');
   INSERT INTO treatment VALUES ('665544332','OBA1234567','A55667788',3,'2012-10-01');
   INSERT INTO treatment VALUES ('564738291','OBA1234567','A77889900',3,'2012-10-01');
   INSERT INTO treatment VALUES ('332211009','OBA2345678','A12344556',1,'2012-10-07');
   INSERT INTO treatment VALUES ('332211009','OBH3456789','ED20394857',5,'2012-10-07');
   INSERT INTO treatment VALUES ('009988776','OBA2345678','B12345678',4,'2012-10-09');
   INSERT INTO treatment VALUES ('765432109','SDO7654321','E87675432',2,'2012-10-10');
   INSERT INTO treatment VALUES ('543210987','OPT8765432','A44556677',1,'2012-10-10');
   INSERT INTO treatment VALUES ('321098765','IMH1122334','B23456789',5,'2012-10-11');
   INSERT INTO treatment VALUES ('210987654','SKD1098765','B34567890',7,'2012-10-11');
   INSERT INTO treatment VALUES ('009988776','OBA2345678','B56789012',1,'2012-10-15');
   INSERT INTO treatment VALUES ('009988776','OBA2345678','B67890123',4,'2012-10-15');
   INSERT INTO treatment VALUES ('210987654','SKD1098765','B34567890',2,'2012-10-18');
   INSERT INTO treatment VALUES ('210987654','SKD1098765','B45678901',7,'2012-10-25');
   INSERT INTO treatment VALUES ('098765432','OPT8765432','D10293847',3,'2012-10-26');
   INSERT INTO treatment VALUES ('654321098','OBH3456789','A11223344',2,'2012-11-02');
   INSERT INTO treatment VALUES ('432109876','OBH4567890','A11223344',5,'2012-11-03');
   INSERT INTO treatment VALUES ('321098765','IMH1122334','B23456789',4,'2012-11-04');
   INSERT INTO treatment VALUES ('009988776','OBA2345678','B56789012',1,'2012-11-07');
   INSERT INTO treatment VALUES ('102938475','OPT9876543','A11223344',3,'2012-11-10');
   INSERT INTO treatment VALUES ('102938475','OPT9876543','A12344556',2,'2012-11-10');
   INSERT INTO treatment VALUES ('102938475','OPT9876543','A77889900',6,'2012-11-10');
   INSERT INTO treatment VALUES ('998877665','SDO1234567','A55667788',6,'2012-11-12');
   INSERT INTO treatment VALUES ('998877665','SDO1234567','D20394857',3,'2012-11-12');
   INSERT INTO treatment VALUES ('998877665','SDO1234567','E98767543',1,'2012-11-12');
   INSERT INTO treatment VALUES ('654321098','OBH3456789','A55667788',7,'2012-11-16');
   INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900',2,'2012-11-23');
   INSERT INTO treatment VALUES ('432109876','SDO3219876','A11223344',4,'2012-11-23');
   INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900',3,'2012-12-23');
   INSERT INTO treatment VALUES ('887766554','SDO3219876','A77889900',2,'2012-12-03');
   INSERT INTO treatment VALUES ('887766554','SDO3219876','A44556677',1,'2012-12-03');
   INSERT INTO treatment VALUES ('887766554','SDO3219876','D30495867',5,'2012-12-03');
   INSERT INTO treatment VALUES ('765432109','SDO7654321','A77889900',6,'2012-12-05');
   INSERT INTO treatment VALUES ('765432109','SDO7654321','E98767543',3,'2012-12-05');
   INSERT INTO treatment VALUES ('765432109','SDO6543210','E76754321',2,'2012-12-07');
   INSERT INTO treatment VALUES ('210987654','SKD1098765','B67890123',2,'2012-12-07');
   INSERT INTO treatment VALUES ('987654321','OBH4567890','E87675432',5,'2012-12-08');
   INSERT INTO treatment VALUES ('321098765','IMH2233445','D30495867',3,'2012-12-08');
   INSERT INTO treatment VALUES ('321098765','IMH2233445','D50697812',4,'2012-12-09');
   INSERT INTO treatment VALUES ('987654321','OBH4567890','E76754321',2,'2012-12-12');
   INSERT INTO treatment VALUES ('098765432','OPT8765432','D10293847',4,'2012-12-14');
   INSERT INTO treatment VALUES ('332211009','OBH3456789','D30495867',4,'2012-12-17');
   INSERT INTO treatment VALUES ('554433221','OBA1234567','A77889900',2,'2012-12-22');
   INSERT INTO treatment VALUES ('554433221','OBA1234567','D30495867',3,'2012-12-22');
   INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900',2,'2013-1-02');
   INSERT INTO treatment VALUES ('876543210','OPT7654321','A77889900',5,'2013-1-02');
   INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900',1,'2013-1-03');
   INSERT INTO treatment VALUES ('543210987','OPT8765432','A44556677',4,'2013-1-03');
   INSERT INTO treatment VALUES ('109876543','OBL3456789','D30495867',3,'2013-1-04');
   INSERT INTO treatment VALUES ('543210987','OPT8765432','A44556677',3,'2013-1-05');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','A44556677',1,'2013-1-10');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','A12344556',3,'2013-1-10');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','B56789012',1,'2013-1-10');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','B23456789',2,'2013-1-10');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900',2,'2013-1-10');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867',4,'2013-1-10');
   INSERT INTO treatment VALUES ('998877665','SDO1234567','E98767543',3,'2013-1-18');
   INSERT INTO treatment VALUES ('998877665','SDO1234567','E76754321',2,'2013-1-18');
   INSERT INTO treatment VALUES ('887766554','SDO3219876','D30495867',2,'2013-1-23');
   INSERT INTO treatment VALUES ('765432109','SDO6543210','E76754321',1,'2013-1-24');
   INSERT INTO treatment VALUES ('110090887','IMH1122334','C88776655',3,'2013-1-25');
   INSERT INTO treatment VALUES ('009988776','SDO3219876','D10293847',4,'2013-2-01');
   INSERT INTO treatment VALUES ('009988776','SDO3219876','A77889900',1,'2013-2-01');
   INSERT INTO treatment VALUES ('765432109','SDO6543210','D30495867',2,'2013-2-07');
   INSERT INTO treatment VALUES ('987654321','OBH4567890','D30495867',2,'2013-2-08');
   INSERT INTO treatment VALUES ('321098765','IMH2233445','D50697812',1,'2013-2-09');
   INSERT INTO treatment VALUES ('102938476','SKD1098765','D30495867',1,'2013-2-09');
   INSERT INTO treatment VALUES ('098765432','OPT8765432','D10293847',3,'2013-2-14');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900',2,'2013-2-15');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867',1,'2013-2-15');
   INSERT INTO treatment VALUES ('221100998','SKD1098765','A33445566',2,'2013-2-17');
   INSERT INTO treatment VALUES ('009988776','SDO3219876','D50697812',3,'2013-2-20');
   INSERT INTO treatment VALUES ('102938475','OPT8765432','A77889900',1,'2013-2-22');
   INSERT INTO treatment VALUES ('394857601','SDO7654321','A11223344',2,'2013-2-25');
   INSERT INTO treatment VALUES ('758493026','SKD1098765','C66554433',2,'2013-2-26');
   INSERT INTO treatment VALUES ('221100998','SKD9876543','A11223344',3,'2013-3-05');
   INSERT INTO treatment VALUES ('221100998','SKD9876543','A55667788',1,'2013-3-05');
   INSERT INTO treatment VALUES ('110090887','IMH1122334','C77665544',4,'2013-3-12');
   INSERT INTO treatment VALUES ('110090887','IMH1122334','B56789012',2,'2013-3-12');
   INSERT INTO treatment VALUES ('110090887','IMH1122334','C66554433',2,'2013-3-12');
   INSERT INTO treatment VALUES ('758493026','SKD1098765','C66554433',3,'2013-3-15');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900',1,'2013-3-17');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867',1,'2013-3-17');
   INSERT INTO treatment VALUES ('987654321','OBH5678901','D30495867',2,'2013-3-22');
   INSERT INTO treatment VALUES ('210987654','SKD1098765','D30495867',3,'2013-3-23');
   INSERT INTO treatment VALUES ('758493026','SKD0987654','B34567890',2,'2013-3-26');
   INSERT INTO treatment VALUES ('758493026','SKD0987654','B56789012',4,'2013-3-26');
   INSERT INTO treatment VALUES ('394857601','SDO7654321','A11223344',5,'2013-3-27');
   INSERT INTO treatment VALUES ('394857601','SDO7654321','E98767543',3,'2013-3-27');
   INSERT INTO treatment VALUES ('098765432','OPT8765432','D30495867',2,'2013-3-27');
   INSERT INTO treatment VALUES ('102938475','OPT8765432','D30495867',3,'2013-3-29');
   INSERT INTO treatment VALUES ('758493026','SKD0987654','D30495867',2,'2013-4-03');
   INSERT INTO treatment VALUES ('758493026','SKD0987654','B45678901',1,'2013-4-03');
   INSERT INTO treatment VALUES ('110090887','IMH1122334','D30495867',3,'2013-4-07');
   INSERT INTO treatment VALUES ('765432109','SDO6543210','E76754321',6,'2013-4-11');
   INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900',4,'2013-4-12');
   INSERT INTO treatment VALUES ('321098765','IMH2233445','D50697812',4,'2013-4-13');
   INSERT INTO treatment VALUES ('009988776','SDO3219876','A22334455',2,'2013-4-18');
   INSERT INTO treatment VALUES ('009988776','SDO3219876','A77889900',3,'2013-4-18');
   INSERT INTO treatment VALUES ('210987654','SKD1098765','D30495867',3,'2013-4-23');
   INSERT INTO treatment VALUES ('394857601','SDO6543210','E87675432',3,'2013-4-25');
   INSERT INTO treatment VALUES ('998877665','IMH2233445','C77665544',4,'2013-5-01');
   INSERT INTO treatment VALUES ('998877665','IMH5566778','E76754321',4,'2013-5-01');
   INSERT INTO treatment VALUES ('758493026','SKD7654321','D30495867',1,'2013-5-03');
   INSERT INTO treatment VALUES ('102938475','OPT8765432','D30495867',2,'2013-5-05');
   INSERT INTO treatment VALUES ('019283746','SDO9654321','A33445566',1,'2013-5-07');
   INSERT INTO treatment VALUES ('221100998','SKD9876543','B23456789',3,'2013-5-18');
   INSERT INTO treatment VALUES ('221100998','SKD9876543','D30495867',2,'2013-5-18');
   INSERT INTO treatment VALUES ('758493026','SKD7654321','D30495867',3,'2013-5-19');
   INSERT INTO treatment VALUES ('110090887','IMH1122334','D30495867',5,'2013-5-20');
   INSERT INTO treatment VALUES ('394857601','SDO6543210','E87675432',3,'2013-5-25');
   INSERT INTO treatment VALUES ('394857601','SDO6543210','C66554433',2,'2013-5-25');
   INSERT INTO treatment VALUES ('009988776','OPT9876543','B23456789',1,'2013-5-25');
   INSERT INTO treatment VALUES ('019283746','SDO4321987','E98767543',4,'2013-6-01');
   INSERT INTO treatment VALUES ('019283746','SDO4321987','A77889900',2,'2013-6-01');
   INSERT INTO treatment VALUES ('987654321','OBH4567890','D30495867',3,'2013-6-10');
   INSERT INTO treatment VALUES ('987654321','OBH4567890','C66554433',3,'2013-6-10');
   INSERT INTO treatment VALUES ('102938475','OPT8765432','D30495867',6,'2013-6-12');
   INSERT INTO treatment VALUES ('987654321','OBH4567890','C66554433',3,'2013-6-14');
   INSERT INTO treatment VALUES ('758493026','SKD7654321','D30495867',2,'2013-6-16');
   INSERT INTO treatment VALUES ('554433221','OBA1234567','D30495867',2,'2013-6-22');
   INSERT INTO treatment VALUES ('221100998','SKD8765432','D30495867',4,'2013-6-24');
   INSERT INTO treatment VALUES ('394857601','SDO5432109','E76754321',3,'2013-6-25');
   INSERT INTO treatment VALUES ('847560192','OBL3456789','B56789012',2,'2013-6-28');
   INSERT INTO treatment VALUES ('847560192','OBL3456789','D30495867',6,'2013-6-28');
   INSERT INTO treatment VALUES ('009988776','OPT9876543','B23456789',3,'2013-7-04');
   INSERT INTO treatment VALUES ('009988776','OPT9876543','C66554433',4,'2013-7-04');
   INSERT INTO treatment VALUES ('102938475','OPT6543210','D30495867',2,'2013-7-09');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900',6,'2013-7-10');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867',3,'2013-7-10');
   INSERT INTO treatment VALUES ('654321098','OBH3456789','A77889900',4,'2013-7-12');
   INSERT INTO treatment VALUES ('648392015','SDO7654321','A33445566',1,'2013-7-18');
   INSERT INTO treatment VALUES ('876543210','SDO4321987','D40596871',4,'2013-7-21');
   INSERT INTO treatment VALUES ('394857601','SDO5432109','E76754321',5,'2013-7-25');
   INSERT INTO treatment VALUES ('847560192','OBL3456789','D30495867',3,'2013-7-28');
   INSERT INTO treatment VALUES ('019283746','SDO4321987','E87675432',3,'2013-8-01');
   INSERT INTO treatment VALUES ('019283746','SDO4321987','A77889900',2,'2013-8-01');
   INSERT INTO treatment VALUES ('102938475','OPT6543210','D30495867',4,'2013-8-08');
   INSERT INTO treatment VALUES ('648392015','SDO7654321','A11223344',2,'2013-8-10');
   INSERT INTO treatment VALUES ('648392015','SDO7654321','A77889900',2,'2013-8-10');
   INSERT INTO treatment VALUES ('543210987','OPT7654321','D30495867',3,'2013-8-11');
   INSERT INTO treatment VALUES ('221100998','SKD7654321','D30495867',4,'2013-8-15');
   INSERT INTO treatment VALUES ('394857601','SDO5432109','E76754321',3,'2013-8-25');
   INSERT INTO treatment VALUES ('847560192','OBL3456789','D30495867',1,'2013-8-26');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','A77889900',2,'2013-8-28');
   INSERT INTO treatment VALUES ('564738291','OBL1234567','D30495867',3,'2013-8-28');
   INSERT INTO treatment VALUES ('019283746','SDO4321987','E87675432',4,'2013-9-01');
   INSERT INTO treatment VALUES ('765432109','SDO7654321','E87675432',3,'2013-9-08');
   INSERT INTO treatment VALUES ('648392015','SDO7654321','E98767543',2,'2013-9-10');
   INSERT INTO treatment VALUES ('567483920','SKD8765432','B34567890',2,'2013-9-12');
   INSERT INTO treatment VALUES ('567483920','SKD8765432','B45678901',4,'2013-9-12');
   INSERT INTO treatment VALUES ('567483920','SKD8765432','B12345678',2,'2013-9-12');
   INSERT INTO treatment VALUES ('567483920','SKD8765432','B67890123',3,'2013-9-12');
   INSERT INTO treatment VALUES ('567483920','SKD8765432','B23456789',1,'2013-9-12');
   INSERT INTO treatment VALUES ('019283746','SKD8765432','D40596871',4,'2013-9-14');
   INSERT INTO treatment VALUES ('102938475','OPT6543210','D30495867',2,'2013-9-15');
   INSERT INTO treatment VALUES ('567483920','IMH5566778','ED30495867',4,'2013-9-18');
   INSERT INTO treatment VALUES ('293847560','SKD0987654','B34567890',3,'2013-9-20');
   INSERT INTO treatment VALUES ('293847560','SKD0987654','C66554433',5,'2013-9-20');
   INSERT INTO treatment VALUES ('394857601','SDO5432109','E76754321',2,'2013-9-25');
   INSERT INTO treatment VALUES ('987654321','OBH5678901','C66554433',3,'2013-9-28');
   INSERT INTO treatment VALUES ('876543210','SDO4321987','E76754321',2,'2013-10-05');
   INSERT INTO treatment VALUES ('648392015','SDO7654321','E76754321',3,'2013-10-06');
   INSERT INTO treatment VALUES ('432109876','SKD1098765','D10293847',2,'2013-10-08');
   INSERT INTO treatment VALUES ('321098765','IMH2233445','D50697812',3,'2013-10-10');