--
-- Dump dei dati per la tabella `ec_agenda_servizi_giornaliera`
--

INSERT INTO `ec_agenda_servizi_giornaliera` (`id`, `id_agenda_HTSAN`, `nome_agenda`, `id_medico`, `nome_medico`, `id_servizio`, `nome_servizio`, `id_modalita`, `data`, `ora_inizio`, `ora_fine`, `prenotati`, `liberi`) VALUES
(1, 131, 'CALTAVUTURO (TAC/RX ESTERNI)', 131, 'CALTAVUTURO CLAUDIA', 65, 'TAC', 1, '2014-05-07', '10:00:00', '12:45:00', 1, 11),
(2, 2, 'CARDIOLOGIA AMBULATORIALE', 0, 'TUTTI', 8, 'CARDIOLOGIA', 1, '2014-05-07', '13:30:00', '13:30:00', 5, 0),
(3, 701, 'COPPOLINO SINIBALDO', 701, 'COPPOLINO SINIBALDO', 68, 'PNEUMOLOGIA', 1, '2014-05-07', '15:30:00', '17:00:00', 4, 0),
(4, 333, 'COSENTINO SALVATORE', 333, 'COSENTINO SALVATORE', 58, ' ENDOSCOPIA', 1, '2014-05-07', '10:00:00', '11:30:00', 4, 0),
(5, 203, 'DH TERAPIA INF. BREVE', 0, 'TUTTI', 2, ' DAY HOSPITAL', 2, '2014-05-07', '07:30:00', '08:55:00', 13, 5),
(6, 201, 'DH TERAPIA INF. LUNGA', 0, 'TUTTI', 2, ' DAY HOSPITAL', 2, '2014-05-07', '07:30:00', '08:55:00', 0, 18),
(7, 202, 'DH TERAPIA INF. MEDIA', 0, 'TUTTI', 2, ' DAY HOSPITAL', 2, '2014-05-07', '07:30:00', '08:55:00', 4, 14),
(8, 144, 'GIUFFRIDA (ENDOCRINOLOGIA)', 145, 'GIUFFRIDA DARIO', 0, ' TUTTI', 1, '2014-05-07', '15:00:00', '18:40:00', 17, 0),
(9, 146, 'GIUFFRIDA (MATTINA)', 145, 'GIUFFRIDA DARIO', 64, 'ONCOLOGIA AMBUL.', 1, '2014-05-07', '11:00:00', '11:30:00', 6, 0),
(10, 145, 'GIUFFRIDA (POMERIGGIO)', 145, 'GIUFFRIDA DARIO', 0, '*** ONCOLOGIA MEDICA', 1, '2014-05-07', '15:00:00', '18:30:00', 16, 0),
(11, 161, 'IMPALLOMENI RAFFAELLO', 161, 'IMPALLOMENI RAFFAELLO', 75, 'DERMATOLOGIA', 1, '2014-05-07', '09:00:00', '17:30:00', 19, 3),
(12, 121, 'MAJORANA MARCELLO', 121, 'MAJORANA MARCELLO', 69, 'RADIOLOGIA', 1, '2014-05-07', '15:20:00', '18:00:00', 5, 5),
(13, 641, 'ONCOLOGIA AMBULATORIALE', 0, 'TUTTI', 64, 'ONCOLOGIA AMBUL', 1, '2014-05-07', '11:00:00', '12:40:00', 9, 0),
(14, 7, 'PAC DIAGNOSTICI D.I.', 0, 'TUTTI', 0, ' TUTTI', 1, '2014-05-07', '14:00:00', '15:30:00', 3, 1),
(15, 8, 'PAC DIAGNOSTICO 2', 116, 'SIGNORELLI MARIO', 63, 'ECOGRAFIA', 1, '2014-05-07', '14:00:00', '15:30:00', 4, 2),
(16, 46, 'Prenotazione Chemioterapie', 0, 'TUTTI', 0, ' TUTTI', 1, '2014-05-07', '08:00:00', '16:00:00', 0, 0),
(17, 354, 'SPARTA'' ANNA', 354, 'SPARTA'' ANNA', 59, 'GINECOLOGIA', 1, '2014-05-07', '10:30:00', '11:30:00', 2, 1),
(18, 52, 'TAC IN CONVENZIONE', 0, 'TUTTI', 65, ' TAC', 1, '2014-05-07', '12:00:00', '12:00:00', 2, 0);

-- --------------------------------------------------------

--
-- Dump dei dati per la tabella `ec_agende`
--

