noharm-insert.sql

--
-- PREPARE A SECOND SCHEMA FOR TESTS
--
CREATE SCHEMA teste;

CREATE TABLE teste."hospital" (
  "fkhospital" smallint UNIQUE PRIMARY KEY NOT NULL,
  "nome" varchar(255) NOT NULL
);

CREATE TABLE teste."memoria" (
  "idmemoria" SERIAL NOT NULL,
  "tipo" varchar(100) NOT NULL,
  "valor" json NOT NULL,
  "update_at" timestamp NOT NULL DEFAULT NOW(),
  "update_by" integer NOT NULL,
  PRIMARY KEY ("idmemoria", "tipo")
);

CREATE TABLE teste."segmento" (
  "idsegmento" SERIAL PRIMARY KEY NOT NULL,
  "nome" varchar(250) NOT NULL,
  "status" smallint DEFAULT NULL,
  "tp_segmento" smallint
);


--
-- TRUNCATE All Tables
--

TRUNCATE TABLE public.usuario RESTART IDENTITY;
TRUNCATE TABLE demo.hospital RESTART IDENTITY;
TRUNCATE TABLE demo.setor RESTART IDENTITY;
TRUNCATE TABLE demo.segmento RESTART IDENTITY;
TRUNCATE TABLE demo.unidademedida RESTART IDENTITY;
TRUNCATE TABLE demo.frequencia RESTART IDENTITY;
TRUNCATE TABLE demo.medicamento RESTART IDENTITY;
TRUNCATE TABLE demo.pessoa RESTART IDENTITY;
TRUNCATE TABLE demo.exame RESTART IDENTITY;
TRUNCATE TABLE demo.prescricao, demo.outlier, demo.prescricaoagg RESTART IDENTITY;
TRUNCATE TABLE demo.motivointervencao, demo.intervencao, demo.presmed, demo.memoria RESTART IDENTITY;

--
-- Insert Support's Tables
--

CREATE EXTENSION IF NOT EXISTS pgcrypto;

INSERT INTO public.schema_config (schema_name, created_at) VALUES
            ('demo', now()), ('teste', now());

INSERT INTO public.usuario (nome,email,senha,schema,config) VALUES 
						('Demonstração','demo',crypt('demo', gen_salt('bf',8)) ,'demo','{"roles":["PRESCRIPTION_ANALYST", "USER_MANAGER", "CONFIG_MANAGER", "suporte"], "features": [ "STAGING_ACCESS"]}'),
						('User Admin','user@admin.com',crypt('useradmin', gen_salt('bf',8)) ,'demo','{"roles":[], "features": [ "STAGING_ACCESS"]}'),
						('Não Admin','noadmin',crypt('noadmin', gen_salt('bf',8)),'demo','{"roles":["PRESCRIPTION_ANALYST", "USER_MANAGER", "CONFIG_MANAGER","staging"], "features": [ "STAGING_ACCESS"]}'),
            ('Organization manager','organizationmanager',crypt('organizationmanager', gen_salt('bf',8)),'demo','{"roles":["VIEWER"], "features": [ "STAGING_ACCESS"]}'),
            ('Invalid User','invaliduser',crypt('invaliduser', gen_salt('bf',8)),'demo','{"roles":["ADMIN"], "features": [ "STAGING_ACCESS"]}'),
            ('Invalid User 2','invaliduser2',crypt('invaliduser2', gen_salt('bf',8)),'demo','{"roles":["VIEWER"], "schemas": [{"name": "demo", "friendlyName": "Hospital Demo"}], "features": [ "STAGING_ACCESS"]}'),
            ('E2E Test','e2e@e2e.com',crypt('e2etest', gen_salt('bf',8)),'demo','{"roles":["PRESCRIPTION_ANALYST", "USER_MANAGER", "CONFIG_MANAGER", "staging"], "features": [ "STAGING_ACCESS"]}');

INSERT INTO public.usuario_autorizacao (idusuario,idsegmento,created_at,created_by) VALUES 
						((select idusuario from public.usuario where email = 'demo'), 1, now(), 0);

INSERT INTO public.usuario_extra (idusuario, config, created_at, created_by) VALUES
            ((select idusuario from public.usuario where email = 'organizationmanager'), '{"roles":["ORGANIZATION_MANAGER"], "schemas": [{"name": "demo", "friendlyName": "Hospital Demo"}, {"name": "teste", "friendlyName": "Hospital Teste"}]}' , now(), 0),
            ((select idusuario from public.usuario where email = 'user@admin.com'), '{"roles":["ADMIN"]}' , now(), 0);

INSERT INTO demo.hospital (fkhospital, nome) VALUES
						(1, 'Hospital Demonstração');

INSERT INTO demo.memoria (tipo, valor, update_by) VALUES
            ('features','["INTERVENTION_V2"]', 0);

INSERT INTO demo.setor (fksetor, nome) VALUES
						(1, 'Setor Adulto 1'),
						(2, 'Setor Adulto 2'),
						(3, 'Setor Adulto 3'),
						(4, 'Setor Pediatrico 1'),
						(5, 'Setor Pediatrico 2'),
						(6, 'Setor Pediatrico 3'),
						(7, 'Setor NeoNatal 1'),
						(8, 'Setor NeoNatal 2'),
						(9, 'Setor NeoNatal 3');

INSERT INTO demo.segmento (nome) VALUES
						('Segmento Adulto');

INSERT INTO demo.segmentosetor (idsegmento, fkhospital, fksetor) VALUES
								(1,1,1),
								(1,1,2),
								(1,1,3);

INSERT INTO demo.unidademedida (fkunidademedida, nome) VALUES
							(1, 'mg'),
							(2, 'mcg'),
							(3, 'mg/ml'),
							(4, 'ml'),
							(5, 'UI'),
							(6, 'Un');

INSERT INTO demo.frequencia (fkfrequencia, nome, frequenciadia) VALUES
							(1, '1x/dia', 1),
							(2, '12h/12h', 2),
							(3, '8h/8h', 3),
							(4, '6h/6h', 4),
							(6, '4h/4h', 6);

INSERT INTO demo.medicamento (fkhospital,fkmedicamento,nome) VALUES 
(1,3,'ANLODIPINO 10 mg CP')
,(1,5,'CETOPROFENO 100 mg SOL INJ IV')
,(1,6,'CLORETO DE POTASSIO 6 % (0,8 mEq/ml) SOL AQ')
,(1,7,'DIAZEPAM 10 mg CP')
,(1,8,'DICLOFENACO 50 mg CP')
,(1,9,'DOXAZOSINA 2 mg CP')
,(1,10,'ENALAPRIL 20 mg CP')
,(1,11,'ENOXAPARINA 60 mg/0,6 ml')
,(1,12,'HIDRALAZINA 50 mg CP')
,(1,13,'LOPERAMIDA 2 mg CP')
,(1,15,'PARACETAMOL 500 mg CP')
,(1,16,'POLIMIXINA B 500.000 UI SOL INJ')
,(1,17,'RISPERIDONA 2 mg CP')
,(1,18,'SULFAMETOXAZOL + TRIMETOPRIMA 800 mg + 160 mg CP')
,(1,19,'TENOFOVIR 300mg + LAMIVUDINA 300mg CP')
,(1,20,'VARFARINA 5 mg CP')
,(1,21,'VITAMINAS DO COMPLEXO B CP')
,(1,22,'MEROPENEM 1 g/100 ml SOL INJ')
,(1,23,'HIOSCINA 20 mg/ml SOL INJ')
,(1,24,'OMEPRAZOL 20mg CP')
,(1,25,'LEVOFLOXACINO 100mcg CP')
,(1,1,'AMPICILINA + SULBACTAM 2 g + 1 g SOL INJ')
,(1,2,'ALOPURINOL 100 mg CP')
,(1,4,'BISACODIL 5 mg CP')
,(1,14,'MORFINA 10 mg/ml SOL ORAL');

INSERT INTO demo.medatributos (idsegmento,fkmedicamento,antimicro,mav,controlados, fkunidademedida, fkunidademedidacusto, custo) VALUES
(1,1,true,true,false,'1', '1', 2.52)
,(1,2,true,true,false,'1', '1', 1.2)
,(1,4,false,false,true, '1', '1', 4.52)
,(1,14,false,true,true,'1', '1', 1.52)
,(1,10,true,true,false,'1', '1', 5.245);

INSERT INTO demo.motivointervencao (nome, substituicao, suspensao, economia_customizada) VALUES
								('Alta antecipada', false, false, true),
                ('Aprazamento', false, false, false),
								('Apresentação', false, false, false),
								('Diluição Padrão', false, false, false),
								('Duplicidade medicamentosa', false, false, false),
								('Frequência SN/Obs', false, false, false),
								('Medicamento não padronizado', false, false, false),
								('Medicamento de uso próprio', false, false, false),
								('Alergia', false, false, false),
								('Aprazamento', false, false, false),
								('Diluição', false, false, false),
								('Dose', false, false, false),
								('Duplicidade Terapêutica', false, false, false),
								('Forma Farmacêutica', false, false, false),
								('Frequência', false, false, false),
								('Incompatibilidade', false, false, false),
								('Indicação Terapêutica', false, false, false),
								('Interação medicamentosa', false, false, false),
								('Orientação Farmacêutica', false, false, false),
								('Medicamento não padronizado - avaliação', false, false, false),
								('Reconciliação medicamentosa', false, false, false),
								('Suspensão da terapia', false, true, false),
                ('Substituição', true, false, false),
								('Tempo de tratamento', false, false, false),
								('Via', false, false, false);

--
-- Insert Prescription's Tables
--

