/****** Object:  Table [dbo].[LogTraEspFuec]    Script Date: 09/05/2019 17:17:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LogTraEspFuec](
	[Numero] [int] NOT NULL,
	[Fecha] [smalldatetime] NOT NULL,
	[TipDocPgr] [varchar](3) NOT NULL,
	[Programa] [int] NOT NULL,
	[IdCiaPgr] [char](2) NOT NULL,
	[EstadoProc] [int] NOT NULL,
	[Observacion] [varchar](250) NULL,
	[TimeSys] [smalldatetime] NOT NULL,
	[IdUsuario] [varchar](11) NOT NULL,
	[Nombre] [varchar](50) NOT NULL,
 CONSTRAINT [PK_LogTraEspFuec] PRIMARY KEY CLUSTERED 
(
	[Numero] 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].[LogTraEspFuecDet]    Script Date: 09/05/2019 17:17:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LogTraEspFuecDet](
	[Numero] [int] NOT NULL,
	[Item] [int] NOT NULL,
	[TipDocFuec] [varchar](3) NOT NULL,
	[Fuec] [int] NOT NULL,
	[IdCiaFuec] [char](2) NOT NULL,
	[IdVehiculo] [varchar](10) NOT NULL,
	[TipDocRes] [varchar](3) NOT NULL,
	[Reservas] [int] NOT NULL,
	[IdCiaRes] [char](2) NOT NULL,
	[ItemRes] [int] NOT NULL,
	[Comentarios] [varchar](max) NULL,
 CONSTRAINT [PK_LogTraEspFuecDet] PRIMARY KEY CLUSTERED 
(
	[Numero] ASC,
	[Item] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[LogTraEspFuec] ADD  DEFAULT ((0)) FOR [Numero]
GO
ALTER TABLE [dbo].[LogTraEspFuec] ADD  DEFAULT ((0)) FOR [EstadoProc]
GO
ALTER TABLE [dbo].[LogTraEspFuecDet] ADD  DEFAULT ((0)) FOR [IdVehiculo]
GO
ALTER TABLE [dbo].[LogTraEspFuecDet]  WITH CHECK ADD  CONSTRAINT [FK_LogTraEspFuecDet_LogTraEspFuec] FOREIGN KEY([Numero])
REFERENCES [dbo].[LogTraEspFuec] ([Numero])
GO
ALTER TABLE [dbo].[LogTraEspFuecDet] CHECK CONSTRAINT [FK_LogTraEspFuecDet_LogTraEspFuec]
GO
ALTER TABLE [dbo].[LogTraEspFuec]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFuecIdCiaPgr] CHECK  ((len([IdCiaPgr])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFuec] CHECK CONSTRAINT [CK_LogTraEspFuecIdCiaPgr]
GO
ALTER TABLE [dbo].[LogTraEspFuec]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFuecIdUsuario] CHECK  ((len([IdUsuario])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFuec] CHECK CONSTRAINT [CK_LogTraEspFuecIdUsuario]
GO
ALTER TABLE [dbo].[LogTraEspFuec]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFuecNombre] CHECK  ((len([Nombre])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFuec] CHECK CONSTRAINT [CK_LogTraEspFuecNombre]
GO
ALTER TABLE [dbo].[LogTraEspFuec]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFuecPrograma] CHECK  (([Programa]>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFuec] CHECK CONSTRAINT [CK_LogTraEspFuecPrograma]
GO
ALTER TABLE [dbo].[LogTraEspFuecDet]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFuecDetFuec] CHECK  (([Fuec]>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFuecDet] CHECK CONSTRAINT [CK_LogTraEspFuecDetFuec]
GO
ALTER TABLE [dbo].[LogTraEspFuecDet]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFuecDetFuecReservas] CHECK  (([Reservas]>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFuecDet] CHECK CONSTRAINT [CK_LogTraEspFuecDetFuecReservas]
GO
ALTER TABLE [dbo].[LogTraEspFuecDet]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFuecDetIdCiaFuec] CHECK  (([IdCiaFuec]>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFuecDet] CHECK CONSTRAINT [CK_LogTraEspFuecDetIdCiaFuec]
GO
ALTER TABLE [dbo].[LogTraEspFuecDet]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFuecDetIdCiaRes] CHECK  ((len([IdCiaRes])>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFuecDet] CHECK CONSTRAINT [CK_LogTraEspFuecDetIdCiaRes]
GO
ALTER TABLE [dbo].[LogTraEspFuecDet]  WITH CHECK ADD  CONSTRAINT [CK_LogTraEspFuecDetItemRes] CHECK  (([ItemRes]>(0)))
GO
ALTER TABLE [dbo].[LogTraEspFuecDet] CHECK CONSTRAINT [CK_LogTraEspFuecDetItemRes]
GO