Skip to content
Snippets Groups Projects

UC14: Reqeust Biosurveillance

Merged adityab3 requested to merge UC14 into master
12 files
+ 669
365
Compare changes
  • Side-by-side
  • Inline
Files
12
INSERT INTO officevisits(ID, visitDate, HCPID, notes, PatientID, HospitalID)
VALUES
(125, '2020-11-18', 9000000000, 'Diagnose Cataracts', 1, '1'),
(126, '2020-11-18', 9000000000, 'Diagnose Cataracts', 2, '1'),
(127, '2020-11-18', 9000000000, 'Diagnose Cataracts', 3, '1'),
(128, '2020-11-18', 9000000000, 'Diagnose Cataracts', 4, '1'),
(129, '2020-11-18', 9000000000, 'Diagnose Cataracts', 21, '1'),
(130, '2020-11-18', 9000000000, 'Diagnose Cataracts', 22, '1'),
(131, '2020-11-18', 9000000000, 'Diagnose Cataracts', 23, '1'),
(132, '2020-11-18', 9000000000, 'Diagnose Cataracts', 24, '1'),
(133, '2020-11-18', 9000000000, 'Diagnose Cataracts', 105, '1'),
(134, '2020-11-18', 9000000000, 'Diagnose Cataracts', 107, '1')
ON DUPLICATE KEY UPDATE id = id;
INSERT INTO ovdiagnosis(ID, VisitID, ICDCode)
VALUES
(125, 125, 26.8),
(126, 126, 26.8),
(127, 127, 26.8),
(128, 128, 26.8),
(129, 129, 26.8),
(130, 130, 26.8),
(131, 131, 26.8),
(132, 132, 26.8),
(133, 133, 26.8),
(134, 134, 26.8)
ON DUPLICATE KEY UPDATE VisitID = VALUES(VisitID), ICDCode = VALUES(ICDCode);
Loading