INSERT INTO demo.pessoa (fkpessoa, fkhospital, nratendimento, dtnascimento, sexo, dtinternacao, peso, cor) VALUES
					(1, 1, 1, '2000-10-10', 'M', '2019-08-01', 75, 'B'),
					(2, 1, 2, '2000-10-10', 'F', '2019-08-22', 75, 'N'),
					(3, 1, 3, '1951-04-05', 'M', '2019-08-24', 75, 'B'),
					(4, 1, 4, '1985-03-04', 'M', '2019-08-23', 75, 'N'),
					(5, 1, 5, '1954-02-05', 'F', '2019-08-12', 67, 'B'),
					(6, 1, 6, '1939-02-05', 'M', '2019-08-12', 97, 'P'),
					(7, 1, 7, '1974-02-05', 'F', '2019-08-12', 70, 'N'),
					(8, 1, 8, '1953-02-05', 'F', '2019-08-12', 77, 'B'),
					(9, 1, 9, '1969-02-05', 'M', '2019-08-12', 90, 'B'),
					(10, 1, 10, '1967-02-05', 'F', '2019-08-12', 100, 'B'),
					(11, 1, 11, '1950-02-05', 'F', '2019-08-12', 100, 'B'),
					(12, 1, 12, '1941-02-05', 'F', '2019-08-12', 100, 'B'),
					(13, 1, 13, '1941-02-05', 'F', '2019-08-12', 100, 'B'),
          (99, 1, 9999, '1941-02-05', 'F', '2019-08-12', 100, 'B');

INSERT INTO demo.exame (fkexame,fkpessoa,nratendimento,dtexame,tpexame,resultado,unidade) VALUES 
(1,1,1234,'2019-10-14 18:32:22.000','CR',0.4,'mg/dL')
,(4,3,4567,'2019-10-14 18:32:22.000','TGO',25,'un/L')
,(4,3,4567,'2019-10-14 18:32:22.000','TGP',42,'un/L')
,(4,3,4567,'2019-10-14 18:32:22.000','CR',0.4,'mg/dL')
,(5,4,5678,'2019-10-14 18:32:22.000','CR',0.4,'mg/dL')
,(7,3,7890,'2019-10-13 18:32:22.000','CR',0.4,'mg/dL')
,(8,5,8908,'2019-10-14 18:32:22.000','CR',0.4,'mg/dL')
,(9,6,9876,'2019-10-14 18:32:22.000','CR',0.4,'mg/dL')
,(10,7,8765,'2019-10-14 18:32:22.000','CR',0.4,'mg/dL')
,(11,8,7654,'2019-10-14 18:32:22.000','CR',0.4,'mg/dL')
,(12,9,7643,'2019-10-14 18:32:22.000','CR',0.4,'mg/dL')
,(13,10,6345,'2019-10-13 18:32:22.000','CR',0.4,'mg/dL')
,(14,99,9999,now(),'CR',0.4,'mg/dL');

INSERT INTO demo.prescricao (fkhospital,fksetor,fkprescricao,fkpessoa,idsegmento,dtprescricao,status,nratendimento,update_at,update_by, agregada, indicadores) VALUES 
(1,1,5,4,1,'2020-12-31 00:00:00.000','0',4,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,10,7,1,'2020-12-31 00:00:00.000','0',7,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,11,8,1,'2020-12-31 00:00:00.000','0',8,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,17,13,1,'2020-12-31 00:00:00.000','s',13,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,9,6,1,'2020-12-31 00:00:00.000','s',6,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,13,10,1,'2020-12-31 00:00:00.000','s',10,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,16,12,1,'2020-12-31 00:00:00.000','s',12,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,8,5,1,'2020-12-31 00:00:00.000','s',5,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,4,3,1,'2020-12-30 00:00:00.000','s',3,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,12,9,1,'2020-12-31 00:00:00.000','0',9,'2020-03-25 14:10:50.154',NULL, NULL, NULL)
,(1,1,20,5,1,'2021-01-01 00:00:00.000','0',5,'2020-04-01 17:49:05.198',1, NULL, NULL)
,(1,1,7,3,1,'2020-12-31 00:00:00.000','0',3,'2020-04-01 17:49:23.264',1, NULL, NULL)
,(1,1,14,11,1,'2020-12-31 00:00:00.000','s',11,'2020-04-02 13:20:57.102',1, NULL, NULL)
,(1,1,1,1,1,'2020-12-31 00:00:00.000','s',1,'2020-04-02 20:55:27.158',1, NULL, NULL)
,(1,1,199,99,1,now(),'0',9999,'2020-04-02 20:55:27.158',1, NULL, NULL)
,(1,1,198,99,1,now(),'0',9999,'2020-04-02 20:55:27.158',1, NULL, NULL)
,(1,1,CAST(TO_CHAR(now() - interval '1 day','YYMMDD') || '1000009999' as bigint),99,1,now()::date - interval '1 day','0',9999,'2020-04-02 20:55:27.158',1, true, '{}')
,(1,1,CAST(TO_CHAR(now(),'YYMMDD') || '1000009999' as bigint),99,1,now()::date,'0',9999,'2020-04-02 20:55:27.158',1, true, '{}');

