|
insert into enfermeiro values(md5('pedro'), 'Pedro Braga', '1999-11-25', 'M', 'pedro', md5('pedro123'), true, curdate(), null); |
|
insert into paciente values(md5(concat('Rodolfo', '2000-10-10')), 'Rodolfo', '2000-10-10', 'M', md5('pedro'), '2018-11-01', null); |
|
insert into consulta values(md5(concat(md5('pedro'), md5(concat('Rodolfo', '2000-10-10')), '2018-08-13 12:59:00')), md5('pedro'), md5(concat('Rodolfo', '2000-10-10')), '2018-08-13 12:59:00', 80, 76, 1.77, true, 60, '120/80', 10, 38.5, 100); |
|
insert into consulta values(md5(concat(md5('pedro'), md5(concat('Rodolfo', '2000-10-10')), '2018-10-29 11:37:00')), md5('pedro'), md5(concat('Rodolfo', '2000-10-10')), '2018-10-29 11:37:00', 90, 79, 1.77, false, 80, '130/90', 15, 36.5, 118); |
|
insert into consulta values(md5(concat(md5('pedro'), md5(concat('Rodolfo', '2000-10-10')), '2018-11-20 10:07:00')), md5('pedro'), md5(concat('Rodolfo', '2000-10-10')), '2018-11-20 10:07:00', 100, 89, 1.76, false, 120, '135/92', 12, 36.5, 126); |
|
insert into paciente values(md5(concat('Rodolfa', '2010-08-09')), 'Rodolfa', '2010-08-09', 'F', md5('pedro'), '2017-12-03', null); |
|
insert into consulta values(md5(concat(md5('pedro'), md5(concat('Rodolfa', '2010-08-09')), '2018-08-13 12:59:00')), md5('pedro'), md5(concat('Rodolfa', '2010-08-09')), '2018-08-13 12:59:00', 50, 50, 1.60, true, 63, '120/80', 12, 36.8, 89); |
|
insert into consulta values(md5(concat(md5('pedro'), md5(concat('Rodolfa', '2010-08-09')), '2018-10-29 11:37:00')), md5('pedro'), md5(concat('Rodolfa', '2010-08-09')), '2018-10-29 11:37:00', 48, 48, 1.60, true, 60, '120/80', 10, 36.5, 83); |
|
insert into consulta values(md5(concat(md5('pedro'), md5(concat('Rodolfa', '2010-08-09')), '2018-11-20 10:07:00')), md5('pedro'), md5(concat('Rodolfa', '2010-08-09')), '2018-11-20 10:07:00', 45, 47, 1.58, false, 120, '120/80', 9, 36, 80); |
|
insert into paciente values(md5(concat('Ronald', '2007-07-07')), 'Ronald', '2007-07-07', 'M', md5('pedro'), '2018-10-14', null); |
|
insert into consulta values(md5(concat(md5('pedro'), md5(concat('Ronald', '2007-07-07')), '2018-08-13 12:59:00')), md5('pedro'), md5(concat('Ronald', '2007-07-07')), '2018-08-13 12:59:00', 50, 50, 1.45, true, 100, '120/80', 12, 38.2, 102); |
|
insert into consulta values(md5(concat(md5('pedro'), md5(concat('Ronald', '2007-07-07')), '2018-10-29 11:37:00')), md5('pedro'), md5(concat('Ronald', '2007-07-07')), '2018-10-29 11:37:00', 52, 51, 1.45, true, 90, '120/80', 13, 36.3, 108); |
|
insert into consulta values(md5(concat(md5('pedro'), md5(concat('Ronald', '2007-07-07')), '2018-11-20 10:07:00')), md5('pedro'), md5(concat('Ronald', '2007-07-07')), '2018-11-20 10:07:00', 50, 50, 1.45, true, 80, '110/75', 12, 40.9, 89); |