INSERT INTO `ec_agende` (`id`, `id_agenda_HTSAN`, `nome_agenda`, `id_servizio`, `nome_servizio`, `id_medico`, `nome_medico`, `tipo`, `id_modalita`, `stato`, `attiva_da`, `attiva_fino_a`) VALUES
(1, 173, 'AGENDA DOTT.SA SCRIMINACI', 0, 'PSICOLOGIA', 173, 'SCRIMINACI MARIA CARMELA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(2, 58, 'AMATO GABRIELLA', 0, 'ONCOEMATOLOGIA', 107, 'AMATO GABRIELLA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(3, 430, 'AMBULATORIO UROLOGIA', 0, 'UROLOGIA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(4, 186, 'ARRIGO ETTORE', 0, 'CHIRURGIA ONCOLOGICA AMB.', 186, 'ARRIGO ETTORE', '', 0, 1, '2014-05-13', '0000-00-00'),
(5, 166, 'BLANCO GIUSY', 0, 'ONCOLOGIA MEDICA', 166, 'BLANCO GIUSI', '', 0, 1, '2014-05-13', '0000-00-00'),
(6, 131, 'CALTAVUTURO (TAC/RX ESTERNI)', 65, 'TAC', 131, 'CALTAVUTURO CLAUDIA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(7, 2, 'CARDIOLOGIA AMBULATORIALE', 8, 'CARDIOLOGIA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(8, 42, 'CH.ONCOLOGICA PRIV. DR.FULLONE', 0, 'CHIRURGIA ONCOLOGICA', 111, 'FULLONE FRANCESCO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(9, 43, 'CH.ONCOLOGICA PRIV.DR.SALLUZZO', 0, 'CHIRURGIA ONCOLOGICA', 112, 'SALLUZZO SALVATORE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(10, 41, 'CH.TORACICA DR.ARRIGO PRIVATO', 0, 'CHIRURGIA TORACICA', 186, 'ARRIGO ETTORE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(11, 28, 'CHIR.ONCOLOGICA MEDICAZIONI', 0, 'CHIRURGIA ONCOLOGICA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(12, 27, 'CHIR.PLAST. MEDICAZIONI', 0, 'CHIRURGIA ONCOLOGICA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(13, 16, 'CHIRURGIA ONCOLOGICA', 0, 'CHIRURGIA ONCOLOGICA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(14, 6401, 'CHIRURGIA ONCOLOGICA', 0, 'CHIRURGIA ONCOLOGICA', 109, 'IUPPA ANTONIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(15, 5, 'CHIRURGIA TORACICA', 0, 'CHIRURGIA TORACICA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(16, 15, 'CHIRURGIA TORACICA', 0, 'CHIRURGIA TORACICA', 186, 'ARRIGO ETTORE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(17, 346, 'CICALA SALVATORE', 0, 'CHIRURGIA ONCOLOGICA AMB.', 346, 'CICALA SALVATORE', '', 0, 1, '2014-05-13', '0000-00-00'),
(18, 701, 'COPPOLINO SINIBALDO', 68, 'PNEUMOLOGIA', 701, 'COPPOLINO SINIBALDO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(19, 333, 'COSENTINO SALVATORE', 58, 'ENDOSCOPIA', 333, 'COSENTINO SALVATORE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(20, 3, 'CRINO''', 0, 'AMBULATORI', 3, 'CRINO'' LUCIO', '', 0, 1, '2014-05-13', '0000-00-00'),
(21, 25, 'CURE PALLIATIVE', 0, 'CURE PALLIATIVE', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(22, 34, 'CURE PALLIATIVE PRIVATO', 0, 'CURE PALLIATIVE', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(23, 203, 'DH TERAPIA INF. BREVE', 2, 'DAY HOSPITAL', 0, '', 'RICOVERI', 2, 1, '2014-05-13', '0000-00-00'),
(24, 201, 'DH TERAPIA INF. LUNGA', 2, 'DAY HOSPITAL', 0, '', 'RICOVERI', 2, 1, '2014-05-13', '0000-00-00'),
(25, 202, 'DH TERAPIA INF. MEDIA', 2, 'DAY HOSPITAL', 0, '', 'RICOVERI', 2, 1, '2014-05-13', '0000-00-00'),
(26, 369, 'DI MAURO SEBASTIANO', 75, 'DERMATOLOGIA', 369, 'DI MAURO SEBASTIANO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(27, 1, 'DIAG.IMM. AMBULATORIALE', 0, '', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(28, 10, 'DIETOLOGIA', 0, '', 0, 'SCARFIA ALESSIA GIUSEPPINA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(29, 12, 'EMATOLOGIA', 0, 'ONCOEMATOLOGIA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(30, 40, 'EMATOLOGIA PRIV.DR.SSA SCIRE''', 0, 'ONCOEMATOLOGIA', 345, 'SCIRE'' PAOLA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(31, 33, 'ENDOCRINOCHIRURGIA DR.IPPOLITO', 0, 'CHIRURGIA ONCOLOGICA', 398, 'IPPOLITO ORAZIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(32, 24, 'ENDOCRINOCHIRURGIA MEDICAZIONI', 0, 'CHIRURGIA ONCOLOGICA', 398, 'IPPOLITO ORAZIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(33, 366, 'FALCONE LORENZO', 0, 'UROLOGIA', 366, 'FALCONE LORENZO', '', 0, 1, '2014-05-13', '0000-00-00'),
(34, 30, 'FISIOTERAPIA', 0, '', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(35, 111, 'FULLONE FRANCESCO', 0, 'CHIRURGIA ONCOLOGICA', 111, 'FULLONE FRANCESCO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(36, 13, 'GINECOLOGIA', 0, '', 354, 'SPARTA'' ANNA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(37, 144, 'GIUFFRIDA (ENDOCRINOLOGIA)', 0, '', 145, 'GIUFFRIDA DARIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(38, 146, 'GIUFFRIDA (MATTINA)', 64, 'ONCOLOGIA AMBUL.', 145, 'GIUFFRIDA DARIO', '', 0, 1, '2014-05-13', '0000-00-00'),
(39, 145, 'GIUFFRIDA (POMERIGGIO)', 0, 'ONCOLOGIA MEDICA', 145, 'GIUFFRIDA DARIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(40, 171, 'GIUFFRIDA C.MAURIZIO (PRIVATO)', 0, 'NEUROCHIRURGIA', 171, 'GIUFFRIDA CARMELO MAURIZIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(41, 53, 'GIUFFRIDA CARMELO MAURIZIO', 0, 'NEUROCHIRURGIA', 171, 'GIUFFRIDA CARMELO MAURIZIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(42, 364, 'GIUSTOLISI ROSARIO', 0, 'ONCOEMATOLOGIA AMBULAT./REF.', 364, 'GIUSTOLISI ROSARIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(43, 114, 'GRASSO VINCENZO', 0, 'UROLOGIA', 114, 'GRASSO VINCENZO', '', 0, 1, '2014-05-13', '0000-00-00'),
(44, 161, 'IMPALLOMENI RAFFAELLO', 75, 'DERMATOLOGIA', 161, 'IMPALLOMENI RAFFAELLO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(45, 109, 'IUPPA ANTONINO', 0, 'CHIRURGIA ONCOLOGICA', 109, 'IUPPA ANTONIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(46, 14, 'IUPPA ANTONIO', 0, 'CHIRURGIA ONCOLOGICA', 109, 'IUPPA ANTONIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(47, 395, 'IUPPA GIUSEPPE', 0, 'CHIRURGIA ONCOLOGICA', 395, 'IUPPA GIUSEPPE', '', 0, 1, '2014-05-13', '0000-00-00'),
(48, 359, 'LENTINI GIUSEPPE', 0, 'OTORINOLARINGOIATRIA', 359, 'LENTINI GIUSEPPE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(49, 172, 'LIPERA MARIO', 0, 'CHIRURGIA ONCOLOGICA AMB.', 172, 'LIPERA MARIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(50, 165, 'MAFODDA ANTONINO', 64, 'ONCOLOGIA AMBUL.', 0, 'MAFODDA ANTONINO', 'AMBULATORIO (I+E', 1, 0, '2014-05-13', '0000-00-00'),
(51, 394, 'MAIO ROBERTA', 69, 'RADIOLOGIA', 394, 'MAIO ROBERTA FEDERICA', '', 0, 1, '2014-05-13', '0000-00-00'),
(52, 121, 'MAJORANA MARCELLO', 69, 'RADIOLOGIA', 121, 'MAJORANA MARCELLO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(53, 147, 'MARE MARZIA', 0, 'ONCOLOGIA MEDICA', 147, 'MARE MARZIA', '', 0, 1, '2014-05-13', '0000-00-00'),
(54, 123, 'MARTINO MASSIMO', 0, 'CURE PALLIATIVE', 123, 'MARTINO MASSIMO', '', 0, 1, '2014-05-13', '0000-00-00'),
(55, 175, 'MUNAO'' STEFANIA', 0, 'ONCOLOGIA MEDICA', 175, 'MUNAO'' STEFANIA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(56, 54, 'NEUROCHIRURGIA', 0, 'NEUROCHIRURGIA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(57, 661, 'ONCOEMATOLOGIA', 0, 'ONCOEMATOLOGIA AMBULAT./REF.', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(58, 35, 'ONCOEMATOLOGIA PRIVATO', 0, 'ONCOEMATOLOGIA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(59, 32, 'ONCOEMATOLOGIA PROF.GIUSTOLISI', 0, 'ONCOEMATOLOGIA', 364, 'GIUSTOLISI ROSARIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(60, 641, 'ONCOLOGIA AMBULATORIALE', 64, 'ONCOLOGIA AMBUL.', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(61, 23, 'ONCOLOGIA MEDICA', 0, 'ONCOLOGIA MEDICA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(62, 22, 'ORL', 0, 'OTORINOLARINGOIATRIA', 359, 'LENTINI GIUSEPPE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(63, 39, 'ORL PRIVATO', 0, 'OTORINOLARINGOIATRIA', 359, 'LENTINI GIUSEPPE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(64, 7, 'PAC DIAGNOSTICI D.I.', 0, '', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(65, 6, 'PAC DIAGNOSTICO 1', 0, '', 333, 'COSENTINO SALVATORE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(66, 8, 'PAC DIAGNOSTICO 2', 63, 'ECOGRAFIA', 116, 'SIGNORELLI MARIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(67, 9, 'PAC DIAGNOSTICO 3', 0, '', 121, 'MAJORANA MARCELLO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(68, 180, 'PIETRO PINO', 0, 'UROLOGIA', 180, 'PINO PIETRO', '', 0, 1, '2014-05-13', '0000-00-00'),
(69, 29, 'PNEUMOLOGIA', 0, '', 701, 'COPPOLINO SINIBALDO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(70, 393, 'PORRETTO CONCETTA MARIA', 0, '', 0, '', '', 0, 1, '2014-05-13', '0000-00-00'),
(71, 51, 'PRERICOVERI ANESTESIA', 0, '', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(72, 48, 'PRERICOVERI CARDIOLOGIA', 0, '', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(73, 49, 'PRERICOVERI RADIOLOGIA', 0, '', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(74, 47, 'PRERICOVERO VISITA', 0, '', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(75, 388, 'PRESTIFILIPPO ANGELA', 64, 'ONCOLOGIA AMBUL.', 388, 'PRESTIFILIPPO ANGELA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(76, 55, 'PREVENZIONE TIROIDE', 0, '', 64, 'RUSSO BARBARO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(77, 56, 'PULIAFITO IVANA', 0, 'ONCOLOGIA MEDICA', 715, 'PULIAFITO IVANA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(78, 46, 'Prenotazione Chemioterapie', 0, '', 0, '', 'RICOVERI', 2, 0, '2014-05-13', '0000-00-00'),
(79, 132, 'RANNO CRISTIAN', 0, 'UROLOGIA', 132, 'RANNO CHRISTIAN', '', 0, 1, '2014-05-13', '0000-00-00'),
(80, 195, 'RUGGERI LUCA', 0, '', 0, 'RUGGERI LUCA', 'AMBULATORIO (I+E', 1, 0, '2014-05-13', '0000-00-00'),
(81, 351, 'RUSSO ALESSIO', 69, 'RADIOLOGIA', 351, 'RUSSO ALESSIO', '', 0, 1, '2014-05-13', '0000-00-00'),
(82, 112, 'SALLUZZO SALVATORE', 0, 'CHIRURGIA ONCOLOGICA', 112, 'SALLUZZO SALVATORE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(83, 345, 'SCIRE'' PAOLA', 0, 'ONCOEMATOLOGIA', 345, 'SCIRE'' PAOLA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(84, 11, 'SENOLOGIA MEDICAZIONI', 0, 'BREAST UNIT', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(85, 45, 'SENOLOGIA PRIV. DR.LIPERA', 0, 'BREAST UNIT', 172, 'LIPERA MARIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(86, 44, 'SENOLOGICA PRIV. DR.CICALA', 0, 'BREAST UNIT', 346, 'CICALA SALVATORE', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(87, 116, 'SIGNORELLI MARIO', 63, 'ECOGRAFIA', 116, 'SIGNORELLI MARIO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(88, 354, 'SPARTA'' ANNA', 59, 'GINECOLOGIA', 354, 'SPARTA'' ANNA', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(89, 52, 'TAC IN CONVENZIONE', 65, 'TAC', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(90, 37, 'TERAPIA ANTALGICA PRIVATO', 0, 'TERAPIA ANTALGICA', 108, 'SGALAMBRO FRANCESCO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(91, 380, 'TROVATO SEBASTIANO', 0, '', 0, '', '', 0, 1, '2014-05-13', '0000-00-00'),
(92, 21, 'URODINAMICA', 0, 'UROLOGIA', 114, 'GRASSO VINCENZO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(93, 26, 'UROLOGIA', 0, 'UROLOGIA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(94, 18, 'UROLOGIA DR.FALCONE', 0, 'UROLOGIA', 366, 'FALCONE LORENZO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(95, 20, 'UROLOGIA DR.GRASSO', 0, 'UROLOGIA', 114, 'GRASSO VINCENZO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(96, 19, 'UROLOGIA DR.PINO', 0, 'UROLOGIA', 180, 'PINO PIETRO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(97, 17, 'UROLOGIA MEDICAZIONI', 0, 'UROLOGIA', 0, '', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(98, 31, 'UROLOGIA PRIVATO DR.FALCONE', 0, 'UROLOGIA', 366, 'FALCONE LORENZO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(99, 36, 'UROLOGIA PRIVATO DR.GRASSO', 0, 'UROLOGIA', 114, 'GRASSO VINCENZO', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00'),
(100, 38, 'UROLOGIA PRIVATO DR.RANNO', 0, 'UROLOGIA', 132, 'RANNO CHRISTIAN', 'AMBULATORIO (I+E', 1, 1, '2014-05-13', '0000-00-00');

-- --------------------------------------------------------


--
-- Dump dei dati per la tabella `ec_prenotazioni_dh_ambulatori`
--

INSERT INTO `ec_prenotazioni_dh_ambulatori` (`id`, `data`, `ora`, `nome_paziente`, `data_nascita`, `id_agenda`, `nome_agenda`, `accettato`) VALUES
(1, '2014-05-07', '11:40:00', '.', '0000-00-00', 2, 'CARDIOLOGIA AMBULATO', 0),
(2, '2014-05-07', '16:00:00', '.', '0000-00-00', 8, 'PAC DIAGNOSTICO 2', 0),
(3, '2014-05-07', '07:35:00', 'ADAMO ANNUNZIATA', '1968-11-13', 203, 'DH TERAPIA INF. BREV', 0),
(4, '2014-05-07', '07:45:00', 'ADORNETTO AGATA', '1945-05-28', 202, 'DH TERAPIA INF. MEDI', 0),
(5, '2014-05-07', '10:00:00', 'AIELLO CARMELO', '0000-00-00', 131, 'CALTAVUTURO (TAC/RX', 0),
(6, '2014-05-07', '18:40:00', 'ALBA MARIA AGATA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(7, '2014-05-07', '17:15:00', 'ALFERI SALVATORE', '0000-00-00', 161, 'IMPALLOMENI RAFFAELL', 0),
(8, '2014-05-07', '18:15:00', 'ALFERI SALVATORE', '1936-07-07', 145, 'GIUFFRIDA (POMERIGGI', 0),
(9, '2014-05-07', '17:20:00', 'ANDRONACO CAMILLA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(10, '2014-05-07', '09:15:00', 'ARENA CONCETTA FRANCESCA', '0000-00-00', 161, 'IMPALLOMENI RAFFAELL', 0),
(11, '2014-05-07', '12:00:00', 'ATTARDI BRUNA MARIA', '1987-12-31', 161, 'IMPALLOMENI RAFFAELL', 0),
(12, '2014-05-07', '12:30:00', 'ATTARDI MARILEA BARBARA', '1985-04-26', 161, 'IMPALLOMENI RAFFAELL', 0),
(13, '2014-05-07', '12:20:00', 'BAELI VALERIA', '1974-11-09', 2, 'CARDIOLOGIA AMBULATO', 0),
(14, '2014-05-07', '13:00:00', 'BAELI VALERIA', '1974-11-09', 7, 'PAC DIAGNOSTICI D.I.', 0),
(15, '2014-05-07', '15:00:00', 'BAELI VALERIA', '1974-11-09', 8, 'PAC DIAGNOSTICO 2', 0),
(16, '2014-05-07', '11:20:00', 'BALSAMO SANTA', '1969-07-25', 641, 'ONCOLOGIA AMBULATORI', 0),
(17, '2014-05-07', '16:00:00', 'BARBARINO LAURA', '0000-00-00', 145, 'GIUFFRIDA (POMERIGGI', 0),
(18, '2014-05-07', '15:00:00', 'BARCELLA SANTO DOMENICO', '0000-00-00', 145, 'GIUFFRIDA (POMERIGGI', 0),
(19, '2014-05-07', '07:45:00', 'BARTOLUCCI NUNZIA', '1933-03-25', 203, 'DH TERAPIA INF. BREV', 0),
(20, '2014-05-07', '18:30:00', 'BATTIATO ANGELA', '1946-02-18', 145, 'GIUFFRIDA (POMERIGGI', 0),
(21, '2014-05-07', '10:45:00', 'BELLA MARIA', '1937-01-16', 641, 'ONCOLOGIA AMBULATORI', 0),
(22, '2014-05-07', '07:30:00', 'BILARDO GIUSEPPA', '1960-02-04', 203, 'DH TERAPIA INF. BREV', 0),
(23, '2014-05-07', '17:00:00', 'BONACCORSO AGATA', '1944-11-18', 121, 'MAJORANA MARCELLO', 0),
(24, '2014-05-07', '16:30:00', 'CALOGERO KATYA', '0000-00-00', 145, 'GIUFFRIDA (POMERIGGI', 0),
(25, '2014-05-07', '15:45:00', 'CAPIZZI GIUSEPPA', '1960-02-09', 145, 'GIUFFRIDA (POMERIGGI', 0),
(26, '2014-05-07', '11:00:00', 'CAPPUCCIO EMILIA', '1948-05-27', 146, 'GIUFFRIDA (MATTINA)', 0),
(27, '2014-05-07', '11:15:00', 'CARUSO MARIA CONCETTA', '0000-00-00', 146, 'GIUFFRIDA (MATTINA)', 0),
(28, '2014-05-07', '19:00:00', 'CASILE FORTUNATO', '1949-07-23', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(29, '2014-05-07', '11:30:00', 'CATANIA MARIA', '0000-00-00', 354, 'SPARTA'' ANNA', 0),
(30, '2014-05-07', '07:55:00', 'CAVALLARO ALFIA FRANCESC', '0000-00-00', 203, 'DH TERAPIA INF. BREV', 0),
(31, '2014-05-07', '17:45:00', 'CHIARAMIDA DOMENICO', '1941-07-08', 145, 'GIUFFRIDA (POMERIGGI', 0),
(32, '2014-05-07', '16:20:00', 'CICERONE CLARA', '0000-00-00', 121, 'MAJORANA MARCELLO', 0),
(33, '2014-05-07', '12:40:00', 'CONTICELLO MARIA GRAZIA', '1960-01-05', 641, 'ONCOLOGIA AMBULATORI', 0),
(34, '2014-05-07', '11:30:00', 'CORSARO GIOVANNI', '1957-11-01', 146, 'GIUFFRIDA (MATTINA)', 0),
(35, '2014-05-07', '09:30:00', 'CRISTALDI ALFIO', '1933-10-23', 161, 'IMPALLOMENI RAFFAELL', 0),
(36, '2014-05-07', '07:50:00', 'CUCUZZA VINCENZO', '1937-04-12', 203, 'DH TERAPIA INF. BREV', 0),
(37, '2014-05-07', '17:00:00', 'D''URSO GREGORIO', '1946-09-07', 145, 'GIUFFRIDA (POMERIGGI', 0),
(38, '2014-05-07', '12:15:00', 'DE NATALE', '0000-00-00', 146, 'GIUFFRIDA (MATTINA)', 0),
(39, '2014-05-07', '11:15:00', 'DI DIO CLELIA', '0000-00-00', 161, 'IMPALLOMENI RAFFAELL', 0),
(40, '2014-05-07', '16:45:00', 'DI MARCO FRANCESCA', '1944-08-28', 145, 'GIUFFRIDA (POMERIGGI', 0),
(41, '2014-05-07', '11:00:00', 'DI MARI ANTONINO', '1966-09-08', 333, 'COSENTINO SALVATORE', 0),
(42, '2014-05-07', '12:30:00', 'DI STEFANO', '0000-00-00', 146, 'GIUFFRIDA (MATTINA)', 0),
(43, '2014-05-07', '12:00:00', 'DOTT. SAMMATRICE', '0000-00-00', 146, 'GIUFFRIDA (MATTINA)', 0),
(44, '2014-05-07', '08:15:00', 'FAZIO GIUSEPPE', '1952-04-13', 203, 'DH TERAPIA INF. BREV', 0),
(45, '2014-05-07', '11:00:00', 'FERRARO NICOLETTA', '1925-03-08', 641, 'ONCOLOGIA AMBULATORI', 0),
(46, '2014-05-07', '16:30:00', 'FINOCCHIARO MARIA LUISA', '0000-00-00', 701, 'COPPOLINO SINIBALDO', 0),
(47, '2014-05-07', '11:40:00', 'FROSINA VINCENZA', '1946-02-20', 641, 'ONCOLOGIA AMBULATORI', 0),
(48, '2014-05-07', '16:00:00', 'FURNARI GAETANO', '0000-00-00', 701, 'COPPOLINO SINIBALDO', 0),
(49, '2014-05-07', '10:30:00', 'GIUFRE'' FORTUNATINA', '1960-12-04', 333, 'COSENTINO SALVATORE', 0),
(50, '2014-05-07', '11:30:00', 'GRASSO MARIA ANGELA', '1962-11-01', 2, 'CARDIOLOGIA AMBULATO', 0),
(51, '2014-05-07', '12:30:00', 'GRASSO MARIA ANGELA', '1962-11-01', 7, 'PAC DIAGNOSTICI D.I.', 0),
(52, '2014-05-07', '15:30:00', 'GRASSO MARIA ANGELA', '1962-11-01', 8, 'PAC DIAGNOSTICO 2', 0),
(53, '2014-05-07', '17:00:00', 'GUGLIELMINO ROSARIA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(54, '2014-05-07', '11:00:00', 'GULINA MARIA ANNA', '1940-02-24', 161, 'IMPALLOMENI RAFFAELL', 0),
(55, '2014-05-07', '12:20:00', 'GUTTA'' RITA NATALA', '1969-05-17', 641, 'ONCOLOGIA AMBULATORI', 0),
(56, '2014-05-07', '08:20:00', 'GUZZARDI ARTURO', '1951-10-14', 203, 'DH TERAPIA INF. BREV', 0),
(57, '2014-05-07', '15:15:00', 'INDRIOLO GIORGIA', '0000-00-00', 145, 'GIUFFRIDA (POMERIGGI', 0),
(58, '2014-05-07', '18:00:00', 'IRACI SARERI GIACOMO', '0000-00-00', 145, 'GIUFFRIDA (POMERIGGI', 0),
(59, '2014-05-07', '16:00:00', 'LA ROSA ROSARIA', '0000-00-00', 161, 'IMPALLOMENI RAFFAELL', 0),
(60, '2014-05-07', '16:15:00', 'LA SPINA DOMENICA', '0000-00-00', 161, 'IMPALLOMENI RAFFAELL', 0),
(61, '2014-05-07', '14:45:00', 'LAUDANI ANGELA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(62, '2014-05-07', '18:00:00', 'LEONE ANTONELLO', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(63, '2014-05-07', '15:15:00', 'LEONE MARTINA', '0000-00-00', 161, 'IMPALLOMENI RAFFAELL', 0),
(64, '2014-05-07', '08:25:00', 'LOMBARDO VINCENZA', '1963-11-14', 203, 'DH TERAPIA INF. BREV', 0),
(65, '2014-05-07', '15:00:00', 'LONGO ANTONININA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(66, '2014-05-07', '15:10:00', 'LUCA LIMONE', '0000-00-00', 641, 'ONCOLOGIA AMBULATORI', 0),
(67, '2014-05-07', '08:05:00', 'MAGRA NINETTA', '1949-12-19', 203, 'DH TERAPIA INF. BREV', 0),
(68, '2014-05-07', '17:40:00', 'MALATESTA CARMELA', '1954-04-12', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(69, '2014-05-07', '14:15:00', 'MARINO ANTONELLA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(70, '2014-05-07', '11:30:00', 'MESSINA GAETANO', '1951-07-23', 52, 'TAC IN CONVENZIONE', 0),
(71, '2014-05-07', '16:00:00', 'MONSONE LOREDANA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(72, '2014-05-07', '16:30:00', 'MOTTA DAVIDE ANTONINO', '1978-09-24', 161, 'IMPALLOMENI RAFFAELL', 0),
(73, '2014-05-07', '10:00:00', 'MURATORE CARMELA', '0000-00-00', 333, 'COSENTINO SALVATORE', 0),
(74, '2014-05-07', '16:00:00', 'MUSUMECI ALDO', '2002-01-03', 161, 'IMPALLOMENI RAFFAELL', 0),
(75, '2014-05-07', '16:30:00', 'MUSUMECI GIULIA', '2004-07-07', 161, 'IMPALLOMENI RAFFAELL', 0),
(76, '2014-05-07', '17:00:00', 'MUSUMECI MATTEO', '0000-00-00', 161, 'IMPALLOMENI RAFFAELL', 0),
(77, '2014-05-07', '19:00:00', 'NARCISI CARMELA', '0000-00-00', 145, 'GIUFFRIDA (POMERIGGI', 0),
(78, '2014-05-07', '15:30:00', 'NASTASI AGATINO', '0000-00-00', 145, 'GIUFFRIDA (POMERIGGI', 0),
(79, '2014-05-07', '17:00:00', 'NICOLOSI GRAZIELLA', '0000-00-00', 701, 'COPPOLINO SINIBALDO', 0),
(80, '2014-05-07', '17:30:00', 'NICOTRA LEONARDO', '2002-06-13', 161, 'IMPALLOMENI RAFFAELL', 0),
(81, '2014-05-07', '16:40:00', 'PALAZZOLO LUCIA', '1946-06-18', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(82, '2014-05-07', '11:30:00', 'PANARELLO ADALGISA', '1954-03-23', 161, 'IMPALLOMENI RAFFAELL', 0),
(83, '2014-05-07', '07:35:00', 'PENNISI SANTA', '1934-01-08', 202, 'DH TERAPIA INF. MEDI', 0),
(84, '2014-05-07', '17:15:00', 'PENRNICE FRANCESCO', '0000-00-00', 145, 'GIUFFRIDA (POMERIGGI', 0),
(85, '2014-05-07', '17:30:00', 'POLITI MARIA FRANCESCA', '1938-10-04', 145, 'GIUFFRIDA (POMERIGGI', 0),
(86, '2014-05-07', '07:40:00', 'PRIVITERA LUCIA', '1964-06-30', 203, 'DH TERAPIA INF. BREV', 0),
(87, '2014-05-07', '16:40:00', 'PULVIRENTI MARIA CLARA', '0000-00-00', 121, 'MAJORANA MARCELLO', 0),
(88, '2014-05-07', '14:30:00', 'RAPISARDA FRANCESCO', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(89, '2014-05-07', '10:30:00', 'ROSTA ELISA', '1982-04-08', 354, 'SPARTA'' ANNA', 0),
(90, '2014-05-07', '12:00:00', 'RUSSO DOROTEA', '1936-10-12', 641, 'ONCOLOGIA AMBULATORI', 0),
(91, '2014-05-07', '07:30:00', 'SANTITTO SALVATORE', '1940-02-05', 202, 'DH TERAPIA INF. MEDI', 0),
(92, '2014-05-07', '07:40:00', 'SAPIENZA MARIA', '1930-11-18', 202, 'DH TERAPIA INF. MEDI', 0),
(93, '2014-05-07', '15:20:00', 'SARRI'' FIORENZA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(94, '2014-05-07', '08:30:00', 'SCACCIANOCE GIUSEPPE', '1940-05-25', 203, 'DH TERAPIA INF. BREV', 0),
(95, '2014-05-07', '18:20:00', 'SCACCIANOCE MARIA CONCET', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(96, '2014-05-07', '16:20:00', 'SCHEMBARI CONCETTA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(97, '2014-05-07', '15:00:00', 'SCIBILIA ANGELA', '1930-07-18', 121, 'MAJORANA MARCELLO', 0),
(98, '2014-05-07', '15:00:00', 'SCIUTO AGATA', '1971-09-20', 161, 'IMPALLOMENI RAFFAELL', 0),
(99, '2014-05-07', '08:00:00', 'SEMINARA MARIA', '1957-12-05', 203, 'DH TERAPIA INF. BREV', 0),
(100, '2014-05-07', '08:10:00', 'SICILIA CATERINA', '1956-10-04', 203, 'DH TERAPIA INF. BREV', 0),
(101, '2014-05-07', '15:30:00', 'STOP PRENOTAZIONI', '0000-00-00', 641, 'ONCOLOGIA AMBULATORI', 0),
(102, '2014-05-07', '15:00:00', 'STULLA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(103, '2014-05-07', '10:30:00', 'TUMINO SALVATORE', '1970-08-20', 2, 'CARDIOLOGIA AMBULATO', 0),
(104, '2014-05-07', '11:00:00', 'TUMINO SALVATORE', '1970-08-20', 52, 'TAC IN CONVENZIONE', 0),
(105, '2014-05-07', '10:30:00', 'TURONE TERESA', '1974-01-12', 161, 'IMPALLOMENI RAFFAELL', 0),
(106, '2014-05-07', '16:15:00', 'VACCALLUZZO SERAFINO', '1941-01-18', 145, 'GIUFFRIDA (POMERIGGI', 0),
(107, '2014-05-07', '09:00:00', 'VALASTRO ANGELO', '0000-00-00', 161, 'IMPALLOMENI RAFFAELL', 0),
(108, '2014-05-07', '12:00:00', 'VECCHIA VITTORIO UMBERTO', '1938-01-02', 7, 'PAC DIAGNOSTICI D.I.', 0),
(109, '2014-05-07', '12:00:00', 'VECCHIA VITTORIO UMBERTO', '1938-01-02', 2, 'CARDIOLOGIA AMBULATO', 0),
(110, '2014-05-07', '14:00:00', 'VECCHIA VITTORIO UMBERTO', '1938-01-02', 8, 'PAC DIAGNOSTICO 2', 0),
(111, '2014-05-07', '15:40:00', 'VELLA SIMONA', '0000-00-00', 144, 'GIUFFRIDA (ENDOCRINO', 0),
(112, '2014-05-07', '15:30:00', 'VITTORIO CARMELA', '0000-00-00', 701, 'COPPOLINO SINIBALDO', 0),
(113, '2014-05-07', '17:20:00', 'ZAPPALA'' ELISA ROBERTA', '0000-00-00', 121, 'MAJORANA MARCELLO', 0),
(114, '2014-05-07', '11:30:00', 'ZWART CORNELIA', '0000-00-00', 333, 'COSENTINO SALVATORE', 0);

-- --------------------------------------------------------

--
-- Dump dei dati per la tabella `ec_prenotazioni_ricoveri`
--

INSERT INTO `ec_prenotazioni_ricoveri` (`id`, `data`, `ora`, `nome_paziente`, `regime`, `reparto`, `id_medico`, `accettato`) VALUES
(1, '2014-05-07', '07:00:00', 'vBILARDO GIUSEPPA', 'DH', 'DAY HOSPITAL', 1, '0'),
(2, '2014-05-07', '09:00:00', 'vDEL MORO GIOVANNI', 'ORD', 'TMO', 0, '0'),
(3, '2014-05-07', '09:00:00', 'vSELMI GIUSEPPA', 'ORD', 'ONCOLOGIA MEDICA', 145, '0'),
(4, '2014-05-07', '09:00:00', 'vLEONARDI GAETANA', 'ORD', 'ONCOLOGIA MEDICA', 145, '0');

-- --------------------------------------------------------


--
-- Dump dei dati per la tabella `ec_servizi`
--

INSERT INTO `ec_servizi` (`id`, `id_servizio_HTSAN`, `nome_servizio`) VALUES
(1, 2, 'DAY HOSPITAL'),
(2, 201, 'DAY SURGERY'),
(3, 203, 'UROLOGIA D.H.'),
(4, 204, 'ONCOEMATOLOGIA D.H.'),
(5, 3, 'ANATOMIA PATOLOGICA'),
(6, 5, 'ANGIOLOGIA'),
(7, 8, 'CARDIOLOGIA'),
(8, 120, 'IORT'),
(9, 18, 'EMOTRASFUSIONE'),
(10, 30, 'NEUROCHIRURGIA'),
(11, 34, 'OCULISTICA'),
(12, 38, 'OTORINOLARINGOIATRIA'),
(13, 3801, 'MICROCHIRURGIA ORL'),
(14, 43, 'UROLOGIA'),
(15, 4301, 'LITOTRISSIA'),
(16, 49, 'TERAPIA INTENSIVA'),
(17, 50, 'ANESTESIA/TERAP.ANTALGICA AMB.'),
(18, 56, 'RECUPERO E RIABILITAZIONE'),
(19, 58, 'ENDOSCOPIA'),
(20, 59, 'GINECOLOGIA'),
(21, 61, 'MEDICINA NUCLEARE'),
(22, 63, 'ECOGRAFIA'),
(23, 631, 'ECOGRAFIA DR.RIZZO'),
(24, 64, 'ONCOLOGIA AMBUL.'),
(25, 6400, 'ONCOLOGIA MEDICA'),
(26, 6401, 'CHIRURGIA ONCOLOGICA'),
(27, 6402, 'RADIOTERAPIA'),
(28, 6403, 'TERAPIA ANTALGICA'),
(29, 6404, 'ONCOEMATOLOGIA'),
(30, 6405, 'TMO'),
(31, 6406, 'CHIRURGIA TORACICA'),
(32, 6410, 'CHIRURGIA ONCOLOGICA AMB.'),
(33, 6411, 'BREAST UNIT'),
(34, 6433, 'CURE PALLIATIVE'),
(35, 65, 'TAC'),
(36, 66, 'ONCOEMATOLOGIA AMBULAT./REF.'),
(37, 67, 'RMN'),
(38, 68, 'PNEUMOLOGIA'),
(39, 69, 'RADIOLOGIA'),
(40, 6901, 'RADIOLOGIA INTERVENTISTICA'),
(41, 70, 'LABORATORIO ANALISI'),
(42, 7001, 'CITOFLUORIMETRIA'),
(43, 75, 'DERMATOLOGIA'),
(44, 76, 'ORTOPEDIA ONCOLOGICA'),
(45, 90, 'AMMINISTRAZIONE'),
(46, 901, 'AMBULATORI'),
(47, 902, 'SERVIZIO DIAGNOSTICA DH ONCOL.'),
(48, 91, 'CUCINA'),
(49, 94, 'PSICOLOGIA'),
(50, 95, 'SERVIZIO SOCIALE'),
(51, 96, 'SCREENING POLMONE'),
(52, 97, 'SCREENING TIROIDEO');