INSERT INTO demo.outlier (fkmedicamento,idsegmento,contagem,doseconv,frequenciadia,escore,escoremanual,update_at,update_by) VALUES 
(4,1,11,5,1,3,NULL,NULL,NULL)
,(4,1,780,10,1,0,0,NULL,NULL)
,(4,1,286,15,1,0,NULL,NULL,NULL)
,(4,1,10,20,1,3,NULL,NULL,NULL)
,(4,1,1779,5,2,0,1,NULL,NULL)
,(4,1,517,10,2,0,NULL,NULL,NULL)
,(4,1,8,15,2,3,NULL,NULL,NULL)
,(4,1,7,20,2,3,NULL,NULL,NULL)
,(4,1,8,3,3,3,NULL,NULL,NULL)
,(4,1,492,5,3,0,NULL,NULL,NULL)
,(4,1,141,10,3,2,NULL,NULL,NULL)
,(4,1,3,15,3,3,NULL,NULL,NULL)
,(4,1,1,20,3,3,NULL,NULL,NULL)
,(5,1,27,50,1,3,NULL,NULL,NULL)
,(5,1,224,100,1,2,NULL,NULL,NULL)
,(5,1,255,50,2,2,NULL,NULL,NULL)
,(5,1,9656,100,2,0,0,NULL,NULL)
,(5,1,5,200,2,3,NULL,NULL,NULL)
,(5,1,117,50,3,3,NULL,NULL,NULL)
,(5,1,571,100,3,1,NULL,NULL,NULL)
,(5,1,12,50,4,3,NULL,NULL,NULL)
,(5,1,37,100,4,3,NULL,NULL,NULL)
,(5,1,2,100,6,3,NULL,NULL,NULL)
,(5,1,1,100,24,3,NULL,NULL,NULL)
,(6,1,20,10,1,3,0,NULL,NULL)
,(6,1,6,15,1,3,NULL,NULL,NULL)
,(6,1,27,20,1,3,NULL,NULL,NULL)
,(6,1,5,25,1,3,NULL,NULL,NULL)
,(6,1,1,30,1,3,NULL,NULL,NULL)
,(6,1,7,5,2,3,NULL,NULL,NULL)
,(6,1,292,10,2,2,NULL,NULL,NULL)
,(6,1,121,15,2,3,NULL,NULL,NULL)
,(6,1,121,20,2,3,NULL,NULL,NULL)
,(6,1,28,25,2,3,NULL,NULL,NULL)
,(6,1,13,30,2,3,NULL,NULL,NULL)
,(6,1,14,50,2,3,NULL,NULL,NULL)
,(6,1,28,5,3,3,NULL,NULL,NULL)
,(6,1,1,8,3,3,NULL,NULL,NULL)
,(6,1,864,10,3,0,NULL,NULL,NULL)
,(6,1,1112,15,3,0,NULL,NULL,NULL)
,(6,1,1112,20,3,0,NULL,NULL,NULL)
,(6,1,503,25,3,2,NULL,NULL,NULL)
,(6,1,985,30,3,0,NULL,NULL,NULL)
,(6,1,66,40,3,3,NULL,NULL,NULL)
,(6,1,2,45,3,3,NULL,NULL,NULL)
,(6,1,4,50,3,3,NULL,NULL,NULL)
,(6,1,1,0,4,0,NULL,NULL,NULL)
,(6,1,4,5,4,3,NULL,NULL,NULL)
,(6,1,30,10,4,3,NULL,NULL,NULL)
,(6,1,91,15,4,3,NULL,NULL,NULL)
,(6,1,74,20,4,3,1,NULL,NULL)
,(6,1,42,25,4,3,NULL,NULL,NULL)
,(6,1,16,30,4,3,NULL,NULL,NULL)
,(6,1,1,50,4,3,NULL,NULL,NULL)
,(6,1,2,15,6,3,NULL,NULL,NULL)
,(7,1,28,5,1,3,NULL,NULL,NULL)
,(7,1,7272,10,1,0,NULL,NULL,NULL)
,(7,1,74,15,1,2,NULL,NULL,NULL)
,(7,1,33,20,1,3,NULL,NULL,NULL)
,(7,1,11,5,2,3,NULL,NULL,NULL)
,(7,1,661,10,2,0,NULL,NULL,NULL)
,(7,1,1,20,2,3,NULL,NULL,NULL)
,(7,1,3,5,3,3,NULL,NULL,NULL)
,(7,1,496,10,3,0,NULL,NULL,NULL)
,(7,1,5,15,3,3,NULL,NULL,NULL)
,(7,1,10,20,3,3,NULL,NULL,NULL)
,(7,1,3,40,3,3,NULL,NULL,NULL)
,(7,1,2,5,4,3,NULL,NULL,NULL)
,(7,1,263,10,4,1,NULL,NULL,NULL)
,(7,1,1,15,4,3,NULL,NULL,NULL)
,(7,1,20,20,4,3,NULL,NULL,NULL)
,(7,1,118,10,6,2,NULL,NULL,NULL)
,(7,1,17,20,6,3,NULL,NULL,NULL)
,(7,1,5,10,8,3,NULL,NULL,NULL)
,(7,1,2,40,12,3,NULL,NULL,NULL)
,(7,1,2,50,12,3,NULL,NULL,NULL)
,(7,1,3,60,12,3,NULL,NULL,NULL)
,(8,1,30,50,1,3,2,NULL,NULL)
,(8,1,3,100,1,3,NULL,NULL,NULL)
,(8,1,160,50,2,2,NULL,NULL,NULL)
,(8,1,2,100,2,3,NULL,NULL,NULL)
,(8,1,5268,50,3,0,NULL,NULL,NULL)
,(8,1,14,100,3,3,NULL,NULL,NULL)
,(8,1,82,50,4,3,NULL,NULL,NULL)
,(9,1,379,1,1,1,NULL,NULL,NULL)
,(9,1,2698,2,1,0,NULL,NULL,NULL)
,(9,1,1,3,1,3,NULL,NULL,NULL)
,(9,1,3076,4,1,0,NULL,NULL,NULL)
,(9,1,39,6,1,3,NULL,NULL,NULL)
,(9,1,19,16,1,3,NULL,NULL,NULL)
,(9,1,7,1,2,3,NULL,NULL,NULL)
,(9,1,53,2,2,3,NULL,NULL,NULL)
,(9,1,8,4,2,3,NULL,NULL,NULL)
,(10,1,1,10,1,3,2,NULL,NULL)
,(10,1,219,20,1,3,0,NULL,NULL)
,(10,1,4,40,1,3,NULL,NULL,NULL)
,(10,1,100,10,2,3,NULL,NULL,NULL)
,(10,1,9183,20,2,0,0,NULL,NULL)
,(10,1,58,40,2,3,1,NULL,NULL)
,(10,1,18,20,3,3,NULL,NULL,NULL)
,(11,1,1,30,1,3,NULL,NULL,NULL)
,(11,1,3,40,1,3,NULL,NULL,NULL)
,(11,1,1,50,1,3,NULL,NULL,NULL)
,(11,1,776,60,1,0,NULL,NULL,NULL)
,(11,1,2,100,1,3,NULL,NULL,NULL)
,(11,1,43,120,1,3,NULL,NULL,NULL)
,(11,1,12,40,2,3,NULL,NULL,NULL)
,(11,1,31,50,2,3,NULL,NULL,NULL)
,(11,1,6734,60,2,0,NULL,NULL,NULL)
,(11,1,1,64,2,3,NULL,NULL,NULL)
,(11,1,1,65,2,3,NULL,NULL,NULL)
,(2,1,3,600,1,3,NULL,NULL,NULL)
,(2,1,2,100,6,3,NULL,NULL,NULL)
,(2,1,823,100,3,0,NULL,NULL,NULL)
,(2,1,2288,100,1,0,NULL,NULL,NULL)
,(2,1,110,100,2,2,NULL,NULL,NULL)
,(2,1,219,200,1,1,NULL,NULL,NULL)
,(2,1,1219,300,1,0,NULL,NULL,NULL)
,(2,1,13,200,2,3,NULL,NULL,NULL)
,(2,1,21,150,1,3,NULL,NULL,NULL)
,(2,1,8,200,3,3,NULL,NULL,NULL)
,(2,1,12,300,3,3,NULL,NULL,NULL)
,(3,1,7982,5,1,0,NULL,NULL,NULL)
,(3,1,1821,5,2,0,NULL,NULL,NULL)
,(3,1,15,5,3,3,NULL,NULL,NULL)
,(3,1,6,5,4,3,NULL,NULL,NULL)
,(3,1,523,10,1,2,NULL,NULL,NULL)
,(3,1,13,10,2,3,NULL,NULL,NULL)
,(3,1,4,15,1,3,NULL,NULL,NULL)
,(11,1,10,70,2,3,NULL,NULL,NULL)
,(11,1,13,80,2,3,NULL,NULL,NULL)
,(11,1,1,90,2,3,NULL,NULL,NULL)
,(11,1,7,100,2,3,NULL,NULL,NULL)
,(11,1,30,120,2,3,NULL,NULL,NULL)
,(12,1,21,50,1,3,NULL,NULL,NULL)
,(12,1,2,25,2,3,NULL,NULL,NULL)
,(12,1,491,50,2,0,NULL,NULL,NULL)
,(12,1,30,100,2,3,NULL,NULL,NULL)
,(12,1,37,25,3,3,NULL,NULL,NULL)
,(12,1,3309,50,3,0,NULL,NULL,NULL)
,(12,1,86,75,3,2,NULL,NULL,NULL)
,(12,1,607,100,3,0,NULL,NULL,NULL)
,(12,1,13,150,3,3,NULL,NULL,NULL)
,(12,1,5,200,3,3,NULL,NULL,NULL)
,(12,1,34,25,4,3,NULL,NULL,NULL)
,(12,1,1186,50,4,0,NULL,NULL,NULL)
,(12,1,31,75,4,3,NULL,NULL,NULL)
,(12,1,196,100,4,2,NULL,NULL,NULL)
,(12,1,8,50,6,3,NULL,NULL,NULL)
,(13,1,1,1,1,3,NULL,NULL,NULL)
,(13,1,294,2,1,0,NULL,NULL,NULL)
,(13,1,35,4,1,3,NULL,NULL,NULL)
,(13,1,805,2,2,0,NULL,NULL,NULL)
,(13,1,187,4,2,1,NULL,NULL,NULL)
,(13,1,3,8,2,3,NULL,NULL,NULL)
,(13,1,1272,2,3,0,NULL,NULL,NULL)
,(13,1,495,4,3,0,NULL,NULL,NULL)
,(13,1,9,8,3,3,NULL,NULL,NULL)
,(13,1,707,2,4,0,NULL,NULL,NULL)
,(13,1,762,4,4,0,NULL,NULL,NULL)
,(13,1,53,6,4,2,NULL,NULL,NULL)
,(13,1,251,8,4,1,NULL,NULL,NULL)
,(13,1,15,2,5,3,NULL,NULL,NULL)
,(13,1,52,2,6,3,NULL,NULL,NULL)
,(13,1,16,4,6,3,NULL,NULL,NULL)
,(14,1,25,10,1,1,NULL,NULL,NULL)
,(14,1,7,14,1,3,NULL,NULL,NULL)
,(14,1,15,15,1,2,NULL,NULL,NULL)
,(14,1,9,16,1,2,NULL,NULL,NULL)
,(14,1,2,17,1,3,NULL,NULL,NULL)
,(14,1,1,18,1,3,NULL,NULL,NULL)
,(14,1,11,20,1,2,NULL,NULL,NULL)
,(14,1,13,32,1,2,NULL,NULL,NULL)
,(14,1,2,5,2,3,NULL,NULL,NULL)
,(14,1,10,10,2,2,NULL,NULL,NULL)
,(14,1,1,14,2,3,NULL,NULL,NULL)
,(14,1,1,15,2,3,NULL,NULL,NULL)
,(14,1,20,16,2,2,NULL,NULL,NULL)
,(14,1,18,32,2,2,NULL,NULL,NULL)
,(14,1,20,36,2,2,NULL,NULL,NULL)
,(14,1,4,5,3,3,NULL,NULL,NULL)
,(14,1,68,10,3,0,NULL,NULL,NULL)
,(14,1,7,15,3,3,NULL,NULL,NULL)
,(14,1,12,16,3,2,NULL,NULL,NULL)
,(14,1,1,19,3,3,NULL,NULL,NULL)
,(14,1,3,20,3,3,NULL,NULL,NULL)
,(14,1,3,25,3,3,NULL,NULL,NULL)
,(14,1,8,30,3,2,NULL,NULL,NULL)
,(14,1,14,32,3,2,NULL,NULL,NULL)
,(14,1,7,96,3,3,NULL,NULL,NULL)
,(14,1,15,5,4,2,NULL,NULL,NULL)
,(14,1,8,8,4,2,NULL,NULL,NULL)
,(14,1,163,10,4,0,NULL,NULL,NULL)
,(14,1,11,12,4,2,NULL,NULL,NULL)
,(14,1,4,13,4,3,NULL,NULL,NULL)
,(14,1,4,14,4,3,NULL,NULL,NULL)
,(14,1,62,15,4,0,NULL,NULL,NULL)
,(14,1,62,16,4,0,NULL,NULL,NULL)
,(14,1,1,18,4,3,NULL,NULL,NULL)
,(14,1,271,20,4,0,NULL,NULL,NULL)
,(14,1,1,24,4,3,NULL,NULL,NULL)
,(14,1,6,25,4,3,NULL,NULL,NULL)
,(14,1,3,28,4,3,NULL,NULL,NULL)
,(14,1,42,30,4,0,NULL,NULL,NULL)
,(14,1,38,32,4,0,NULL,NULL,NULL)
,(14,1,24,40,4,1,NULL,NULL,NULL)
,(14,1,6,45,4,3,NULL,NULL,NULL)
,(14,1,1,50,4,3,NULL,NULL,NULL)
,(14,1,5,80,4,3,NULL,NULL,NULL)
,(14,1,6,10,5,3,NULL,NULL,NULL)
,(14,1,2,3,6,3,NULL,NULL,NULL)
,(14,1,7,5,6,3,NULL,NULL,NULL)
,(14,1,37,8,6,0,NULL,NULL,NULL)
,(14,1,746,10,6,0,NULL,NULL,NULL)
,(14,1,9,12,6,2,NULL,NULL,NULL)
,(14,1,1,13,6,3,NULL,NULL,NULL)
,(14,1,4,14,6,3,NULL,NULL,NULL)
,(14,1,288,15,6,0,NULL,NULL,NULL)
,(14,1,335,16,6,0,NULL,NULL,NULL)
,(14,1,17,18,6,2,NULL,NULL,NULL)
,(14,1,715,20,6,0,NULL,NULL,NULL)
,(14,1,3,22,6,3,NULL,NULL,NULL)
,(14,1,1,23,6,3,NULL,NULL,NULL)
,(14,1,4,24,6,3,NULL,NULL,NULL)
,(14,1,239,25,6,0,NULL,NULL,NULL)
,(14,1,9,26,6,2,NULL,NULL,NULL)
,(14,1,18,28,6,2,NULL,NULL,NULL)
,(14,1,2,29,6,3,NULL,NULL,NULL)
,(14,1,273,30,6,0,NULL,NULL,NULL)
,(14,1,487,32,6,0,NULL,NULL,NULL)
,(14,1,1,34,6,3,NULL,NULL,NULL)
,(14,1,60,35,6,0,NULL,NULL,NULL)
,(14,1,4,36,6,3,NULL,NULL,NULL)
,(14,1,24,38,6,1,NULL,NULL,NULL)
,(14,1,300,40,6,0,NULL,NULL,NULL)
,(14,1,1,42,6,3,NULL,NULL,NULL)
,(14,1,12,44,6,2,NULL,NULL,NULL)
,(14,1,93,45,6,0,NULL,NULL,NULL)
,(14,1,2,46,6,3,NULL,NULL,NULL)
,(14,1,77,48,6,0,NULL,NULL,NULL)
,(14,1,138,50,6,0,NULL,NULL,NULL)
,(14,1,22,52,6,1,NULL,NULL,NULL)
,(14,1,19,55,6,2,NULL,NULL,NULL)
,(14,1,2,57,6,3,NULL,NULL,NULL)
,(14,1,4,58,6,3,NULL,NULL,NULL)
,(14,1,36,60,6,0,NULL,NULL,NULL)
,(14,1,57,64,6,0,NULL,NULL,NULL)
,(14,1,7,65,6,3,NULL,NULL,NULL)
,(14,1,18,68,6,2,NULL,NULL,NULL)
,(14,1,13,70,6,2,NULL,NULL,NULL)
,(14,1,5,72,6,3,NULL,NULL,NULL)
,(14,1,1,74,6,3,NULL,NULL,NULL)
,(14,1,2,77,6,3,NULL,NULL,NULL)
,(14,1,33,80,6,1,NULL,NULL,NULL)
,(14,1,15,90,6,2,NULL,NULL,NULL)
,(14,1,1,95,6,3,NULL,NULL,NULL)
,(14,1,44,96,6,0,NULL,NULL,NULL)
,(14,1,1,97,6,3,NULL,NULL,NULL)
,(14,1,7,100,6,3,NULL,NULL,NULL)
,(14,1,1,105,6,3,NULL,NULL,NULL)
,(14,1,13,110,6,2,NULL,NULL,NULL)
,(14,1,2,112,6,3,NULL,NULL,NULL)
,(14,1,5,115,6,3,NULL,NULL,NULL)
,(14,1,9,118,6,2,NULL,NULL,NULL)
,(14,1,10,128,6,2,NULL,NULL,NULL)
,(14,1,16,144,6,2,NULL,NULL,NULL)
,(14,1,14,150,6,2,NULL,NULL,NULL)
,(14,1,1,166,6,3,NULL,NULL,NULL)
,(14,1,6,175,6,3,NULL,NULL,NULL)
,(14,1,1,180,6,3,NULL,NULL,NULL)
,(14,1,2,200,6,3,NULL,NULL,NULL)
,(14,1,6,224,6,3,NULL,NULL,NULL)
,(14,1,2,256,6,3,NULL,NULL,NULL)
,(14,1,2,288,6,3,NULL,NULL,NULL)
,(14,1,3,320,6,3,NULL,NULL,NULL)
,(14,1,6,380,6,3,NULL,NULL,NULL)
,(14,1,7,400,6,3,NULL,NULL,NULL)
,(14,1,6,16,8,3,NULL,NULL,NULL)
,(14,1,5,20,8,3,NULL,NULL,NULL)
,(14,1,1,25,8,3,NULL,NULL,NULL)
,(14,1,1,30,8,3,NULL,NULL,NULL)
,(14,1,3,32,8,3,NULL,NULL,NULL)
,(14,1,2,40,8,3,NULL,NULL,NULL)
,(14,1,1,60,8,3,NULL,NULL,NULL)
,(14,1,10,15,12,2,NULL,NULL,NULL)
,(14,1,6,40,12,3,NULL,NULL,NULL)
,(14,1,1,50,12,3,NULL,NULL,NULL)
,(14,1,1,80,12,3,NULL,NULL,NULL)
,(14,1,2,16,24,3,NULL,NULL,NULL)
,(14,1,3,32,24,3,NULL,NULL,NULL)
,(14,1,2,50,24,3,NULL,NULL,NULL)
,(14,1,1,67,24,3,NULL,NULL,NULL)
,(15,1,3515,1000,4,0,NULL,NULL,NULL)
,(15,1,1239,500,4,1,NULL,NULL,NULL)
,(15,1,9,1000,6,3,NULL,NULL,NULL)
,(16,1,5,1000000,1,3,NULL,NULL,NULL)
,(16,1,1,1500,1,3,NULL,NULL,NULL)
,(16,1,1,2000,1,3,NULL,NULL,NULL)
,(16,1,14,250000,1,3,NULL,NULL,NULL)
,(16,1,48,500000,1,2,NULL,NULL,NULL)
,(16,1,4,700000,1,3,NULL,NULL,NULL)
,(16,1,15,750000,1,3,NULL,NULL,NULL)
,(16,1,1,1200000,1,3,NULL,NULL,NULL)
,(16,1,4,1250000,1,3,NULL,NULL,NULL)
,(16,1,58,1500000,1,2,NULL,NULL,NULL)
,(16,1,1,1650000,1,3,NULL,NULL,NULL)
,(16,1,1,1700000,1,3,NULL,NULL,NULL)
,(16,1,27,1750000,1,2,NULL,NULL,NULL)
,(16,1,55,2000000,1,2,NULL,NULL,NULL)
,(16,1,2,2250000,1,3,NULL,NULL,NULL)
,(16,1,2,2500000,1,3,NULL,NULL,NULL)
,(16,1,1,500,2,3,NULL,NULL,NULL)
,(16,1,4,600,2,3,NULL,NULL,NULL)
,(16,1,3,700,2,3,NULL,NULL,NULL)
,(16,1,1,120000,2,3,NULL,NULL,NULL)
,(16,1,1,250000,2,3,NULL,NULL,NULL)
,(16,1,1,300000,2,3,NULL,NULL,NULL)
,(16,1,6,375000,2,3,NULL,NULL,NULL)
,(16,1,30,400000,2,2,NULL,NULL,NULL)
,(16,1,4,430000,2,3,NULL,NULL,NULL)
,(16,1,766,500000,2,0,NULL,NULL,NULL)
,(16,1,7,625000,2,3,NULL,NULL,NULL)
,(16,1,9,650000,2,3,NULL,NULL,NULL)
,(16,1,1705,750000,2,0,NULL,NULL,NULL)
,(16,1,5,800000,2,3,NULL,NULL,NULL)
,(16,1,12,875000,2,3,NULL,NULL,NULL)
,(16,1,28,900000,2,2,NULL,NULL,NULL)
,(16,1,3936,1000000,2,0,NULL,NULL,NULL)
,(16,1,40,1200000,2,2,NULL,NULL,NULL)
,(16,1,101,1250000,2,1,NULL,NULL,NULL)
,(16,1,10,1350000,2,3,NULL,NULL,NULL)
,(16,1,247,1500000,2,0,NULL,NULL,NULL)
,(16,1,2,1600000,2,3,NULL,NULL,NULL)
,(16,1,3,1750000,2,3,NULL,NULL,NULL)
,(16,1,8,1800000,2,3,NULL,NULL,NULL)
,(16,1,18,2000000,2,3,NULL,NULL,NULL)
,(16,1,4,2500000,2,3,NULL,NULL,NULL)
,(16,1,1,15000000,2,3,NULL,NULL,NULL)
,(16,1,4,500000,3,3,NULL,NULL,NULL)
,(16,1,5,250000,4,3,NULL,NULL,NULL)
,(16,1,1,300000,4,3,NULL,NULL,NULL)
,(16,1,1,1000000,4,3,NULL,NULL,NULL)
,(17,1,43,1,1,3,NULL,NULL,NULL)
,(17,1,1960,2,1,0,NULL,NULL,NULL)
,(17,1,157,3,1,2,NULL,NULL,NULL)
,(17,1,468,4,1,0,NULL,NULL,NULL)
,(17,1,11,5,1,3,NULL,NULL,NULL)
,(17,1,268,6,1,0,NULL,NULL,NULL)
,(17,1,420,1,2,0,NULL,NULL,NULL)
,(17,1,532,2,2,0,NULL,NULL,NULL)
,(17,1,45,3,2,3,NULL,NULL,NULL)
,(17,1,47,4,2,3,NULL,NULL,NULL)
,(17,1,12,10,2,3,NULL,NULL,NULL)
,(17,1,10,1,3,3,NULL,NULL,NULL)
,(17,1,79,2,3,2,NULL,NULL,NULL)
,(18,1,15,960,0,0,NULL,NULL,NULL)
,(18,1,6320,960,1,0,NULL,NULL,NULL)
,(18,1,24,1920,1,3,NULL,NULL,NULL)
,(18,1,19,480,2,3,NULL,NULL,NULL)
,(18,1,482,960,2,3,NULL,NULL,NULL)
,(18,1,35,1920,2,3,NULL,NULL,NULL)
,(18,1,53,960,3,3,NULL,NULL,NULL)
,(18,1,67,1920,3,3,NULL,NULL,NULL)
,(18,1,11,960,4,3,NULL,NULL,NULL)
,(18,1,1,1200,4,3,NULL,NULL,NULL)
,(18,1,49,1920,4,3,NULL,NULL,NULL)
,(18,1,5,2880,4,3,NULL,NULL,NULL)
,(19,1,5,1,0,0,NULL,NULL,NULL)
,(19,1,4456,1,1,1,NULL,NULL,NULL)
,(19,1,5,1,2,3,NULL,NULL,NULL)
,(20,1,5,2,1,3,NULL,NULL,NULL)
,(20,1,1155,3,1,0,3,NULL,NULL)
,(20,1,3819,5,1,0,NULL,NULL,NULL)
,(20,1,330,8,1,2,3,NULL,NULL)
,(20,1,970,10,1,0,1,NULL,NULL)
,(20,1,18,13,1,3,NULL,NULL,NULL)
,(20,1,88,15,1,3,NULL,NULL,NULL)
,(20,1,15,20,1,3,NULL,NULL,NULL)
,(20,1,6,60,1,3,NULL,NULL,NULL)
,(21,1,913,1,1,0,NULL,NULL,NULL)
,(21,1,170,2,1,3,NULL,NULL,NULL)
,(21,1,1152,1,2,0,NULL,NULL,NULL)
,(21,1,92,2,2,3,NULL,NULL,NULL)
,(21,1,3346,1,3,0,NULL,NULL,NULL)
,(21,1,93,2,3,3,NULL,NULL,NULL)
,(22,1,10791,2000,3,0,0,NULL,NULL)
,(22,1,1615,1000,3,0,0,NULL,NULL)
,(22,1,575,1000,2,2,1,NULL,NULL)
,(22,1,505,2000,2,2,1,NULL,NULL)
,(22,1,306,500,1,2,2,NULL,NULL)
,(22,1,162,500,2,3,2,NULL,NULL)
,(22,1,160,1000,1,3,2,NULL,NULL)
,(22,1,114,3000,3,3,3,NULL,NULL)
,(22,1,105,500,3,3,3,NULL,NULL)
,(22,1,41,1500,3,3,3,NULL,NULL)
,(22,1,38,2000,4,3,3,NULL,NULL)
,(22,1,34,2000,1,3,2,NULL,NULL)
,(23,1,18231,20,4,0,0,NULL,NULL)
,(23,1,2932,20,3,0,0,NULL,NULL)
,(23,1,328,40,4,3,3,NULL,NULL)
,(23,1,294,20,6,3,3,NULL,NULL)
,(23,1,59,20,2,3,0,NULL,NULL)
,(23,1,57,20,1,3,0,NULL,NULL)
,(23,1,48,40,3,3,NULL,NULL,NULL)
,(23,1,46,30,4,3,NULL,NULL,NULL)
,(23,1,31,40,6,3,NULL,NULL,NULL)
,(23,1,10,40,1,3,0,NULL,NULL)
,(23,1,8,10,3,3,NULL,NULL,NULL)
,(24,1,250,20,1,3,0,NULL,NULL)
,(25,1,250,88,1,3,NULL,NULL,NULL)
,(1,1,348,3,3,2,NULL,NULL,NULL)
,(1,1,22,3,1,3,NULL,NULL,NULL)
,(1,1,145,3,2,3,NULL,NULL,NULL)
,(1,1,7,2,2,3,NULL,NULL,NULL)
,(1,1,14,6,4,3,NULL,NULL,NULL)
,(1,1,253,3,6,2,NULL,NULL,NULL)
,(1,1,6437,3,4,0,NULL,NULL,NULL);

