USE [dbDecotune]
GO
create database dbDecotune
/****** Object: Table [dbo].[Usuario] Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GOde
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Usuario](
[pkUsuario] [int] IDENTITY(1,1) NOT NULL,
[nombres] [varchar](100) NOT NULL,
[apellidoPaterno] [varchar](50) NOT NULL,
[apellidoMaterno] [varchar](50) NULL,
[usuario] [varchar](10) NULL,
[clave] [varchar](10) NULL,
[estado] [bit] NULL,
[fechaRegistro] [date] NULL,
[dni] [varchar](8) NULL,
CONSTRAINT [PK_Usuario] PRIMARY KEY CLUSTERED
(
[pkUsuario] 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].[Cliente] Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cliente](
[pkCliente] [int] IDENTITY(1,1) NOT NULL,
[nombre] [varchar](100) NOT NULL,
[apellidoPaterno] [varchar](50) NOT NULL,
[apellidoMaterno] [varchar](50) NOT NULL,
[dni] [varchar](11) NOT NULL,
[direccion] [varchar](100) NOT NULL,
[sexo] [char](1) NOT NULL,
[NCelular] [varchar](20) NULL,
[correoElectronico] [varchar](100) NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [datetime] NOT NULL,
CONSTRAINT [PK_Cliente] PRIMARY KEY CLUSTERED
(
[pkCliente] 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].[Calidad] Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Calidad](
[pkCalidad] [int] IDENTITY(1,1) NOT NULL,
[descripcion] [varchar](100) NOT NULL,
[estado] [bit] NULL,
[fechaRegistro] [datetime] NULL,
CONSTRAINT [PK_Material] PRIMARY KEY CLUSTERED
(
[pkCalidad] 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].[Empresa] Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Empresa](
[pkEmpresa] [int] IDENTITY(1,1) NOT NULL,
[RazonSocial] [varchar](100) NOT NULL,
[ruc] [varchar](11) NOT NULL,
[nCelular] [varchar](20) NULL,
[direccion] [varchar](50) NOT NULL,
[correoElectronico] [varchar](50) NULL,
[HorarioDeAtencion] [text] NOT NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [date] NOT NULL,
CONSTRAINT [PK_Empresa] PRIMARY KEY CLUSTERED
(
[pkEmpresa] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Inventario] Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Inventario](
[pkInventario] [int] NOT NULL,
[tipoInventario] [varchar](50) NOT NULL,
[fechaInventario] [datetime] NOT NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [date] NOT NULL,
[fkEmpresa] [int] NULL,
CONSTRAINT [PK_Inventario_1] PRIMARY KEY CLUSTERED
(
[pkInventario] 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].[Moto] Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Moto](
[pkMoto] [int] IDENTITY(1,1) NOT NULL,
[comentario] [text] NOT NULL,
[nChasis] [varchar](20) NOT NULL,
[nMotor] [varchar](20) NOT NULL,
[Color] [varchar](10) NOT NULL,
[fkCliente] [int] NOT NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [datetime] NOT NULL,
CONSTRAINT [PK_Moto] PRIMARY KEY CLUSTERED
(
[pkMoto] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Modelo] Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Modelo](
[pkModelo] [int] IDENTITY(1,1) NOT NULL,
[serie] [int] NOT NULL,
[descripcion] [varchar](100) NOT NULL,
[comentario] [text] NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [datetime] NOT NULL,
[color] [varchar](50) NULL,
[fkCalidad] [int] NULL,
[precio] [decimal](18, 0) NULL,
CONSTRAINT [PK_Modelo] PRIMARY KEY CLUSTERED
(
[pkModelo] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Material] Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Material](
[pkMaterial] [int] IDENTITY(1,1) NOT NULL,
[descripcionCorta] [varchar](100) NOT NULL,
[descripconLarga] [text] NOT NULL,
[Precio] [decimal](18, 2) NOT NULL,
[Codigo] [varchar](10) NOT NULL,
[fechaRegistro] [nchar](10) NOT NULL,
[estado] [bit] NOT NULL,
[Disponibilidad] [varchar](100) NULL,
[fkInventario] [int] NULL,
CONSTRAINT [PK_Inventario] PRIMARY KEY CLUSTERED
(
[pkMaterial] 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
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[DetalleVenta] Script Date: 07/20/2013 18:13:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DetalleVenta](
[pkDetalleModelo] [int] IDENTITY(1,1) NOT NULL,
[fkMoto] [int] NOT NULL,
[fkModelo] [int] NOT NULL,
[estado] [bit] NOT NULL,
[fechaRegistro] [datetime] NOT NULL,
CONSTRAINT [PK_DetalleModelo] PRIMARY KEY CLUSTERED
(
[pkDetalleModelo] 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_DetalleModelo_Modelo] Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[DetalleVenta] WITH CHECK ADD CONSTRAINT [FK_DetalleModelo_Modelo] FOREIGN KEY([fkMoto])
REFERENCES [dbo].[Modelo] ([pkModelo])
GO
ALTER TABLE [dbo].[DetalleVenta] CHECK CONSTRAINT [FK_DetalleModelo_Modelo]
GO
/****** Object: ForeignKey [FK_DetalleModelo_Moto] Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[DetalleVenta] WITH CHECK ADD CONSTRAINT [FK_DetalleModelo_Moto] FOREIGN KEY([fkMoto])
REFERENCES [dbo].[Moto] ([pkMoto])
GO
ALTER TABLE [dbo].[DetalleVenta] CHECK CONSTRAINT [FK_DetalleModelo_Moto]
GO
/****** Object: ForeignKey [FK_Inventario_Inventario] Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[Inventaro] WITH CHECK ADD CONSTRAINT [FK_Inventario_Inventario] FOREIGN KEY([fkEmpresa])
REFERENCES [dbo].[Empresa] ([pkEmpresa])
GO
ALTER TABLE [dbo].[Inventario] CHECK CONSTRAINT [FK_Inventario_Inventario]
GO
/****** Object: ForeignKey [FK_Material_Inventario] Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[Material] WITH CHECK ADD CONSTRAINT [FK_Material_Inventario] FOREIGN KEY([fkInventario])
REFERENCES [dbo].[Inventario] ([pkInventario])
GO
ALTER TABLE [dbo].[Material] CHECK CONSTRAINT [FK_Material_Inventario]
GO
/****** Object: ForeignKey [FK_Modelo_Calidad] Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[Modelo] WITH CHECK ADD CONSTRAINT [FK_Modelo_Calidad] FOREIGN KEY([fkCalidad])
REFERENCES [dbo].[Calidad] ([pkCalidad])
GO
ALTER TABLE [dbo].[Modelo] CHECK CONSTRAINT [FK_Modelo_Calidad]
GO
/****** Object: ForeignKey [FK_Moto_Cliente] Script Date: 07/20/2013 18:13:59 ******/
ALTER TABLE [dbo].[Moto] WITH CHECK ADD CONSTRAINT [FK_Moto_Cliente] FOREIGN KEY([fkCliente])
REFERENCES [dbo].[Cliente] ([pkCliente])
GO
ALTER TABLE [dbo].[Moto] CHECK CONSTRAINT [FK_Moto_Cliente]
GO