Creacion de la base de datos fisica
La base de datos fisica se crea apartir del modelo dado por el profesor en la clase
USE [master]
GO
/****** Object: Database [Fila_Banco] Script Date: 06/27/2013 08:24:59 ******/
CREATE DATABASE [Fila_Banco] ON PRIMARY
( NAME = N'Fila_Banco', FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.WUXIA\MSSQL\DATA\Fila_Banco.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Fila_Banco_log', FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.WUXIA\MSSQL\DATA\Fila_Banco_log.ldf' , SIZE = 2304KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Fila_Banco] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Fila_Banco].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Fila_Banco] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Fila_Banco] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Fila_Banco] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Fila_Banco] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Fila_Banco] SET ARITHABORT OFF
GO
ALTER DATABASE [Fila_Banco] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Fila_Banco] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Fila_Banco] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Fila_Banco] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Fila_Banco] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Fila_Banco] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [Fila_Banco] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Fila_Banco] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Fila_Banco] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Fila_Banco] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Fila_Banco] SET DISABLE_BROKER
GO
ALTER DATABASE [Fila_Banco] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Fila_Banco] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Fila_Banco] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Fila_Banco] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Fila_Banco] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Fila_Banco] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Fila_Banco] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Fila_Banco] SET READ_WRITE
GO
ALTER DATABASE [Fila_Banco] SET RECOVERY SIMPLE
GO
ALTER DATABASE [Fila_Banco] SET MULTI_USER
GO
ALTER DATABASE [Fila_Banco] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Fila_Banco] SET DB_CHAINING OFF
GO
USE [Fila_Banco]
GO
/****** Object: Table [dbo].[FB_TipoServicio] Script Date: 06/27/2013 08:25:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FB_TipoServicio](
[Id_TipoServicio] [int] IDENTITY(1,1) NOT NULL,
[Nombre] [varchar](50) NOT NULL,
[Prefijo] [varchar](5) NOT NULL,
CONSTRAINT [PK_FB_TipoServicio] PRIMARY KEY CLUSTERED
(
[Id_TipoServicio] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[FB_Estacion] Script Date: 06/27/2013 08:25:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FB_Estacion](
[Id_Estacion] [int] IDENTITY(1,1) NOT NULL,
[Nombre] [varchar](30) NOT NULL,
CONSTRAINT [PK_FB_Estacion] PRIMARY KEY CLUSTERED
(
[Id_Estacion] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[TipoEvento] Script Date: 06/27/2013 08:25:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TipoEvento](
[Id_TipoEvento] [int] NOT NULL,
[Nombre] [nchar](10) NOT NULL,
CONSTRAINT [PK_TipoEvento] PRIMARY KEY CLUSTERED
(
[Id_TipoEvento] 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].[FB_Cajero] Script Date: 06/27/2013 08:25:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FB_Cajero](
[Id_Cajero] [int] IDENTITY(1,1) NOT NULL,
[Nombre] [varchar](256) NOT NULL,
CONSTRAINT [PK_FB_Cajero] PRIMARY KEY CLUSTERED
(
[Id_Cajero] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[FB_EstacionXServicio] Script Date: 06/27/2013 08:25:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FB_EstacionXServicio](
[Id_EstacionXServicio] [int] IDENTITY(1,1) NOT NULL,
[FK_Estacion] [int] NOT NULL,
[FK_TipoServicio] [int] NOT NULL,
[Prioridad] [int] NOT NULL,
CONSTRAINT [PK_FB_EstacionXServicio] PRIMARY KEY CLUSTERED
(
[Id_EstacionXServicio] 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: StoredProcedure [dbo].[FBSP_getCajeros] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[FBSP_getCajeros]
AS
BEGIN
SELECT E.Id_Cajero, E.Nombre
FROM FB_Cajero E
END
GO
/****** Object: StoredProcedure [dbo].[FBSP_getEstaciones] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[FBSP_getEstaciones]
AS
BEGIN
SELECT E.Id_Estacion, E.Nombre
FROM FB_Estacion E
END
GO
/****** Object: Table [dbo].[FB_CajeroXEstacion] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FB_CajeroXEstacion](
[Id_CajeroXEstacion] [int] IDENTITY(1,1) NOT NULL,
[FK_Estacion] [int] NOT NULL,
[FK_Cajero] [int] NOT NULL,
[FechaHoraAbre] [datetime] NOT NULL,
[FechaHoraCierra] [datetime] NULL,
CONSTRAINT [PK_FB_CajeroXEstacion] PRIMARY KEY CLUSTERED
(
[Id_CajeroXEstacion] 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].[FB_Ficha] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FB_Ficha](
[Id_Ficha] [int] IDENTITY(1,1) NOT NULL,
[FK_TipoServicio] [int] NOT NULL,
[Codigo] [varchar](15) NOT NULL,
[TiempoSolicitud] [datetime] NOT NULL,
[TiempoInicioServicio] [datetime] NOT NULL,
[TiempoFinServicio] [datetime] NOT NULL,
[TiempoEspera] [int] NOT NULL,
CONSTRAINT [PK_FB_Ficha] PRIMARY KEY CLUSTERED
(
[Id_Ficha] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[FB_EventoXEstacion] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FB_EventoXEstacion](
[Id_EventoXEstacion] [int] IDENTITY(1,1) NOT NULL,
[FK_Ficha] [int] NOT NULL,
[FK_CajeroXEstacion] [int] NOT NULL,
[Codigo] [varchar](20) NOT NULL,
[Duracion] [int] NOT NULL,
CONSTRAINT [PK_FB_EventoXEstacion] PRIMARY KEY CLUSTERED
(
[Id_EventoXEstacion] 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
SET ANSI_PADDING OFF
GO
/****** Object: StoredProcedure [dbo].[FBSP_getEstaciones2Prioridad] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[FBSP_getEstaciones2Prioridad]
@fecha DATE
AS
BEGIN
SELECT E.Nombre,COUNT(F.Id_Ficha) Tiquetes, S.Nombre,EXS.Prioridad
FROM FB_Estacion E
INNER JOIN FB_EstacionXServicio EXS ON EXS.FK_Estacion=E.Id_Estacion
INNER JOIN FB_TipoServicio S ON S.Id_TipoServicio=EXS.FK_TipoServicio AND EXS.Prioridad=2
INNER JOIN FB_Ficha F ON F.FK_TipoServicio=S.Id_TipoServicio
GROUP BY E.Nombre,S.Nombre,EXS.Prioridad,F.TiempoInicioServicio,S.Nombre
HAVING (DATEPART(WEEK,F.TiempoInicioServicio))=(DATEPART(WEEK,@fecha))
ORDER BY Tiquetes DESC
END
GO
/****** Object: StoredProcedure [dbo].[FBSP_getCajeros3Prioridad] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[FBSP_getCajeros3Prioridad]
@fecha DATE
AS
BEGIN
--declare @fecha date= '2013-01-14'
SELECT DISTINCT C.Nombre Cajero,E.Nombre Estacion,COUNT(F.Id_Ficha) Tiquetes,S.Nombre TipoServicio,EXS.Prioridad
,(DATEPART(WEEK,F.TiempoInicioServicio)) Fecha
FROM FB_Cajero C
INNER JOIN FB_CajeroXEstacion CXE ON CXE.FK_Cajero=C.Id_Cajero
INNER JOIN FB_Estacion E ON E.Id_Estacion=CXE.FK_Estacion
INNER JOIN FB_EstacionXServicio EXS ON EXS.FK_Estacion=E.Id_Estacion
INNER JOIN FB_TipoServicio S ON S.Id_TipoServicio=EXS.FK_TipoServicio AND EXS.Prioridad=3
INNER JOIN FB_Ficha F ON F.FK_TipoServicio=S.Id_TipoServicio
GROUP BY C.Nombre,E.Nombre,F.TiempoInicioServicio,S.Nombre,EXS.Prioridad
HAVING (DATEPART(WEEK,F.TiempoInicioServicio))=(DATEPART(WEEK,@fecha))
ORDER BY Tiquetes DESC
END
GO
/****** Object: StoredProcedure [dbo].[FBSP_cierraEstacion] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[FBSP_cierraEstacion]
@id int
AS
BEGIN
UPDATE FB_CajeroXEstacion
SET FechaHoraCierra= GETDATE()
WHERE Id_CajeroXEstacion=@id
END
GO
/****** Object: StoredProcedure [dbo].[FBSP_abreEstacion] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[FBSP_abreEstacion]
@idEstacion int, @idCajero int
AS
DECLARE @Prefijo varchar(1),@FKTipoServico INT, @Numero int, @codigo varchar(10)
BEGIN
INSERT INTO FB_CajeroXEstacion(FK_Cajero,FK_Estacion,FechaHoraAbre)
VALUES(@idCajero,@idEstacion,GETDATE())
SELECT TOP 1 F.Id_CajeroXEstacion
FROM FB_CajeroXEstacion F
ORDER BY F.Id_CajeroXEstacion DESC
END
GO
/****** Object: StoredProcedure [dbo].[FBSP_getNextFicha] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[FBSP_getNextFicha]
@idCXE INT
AS
BEGIN
SELECT DISTINCT TOP 1 F.Id_Ficha,F.Codigo,EXS.Prioridad
FROM FB_Ficha F
INNER JOIN FB_EstacionXServicio EXS ON EXS.FK_TipoServicio=F.FK_TipoServicio
INNER JOIN FB_CajeroXEstacion CXE ON CXE.FK_Estacion=EXS.FK_Estacion AND
CXE.Id_CajeroXEstacion=@idCXE
INNER JOIN FB_Estacion E ON E.Id_Estacion=CXE.FK_Estacion
INNER JOIN FB_TipoServicio TS ON F.FK_TipoServicio=TS.Id_TipoServicio
WHERE F.TiempoInicioServicio='00:00:00'
ORDER BY EXS.Prioridad,F.Id_Ficha ASC
END
GO
/****** Object: StoredProcedure [dbo].[FBSP_getFicha] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[FBSP_getFicha]
@TipodeServicio varchar(20)
AS
DECLARE @Prefijo varchar(2),@FKTipoServico INT, @Numero int, @codigo varchar(10)
BEGIN
SET @Prefijo = (Select TS.Prefijo FROM FB_TipoServicio TS WHERE TS.Nombre = @TipodeServicio)
SET @Numero = (SELECT COUNT(*) FROM FB_Ficha F INNER JOIN FB_TipoServicio TS ON F.FK_TipoServicio = TS.Id_TipoServicio
AND TS.Prefijo = @Prefijo
WHERE DATEPART(DAYOFYEAR,GETDATE())=DATEPART(DAYOFYEAR,F.TiempoSolicitud))
SET @codigo = @Prefijo + CONVERT(VARCHAR(20),@Numero+1)
SET @FKTipoServico = (SELECT TS.Id_TipoServicio FROM FB_TipoServicio TS WHERE TS.Prefijo = @Prefijo)
INSERT INTO FB_Ficha(FK_TipoServicio,Codigo,TiempoSolicitud,TiempoInicioServicio,TiempoFinServicio)
VALUES(@FKTipoServico,@codigo,GETDATE(),DEFAULT,DEFAULT)
SELECT TOP 1 F.Id_Ficha,F.Codigo
FROM FB_Ficha F
ORDER BY F.Id_Ficha DESC
END
GO
/****** Object: StoredProcedure [dbo].[FBSP_getEstacionEsperaLargaPromedio] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[FBSP_getEstacionEsperaLargaPromedio]
AS
BEGIN
SELECT DISTINCT E.Nombre Estacion,C.Nombre Cajero,SUM(EXE.Duracion) Duracion
,AVG(F.TiempoEspera) Espera
FROM FB_EventoXEstacion EXE
INNER JOIN FB_CajeroXEstacion CXE ON CXE.FK_Cajero= EXE.FK_CajeroXEstacion
INNER JOIN FB_Cajero C ON C.Id_Cajero=CXE.FK_Cajero
INNER JOIN FB_Estacion E ON E.Id_Estacion=CXE.FK_Estacion
INNER JOIN FB_EstacionXServicio EXS ON EXS.FK_Estacion=E.Id_Estacion
INNER JOIN FB_TipoServicio S ON S.Id_TipoServicio=EXS.FK_TipoServicio AND EXS.Prioridad=3
INNER JOIN FB_Ficha F ON F.FK_TipoServicio=S.Id_TipoServicio
GROUP BY E.Nombre,C.Nombre
ORDER BY Espera DESC
END
GO
/****** Object: StoredProcedure [dbo].[FBSP_get3CajeroEsperaLargaPromedio] Script Date: 06/27/2013 08:25:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[FBSP_get3CajeroEsperaLargaPromedio]
AS
BEGIN
SELECT DISTINCT C.Nombre Cajero,E.Nombre Estacion,SUM(EXE.Duracion) Duracion
,AVG(F.TiempoEspera) Espera
FROM FB_EventoXEstacion EXE
INNER JOIN FB_CajeroXEstacion CXE ON CXE.FK_Cajero= EXE.FK_CajeroXEstacion
INNER JOIN FB_Cajero C ON C.Id_Cajero=CXE.FK_Cajero
INNER JOIN FB_Estacion E ON E.Id_Estacion=CXE.FK_Estacion
INNER JOIN FB_EstacionXServicio EXS ON EXS.FK_Estacion=E.Id_Estacion
INNER JOIN FB_TipoServicio S ON S.Id_TipoServicio=EXS.FK_TipoServicio AND EXS.Prioridad=3
INNER JOIN FB_Ficha F ON F.FK_TipoServicio=S.Id_TipoServicio
GROUP BY C.Nombre,E.Nombre
ORDER BY Estacion
END
GO
/****** Object: Default [DF_FB_Ficha_TiempoInicioSer] Script Date: 06/27/2013 08:25:02 ******/
ALTER TABLE [dbo].[FB_Ficha] ADD CONSTRAINT [DF_FB_Ficha_TiempoInicioSer] DEFAULT ('00:00') FOR [TiempoInicioServicio]
GO
/****** Object: Default [DF_FB_Ficha_TiempoFinSer] Script Date: 06/27/2013 08:25:02 ******/
ALTER TABLE [dbo].[FB_Ficha] ADD CONSTRAINT [DF_FB_Ficha_TiempoFinSer] DEFAULT ('00:00') FOR [TiempoFinServicio]
GO
/****** Object: Default [DF_FB_Ficha_TiempoEspera] Script Date: 06/27/2013 08:25:02 ******/
ALTER TABLE [dbo].[FB_Ficha] ADD CONSTRAINT [DF_FB_Ficha_TiempoEspera] DEFAULT ((0)) FOR [TiempoEspera]
GO
/****** Object: Default [DF_FB_EventoXEstacion_Duracion] Script Date: 06/27/2013 08:25:02 ******/
ALTER TABLE [dbo].[FB_EventoXEstacion] ADD CONSTRAINT [DF_FB_EventoXEstacion_Duracion] DEFAULT ('00:00') FOR [Duracion]
GO
/****** Object: ForeignKey [FK_FB_EstacionXServicio_FB_Estacion] Script Date: 06/27/2013 08:25:01 ******/
ALTER TABLE [dbo].[FB_EstacionXServicio] WITH CHECK ADD CONSTRAINT [FK_FB_EstacionXServicio_FB_Estacion] FOREIGN KEY([FK_Estacion])
REFERENCES [dbo].[FB_Estacion] ([Id_Estacion])
GO
ALTER TABLE [dbo].[FB_EstacionXServicio] CHECK CONSTRAINT [FK_FB_EstacionXServicio_FB_Estacion]
GO
/****** Object: ForeignKey [FK_FB_EstacionXServicio_FB_TipoServicio] Script Date: 06/27/2013 08:25:01 ******/
ALTER TABLE [dbo].[FB_EstacionXServicio] WITH CHECK ADD CONSTRAINT [FK_FB_EstacionXServicio_FB_TipoServicio] FOREIGN KEY([FK_TipoServicio])
REFERENCES [dbo].[FB_TipoServicio] ([Id_TipoServicio])
GO
ALTER TABLE [dbo].[FB_EstacionXServicio] CHECK CONSTRAINT [FK_FB_EstacionXServicio_FB_TipoServicio]
GO
/****** Object: ForeignKey [FK_FB_CajeroXEstacion_FB_Cajero] Script Date: 06/27/2013 08:25:02 ******/
ALTER TABLE [dbo].[FB_CajeroXEstacion] WITH CHECK ADD CONSTRAINT [FK_FB_CajeroXEstacion_FB_Cajero] FOREIGN KEY([FK_Cajero])
REFERENCES [dbo].[FB_Cajero] ([Id_Cajero])
GO
ALTER TABLE [dbo].[FB_CajeroXEstacion] CHECK CONSTRAINT [FK_FB_CajeroXEstacion_FB_Cajero]
GO
/****** Object: ForeignKey [FK_FB_CajeroXEstacion_FB_Estacion] Script Date: 06/27/2013 08:25:02 ******/
ALTER TABLE [dbo].[FB_CajeroXEstacion] WITH CHECK ADD CONSTRAINT [FK_FB_CajeroXEstacion_FB_Estacion] FOREIGN KEY([FK_Estacion])
REFERENCES [dbo].[FB_Estacion] ([Id_Estacion])
GO
ALTER TABLE [dbo].[FB_CajeroXEstacion] CHECK CONSTRAINT [FK_FB_CajeroXEstacion_FB_Estacion]
GO
/****** Object: ForeignKey [FK_FB_Ficha_FB_TipoServicio] Script Date: 06/27/2013 08:25:02 ******/
ALTER TABLE [dbo].[FB_Ficha] WITH CHECK ADD CONSTRAINT [FK_FB_Ficha_FB_TipoServicio] FOREIGN KEY([FK_TipoServicio])
REFERENCES [dbo].[FB_TipoServicio] ([Id_TipoServicio])
GO
ALTER TABLE [dbo].[FB_Ficha] CHECK CONSTRAINT [FK_FB_Ficha_FB_TipoServicio]
GO
/****** Object: ForeignKey [FK_FB_EventoXEstacion_FB_CajeroXEstacion] Script Date: 06/27/2013 08:25:02 ******/
ALTER TABLE [dbo].[FB_EventoXEstacion] WITH CHECK ADD CONSTRAINT [FK_FB_EventoXEstacion_FB_CajeroXEstacion] FOREIGN KEY([FK_CajeroXEstacion])
REFERENCES [dbo].[FB_CajeroXEstacion] ([Id_CajeroXEstacion])
GO
ALTER TABLE [dbo].[FB_EventoXEstacion] CHECK CONSTRAINT [FK_FB_EventoXEstacion_FB_CajeroXEstacion]
GO
/****** Object: ForeignKey [FK_FB_EventoXEstacion_FB_Ficha] Script Date: 06/27/2013 08:25:02 ******/
ALTER TABLE [dbo].[FB_EventoXEstacion] WITH CHECK ADD CONSTRAINT [FK_FB_EventoXEstacion_FB_Ficha] FOREIGN KEY([FK_Ficha])
REFERENCES [dbo].[FB_Ficha] ([Id_Ficha])
GO
ALTER TABLE [dbo].[FB_EventoXEstacion] CHECK CONSTRAINT [FK_FB_EventoXEstacion_FB_Ficha]
GO
Duración 2 horas
.jpg)
.jpg)