INSERT INTO demo.prescricaoagg (fkhospital,fksetor,idsegmento,fkmedicamento,fkunidademedida,fkfrequencia,dose,frequenciadia,contagem,doseconv) VALUES 
(1,1,1,1,NULL,NULL,3,1,22,3)
,(1,1,1,1,NULL,NULL,2,2,7,2)
,(1,1,1,1,NULL,NULL,3,2,145,3)
,(1,1,1,1,NULL,NULL,3,3,348,3)
,(1,1,1,1,NULL,NULL,3,4,6437,3)
,(1,1,1,1,NULL,NULL,6,4,14,6)
,(1,1,1,1,NULL,NULL,3,6,253,3)
,(1,1,1,3,NULL,NULL,5,1,7982,5)
,(1,1,1,3,NULL,NULL,10,1,523,10)
,(1,1,1,3,NULL,NULL,15,1,4,15)
,(1,1,1,3,NULL,NULL,5,2,1821,5)
,(1,1,1,3,NULL,NULL,10,2,13,10)
,(1,1,1,3,NULL,NULL,5,3,15,5)
,(1,1,1,3,NULL,NULL,5,4,6,5)
,(1,1,1,4,NULL,NULL,5,1,11,5)
,(1,1,1,4,NULL,NULL,10,1,780,10)
,(1,1,1,4,NULL,NULL,15,1,286,15)
,(1,1,1,4,NULL,NULL,20,1,10,20)
,(1,1,1,4,NULL,NULL,5,2,1779,5)
,(1,1,1,4,NULL,NULL,10,2,517,10)
,(1,1,1,4,NULL,NULL,15,2,8,15)
,(1,1,1,4,NULL,NULL,20,2,7,20)
,(1,1,1,4,NULL,NULL,3,3,8,3)
,(1,1,1,4,NULL,NULL,5,3,492,5)
,(1,1,1,4,NULL,NULL,10,3,141,10)
,(1,1,1,4,NULL,NULL,15,3,3,15)
,(1,1,1,4,NULL,NULL,20,3,1,20)
,(1,1,1,5,NULL,NULL,50,1,27,50)
,(1,1,1,5,NULL,NULL,100,1,224,100)
,(1,1,1,5,NULL,NULL,50,2,255,50)
,(1,1,1,5,NULL,NULL,100,2,9656,100)
,(1,1,1,5,NULL,NULL,200,2,5,200)
,(1,1,1,5,NULL,NULL,50,3,117,50)
,(1,1,1,5,NULL,NULL,100,3,571,100)
,(1,1,1,5,NULL,NULL,50,4,12,50)
,(1,1,1,5,NULL,NULL,100,4,37,100)
,(1,1,1,5,NULL,NULL,100,6,2,100)
,(1,1,1,5,NULL,NULL,100,24,1,100)
,(1,1,1,6,NULL,NULL,10,1,20,10)
,(1,1,1,6,NULL,NULL,15,1,6,15)
,(1,1,1,6,NULL,NULL,20,1,27,20)
,(1,1,1,6,NULL,NULL,25,1,5,25)
,(1,1,1,6,NULL,NULL,30,1,1,30)
,(1,1,1,6,NULL,NULL,5,2,7,5)
,(1,1,1,6,NULL,NULL,10,2,292,10)
,(1,1,1,6,NULL,NULL,15,2,121,15)
,(1,1,1,6,NULL,NULL,20,2,121,20)
,(1,1,1,6,NULL,NULL,25,2,28,25)
,(1,1,1,6,NULL,NULL,30,2,13,30)
,(1,1,1,6,NULL,NULL,50,2,14,50)
,(1,1,1,6,NULL,NULL,5,3,28,5)
,(1,1,1,6,NULL,NULL,8,3,1,8)
,(1,1,1,6,NULL,NULL,10,3,864,10)
,(1,1,1,6,NULL,NULL,15,3,1112,15)
,(1,1,1,6,NULL,NULL,20,3,1112,20)
,(1,1,1,6,NULL,NULL,25,3,503,25)
,(1,1,1,6,NULL,NULL,30,3,985,30)
,(1,1,1,6,NULL,NULL,40,3,66,40)
,(1,1,1,6,NULL,NULL,45,3,2,45)
,(1,1,1,6,NULL,NULL,50,3,4,50)
,(1,1,1,6,NULL,NULL,0,4,1,0)
,(1,1,1,6,NULL,NULL,5,4,4,5)
,(1,1,1,6,NULL,NULL,10,4,30,10)
,(1,1,1,6,NULL,NULL,15,4,91,15)
,(1,1,1,6,NULL,NULL,20,4,74,20)
,(1,1,1,6,NULL,NULL,25,4,42,25)
,(1,1,1,6,NULL,NULL,30,4,16,30)
,(1,1,1,6,NULL,NULL,50,4,1,50)
,(1,1,1,6,NULL,NULL,15,6,2,15)
,(1,1,1,7,NULL,NULL,5,1,28,5)
,(1,1,1,7,NULL,NULL,10,1,7272,10)
,(1,1,1,7,NULL,NULL,15,1,74,15)
,(1,1,1,7,NULL,NULL,20,1,33,20)
,(1,1,1,7,NULL,NULL,5,2,11,5)
,(1,1,1,7,NULL,NULL,10,2,661,10)
,(1,1,1,7,NULL,NULL,20,2,1,20)
,(1,1,1,7,NULL,NULL,5,3,3,5)
,(1,1,1,7,NULL,NULL,10,3,496,10)
,(1,1,1,7,NULL,NULL,15,3,5,15)
,(1,1,1,7,NULL,NULL,20,3,10,20)
,(1,1,1,7,NULL,NULL,40,3,3,40)
,(1,1,1,7,NULL,NULL,5,4,2,5)
,(1,1,1,7,NULL,NULL,10,4,263,10)
,(1,1,1,7,NULL,NULL,15,4,1,15)
,(1,1,1,7,NULL,NULL,20,4,20,20)
,(1,1,1,7,NULL,NULL,10,6,118,10)
,(1,1,1,7,NULL,NULL,20,6,17,20)
,(1,1,1,7,NULL,NULL,10,8,5,10)
,(1,1,1,7,NULL,NULL,40,12,2,40)
,(1,1,1,7,NULL,NULL,50,12,2,50)
,(1,1,1,7,NULL,NULL,60,12,3,60)
,(1,1,1,8,NULL,NULL,50,1,30,50)
,(1,1,1,8,NULL,NULL,100,1,3,100)
,(1,1,1,8,NULL,NULL,50,2,160,50)
,(1,1,1,8,NULL,NULL,100,2,2,100)
,(1,1,1,8,NULL,NULL,50,3,5268,50)
,(1,1,1,8,NULL,NULL,100,3,14,100)
,(1,1,1,8,NULL,NULL,50,4,82,50)
,(1,1,1,9,NULL,NULL,1,1,379,1)
,(1,1,1,9,NULL,NULL,2,1,2698,2)
,(1,1,1,9,NULL,NULL,3,1,1,3)
,(1,1,1,9,NULL,NULL,4,1,3076,4)
,(1,1,1,9,NULL,NULL,6,1,39,6)
,(1,1,1,9,NULL,NULL,16,1,19,16)
,(1,1,1,9,NULL,NULL,1,2,7,1)
,(1,1,1,9,NULL,NULL,2,2,53,2)
,(1,1,1,9,NULL,NULL,4,2,8,4)
,(1,1,1,10,NULL,NULL,10,1,1,10)
,(1,1,1,10,NULL,NULL,20,1,219,20)
,(1,1,1,10,NULL,NULL,40,1,4,40)
,(1,1,1,10,NULL,NULL,10,2,100,10)
,(1,1,1,10,NULL,NULL,20,2,9183,20)
,(1,1,1,10,NULL,NULL,40,2,58,40)
,(1,1,1,10,NULL,NULL,20,3,18,20)
,(1,1,1,11,NULL,NULL,30,1,1,30)
,(1,1,1,11,NULL,NULL,40,1,3,40)
,(1,1,1,11,NULL,NULL,50,1,1,50)
,(1,1,1,11,NULL,NULL,60,1,776,60)
,(1,1,1,11,NULL,NULL,100,1,2,100)
,(1,1,1,11,NULL,NULL,120,1,43,120)
,(1,1,1,11,NULL,NULL,40,2,12,40)
,(1,1,1,11,NULL,NULL,50,2,31,50)
,(1,1,1,11,NULL,NULL,60,2,6734,60)
,(1,1,1,11,NULL,NULL,64,2,1,64)
,(1,1,1,11,NULL,NULL,65,2,1,65)
,(1,1,1,11,NULL,NULL,70,2,10,70)
,(1,1,1,11,NULL,NULL,80,2,13,80)
,(1,1,1,11,NULL,NULL,90,2,1,90)
,(1,1,1,11,NULL,NULL,100,2,7,100)
,(1,1,1,11,NULL,NULL,120,2,30,120)
,(1,1,1,12,NULL,NULL,50,1,21,50)
,(1,1,1,12,NULL,NULL,25,2,2,25)
,(1,1,1,12,NULL,NULL,50,2,491,50)
,(1,1,1,12,NULL,NULL,100,2,30,100)
,(1,1,1,12,NULL,NULL,25,3,37,25)
,(1,1,1,12,NULL,NULL,50,3,3309,50)
,(1,1,1,12,NULL,NULL,75,3,86,75)
,(1,1,1,12,NULL,NULL,100,3,607,100)
,(1,1,1,12,NULL,NULL,150,3,13,150)
,(1,1,1,12,NULL,NULL,200,3,5,200)
,(1,1,1,12,NULL,NULL,25,4,34,25)
,(1,1,1,12,NULL,NULL,50,4,1186,50)
,(1,1,1,12,NULL,NULL,75,4,31,75)
,(1,1,1,12,NULL,NULL,100,4,196,100)
,(1,1,1,12,NULL,NULL,50,6,8,50)
,(1,1,1,13,NULL,NULL,1,1,1,1)
,(1,1,1,13,NULL,NULL,2,1,294,2)
,(1,1,1,13,NULL,NULL,4,1,35,4)
,(1,1,1,13,NULL,NULL,2,2,805,2)
,(1,1,1,13,NULL,NULL,4,2,187,4)
,(1,1,1,13,NULL,NULL,8,2,3,8)
,(1,1,1,13,NULL,NULL,2,3,1272,2)
,(1,1,1,13,NULL,NULL,4,3,495,4)
,(1,1,1,13,NULL,NULL,8,3,9,8)
,(1,1,1,13,NULL,NULL,2,4,707,2)
,(1,1,1,13,NULL,NULL,4,4,762,4)
,(1,1,1,13,NULL,NULL,6,4,53,6)
,(1,1,1,13,NULL,NULL,8,4,251,8)
,(1,1,1,13,NULL,NULL,2,5,15,2)
,(1,1,1,13,NULL,NULL,2,6,52,2)
,(1,1,1,13,NULL,NULL,4,6,16,4)
,(1,1,1,14,NULL,NULL,10,1,25,10)
,(1,1,1,14,NULL,NULL,14,1,7,14)
,(1,1,1,14,NULL,NULL,15,1,15,15)
,(1,1,1,14,NULL,NULL,16,1,9,16)
,(1,1,1,14,NULL,NULL,17,1,2,17)
,(1,1,1,14,NULL,NULL,18,1,1,18)
,(1,1,1,14,NULL,NULL,20,1,11,20)
,(1,1,1,14,NULL,NULL,32,1,13,32)
,(1,1,1,14,NULL,NULL,5,2,2,5)
,(1,1,1,14,NULL,NULL,10,2,10,10)
,(1,1,1,14,NULL,NULL,14,2,1,14)
,(1,1,1,14,NULL,NULL,15,2,1,15)
,(1,1,1,14,NULL,NULL,16,2,20,16)
,(1,1,1,14,NULL,NULL,32,2,18,32)
,(1,1,1,14,NULL,NULL,36,2,20,36)
,(1,1,1,14,NULL,NULL,5,3,4,5)
,(1,1,1,14,NULL,NULL,10,3,68,10)
,(1,1,1,14,NULL,NULL,15,3,7,15)
,(1,1,1,14,NULL,NULL,16,3,12,16)
,(1,1,1,14,NULL,NULL,19,3,1,19)
,(1,1,1,14,NULL,NULL,20,3,3,20)
,(1,1,1,14,NULL,NULL,25,3,3,25)
,(1,1,1,14,NULL,NULL,30,3,8,30)
,(1,1,1,14,NULL,NULL,32,3,14,32)
,(1,1,1,14,NULL,NULL,96,3,7,96)
,(1,1,1,14,NULL,NULL,5,4,15,5)
,(1,1,1,14,NULL,NULL,8,4,8,8)
,(1,1,1,14,NULL,NULL,10,4,163,10)
,(1,1,1,14,NULL,NULL,12,4,11,12)
,(1,1,1,14,NULL,NULL,13,4,4,13)
,(1,1,1,14,NULL,NULL,14,4,4,14)
,(1,1,1,14,NULL,NULL,15,4,62,15)
,(1,1,1,14,NULL,NULL,16,4,62,16)
,(1,1,1,14,NULL,NULL,18,4,1,18)
,(1,1,1,14,NULL,NULL,20,4,271,20)
,(1,1,1,14,NULL,NULL,24,4,1,24)
,(1,1,1,14,NULL,NULL,25,4,6,25)
,(1,1,1,14,NULL,NULL,28,4,3,28)
,(1,1,1,14,NULL,NULL,30,4,42,30)
,(1,1,1,14,NULL,NULL,32,4,38,32)
,(1,1,1,14,NULL,NULL,40,4,24,40)
,(1,1,1,14,NULL,NULL,45,4,6,45)
,(1,1,1,14,NULL,NULL,50,4,1,50)
,(1,1,1,14,NULL,NULL,80,4,5,80)
,(1,1,1,14,NULL,NULL,10,5,6,10)
,(1,1,1,14,NULL,NULL,3,6,2,3)
,(1,1,1,14,NULL,NULL,5,6,7,5)
,(1,1,1,14,NULL,NULL,8,6,37,8)
,(1,1,1,14,NULL,NULL,10,6,746,10)
,(1,1,1,14,NULL,NULL,12,6,9,12)
,(1,1,1,14,NULL,NULL,13,6,1,13)
,(1,1,1,14,NULL,NULL,14,6,4,14)
,(1,1,1,14,NULL,NULL,15,6,288,15)
,(1,1,1,14,NULL,NULL,16,6,335,16)
,(1,1,1,14,NULL,NULL,18,6,17,18)
,(1,1,1,14,NULL,NULL,20,6,715,20)
,(1,1,1,14,NULL,NULL,22,6,3,22)
,(1,1,1,14,NULL,NULL,23,6,1,23)
,(1,1,1,14,NULL,NULL,24,6,4,24)
,(1,1,1,14,NULL,NULL,25,6,239,25)
,(1,1,1,14,NULL,NULL,26,6,9,26)
,(1,1,1,14,NULL,NULL,28,6,18,28)
,(1,1,1,14,NULL,NULL,29,6,2,29)
,(1,1,1,14,NULL,NULL,30,6,273,30)
,(1,1,1,14,NULL,NULL,32,6,487,32)
,(1,1,1,14,NULL,NULL,34,6,1,34)
,(1,1,1,14,NULL,NULL,35,6,60,35)
,(1,1,1,14,NULL,NULL,36,6,4,36)
,(1,1,1,14,NULL,NULL,38,6,24,38)
,(1,1,1,14,NULL,NULL,40,6,300,40)
,(1,1,1,14,NULL,NULL,42,6,1,42)
,(1,1,1,14,NULL,NULL,44,6,12,44)
,(1,1,1,14,NULL,NULL,45,6,93,45)
,(1,1,1,14,NULL,NULL,46,6,2,46)
,(1,1,1,14,NULL,NULL,48,6,77,48)
,(1,1,1,14,NULL,NULL,50,6,138,50)
,(1,1,1,14,NULL,NULL,52,6,22,52)
,(1,1,1,14,NULL,NULL,55,6,19,55)
,(1,1,1,14,NULL,NULL,57,6,2,57)
,(1,1,1,14,NULL,NULL,58,6,4,58)
,(1,1,1,14,NULL,NULL,60,6,36,60)
,(1,1,1,14,NULL,NULL,64,6,57,64)
,(1,1,1,14,NULL,NULL,65,6,7,65)
,(1,1,1,14,NULL,NULL,68,6,18,68)
,(1,1,1,14,NULL,NULL,70,6,13,70)
,(1,1,1,14,NULL,NULL,72,6,5,72)
,(1,1,1,14,NULL,NULL,74,6,1,74)
,(1,1,1,14,NULL,NULL,77,6,2,77)
,(1,1,1,14,NULL,NULL,80,6,33,80)
,(1,1,1,14,NULL,NULL,90,6,15,90)
,(1,1,1,14,NULL,NULL,95,6,1,95)
,(1,1,1,14,NULL,NULL,96,6,44,96)
,(1,1,1,14,NULL,NULL,97,6,1,97)
,(1,1,1,14,NULL,NULL,100,6,7,100)
,(1,1,1,14,NULL,NULL,105,6,1,105)
,(1,1,1,14,NULL,NULL,110,6,13,110)
,(1,1,1,14,NULL,NULL,112,6,2,112)
,(1,1,1,14,NULL,NULL,115,6,5,115)
,(1,1,1,14,NULL,NULL,118,6,9,118)
,(1,1,1,14,NULL,NULL,128,6,10,128)
,(1,1,1,14,NULL,NULL,144,6,16,144)
,(1,1,1,14,NULL,NULL,150,6,14,150)
,(1,1,1,14,NULL,NULL,166,6,1,166)
,(1,1,1,14,NULL,NULL,175,6,6,175)
,(1,1,1,14,NULL,NULL,180,6,1,180)
,(1,1,1,14,NULL,NULL,200,6,2,200)
,(1,1,1,14,NULL,NULL,224,6,6,224)
,(1,1,1,14,NULL,NULL,256,6,2,256)
,(1,1,1,14,NULL,NULL,288,6,2,288)
,(1,1,1,14,NULL,NULL,320,6,3,320)
,(1,1,1,14,NULL,NULL,380,6,6,380)
,(1,1,1,14,NULL,NULL,400,6,7,400)
,(1,1,1,14,NULL,NULL,16,8,6,16)
,(1,1,1,14,NULL,NULL,20,8,5,20)
,(1,1,1,14,NULL,NULL,25,8,1,25)
,(1,1,1,14,NULL,NULL,30,8,1,30)
,(1,1,1,14,NULL,NULL,32,8,3,32)
,(1,1,1,14,NULL,NULL,40,8,2,40)
,(1,1,1,14,NULL,NULL,60,8,1,60)
,(1,1,1,14,NULL,NULL,15,12,10,15)
,(1,1,1,14,NULL,NULL,40,12,6,40)
,(1,1,1,14,NULL,NULL,50,12,1,50)
,(1,1,1,14,NULL,NULL,80,12,1,80)
,(1,1,1,14,NULL,NULL,16,24,2,16)
,(1,1,1,14,NULL,NULL,32,24,3,32)
,(1,1,1,14,NULL,NULL,50,24,2,50)
,(1,1,1,14,NULL,NULL,67,24,1,67)
,(1,1,1,15,NULL,NULL,1000,4,3515,1000)
,(1,1,1,15,NULL,NULL,500,4,1239,500)
,(1,1,1,15,NULL,NULL,1000,6,9,1000)
,(1,1,1,16,NULL,NULL,1000000,1,5,1000000)
,(1,1,1,16,NULL,NULL,1500,1,1,1500)
,(1,1,1,16,NULL,NULL,2000,1,1,2000)
,(1,1,1,16,NULL,NULL,250000,1,14,250000)
,(1,1,1,16,NULL,NULL,500000,1,48,500000)
,(1,1,1,16,NULL,NULL,700000,1,4,700000)
,(1,1,1,16,NULL,NULL,750000,1,15,750000)
,(1,1,1,16,NULL,NULL,1200000,1,1,1200000)
,(1,1,1,16,NULL,NULL,1250000,1,4,1250000)
,(1,1,1,16,NULL,NULL,1500000,1,58,1500000)
,(1,1,1,16,NULL,NULL,1650000,1,1,1650000)
,(1,1,1,16,NULL,NULL,1700000,1,1,1700000)
,(1,1,1,16,NULL,NULL,1750000,1,27,1750000)
,(1,1,1,16,NULL,NULL,2000000,1,55,2000000)
,(1,1,1,16,NULL,NULL,2250000,1,2,2250000)
,(1,1,1,16,NULL,NULL,2500000,1,2,2500000)
,(1,1,1,16,NULL,NULL,500,2,1,500)
,(1,1,1,16,NULL,NULL,600,2,4,600)
,(1,1,1,16,NULL,NULL,700,2,3,700)
,(1,1,1,16,NULL,NULL,120000,2,1,120000)
,(1,1,1,16,NULL,NULL,250000,2,1,250000)
,(1,1,1,16,NULL,NULL,300000,2,1,300000)
,(1,1,1,16,NULL,NULL,375000,2,6,375000)
,(1,1,1,16,NULL,NULL,400000,2,30,400000)
,(1,1,1,16,NULL,NULL,430000,2,4,430000)
,(1,1,1,16,NULL,NULL,500000,2,766,500000)
,(1,1,1,16,NULL,NULL,625000,2,7,625000)
,(1,1,1,16,NULL,NULL,650000,2,9,650000)
,(1,1,1,16,NULL,NULL,750000,2,1705,750000)
,(1,1,1,16,NULL,NULL,800000,2,5,800000)
,(1,1,1,16,NULL,NULL,875000,2,12,875000)
,(1,1,1,16,NULL,NULL,900000,2,28,900000)
,(1,1,1,16,NULL,NULL,1000000,2,3936,1000000)
,(1,1,1,16,NULL,NULL,1200000,2,40,1200000)
,(1,1,1,16,NULL,NULL,1250000,2,101,1250000)
,(1,1,1,16,NULL,NULL,1350000,2,10,1350000)
,(1,1,1,16,NULL,NULL,1500000,2,247,1500000)
,(1,1,1,16,NULL,NULL,1600000,2,2,1600000)
,(1,1,1,16,NULL,NULL,1750000,2,3,1750000)
,(1,1,1,16,NULL,NULL,1800000,2,8,1800000)
,(1,1,1,16,NULL,NULL,2000000,2,18,2000000)
,(1,1,1,16,NULL,NULL,2500000,2,4,2500000)
,(1,1,1,16,NULL,NULL,15000000,2,1,15000000)
,(1,1,1,16,NULL,NULL,500000,3,4,500000)
,(1,1,1,16,NULL,NULL,250000,4,5,250000)
,(1,1,1,16,NULL,NULL,300000,4,1,300000)
,(1,1,1,16,NULL,NULL,1000000,4,1,1000000)
,(1,1,1,17,NULL,NULL,1,1,43,1)
,(1,1,1,17,NULL,NULL,2,1,1960,2)
,(1,1,1,17,NULL,NULL,3,1,157,3)
,(1,1,1,17,NULL,NULL,4,1,468,4)
,(1,1,1,17,NULL,NULL,5,1,11,5)
,(1,1,1,17,NULL,NULL,6,1,268,6)
,(1,1,1,17,NULL,NULL,1,2,420,1)
,(1,1,1,17,NULL,NULL,2,2,532,2)
,(1,1,1,17,NULL,NULL,3,2,45,3)
,(1,1,1,17,NULL,NULL,4,2,47,4)
,(1,1,1,17,NULL,NULL,10,2,12,10)
,(1,1,1,17,NULL,NULL,1,3,10,1)
,(1,1,1,17,NULL,NULL,2,3,79,2)
,(1,1,1,18,NULL,NULL,960,0,15,960)
,(1,1,1,18,NULL,NULL,960,1,6320,960)
,(1,1,1,18,NULL,NULL,1920,1,24,1920)
,(1,1,1,18,NULL,NULL,480,2,19,480)
,(1,1,1,18,NULL,NULL,960,2,482,960)
,(1,1,1,18,NULL,NULL,1920,2,35,1920)
,(1,1,1,18,NULL,NULL,960,3,53,960)
,(1,1,1,18,NULL,NULL,1920,3,67,1920)
,(1,1,1,18,NULL,NULL,960,4,11,960)
,(1,1,1,18,NULL,NULL,1200,4,1,1200)
,(1,1,1,18,NULL,NULL,1920,4,49,1920)
,(1,1,1,18,NULL,NULL,2880,4,5,2880)
,(1,1,1,19,NULL,NULL,1,0,5,1)
,(1,1,1,19,NULL,NULL,1,1,4456,1)
,(1,1,1,19,NULL,NULL,1,2,5,1)
,(1,1,1,20,NULL,NULL,2,1,5,2)
,(1,1,1,20,NULL,NULL,3,1,1155,3)
,(1,1,1,20,NULL,NULL,5,1,3819,5)
,(1,1,1,20,NULL,NULL,8,1,330,8)
,(1,1,1,20,NULL,NULL,10,1,970,10)
,(1,1,1,20,NULL,NULL,13,1,18,13)
,(1,1,1,20,NULL,NULL,15,1,88,15)
,(1,1,1,20,NULL,NULL,20,1,15,20)
,(1,1,1,20,NULL,NULL,60,1,6,60)
,(1,1,1,21,NULL,NULL,1,1,913,1)
,(1,1,1,21,NULL,NULL,2,1,170,2)
,(1,1,1,21,NULL,NULL,1,2,1152,1)
,(1,1,1,21,NULL,NULL,2,2,92,2)
,(1,1,1,21,NULL,NULL,1,3,3346,1)
,(1,1,1,21,NULL,NULL,2,3,93,2)
,(1,1,1,22,NULL,NULL,2000,3,10791,2000)
,(1,1,1,22,NULL,NULL,1000,3,1615,1000)
,(1,1,1,22,NULL,NULL,1000,2,575,1000)
,(1,1,1,22,NULL,NULL,2000,2,505,2000)
,(1,1,1,22,NULL,NULL,500,1,306,500)
,(1,1,1,22,NULL,NULL,500,2,162,500)
,(1,1,1,22,NULL,NULL,1000,1,160,1000)
,(1,1,1,22,NULL,NULL,3000,3,114,3000)
,(1,1,1,22,NULL,NULL,500,3,105,500)
,(1,1,1,22,NULL,NULL,1500,3,41,1500)
,(1,1,1,22,NULL,NULL,2000,4,38,2000)
,(1,1,1,22,NULL,NULL,2000,1,34,2000)
,(1,1,1,23,NULL,NULL,20,4,18231,20)
,(1,1,1,23,NULL,NULL,20,3,2932,20)
,(1,1,1,23,NULL,NULL,40,4,328,40)
,(1,1,1,23,NULL,NULL,20,6,294,20)
,(1,1,1,23,NULL,NULL,20,2,59,20)
,(1,1,1,23,NULL,NULL,20,1,57,20)
,(1,1,1,23,NULL,NULL,40,3,48,40)
,(1,1,1,23,NULL,NULL,30,4,46,30)
,(1,1,1,23,NULL,NULL,40,6,31,40)
,(1,1,1,23,NULL,NULL,40,1,10,40)
,(1,1,1,23,NULL,NULL,10,3,8,10)
,(1,1,1,24,NULL,NULL,20,1,250,20)
,(1,1,1,25,NULL,NULL,88,1,250,88)
,(1,1,1,2,'1',NULL,100,1,2288,100)
,(1,1,1,2,'1',NULL,150,1,21,150)
,(1,1,1,2,'1',NULL,200,1,219,200)
,(1,1,1,2,'3',NULL,300,1,1219,300)
,(1,1,1,2,'3',NULL,600,1,3,600)
,(1,1,1,2,'1',NULL,100,2,110,100)
,(1,1,1,2,'1',NULL,200,2,13,200)
,(1,1,1,2,'3',NULL,100,3,823,100)
,(1,1,1,2,'1',NULL,200,3,8,200)
,(1,1,1,2,'1',NULL,300,3,12,300)
,(1,1,1,2,'1',NULL,100,6,2,100);

