API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 21st, 2019
133
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 54.87 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('1', 'John', 'Smith', 'MALE', '01/01/1990', '5555555555', '123 Main St', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  2. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('2', 'Kenneth', 'Parscale', 'MALE', '02/01/1991', '8776433906', '7902 Porta Av.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  3. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS) VALUES ('3', 'John', 'Goodman', 'MALE', '03/01/1992', '6787796798', '7076 Posuere, St', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  4. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('4', 'David', 'Davidson', 'MALE', '04/01/1993', '9245816615', '2985 Felis. Avenue', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  5. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('5', 'Katelyn', 'Smith', 'FEMALE', '05/01/1994', '8172472199', '6415 Mattis Rd', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  6. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('6', 'Lauren', 'Hart', 'FEMALE', '06/01/1995', '8768347257', '123 Main St', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  7. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('7', 'Brian', 'Brianson', 'MALE', '07/01/1996', '9231902541', '6640 Tellus Avenue', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  8. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('8', 'Jamie', 'Jamieson', 'MALE', '08/01/1997', '2319629517', '975 Orci. St.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  9. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('9', 'Nick', 'Nickieson', 'MALE', '09/01/1996', '8662497146', '480 Tortor Rd.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  10. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('10', 'Elliot', 'Moose', 'MALE', '10/01/1995', '7848093165', '22 Falcon Rd.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  11. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('11', 'Brianna', 'Moose', 'FEMALE', '11/01/1994', '7410462290', '11 Woodwine Rd.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  12. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('12', 'Julian', 'Lahey', 'MALE', '12/01/1993', '5617790841', '2191 Nunc Ave', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  13. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('13', 'Ricky', 'Lahey', 'MALE', '01/02/1992', '7734662258', '3952 Egestas Rd', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  14. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('14', 'Bubbles', 'Bubbleson', 'MALE', '021/03/1991', '9433162638', '6223 Magna Rd.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  15. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('15', 'Eugene', 'Smithers', 'MALE', '04/01/1989', '7913239039', '123 Skyline Dr.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  16. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('16', 'Marge', 'Simspon', 'FEMALE', '05/12/1988', '7364528343', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  17. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('17', 'Bart', 'Simspon', 'MALE', '04/12/1980', '7364528343', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  18. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('18', 'Homer', 'Simspon', 'MALE', '03/11/1980', '8821725673', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  19. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('19', 'Maggie', 'Simspon', 'FEMALE', '02/12/1981', '3756681985', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  20. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('20', 'Itchy', 'Simspon', 'MALE', '07/08/1982', '3906613121', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  21. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('21', 'Scratchy', 'Simspon', 'MALE', '08/09/1983', '7153600202', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'Walgreens', '22 Main St');
  22. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('22', 'Poochy', 'Simspon', 'MALE', '10/01/1984', '3775935479', '1002 6th Av.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  23. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('23', 'Magnus', 'Pompey', 'MALE', '02/01/1985', '4732581091', '7706 Bridgeton Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  24. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('24', 'Biggus', 'Diccus', 'MALE', '03/01/1986', '4538628118', '676 Randall Mill Dr.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  25. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('25', 'Julius', 'Caesar', 'MALE', '10/01/1987', '6530531105', '8 Lyme Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  26. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('26', 'Monty', 'Python', 'MALE', '09/01/1987', '3841041135', '3 Howard Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  27. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('27', 'Elliot', 'Broidy', 'MALE', '08/01/1988', '7439241138', '386 Lake Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  28. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('28', 'Please', 'Help', 'MALE', '07/01/1970', '7930040634', '472 County Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  29. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('29', 'Falco', 'Lombardi', 'MALE', '06/01/1971', '1666492994', '8611 Arnold St.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  30. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('30', 'TJ', 'Yoshi', 'MALE', '051/01/1971', '9016640028', '480 Tortor Rd.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  31. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('31', 'Zelda', 'Link', 'FEMALE', '04/01/1972', '3227391748', '751 High St.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  32. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('32', 'Bowser', 'Koopa', 'MALE', '03/01/1973', '7301425292', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  33. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('33', 'Roy', 'Koopa', 'MALE', '02/01/1973', '7552775333', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  34. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('34', 'Iggy', 'Koopa', 'MALE', '01/01/1990', '2407976101', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  35. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('35', 'Lemmy', 'Koopa', 'MALE', '12/01/1990', '9671929720', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  36. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('36', 'Ludwig', 'Koopa', 'MALE', '11/01/1990', '5614671084', '8125 Shub Farm Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  37. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('37', 'Mario', 'Luigi', 'MALE', '11/01/1982', '1594854682', '410 Blue Spring Court', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  38. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('38', 'Gannondorf', 'Zelda', 'MALE', '10/01/1981', '3501023577', '480 Tortor Rd.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  39. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('39', 'Palutena', 'Pit', 'FEMALE', '09/01/1980', '8764799664', '929 Ketch Harbour St.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  40. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('40', 'Ken', 'Masters', 'MALE', '08/01/1979', '4437033597', '859 Windfall Street', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  41. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('41', 'Phoenix', 'Wright', 'MALE', '07/01/1978', '5361074114', '855 University Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  42. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('42', 'Maya', 'Masters', 'MALE', '06/01/19968', '4789360248', '9659 Circle Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  43. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('43', 'Scar', 'Toph', 'MALE', '05/01/1967', '9329835955', '7559 Peninsula Lane', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  44. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('44', 'Jason', 'Zimmerman', 'MALE', '04/01/1966', '8129149333', '542 Talbot Court', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  45. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('45', 'Hatsune', 'Miku', 'FEMALE', '03/01/1965', '0803351285', '38 Redwood Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  46. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('46', 'Ayanami', 'Rei', 'FEMALE', '02/01/1964', '5691633391', '13 N. Chestnut Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  47. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('47', 'Hakurei', 'Reimu', 'FEMALE', '01/01/1963', '1367586031', '9697 Elizabeth Ave.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  48. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('48', 'Remilia', 'Scarlet', 'FEMALE', '12/01/1962', '1156099419', '659 Thatcher St.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  49. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('49', 'Flandre', 'Scarlet', 'FEMALE', '11/01/1961', '2236675817', '9688 Westminster Street ', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  50. INSERT INTO "PATIENT" (PATIENT_ID, FIRST_NAME, LAST_NAME, SEX, DOB, PHONE_NUMBER, ADDRESS, CITY, STATE, ZIP, PREFERRED_PHARMACY, PREFERRED_PHARMACY_ADDRESS ) VALUES ('50', 'Alice', 'Margatroid', 'FEMALE', '04/01/1960', '7307348370', '8627 Depot Dr.', 'Philadelphia', 'PA', '19104', 'CVS', '22 CVS St');
  51. INSERT INTO "DOCTOR" (DOCTOR_ID, FIRST_NAME, LAST_NAME) VALUES ('1', 'Jeff ', 'Pratee');
  52. INSERT INTO "DOCTOR" (DOCTOR_ID, FIRST_NAME, LAST_NAME) VALUES ('2', 'Brett ', 'Pratee');
  53. INSERT INTO "DOCTOR" (DOCTOR_ID, FIRST_NAME, LAST_NAME) VALUES ('3', 'Brian ', 'Pratee');
  54. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('1', '1', '1', 'Exam and glasses', '01/01/2019');
  55. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('2', '2', '2', 'Exam and glasses', '01/01/2019');
  56. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('3', '3', '3', 'Styes', '01/01/2019');
  57. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('4', '1', '4', 'Pink eye', '01/01/2019');
  58. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('5', '2', '5', 'Exam and contacts', '01/02/2019');
  59. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('6', '1', '6', 'Exam and glasses', '01/02/2019');
  60. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('7', '1', '7', 'Exam and glasses', '01/02/2019');
  61. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('8', '1', '8', 'Exam', '01/02/2019');
  62. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('9', '2', '9', 'Styes', '01/03/2019');
  63. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('10', '1', '10', 'Exam', '01/03/2019');
  64. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('11', '1', '1', 'Exam and glasses', '01/03/2019');
  65. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('12', '3', '11', 'Exam and glasses', '01/03/2019');
  66. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('13', '1', '12', 'Exam and glasses', '01/04/2019');
  67. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('14', '2', '13', 'Pink eye', '01/06/2019');
  68. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('15', '1', '14', 'Pink eye', '01/06/2019');
  69. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('16', '1', '15', 'Exam and contacts', '01/07/2019');
  70. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('17', '3', '16', 'Exam and contacts', '01/07/2019');
  71. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('18', '2', '17', 'Exam and contacts', '01/07/2019');
  72. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('19', '1', '18', 'Exam and glasses', '01/08/2019');
  73. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('20', '1', '19', 'Exam', '01/08/2019');
  74. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('21', '1', '20', 'Exam', '01/9/2019');
  75. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('22', '2', '2', 'Follow up', '01/09/2019');
  76. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('23', '1', '21', 'Exam and glasses', '01/09/2019');
  77. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('24', '1', '22', 'Exam and glasses', '01/10/2019');
  78. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('25', '1', '23', 'Pink eye', '01/10/2019');
  79. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('26', '1', '24', 'Exam and glasses', '01/11/2019');
  80. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('27', '2', '25', 'Exam and contacts', '01/11/2019');
  81. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('28', '1', '26', 'Styes', '01/11/2019');
  82. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('29', '1', '27', 'Exam and contacts', '01/13/2019');
  83. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('30', '1', '28', 'Exam', '01/14/2019');
  84. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('31', '3', '29', 'Pink eye', '01/14/2019');
  85. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('32', '2', '30', 'Pink eye', '01/14/2019');
  86. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('33', '1', '3', 'Follow up', '01/15/2019');
  87. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('34', '1', '31', 'Exam and contacts', '01/15/2019');
  88. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('35', '3', '32', 'Exam and contacts', '01/15/2019');
  89. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('36', '1', '33', 'Exam and glasses', '01/15/2019');
  90. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('37', '1', '34', 'Exam and glasses', '01/15/2019');
  91. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('38', '2', '35', 'Exam and glasses', '01/16/2019');
  92. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('39', '1', '36', 'Exam and glasses', '01/16/2019');
  93. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('40', '1', '4', 'Follow up', '01/17/2019');
  94. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('41', '2', '37', 'Exam', '01/17/2019');
  95. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('42', '2', '38', 'Styes', '01/17/2019');
  96. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('43', '1', '39', 'Pink eye', '01/17/2019');
  97. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('44', '2', '40', 'Styes', '01/18/2019');
  98. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('45', '1', '5', 'Follow up', '01/18/2019');
  99. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('46', '1', '41', 'Exam and glasses', '01/18/2019');
  100. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('47', '3', '42', 'Exam and glasses', '01/18/2019');
  101. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('48', '1', '43', 'Exam and glasses', '01/18/2019');
  102. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('49', '1', '44', 'Exam and glasses', '01/20/2019');
  103. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('50', '1', '6', 'Follow up', '01/20/2019');
  104. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('51', '2', '45', 'Exam and glasses', '01/20/2019');
  105. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('52', '1', '46', 'Exam and glasses', '01/20/2019');
  106. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('53', '3', '47', 'Exam and glasses', '01/20/2019');
  107. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('54', '2', '48', 'Exam and glasses', '01/21/2019');
  108. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('55', '1', '7', 'Follow up', '01/21/2019');
  109. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('56', '2', '49', 'Exam and glasses', '01/21/2019');
  110. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('57', '1', '50', 'Exam and glasses', '01/22/2019');
  111. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('58', '2', '8', 'Follow up', '01/22/2019');
  112. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('59', '1', '21', 'Pink eye', '01/22/2019');
  113. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('60', '2', '22', 'Follow up', '01/22/2019');
  114. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('61', '1', '26', 'Exam and glasses', '01/22/2019');
  115. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('62', '3', '13', 'Exam and contacts', '01/23/2019');
  116. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('63', '1', '27', 'Exam and contacts', '01/23/2019');
  117. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('64', '1', '35', 'Styes', '01/23/2019');
  118. INSERT INTO "APPOINTMENT" (APPOINTMENT_ID, DOCTOR_ID, PATIENT_ID, REASON, APPOINTMENT_DATE) VALUES ('65', '1', '12', 'Exam and contacts', '01/23/2019');
  119. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('1', '1', '3', '01/01/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes daily');
  120. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('2', '1', '9', '01/03/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  121. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('3', '1', '26', '01/11/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  122. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('4', '1', '38', '01/17/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  123. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('5', '1', '40', '01/18/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  124. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('6', '1', '35', '01/23/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  125. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('7', '1', '29', '01/14/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes daily');
  126. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('8', '1', '30', '01/14/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  127. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('9', '1', '39', '01/17/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  128. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('10', '1', '21', '01/22/2019', 'Sulfacetamide Sodium 0.5%', 'Two drops both eyes');
  129. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('11', '1', '4', '01/01/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  130. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('12', '1', '23', '01/10/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  131. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('13', '1', '13', '01/06/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  132. INSERT INTO "PRESCRIPTION" (RX_ID, DOCTOR_ID, PATIENT_ID, RX_DATE, DRUG, DOSAGE) VALUES ('14', '1', '14', '01/06/2019', 'Moxeza 0.25%', 'Two drops both eyes');
  133.  
  134. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('1', 'Horizon', '365479510', '208981', 'PPO', '5');
  135. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('2', 'Aetna', '703558595', '775337', 'PPO', '10');
  136. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('3', 'UnitedHealth', '105531242', '221028', 'PPO', '15');
  137. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('4', 'Wellpoint', '837353127', '225905', 'PPO', '20');
  138. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('5', 'Humana', '418953014', '160854', 'PPO', '5');
  139. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('6', 'Cigna', '956401511', '706116', 'PPO', '10');
  140. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('7', 'Highmark', '158540167', '441169', 'PPO', '15');
  141. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('8', 'Horizon', '401837495', '506288', 'PPO', '20');
  142. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('9', 'Horizon', '968496026', '738471', 'PPO', '25');
  143. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('10', 'Aetna', '344427508', '442847', 'PPO', '30');
  144. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('11', 'Cigna', '512077006', '850070', 'PPO', '5');
  145. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('12', 'Humana', '904470553', '224729', 'PPO', '10');
  146. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('13', 'Highmark', '544551519', '901032', 'PPO', '15');
  147. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('14', 'UnitedHealth', '135956812', '514547', 'PPO', '20');
  148. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('15', 'UnitedHealth', '567025086', '205491', 'PPO', '25');
  149. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('16', 'Horizon', '152633703', '595839', 'PPO', '30');
  150. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('17', 'Horizon', '366721520', '851247', 'PPO', '5');
  151. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('18', 'UnitedHealth', '318365256', '529992', 'PPO', '10');
  152. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('19', 'UnitedHealth', '585963750', '600755', 'PPO', '15');
  153. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('20', 'Aetna', '832377105', '404144', 'PPO', '25');
  154. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('21', 'Horizon', '593746868', '265489', 'PPO', '30');
  155. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('22', 'Aetna', '318365256', '241894', 'PPO', '35');
  156. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('23', 'Aetna' '604584439', '672387', 'PPO', '40');
  157. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('24', 'Aetna', '567025086', '211244', 'PPO', '5');
  158. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('25', 'Humana', '016515710', '005811', 'PPO', '10');
  159. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('26', 'Humana', '613292968', '972479', 'PPO', '15');
  160. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('27', 'Humana', '721073099', '074033', 'PPO', '20');
  161. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('28', 'Horizon', '666608907', '645118', 'PPO', '25');
  162. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('29', 'Aetna', '056172817', '761152', 'PPO', '30');
  163. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('30', 'Highmark', '560466689', '454562', 'PPO', '35');
  164. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('31', 'Horizon', '283714808', '138172', 'PPO', '40');
  165. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('32', 'Horizon', '608607848', '594904', 'PPO', '5');
  166. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('33', 'Horizon', '714883203', '045306', 'PPO', '5');
  167. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('34', 'Highmark', '135145899', '539820', 'PPO', '10');
  168. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('35', 'Highmark', '828140452', '500051', 'PPO', '15');
  169. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('36', 'Highmark', '048754237', '910431', 'PPO', '25');
  170. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('37', 'Horizon', '423418545', '709663', 'PPO', '15');
  171. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('38', 'Horizon', '307190508', '904862', 'PPO', '15');
  172. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('39', 'Humana' '380417854', '755546', 'PPO', '25');
  173. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('40', 'Horizon', '166022266', '051370', 'PPO', '30');
  174. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('41', 'Humana', '765477489', '977369', 'PPO', '10');
  175. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('42', 'Horizon', '053109214', '882102', 'PPO', '15');
  176. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('43', 'Aetna', '406786530', '120667', 'PPO', '25');
  177. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('44', 'Aetna', '547443631', '922265', 'PPO', '30');
  178. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('45', 'Horizon', '968715335', '595064', 'PPO', '20');
  179. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('46', 'Horizon', '547443631', '427404', 'PPO', '5');
  180. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('47', 'Horizon', '228863395', '918364', 'PPO', '10');
  181. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('48', 'UnitedHealth', '474025850', '219260', 'PPO', '15');
  182. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('49', 'UnitedHealth', '353046702', '682128', 'PPO', '20');
  183. INSERT INTO "MEDICAL_INSURANCE" (PATIENT_ID, INSURANCE_NAME, MEMBER_ID, GROUP_NUMBER, INSURANCE_TYPE, CO_PAY) VALUES ('50', 'Humana', '004804954', '624231', 'PPO', '25');
  184. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('1', 'Vision Plan America', '365479510', '208981', 'PPO');
  185. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('2', 'Aetna', '703558595', '775337', 'PPO');
  186. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('3', 'UnitedHealth', '105531242', '221028', 'PPO');
  187. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('4', 'Wellpoint', '837353127', '225905', 'PPO');
  188. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('5', 'Humana', '418953014', '160854', 'PPO');
  189. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('6', 'Davis Vision', '956401511', '706116', 'PPO');
  190. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('7', 'Vision Plan America', '158540167', '441169', 'PPO');
  191. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('8', 'Horizon', '401837495', '506288', 'PPO');
  192. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('9', 'Horizon', '968496026', '738471', 'PPO');
  193. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('10', 'Aetna', '344427508', '442847', 'PPO');
  194. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('11', 'Davis Vision', '512077006', '850070', 'PPO');
  195. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('12', 'Humana', '904470553', '224729', 'PPO');
  196. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('13', 'Vision Plan America', '544551519', '901032', 'PPO');
  197. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('14', 'UnitedHealth', '135956812', '514547', 'PPO');
  198. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('15', 'UnitedHealth', '567025086', '205491', 'PPO');
  199. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('16', 'Horizon', '152633703', '595839', 'PPO');
  200. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('17', 'Horizon', '366721520', '851247', 'PPO');
  201. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('18', 'UnitedHealth', '318365256', '529992', 'PPO');
  202. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('19', 'UnitedHealth', '585963750', '600755', 'PPO');
  203. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('20', 'Aetna', '832377105', '404144', 'PPO');
  204. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('21', 'Horizon', '593746868', '265489', 'PPO',);
  205. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('22', 'Aetna', '318365256', '241894', 'PPO');
  206. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('23', 'Aetna', '604584439', '672387', 'PPO');
  207. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('24', 'Aetna', '567025086', '211244', 'PPO');
  208. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('25', 'Humana', '016515710', '005811', 'PPO');
  209. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('26', 'Humana', '613292968', '972479', 'PPO');
  210. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('27', 'Humana', '721073099', '074033', 'PPO');
  211. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('28', 'Horizon', '666608907', '645118', 'PPO');
  212. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('29', 'Aetna', '056172817', '761152', 'PPO');
  213. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('30', 'Vision Plan America', '560466689', '454562', 'PPO');
  214. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('31', 'Horizon', '283714808', '138172', 'PPO');
  215. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('32', 'Horizon', '608607848', '594904', 'PPO');
  216. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('33', 'Horizon', '714883203', '045306', 'PPO');
  217. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('34', 'Vision Plan America', '135145899', '539820', 'PPO');
  218. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('35', 'Vision Plan Americak', '828140452', '500051', 'PPO');
  219. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('36', 'Vision Plan America', '048754237', '910431', 'PPO'
  220. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('37', 'Horizon', '423418545', '709663', 'PPO');
  221. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('38', 'Horizon', '307190508', '904862', 'PPO');
  222. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('39', 'Humana' '380417854', '755546', 'PPO');
  223. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('40', 'Horizon', '166022266', '051370', 'PPO');
  224. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('41', 'Humana', '765477489', '977369', 'PPO');
  225. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('42', 'Horizon', '053109214', '882102', 'PPO');
  226. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('43', 'Aetna', '406786530', '120667', 'PPO');
  227. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('44', 'Aetna', '547443631', '922265', 'PPO');
  228. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('45', 'Horizon', '968715335', '595064', 'PPO');
  229. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('46', 'Horizon', '547443631', '427404', 'PPO');
  230. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('47', 'Horizon', '228863395', '918364', 'PPO');
  231. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('48', 'UnitedHealth', '474025850', '219260', 'PPO');
  232. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('49', 'UnitedHealth', '353046702', '682128', 'PPO');
  233. INSERT INTO "VISION_PLAN" (PATIENT_ID, PLAN_NAME, MEMBER_ID, GROUP_NUMBER, PLAN_TYPE) VALUES ('50', 'Humana', '004804954', '624231', 'PPO');
  234. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('1', '3', '01/01/2019', '9.99');
  235. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('2', '9', '01/03/2019', '9.99');
  236. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('3', '26', '01/11/2019', '9.99');
  237. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('4', '38', '01/17/2019', '12.99');
  238. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('5', '40', '01/18/2019', '12.99');
  239. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('6', '35', '01/23/2019', '12.99');
  240. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('7', '29', '01/14/2019', '12.99');
  241. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('8', '30', '01/14/2019', '9.99');
  242. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('9', '39', '01/17/2019', '9.99');
  243. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('10', '21', '01/22/2019', '9.99');
  244. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('11', '4', '01/01/2019', '9.99');
  245. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('12', '23', '01/10/2019', '9.99');
  246. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('13', '13', '01/06/2019', '9.99');
  247. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('14', '14', '01/06/2019', '9.99');
  248. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('15', '1', '01/06/2019', '9.99');
  249. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('16', '1', '01/01/2019', '290.00');
  250. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('17', '2', '01/01/2019', '280.00');
  251. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('18', '6', '01/02/2019', '270.00');
  252. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('19', '7', '01/02/2019', '300.00');
  253. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('20', '11', '01/03/2019', '300.00');
  254. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('21', '18', '01/08/2019', '300.00');
  255. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('22', '21', '01/09/2019', '300.00');
  256. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('23', '22', '01/10/2019', '300.00');
  257. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('24', '24', '01/11/2019', '290.00');
  258. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('25', '33', '01/15/2019', '290.00');
  259. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('26', '34', '01/15/2019', '290.00');
  260. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('27', '35', '01/16/2019', '290.00');
  261. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('28', '36', '01/16/2019', '290.00');
  262. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('29', '41', '01/18/2019', '290.00');
  263. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('30', '42', '01/18/2019', '280.00');
  264. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('31', '43', '01/18/2019', '280.00');
  265. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('32', '44', '01/20/2019', '280.00');
  266. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('33', '45', '01/20/2019', '280.00');
  267. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('34', '46', '01/20/2019', '280.00');
  268. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('35', '47', '01/20/2019', '280.00');
  269. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('36', '48', '01/21/2019', '280.00');
  270. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('37', '49', '01/21/2019', '280.00');
  271. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('38', '50', '01/22/2019', '280.00');
  272. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('39', '22', '01/09/2019', '26.00');
  273. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('40', '26', '01/11/2019', '26.00');
  274. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('41', '5', '01/02/2019', '27.00');
  275. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('42', '15', '01/07/2019', '28.00');
  276. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('43', '16', '01/07/2019', '29.00');
  277. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('44', '17', '01/07/2019', '27.00');
  278. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('45', '25', '01/11/2019', '30.00');
  279. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('46', '27', '01/13/2019', '31.00');
  280. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('47', '31', '01/15/2019', '30.00');
  281. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('48', '32', '01/15/2019', '31.00');
  282. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('49', '27', '01/13/2019', '31.00');
  283. INSERT INTO "ORDERS" (ORDER_ID, PATIENT_ID, ORDER_DATE, ORDER_TOTAL) VALUES ('50', '12', '01/04/2019', '31.00');
  284. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('1', '1', '3');
  285. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('2', '1', '3');
  286. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('3', '1', '3');
  287. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('4', '1', '4');
  288. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('5', '1', '4');
  289. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('6', '1', '4');
  290. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('7', '1', '4');
  291. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('8', '1', '3');
  292. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('9', '1', '3');
  293. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('11', '1', '3');
  294. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('12', '1', '3');
  295. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('13', '1', '3');
  296. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('14', '1', '3');
  297. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('15', '1', '3');
  298. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('16', '3', '1');
  299. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('17', '4', '1');
  300. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('18', '5', '1');
  301. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('19', '2', '1');
  302. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('20', '2', '1');
  303. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('21', '2', '1');
  304. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('22', '2', '1');
  305. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('23', '2', '1');
  306. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('24', '3', '1');
  307. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('25', '3', '1');
  308. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('26', '3', '1');
  309. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('27', '3', '1');
  310. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('28', '3', '1');
  311. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('29', '3', '1');
  312. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('30', '4', '1');
  313. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('31', '4', '1');
  314. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('32', '4', '1');
  315. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('33', '4', '1');
  316. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('34', '4', '1');
  317. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('35', '4', '1');
  318. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('36', '4', '1');
  319. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('37', '4', '1');
  320. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('38', '4', '1');
  321. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('39', '6', '1');
  322. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('40', '6', '1');
  323. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('41', '7', '1');
  324. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('42', '8', '1');
  325. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('43', '9', '1');
  326. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('44', '7', '1');
  327. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('45', '10', '1');
  328. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('46', '11', '1');
  329. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('47', '10', '1');
  330. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('48', '11', '1');
  331. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('49', '11', '1');
  332. INSERT INTO "ORDER_LINE" (ORDER_ID, PRODUCT_ID, QUANTITY) VALUES ('50', '11', '1');
  333. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE) VALUES ('1', 'Eyelid Scrubs', 'Clean your eyes', '3.33', '1');
  334. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, FRAMES_PRODUCT_ID) VALUES ('2', 'Frames', 'Glasses Frames', '300.00', '2', '1');
  335. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, FRAMES_PRODUCT_ID) VALUES ('3', 'Frames', 'Glasses Frames', '290.00', '2', '2');
  336. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, FRAMES_PRODUCT_ID) VALUES ('4', 'Frames', 'Glasses Frames', '280.00', '2', '3');
  337. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('5', 'Frames', 'Glasses Frames', '270.00', '2', '4');
  338. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('6', 'Contacts', 'Contacts', '26.00', '3', '1');
  339. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('7', 'Contacts', 'Contacts', '27.00', '3', '2');
  340. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('8', 'Contacts', 'Contacts', '28.00', '3', '3');
  341. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('9', 'Contacts', 'Contacts', '29.00', '3', '4');
  342. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('10', 'Contacts', 'Contacts', '30.00', '3', '5');
  343. INSERT INTO "PRODUCT" (PRODUCT_ID, PRODUCT_NAME, PRODUCT_DESCRIPTION, UNIT_PRICE, PRODUCT_TYPE, CONTACTS_PRODUCT_ID) VALUES ('11', 'Contacts', 'Contacts', '31.00', '3', '6');
  344. INSERT INTO "FRAMES" (PRODUCT_ID, BRAND, SIZE, COLOR, MATERIAL) VALUES ('2', 'Ray Ban', 'Regular', 'Grey', 'Matte');
  345. INSERT INTO "FRAMES" (PRODUCT_ID, BRAND, SIZE, COLOR, MATERIAL) VALUES ('3', 'Oakley', 'Regular', 'Black', 'Titanium');
  346. INSERT INTO "FRAMES" (PRODUCT_ID, BRAND, SIZE, COLOR, MATERIAL) VALUES ('4', 'Coach', 'Regular', 'Black', 'Zyl');
  347. INSERT INTO "FRAMES" (PRODUCT_ID, BRAND, SIZE, COLOR, MATERIAL) VALUES ('5', 'Versace', 'Regular', 'Grey', 'Matte');
  348. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('6', 'Acuve', 'Regular', 'Clear');
  349. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('7', 'Dailies', 'Regular', 'Clear');
  350. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('8', 'Softlens', 'Regular', 'Clear);
  351. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('9', 'Air Optix', 'Regular', 'Clear');
  352. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('10', 'Proclear', 'Regular', 'Clear');
  353. INSERT INTO "CONTACTS" (PRODUCT_ID, BRAND, TYPE, COLOR) VALUES ('11', 'Bioinfinity', 'Regular', 'Clear');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!