El cubo de datos, es una herramienta de análisis de datos, que parte de dos cosas fundamentalmente:
1. Una tabla de hechos, producto de las operaciones de la empresa
2. Una serie de variables objeto del análisis, conocido como dimensiones.
En el estudio de caso, la alcaldía presenta una serie preocupaciones por la calidad e integridad de los informes que llegan al despacho. Una de las preocupaciones es encontrar si existe una relación directa entre los eventos de la secretaria de recreación y el aumento en la atención por ejemplo en los servicios de urgencia.
Luego entonces se analizó la información de los eventos de la secretaría de educación en un cruce con la información de secretaria de salud, donde se reportan las atenciones medicas mes a mes.
Se procede entonces construir el cubo así:
I. Se toma el modelo relación de la base de datos origen del cubo.
II. Se ejecuta el software SQL SERVER DATA TOOLS, para crear el cubo de datos sobre SQL SERVER, este producto trabaja con Microsoft Visual Studio 2015.
III. Creando el proyecto Acanchila_Cubo, como lo indica la imagen anterior procedemos a crear la conexión al servidor de datos SQL SERVER a través de los siguientes pasos:
1. En la estructura del cubo que se crea, se hace clic derecho sobre Origen de datos y luego en nuevo.
2. Clic en Siguiente
3. Se selecciona el controlador correspondiente
4. Se suministra el nombre del servidor de SQL SERVER
5. Seleccionamos el método de conexión. Autenticación de windows.
6. Se selecciona la Base de datos para la creación del cubo.
7. Seleccionamos la información de suplantación.
8. Suministramos Nombre y contraseña del usuario de Windows.
9. Clic en siguiente y se crea automáticamente el origen de datos, como se ve en la siguiente imagen.
IV. Se crea la vista de datos, como se ven la imagen. En esta etapa se agregan las tablas que contienen la información del cubo.
V. Se crean las dimensiones. Como se muestra en la siguiente secuencia de imágenes.
1. Clic derecho sobre dimensiones y luego en nuevo
2. Clic en siguiente
3. Se selecciona Usar tabla existente
4. Se escoge el nombre de la vista de datos a usar.
5. Se escoge la tabla para la dimension
6. Se selecciona el dato o atributo para la dimension que se va a mostrar como nombre
7. Se pueden seleccionar otros atributos
8. Clic en siguiente
9. Se muestra la dimension creada.
VI. Se crea el CUBO. A continuación se muestra el paso para la Generación del cubo una vez se ha configurado. el esquema.
1. Se hace clic derecho en CUBOS, y se selecciona Nuevo
2. Clic en siguiente
3. Usar las tablas existentes
4. Clic en Siguiente
5. Se selecciona la tabla de medida, tbl_Atencion_medica
6. Clic en siguiente
7. Se muestran las medidas
8. Se Seleccionan las dimensiones a usar
9. Clic en siguiente
10. Se muestran las dimensiones con los atributos.
11. Clic en Siguiente
12. Clic en finalizar y se muestra el cubo en la siguiente imagen.
VII- Generación del cubo.
VIII. Resultados exportados a Excel en forma de tabla dinámica.
Al cruzar la información de las fechas de los eventos con las fechas atención encontramos que varios de los pacientes estuvieron en los eventos programados.
NOTA: El siguiente es el script de la base de datos usada para la construcción del cubo.
USE [BD_CUBO_ALCALDIA]
GO
/****** Object: ForeignKey [FK_tbl_predios_propietarios_tbl_personas] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_propietarios_tbl_personas]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]'))
ALTER TABLE [dbo].[tbl_predios_propietarios] DROP CONSTRAINT [FK_tbl_predios_propietarios_tbl_personas]
GO
/****** Object: ForeignKey [FK_tbl_predios_propietarios_tbl_predios1] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_propietarios_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]'))
ALTER TABLE [dbo].[tbl_predios_propietarios] DROP CONSTRAINT [FK_tbl_predios_propietarios_tbl_predios1]
GO
/****** Object: ForeignKey [FK_tbl_predios_morosos_tbl_predios1] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_morosos_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_morosos]'))
ALTER TABLE [dbo].[tbl_predios_morosos] DROP CONSTRAINT [FK_tbl_predios_morosos_tbl_predios1]
GO
/****** Object: ForeignKey [FK_tbl_predios_demandados_tbl_predios1] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_demandados_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_demandados]'))
ALTER TABLE [dbo].[tbl_predios_demandados] DROP CONSTRAINT [FK_tbl_predios_demandados_tbl_predios1]
GO
/****** Object: ForeignKey [FK_tbl_eventos_personas_tbl_eventos_tipo] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_eventos_tipo]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] DROP CONSTRAINT [FK_tbl_eventos_personas_tbl_eventos_tipo]
GO
/****** Object: ForeignKey [FK_tbl_eventos_personas_tbl_personas1] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] DROP CONSTRAINT [FK_tbl_eventos_personas_tbl_personas1]
GO
/****** Object: ForeignKey [FK_tbl_eventos_personas_tbl_secretarias] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_secretarias]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] DROP CONSTRAINT [FK_tbl_eventos_personas_tbl_secretarias]
GO
/****** Object: ForeignKey [FK_tbl_contravenciones_tbl_personas1] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_contravenciones_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]'))
ALTER TABLE [dbo].[tbl_contravenciones] DROP CONSTRAINT [FK_tbl_contravenciones_tbl_personas1]
GO
/****** Object: ForeignKey [FK_tbl_contravenciones_tbl_tipocontravencion1] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_contravenciones_tbl_tipocontravencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]'))
ALTER TABLE [dbo].[tbl_contravenciones] DROP CONSTRAINT [FK_tbl_contravenciones_tbl_tipocontravencion1]
GO
/****** Object: ForeignKey [FK_tbl_atencion_medica_dim_tiempo] Script Date: 08/10/2019 16:49:14 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_dim_tiempo]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] DROP CONSTRAINT [FK_tbl_atencion_medica_dim_tiempo]
GO
/****** Object: ForeignKey [FK_tbl_atencion_medica_tbl_lugaratencion1] Script Date: 08/10/2019 16:49:14 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_lugaratencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] DROP CONSTRAINT [FK_tbl_atencion_medica_tbl_lugaratencion1]
GO
/****** Object: ForeignKey [FK_tbl_atencion_medica_tbl_personas1] Script Date: 08/10/2019 16:49:14 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] DROP CONSTRAINT [FK_tbl_atencion_medica_tbl_personas1]
GO
/****** Object: ForeignKey [FK_tbl_atencion_medica_tbl_tipoatencion1] Script Date: 08/10/2019 16:49:14 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_tipoatencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] DROP CONSTRAINT [FK_tbl_atencion_medica_tbl_tipoatencion1]
GO
/****** Object: Table [dbo].[tbl_atencion_medica] Script Date: 08/10/2019 16:49:14 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_dim_tiempo]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] DROP CONSTRAINT [FK_tbl_atencion_medica_dim_tiempo]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_lugaratencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] DROP CONSTRAINT [FK_tbl_atencion_medica_tbl_lugaratencion1]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] DROP CONSTRAINT [FK_tbl_atencion_medica_tbl_personas1]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_tipoatencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] DROP CONSTRAINT [FK_tbl_atencion_medica_tbl_tipoatencion1]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_atencion_medica]
GO
/****** Object: Table [dbo].[tbl_contravenciones] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_contravenciones_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]'))
ALTER TABLE [dbo].[tbl_contravenciones] DROP CONSTRAINT [FK_tbl_contravenciones_tbl_personas1]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_contravenciones_tbl_tipocontravencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]'))
ALTER TABLE [dbo].[tbl_contravenciones] DROP CONSTRAINT [FK_tbl_contravenciones_tbl_tipocontravencion1]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_contravenciones]
GO
/****** Object: Table [dbo].[tbl_eventos_personas] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_eventos_tipo]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] DROP CONSTRAINT [FK_tbl_eventos_personas_tbl_eventos_tipo]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] DROP CONSTRAINT [FK_tbl_eventos_personas_tbl_personas1]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_secretarias]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] DROP CONSTRAINT [FK_tbl_eventos_personas_tbl_secretarias]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_eventos_personas]
GO
/****** Object: Table [dbo].[tbl_predios_demandados] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_demandados_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_demandados]'))
ALTER TABLE [dbo].[tbl_predios_demandados] DROP CONSTRAINT [FK_tbl_predios_demandados_tbl_predios1]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_predios_demandados]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_predios_demandados]
GO
/****** Object: Table [dbo].[tbl_predios_morosos] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_morosos_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_morosos]'))
ALTER TABLE [dbo].[tbl_predios_morosos] DROP CONSTRAINT [FK_tbl_predios_morosos_tbl_predios1]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_predios_morosos]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_predios_morosos]
GO
/****** Object: Table [dbo].[tbl_predios_propietarios] Script Date: 08/10/2019 16:49:13 ******/
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_propietarios_tbl_personas]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]'))
ALTER TABLE [dbo].[tbl_predios_propietarios] DROP CONSTRAINT [FK_tbl_predios_propietarios_tbl_personas]
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_propietarios_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]'))
ALTER TABLE [dbo].[tbl_predios_propietarios] DROP CONSTRAINT [FK_tbl_predios_propietarios_tbl_predios1]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_predios_propietarios]
GO
/****** Object: Table [dbo].[tbl_secretarias] Script Date: 08/10/2019 16:49:12 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_secretarias]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_secretarias]
GO
/****** Object: Table [dbo].[tbl_eventos_tipo] Script Date: 08/10/2019 16:49:12 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_eventos_tipo]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_eventos_tipo]
GO
/****** Object: Table [dbo].[tbl_personas] Script Date: 08/10/2019 16:49:12 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_personas]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_personas]
GO
/****** Object: Table [dbo].[tbl_predios] Script Date: 08/10/2019 16:49:12 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_predios]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_predios]
GO
/****** Object: Table [dbo].[tbl_contravenciones_tipo] Script Date: 08/10/2019 16:49:11 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones_tipo]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_contravenciones_tipo]
GO
/****** Object: Table [dbo].[tbl_atencion_tipo] Script Date: 08/10/2019 16:49:11 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_atencion_tipo]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_atencion_tipo]
GO
/****** Object: Table [dbo].[dim_tiempo] Script Date: 08/10/2019 16:49:11 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dim_tiempo]') AND type in (N'U'))
DROP TABLE [dbo].[dim_tiempo]
GO
/****** Object: Table [dbo].[tbl_atencion_lugar] Script Date: 08/10/2019 16:49:11 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_atencion_lugar]') AND type in (N'U'))
DROP TABLE [dbo].[tbl_atencion_lugar]
GO
/****** Object: User [Administrador] Script Date: 08/10/2019 16:49:05 ******/
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'Administrador')
DROP USER [Administrador]
GO
/****** Object: User [Sena] Script Date: 08/10/2019 16:49:05 ******/
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'Sena')
DROP USER [Sena]
GO
/****** Object: User [Sena] Script Date: 08/10/2019 16:49:05 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'Sena')
CREATE USER [Sena] FOR LOGIN [Sena] WITH DEFAULT_SCHEMA=[dbo]
GO
/****** Object: User [Administrador] Script Date: 08/10/2019 16:49:05 ******/
IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'Administrador')
CREATE USER [Administrador] FOR LOGIN [SRVSNANTONIO\Administrador] WITH DEFAULT_SCHEMA=[db_accessadmin]
GO
/****** Object: Table [dbo].[tbl_atencion_lugar] Script Date: 08/10/2019 16:49:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_atencion_lugar]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_atencion_lugar](
[fld_codlugaraten] [int] IDENTITY(1,1) NOT NULL,
[fld_nombre] [nchar](60) NULL,
CONSTRAINT [PK_tbl_lugaratencion] PRIMARY KEY CLUSTERED
(
[fld_codlugaraten] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_atencion_lugar] ON
INSERT [dbo].[tbl_atencion_lugar] ([fld_codlugaraten], [fld_nombre]) VALUES (1, N'Urgencia ')
INSERT [dbo].[tbl_atencion_lugar] ([fld_codlugaraten], [fld_nombre]) VALUES (2, N'UCI ')
SET IDENTITY_INSERT [dbo].[tbl_atencion_lugar] OFF
/****** Object: Table [dbo].[dim_tiempo] Script Date: 08/10/2019 16:49:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[dim_tiempo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[dim_tiempo](
[fld_fecha] [date] NOT NULL,
[fld_año] [int] NULL,
[fld_trimestre] [int] NULL,
[fld_mes] [int] NULL,
[fld_mes_nombre] [nchar](25) NULL,
[fld_dia] [int] NULL,
[fld_dia_nombre] [nchar](25) NULL,
CONSTRAINT [PK_dim_tiempo] PRIMARY KEY CLUSTERED
(
[fld_fecha] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
INSERT [dbo].[dim_tiempo] ([fld_fecha], [fld_año], [fld_trimestre], [fld_mes], [fld_mes_nombre], [fld_dia], [fld_dia_nombre]) VALUES (CAST(0x26350B00 AS Date), 2012, 1, 1, N'Enero ', 1, N'Domingo ')
INSERT [dbo].[dim_tiempo] ([fld_fecha], [fld_año], [fld_trimestre], [fld_mes], [fld_mes_nombre], [fld_dia], [fld_dia_nombre]) VALUES (CAST(0x46350B00 AS Date), 2012, 1, 2, N'Febrero ', 2, N'Jueves ')
INSERT [dbo].[dim_tiempo] ([fld_fecha], [fld_año], [fld_trimestre], [fld_mes], [fld_mes_nombre], [fld_dia], [fld_dia_nombre]) VALUES (CAST(0x83350B00 AS Date), 2012, 2, 4, N'Abril ', 3, N'Martes ')
INSERT [dbo].[dim_tiempo] ([fld_fecha], [fld_año], [fld_trimestre], [fld_mes], [fld_mes_nombre], [fld_dia], [fld_dia_nombre]) VALUES (CAST(0x8F350B00 AS Date), 2012, 2, 4, N'Abril ', 15, N'Domingo ')
INSERT [dbo].[dim_tiempo] ([fld_fecha], [fld_año], [fld_trimestre], [fld_mes], [fld_mes_nombre], [fld_dia], [fld_dia_nombre]) VALUES (CAST(0x5A360B00 AS Date), 2012, 4, 11, N'Noviembre ', 4, N'Domingo ')
/****** Object: Table [dbo].[tbl_atencion_tipo] Script Date: 08/10/2019 16:49:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_atencion_tipo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_atencion_tipo](
[fld_codtpatencion] [int] IDENTITY(1,1) NOT NULL,
[fld_nombre] [nchar](30) NULL,
CONSTRAINT [PK_tbl_tipoatencion] PRIMARY KEY CLUSTERED
(
[fld_codtpatencion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_atencion_tipo] ON
INSERT [dbo].[tbl_atencion_tipo] ([fld_codtpatencion], [fld_nombre]) VALUES (1, N'Medicina General ')
INSERT [dbo].[tbl_atencion_tipo] ([fld_codtpatencion], [fld_nombre]) VALUES (2, N'Psiquiatria ')
INSERT [dbo].[tbl_atencion_tipo] ([fld_codtpatencion], [fld_nombre]) VALUES (3, N'Especializada ')
SET IDENTITY_INSERT [dbo].[tbl_atencion_tipo] OFF
/****** Object: Table [dbo].[tbl_contravenciones_tipo] Script Date: 08/10/2019 16:49:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones_tipo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_contravenciones_tipo](
[fld_codtpcontravencion] [int] IDENTITY(1,1) NOT NULL,
[fld_nombre] [nchar](60) NULL,
CONSTRAINT [PK_tbl_tipocontravencion] PRIMARY KEY CLUSTERED
(
[fld_codtpcontravencion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_contravenciones_tipo] ON
INSERT [dbo].[tbl_contravenciones_tipo] ([fld_codtpcontravencion], [fld_nombre]) VALUES (1, N'Alicoramiento en via publica ')
INSERT [dbo].[tbl_contravenciones_tipo] ([fld_codtpcontravencion], [fld_nombre]) VALUES (2, N'Riña callejera ')
INSERT [dbo].[tbl_contravenciones_tipo] ([fld_codtpcontravencion], [fld_nombre]) VALUES (3, N'Desorden en via publica ')
INSERT [dbo].[tbl_contravenciones_tipo] ([fld_codtpcontravencion], [fld_nombre]) VALUES (4, N'Pelea familiar ')
SET IDENTITY_INSERT [dbo].[tbl_contravenciones_tipo] OFF
/****** Object: Table [dbo].[tbl_predios] Script Date: 08/10/2019 16:49:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_predios]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_predios](
[fld_codpredio] [int] IDENTITY(1,1) NOT NULL,
[fld_nombre] [nchar](60) NULL,
CONSTRAINT [PK_tbl_predios] PRIMARY KEY CLUSTERED
(
[fld_codpredio] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_predios] ON
INSERT [dbo].[tbl_predios] ([fld_codpredio], [fld_nombre]) VALUES (1, N'Edificio el almendro ')
INSERT [dbo].[tbl_predios] ([fld_codpredio], [fld_nombre]) VALUES (2, N'Casa cl 46 ')
INSERT [dbo].[tbl_predios] ([fld_codpredio], [fld_nombre]) VALUES (3, N'Parqueadero Cr 46 ')
INSERT [dbo].[tbl_predios] ([fld_codpredio], [fld_nombre]) VALUES (4, N'Centro comercial portal del prado ')
INSERT [dbo].[tbl_predios] ([fld_codpredio], [fld_nombre]) VALUES (5, N'Fabrica de helados "El heladero mayor" ')
SET IDENTITY_INSERT [dbo].[tbl_predios] OFF
/****** Object: Table [dbo].[tbl_personas] Script Date: 08/10/2019 16:49:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_personas]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_personas](
[fld_identificacion] [nchar](20) NOT NULL,
[fld_nombre] [nchar](60) NULL,
[fld_edad] [int] NULL,
CONSTRAINT [PK_tbl_personas_1] PRIMARY KEY CLUSTERED
(
[fld_identificacion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'80232393 ', N'Lunio Castañeda Silva ', 35)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'81231391 ', N'James Claros Alvarez ', 21)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'81232190 ', N'Pedro Nieto Alvarez ', 24)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'81232191 ', N'Fermí Beltran Barraga ', 39)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'81232391 ', N'Guillermo Cano Soto ', 19)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'81232396 ', N'Pablo Henriquez Villa ', 26)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'82222390 ', N'Javier Pinto Ortiz ', 20)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'82232290 ', N'Julio Neira Castro ', 24)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'82232391 ', N'Lino Castro Ordoñez ', 24)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83232244 ', N'Hernando Moncaleano Vargas ', 22)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83232330 ', N'Leandro Quintero Narvaez ', 35)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83232333 ', N'Ada Perez Alvarez ', 29)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83232380 ', N'Manolo Cardona Prieto ', 23)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83232390 ', N'Andres Nieto Alvarez ', 33)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83232392 ', N'Jua Castro Nieto ', 28)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83232395 ', N'Luis Carvajal Silva ', 33)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83232399 ', N'Pedro Castro Nieto ', 25)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83233398 ', N'Jose Miguel Llanos Mosquera ', 33)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83234397 ', N'Andres Peña Silva ', 27)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'83237397 ', N'Rafael Mendieta Alvarez ', 20)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'84232390 ', N'Jairo Osorio Castro ', 37)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'84232397 ', N'Daniel Guzman Ortiz ', 27)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'84234394 ', N'Sergio Nieto Vargas ', 31)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'84234395 ', N'Carlos Alvarado Silva ', 23)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'84235390 ', N'Manuel Silva Castro ', 21)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'84242390 ', N'Jose Martinez Rojas ', 34)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'86236396 ', N'Herna Rojas Alvarez ', 23)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'87237390 ', N'Marcos Dussan Alvarez ', 31)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'87237397 ', N'Nelso Gongora Muñoz ', 37)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'87238399 ', N'Pastor Luna Ortiz ', 22)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'88232390 ', N'Miguel Silva Castro ', 35)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'88232398 ', N'Diego Polanco Vargas ', 30)
INSERT [dbo].[tbl_personas] ([fld_identificacion], [fld_nombre], [fld_edad]) VALUES (N'89239399 ', N'Francisco Guarín Rojas ', 40)
/****** Object: Table [dbo].[tbl_eventos_tipo] Script Date: 08/10/2019 16:49:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_eventos_tipo]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_eventos_tipo](
[fld_codtpevento] [int] IDENTITY(1,1) NOT NULL,
[fld_nombre] [nchar](60) NULL,
CONSTRAINT [PK_tbl_tipoeventos] PRIMARY KEY CLUSTERED
(
[fld_codtpevento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_eventos_tipo] ON
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (1, N'Deporte Terrestre ')
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (2, N'Deporte Acuático ')
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (3, N'Deporte Aéreo ')
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (4, N'Deporte Extremo ')
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (5, N'Arte Contemporaneo ')
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (6, N'Arte Rupestre ')
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (7, N'Arte Moderno ')
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (8, N'Música ')
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (9, N'Peña Cultural ')
INSERT [dbo].[tbl_eventos_tipo] ([fld_codtpevento], [fld_nombre]) VALUES (10, N'Sin evento ')
SET IDENTITY_INSERT [dbo].[tbl_eventos_tipo] OFF
/****** Object: Table [dbo].[tbl_secretarias] Script Date: 08/10/2019 16:49:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_secretarias]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_secretarias](
[fld_codsecretaria] [int] IDENTITY(1,1) NOT NULL,
[fld_nombre] [nchar](60) NULL,
CONSTRAINT [PK_tbl_secretarias] PRIMARY KEY CLUSTERED
(
[fld_codsecretaria] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_secretarias] ON
INSERT [dbo].[tbl_secretarias] ([fld_codsecretaria], [fld_nombre]) VALUES (1, N'Gobierno ')
INSERT [dbo].[tbl_secretarias] ([fld_codsecretaria], [fld_nombre]) VALUES (2, N'Recreacion y deportes ')
INSERT [dbo].[tbl_secretarias] ([fld_codsecretaria], [fld_nombre]) VALUES (3, N'Sec. de gobierno ')
INSERT [dbo].[tbl_secretarias] ([fld_codsecretaria], [fld_nombre]) VALUES (4, N'Sec. de Recreacion ')
INSERT [dbo].[tbl_secretarias] ([fld_codsecretaria], [fld_nombre]) VALUES (5, N'Sec. de Salud ')
INSERT [dbo].[tbl_secretarias] ([fld_codsecretaria], [fld_nombre]) VALUES (6, N'Sec. de Hacienda ')
INSERT [dbo].[tbl_secretarias] ([fld_codsecretaria], [fld_nombre]) VALUES (7, N'Sec. de Ambiente ')
SET IDENTITY_INSERT [dbo].[tbl_secretarias] OFF
/****** Object: Table [dbo].[tbl_predios_propietarios] Script Date: 08/10/2019 16:49:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_predios_propietarios](
[fld_codpredio] [int] NULL,
[fld_identificacion] [nchar](20) NULL
) ON [PRIMARY]
END
GO
INSERT [dbo].[tbl_predios_propietarios] ([fld_codpredio], [fld_identificacion]) VALUES (1, N'80232393 ')
INSERT [dbo].[tbl_predios_propietarios] ([fld_codpredio], [fld_identificacion]) VALUES (2, N'82232391 ')
INSERT [dbo].[tbl_predios_propietarios] ([fld_codpredio], [fld_identificacion]) VALUES (3, N'81232391 ')
INSERT [dbo].[tbl_predios_propietarios] ([fld_codpredio], [fld_identificacion]) VALUES (4, N'83233398 ')
INSERT [dbo].[tbl_predios_propietarios] ([fld_codpredio], [fld_identificacion]) VALUES (5, N'87237397 ')
/****** Object: Table [dbo].[tbl_predios_morosos] Script Date: 08/10/2019 16:49:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_predios_morosos]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_predios_morosos](
[fld_idmora] [int] IDENTITY(1,1) NOT NULL,
[fld_codpredio] [int] NULL,
[fld_valor] [decimal](18, 0) NULL
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_predios_morosos] ON
INSERT [dbo].[tbl_predios_morosos] ([fld_idmora], [fld_codpredio], [fld_valor]) VALUES (1, 1, CAST(25000000 AS Decimal(18, 0)))
INSERT [dbo].[tbl_predios_morosos] ([fld_idmora], [fld_codpredio], [fld_valor]) VALUES (2, 5, CAST(400000000 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[tbl_predios_morosos] OFF
/****** Object: Table [dbo].[tbl_predios_demandados] Script Date: 08/10/2019 16:49:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_predios_demandados]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_predios_demandados](
[fld_iddemanda] [int] IDENTITY(1,1) NOT NULL,
[fld_codpredio] [int] NULL,
[fld_fecha] [nchar](10) NULL,
[fld_valor] [decimal](18, 0) NULL
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_predios_demandados] ON
INSERT [dbo].[tbl_predios_demandados] ([fld_iddemanda], [fld_codpredio], [fld_fecha], [fld_valor]) VALUES (1, 2, N'2012-11-30', CAST(14000000 AS Decimal(18, 0)))
INSERT [dbo].[tbl_predios_demandados] ([fld_iddemanda], [fld_codpredio], [fld_fecha], [fld_valor]) VALUES (2, 3, N'2012-12-05', CAST(150000000 AS Decimal(18, 0)))
SET IDENTITY_INSERT [dbo].[tbl_predios_demandados] OFF
/****** Object: Table [dbo].[tbl_eventos_personas] Script Date: 08/10/2019 16:49:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_eventos_personas](
[fld_consecutivo] [int] IDENTITY(1,1) NOT NULL,
[fld_idevento] [int] NULL,
[fld_identificacion] [nchar](20) NULL,
[fld_valor] [decimal](18, 0) NULL,
[fld_fecha] [date] NULL,
[fld_codsecretaria] [int] NULL,
[fld_codtpevento] [int] NULL,
CONSTRAINT [PK_tbl_eventos_personas] PRIMARY KEY CLUSTERED
(
[fld_consecutivo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_eventos_personas] ON
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (1, 1, N'83232390 ', CAST(3000 AS Decimal(18, 0)), CAST(0x26350B00 AS Date), 1, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (2, 1, N'83232392 ', CAST(3000 AS Decimal(18, 0)), CAST(0x26350B00 AS Date), 1, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (3, 1, N'80232393 ', CAST(3000 AS Decimal(18, 0)), CAST(0x26350B00 AS Date), 1, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (4, 1, N'81232190 ', CAST(3000 AS Decimal(18, 0)), CAST(0x26350B00 AS Date), 1, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (5, 1, N'84232397 ', CAST(3000 AS Decimal(18, 0)), CAST(0x26350B00 AS Date), 1, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (6, 1, N'82232391 ', CAST(3000 AS Decimal(18, 0)), CAST(0x26350B00 AS Date), 1, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (7, 1, N'83232244 ', CAST(3000 AS Decimal(18, 0)), CAST(0x26350B00 AS Date), 1, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (8, 1, N'81232396 ', CAST(3000 AS Decimal(18, 0)), CAST(0x26350B00 AS Date), 1, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (9, 2, N'83234397 ', CAST(5000 AS Decimal(18, 0)), CAST(0x46350B00 AS Date), 1, 1)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (10, 2, N'83232333 ', CAST(5000 AS Decimal(18, 0)), CAST(0x46350B00 AS Date), 1, 1)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (11, 2, N'84234394 ', CAST(5000 AS Decimal(18, 0)), CAST(0x46350B00 AS Date), 1, 1)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (12, 2, N'83233398 ', CAST(5000 AS Decimal(18, 0)), CAST(0x46350B00 AS Date), 1, 1)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (13, 2, N'82222390 ', CAST(5000 AS Decimal(18, 0)), CAST(0x46350B00 AS Date), 1, 1)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (14, 2, N'83232399 ', CAST(5000 AS Decimal(18, 0)), CAST(0x46350B00 AS Date), 1, 1)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (15, 2, N'83232380 ', CAST(5000 AS Decimal(18, 0)), CAST(0x46350B00 AS Date), 1, 1)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (16, 3, N'83232395 ', CAST(6000 AS Decimal(18, 0)), CAST(0x83350B00 AS Date), 2, 5)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (17, 3, N'84232390 ', CAST(6000 AS Decimal(18, 0)), CAST(0x83350B00 AS Date), 2, 5)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (18, 3, N'83232330 ', CAST(6000 AS Decimal(18, 0)), CAST(0x83350B00 AS Date), 2, 5)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (19, 3, N'87237390 ', CAST(6000 AS Decimal(18, 0)), CAST(0x83350B00 AS Date), 2, 5)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (20, 3, N'88232398 ', CAST(6000 AS Decimal(18, 0)), CAST(0x83350B00 AS Date), 2, 5)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (21, 3, N'82232290 ', CAST(6000 AS Decimal(18, 0)), CAST(0x83350B00 AS Date), 2, 5)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (22, 3, N'84235390 ', CAST(6000 AS Decimal(18, 0)), CAST(0x83350B00 AS Date), 2, 5)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (23, 3, N'83237397 ', CAST(6000 AS Decimal(18, 0)), CAST(0x83350B00 AS Date), 2, 5)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (24, 4, N'81232391 ', CAST(4500 AS Decimal(18, 0)), CAST(0x5A360B00 AS Date), 3, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (25, 4, N'87238399 ', CAST(4500 AS Decimal(18, 0)), CAST(0x5A360B00 AS Date), 3, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (26, 4, N'81231391 ', CAST(4500 AS Decimal(18, 0)), CAST(0x5A360B00 AS Date), 3, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (27, 4, N'84234395 ', CAST(4500 AS Decimal(18, 0)), CAST(0x5A360B00 AS Date), 3, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (28, 4, N'86236396 ', CAST(4500 AS Decimal(18, 0)), CAST(0x5A360B00 AS Date), 3, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (29, 4, N'84242390 ', CAST(4500 AS Decimal(18, 0)), CAST(0x5A360B00 AS Date), 3, 9)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (30, 5, N'88232390 ', CAST(5500 AS Decimal(18, 0)), CAST(0x8F350B00 AS Date), 4, 4)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (31, 5, N'83233398 ', CAST(5500 AS Decimal(18, 0)), CAST(0x8F350B00 AS Date), 4, 4)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (32, 5, N'84234394 ', CAST(5500 AS Decimal(18, 0)), CAST(0x8F350B00 AS Date), 4, 4)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (33, 5, N'83232333 ', CAST(5500 AS Decimal(18, 0)), CAST(0x8F350B00 AS Date), 4, 4)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (34, 5, N'83234397 ', CAST(5500 AS Decimal(18, 0)), CAST(0x8F350B00 AS Date), 4, 4)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (35, 5, N'83232244 ', CAST(5500 AS Decimal(18, 0)), CAST(0x8F350B00 AS Date), 4, 4)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (36, 5, N'82232391 ', CAST(6500 AS Decimal(18, 0)), CAST(0x8F350B00 AS Date), 4, 4)
INSERT [dbo].[tbl_eventos_personas] ([fld_consecutivo], [fld_idevento], [fld_identificacion], [fld_valor], [fld_fecha], [fld_codsecretaria], [fld_codtpevento]) VALUES (37, 5, N'84232397 ', CAST(6500 AS Decimal(18, 0)), CAST(0x8F350B00 AS Date), 4, 4)
SET IDENTITY_INSERT [dbo].[tbl_eventos_personas] OFF
/****** Object: Table [dbo].[tbl_contravenciones] Script Date: 08/10/2019 16:49:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_contravenciones](
[fld_idcontravencion] [int] IDENTITY(1,1) NOT NULL,
[fld_codtpcontravencion] [int] NULL,
[fld_identificacion] [nchar](20) NULL,
[fld_fecha] [date] NULL,
[fld_detalle] [nchar](60) NULL,
CONSTRAINT [PK_tbl_contravenciones] PRIMARY KEY CLUSTERED
(
[fld_idcontravencion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_contravenciones] ON
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (5, 1, N'84232397 ', CAST(0x26350B00 AS Date), N'Ciudadano ebrio ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (6, 1, N'82232391 ', CAST(0x26350B00 AS Date), N'Ciudadano ebrio ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (7, 1, N'83232244 ', CAST(0x26350B00 AS Date), N'Ciudadano ebrio ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (8, 2, N'81232396 ', CAST(0x26350B00 AS Date), N'Rina en via publica ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (12, 2, N'83233398 ', CAST(0x46350B00 AS Date), N'Rina en via publica ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (13, 2, N'82222390 ', CAST(0x46350B00 AS Date), N'Rina en via publica ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (14, 3, N'83232399 ', CAST(0x46350B00 AS Date), N'Desorden en via publica ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (15, 3, N'83232380 ', CAST(0x46350B00 AS Date), N'Desorden en via publica ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (23, 3, N'83237397 ', CAST(0x83350B00 AS Date), N'Desorden en via publica ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (28, 4, N'86236396 ', CAST(0x5A360B00 AS Date), N'Violencia intrafamiliar ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (29, 4, N'84242390 ', CAST(0x5A360B00 AS Date), N'Violencia intrafamiliar ')
INSERT [dbo].[tbl_contravenciones] ([fld_idcontravencion], [fld_codtpcontravencion], [fld_identificacion], [fld_fecha], [fld_detalle]) VALUES (30, 1, N'88232390 ', CAST(0x8F350B00 AS Date), N'Ciudadano ebrio ')
SET IDENTITY_INSERT [dbo].[tbl_contravenciones] OFF
/****** Object: Table [dbo].[tbl_atencion_medica] Script Date: 08/10/2019 16:49:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbl_atencion_medica](
[fld_idatencion] [int] IDENTITY(1,1) NOT NULL,
[fld_identificacion] [nchar](20) NULL,
[fld_codtpatencion] [int] NULL,
[fld_codlugaratencion] [int] NULL,
[fld_fecha] [date] NULL,
[fld_detalle_atencion] [nchar](60) NULL,
CONSTRAINT [PK_tbl_atencion_medica] PRIMARY KEY CLUSTERED
(
[fld_idatencion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[tbl_atencion_medica] ON
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (1, N'83232390 ', 1, 1, CAST(0x26350B00 AS Date), N'Paciente ingresa urgencia ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (2, N'83232392 ', 2, 1, CAST(0x26350B00 AS Date), N'Paciente ingresa a psiquiatira ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (7, N'83232244 ', 1, 1, CAST(0x26350B00 AS Date), N'Paciente ingresa urgencia ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (8, N'81232396 ', 2, 1, CAST(0x26350B00 AS Date), N'Paciente ingresa a psiquiatira ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (9, N'83234397 ', 3, 2, CAST(0x46350B00 AS Date), N'Paciente ingresa a medicina especializada ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (10, N'83232333 ', 1, 2, CAST(0x46350B00 AS Date), N'Paciente ingresa urgencia ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (15, N'83232380 ', 2, 2, CAST(0x46350B00 AS Date), N'Paciente ingresa a psiquiatira ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (16, N'83232395 ', 2, 2, CAST(0x83350B00 AS Date), N'Paciente ingresa a psiquiatira ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (17, N'84232390 ', 3, 2, CAST(0x83350B00 AS Date), N'Paciente ingresa a medicina especializada ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (24, N'81232391 ', 3, 1, CAST(0x5A360B00 AS Date), N'Paciente ingresa a medicina especializada ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (25, N'87238399 ', 1, 1, CAST(0x5A360B00 AS Date), N'Paciente ingresa urgencia ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (26, N'81231391 ', 1, 1, CAST(0x5A360B00 AS Date), N'Paciente ingresa urgencia ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (27, N'84234395 ', 1, 2, CAST(0x5A360B00 AS Date), N'Paciente ingresa urgencia ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (30, N'88232390 ', 2, 1, CAST(0x8F350B00 AS Date), N'Paciente ingresa a psiquiatira ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (31, N'83233398 ', 2, 2, CAST(0x8F350B00 AS Date), N'Paciente ingresa a psiquiatira ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (35, N'83232244 ', 2, 1, CAST(0x8F350B00 AS Date), N'Paciente ingresa a psiquiatira ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (36, N'82232391 ', 1, 2, CAST(0x8F350B00 AS Date), N'Paciente ingresa urgencia ')
INSERT [dbo].[tbl_atencion_medica] ([fld_idatencion], [fld_identificacion], [fld_codtpatencion], [fld_codlugaratencion], [fld_fecha], [fld_detalle_atencion]) VALUES (37, N'84232397 ', 2, 1, CAST(0x8F350B00 AS Date), N'Paciente ingresa a psiquiatira ')
SET IDENTITY_INSERT [dbo].[tbl_atencion_medica] OFF
/****** Object: ForeignKey [FK_tbl_predios_propietarios_tbl_personas] Script Date: 08/10/2019 16:49:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_propietarios_tbl_personas]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]'))
ALTER TABLE [dbo].[tbl_predios_propietarios] WITH CHECK ADD CONSTRAINT [FK_tbl_predios_propietarios_tbl_personas] FOREIGN KEY([fld_identificacion])
REFERENCES [dbo].[tbl_personas] ([fld_identificacion])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_propietarios_tbl_personas]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]'))
ALTER TABLE [dbo].[tbl_predios_propietarios] CHECK CONSTRAINT [FK_tbl_predios_propietarios_tbl_personas]
GO
/****** Object: ForeignKey [FK_tbl_predios_propietarios_tbl_predios1] Script Date: 08/10/2019 16:49:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_propietarios_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]'))
ALTER TABLE [dbo].[tbl_predios_propietarios] WITH CHECK ADD CONSTRAINT [FK_tbl_predios_propietarios_tbl_predios1] FOREIGN KEY([fld_codpredio])
REFERENCES [dbo].[tbl_predios] ([fld_codpredio])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_propietarios_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_propietarios]'))
ALTER TABLE [dbo].[tbl_predios_propietarios] CHECK CONSTRAINT [FK_tbl_predios_propietarios_tbl_predios1]
GO
/****** Object: ForeignKey [FK_tbl_predios_morosos_tbl_predios1] Script Date: 08/10/2019 16:49:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_morosos_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_morosos]'))
ALTER TABLE [dbo].[tbl_predios_morosos] WITH CHECK ADD CONSTRAINT [FK_tbl_predios_morosos_tbl_predios1] FOREIGN KEY([fld_codpredio])
REFERENCES [dbo].[tbl_predios] ([fld_codpredio])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_morosos_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_morosos]'))
ALTER TABLE [dbo].[tbl_predios_morosos] CHECK CONSTRAINT [FK_tbl_predios_morosos_tbl_predios1]
GO
/****** Object: ForeignKey [FK_tbl_predios_demandados_tbl_predios1] Script Date: 08/10/2019 16:49:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_demandados_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_demandados]'))
ALTER TABLE [dbo].[tbl_predios_demandados] WITH CHECK ADD CONSTRAINT [FK_tbl_predios_demandados_tbl_predios1] FOREIGN KEY([fld_codpredio])
REFERENCES [dbo].[tbl_predios] ([fld_codpredio])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_predios_demandados_tbl_predios1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_predios_demandados]'))
ALTER TABLE [dbo].[tbl_predios_demandados] CHECK CONSTRAINT [FK_tbl_predios_demandados_tbl_predios1]
GO
/****** Object: ForeignKey [FK_tbl_eventos_personas_tbl_eventos_tipo] Script Date: 08/10/2019 16:49:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_eventos_tipo]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] WITH CHECK ADD CONSTRAINT [FK_tbl_eventos_personas_tbl_eventos_tipo] FOREIGN KEY([fld_codtpevento])
REFERENCES [dbo].[tbl_eventos_tipo] ([fld_codtpevento])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_eventos_tipo]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] CHECK CONSTRAINT [FK_tbl_eventos_personas_tbl_eventos_tipo]
GO
/****** Object: ForeignKey [FK_tbl_eventos_personas_tbl_personas1] Script Date: 08/10/2019 16:49:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] WITH CHECK ADD CONSTRAINT [FK_tbl_eventos_personas_tbl_personas1] FOREIGN KEY([fld_identificacion])
REFERENCES [dbo].[tbl_personas] ([fld_identificacion])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] CHECK CONSTRAINT [FK_tbl_eventos_personas_tbl_personas1]
GO
/****** Object: ForeignKey [FK_tbl_eventos_personas_tbl_secretarias] Script Date: 08/10/2019 16:49:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_secretarias]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] WITH CHECK ADD CONSTRAINT [FK_tbl_eventos_personas_tbl_secretarias] FOREIGN KEY([fld_codsecretaria])
REFERENCES [dbo].[tbl_secretarias] ([fld_codsecretaria])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_eventos_personas_tbl_secretarias]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_eventos_personas]'))
ALTER TABLE [dbo].[tbl_eventos_personas] CHECK CONSTRAINT [FK_tbl_eventos_personas_tbl_secretarias]
GO
/****** Object: ForeignKey [FK_tbl_contravenciones_tbl_personas1] Script Date: 08/10/2019 16:49:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_contravenciones_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]'))
ALTER TABLE [dbo].[tbl_contravenciones] WITH CHECK ADD CONSTRAINT [FK_tbl_contravenciones_tbl_personas1] FOREIGN KEY([fld_identificacion])
REFERENCES [dbo].[tbl_personas] ([fld_identificacion])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_contravenciones_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]'))
ALTER TABLE [dbo].[tbl_contravenciones] CHECK CONSTRAINT [FK_tbl_contravenciones_tbl_personas1]
GO
/****** Object: ForeignKey [FK_tbl_contravenciones_tbl_tipocontravencion1] Script Date: 08/10/2019 16:49:13 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_contravenciones_tbl_tipocontravencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]'))
ALTER TABLE [dbo].[tbl_contravenciones] WITH CHECK ADD CONSTRAINT [FK_tbl_contravenciones_tbl_tipocontravencion1] FOREIGN KEY([fld_codtpcontravencion])
REFERENCES [dbo].[tbl_contravenciones_tipo] ([fld_codtpcontravencion])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_contravenciones_tbl_tipocontravencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_contravenciones]'))
ALTER TABLE [dbo].[tbl_contravenciones] CHECK CONSTRAINT [FK_tbl_contravenciones_tbl_tipocontravencion1]
GO
/****** Object: ForeignKey [FK_tbl_atencion_medica_dim_tiempo] Script Date: 08/10/2019 16:49:14 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_dim_tiempo]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] WITH CHECK ADD CONSTRAINT [FK_tbl_atencion_medica_dim_tiempo] FOREIGN KEY([fld_fecha])
REFERENCES [dbo].[dim_tiempo] ([fld_fecha])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_dim_tiempo]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] CHECK CONSTRAINT [FK_tbl_atencion_medica_dim_tiempo]
GO
/****** Object: ForeignKey [FK_tbl_atencion_medica_tbl_lugaratencion1] Script Date: 08/10/2019 16:49:14 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_lugaratencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] WITH CHECK ADD CONSTRAINT [FK_tbl_atencion_medica_tbl_lugaratencion1] FOREIGN KEY([fld_codlugaratencion])
REFERENCES [dbo].[tbl_atencion_lugar] ([fld_codlugaraten])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_lugaratencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] CHECK CONSTRAINT [FK_tbl_atencion_medica_tbl_lugaratencion1]
GO
/****** Object: ForeignKey [FK_tbl_atencion_medica_tbl_personas1] Script Date: 08/10/2019 16:49:14 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] WITH CHECK ADD CONSTRAINT [FK_tbl_atencion_medica_tbl_personas1] FOREIGN KEY([fld_identificacion])
REFERENCES [dbo].[tbl_personas] ([fld_identificacion])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_personas1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] CHECK CONSTRAINT [FK_tbl_atencion_medica_tbl_personas1]
GO
/****** Object: ForeignKey [FK_tbl_atencion_medica_tbl_tipoatencion1] Script Date: 08/10/2019 16:49:14 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_tipoatencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] WITH CHECK ADD CONSTRAINT [FK_tbl_atencion_medica_tbl_tipoatencion1] FOREIGN KEY([fld_codtpatencion])
REFERENCES [dbo].[tbl_atencion_tipo] ([fld_codtpatencion])
GO
IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbl_atencion_medica_tbl_tipoatencion1]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbl_atencion_medica]'))
ALTER TABLE [dbo].[tbl_atencion_medica] CHECK CONSTRAINT [FK_tbl_atencion_medica_tbl_tipoatencion1]
GO
No hay comentarios:
Publicar un comentario