INSERT INTO demo.presmed (fkprescricao,fkmedicamento,fkunidademedida,fkfrequencia,idsegmento,idoutlier,dose,frequenciadia,via,complemento,escorefinal,doseconv) VALUES 
(1,2,'1',1,1,459,100,1,'VO',NULL,NULL,100)
,(5,2,'1',1,1,459,100,1,'VO',NULL,NULL,100)
,(5,3,'1',1,1,467,5,1,'VO',NULL,NULL,5)
,(9,3,'1',1,1,471,10,1,'VO',NULL,NULL,10)
,(4,7,'1',3,1,88,5,3,'VO',NULL,NULL,5)
,(4,17,'1',2,1,360,10,2,'VO',NULL,NULL,10)
,(5,10,'1',1,1,121,40,1,'VO',NULL,NULL,40)
,(7,7,'1',3,1,88,5,3,'VO',NULL,NULL,5)
,(7,17,'1',2,1,360,10,2,'VO',NULL,NULL,10)
,(8,10,'1',2,1,123,20,2,'VO',NULL,NULL,20)
,(8,15,'1',4,1,300,1000,4,'VO',NULL,NULL,1000)
,(8,25,'1',1,1,417,88,1,'VO',NULL,NULL,88)
,(9,15,'1',4,1,301,500,4,'VO',NULL,NULL,500)
,(9,23,'1',4,1,405,20,4,'VO',NULL,NULL,20)
,(9,24,'1',1,1,416,20,1,'VO',NULL,NULL,20)
,(10,7,'1',1,1,82,10,1,'VO',NULL,NULL,10)
,(10,15,'1',4,1,301,500,4,'VO',NULL,NULL,500)
,(10,22,'1',3,1,393,2000,3,'VO',NULL,NULL,2000)
,(11,15,'1',4,1,300,1000,4,'VO',NULL,NULL,1000)
,(11,22,'1',1,1,404,2000,1,'VO',NULL,NULL,2000)
,(17,1,'1',4,1,455,3,4,'VO',NULL,NULL,3)
,(11,23,'1',6,1,408,20,6,'VO',NULL,NULL,20)
,(12,12,'1',3,1,146,25,3,'VO',NULL,NULL,25)
,(12,15,'1',4,1,301,500,4,'VO',NULL,NULL,500)
,(12,20,'1',1,1,380,5,1,'VO',NULL,NULL,5)
,(13,5,'1',2,1,43,200,2,'VO',NULL,NULL,200)
,(13,14,'1',6,1,237,32,6,'VO',NULL,NULL,32)
,(13,15,'1',4,1,301,500,4,'VO',NULL,NULL,500)
,(14,10,'1',2,1,124,40,2,'VO',NULL,NULL,40)
,(20,10,'1',2,1,123,20,2,'VO',NULL,NULL,20)
,(20,15,'1',4,1,300,1000,4,'VO',NULL,NULL,1000)
,(20,25,'1',1,1,417,88,1,'VO',NULL,NULL,88)
,(20,25,'1',1,1,NULL,80,1,'VO',NULL,NULL,NULL)
,(14,15,'1',4,1,301,500,4,'VO',NULL,NULL,500)
,(14,22,'1',4,1,403,2000,4,'VO',NULL,NULL,2000)
,(16,4,'1',2,1,30,5,2,'VO',NULL,NULL,5)
,(16,15,'1',6,1,302,1000,6,'VO',NULL,NULL,1000)
,(16,20,'1',1,1,385,20,1,'VO',NULL,NULL,20)
,(17,15,'1',4,1,301,500,4,'VO',NULL,NULL,500)
,(17,24,'1',1,1,416,20,1,'VO',NULL,NULL,20)
,(20,22,'1',4,1,403,2000,4,'VO',NULL,NULL,2000)
,(20,4,'1',2,1,30,5,2,'VO',NULL,NULL,5)
,(199,10,'1',1,1,123,20,2,'VO',NULL,NULL,20)
,(199,15,'1',4,1,300,1000,4,'VO',NULL,NULL,1000)
,(199,25,'1',1,1,417,88,1,'VO',NULL,NULL,88)
,(199,25,'1',1,1,NULL,80,1,'VO',NULL,NULL,NULL)
,(199,22,'1',4,1,403,2000,4,'VO',NULL,NULL,2000)
,(199,4,'1',2,1,30,5,2,'VO',NULL,NULL,5)
,(198,10,'1',2,1,123,20,2,'VO',NULL,NULL,20)
,(198,15,'1',4,1,300,1000,4,'VO',NULL,NULL,1000)
,(198,25,'1',1,1,417,88,1,'VO',NULL,NULL,88)
,(198,25,'1',1,1,NULL,80,1,'VO',NULL,NULL,NULL)
,(198,22,'1',4,1,403,2000,4,'VO',NULL,NULL,2000)
,(198,4,'1',2,1,30,5,2,'VO',NULL,NULL,5);

