USE [EN_DEV]
GO
/****** Object: Table [dbo].[Monto_Liquidacion] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Monto_Liquidacion](
[ID_Proyecto] [nchar](10) NOT NULL,
[Numero_Desembolso] [numeric](18, 0) NOT NULL,
[Fecha_Solicitud_Desembolso] [date] NOT NULL,
[Fecha_Entrega_Desembolso] [date] NOT NULL,
[Fecha_Liquidacion] [date] NOT NULL,
[Monto] [numeric](18, 0) NULL,
CONSTRAINT [PK_Monto_Liquidacion_1] PRIMARY KEY CLUSTERED
(
[ID_Proyecto] ASC,
[Numero_Desembolso] ASC,
[Fecha_Solicitud_Desembolso] ASC,
[Fecha_Entrega_Desembolso] ASC,
[Fecha_Liquidacion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Modulo] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Modulo](
[ID_Modulo] [nchar](10) NOT NULL,
[Descripcion] [nchar](10) NULL,
CONSTRAINT [PK_Modulo] PRIMARY KEY CLUSTERED
(
[ID_Modulo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Propuesta] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Propuesta](
[Nombre] [nchar](10) NOT NULL,
[Ubicacion] [nchar](10) NOT NULL,
[Perfil_Institucional] [bit] NULL,
[Justificacion] [bit] NULL,
[Especificacion_Equipo] [bit] NULL,
[Beneficiario] [bit] NULL,
[Capacitaciones] [bit] NULL,
[Ente_Administrador] [bit] NULL,
[Tarifa] [bit] NULL,
[Mantenimiento_Equipo] [bit] NULL,
[Monto] [bit] NULL,
[Cronograma] [bit] NULL,
[Subsidio] [bit] NULL,
[Personeria_Juridica] [bit] NULL,
[Copia_Registro_tributario] [bit] NULL,
[Constacia_Junta_Directiva] [bit] NULL,
[Contacto_Telefonico] [bit] NULL,
[Contacto_Fax] [bit] NULL,
[Contacto_Correo_Electronico] [bit] NULL,
[Copia_Identidad] [bit] NULL,
[Identidad_Interesado] [bit] NULL,
CONSTRAINT [PK_Propuesta_1] PRIMARY KEY CLUSTERED
(
[Nombre] ASC,
[Ubicacion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Interesado] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Interesado](
[Identidad] [nchar](10) NOT NULL,
[Primer_Nombre] [nchar](10) NULL,
[Primer_Apellido] [nchar](10) NULL,
[Segundo_Apellido] [nchar](10) NULL,
[Telefono] [nchar](10) NULL,
[Correo_Electornico] [nchar](10) NULL,
CONSTRAINT [PK_Interesado] PRIMARY KEY CLUSTERED
(
[Identidad] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Empleado] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Empleado](
[ID] [nchar](10) NOT NULL,
[Nombre] [nchar](10) NULL,
[Primer_Apellido] [nchar](10) NULL,
CONSTRAINT [PK_Empleado] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Contraparte] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Contraparte](
[ID_Contraparte] [nchar](10) NOT NULL,
[Nombre] [nchar](10) NULL,
[Ubicacion] [nchar](10) NULL,
CONSTRAINT [PK_Contraparte] PRIMARY KEY CLUSTERED
(
[ID_Contraparte] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Administracion] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Administracion](
[ID_Empleado] [nchar](10) NOT NULL,
[Propuesta_Verificada] [nchar](10) NULL,
CONSTRAINT [PK_Administracion] PRIMARY KEY CLUSTERED
(
[ID_Empleado] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Proyecto] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Proyecto](
[ID] [nchar](10) NOT NULL,
[ID_Contraparte] [nchar](10) NULL,
[Contrato] [nchar](10) NULL,
[Induccion] [bit] NULL,
[Antecedentes] [bit] NULL,
[Informe_Avance] [nchar](10) NULL,
[Informe_Final] [nchar](10) NULL,
[Presupuesto_Aprobado] [nchar](10) NULL,
[Nombre_Propuesta] [nchar](10) NULL,
[Ubicacion_Propuesta] [nchar](10) NULL,
[Auntorizacion_EnDev] [bit] NULL,
[Autorizacion_Prorena] [bit] NULL,
[Autorizacion_AgenciaGTZ] [bit] NULL,
CONSTRAINT [PK_Proyecto] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Tecnico] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tecnico](
[ID_Empleado] [nchar](10) NOT NULL,
[Proyecto_Supervisado] [nchar](10) NULL,
CONSTRAINT [PK_Tecnico] PRIMARY KEY CLUSTERED
(
[ID_Empleado] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Usuario] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Usuario](
[ID_Usuario] [nchar](10) NOT NULL,
[Nombre_Usurio] [nchar](10) NULL,
[Contraseña] [nchar](10) NULL,
[ID_Modulo] [nchar](10) NULL,
CONSTRAINT [PK_Usuario] PRIMARY KEY CLUSTERED
(
[ID_Usuario] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Verifica] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Verifica](
[Nombre_Propuesta] [nchar](10) NOT NULL,
[Ubicacion_Propuesta] [nchar](10) NOT NULL,
[ID_Empleado_Administracion] [nchar](10) NOT NULL,
CONSTRAINT [PK_Verifica] PRIMARY KEY CLUSTERED
(
[Nombre_Propuesta] ASC,
[Ubicacion_Propuesta] ASC,
[ID_Empleado_Administracion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Tiene] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tiene](
[ID_Empleado] [nchar](10) NOT NULL,
[ID_Usuario] [nchar](10) NOT NULL,
[Nombre_Empleado] [nchar](10) NULL,
[Primer_Apelldio_Empleado] [nchar](10) NULL,
[Nombre_Usuario] [nchar](10) NULL,
[Contraseña] [nchar](10) NULL,
CONSTRAINT [PK_Tiene] PRIMARY KEY CLUSTERED
(
[ID_Empleado] ASC,
[ID_Usuario] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Supervisa] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Supervisa](
[ID_Proyecto] [nchar](10) NOT NULL,
[ID_Empleado_Tecnico] [nchar](10) NOT NULL,
CONSTRAINT [PK_Supervisa] PRIMARY KEY CLUSTERED
(
[ID_Proyecto] ASC,
[ID_Empleado_Tecnico] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Recibos] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Recibos](
[ID_Proyecto] [nchar](10) NOT NULL,
[Fecha_Solicitud_Desembolso] [date] NOT NULL,
[Fecha_Entrega_Desembolso] [date] NOT NULL,
[Fecha_Liquidacion] [date] NOT NULL,
[Recibo] [nchar](10) NOT NULL,
CONSTRAINT [PK_Recibos] PRIMARY KEY CLUSTERED
(
[ID_Proyecto] ASC,
[Fecha_Solicitud_Desembolso] ASC,
[Fecha_Entrega_Desembolso] ASC,
[Fecha_Liquidacion] ASC,
[Recibo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Desembolso] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Desembolso](
[ID_Proyecto] [nchar](10) NOT NULL,
[Numero_Desembolso] [numeric](18, 0) NOT NULL,
[Fecha_Solicitud] [date] NOT NULL,
[Fecha_Entrega] [date] NOT NULL,
[Fecha_Vecimiento] [date] NULL,
[Monto_Desembolso] [numeric](18, 0) NULL,
[Recico] [nchar](10) NULL,
CONSTRAINT [PK_Desembolso] PRIMARY KEY CLUSTERED
(
[ID_Proyecto] ASC,
[Numero_Desembolso] ASC,
[Fecha_Solicitud] ASC,
[Fecha_Entrega] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Alcances] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Alcances](
[ID_Proyecto] [nchar](10) NOT NULL,
[Alcance] [nchar](10) NOT NULL,
CONSTRAINT [PK_Alcances] PRIMARY KEY CLUSTERED
(
[ID_Proyecto] ASC,
[Alcance] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Objetivos_Generales] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Objetivos_Generales](
[ID_Proyecto] [nchar](10) NOT NULL,
[Objetivo] [nchar](10) NOT NULL,
CONSTRAINT [PK_Objetivos_Generales] PRIMARY KEY CLUSTERED
(
[ID_Proyecto] ASC,
[Objetivo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Objetivo_Especifico] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Objetivo_Especifico](
[ID_Proyecto] [nchar](10) NOT NULL,
[Objetivos] [nchar](10) NOT NULL,
CONSTRAINT [PK_Objetivo_Especifico] PRIMARY KEY CLUSTERED
(
[ID_Proyecto] ASC,
[Objetivos] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Liquidacion] Script Date: 09/08/2009 00:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Liquidacion](
[ID_Proyecto] [nchar](10) NOT NULL,
[Numero_Desembolso] [numeric](18, 0) NOT NULL,
[Fecha_Solicitud_Desembolso] [date] NOT NULL,
[Fecha_Entrega_Desembolso] [date] NOT NULL,
[Fecha_Liquidacion] [date] NOT NULL,
[Hoja_Liquidacion] [bit] NULL,
[Hoja_Gastos] [bit] NULL,
CONSTRAINT [PK_Liquidacion_1] PRIMARY KEY CLUSTERED
(
[ID_Proyecto] ASC,
[Numero_Desembolso] ASC,
[Fecha_Solicitud_Desembolso] ASC,
[Fecha_Entrega_Desembolso] ASC,
[Fecha_Liquidacion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: ForeignKey [FK_Administracion_Empleado] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Administracion] WITH CHECK ADD CONSTRAINT [FK_Administracion_Empleado] FOREIGN KEY([ID_Empleado])
REFERENCES [dbo].[Empleado] ([ID])
GO
ALTER TABLE [dbo].[Administracion] CHECK CONSTRAINT [FK_Administracion_Empleado]
GO
/****** Object: ForeignKey [FK_Alcances_Proyecto] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Alcances] WITH CHECK ADD CONSTRAINT [FK_Alcances_Proyecto] FOREIGN KEY([ID_Proyecto])
REFERENCES [dbo].[Proyecto] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Alcances] CHECK CONSTRAINT [FK_Alcances_Proyecto]
GO
/****** Object: ForeignKey [FK_Desembolso_Proyecto] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Desembolso] WITH CHECK ADD CONSTRAINT [FK_Desembolso_Proyecto] FOREIGN KEY([ID_Proyecto])
REFERENCES [dbo].[Proyecto] ([ID])
GO
ALTER TABLE [dbo].[Desembolso] CHECK CONSTRAINT [FK_Desembolso_Proyecto]
GO
/****** Object: ForeignKey [FK_Liquidacion_Desembolso] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Liquidacion] WITH CHECK ADD CONSTRAINT [FK_Liquidacion_Desembolso] FOREIGN KEY([ID_Proyecto], [Numero_Desembolso], [Fecha_Solicitud_Desembolso], [Fecha_Entrega_Desembolso])
REFERENCES [dbo].[Desembolso] ([ID_Proyecto], [Numero_Desembolso], [Fecha_Solicitud], [Fecha_Entrega])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Liquidacion] CHECK CONSTRAINT [FK_Liquidacion_Desembolso]
GO
/****** Object: ForeignKey [FK_Objetivo_Especifico_Proyecto] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Objetivo_Especifico] WITH CHECK ADD CONSTRAINT [FK_Objetivo_Especifico_Proyecto] FOREIGN KEY([ID_Proyecto])
REFERENCES [dbo].[Proyecto] ([ID])
GO
ALTER TABLE [dbo].[Objetivo_Especifico] CHECK CONSTRAINT [FK_Objetivo_Especifico_Proyecto]
GO
/****** Object: ForeignKey [FK_Objetivos_Generales_Proyecto] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Objetivos_Generales] WITH CHECK ADD CONSTRAINT [FK_Objetivos_Generales_Proyecto] FOREIGN KEY([ID_Proyecto])
REFERENCES [dbo].[Proyecto] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Objetivos_Generales] CHECK CONSTRAINT [FK_Objetivos_Generales_Proyecto]
GO
/****** Object: ForeignKey [FK_Contraparte_Proyecto] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Proyecto] WITH CHECK ADD CONSTRAINT [FK_Contraparte_Proyecto] FOREIGN KEY([ID_Contraparte])
REFERENCES [dbo].[Contraparte] ([ID_Contraparte])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Proyecto] CHECK CONSTRAINT [FK_Contraparte_Proyecto]
GO
/****** Object: ForeignKey [FK_Recibos_Desembolso] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Recibos] WITH CHECK ADD CONSTRAINT [FK_Recibos_Desembolso] FOREIGN KEY([ID_Proyecto], [Fecha_Solicitud_Desembolso], [Fecha_Entrega_Desembolso], [Fecha_Liquidacion], [Recibo])
REFERENCES [dbo].[Recibos] ([ID_Proyecto], [Fecha_Solicitud_Desembolso], [Fecha_Entrega_Desembolso], [Fecha_Liquidacion], [Recibo])
GO
ALTER TABLE [dbo].[Recibos] CHECK CONSTRAINT [FK_Recibos_Desembolso]
GO
/****** Object: ForeignKey [FK_Recibos_Proyecto] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Recibos] WITH CHECK ADD CONSTRAINT [FK_Recibos_Proyecto] FOREIGN KEY([ID_Proyecto])
REFERENCES [dbo].[Proyecto] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Recibos] CHECK CONSTRAINT [FK_Recibos_Proyecto]
GO
/****** Object: ForeignKey [FK_Supervisa_Proyecto] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Supervisa] WITH CHECK ADD CONSTRAINT [FK_Supervisa_Proyecto] FOREIGN KEY([ID_Proyecto])
REFERENCES [dbo].[Proyecto] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Supervisa] CHECK CONSTRAINT [FK_Supervisa_Proyecto]
GO
/****** Object: ForeignKey [FK_Supervisa_Tecnico] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Supervisa] WITH CHECK ADD CONSTRAINT [FK_Supervisa_Tecnico] FOREIGN KEY([ID_Empleado_Tecnico])
REFERENCES [dbo].[Tecnico] ([ID_Empleado])
GO
ALTER TABLE [dbo].[Supervisa] CHECK CONSTRAINT [FK_Supervisa_Tecnico]
GO
/****** Object: ForeignKey [FK_Tecnico_Empleado] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Tecnico] WITH CHECK ADD CONSTRAINT [FK_Tecnico_Empleado] FOREIGN KEY([ID_Empleado])
REFERENCES [dbo].[Empleado] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Tecnico] CHECK CONSTRAINT [FK_Tecnico_Empleado]
GO
/****** Object: ForeignKey [FK_Tiene_Empleado] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Tiene] WITH CHECK ADD CONSTRAINT [FK_Tiene_Empleado] FOREIGN KEY([ID_Empleado])
REFERENCES [dbo].[Empleado] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Tiene] CHECK CONSTRAINT [FK_Tiene_Empleado]
GO
/****** Object: ForeignKey [FK_Tiene_Usuario] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Tiene] WITH CHECK ADD CONSTRAINT [FK_Tiene_Usuario] FOREIGN KEY([ID_Usuario])
REFERENCES [dbo].[Usuario] ([ID_Usuario])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Tiene] CHECK CONSTRAINT [FK_Tiene_Usuario]
GO
/****** Object: ForeignKey [FK_Usuario_Modulo] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Usuario] WITH CHECK ADD CONSTRAINT [FK_Usuario_Modulo] FOREIGN KEY([ID_Modulo])
REFERENCES [dbo].[Modulo] ([ID_Modulo])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Usuario] CHECK CONSTRAINT [FK_Usuario_Modulo]
GO
/****** Object: ForeignKey [FK_Verifica_Administarcion] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Verifica] WITH CHECK ADD CONSTRAINT [FK_Verifica_Administarcion] FOREIGN KEY([ID_Empleado_Administracion])
REFERENCES [dbo].[Administracion] ([ID_Empleado])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Verifica] CHECK CONSTRAINT [FK_Verifica_Administarcion]
GO
/****** Object: ForeignKey [FK_Verifica_Propuesta] Script Date: 09/08/2009 00:20:04 ******/
ALTER TABLE [dbo].[Verifica] WITH CHECK ADD CONSTRAINT [FK_Verifica_Propuesta] FOREIGN KEY([Nombre_Propuesta], [Ubicacion_Propuesta])
REFERENCES [dbo].[Propuesta] ([Nombre], [Ubicacion])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Verifica] CHECK CONSTRAINT [FK_Verifica_Propuesta]
GO
No hay comentarios:
Publicar un comentario