5qzrcm3k

· 8 years ago · Aug 01, 2018, 04:20 AM
1USE [master]
2GO
3/****** Object:  Database [qa_apj_api]    Script Date: 31/07/2018 11:15:41 p.m. ******/
4CREATE DATABASE [qa_apj_api]
5 CONTAINMENT = NONE
6 ON  PRIMARY 
7( NAME = N'qa_apj_api', FILENAME = N'D:\SQL\qa_apj_api.mdf' , SIZE = 1112064KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
8 LOG ON 
9( NAME = N'qa_apj_api_log', FILENAME = N'D:\SQL\qa_apj_api_log.ldf' , SIZE = 20096KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
10GO
11ALTER DATABASE [qa_apj_api] SET COMPATIBILITY_LEVEL = 110
12GO
13IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
14begin
15EXEC [qa_apj_api].[dbo].[sp_fulltext_database] @action = 'enable'
16end
17GO
18ALTER DATABASE [qa_apj_api] SET ANSI_NULL_DEFAULT OFF 
19GO
20ALTER DATABASE [qa_apj_api] SET ANSI_NULLS OFF 
21GO
22ALTER DATABASE [qa_apj_api] SET ANSI_PADDING OFF 
23GO
24ALTER DATABASE [qa_apj_api] SET ANSI_WARNINGS OFF 
25GO
26ALTER DATABASE [qa_apj_api] SET ARITHABORT OFF 
27GO
28ALTER DATABASE [qa_apj_api] SET AUTO_CLOSE OFF 
29GO
30ALTER DATABASE [qa_apj_api] SET AUTO_CREATE_STATISTICS ON 
31GO
32ALTER DATABASE [qa_apj_api] SET AUTO_SHRINK OFF 
33GO
34ALTER DATABASE [qa_apj_api] SET AUTO_UPDATE_STATISTICS ON 
35GO
36ALTER DATABASE [qa_apj_api] SET CURSOR_CLOSE_ON_COMMIT OFF 
37GO
38ALTER DATABASE [qa_apj_api] SET CURSOR_DEFAULT  GLOBAL 
39GO
40ALTER DATABASE [qa_apj_api] SET CONCAT_NULL_YIELDS_NULL OFF 
41GO
42ALTER DATABASE [qa_apj_api] SET NUMERIC_ROUNDABORT OFF 
43GO
44ALTER DATABASE [qa_apj_api] SET QUOTED_IDENTIFIER OFF 
45GO
46ALTER DATABASE [qa_apj_api] SET RECURSIVE_TRIGGERS OFF 
47GO
48ALTER DATABASE [qa_apj_api] SET  DISABLE_BROKER 
49GO
50ALTER DATABASE [qa_apj_api] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
51GO
52ALTER DATABASE [qa_apj_api] SET DATE_CORRELATION_OPTIMIZATION OFF 
53GO
54ALTER DATABASE [qa_apj_api] SET TRUSTWORTHY OFF 
55GO
56ALTER DATABASE [qa_apj_api] SET ALLOW_SNAPSHOT_ISOLATION OFF 
57GO
58ALTER DATABASE [qa_apj_api] SET PARAMETERIZATION SIMPLE 
59GO
60ALTER DATABASE [qa_apj_api] SET READ_COMMITTED_SNAPSHOT OFF 
61GO
62ALTER DATABASE [qa_apj_api] SET HONOR_BROKER_PRIORITY OFF 
63GO
64ALTER DATABASE [qa_apj_api] SET RECOVERY FULL 
65GO
66ALTER DATABASE [qa_apj_api] SET  MULTI_USER 
67GO
68ALTER DATABASE [qa_apj_api] SET PAGE_VERIFY CHECKSUM  
69GO
70ALTER DATABASE [qa_apj_api] SET DB_CHAINING OFF 
71GO
72ALTER DATABASE [qa_apj_api] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
73GO
74ALTER DATABASE [qa_apj_api] SET TARGET_RECOVERY_TIME = 0 SECONDS 
75GO
76EXEC sys.sp_db_vardecimal_storage_format N'qa_apj_api', N'ON'
77GO
78USE [qa_apj_api]
79GO
80/****** Object:  Schema [m2ss]    Script Date: 31/07/2018 11:15:41 p.m. ******/
81CREATE SCHEMA [m2ss]
82GO
83/****** Object:  StoredProcedure [dbo].[work_proc_citas]    Script Date: 31/07/2018 11:15:41 p.m. ******/
84SET ANSI_NULLS ON
85GO
86SET QUOTED_IDENTIFIER ON
87GO
88CREATE PROCEDURE [dbo].[work_proc_citas]
89AS
90BEGIN
91	BEGIN TRY
92		IF (SELECT COUNT(1) FROM work_cita) = 0
93		BEGIN
94			RETURN
95		END
96		
97		DECLARE @Fecha AS DATETIME
98		SELECT @Fecha = GETDATE()
99		
100		UPDATE W
101		SET accion = 'N',
102			mensaje = 'El horario no existe'
103		FROM work_cita W
104		LEFT JOIN horario M ON W.horario_id_spring = M.id_spring
105		WHERE M.id_spring IS NULL
106		
107		UPDATE W
108		SET accion = 'A'
109		FROM work_cita W
110		INNER JOIN cita M ON W.id_spring = M.id_spring
111		WHERE accion = 'I'
112
113		--ActualizaciÃ³n
114		UPDATE M
115		SET
116			M.horario_id_spring = W.horario_id_spring,
117			M.fecha_cita = W.fecha_cita,
118			M.turno = W.turno,
119			M.paciente_id_spring = W.paciente_id_spring,
120			M.fecha_registro = W.fecha_registro,
121			M.origen_registro = W.origen_registro,
122			M.estatus_pago = W.estatus_pago,
123			M.estatus = W.estatus
124		FROM cita M
125		INNER JOIN work_cita W ON M.id_spring = W.id_spring AND W.accion = 'A'
126		
127		UPDATE work_cita
128		SET mensaje = 'Cita actualizada.'
129		WHERE accion = 'A'
130		
131		--InserciÃ³n		
132		INSERT INTO cita
133			(id_spring,
134			horario_id_spring,
135			fecha_cita,
136			turno,
137			paciente_id_spring,
138			fecha_registro,
139			origen_registro,
140			estatus_pago,
141			estatus)
142		SELECT DISTINCT
143			W.id_spring,
144			W.horario_id_spring,
145			W.fecha_cita,
146			W.turno,
147			W.paciente_id_spring,
148			W.fecha_registro,
149			W.origen_registro,
150			W.estatus_pago,
151			W.estatus
152		FROM work_cita W
153		WHERE W.accion = 'I'
154		
155		UPDATE work_cita
156		SET mensaje = 'Cita insertada.'
157		WHERE accion = 'I'
158		
159		--Pasar a histÃ³rico		
160		INSERT INTO migracion_cita
161			(id_spring,
162			horario_id_spring,
163			fecha_cita,
164			turno,
165			paciente_id_spring,
166			fecha_registro,
167			origen_registro,
168			estatus_pago,
169			estatus,
170			fecha_sincronizacion,
171			mensaje)
172		SELECT
173			id_spring,
174			horario_id_spring,
175			fecha_cita,
176			turno,
177			paciente_id_spring,
178			fecha_registro,
179			origen_registro,
180			estatus_pago,
181			estatus,
182			@Fecha,
183			mensaje
184		FROM work_cita
185		
186		UPDATE work_sincronizacion
187		SET fecha_sincronizacion = @Fecha
188		where tipo_sincronizacion = 'citas'
189	END TRY
190	BEGIN CATCH
191		DECLARE @ErrorMessage NVARCHAR(4000);  
192		DECLARE @ErrorSeverity INT;  
193		DECLARE @ErrorState INT;  
194
195		SELECT   
196			@ErrorMessage = ERROR_MESSAGE(),
197			@ErrorSeverity = ERROR_SEVERITY(),
198			@ErrorState = ERROR_STATE();
199			
200		RAISERROR (@ErrorMessage,
201				   @ErrorSeverity,
202				   @ErrorState);  
203	END CATCH
204END
205GO
206/****** Object:  StoredProcedure [dbo].[work_proc_clinica_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
207SET ANSI_NULLS ON
208GO
209SET QUOTED_IDENTIFIER ON
210GO
211CREATE PROCEDURE [dbo].[work_proc_clinica_especialidad]
212AS
213BEGIN
214	BEGIN TRY
215		IF (SELECT COUNT(1) FROM work_clinica_especialidad) = 0
216		BEGIN
217			RETURN
218		END
219		
220		TRUNCATE TABLE clinica_especialidad
221		
222		DECLARE @Fecha AS DATETIME
223		SELECT @Fecha = GETDATE()
224		
225		UPDATE W
226		SET mensaje = 'La especialidad no existe'
227		FROM work_clinica_especialidad W
228		LEFT JOIN especialidad M ON W.especialidad_id_spring = M.id_spring
229		WHERE M.id_spring IS NULL
230		
231		UPDATE W
232		SET mensaje = 'La clinica no existe'
233		FROM work_clinica_especialidad W
234		LEFT JOIN clinica M ON W.clinica_id_spring = M.id_spring
235		WHERE M.id_spring IS NULL
236		
237		--InserciÃ³n		
238		INSERT INTO clinica_especialidad
239			(especialidad_id_spring
240			,clinica_id_spring)
241		SELECT
242			 W.especialidad_id_spring
243			,W.clinica_id_spring
244		FROM work_clinica_especialidad W
245		WHERE W.mensaje = ''
246		
247		UPDATE work_clinica_especialidad
248		SET mensaje = 'Registro insertado.'
249		WHERE mensaje = ''
250		
251		--Pasar a histÃ³rico
252		
253		INSERT INTO migracion_clinica_especialidad
254			(especialidad_id_spring
255			,clinica_id_spring
256			,fecha_sincronizacion
257			,mensaje)
258		SELECT
259			 especialidad_id_spring
260			,clinica_id_spring
261			,@Fecha
262			,mensaje
263		FROM work_clinica_especialidad
264		
265		UPDATE work_sincronizacion
266		SET fecha_sincronizacion = @Fecha
267		where tipo_sincronizacion = 'clinica_especialidad'
268	END TRY
269	BEGIN CATCH
270		DECLARE @ErrorMessage NVARCHAR(4000);  
271		DECLARE @ErrorSeverity INT;  
272		DECLARE @ErrorState INT;  
273
274		SELECT   
275			@ErrorMessage = ERROR_MESSAGE(),
276			@ErrorSeverity = ERROR_SEVERITY(),
277			@ErrorState = ERROR_STATE();
278			
279		RAISERROR (@ErrorMessage,
280				   @ErrorSeverity,
281				   @ErrorState);  
282	END CATCH
283END
284GO
285/****** Object:  StoredProcedure [dbo].[work_proc_clinica_medico]    Script Date: 31/07/2018 11:15:41 p.m. ******/
286SET ANSI_NULLS ON
287GO
288SET QUOTED_IDENTIFIER ON
289GO
290CREATE PROCEDURE [dbo].[work_proc_clinica_medico]
291AS
292BEGIN
293	BEGIN TRY
294		IF (SELECT COUNT(1) FROM work_clinica_medico) = 0
295		BEGIN
296			RETURN
297		END
298		
299		DECLARE @Fecha AS DATETIME
300		SELECT @Fecha = GETDATE()
301		
302		UPDATE W
303		SET accion = 'N',
304			mensaje = 'El mÃ©dico no existe'
305		FROM work_clinica_medico W
306		LEFT JOIN medico M ON W.medico_id_spring = M.id_spring
307		WHERE M.id_spring IS NULL
308		
309		UPDATE W
310		SET accion = 'N',
311			mensaje = 'La clinica no existe'
312		FROM work_clinica_medico W
313		LEFT JOIN clinica M ON W.clinica_id_spring = M.id_spring
314		WHERE M.id_spring IS NULL
315		
316		UPDATE work_clinica_medico
317		SET accion = 'N',
318			mensaje = 'Registro no considerado (Estado no activo)'
319		WHERE estado <> 2
320		
321		UPDATE W
322		SET accion = 'N',
323			mensaje = 'El registro ya existÃa'
324		FROM work_clinica_medico W
325		INNER JOIN clinica_medico M ON W.medico_id_spring = M.medico_id_spring AND W.clinica_id_spring = M.clinica_id_spring
326		
327		--InserciÃ³n		
328		INSERT INTO clinica_medico
329			(medico_id_spring
330			,clinica_id_spring)
331		SELECT
332			 W.medico_id_spring
333			,W.clinica_id_spring
334		FROM work_clinica_medico W
335		WHERE W.accion = 'I'
336		
337		UPDATE work_clinica_medico
338		SET mensaje = 'Registro insertado.'
339		WHERE accion = 'I'
340		
341		--Pasar a histÃ³rico
342		
343		INSERT INTO migracion_clinica_medico
344			(medico_id_spring
345			,clinica_id_spring
346			,estado
347			,fecha_sincronizacion
348			,mensaje)
349		SELECT
350			 medico_id_spring
351			,clinica_id_spring
352			,estado
353			,@Fecha
354			,mensaje
355		FROM work_clinica_medico
356		
357		UPDATE work_sincronizacion
358		SET fecha_sincronizacion = @Fecha
359		where tipo_sincronizacion = 'medico_clinica'
360	END TRY
361	BEGIN CATCH
362		DECLARE @ErrorMessage NVARCHAR(4000);  
363		DECLARE @ErrorSeverity INT;  
364		DECLARE @ErrorState INT;  
365
366		SELECT   
367			@ErrorMessage = ERROR_MESSAGE(),
368			@ErrorSeverity = ERROR_SEVERITY(),
369			@ErrorState = ERROR_STATE();
370			
371		RAISERROR (@ErrorMessage,
372				   @ErrorSeverity,
373				   @ErrorState);  
374	END CATCH
375END
376GO
377/****** Object:  StoredProcedure [dbo].[work_proc_consultorios]    Script Date: 31/07/2018 11:15:41 p.m. ******/
378SET ANSI_NULLS ON
379GO
380SET QUOTED_IDENTIFIER ON
381GO
382CREATE PROCEDURE [dbo].[work_proc_consultorios]
383AS
384BEGIN
385	BEGIN TRY
386		IF (SELECT COUNT(1) FROM work_consultorio) = 0
387		BEGIN
388			RETURN
389		END
390		
391		DECLARE @Fecha AS DATETIME
392		SELECT @Fecha = GETDATE()
393		
394		UPDATE W
395		SET accion = 'N',
396			mensaje = 'RelaciÃ³n con clÃnica incorrecta'
397		FROM work_consultorio W
398		LEFT JOIN clinica C ON W.clinica_id_spring = C.id_spring
399		WHERE C.id_spring IS NULL
400		
401		UPDATE W
402		SET accion = 'A'
403		FROM work_consultorio W
404		INNER JOIN consultorio M ON W.id_spring = M.id_spring
405		WHERE accion = 'I'
406		
407		--ActualizaciÃ³n
408		UPDATE C
409		SET
410			C.clinica_id_spring = W.clinica_id_spring,
411			C.nombre = W.nombre,
412			C.estatus = CASE WHEN W.estatus = 2 THEN 1 ELSE 0 END
413		FROM consultorio C
414		INNER JOIN work_consultorio W ON C.id_spring = W.id_spring AND W.accion = 'A'
415		
416		UPDATE work_consultorio
417		SET mensaje = 'Consultorio actualizado.'
418		WHERE accion = 'A'
419		
420		--InserciÃ³n		
421		INSERT INTO consultorio
422			(id_spring
423			,clinica_id_spring
424			,nombre
425			,estatus)
426		SELECT
427			 W.id_spring
428			,W.clinica_id_spring
429			,W.nombre
430			,CASE WHEN W.estatus = 2 THEN 1 ELSE 0 END
431		FROM work_consultorio W
432		WHERE W.accion = 'I'
433		
434		UPDATE work_consultorio
435		SET mensaje = 'Consultorio insertado.'
436		WHERE accion = 'I'
437		
438		--Pasar a histÃ³rico
439		
440		INSERT INTO migracion_consultorio
441			(id_spring
442			,clinica_id_spring
443			,nombre
444			,estatus
445			,fecha_sincronizacion
446			,mensaje)
447		SELECT
448			 id_spring
449			,clinica_id_spring
450			,nombre
451			,estatus
452			,@Fecha
453			,mensaje
454		FROM work_consultorio
455		
456		UPDATE work_sincronizacion
457		SET fecha_sincronizacion = @Fecha
458		where tipo_sincronizacion = 'consultorios'
459	END TRY
460	BEGIN CATCH
461		DECLARE @ErrorMessage NVARCHAR(4000);  
462		DECLARE @ErrorSeverity INT;  
463		DECLARE @ErrorState INT;  
464
465		SELECT   
466			@ErrorMessage = ERROR_MESSAGE(),
467			@ErrorSeverity = ERROR_SEVERITY(),
468			@ErrorState = ERROR_STATE();
469			
470		RAISERROR (@ErrorMessage,
471				   @ErrorSeverity,
472				   @ErrorState);  
473	END CATCH
474END
475GO
476/****** Object:  StoredProcedure [dbo].[work_proc_especialidades]    Script Date: 31/07/2018 11:15:41 p.m. ******/
477SET ANSI_NULLS ON
478GO
479SET QUOTED_IDENTIFIER ON
480GO
481CREATE PROCEDURE [dbo].[work_proc_especialidades]
482AS
483BEGIN
484	BEGIN TRY
485		IF (SELECT COUNT(1) FROM work_especialidad) = 0
486		BEGIN
487			RETURN
488		END
489		
490		DECLARE @Fecha AS DATETIME
491		SELECT @Fecha = GETDATE()
492		
493		UPDATE W
494		SET accion = 'A'
495		FROM work_especialidad W
496		INNER JOIN especialidad M ON W.id_spring = M.id_spring
497
498		--ActualizaciÃ³n
499		UPDATE M
500		SET
501			M.nombre = ISNULL(W.nombre,'')
502		FROM especialidad M
503		INNER JOIN work_especialidad W ON M.id_spring = W.id_spring AND W.accion = 'A'
504		
505		UPDATE work_especialidad
506		SET mensaje = 'Especialidad actualizada.'
507		WHERE accion = 'A'
508		
509		--InserciÃ³n		
510		INSERT INTO especialidad
511			(id_spring
512			,nombre
513			,estatus)
514		SELECT DISTINCT
515			 W.id_spring
516			,W.nombre
517			,1
518		FROM work_especialidad W
519		WHERE W.accion = 'I'
520		
521		UPDATE work_especialidad
522		SET mensaje = 'Especialidad insertada.'
523		WHERE accion = 'I'
524		
525		--Pasar a histÃ³rico
526		
527		INSERT INTO migracion_especialidad
528			(id_spring
529			,nombre
530			,fecha_sincronizacion
531			,mensaje)
532		SELECT
533			 id_spring
534			,nombre
535			,@Fecha
536			,mensaje
537		FROM work_especialidad
538		
539		UPDATE work_sincronizacion
540		SET fecha_sincronizacion = @Fecha
541		where tipo_sincronizacion = 'especialidades'
542	END TRY
543	BEGIN CATCH
544		DECLARE @ErrorMessage NVARCHAR(4000);  
545		DECLARE @ErrorSeverity INT;  
546		DECLARE @ErrorState INT;  
547
548		SELECT   
549			@ErrorMessage = ERROR_MESSAGE(),
550			@ErrorSeverity = ERROR_SEVERITY(),
551			@ErrorState = ERROR_STATE();
552			
553		RAISERROR (@ErrorMessage,
554				   @ErrorSeverity,
555				   @ErrorState);  
556	END CATCH
557END
558GO
559/****** Object:  StoredProcedure [dbo].[work_proc_horarios]    Script Date: 31/07/2018 11:15:41 p.m. ******/
560SET ANSI_NULLS ON
561GO
562SET QUOTED_IDENTIFIER ON
563GO
564CREATE PROCEDURE [dbo].[work_proc_horarios]
565AS
566BEGIN
567	BEGIN TRY
568		IF (SELECT COUNT(1) FROM work_horario) = 0
569		BEGIN
570			RETURN
571		END
572		
573		DECLARE @Fecha AS DATETIME
574		SELECT @Fecha = GETDATE()
575		
576		UPDATE W
577		SET accion = 'N',
578			mensaje = 'El mÃ©dico/especialidad no existe'
579		FROM work_horario W
580		LEFT JOIN medico_especialidad M ON W.medico_id_spring = M.medico_id_spring AND W.especialidad_id_spring = M.especialidad_id_spring
581		WHERE M.medico_id_spring IS NULL
582		
583		UPDATE W
584		SET accion = 'N',
585			mensaje = 'La clinica no existe'
586		FROM work_horario W
587		LEFT JOIN clinica M ON W.clinica_id_spring = M.id_spring
588		WHERE M.id_spring IS NULL
589		
590		UPDATE W
591		SET accion = 'N',
592			mensaje = 'El consultorio no existe'
593		FROM work_horario W
594		LEFT JOIN consultorio M ON W.consultorio_id_spring = M.id_spring
595		WHERE M.id_spring IS NULL
596		
597		UPDATE work_horario
598		SET accion = 'N',
599			mensaje = 'El registro no tiene fecha de inicio'
600		WHERE fecha_inicio IS NULL
601		
602		UPDATE work_horario
603		SET accion = 'N',
604			mensaje = 'El registro no tiene fecha de fin'
605		WHERE fecha_fin IS NULL
606		
607		UPDATE work_horario
608		SET accion = 'N',
609			mensaje = 'El registro no tiene hora de inicio'
610		WHERE hora_inicio IS NULL
611		
612		UPDATE work_horario
613		SET accion = 'N',
614			mensaje = 'El registro no tiene hora de fin'
615		WHERE hora_fin IS NULL
616		
617		UPDATE work_horario
618		SET accion = 'N',
619			mensaje = 'El registro no tiene tiempo de atencion'
620		WHERE tiempo_atencion IS NULL
621		
622		UPDATE W
623		SET accion = 'A'
624		FROM work_horario W
625		INNER JOIN horario M ON W.id_spring = M.id_spring
626		WHERE accion = 'I'
627
628		--ActualizaciÃ³n
629		UPDATE M
630		SET
631			M.medico_id_spring = W.medico_id_spring,
632			M.especialidad_id_spring = W.especialidad_id_spring,
633			M.clinica_id_spring = W.clinica_id_spring,
634			M.consultorio_id_spring = W.consultorio_id_spring,
635			M.tipo_turno = ISNULL(W.tipo_turno,''),
636			M.fecha_inicio = W.fecha_inicio,
637			M.fecha_fin = W.fecha_fin,
638			M.hora_inicio = W.hora_inicio,
639			M.hora_fin = W.hora_fin,
640			M.tiempo_atencion = W.tiempo_atencion,
641			M.cantidad_turno = W.cantidad_turno,
642			M.observacion = W.observacion,
643			M.estatus = W.estatus
644		FROM horario M
645		INNER JOIN work_horario W ON M.id_spring = W.id_spring AND W.accion = 'A'
646		
647		UPDATE work_horario
648		SET mensaje = 'Horario actualizado.'
649		WHERE accion = 'A'
650		
651		IF EXISTS 
652        (SELECT TABLE_NAME 
653         FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '#DetalleHorarios') 
654			DROP TABLE #DetalleHorarios
655		
656		CREATE TABLE #DetalleHorarios
657		(
658			horario_id_spring int,
659			dia int,
660		)
661		
662		INSERT INTO #DetalleHorarios
663		SELECT
664			id_spring,
665			dia
666		FROM
667		(
668			SELECT
669				id_spring,
670				1 dia
671			FROM work_horario
672			WHERE Accion = 'A' AND lunes = 2
673			UNION ALL
674			SELECT
675				id_spring,
676				2
677			FROM work_horario
678			WHERE Accion = 'A' AND martes = 2
679			UNION ALL
680			SELECT
681				id_spring,
682				3
683			FROM work_horario
684			WHERE Accion = 'A' AND miercoles = 2
685			UNION ALL
686			SELECT
687				id_spring,
688				4
689			FROM work_horario
690			WHERE Accion = 'A' AND jueves = 2
691			UNION ALL
692			SELECT
693				id_spring,
694				5
695			FROM work_horario
696			WHERE Accion = 'A' AND viernes = 2
697			UNION ALL
698			SELECT
699				id_spring,
700				6
701			FROM work_horario
702			WHERE Accion = 'A' AND sabado = 2
703			UNION ALL
704			SELECT
705				id_spring,
706				7
707			FROM work_horario
708			WHERE Accion = 'A' AND domingo = 2
709		) Data
710		
711		UPDATE DH
712		SET DH.estatus = 0
713		FROM #DetalleHorarios HD
714		INNER JOIN horario_detalle DH ON HD.horario_id_spring = DH.horario_id_spring
715		
716		UPDATE DH
717		SET DH.estatus = 1
718		FROM #DetalleHorarios HD
719		INNER JOIN horario_detalle DH ON HD.horario_id_spring = DH.horario_id_spring AND HD.dia = DH.dia
720		
721		INSERT INTO horario_detalle
722		SELECT
723			HD.horario_id_spring,
724			HD.dia,
725			1
726		FROM #DetalleHorarios HD
727		LEFT JOIN horario_detalle DH ON HD.horario_id_spring = DH.horario_id_spring AND HD.dia = DH.dia
728		WHERE DH.horario_id_spring IS NULL
729		
730		--InserciÃ³n		
731		INSERT INTO horario
732			(id_spring,
733			medico_id_spring,
734			especialidad_id_spring,
735			clinica_id_spring,
736			consultorio_id_spring,
737			tipo_turno,
738			fecha_inicio,
739			fecha_fin,
740			hora_inicio,
741			hora_fin,
742			tiempo_atencion,
743			cantidad_turno,
744			observacion,
745			estatus)
746		SELECT DISTINCT
747			W.id_spring,
748			W.medico_id_spring,
749			W.especialidad_id_spring,
750			W.clinica_id_spring,
751			W.consultorio_id_spring,
752			W.tipo_turno,
753			W.fecha_inicio,
754			W.fecha_fin,
755			W.hora_inicio,
756			W.hora_fin,
757			W.tiempo_atencion,
758			W.cantidad_turno,
759			W.observacion,
760			W.estatus
761		FROM work_horario W
762		WHERE W.accion = 'I'
763		
764		UPDATE work_horario
765		SET mensaje = 'Horario insertado.'
766		WHERE accion = 'I'
767		
768		IF EXISTS 
769        (SELECT TABLE_NAME 
770         FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '#DetalleHorariosIns') 
771			DROP TABLE #DetalleHorariosIns
772		
773		CREATE TABLE #DetalleHorariosIns
774		(
775			horario_id_spring int,
776			dia int,
777		)
778		
779		INSERT INTO #DetalleHorariosIns
780		SELECT
781			id_spring,
782			dia
783		FROM
784		(
785			SELECT
786				id_spring,
787				1 dia
788			FROM work_horario
789			WHERE Accion = 'I' AND lunes = 2
790			UNION ALL
791			SELECT
792				id_spring,
793				2
794			FROM work_horario
795			WHERE Accion = 'I' AND martes = 2
796			UNION ALL
797			SELECT
798				id_spring,
799				3
800			FROM work_horario
801			WHERE Accion = 'I' AND miercoles = 2
802			UNION ALL
803			SELECT
804				id_spring,
805				4
806			FROM work_horario
807			WHERE Accion = 'I' AND jueves = 2
808			UNION ALL
809			SELECT
810				id_spring,
811				5
812			FROM work_horario
813			WHERE Accion = 'I' AND viernes = 2
814			UNION ALL
815			SELECT
816				id_spring,
817				6
818			FROM work_horario
819			WHERE Accion = 'I' AND sabado = 2
820			UNION ALL
821			SELECT
822				id_spring,
823				7
824			FROM work_horario
825			WHERE Accion = 'I' AND domingo = 2
826		) Data
827		
828		INSERT INTO horario_detalle
829		SELECT
830			HD.horario_id_spring,
831			HD.dia,
832			1
833		FROM #DetalleHorariosIns HD
834		
835		--Pasar a histÃ³rico
836		
837		INSERT INTO migracion_horario
838			(id_spring,
839			medico_id_spring,
840			especialidad_id_spring,
841			clinica_id_spring,
842			consultorio_id_spring,
843			tipo_turno,
844			fecha_inicio,
845			fecha_fin,
846			hora_inicio,
847			hora_fin,
848			tiempo_atencion,
849			cantidad_turno,
850			observacion,
851			estatus,
852			lunes,
853			martes,
854			miercoles,
855			jueves,
856			viernes,
857			sabado,
858			domingo,
859			fecha_sincronizacion,
860			mensaje)
861		SELECT
862			id_spring,
863			medico_id_spring,
864			especialidad_id_spring,
865			clinica_id_spring,
866			consultorio_id_spring,
867			tipo_turno,
868			fecha_inicio,
869			fecha_fin,
870			hora_inicio,
871			hora_fin,
872			tiempo_atencion,
873			cantidad_turno,
874			observacion,
875			estatus,
876			lunes,
877			martes,
878			miercoles,
879			jueves,
880			viernes,
881			sabado,
882			domingo,
883			@Fecha,
884			mensaje
885		FROM work_horario
886		
887		UPDATE work_sincronizacion
888		SET fecha_sincronizacion = @Fecha
889		where tipo_sincronizacion = 'horarios'
890	END TRY
891	BEGIN CATCH
892		DECLARE @ErrorMessage NVARCHAR(4000);  
893		DECLARE @ErrorSeverity INT;  
894		DECLARE @ErrorState INT;  
895
896		SELECT   
897			@ErrorMessage = ERROR_MESSAGE(),
898			@ErrorSeverity = ERROR_SEVERITY(),
899			@ErrorState = ERROR_STATE();
900			
901		RAISERROR (@ErrorMessage,
902				   @ErrorSeverity,
903				   @ErrorState);  
904	END CATCH
905END
906GO
907/****** Object:  StoredProcedure [dbo].[work_proc_inasistencias]    Script Date: 31/07/2018 11:15:41 p.m. ******/
908SET ANSI_NULLS ON
909GO
910SET QUOTED_IDENTIFIER ON
911GO
912CREATE PROCEDURE [dbo].[work_proc_inasistencias]
913AS
914BEGIN
915	BEGIN TRY
916		IF (SELECT COUNT(1) FROM work_inasistencia) = 0
917		BEGIN
918			RETURN
919		END
920		
921		DECLARE @Fecha AS DATETIME
922		SELECT @Fecha = GETDATE()
923		
924		UPDATE W
925		SET accion = 'N',
926			mensaje = 'El horario no existe'
927		FROM work_inasistencia W
928		LEFT JOIN horario M ON W.horario_id_spring = M.id_spring
929		WHERE M.id_spring IS NULL
930		
931		UPDATE W
932		SET accion = 'A'
933		FROM work_inasistencia W
934		INNER JOIN inasistencia M ON W.id_spring = M.id_spring AND W.secuencial = M.secuencial
935		WHERE accion = 'I'
936
937		--ActualizaciÃ³n
938		UPDATE M
939		SET
940			M.horario_id_spring = W.horario_id_spring,
941			M.fecha_inicio = W.fecha_inicio,
942			M.fecha_fin = W.fecha_fin,
943			M.estatus = W.estatus
944		FROM inasistencia M
945		INNER JOIN work_inasistencia W ON M.id_spring = W.id_spring AND M.secuencial = W.secuencial AND W.accion = 'A'
946		
947		UPDATE work_inasistencia
948		SET mensaje = 'Inasistencia actualizada.'
949		WHERE accion = 'A'
950		
951		--InserciÃ³n		
952		INSERT INTO inasistencia
953			(id_spring,
954			secuencial,
955			horario_id_spring,
956			fecha_inicio,
957			fecha_fin,
958			estatus)
959		SELECT DISTINCT
960			W.id_spring,
961			W.secuencial,
962			W.horario_id_spring,
963			W.fecha_inicio,
964			W.fecha_fin,
965			W.estatus
966		FROM work_inasistencia W
967		WHERE W.accion = 'I'
968		
969		UPDATE work_inasistencia
970		SET mensaje = 'Inasistencia insertado.'
971		WHERE accion = 'I'
972		
973		--Pasar a histÃ³rico		
974		INSERT INTO migracion_inasistencia
975			(id_spring,
976			secuencial,
977			horario_id_spring,
978			fecha_inicio,
979			fecha_fin,
980			estatus,
981			fecha_sincronizacion,
982			mensaje)
983		SELECT
984			id_spring,
985			secuencial,
986			horario_id_spring,
987			fecha_inicio,
988			fecha_fin,
989			estatus,
990			@Fecha,
991			mensaje
992		FROM work_inasistencia
993		
994		UPDATE work_sincronizacion
995		SET fecha_sincronizacion = @Fecha
996		where tipo_sincronizacion = 'inasistencias'
997	END TRY
998	BEGIN CATCH
999		DECLARE @ErrorMessage NVARCHAR(4000);  
1000		DECLARE @ErrorSeverity INT;  
1001		DECLARE @ErrorState INT;  
1002
1003		SELECT   
1004			@ErrorMessage = ERROR_MESSAGE(),
1005			@ErrorSeverity = ERROR_SEVERITY(),
1006			@ErrorState = ERROR_STATE();
1007			
1008		RAISERROR (@ErrorMessage,
1009				   @ErrorSeverity,
1010				   @ErrorState);  
1011	END CATCH
1012END
1013GO
1014/****** Object:  StoredProcedure [dbo].[work_proc_medico_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1015SET ANSI_NULLS ON
1016GO
1017SET QUOTED_IDENTIFIER ON
1018GO
1019CREATE PROCEDURE [dbo].[work_proc_medico_especialidad]
1020AS
1021BEGIN
1022	BEGIN TRY
1023		IF (SELECT COUNT(1) FROM work_medico_especialidad) = 0
1024		BEGIN
1025			RETURN
1026		END
1027		
1028		DECLARE @Fecha AS DATETIME
1029		SELECT @Fecha = GETDATE()
1030		
1031		UPDATE W
1032		SET accion = 'N',
1033			mensaje = 'El mÃ©dico no existe'
1034		FROM work_medico_especialidad W
1035		LEFT JOIN medico M ON W.medico_id_spring = M.id_spring
1036		WHERE M.id_spring IS NULL
1037		
1038		UPDATE W
1039		SET accion = 'N',
1040			mensaje = 'La especialidad no existe'
1041		FROM work_medico_especialidad W
1042		LEFT JOIN especialidad M ON W.especialidad_id_spring = M.id_spring
1043		WHERE M.id_spring IS NULL
1044		
1045		UPDATE work_medico_especialidad
1046		SET accion = 'N',
1047			mensaje = 'Registro no considerado (Estado no activo)'
1048		WHERE estado <> 2
1049		
1050		UPDATE W
1051		SET accion = 'N',
1052			mensaje = 'El registro ya existÃa'
1053		FROM work_medico_especialidad W
1054		INNER JOIN medico_especialidad M ON W.medico_id_spring = M.medico_id_spring AND W.especialidad_id_spring = M.especialidad_id_spring
1055		
1056		--InserciÃ³n		
1057		INSERT INTO medico_especialidad
1058			(medico_id_spring
1059			,especialidad_id_spring)
1060		SELECT
1061			 W.medico_id_spring
1062			,W.especialidad_id_spring
1063		FROM work_medico_especialidad W
1064		WHERE W.accion = 'I'
1065		
1066		UPDATE work_medico_especialidad
1067		SET mensaje = 'Registro insertado.'
1068		WHERE accion = 'I'
1069		
1070		--Pasar a histÃ³rico
1071		
1072		INSERT INTO migracion_medico_especialidad
1073			(medico_id_spring
1074			,especialidad_id_spring
1075			,estado
1076			,fecha_sincronizacion
1077			,mensaje)
1078		SELECT
1079			 medico_id_spring
1080			,especialidad_id_spring
1081			,estado
1082			,@Fecha
1083			,mensaje
1084		FROM work_medico_especialidad
1085		
1086		UPDATE work_sincronizacion
1087		SET fecha_sincronizacion = @Fecha
1088		where tipo_sincronizacion = 'medico_especialidad'
1089	END TRY
1090	BEGIN CATCH
1091		DECLARE @ErrorMessage NVARCHAR(4000);  
1092		DECLARE @ErrorSeverity INT;  
1093		DECLARE @ErrorState INT;  
1094
1095		SELECT   
1096			@ErrorMessage = ERROR_MESSAGE(),
1097			@ErrorSeverity = ERROR_SEVERITY(),
1098			@ErrorState = ERROR_STATE();
1099			
1100		RAISERROR (@ErrorMessage,
1101				   @ErrorSeverity,
1102				   @ErrorState);  
1103	END CATCH
1104END
1105GO
1106/****** Object:  StoredProcedure [dbo].[work_proc_medicos]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1107SET ANSI_NULLS ON
1108GO
1109SET QUOTED_IDENTIFIER ON
1110GO
1111CREATE PROCEDURE [dbo].[work_proc_medicos]
1112AS
1113BEGIN
1114BEGIN TRY
1115	IF (SELECT COUNT(1) FROM work_medico) = 0
1116	BEGIN
1117		RETURN
1118	END
1119	
1120	UPDATE W
1121	SET accion = 'A'
1122	FROM work_medico W
1123	INNER JOIN Medico M ON W.id_spring = M.id_spring
1124
1125	--ActualizaciÃ³n
1126	UPDATE M
1127	SET
1128		M.cmp = W.cmp,
1129		M.nombres = ISNULL(W.nombres,''),
1130		M.apellido_paterno = ISNULL(W.apellido_paterno,''),
1131		M.apellido_materno = W.apellido_materno
1132	FROM Medico M
1133	INNER JOIN work_medico W ON W.id_spring = M.id_spring AND W.accion = 'A'
1134	
1135	UPDATE work_medico
1136	SET mensaje = 'Medico actualizado.'
1137	WHERE accion = 'A'
1138	
1139	--InserciÃ³n		
1140	INSERT INTO Medico
1141		(id_spring
1142		,cmp
1143		,nombres
1144		,apellido_paterno
1145		,apellido_materno
1146		,disponible_cita_app
1147		,estatus)
1148	SELECT DISTINCT
1149		 W.id_spring
1150		,W.cmp
1151		,ISNULL(W.nombres,'')
1152		,ISNULL(W.apellido_paterno,'')
1153		,W.apellido_materno
1154		,W.disponible_cita_app
1155		,W.estatus
1156	FROM work_medico W
1157	WHERE W.accion = 'I'
1158	
1159	UPDATE work_medico
1160	SET mensaje = 'Medico insertado.'
1161	WHERE accion = 'I'
1162	
1163	--Pasar a histÃ³rico
1164	DECLARE @Fecha AS DATETIME
1165	SELECT @Fecha = GETDATE()
1166	
1167	INSERT INTO migracion_medico
1168		(id_spring
1169		,cmp
1170		,nombres
1171		,apellido_paterno
1172		,apellido_materno
1173		,fecha_sincronizacion
1174		,mensaje)
1175	SELECT
1176		id_spring
1177		,cmp
1178		,nombres
1179		,apellido_paterno
1180		,apellido_materno
1181		,@Fecha
1182		,mensaje
1183	FROM work_medico
1184	
1185	UPDATE work_sincronizacion
1186	SET fecha_sincronizacion = @Fecha
1187	where tipo_sincronizacion = 'medicos'
1188
1189END TRY
1190BEGIN CATCH
1191	DECLARE @ErrorMessage NVARCHAR(4000);  
1192	DECLARE @ErrorSeverity INT;  
1193	DECLARE @ErrorState INT;  
1194
1195	SELECT   
1196		@ErrorMessage = ERROR_MESSAGE(),
1197		@ErrorSeverity = ERROR_SEVERITY(),
1198		@ErrorState = ERROR_STATE();
1199		
1200	RAISERROR (@ErrorMessage,
1201			   @ErrorSeverity,
1202			   @ErrorState);  
1203END CATCH
1204END
1205GO
1206/****** Object:  StoredProcedure [dbo].[work_proc_pacientes]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1207SET ANSI_NULLS ON
1208GO
1209SET QUOTED_IDENTIFIER ON
1210GO
1211CREATE PROCEDURE [dbo].[work_proc_pacientes]
1212AS
1213BEGIN
1214	BEGIN TRY
1215		IF (SELECT COUNT(1) FROM work_paciente) = 0
1216		BEGIN
1217			RETURN
1218		END
1219		
1220		DECLARE @Fecha AS DATETIME
1221		SELECT @Fecha = GETDATE()
1222		
1223		UPDATE work_paciente
1224		SET estado_civil_id_spring = NULL
1225		WHERE estado_civil_id_spring = ''
1226		
1227		UPDATE work_paciente
1228		SET pais_id_spring = NULL
1229		WHERE pais_id_spring = ''
1230		
1231		UPDATE work_paciente
1232		SET departamento_id_spring = NULL
1233		WHERE departamento_id_spring = ''
1234		
1235		UPDATE work_paciente
1236		SET provincia_id_spring = NULL
1237		WHERE provincia_id_spring = ''
1238		
1239		UPDATE work_paciente
1240		SET distrito_id_spring = NULL
1241		WHERE distrito_id_spring = ''
1242		
1243		UPDATE W
1244		SET accion = 'N',
1245			mensaje = 'Paciente ya existÃa con otro ID'
1246		FROM work_paciente W
1247		INNER JOIN paciente M ON W.tipo_documento = M.tipo_documento AND W.numero_documento = M.numero_documento
1248		
1249		UPDATE W
1250		SET accion = 'N',
1251			mensaje = 'Paciente migrado con otro ID'
1252		FROM work_paciente W
1253		INNER JOIN ( 
1254		SELECT
1255			id_spring,
1256			numero_documento,
1257			ROW_NUMBER() OVER (PARTITION BY tipo_documento,numero_documento ORDER BY id_spring DESC) prioridad
1258		FROM work_paciente) Data ON W.id_spring = Data.id_spring
1259		WHERE Data.prioridad > 1
1260
1261		
1262		UPDATE W
1263		SET accion = 'N',
1264			mensaje = 'RelaciÃ³n con estado civil incorrecta'
1265		FROM work_paciente W
1266		LEFT JOIN estado_civil E ON W.estado_civil_id_spring = E.id_spring
1267		WHERE E.id_spring IS NULL AND W.estado_civil_id_spring IS NOT NULL
1268		
1269		UPDATE W
1270		SET accion = 'N',
1271			mensaje = 'RelaciÃ³n con estado civil incorrecta'
1272		FROM work_paciente W
1273		LEFT JOIN pais P ON W.pais_id_spring = P.id_spring
1274		WHERE P.id_spring IS NULL AND W.pais_id_spring IS NOT NULL
1275		
1276		UPDATE W
1277		SET accion = 'N',
1278			mensaje = 'RelaciÃ³n con distrito incorrecta'
1279		FROM work_paciente W
1280		LEFT JOIN distrito D ON W.departamento_id_spring = D.departamento_id_spring and W.provincia_id_spring = D.provincia_id_spring and W.distrito_id_spring = D.id_spring
1281		WHERE D.id_spring IS NULL AND W.departamento_id_spring IS NOT NULL AND W.provincia_id_spring IS NOT NULL AND W.distrito_id_spring IS NOT NULL
1282		
1283		UPDATE W
1284		SET accion = 'A'
1285		FROM work_paciente W
1286		INNER JOIN paciente M ON W.id_spring = M.id_spring
1287		WHERE accion = 'I'
1288
1289		--ActualizaciÃ³n
1290		UPDATE M
1291		SET
1292			M.tipo_documento = ISNULL(W.tipo_documento,''),
1293			M.numero_documento = ISNULL(W.numero_documento,''),
1294			M.nombres = ISNULL(W.nombres,''),
1295			M.apellido_paterno = ISNULL(W.apellido_paterno,''),
1296			M.apellido_materno = W.apellido_materno,
1297			M.genero = W.genero,
1298			M.fecha_nacimiento = W.fecha_nacimiento,
1299			M.estado_civil_id_spring = W.estado_civil_id_spring,
1300			M.pais_id_spring = W.pais_id_spring,
1301			M.departamento_id_spring = W.departamento_id_spring,
1302			M.provincia_id_spring = W.provincia_id_spring,
1303			M.distrito_id_spring = W.distrito_id_spring,
1304			M.direccion = W.direccion,
1305			M.correo = W.correo,
1306			M.telefono_celular = ISNULL(W.telefono_celular,''),
1307			M.fecha_actualizacion = @Fecha
1308		FROM paciente M
1309		INNER JOIN work_paciente W ON W.id_spring = M.id_spring AND W.accion = 'A'
1310		
1311		UPDATE work_paciente
1312		SET mensaje = 'Paciente actualizado.'
1313		WHERE accion = 'A'
1314		
1315		--InserciÃ³n		
1316		INSERT INTO paciente
1317			(id_spring
1318			,tipo_documento
1319			,numero_documento
1320			,nombres
1321			,apellido_paterno
1322			,apellido_materno
1323			,genero
1324			,fecha_nacimiento
1325			,estado_civil_id_spring
1326			,pais_id_spring
1327			,departamento_id_spring
1328			,provincia_id_spring
1329			,distrito_id_spring
1330			,direccion
1331			,correo
1332			,telefono_celular
1333			,imagen
1334			,fecha_registro
1335			,origen_registro
1336			,fecha_actualizacion
1337			,ver_historico)
1338		SELECT
1339			 ISNULL(W.id_spring,'')
1340			,ISNULL(W.tipo_documento,'')
1341			,ISNULL(W.numero_documento,'')
1342			,ISNULL(W.nombres,'')
1343			,ISNULL(W.apellido_paterno,'')
1344			,W.apellido_materno
1345			,W.genero
1346			,W.fecha_nacimiento
1347			,CASE WHEN W.estado_civil_id_spring = '' THEN NULL ELSE W.estado_civil_id_spring END
1348			,CASE WHEN W.pais_id_spring = '' THEN NULL ELSE W.pais_id_spring END
1349			,CASE WHEN W.departamento_id_spring = '' THEN NULL ELSE W.departamento_id_spring END
1350			,CASE WHEN W.provincia_id_spring = '' THEN NULL ELSE W.provincia_id_spring END
1351			,CASE WHEN W.distrito_id_spring = '' THEN NULL ELSE W.distrito_id_spring END
1352			,W.direccion
1353			,W.correo
1354			,ISNULL(W.telefono_celular,'')
1355			,W.imagen
1356			,@Fecha
1357			,'SPRING'
1358			,@Fecha
1359			,0
1360		FROM work_paciente W
1361		WHERE W.accion = 'I'
1362		
1363		UPDATE work_paciente
1364		SET mensaje = 'Paciente insertado.'
1365		WHERE accion = 'I'
1366		
1367		--Pasar a histÃ³rico
1368		
1369		INSERT INTO migracion_paciente
1370			(id_spring
1371			,tipo_documento
1372			,numero_documento
1373			,nombres
1374			,apellido_paterno
1375			,apellido_materno
1376			,genero
1377			,fecha_nacimiento
1378			,estado_civil_id_spring
1379			,pais_id_spring
1380			,departamento_id_spring
1381			,provincia_id_spring
1382			,distrito_id_spring
1383			,direccion
1384			,correo
1385			,telefono_celular
1386			,imagen
1387			,fecha_sincronizacion
1388			,mensaje)
1389		SELECT
1390			 id_spring
1391			,tipo_documento
1392			,numero_documento
1393			,nombres
1394			,apellido_paterno
1395			,apellido_materno
1396			,genero
1397			,fecha_nacimiento
1398			,estado_civil_id_spring
1399			,pais_id_spring
1400			,departamento_id_spring
1401			,provincia_id_spring
1402			,distrito_id_spring
1403			,direccion
1404			,correo
1405			,telefono_celular
1406			,imagen
1407			,@Fecha
1408			,mensaje
1409		FROM work_paciente
1410		
1411		UPDATE work_sincronizacion
1412		SET fecha_sincronizacion = @Fecha
1413		where tipo_sincronizacion = 'pacientes'
1414	END TRY
1415	BEGIN CATCH
1416		DECLARE @ErrorMessage NVARCHAR(4000);  
1417		DECLARE @ErrorSeverity INT;  
1418		DECLARE @ErrorState INT;  
1419
1420		SELECT   
1421			@ErrorMessage = ERROR_MESSAGE(),
1422			@ErrorSeverity = ERROR_SEVERITY(),
1423			@ErrorState = ERROR_STATE();
1424			
1425		RAISERROR (@ErrorMessage,
1426				   @ErrorSeverity,
1427				   @ErrorState);  
1428	END CATCH
1429END
1430GO
1431/****** Object:  Table [dbo].[app_notificacion]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1432SET ANSI_NULLS ON
1433GO
1434SET QUOTED_IDENTIFIER ON
1435GO
1436SET ANSI_PADDING ON
1437GO
1438CREATE TABLE [dbo].[app_notificacion](
1439	[id] [int] IDENTITY(24,1) NOT NULL,
1440	[usuario_id] [int] NOT NULL,
1441	[tipo_notificacion] [int] NOT NULL,
1442	[fecha_registro] [datetime2](0) NOT NULL,
1443	[titulo] [varchar](100) NOT NULL,
1444	[mensaje] [varchar](2500) NOT NULL,
1445	[url] [varchar](500) NULL DEFAULT (NULL),
1446	[cita_id_spring] [int] NULL DEFAULT (NULL),
1447	[fecha_envio] [datetime2](0) NULL DEFAULT (NULL),
1448	[estatus] [int] NULL DEFAULT (NULL),
1449	[resultado_envio] [varchar](500) NULL DEFAULT (NULL),
1450 CONSTRAINT [PK_app_notificacion_id] PRIMARY KEY CLUSTERED 
1451(
1452	[id] ASC
1453)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1454) ON [PRIMARY]
1455
1456GO
1457SET ANSI_PADDING OFF
1458GO
1459/****** Object:  Table [dbo].[cita]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1460SET ANSI_NULLS ON
1461GO
1462SET QUOTED_IDENTIFIER ON
1463GO
1464SET ANSI_PADDING ON
1465GO
1466CREATE TABLE [dbo].[cita](
1467	[id_spring] [int] NOT NULL,
1468	[horario_id_spring] [int] NOT NULL,
1469	[fecha_cita] [datetime2](0) NULL DEFAULT (NULL),
1470	[turno] [int] NOT NULL,
1471	[paciente_id_spring] [int] NOT NULL,
1472	[fecha_registro] [datetime2](0) NOT NULL,
1473	[origen_registro] [varchar](10) NOT NULL,
1474	[estatus_pago] [int] NOT NULL,
1475	[estatus] [int] NOT NULL,
1476 CONSTRAINT [PK_cita_id_spring] PRIMARY KEY CLUSTERED 
1477(
1478	[id_spring] ASC
1479)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1480) ON [PRIMARY]
1481
1482GO
1483SET ANSI_PADDING OFF
1484GO
1485/****** Object:  Table [dbo].[cita_bloqueo_manual]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1486SET ANSI_NULLS ON
1487GO
1488SET QUOTED_IDENTIFIER ON
1489GO
1490CREATE TABLE [dbo].[cita_bloqueo_manual](
1491	[id] [int] IDENTITY(2,1) NOT NULL,
1492	[medico_id_spring] [int] NOT NULL,
1493	[fecha] [datetime2](0) NOT NULL,
1494	[estatus] [int] NOT NULL,
1495 CONSTRAINT [PK_cita_bloqueo_manual_id] PRIMARY KEY CLUSTERED 
1496(
1497	[id] ASC
1498)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1499) ON [PRIMARY]
1500
1501GO
1502/****** Object:  Table [dbo].[cita_historica]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1503SET ANSI_NULLS ON
1504GO
1505SET QUOTED_IDENTIFIER ON
1506GO
1507SET ANSI_PADDING ON
1508GO
1509CREATE TABLE [dbo].[cita_historica](
1510	[id_spring] [int] NOT NULL,
1511	[paciente_id_spring] [int] NOT NULL,
1512	[horario_id_spring] [int] NOT NULL,
1513	[clinica_id_spring] [varchar](4) NOT NULL,
1514	[medico_id_spring] [int] NOT NULL,
1515	[especialidad_id_spring] [int] NOT NULL,
1516	[fecha_cita] [datetime2](0) NOT NULL,
1517	[turno] [int] NOT NULL,
1518	[fecha_envio_historico] [datetime2](0) NOT NULL,
1519	[fecha_registro] [datetime2](0) NOT NULL,
1520	[origen_registro] [varchar](10) NOT NULL,
1521	[estatus_pago] [int] NOT NULL,
1522	[estatus] [int] NOT NULL,
1523 CONSTRAINT [PK_cita_historica_id_spring] PRIMARY KEY CLUSTERED 
1524(
1525	[id_spring] ASC
1526)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1527) ON [PRIMARY]
1528
1529GO
1530SET ANSI_PADDING OFF
1531GO
1532/****** Object:  Table [dbo].[clinica]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1533SET ANSI_NULLS ON
1534GO
1535SET QUOTED_IDENTIFIER ON
1536GO
1537SET ANSI_PADDING ON
1538GO
1539CREATE TABLE [dbo].[clinica](
1540	[id_spring] [varchar](4) NOT NULL,
1541	[nombre] [varchar](45) NOT NULL,
1542	[distrito] [varchar](20) NOT NULL,
1543	[direccion] [varchar](200) NOT NULL,
1544	[telefono] [varchar](12) NOT NULL,
1545	[correo] [varchar](255) NOT NULL,
1546	[latitud] [real] NOT NULL,
1547	[longitud] [real] NOT NULL,
1548	[estatus] [int] NOT NULL DEFAULT ((1)),
1549 CONSTRAINT [PK_clinica_id_spring] PRIMARY KEY CLUSTERED 
1550(
1551	[id_spring] ASC
1552)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1553) ON [PRIMARY]
1554
1555GO
1556SET ANSI_PADDING OFF
1557GO
1558/****** Object:  Table [dbo].[clinica_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1559SET ANSI_NULLS ON
1560GO
1561SET QUOTED_IDENTIFIER ON
1562GO
1563SET ANSI_PADDING ON
1564GO
1565CREATE TABLE [dbo].[clinica_especialidad](
1566	[clinica_id_spring] [varchar](4) NOT NULL,
1567	[especialidad_id_spring] [int] NOT NULL,
1568 CONSTRAINT [PK_clinica_especialidad_clinica_id_spring] PRIMARY KEY CLUSTERED 
1569(
1570	[clinica_id_spring] ASC,
1571	[especialidad_id_spring] ASC
1572)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1573) ON [PRIMARY]
1574
1575GO
1576SET ANSI_PADDING OFF
1577GO
1578/****** Object:  Table [dbo].[clinica_medico]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1579SET ANSI_NULLS ON
1580GO
1581SET QUOTED_IDENTIFIER ON
1582GO
1583SET ANSI_PADDING ON
1584GO
1585CREATE TABLE [dbo].[clinica_medico](
1586	[clinica_id_spring] [varchar](4) NOT NULL,
1587	[medico_id_spring] [int] NOT NULL,
1588 CONSTRAINT [PK_clinica_medico_clinica_id_spring] PRIMARY KEY CLUSTERED 
1589(
1590	[clinica_id_spring] ASC,
1591	[medico_id_spring] ASC
1592)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1593) ON [PRIMARY]
1594
1595GO
1596SET ANSI_PADDING OFF
1597GO
1598/****** Object:  Table [dbo].[consultorio]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1599SET ANSI_NULLS ON
1600GO
1601SET QUOTED_IDENTIFIER ON
1602GO
1603SET ANSI_PADDING ON
1604GO
1605CREATE TABLE [dbo].[consultorio](
1606	[id_spring] [int] NOT NULL,
1607	[clinica_id_spring] [varchar](4) NOT NULL,
1608	[nombre] [varchar](150) NOT NULL,
1609	[estatus] [int] NOT NULL,
1610 CONSTRAINT [PK_consultorio_id_spring] PRIMARY KEY CLUSTERED 
1611(
1612	[id_spring] ASC
1613)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1614) ON [PRIMARY]
1615
1616GO
1617SET ANSI_PADDING OFF
1618GO
1619/****** Object:  Table [dbo].[departamento]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1620SET ANSI_NULLS ON
1621GO
1622SET QUOTED_IDENTIFIER ON
1623GO
1624SET ANSI_PADDING ON
1625GO
1626CREATE TABLE [dbo].[departamento](
1627	[id_spring] [varchar](3) NOT NULL,
1628	[pais_id_spring] [varchar](4) NOT NULL,
1629	[nombre] [varchar](40) NOT NULL,
1630	[estatus] [int] NOT NULL DEFAULT ((1)),
1631 CONSTRAINT [PK_departamento_id_sprin] PRIMARY KEY CLUSTERED 
1632(
1633	[id_spring] ASC
1634)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1635) ON [PRIMARY]
1636
1637GO
1638SET ANSI_PADDING OFF
1639GO
1640/****** Object:  Table [dbo].[distrito]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1641SET ANSI_NULLS ON
1642GO
1643SET QUOTED_IDENTIFIER ON
1644GO
1645SET ANSI_PADDING ON
1646GO
1647CREATE TABLE [dbo].[distrito](
1648	[departamento_id_spring] [varchar](3) NOT NULL,
1649	[provincia_id_spring] [varchar](3) NOT NULL,
1650	[id_spring] [varchar](3) NOT NULL,
1651	[nombre] [varchar](40) NOT NULL,
1652	[estatus] [int] NOT NULL CONSTRAINT [DF__distrito__estatu__2EA5EC27]  DEFAULT ((1)),
1653 CONSTRAINT [PK_distrito_departamento_id_spring] PRIMARY KEY CLUSTERED 
1654(
1655	[departamento_id_spring] ASC,
1656	[provincia_id_spring] ASC,
1657	[id_spring] ASC
1658)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1659) ON [PRIMARY]
1660
1661GO
1662SET ANSI_PADDING OFF
1663GO
1664/****** Object:  Table [dbo].[encuesta]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1665SET ANSI_NULLS ON
1666GO
1667SET QUOTED_IDENTIFIER ON
1668GO
1669SET ANSI_PADDING ON
1670GO
1671CREATE TABLE [dbo].[encuesta](
1672	[id] [int] IDENTITY(4,1) NOT NULL,
1673	[pregunta] [varchar](40) NOT NULL,
1674	[tipo_respuesta] [int] NOT NULL,
1675	[estatus] [int] NOT NULL,
1676 CONSTRAINT [PK_encuesta_id] PRIMARY KEY CLUSTERED 
1677(
1678	[id] ASC
1679)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1680) ON [PRIMARY]
1681
1682GO
1683SET ANSI_PADDING OFF
1684GO
1685/****** Object:  Table [dbo].[encuesta_pregunta_respuesta]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1686SET ANSI_NULLS ON
1687GO
1688SET QUOTED_IDENTIFIER ON
1689GO
1690CREATE TABLE [dbo].[encuesta_pregunta_respuesta](
1691	[id] [int] IDENTITY(4,1) NOT NULL,
1692	[encuesta_respuesta_id] [int] NOT NULL,
1693	[repuesta] [int] NOT NULL,
1694	[encuesta_id] [int] NOT NULL,
1695 CONSTRAINT [PK_encuesta_pregunta_respuesta_id] PRIMARY KEY CLUSTERED 
1696(
1697	[id] ASC
1698)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1699) ON [PRIMARY]
1700
1701GO
1702/****** Object:  Table [dbo].[encuesta_respuesta]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1703SET ANSI_NULLS ON
1704GO
1705SET QUOTED_IDENTIFIER ON
1706GO
1707SET ANSI_PADDING ON
1708GO
1709CREATE TABLE [dbo].[encuesta_respuesta](
1710	[id] [int] IDENTITY(11,1) NOT NULL,
1711	[usuario_id] [int] NOT NULL,
1712	[cita_id_spring] [int] NOT NULL,
1713	[fecha_registro] [datetime2](0) NOT NULL,
1714	[observaciones] [varchar](500) NOT NULL,
1715	[origen_registro] [varchar](10) NOT NULL,
1716 CONSTRAINT [PK_encuesta_respuesta_id] PRIMARY KEY CLUSTERED 
1717(
1718	[id] ASC
1719)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1720) ON [PRIMARY]
1721
1722GO
1723SET ANSI_PADDING OFF
1724GO
1725/****** Object:  Table [dbo].[especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1726SET ANSI_NULLS ON
1727GO
1728SET QUOTED_IDENTIFIER ON
1729GO
1730SET ANSI_PADDING ON
1731GO
1732CREATE TABLE [dbo].[especialidad](
1733	[id_spring] [int] NOT NULL,
1734	[nombre] [varchar](100) NOT NULL,
1735	[estatus] [int] NOT NULL DEFAULT ((1)),
1736 CONSTRAINT [PK_especialidad_id_spring] PRIMARY KEY CLUSTERED 
1737(
1738	[id_spring] ASC
1739)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1740) ON [PRIMARY]
1741
1742GO
1743SET ANSI_PADDING OFF
1744GO
1745/****** Object:  Table [dbo].[estado_civil]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1746SET ANSI_NULLS ON
1747GO
1748SET QUOTED_IDENTIFIER ON
1749GO
1750SET ANSI_PADDING ON
1751GO
1752CREATE TABLE [dbo].[estado_civil](
1753	[id_spring] [varchar](1) NOT NULL,
1754	[nombre] [varchar](45) NOT NULL,
1755	[estatus] [int] NOT NULL DEFAULT ((1)),
1756 CONSTRAINT [PK_estado_civil_id_spring] PRIMARY KEY CLUSTERED 
1757(
1758	[id_spring] ASC
1759)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1760) ON [PRIMARY]
1761
1762GO
1763SET ANSI_PADDING OFF
1764GO
1765/****** Object:  Table [dbo].[failed_jobs]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1766SET ANSI_NULLS ON
1767GO
1768SET QUOTED_IDENTIFIER ON
1769GO
1770CREATE TABLE [dbo].[failed_jobs](
1771	[id] [numeric](20, 0) IDENTITY(1,1) NOT NULL,
1772	[connection] [nvarchar](max) NOT NULL,
1773	[queue] [nvarchar](max) NOT NULL,
1774	[payload] [nvarchar](max) NOT NULL,
1775	[exception] [nvarchar](max) NOT NULL,
1776	[failed_at] [datetime] NOT NULL,
1777 CONSTRAINT [PK_failed_jobs_id] PRIMARY KEY CLUSTERED 
1778(
1779	[id] ASC
1780)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1781) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1782
1783GO
1784/****** Object:  Table [dbo].[feriado]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1785SET ANSI_NULLS ON
1786GO
1787SET QUOTED_IDENTIFIER ON
1788GO
1789CREATE TABLE [dbo].[feriado](
1790	[id] [int] IDENTITY(1,1) NOT NULL,
1791	[fecha] [date] NOT NULL,
1792 CONSTRAINT [PK_feriado_id] PRIMARY KEY CLUSTERED 
1793(
1794	[id] ASC
1795)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
1796 CONSTRAINT [feriado$fecha_UNIQUE] UNIQUE NONCLUSTERED 
1797(
1798	[fecha] ASC
1799)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1800) ON [PRIMARY]
1801
1802GO
1803/****** Object:  Table [dbo].[horario]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1804SET ANSI_NULLS ON
1805GO
1806SET QUOTED_IDENTIFIER ON
1807GO
1808SET ANSI_PADDING ON
1809GO
1810CREATE TABLE [dbo].[horario](
1811	[id_spring] [int] NOT NULL,
1812	[medico_id_spring] [int] NOT NULL,
1813	[especialidad_id_spring] [int] NOT NULL,
1814	[clinica_id_spring] [varchar](4) NOT NULL,
1815	[consultorio_id_spring] [int] NOT NULL,
1816	[tipo_turno] [varchar](1) NOT NULL,
1817	[fecha_inicio] [date] NOT NULL,
1818	[fecha_fin] [date] NOT NULL,
1819	[hora_inicio] [time](7) NOT NULL,
1820	[hora_fin] [time](7) NOT NULL,
1821	[tiempo_atencion] [numeric](6, 2) NOT NULL,
1822	[cantidad_turno] [int] NOT NULL,
1823	[observacion] [varchar](250) NULL DEFAULT (NULL),
1824	[estatus] [int] NOT NULL DEFAULT ((1)),
1825 CONSTRAINT [PK_horario_id_spring] PRIMARY KEY CLUSTERED 
1826(
1827	[id_spring] ASC
1828)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1829) ON [PRIMARY]
1830
1831GO
1832SET ANSI_PADDING OFF
1833GO
1834/****** Object:  Table [dbo].[horario_detalle]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1835SET ANSI_NULLS ON
1836GO
1837SET QUOTED_IDENTIFIER ON
1838GO
1839CREATE TABLE [dbo].[horario_detalle](
1840	[horario_id_spring] [int] NOT NULL,
1841	[dia] [int] NOT NULL,
1842	[estatus] [int] NOT NULL DEFAULT ((1)),
1843 CONSTRAINT [PK_horario_detalle_horario_id_spring] PRIMARY KEY CLUSTERED 
1844(
1845	[horario_id_spring] ASC,
1846	[dia] ASC
1847)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1848) ON [PRIMARY]
1849
1850GO
1851/****** Object:  Table [dbo].[inasistencia]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1852SET ANSI_NULLS ON
1853GO
1854SET QUOTED_IDENTIFIER ON
1855GO
1856CREATE TABLE [dbo].[inasistencia](
1857	[id_spring] [int] NOT NULL,
1858	[secuencial] [int] NOT NULL,
1859	[horario_id_spring] [int] NOT NULL,
1860	[fecha_inicio] [datetime2](0) NOT NULL,
1861	[fecha_fin] [datetime2](0) NOT NULL,
1862	[estatus] [int] NOT NULL CONSTRAINT [DF__inasisten__estat__2882FE7D]  DEFAULT ((1)),
1863 CONSTRAINT [PK_inasistencia_id_spring] PRIMARY KEY CLUSTERED 
1864(
1865	[id_spring] ASC,
1866	[secuencial] ASC
1867)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1868) ON [PRIMARY]
1869
1870GO
1871/****** Object:  Table [dbo].[jobs]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1872SET ANSI_NULLS ON
1873GO
1874SET QUOTED_IDENTIFIER ON
1875GO
1876CREATE TABLE [dbo].[jobs](
1877	[id] [numeric](20, 0) IDENTITY(484,1) NOT NULL,
1878	[queue] [nvarchar](255) NOT NULL,
1879	[payload] [nvarchar](max) NOT NULL,
1880	[attempts] [tinyint] NOT NULL,
1881	[reserved_at] [bigint] NULL,
1882	[available_at] [bigint] NOT NULL,
1883	[created_at] [bigint] NOT NULL,
1884 CONSTRAINT [PK_jobs_id] PRIMARY KEY CLUSTERED 
1885(
1886	[id] ASC
1887)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1888) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
1889
1890GO
1891/****** Object:  Table [dbo].[medico]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1892SET ANSI_NULLS ON
1893GO
1894SET QUOTED_IDENTIFIER ON
1895GO
1896SET ANSI_PADDING ON
1897GO
1898CREATE TABLE [dbo].[medico](
1899	[id_spring] [int] NOT NULL,
1900	[cmp] [varchar](10) NULL DEFAULT (NULL),
1901	[nombres] [varchar](50) NOT NULL,
1902	[apellido_paterno] [varchar](50) NOT NULL,
1903	[apellido_materno] [varchar](50) NULL DEFAULT (NULL),
1904	[disponible_cita_app] [int] NOT NULL DEFAULT ((1)),
1905	[estatus] [int] NOT NULL DEFAULT ((1)),
1906 CONSTRAINT [PK_medico_id_spring] PRIMARY KEY CLUSTERED 
1907(
1908	[id_spring] ASC
1909)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1910) ON [PRIMARY]
1911
1912GO
1913SET ANSI_PADDING OFF
1914GO
1915/****** Object:  Table [dbo].[medico_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1916SET ANSI_NULLS ON
1917GO
1918SET QUOTED_IDENTIFIER ON
1919GO
1920CREATE TABLE [dbo].[medico_especialidad](
1921	[medico_id_spring] [int] NOT NULL,
1922	[especialidad_id_spring] [int] NOT NULL,
1923 CONSTRAINT [PK_medico_especialidad_medico_id_spring] PRIMARY KEY CLUSTERED 
1924(
1925	[medico_id_spring] ASC,
1926	[especialidad_id_spring] ASC
1927)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
1928) ON [PRIMARY]
1929
1930GO
1931/****** Object:  Table [dbo].[migracion_cita]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1932SET ANSI_NULLS ON
1933GO
1934SET QUOTED_IDENTIFIER ON
1935GO
1936SET ANSI_PADDING ON
1937GO
1938CREATE TABLE [dbo].[migracion_cita](
1939	[id_spring] [int] NULL,
1940	[horario_id_spring] [int] NULL,
1941	[fecha_cita] [datetime] NULL,
1942	[turno] [int] NULL,
1943	[paciente_id_spring] [int] NULL,
1944	[fecha_registro] [datetime] NULL,
1945	[origen_registro] [varchar](10) NULL,
1946	[estatus_pago] [int] NULL,
1947	[estatus] [int] NULL,
1948	[fecha_sincronizacion] [datetime] NULL,
1949	[mensaje] [varchar](500) NULL
1950) ON [PRIMARY]
1951
1952GO
1953SET ANSI_PADDING OFF
1954GO
1955/****** Object:  Table [dbo].[migracion_clinica_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1956SET ANSI_NULLS ON
1957GO
1958SET QUOTED_IDENTIFIER ON
1959GO
1960SET ANSI_PADDING ON
1961GO
1962CREATE TABLE [dbo].[migracion_clinica_especialidad](
1963	[clinica_id_spring] [varchar](4) NULL,
1964	[especialidad_id_spring] [int] NULL,
1965	[fecha_sincronizacion] [datetime] NULL,
1966	[mensaje] [varchar](500) NULL
1967) ON [PRIMARY]
1968
1969GO
1970SET ANSI_PADDING OFF
1971GO
1972/****** Object:  Table [dbo].[migracion_clinica_medico]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1973SET ANSI_NULLS ON
1974GO
1975SET QUOTED_IDENTIFIER ON
1976GO
1977SET ANSI_PADDING ON
1978GO
1979CREATE TABLE [dbo].[migracion_clinica_medico](
1980	[clinica_id_spring] [varchar](4) NULL,
1981	[medico_id_spring] [int] NULL,
1982	[estado] [int] NULL,
1983	[fecha_sincronizacion] [datetime] NULL,
1984	[mensaje] [varchar](500) NULL
1985) ON [PRIMARY]
1986
1987GO
1988SET ANSI_PADDING OFF
1989GO
1990/****** Object:  Table [dbo].[migracion_consultorio]    Script Date: 31/07/2018 11:15:41 p.m. ******/
1991SET ANSI_NULLS ON
1992GO
1993SET QUOTED_IDENTIFIER ON
1994GO
1995SET ANSI_PADDING ON
1996GO
1997CREATE TABLE [dbo].[migracion_consultorio](
1998	[id_spring] [int] NULL,
1999	[clinica_id_spring] [varchar](4) NULL,
2000	[nombre] [varchar](150) NULL,
2001	[estatus] [int] NULL,
2002	[fecha_sincronizacion] [datetime] NULL,
2003	[mensaje] [varchar](500) NULL
2004) ON [PRIMARY]
2005
2006GO
2007SET ANSI_PADDING OFF
2008GO
2009/****** Object:  Table [dbo].[migracion_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2010SET ANSI_NULLS ON
2011GO
2012SET QUOTED_IDENTIFIER ON
2013GO
2014SET ANSI_PADDING ON
2015GO
2016CREATE TABLE [dbo].[migracion_especialidad](
2017	[id_spring] [int] NULL,
2018	[nombre] [varchar](100) NULL,
2019	[fecha_sincronizacion] [datetime] NULL,
2020	[mensaje] [varchar](500) NULL
2021) ON [PRIMARY]
2022
2023GO
2024SET ANSI_PADDING OFF
2025GO
2026/****** Object:  Table [dbo].[migracion_horario]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2027SET ANSI_NULLS ON
2028GO
2029SET QUOTED_IDENTIFIER ON
2030GO
2031SET ANSI_PADDING ON
2032GO
2033CREATE TABLE [dbo].[migracion_horario](
2034	[id_spring] [int] NULL,
2035	[medico_id_spring] [int] NULL,
2036	[especialidad_id_spring] [int] NULL,
2037	[clinica_id_spring] [varchar](4) NULL,
2038	[consultorio_id_spring] [int] NULL,
2039	[tipo_turno] [varchar](1) NULL,
2040	[fecha_inicio] [date] NULL,
2041	[fecha_fin] [date] NULL,
2042	[hora_inicio] [time](5) NULL,
2043	[hora_fin] [time](5) NULL,
2044	[tiempo_atencion] [numeric](5, 0) NULL,
2045	[cantidad_turno] [int] NULL,
2046	[observacion] [varchar](250) NULL,
2047	[estatus] [int] NULL,
2048	[lunes] [int] NULL,
2049	[martes] [int] NULL,
2050	[miercoles] [int] NULL,
2051	[jueves] [int] NULL,
2052	[viernes] [int] NULL,
2053	[sabado] [int] NULL,
2054	[domingo] [int] NULL,
2055	[fecha_sincronizacion] [datetime] NULL,
2056	[mensaje] [varchar](500) NULL
2057) ON [PRIMARY]
2058
2059GO
2060SET ANSI_PADDING OFF
2061GO
2062/****** Object:  Table [dbo].[migracion_inasistencia]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2063SET ANSI_NULLS ON
2064GO
2065SET QUOTED_IDENTIFIER ON
2066GO
2067SET ANSI_PADDING ON
2068GO
2069CREATE TABLE [dbo].[migracion_inasistencia](
2070	[id_spring] [int] NULL,
2071	[secuencial] [int] NULL,
2072	[horario_id_spring] [int] NULL,
2073	[fecha_inicio] [datetime] NULL,
2074	[fecha_fin] [datetime] NULL,
2075	[estatus] [int] NULL,
2076	[fecha_sincronizacion] [datetime] NULL,
2077	[mensaje] [varchar](500) NULL
2078) ON [PRIMARY]
2079
2080GO
2081SET ANSI_PADDING OFF
2082GO
2083/****** Object:  Table [dbo].[migracion_medico]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2084SET ANSI_NULLS ON
2085GO
2086SET QUOTED_IDENTIFIER ON
2087GO
2088SET ANSI_PADDING ON
2089GO
2090CREATE TABLE [dbo].[migracion_medico](
2091	[id_migracion] [int] NULL,
2092	[id_spring] [int] NULL,
2093	[cmp] [varchar](40) NULL,
2094	[nombres] [varchar](200) NULL,
2095	[apellido_paterno] [varchar](200) NULL,
2096	[apellido_materno] [varchar](200) NULL,
2097	[fecha_sincronizacion] [datetime] NULL,
2098	[mensaje] [varchar](500) NULL
2099) ON [PRIMARY]
2100
2101GO
2102SET ANSI_PADDING OFF
2103GO
2104/****** Object:  Table [dbo].[migracion_medico_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2105SET ANSI_NULLS ON
2106GO
2107SET QUOTED_IDENTIFIER ON
2108GO
2109SET ANSI_PADDING ON
2110GO
2111CREATE TABLE [dbo].[migracion_medico_especialidad](
2112	[medico_id_spring] [int] NULL,
2113	[especialidad_id_spring] [int] NULL,
2114	[estado] [int] NULL,
2115	[fecha_sincronizacion] [datetime] NULL,
2116	[mensaje] [varchar](500) NULL
2117) ON [PRIMARY]
2118
2119GO
2120SET ANSI_PADDING OFF
2121GO
2122/****** Object:  Table [dbo].[migracion_paciente]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2123SET ANSI_NULLS ON
2124GO
2125SET QUOTED_IDENTIFIER ON
2126GO
2127SET ANSI_PADDING ON
2128GO
2129CREATE TABLE [dbo].[migracion_paciente](
2130	[id_spring] [int] NULL,
2131	[tipo_documento] [varchar](1) NULL,
2132	[numero_documento] [varchar](20) NULL,
2133	[nombres] [varchar](40) NULL,
2134	[apellido_paterno] [varchar](40) NULL,
2135	[apellido_materno] [varchar](40) NULL,
2136	[genero] [varchar](1) NULL,
2137	[fecha_nacimiento] [date] NULL,
2138	[estado_civil_id_spring] [varchar](1) NULL,
2139	[pais_id_spring] [varchar](4) NULL,
2140	[departamento_id_spring] [varchar](3) NULL,
2141	[provincia_id_spring] [varchar](3) NULL,
2142	[distrito_id_spring] [varchar](3) NULL,
2143	[direccion] [varchar](255) NULL,
2144	[correo] [varchar](255) NULL,
2145	[telefono_celular] [varchar](45) NULL,
2146	[imagen] [varchar](255) NULL,
2147	[fecha_sincronizacion] [datetime] NULL,
2148	[mensaje] [varchar](500) NULL
2149) ON [PRIMARY]
2150
2151GO
2152SET ANSI_PADDING OFF
2153GO
2154/****** Object:  Table [dbo].[migrations]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2155SET ANSI_NULLS ON
2156GO
2157SET QUOTED_IDENTIFIER ON
2158GO
2159CREATE TABLE [dbo].[migrations](
2160	[id] [bigint] IDENTITY(4,1) NOT NULL,
2161	[migration] [nvarchar](255) NOT NULL,
2162	[batch] [int] NOT NULL,
2163 CONSTRAINT [PK_migrations_id] PRIMARY KEY CLUSTERED 
2164(
2165	[id] ASC
2166)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2167) ON [PRIMARY]
2168
2169GO
2170/****** Object:  Table [dbo].[paciente]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2171SET ANSI_NULLS ON
2172GO
2173SET QUOTED_IDENTIFIER ON
2174GO
2175SET ANSI_PADDING ON
2176GO
2177CREATE TABLE [dbo].[paciente](
2178	[id_spring] [int] NOT NULL,
2179	[tipo_documento] [varchar](1) NOT NULL,
2180	[numero_documento] [varchar](20) NOT NULL,
2181	[nombres] [varchar](40) NOT NULL,
2182	[apellido_paterno] [varchar](40) NOT NULL,
2183	[apellido_materno] [varchar](40) NULL DEFAULT (NULL),
2184	[genero] [varchar](1) NULL DEFAULT (NULL),
2185	[fecha_nacimiento] [date] NULL DEFAULT (NULL),
2186	[estado_civil_id_spring] [varchar](1) NULL DEFAULT (NULL),
2187	[pais_id_spring] [varchar](4) NULL DEFAULT (NULL),
2188	[departamento_id_spring] [varchar](3) NULL CONSTRAINT [DF__paciente__depart__3335971A]  DEFAULT (NULL),
2189	[provincia_id_spring] [varchar](3) NULL CONSTRAINT [DF__paciente__provin__3429BB53]  DEFAULT (NULL),
2190	[distrito_id_spring] [varchar](3) NULL CONSTRAINT [DF__paciente__distri__351DDF8C]  DEFAULT (NULL),
2191	[direccion] [varchar](255) NULL DEFAULT (NULL),
2192	[correo] [varchar](255) NULL DEFAULT (NULL),
2193	[telefono_celular] [varchar](45) NOT NULL,
2194	[imagen] [varchar](255) NULL DEFAULT (NULL),
2195	[fecha_registro] [datetime2](0) NOT NULL,
2196	[origen_registro] [varchar](10) NOT NULL,
2197	[fecha_actualizacion] [datetime2](0) NOT NULL,
2198	[ver_historico] [int] NOT NULL DEFAULT ((0)),
2199	[tratamiento_datos] [int] NULL CONSTRAINT [DF_paciente_tratamiento_datos]  DEFAULT ((0)),
2200 CONSTRAINT [PK_paciente_id_spring] PRIMARY KEY CLUSTERED 
2201(
2202	[id_spring] ASC
2203)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
2204 CONSTRAINT [paciente_documento_tipo_numero_UNIQU] UNIQUE NONCLUSTERED 
2205(
2206	[tipo_documento] ASC,
2207	[numero_documento] ASC
2208)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2209) ON [PRIMARY]
2210
2211GO
2212SET ANSI_PADDING OFF
2213GO
2214/****** Object:  Table [dbo].[pais]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2215SET ANSI_NULLS ON
2216GO
2217SET QUOTED_IDENTIFIER ON
2218GO
2219SET ANSI_PADDING ON
2220GO
2221CREATE TABLE [dbo].[pais](
2222	[id_spring] [varchar](4) NOT NULL,
2223	[nombre] [varchar](40) NOT NULL,
2224	[estatus] [int] NOT NULL DEFAULT ((1)),
2225 CONSTRAINT [PK_pais_id_sprin] PRIMARY KEY CLUSTERED 
2226(
2227	[id_spring] ASC
2228)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2229) ON [PRIMARY]
2230
2231GO
2232SET ANSI_PADDING OFF
2233GO
2234/****** Object:  Table [dbo].[parametro]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2235SET ANSI_NULLS ON
2236GO
2237SET QUOTED_IDENTIFIER ON
2238GO
2239CREATE TABLE [dbo].[parametro](
2240	[id] [int] IDENTITY(15,1) NOT NULL,
2241	[clave] [nvarchar](200) NOT NULL,
2242	[descripcion] [nvarchar](200) NOT NULL,
2243	[valor] [nvarchar](max) NOT NULL,
2244	[fecha_actualizacion] [datetime2](0) NOT NULL,
2245 CONSTRAINT [PK_parametro_id] PRIMARY KEY CLUSTERED 
2246(
2247	[id] ASC
2248)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
2249 CONSTRAINT [parametro$codigo_UNIQUE] UNIQUE NONCLUSTERED 
2250(
2251	[clave] ASC
2252)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2253) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
2254
2255GO
2256/****** Object:  Table [dbo].[parentesco]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2257SET ANSI_NULLS ON
2258GO
2259SET QUOTED_IDENTIFIER ON
2260GO
2261SET ANSI_PADDING ON
2262GO
2263CREATE TABLE [dbo].[parentesco](
2264	[id] [int] IDENTITY(5,1) NOT NULL,
2265	[nombre] [varchar](40) NOT NULL,
2266	[estatus] [int] NOT NULL DEFAULT ((1)),
2267 CONSTRAINT [PK_parentesco_id] PRIMARY KEY CLUSTERED 
2268(
2269	[id] ASC
2270)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2271) ON [PRIMARY]
2272
2273GO
2274SET ANSI_PADDING OFF
2275GO
2276/****** Object:  Table [dbo].[provincia]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2277SET ANSI_NULLS ON
2278GO
2279SET QUOTED_IDENTIFIER ON
2280GO
2281SET ANSI_PADDING ON
2282GO
2283CREATE TABLE [dbo].[provincia](
2284	[departamento_id_spring] [varchar](3) NOT NULL,
2285	[id_spring] [varchar](3) NOT NULL,
2286	[nombre] [varchar](40) NOT NULL,
2287	[estatus] [int] NOT NULL CONSTRAINT [DF__provincia__estat__3EDC53F0]  DEFAULT ((1)),
2288 CONSTRAINT [PK_provincia_id_spring] PRIMARY KEY CLUSTERED 
2289(
2290	[id_spring] ASC,
2291	[departamento_id_spring] ASC
2292)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2293) ON [PRIMARY]
2294
2295GO
2296SET ANSI_PADDING OFF
2297GO
2298/****** Object:  Table [dbo].[usuario]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2299SET ANSI_NULLS ON
2300GO
2301SET QUOTED_IDENTIFIER ON
2302GO
2303SET ANSI_PADDING ON
2304GO
2305CREATE TABLE [dbo].[usuario](
2306	[id] [int] IDENTITY(32,1) NOT NULL,
2307	[tipo_documento] [varchar](1) NOT NULL,
2308	[numero_documento] [varchar](20) NOT NULL,
2309	[password] [nvarchar](60) NOT NULL,
2310	[correo] [nvarchar](255) NOT NULL,
2311	[estatus] [int] NOT NULL DEFAULT ((2)),
2312	[fecha_registro] [datetime2](0) NOT NULL,
2313	[fecha_activacion] [datetime2](0) NULL DEFAULT (NULL),
2314	[fecha_ultimo_acceso] [datetime2](0) NULL DEFAULT (NULL),
2315	[paciente_id_spring] [int] NOT NULL,
2316	[origen_registro] [nvarchar](10) NOT NULL,
2317	[tipo_dispositivo] [nvarchar](10) NULL DEFAULT (NULL),
2318	[token_push] [nvarchar](255) NULL DEFAULT (NULL),
2319	[api_token] [nvarchar](255) NULL DEFAULT (NULL),
2320	[web_token] [nvarchar](255) NULL DEFAULT (NULL),
2321	[activacion_token] [nvarchar](255) NULL DEFAULT (NULL),
2322 CONSTRAINT [PK_usuario_id] PRIMARY KEY CLUSTERED 
2323(
2324	[id] ASC
2325)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
2326 CONSTRAINT [usuario$documento_tipo_numero_UNIQUE] UNIQUE NONCLUSTERED 
2327(
2328	[tipo_documento] ASC,
2329	[numero_documento] ASC
2330)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
2331 CONSTRAINT [usuario$paciente_id_UNIQUE] UNIQUE NONCLUSTERED 
2332(
2333	[paciente_id_spring] ASC
2334)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2335) ON [PRIMARY]
2336
2337GO
2338SET ANSI_PADDING OFF
2339GO
2340/****** Object:  Table [dbo].[usuario_medico_favorito]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2341SET ANSI_NULLS ON
2342GO
2343SET QUOTED_IDENTIFIER ON
2344GO
2345CREATE TABLE [dbo].[usuario_medico_favorito](
2346	[usuario_id] [int] NOT NULL,
2347	[medico_id_spring] [int] NOT NULL,
2348	[especialidad_id_spring] [int] NOT NULL,
2349 CONSTRAINT [PK_usuario_medico_favorito_usuario_id] PRIMARY KEY CLUSTERED 
2350(
2351	[usuario_id] ASC,
2352	[medico_id_spring] ASC,
2353	[especialidad_id_spring] ASC
2354)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2355) ON [PRIMARY]
2356
2357GO
2358/****** Object:  Table [dbo].[usuario_paciente]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2359SET ANSI_NULLS ON
2360GO
2361SET QUOTED_IDENTIFIER ON
2362GO
2363CREATE TABLE [dbo].[usuario_paciente](
2364	[usuario_id] [int] NOT NULL,
2365	[paciente_id_spring] [int] NOT NULL,
2366	[parentesco_id] [int] NOT NULL,
2367 CONSTRAINT [PK_usuario_paciente_usuario_id] PRIMARY KEY CLUSTERED 
2368(
2369	[usuario_id] ASC,
2370	[paciente_id_spring] ASC
2371)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
2372 CONSTRAINT [usuario_paciente$paciente_id_spring_UNIQUE] UNIQUE NONCLUSTERED 
2373(
2374	[paciente_id_spring] ASC
2375)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2376) ON [PRIMARY]
2377
2378GO
2379/****** Object:  Table [dbo].[work_cita]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2380SET ANSI_NULLS ON
2381GO
2382SET QUOTED_IDENTIFIER ON
2383GO
2384SET ANSI_PADDING ON
2385GO
2386CREATE TABLE [dbo].[work_cita](
2387	[id_spring] [int] NULL,
2388	[horario_id_spring] [int] NULL,
2389	[fecha_cita] [datetime] NULL,
2390	[turno] [int] NULL,
2391	[paciente_id_spring] [int] NULL,
2392	[fecha_registro] [datetime] NULL,
2393	[origen_registro] [varchar](10) NULL,
2394	[estatus_pago] [int] NULL,
2395	[estatus] [int] NULL,
2396	[accion] [varchar](1) NULL,
2397	[mensaje] [varchar](500) NULL
2398) ON [PRIMARY]
2399
2400GO
2401SET ANSI_PADDING OFF
2402GO
2403/****** Object:  Table [dbo].[work_cita_bloqueo_manual]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2404SET ANSI_NULLS ON
2405GO
2406SET QUOTED_IDENTIFIER ON
2407GO
2408CREATE TABLE [dbo].[work_cita_bloqueo_manual](
2409	[medico_id_spring] [int] NULL,
2410	[fecha] [datetime] NULL,
2411	[estatus] [int] NULL
2412) ON [PRIMARY]
2413
2414GO
2415/****** Object:  Table [dbo].[work_clinica_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2416SET ANSI_NULLS ON
2417GO
2418SET QUOTED_IDENTIFIER ON
2419GO
2420SET ANSI_PADDING ON
2421GO
2422CREATE TABLE [dbo].[work_clinica_especialidad](
2423	[clinica_id_spring] [varchar](4) NULL,
2424	[especialidad_id_spring] [int] NULL,
2425	[mensaje] [varchar](500) NULL
2426) ON [PRIMARY]
2427
2428GO
2429SET ANSI_PADDING OFF
2430GO
2431/****** Object:  Table [dbo].[work_clinica_medico]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2432SET ANSI_NULLS ON
2433GO
2434SET QUOTED_IDENTIFIER ON
2435GO
2436SET ANSI_PADDING ON
2437GO
2438CREATE TABLE [dbo].[work_clinica_medico](
2439	[clinica_id_spring] [varchar](4) NULL,
2440	[medico_id_spring] [int] NULL,
2441	[estado] [int] NULL,
2442	[accion] [varchar](1) NULL,
2443	[mensaje] [varchar](500) NULL
2444) ON [PRIMARY]
2445
2446GO
2447SET ANSI_PADDING OFF
2448GO
2449/****** Object:  Table [dbo].[work_consultorio]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2450SET ANSI_NULLS ON
2451GO
2452SET QUOTED_IDENTIFIER ON
2453GO
2454SET ANSI_PADDING ON
2455GO
2456CREATE TABLE [dbo].[work_consultorio](
2457	[id_spring] [int] NULL,
2458	[clinica_id_spring] [varchar](4) NULL,
2459	[nombre] [varchar](150) NULL,
2460	[estatus] [int] NULL,
2461	[accion] [varchar](1) NULL,
2462	[mensaje] [varchar](500) NULL
2463) ON [PRIMARY]
2464
2465GO
2466SET ANSI_PADDING OFF
2467GO
2468/****** Object:  Table [dbo].[work_departamento]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2469SET ANSI_NULLS ON
2470GO
2471SET QUOTED_IDENTIFIER ON
2472GO
2473SET ANSI_PADDING ON
2474GO
2475CREATE TABLE [dbo].[work_departamento](
2476	[id_spring] [varchar](3) NULL,
2477	[pais_id_spring] [varchar](4) NULL,
2478	[nombre] [varchar](40) NULL
2479) ON [PRIMARY]
2480
2481GO
2482SET ANSI_PADDING OFF
2483GO
2484/****** Object:  Table [dbo].[work_distrito]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2485SET ANSI_NULLS ON
2486GO
2487SET QUOTED_IDENTIFIER ON
2488GO
2489SET ANSI_PADDING ON
2490GO
2491CREATE TABLE [dbo].[work_distrito](
2492	[id_spring] [varchar](3) NULL,
2493	[provincia_id_spring] [varchar](3) NULL,
2494	[departamento_id_spring] [varchar](3) NULL,
2495	[nombre] [varchar](40) NULL
2496) ON [PRIMARY]
2497
2498GO
2499SET ANSI_PADDING OFF
2500GO
2501/****** Object:  Table [dbo].[work_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2502SET ANSI_NULLS ON
2503GO
2504SET QUOTED_IDENTIFIER ON
2505GO
2506SET ANSI_PADDING ON
2507GO
2508CREATE TABLE [dbo].[work_especialidad](
2509	[id_spring] [int] NULL,
2510	[nombre] [varchar](100) NULL,
2511	[accion] [varchar](1) NULL,
2512	[mensaje] [varchar](500) NULL
2513) ON [PRIMARY]
2514
2515GO
2516SET ANSI_PADDING OFF
2517GO
2518/****** Object:  Table [dbo].[work_estado_civil]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2519SET ANSI_NULLS ON
2520GO
2521SET QUOTED_IDENTIFIER ON
2522GO
2523SET ANSI_PADDING ON
2524GO
2525CREATE TABLE [dbo].[work_estado_civil](
2526	[id_spring] [varchar](1) NULL,
2527	[nombre] [varchar](45) NULL
2528) ON [PRIMARY]
2529
2530GO
2531SET ANSI_PADDING OFF
2532GO
2533/****** Object:  Table [dbo].[work_horario]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2534SET ANSI_NULLS ON
2535GO
2536SET QUOTED_IDENTIFIER ON
2537GO
2538SET ANSI_PADDING ON
2539GO
2540CREATE TABLE [dbo].[work_horario](
2541	[id_spring] [int] NULL,
2542	[medico_id_spring] [int] NULL,
2543	[especialidad_id_spring] [int] NULL,
2544	[clinica_id_spring] [varchar](4) NULL,
2545	[consultorio_id_spring] [int] NULL,
2546	[tipo_turno] [varchar](1) NULL,
2547	[fecha_inicio] [date] NULL,
2548	[fecha_fin] [date] NULL,
2549	[hora_inicio] [time](5) NULL,
2550	[hora_fin] [time](5) NULL,
2551	[tiempo_atencion] [numeric](5, 0) NULL,
2552	[cantidad_turno] [int] NULL,
2553	[observacion] [varchar](250) NULL,
2554	[estatus] [int] NULL,
2555	[lunes] [int] NULL,
2556	[martes] [int] NULL,
2557	[miercoles] [int] NULL,
2558	[jueves] [int] NULL,
2559	[viernes] [int] NULL,
2560	[sabado] [int] NULL,
2561	[domingo] [int] NULL,
2562	[accion] [varchar](1) NULL,
2563	[mensaje] [varchar](500) NULL
2564) ON [PRIMARY]
2565
2566GO
2567SET ANSI_PADDING OFF
2568GO
2569/****** Object:  Table [dbo].[work_inasistencia]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2570SET ANSI_NULLS ON
2571GO
2572SET QUOTED_IDENTIFIER ON
2573GO
2574SET ANSI_PADDING ON
2575GO
2576CREATE TABLE [dbo].[work_inasistencia](
2577	[id_spring] [int] NULL,
2578	[secuencial] [int] NULL,
2579	[horario_id_spring] [int] NULL,
2580	[fecha_inicio] [datetime] NULL,
2581	[fecha_fin] [datetime] NULL,
2582	[estatus] [int] NULL,
2583	[accion] [varchar](1) NULL,
2584	[mensaje] [varchar](500) NULL
2585) ON [PRIMARY]
2586
2587GO
2588SET ANSI_PADDING OFF
2589GO
2590/****** Object:  Table [dbo].[work_medico]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2591SET ANSI_NULLS ON
2592GO
2593SET QUOTED_IDENTIFIER ON
2594GO
2595SET ANSI_PADDING ON
2596GO
2597CREATE TABLE [dbo].[work_medico](
2598	[id_spring] [int] NULL,
2599	[cmp] [varchar](40) NULL,
2600	[nombres] [varchar](200) NULL,
2601	[apellido_paterno] [varchar](200) NULL,
2602	[apellido_materno] [varchar](200) NULL,
2603	[disponible_cita_app] [int] NULL,
2604	[estatus] [int] NULL,
2605	[accion] [varchar](1) NULL,
2606	[mensaje] [varchar](500) NULL
2607) ON [PRIMARY]
2608
2609GO
2610SET ANSI_PADDING OFF
2611GO
2612/****** Object:  Table [dbo].[work_medico_especialidad]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2613SET ANSI_NULLS ON
2614GO
2615SET QUOTED_IDENTIFIER ON
2616GO
2617SET ANSI_PADDING ON
2618GO
2619CREATE TABLE [dbo].[work_medico_especialidad](
2620	[medico_id_spring] [int] NULL,
2621	[especialidad_id_spring] [int] NULL,
2622	[estado] [int] NULL,
2623	[accion] [varchar](1) NULL,
2624	[mensaje] [varchar](500) NULL
2625) ON [PRIMARY]
2626
2627GO
2628SET ANSI_PADDING OFF
2629GO
2630/****** Object:  Table [dbo].[work_paciente]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2631SET ANSI_NULLS ON
2632GO
2633SET QUOTED_IDENTIFIER ON
2634GO
2635SET ANSI_PADDING ON
2636GO
2637CREATE TABLE [dbo].[work_paciente](
2638	[id_spring] [int] NULL,
2639	[tipo_documento] [varchar](1) NULL,
2640	[numero_documento] [varchar](20) NULL,
2641	[nombres] [varchar](40) NULL,
2642	[apellido_paterno] [varchar](40) NULL,
2643	[apellido_materno] [varchar](40) NULL,
2644	[genero] [varchar](1) NULL,
2645	[fecha_nacimiento] [date] NULL,
2646	[estado_civil_id_spring] [varchar](1) NULL,
2647	[pais_id_spring] [varchar](4) NULL,
2648	[departamento_id_spring] [varchar](3) NULL,
2649	[provincia_id_spring] [varchar](3) NULL,
2650	[distrito_id_spring] [varchar](3) NULL,
2651	[direccion] [varchar](255) NULL,
2652	[correo] [varchar](255) NULL,
2653	[telefono_celular] [varchar](45) NULL,
2654	[imagen] [varchar](255) NULL,
2655	[accion] [varchar](1) NULL,
2656	[mensaje] [varchar](500) NULL
2657) ON [PRIMARY]
2658
2659GO
2660SET ANSI_PADDING OFF
2661GO
2662/****** Object:  Table [dbo].[work_pais]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2663SET ANSI_NULLS ON
2664GO
2665SET QUOTED_IDENTIFIER ON
2666GO
2667SET ANSI_PADDING ON
2668GO
2669CREATE TABLE [dbo].[work_pais](
2670	[id_spring] [varchar](4) NULL,
2671	[nombre] [varchar](40) NULL
2672) ON [PRIMARY]
2673
2674GO
2675SET ANSI_PADDING OFF
2676GO
2677/****** Object:  Table [dbo].[work_provincia]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2678SET ANSI_NULLS ON
2679GO
2680SET QUOTED_IDENTIFIER ON
2681GO
2682SET ANSI_PADDING ON
2683GO
2684CREATE TABLE [dbo].[work_provincia](
2685	[id_spring] [varchar](3) NULL,
2686	[departamento_id_spring] [varchar](3) NULL,
2687	[nombre] [varchar](40) NULL
2688) ON [PRIMARY]
2689
2690GO
2691SET ANSI_PADDING OFF
2692GO
2693/****** Object:  Table [dbo].[work_sincronizacion]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2694SET ANSI_NULLS ON
2695GO
2696SET QUOTED_IDENTIFIER ON
2697GO
2698CREATE TABLE [dbo].[work_sincronizacion](
2699	[tipo_sincronizacion] [nvarchar](50) NOT NULL,
2700	[fecha_sincronizacion] [datetime] NULL,
2701 CONSTRAINT [PK_fechas_sincronizacion_tipo_sincronizacion] PRIMARY KEY CLUSTERED 
2702(
2703	[tipo_sincronizacion] ASC
2704)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2705) ON [PRIMARY]
2706
2707GO
2708/****** Object:  Index [fk_audit_app_notificacion_usuario_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2709CREATE NONCLUSTERED INDEX [fk_audit_app_notificacion_usuario_idx] ON [dbo].[app_notificacion]
2710(
2711	[usuario_id] ASC
2712)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2713GO
2714/****** Object:  Index [cita_fecha_actualizacion_IX]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2715CREATE NONCLUSTERED INDEX [cita_fecha_actualizacion_IX] ON [dbo].[cita]
2716(
2717	[fecha_cita] ASC,
2718	[turno] ASC
2719)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2720GO
2721/****** Object:  Index [fk_cita_paciente_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2722CREATE NONCLUSTERED INDEX [fk_cita_paciente_idx] ON [dbo].[cita]
2723(
2724	[paciente_id_spring] ASC
2725)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2726GO
2727/****** Object:  Index [cita_bloqueo_manual_medico_id_spring_fecha_UQ]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2728CREATE UNIQUE NONCLUSTERED INDEX [cita_bloqueo_manual_medico_id_spring_fecha_UQ] ON [dbo].[cita_bloqueo_manual]
2729(
2730	[medico_id_spring] ASC,
2731	[fecha] ASC
2732)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2733GO
2734/****** Object:  Index [fk_cita_bloque_manual_medico1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2735CREATE NONCLUSTERED INDEX [fk_cita_bloque_manual_medico1_idx] ON [dbo].[cita_bloqueo_manual]
2736(
2737	[medico_id_spring] ASC
2738)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2739GO
2740SET ANSI_PADDING ON
2741
2742GO
2743/****** Object:  Index [fk_cita_historica_clinica1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2744CREATE NONCLUSTERED INDEX [fk_cita_historica_clinica1_idx] ON [dbo].[cita_historica]
2745(
2746	[clinica_id_spring] ASC
2747)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2748GO
2749/****** Object:  Index [fk_cita_historica_especialidad1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2750CREATE NONCLUSTERED INDEX [fk_cita_historica_especialidad1_idx] ON [dbo].[cita_historica]
2751(
2752	[especialidad_id_spring] ASC
2753)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2754GO
2755/****** Object:  Index [fk_cita_historica_horario1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2756CREATE NONCLUSTERED INDEX [fk_cita_historica_horario1_idx] ON [dbo].[cita_historica]
2757(
2758	[horario_id_spring] ASC
2759)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2760GO
2761/****** Object:  Index [fk_cita_historica_medico1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2762CREATE NONCLUSTERED INDEX [fk_cita_historica_medico1_idx] ON [dbo].[cita_historica]
2763(
2764	[medico_id_spring] ASC
2765)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2766GO
2767/****** Object:  Index [fk_cita_historica_paciente1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2768CREATE NONCLUSTERED INDEX [fk_cita_historica_paciente1_idx] ON [dbo].[cita_historica]
2769(
2770	[paciente_id_spring] ASC
2771)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2772GO
2773SET ANSI_PADDING ON
2774
2775GO
2776/****** Object:  Index [fk_clinica_especialidad_clinica_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2777CREATE NONCLUSTERED INDEX [fk_clinica_especialidad_clinica_idx] ON [dbo].[clinica_especialidad]
2778(
2779	[clinica_id_spring] ASC
2780)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2781GO
2782/****** Object:  Index [fk_clinica_especialidad_especialidad_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2783CREATE NONCLUSTERED INDEX [fk_clinica_especialidad_especialidad_idx] ON [dbo].[clinica_especialidad]
2784(
2785	[especialidad_id_spring] ASC
2786)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2787GO
2788SET ANSI_PADDING ON
2789
2790GO
2791/****** Object:  Index [fk_clinica_medico_clinica_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2792CREATE NONCLUSTERED INDEX [fk_clinica_medico_clinica_idx] ON [dbo].[clinica_medico]
2793(
2794	[clinica_id_spring] ASC
2795)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2796GO
2797/****** Object:  Index [fk_clinica_medico_medico_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2798CREATE NONCLUSTERED INDEX [fk_clinica_medico_medico_idx] ON [dbo].[clinica_medico]
2799(
2800	[medico_id_spring] ASC
2801)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2802GO
2803SET ANSI_PADDING ON
2804
2805GO
2806/****** Object:  Index [fk_consultorio_clinica1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2807CREATE NONCLUSTERED INDEX [fk_consultorio_clinica1_idx] ON [dbo].[consultorio]
2808(
2809	[clinica_id_spring] ASC
2810)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2811GO
2812/****** Object:  Index [fk_encuesta_pregunta_respuesta_encuesta_respuesta_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2813CREATE NONCLUSTERED INDEX [fk_encuesta_pregunta_respuesta_encuesta_respuesta_idx] ON [dbo].[encuesta_pregunta_respuesta]
2814(
2815	[encuesta_respuesta_id] ASC
2816)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2817GO
2818/****** Object:  Index [fk_encuesta_respuesta_encuesta_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2819CREATE NONCLUSTERED INDEX [fk_encuesta_respuesta_encuesta_idx] ON [dbo].[encuesta_pregunta_respuesta]
2820(
2821	[encuesta_id] ASC
2822)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2823GO
2824/****** Object:  Index [fk_encuesta_cita_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2825CREATE NONCLUSTERED INDEX [fk_encuesta_cita_idx] ON [dbo].[encuesta_respuesta]
2826(
2827	[cita_id_spring] ASC
2828)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2829GO
2830/****** Object:  Index [fk_encuesta_usuario_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2831CREATE NONCLUSTERED INDEX [fk_encuesta_usuario_idx] ON [dbo].[encuesta_respuesta]
2832(
2833	[usuario_id] ASC
2834)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2835GO
2836SET ANSI_PADDING ON
2837
2838GO
2839/****** Object:  Index [fk_disponibilidad_clinica_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2840CREATE NONCLUSTERED INDEX [fk_disponibilidad_clinica_idx] ON [dbo].[horario]
2841(
2842	[clinica_id_spring] ASC
2843)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2844GO
2845/****** Object:  Index [fk_disponibilidad_medico_especialidad_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2846CREATE NONCLUSTERED INDEX [fk_disponibilidad_medico_especialidad_idx] ON [dbo].[horario]
2847(
2848	[medico_id_spring] ASC,
2849	[especialidad_id_spring] ASC
2850)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2851GO
2852/****** Object:  Index [fk_horario_consultorio_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2853CREATE NONCLUSTERED INDEX [fk_horario_consultorio_idx] ON [dbo].[horario]
2854(
2855	[consultorio_id_spring] ASC
2856)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2857GO
2858/****** Object:  Index [fk_horario_detalle_horario_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2859CREATE NONCLUSTERED INDEX [fk_horario_detalle_horario_idx] ON [dbo].[horario_detalle]
2860(
2861	[horario_id_spring] ASC
2862)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2863GO
2864/****** Object:  Index [IDX_dia]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2865CREATE NONCLUSTERED INDEX [IDX_dia] ON [dbo].[horario_detalle]
2866(
2867	[dia] ASC
2868)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2869GO
2870/****** Object:  Index [fk_inasistencia_horario1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2871CREATE NONCLUSTERED INDEX [fk_inasistencia_horario1_idx] ON [dbo].[inasistencia]
2872(
2873	[horario_id_spring] ASC
2874)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2875GO
2876SET ANSI_PADDING ON
2877
2878GO
2879/****** Object:  Index [jobs_queue_index]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2880CREATE NONCLUSTERED INDEX [jobs_queue_index] ON [dbo].[jobs]
2881(
2882	[queue] ASC
2883)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2884GO
2885/****** Object:  Index [fk_medico_especialidad_especialidad_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2886CREATE NONCLUSTERED INDEX [fk_medico_especialidad_especialidad_idx] ON [dbo].[medico_especialidad]
2887(
2888	[especialidad_id_spring] ASC
2889)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2890GO
2891/****** Object:  Index [fk_medico_especialidad_medico_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2892CREATE NONCLUSTERED INDEX [fk_medico_especialidad_medico_idx] ON [dbo].[medico_especialidad]
2893(
2894	[medico_id_spring] ASC
2895)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2896GO
2897SET ANSI_PADDING ON
2898
2899GO
2900/****** Object:  Index [fk_provincia_departamento1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2901CREATE NONCLUSTERED INDEX [fk_provincia_departamento1_idx] ON [dbo].[provincia]
2902(
2903	[departamento_id_spring] ASC
2904)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2905GO
2906/****** Object:  Index [fk_usuario_paciente_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2907CREATE NONCLUSTERED INDEX [fk_usuario_paciente_idx] ON [dbo].[usuario]
2908(
2909	[paciente_id_spring] ASC
2910)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2911GO
2912/****** Object:  Index [fk_usuario_medico_favorito_medico_especialidad1_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2913CREATE NONCLUSTERED INDEX [fk_usuario_medico_favorito_medico_especialidad1_idx] ON [dbo].[usuario_medico_favorito]
2914(
2915	[medico_id_spring] ASC,
2916	[especialidad_id_spring] ASC
2917)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2918GO
2919/****** Object:  Index [fk_usuario_medico_favorito_usuario_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2920CREATE NONCLUSTERED INDEX [fk_usuario_medico_favorito_usuario_idx] ON [dbo].[usuario_medico_favorito]
2921(
2922	[usuario_id] ASC
2923)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2924GO
2925/****** Object:  Index [fk_usuario_paciente_paciente_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2926CREATE NONCLUSTERED INDEX [fk_usuario_paciente_paciente_idx] ON [dbo].[usuario_paciente]
2927(
2928	[paciente_id_spring] ASC
2929)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2930GO
2931/****** Object:  Index [fk_usuario_paciente_parentesco_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2932CREATE NONCLUSTERED INDEX [fk_usuario_paciente_parentesco_idx] ON [dbo].[usuario_paciente]
2933(
2934	[parentesco_id] ASC
2935)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2936GO
2937/****** Object:  Index [fk_usuario_paciente_usuario_idx]    Script Date: 31/07/2018 11:15:41 p.m. ******/
2938CREATE NONCLUSTERED INDEX [fk_usuario_paciente_usuario_idx] ON [dbo].[usuario_paciente]
2939(
2940	[usuario_id] ASC
2941)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
2942GO
2943ALTER TABLE [dbo].[cita_bloqueo_manual] ADD  DEFAULT ((1)) FOR [estatus]
2944GO
2945ALTER TABLE [dbo].[failed_jobs] ADD  DEFAULT (getdate()) FOR [failed_at]
2946GO
2947ALTER TABLE [dbo].[jobs] ADD  DEFAULT (NULL) FOR [reserved_at]
2948GO
2949ALTER TABLE [dbo].[app_notificacion]  WITH NOCHECK ADD  CONSTRAINT [app_notificacion$fk_audit_app_notificacion_usuario] FOREIGN KEY([usuario_id])
2950REFERENCES [dbo].[usuario] ([id])
2951GO
2952ALTER TABLE [dbo].[app_notificacion] CHECK CONSTRAINT [app_notificacion$fk_audit_app_notificacion_usuario]
2953GO
2954ALTER TABLE [dbo].[cita]  WITH NOCHECK ADD  CONSTRAINT [cita$fk_cita_horario] FOREIGN KEY([horario_id_spring])
2955REFERENCES [dbo].[horario] ([id_spring])
2956GO
2957ALTER TABLE [dbo].[cita] CHECK CONSTRAINT [cita$fk_cita_horario]
2958GO
2959ALTER TABLE [dbo].[cita_bloqueo_manual]  WITH NOCHECK ADD  CONSTRAINT [cita_bloqueo_manual$fk_cita_bloque_manual_medico1] FOREIGN KEY([medico_id_spring])
2960REFERENCES [dbo].[medico] ([id_spring])
2961GO
2962ALTER TABLE [dbo].[cita_bloqueo_manual] CHECK CONSTRAINT [cita_bloqueo_manual$fk_cita_bloque_manual_medico1]
2963GO
2964ALTER TABLE [dbo].[cita_historica]  WITH NOCHECK ADD  CONSTRAINT [cita_historica$fk_cita_historica_clinica1] FOREIGN KEY([clinica_id_spring])
2965REFERENCES [dbo].[clinica] ([id_spring])
2966GO
2967ALTER TABLE [dbo].[cita_historica] CHECK CONSTRAINT [cita_historica$fk_cita_historica_clinica1]
2968GO
2969ALTER TABLE [dbo].[cita_historica]  WITH NOCHECK ADD  CONSTRAINT [cita_historica$fk_cita_historica_especialidad1] FOREIGN KEY([especialidad_id_spring])
2970REFERENCES [dbo].[especialidad] ([id_spring])
2971GO
2972ALTER TABLE [dbo].[cita_historica] CHECK CONSTRAINT [cita_historica$fk_cita_historica_especialidad1]
2973GO
2974ALTER TABLE [dbo].[cita_historica]  WITH NOCHECK ADD  CONSTRAINT [cita_historica$fk_cita_historica_horario1] FOREIGN KEY([horario_id_spring])
2975REFERENCES [dbo].[horario] ([id_spring])
2976GO
2977ALTER TABLE [dbo].[cita_historica] CHECK CONSTRAINT [cita_historica$fk_cita_historica_horario1]
2978GO
2979ALTER TABLE [dbo].[cita_historica]  WITH NOCHECK ADD  CONSTRAINT [cita_historica$fk_cita_historica_medico1] FOREIGN KEY([medico_id_spring])
2980REFERENCES [dbo].[medico] ([id_spring])
2981GO
2982ALTER TABLE [dbo].[cita_historica] CHECK CONSTRAINT [cita_historica$fk_cita_historica_medico1]
2983GO
2984ALTER TABLE [dbo].[clinica_especialidad]  WITH NOCHECK ADD  CONSTRAINT [clinica_especialidad$fk_clinica_especialidad_clinica] FOREIGN KEY([clinica_id_spring])
2985REFERENCES [dbo].[clinica] ([id_spring])
2986GO
2987ALTER TABLE [dbo].[clinica_especialidad] CHECK CONSTRAINT [clinica_especialidad$fk_clinica_especialidad_clinica]
2988GO
2989ALTER TABLE [dbo].[clinica_especialidad]  WITH NOCHECK ADD  CONSTRAINT [clinica_especialidad$fk_clinica_especialidad_especialidad] FOREIGN KEY([especialidad_id_spring])
2990REFERENCES [dbo].[especialidad] ([id_spring])
2991GO
2992ALTER TABLE [dbo].[clinica_especialidad] CHECK CONSTRAINT [clinica_especialidad$fk_clinica_especialidad_especialidad]
2993GO
2994ALTER TABLE [dbo].[clinica_medico]  WITH NOCHECK ADD  CONSTRAINT [clinica_medico$fk_clinica_medico_clinica] FOREIGN KEY([clinica_id_spring])
2995REFERENCES [dbo].[clinica] ([id_spring])
2996GO
2997ALTER TABLE [dbo].[clinica_medico] CHECK CONSTRAINT [clinica_medico$fk_clinica_medico_clinica]
2998GO
2999ALTER TABLE [dbo].[clinica_medico]  WITH NOCHECK ADD  CONSTRAINT [clinica_medico$fk_clinica_medico_medico] FOREIGN KEY([medico_id_spring])
3000REFERENCES [dbo].[medico] ([id_spring])
3001GO
3002ALTER TABLE [dbo].[clinica_medico] CHECK CONSTRAINT [clinica_medico$fk_clinica_medico_medico]
3003GO
3004ALTER TABLE [dbo].[consultorio]  WITH NOCHECK ADD  CONSTRAINT [consultorio$fk_consultorio_clinica1] FOREIGN KEY([clinica_id_spring])
3005REFERENCES [dbo].[clinica] ([id_spring])
3006GO
3007ALTER TABLE [dbo].[consultorio] CHECK CONSTRAINT [consultorio$fk_consultorio_clinica1]
3008GO
3009ALTER TABLE [dbo].[departamento]  WITH CHECK ADD  CONSTRAINT [FK_departamento_pais] FOREIGN KEY([pais_id_spring])
3010REFERENCES [dbo].[pais] ([id_spring])
3011GO
3012ALTER TABLE [dbo].[departamento] CHECK CONSTRAINT [FK_departamento_pais]
3013GO
3014ALTER TABLE [dbo].[distrito]  WITH CHECK ADD  CONSTRAINT [FK_distrito_provincia] FOREIGN KEY([provincia_id_spring], [departamento_id_spring])
3015REFERENCES [dbo].[provincia] ([id_spring], [departamento_id_spring])
3016GO
3017ALTER TABLE [dbo].[distrito] CHECK CONSTRAINT [FK_distrito_provincia]
3018GO
3019ALTER TABLE [dbo].[encuesta_pregunta_respuesta]  WITH NOCHECK ADD  CONSTRAINT [encuesta_pregunta_respuesta$fk_encuesta_pregunta_respuesta_encuesta_respuesta] FOREIGN KEY([encuesta_respuesta_id])
3020REFERENCES [dbo].[encuesta_respuesta] ([id])
3021GO
3022ALTER TABLE [dbo].[encuesta_pregunta_respuesta] CHECK CONSTRAINT [encuesta_pregunta_respuesta$fk_encuesta_pregunta_respuesta_encuesta_respuesta]
3023GO
3024ALTER TABLE [dbo].[encuesta_pregunta_respuesta]  WITH NOCHECK ADD  CONSTRAINT [encuesta_pregunta_respuesta$fk_encuesta_respuesta_encuesta] FOREIGN KEY([encuesta_id])
3025REFERENCES [dbo].[encuesta] ([id])
3026GO
3027ALTER TABLE [dbo].[encuesta_pregunta_respuesta] CHECK CONSTRAINT [encuesta_pregunta_respuesta$fk_encuesta_respuesta_encuesta]
3028GO
3029ALTER TABLE [dbo].[encuesta_respuesta]  WITH NOCHECK ADD  CONSTRAINT [encuesta_respuesta$fk_encuesta_cita] FOREIGN KEY([cita_id_spring])
3030REFERENCES [dbo].[cita_historica] ([id_spring])
3031GO
3032ALTER TABLE [dbo].[encuesta_respuesta] CHECK CONSTRAINT [encuesta_respuesta$fk_encuesta_cita]
3033GO
3034ALTER TABLE [dbo].[encuesta_respuesta]  WITH NOCHECK ADD  CONSTRAINT [encuesta_respuesta$fk_encuesta_usuario] FOREIGN KEY([usuario_id])
3035REFERENCES [dbo].[usuario] ([id])
3036GO
3037ALTER TABLE [dbo].[encuesta_respuesta] CHECK CONSTRAINT [encuesta_respuesta$fk_encuesta_usuario]
3038GO
3039ALTER TABLE [dbo].[horario]  WITH NOCHECK ADD  CONSTRAINT [horario$fk_disponibilidad_clinica] FOREIGN KEY([clinica_id_spring])
3040REFERENCES [dbo].[clinica] ([id_spring])
3041GO
3042ALTER TABLE [dbo].[horario] CHECK CONSTRAINT [horario$fk_disponibilidad_clinica]
3043GO
3044ALTER TABLE [dbo].[horario]  WITH NOCHECK ADD  CONSTRAINT [horario$fk_disponibilidad_medico_especialidad] FOREIGN KEY([medico_id_spring], [especialidad_id_spring])
3045REFERENCES [dbo].[medico_especialidad] ([medico_id_spring], [especialidad_id_spring])
3046GO
3047ALTER TABLE [dbo].[horario] CHECK CONSTRAINT [horario$fk_disponibilidad_medico_especialidad]
3048GO
3049ALTER TABLE [dbo].[horario]  WITH NOCHECK ADD  CONSTRAINT [horario$fk_horario_consultorio] FOREIGN KEY([consultorio_id_spring])
3050REFERENCES [dbo].[consultorio] ([id_spring])
3051GO
3052ALTER TABLE [dbo].[horario] CHECK CONSTRAINT [horario$fk_horario_consultorio]
3053GO
3054ALTER TABLE [dbo].[horario_detalle]  WITH NOCHECK ADD  CONSTRAINT [horario_detalle$fk_horario_detalle_horario] FOREIGN KEY([horario_id_spring])
3055REFERENCES [dbo].[horario] ([id_spring])
3056GO
3057ALTER TABLE [dbo].[horario_detalle] CHECK CONSTRAINT [horario_detalle$fk_horario_detalle_horario]
3058GO
3059ALTER TABLE [dbo].[inasistencia]  WITH NOCHECK ADD  CONSTRAINT [inasistencia$fk_inasistencia_horario1] FOREIGN KEY([horario_id_spring])
3060REFERENCES [dbo].[horario] ([id_spring])
3061GO
3062ALTER TABLE [dbo].[inasistencia] CHECK CONSTRAINT [inasistencia$fk_inasistencia_horario1]
3063GO
3064ALTER TABLE [dbo].[medico_especialidad]  WITH NOCHECK ADD  CONSTRAINT [medico_especialidad$fk_medico_especialidad_especialidad] FOREIGN KEY([especialidad_id_spring])
3065REFERENCES [dbo].[especialidad] ([id_spring])
3066GO
3067ALTER TABLE [dbo].[medico_especialidad] CHECK CONSTRAINT [medico_especialidad$fk_medico_especialidad_especialidad]
3068GO
3069ALTER TABLE [dbo].[medico_especialidad]  WITH NOCHECK ADD  CONSTRAINT [medico_especialidad$fk_medico_especialidad_medico] FOREIGN KEY([medico_id_spring])
3070REFERENCES [dbo].[medico] ([id_spring])
3071GO
3072ALTER TABLE [dbo].[medico_especialidad] CHECK CONSTRAINT [medico_especialidad$fk_medico_especialidad_medico]
3073GO
3074ALTER TABLE [dbo].[paciente]  WITH CHECK ADD  CONSTRAINT [FK_paciente_distrito] FOREIGN KEY([departamento_id_spring], [provincia_id_spring], [distrito_id_spring])
3075REFERENCES [dbo].[distrito] ([departamento_id_spring], [provincia_id_spring], [id_spring])
3076GO
3077ALTER TABLE [dbo].[paciente] CHECK CONSTRAINT [FK_paciente_distrito]
3078GO
3079ALTER TABLE [dbo].[paciente]  WITH CHECK ADD  CONSTRAINT [FK_paciente_pais] FOREIGN KEY([pais_id_spring])
3080REFERENCES [dbo].[pais] ([id_spring])
3081GO
3082ALTER TABLE [dbo].[paciente] CHECK CONSTRAINT [FK_paciente_pais]
3083GO
3084ALTER TABLE [dbo].[paciente]  WITH NOCHECK ADD  CONSTRAINT [paciente_fk_paciente_estado_civi] FOREIGN KEY([estado_civil_id_spring])
3085REFERENCES [dbo].[estado_civil] ([id_spring])
3086GO
3087ALTER TABLE [dbo].[paciente] CHECK CONSTRAINT [paciente_fk_paciente_estado_civi]
3088GO
3089ALTER TABLE [dbo].[provincia]  WITH CHECK ADD  CONSTRAINT [FK_provincia_departamento] FOREIGN KEY([departamento_id_spring])
3090REFERENCES [dbo].[departamento] ([id_spring])
3091GO
3092ALTER TABLE [dbo].[provincia] CHECK CONSTRAINT [FK_provincia_departamento]
3093GO
3094ALTER TABLE [dbo].[usuario_medico_favorito]  WITH NOCHECK ADD  CONSTRAINT [usuario_medico_favorito$fk_usuario_medico_favorito_medico_especialidad1] FOREIGN KEY([medico_id_spring], [especialidad_id_spring])
3095REFERENCES [dbo].[medico_especialidad] ([medico_id_spring], [especialidad_id_spring])
3096GO
3097ALTER TABLE [dbo].[usuario_medico_favorito] CHECK CONSTRAINT [usuario_medico_favorito$fk_usuario_medico_favorito_medico_especialidad1]
3098GO
3099ALTER TABLE [dbo].[usuario_medico_favorito]  WITH NOCHECK ADD  CONSTRAINT [usuario_medico_favorito$fk_usuario_medico_favorito_usuario] FOREIGN KEY([usuario_id])
3100REFERENCES [dbo].[usuario] ([id])
3101GO
3102ALTER TABLE [dbo].[usuario_medico_favorito] CHECK CONSTRAINT [usuario_medico_favorito$fk_usuario_medico_favorito_usuario]
3103GO
3104ALTER TABLE [dbo].[usuario_paciente]  WITH NOCHECK ADD  CONSTRAINT [usuario_paciente$fk_usuario_paciente_parentesco] FOREIGN KEY([parentesco_id])
3105REFERENCES [dbo].[parentesco] ([id])
3106GO
3107ALTER TABLE [dbo].[usuario_paciente] CHECK CONSTRAINT [usuario_paciente$fk_usuario_paciente_parentesco]
3108GO
3109ALTER TABLE [dbo].[usuario_paciente]  WITH NOCHECK ADD  CONSTRAINT [usuario_paciente$fk_usuario_paciente_usuario] FOREIGN KEY([usuario_id])
3110REFERENCES [dbo].[usuario] ([id])
3111GO
3112ALTER TABLE [dbo].[usuario_paciente] CHECK CONSTRAINT [usuario_paciente$fk_usuario_paciente_usuario]
3113GO
3114EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.app_notificacion' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'app_notificacion'
3115GO
3116EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.cita' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cita'
3117GO
3118EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.cita_bloqueo_manual' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cita_bloqueo_manual'
3119GO
3120EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.cita_historica' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'cita_historica'
3121GO
3122EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.clinica' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'clinica'
3123GO
3124EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.clinica_especialidad' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'clinica_especialidad'
3125GO
3126EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.clinica_medico' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'clinica_medico'
3127GO
3128EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.consultorio' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'consultorio'
3129GO
3130EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.departamento' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'departamento'
3131GO
3132EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.distrito' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'distrito'
3133GO
3134EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.encuesta' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'encuesta'
3135GO
3136EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.encuesta_pregunta_respuesta' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'encuesta_pregunta_respuesta'
3137GO
3138EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.encuesta_respuesta' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'encuesta_respuesta'
3139GO
3140EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.especialidad' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'especialidad'
3141GO
3142EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.estado_civil' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'estado_civil'
3143GO
3144EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.failed_jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'failed_jobs'
3145GO
3146EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.feriado' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'feriado'
3147GO
3148EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.horario' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'horario'
3149GO
3150EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.horario_detalle' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'horario_detalle'
3151GO
3152EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.inasistencia' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'inasistencia'
3153GO
3154EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs'
3155GO
3156EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.medico' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'medico'
3157GO
3158EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.medico_especialidad' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'medico_especialidad'
3159GO
3160EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.migrations' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'migrations'
3161GO
3162EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.paciente' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'paciente'
3163GO
3164EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.pais' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'pais'
3165GO
3166EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.parametro' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'parametro'
3167GO
3168EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.parentesco' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'parentesco'
3169GO
3170EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.provincia' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'provincia'
3171GO
3172EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.usuario' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'usuario'
3173GO
3174EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.usuario_medico_favorito' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'usuario_medico_favorito'
3175GO
3176EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.usuario_paciente' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'usuario_paciente'
3177GO
3178EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'qa_apj_api.fechas_sincronizacion' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'work_sincronizacion'
3179GO
3180USE [master]
3181GO
3182ALTER DATABASE [qa_apj_api] SET  READ_WRITE 
3183GO