-- conciliacoes
INSERT INTO demo.prescricao (fkhospital,fksetor,fkprescricao,fkpessoa,idsegmento,dtprescricao,status,nratendimento,update_at,update_by, agregada, indicadores, concilia) VALUES 
(1,1,9199,99,1,now(),'0',9999,'2020-04-02 20:55:27.158',1, NULL, NULL, 's');

INSERT INTO demo.presmed (fkprescricao,fkmedicamento,fkunidademedida,fkfrequencia,idsegmento,idoutlier,dose,frequenciadia,via,complemento,escorefinal,doseconv, horario) VALUES 
(9199,0,'1',1,1,459,100,1,'VO',NULL,NULL,100, 'Medicamento do paciente');
-- fim conciliacoes

INSERT INTO demo.unidadeconverte (idsegmento,fkunidademedida,fator,fkmedicamento) VALUES 
(1,'2',3.3,2)
,(1,'3',3,2)
,(1,'1',1,2);

INSERT INTO demo.intervencao (fkpresmed, nratendimento, update_by, idmotivointervencao, status, observacao) VALUES
	(4, 1, 1, ARRAY[2], 'N', '<p><strong>Existe </strong><em>apresenta&ccedil;&atilde;o adequada</em> de <strong>50mg</strong></p>'),
	(18, 2, 1, ARRAY[3], 'N', 'Possivel erro de via. Trocar para EV'),
	(14, 3, 1, ARRAY[2], 'N', 'Frequência potencialmente inadequada para paciente obeso.'),
	(6, 4, 1, ARRAY[2], 'S', '<p>Temos dispon&iacute;vel apresenta&ccedil;&atilde;o de ENALAPRIL 5 mg mais adequada para a dose prescrita.</p><p>Att, Farm...</p><p>Ramal...</p>'),
	(9, 5, 1, ARRAY[2], 'N', '<p>Temos dispon&iacute;vel DIAZEPAM 5mg, mais adequado para a dose prescrita.</p><p>Att, Farm...</p><p>Ramal...</p>'),
	(2, 6, 1, ARRAY[2], 'N', '<p>Temos dispon&iacute;vel DIAZEPAM 5mg, mais adequado para a dose prescrita.</p><p>Att, Farm...</p><p>Ramal...</p>'),
	(5, 7, 1, ARRAY[2], 'N', '<p>Temos dispon&iacute;vel apresenta&ccedil;&atilde;o de ANLODIPINO 5 mg mais adequada para a dose prescrita.</p><p>Att, Farm...</p><p>Ramal...</p>'),
	(24, 8, 1, ARRAY[2], 'S', '<p>Temos dispon&iacute;vel apresenta&ccedil;&atilde;o da HIDRALAZINA 25mg, mais adequado para a dose prescrita.</p><p>Att, Farm...</p><p>Ramal..</p><p>&nbsp;</p>'),
	(13, 1, 1, ARRAY[12], 'N', '<p>N&atilde;o temos dispon&iacute;vel apresenta&ccedil;&atilde;o com essa dose dispon&iacute;vel, portanto n&atilde;o ser&aacute; administrada de forma precisa. Avaliar apresenta&ccedil;&otilde;es dispon&iacute;veis mais adequadas.</p><p>Att, Farm...</p><p>Ramal...</p>'),
	(3, 2, 1, ARRAY[12], 'N', '<p>Sugiro revisar dose da RISPERIDONA.</p><p>Doses acima de 10 mg/dia n&atilde;o se mostraram superiores em efic&aacute;cia em rela&ccedil;&atilde;o a doses mais baixas, e podem provocar mais sintomas extrapiramidais.</p><p>Att, Farm. ....</p><p>Ramal...</p>'),
	(10, 3, 1, ARRAY[12], 'N', '<p>Sugiro revisar dose da RISPERIDONA.</p><p>Doses acima de 10 mg/dia n&atilde;o se mostraram superiores em efic&aacute;cia em rela&ccedil;&atilde;o a doses mais baixas, e podem provocar mais sintomas extrapiramidais.</p><p>Att, Farm. ....</p><p>Ramal...</p>'),
	(35, 4, 1, ARRAY[12], 'N', '<p>Medicamento de alta vigil&acirc;ncia - VARFARINA - com dose acima da usual.</p><p>Favor revisar.</p><p>Att, Farm...</p><p>Ramal...</p>'),
	(34, 5, 1, ARRAY[12], 'N', '<p>A dose m&aacute;xima di&aacute;ria do PARACETAMOL &eacute; de 4g.</p><p>Favor rever frequ&ecirc;ncia (frequ&ecirc;ncia usual 6/6h)</p><p>Att, Farm...</p><p>Ramal...</p>'),
	(23, 6, 1, ARRAY[15], 'N', '<p>A dose m&aacute;xima di&aacute;ria da HIOSCINA &eacute; de 100mg.</p><p>Frequ&ecirc;ncia usual &eacute; 6/6h.</p><p>Favor rever frequ&ecirc;ncia.</p><p>Att, Farm...</p><p>Ramal...</p>');