Scribd
Cargar
25 vistas10 páginas

Creación de Base de Datos Sucursal1

base de datos

Cargado por

elizabalac2024
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como TXT, PDF, TXT o lee en línea desde Scribd
25 vistas10 páginas

Creación de Base de Datos Sucursal1

base de datos

Cargado por

elizabalac2024
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como TXT, PDF, TXT o lee en línea desde Scribd

USE [master]

GO
/****** Object: Database [Sucursal1] Script Date: 28/10/2024 18:24:34 ******/
CREATE DATABASE [Sucursal1]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'Sucursal1', FILENAME = N'C:\Program Files\Microsoft SQL Server\
MSSQL12.LOCALHOST\MSSQL\DATA\Sucursal1.mdf' , SIZE = 4288KB , MAXSIZE = UNLIMITED,
FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Sucursal1_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\
MSSQL12.LOCALHOST\MSSQL\DATA\Sucursal1_log.ldf' , SIZE = 1072KB , MAXSIZE =
2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Sucursal1] SET COMPATIBILITY_LEVEL = 120
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Sucursal1].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Sucursal1] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Sucursal1] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Sucursal1] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Sucursal1] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Sucursal1] SET ARITHABORT OFF
GO
ALTER DATABASE [Sucursal1] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Sucursal1] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Sucursal1] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Sucursal1] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Sucursal1] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [Sucursal1] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Sucursal1] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Sucursal1] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Sucursal1] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Sucursal1] SET ENABLE_BROKER
GO
ALTER DATABASE [Sucursal1] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Sucursal1] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Sucursal1] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Sucursal1] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Sucursal1] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Sucursal1] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Sucursal1] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Sucursal1] SET RECOVERY FULL
GO
ALTER DATABASE [Sucursal1] SET MULTI_USER
GO
ALTER DATABASE [Sucursal1] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Sucursal1] SET DB_CHAINING OFF
GO
ALTER DATABASE [Sucursal1] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [Sucursal1] SET TARGET_RECOVERY_TIME = 0 SECONDS
GO
ALTER DATABASE [Sucursal1] SET DELAYED_DURABILITY = DISABLED
GO
EXEC sys.sp_db_vardecimal_storage_format N'Sucursal1', N'ON'
GO
USE [Sucursal1]
GO
/****** Object: Table [dbo].[Categorias] Script Date: 28/10/2024 18:24:34
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Categorias](
[CategoriaID] [int] NOT NULL,
[Nombre] [nvarchar](50) NULL,
[Descripcion] [nvarchar](200) NULL,
[Estado] [bit] NULL DEFAULT ((1)),
[FechaCreacion] [datetime] NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED
(
[CategoriaID] 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].[Clientes] Script Date: 28/10/2024 18:24:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Clientes](
[ClienteID] [int] NOT NULL,
[TipoDocumento] [nvarchar](20) NULL,
[NumeroDocumento] [nvarchar](20) NULL,
[Nombre] [nvarchar](100) NULL,
[Email] [nvarchar](100) NULL,
[Direccion] [nvarchar](200) NULL,
[Ciudad] [nvarchar](50) NULL,
[Telefono] [nvarchar](20) NULL,
[FechaNacimiento] [date] NULL,
[Estado] [bit] NULL DEFAULT ((1)),
[FechaRegistro] [datetime] NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED
(
[ClienteID] 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].[Compras] Script Date: 28/10/2024 18:24:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Compras](
[CompraID] [int] NOT NULL,
[ProveedorID] [int] NULL,
[FechaCompra] [datetime] NULL,
[NumeroFactura] [nvarchar](20) NULL,
[Subtotal] [decimal](10, 2) NULL,
[IGV] [decimal](10, 2) NULL,
[Total] [decimal](10, 2) NULL,
[Estado] [nvarchar](20) NULL,
PRIMARY KEY CLUSTERED
(
[CompraID] 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].[DetalleCompras] Script Date: 28/10/2024 18:24:34
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DetalleCompras](
[DetalleCompraID] [int] NOT NULL,
[CompraID] [int] NULL,
[ProductoID] [int] NULL,
[Cantidad] [int] NULL,
[PrecioUnitario] [decimal](10, 2) NULL,
[Subtotal] [decimal](10, 2) NULL,
PRIMARY KEY CLUSTERED
(
[DetalleCompraID] 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].[DetalleVentas] Script Date: 28/10/2024 18:24:34
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DetalleVentas](
[DetalleVentaID] [int] NOT NULL,
[VentaID] [int] NULL,
[ProductoID] [int] NULL,
[Cantidad] [int] NULL,
[PrecioUnitario] [decimal](10, 2) NULL,
[Descuento] [decimal](10, 2) NULL,
[Subtotal] [decimal](10, 2) NULL,
PRIMARY KEY CLUSTERED
(
[DetalleVentaID] 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].[Empleados] Script Date: 28/10/2024 18:24:34
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Empleados](
[EmpleadoID] [int] NOT NULL,
[TipoDocumento] [nvarchar](20) NULL,
[NumeroDocumento] [nvarchar](20) NULL,
[Nombre] [nvarchar](100) NULL,
[Direccion] [nvarchar](200) NULL,
[Telefono] [nvarchar](20) NULL,
[Email] [nvarchar](100) NULL,
[Cargo] [nvarchar](50) NULL,
[Salario] [decimal](10, 2) NULL,
[FechaContratacion] [date] NULL,
[Estado] [bit] NULL DEFAULT ((1)),
PRIMARY KEY CLUSTERED
(
[EmpleadoID] 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].[Inventario] Script Date: 28/10/2024 18:24:34
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Inventario](
[InventarioID] [int] NOT NULL,
[ProductoID] [int] NULL,
[FechaMovimiento] [datetime] NULL,
[TipoMovimiento] [nvarchar](20) NULL,
[Cantidad] [int] NULL,
[PrecioUnitario] [decimal](10, 2) NULL,
[Referencia] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[InventarioID] 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].[Productos] Script Date: 28/10/2024 18:24:34
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Productos](
[ProductoID] [int] NOT NULL,
[CategoriaID] [int] NULL,
[Nombre] [nvarchar](100) NULL,
[Descripcion] [nvarchar](200) NULL,
[PrecioUnitario] [decimal](10, 2) NULL,
[Stock] [int] NULL,
[StockMinimo] [int] NULL,
[UnidadMedida] [nvarchar](20) NULL,
[Estado] [bit] NULL DEFAULT ((1)),
[FechaCreacion] [datetime] NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED
(
[ProductoID] 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].[ProductosPromocion] Script Date: 28/10/2024
18:24:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductosPromocion](
[PromocionID] [int] NOT NULL,
[ProductoID] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[PromocionID] ASC,
[ProductoID] 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].[Promociones] Script Date: 28/10/2024 18:24:34
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Promociones](
[PromocionID] [int] NOT NULL,
[Nombre] [nvarchar](100) NULL,
[Descripcion] [nvarchar](200) NULL,
[FechaInicio] [date] NULL,
[FechaFin] [date] NULL,
[Descuento] [decimal](5, 2) NULL,
[Estado] [bit] NULL DEFAULT ((1)),
PRIMARY KEY CLUSTERED
(
[PromocionID] 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].[Proveedores] Script Date: 28/10/2024 18:24:34
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Proveedores](
[ProveedorID] [int] NOT NULL,
[RazonSocial] [nvarchar](100) NULL,
[RUC] [nvarchar](11) NULL,
[Direccion] [nvarchar](200) NULL,
[Ciudad] [nvarchar](50) NULL,
[Telefono] [nvarchar](20) NULL,
[Email] [nvarchar](100) NULL,
[Estado] [bit] NULL DEFAULT ((1)),
[FechaRegistro] [datetime] NULL DEFAULT (getdate()),
PRIMARY KEY CLUSTERED
(
[ProveedorID] 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].[Ventas] Script Date: 28/10/2024 18:24:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Ventas](
[VentaID] [int] NOT NULL,
[ClienteID] [int] NULL,
[EmpleadoID] [int] NULL,
[FechaVenta] [datetime] NULL,
[TipoComprobante] [nvarchar](20) NULL,
[NumeroComprobante] [nvarchar](20) NULL,
[Subtotal] [decimal](10, 2) NULL,
[IGV] [decimal](10, 2) NULL,
[Descuento] [decimal](10, 2) NULL,
[Total] [decimal](10, 2) NULL,
[Estado] [nvarchar](20) NULL,
[SucursalID] [int] NULL DEFAULT ((1)),
PRIMARY KEY CLUSTERED
(
[VentaID] 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
INSERT [dbo].[Categorias] ([CategoriaID], [Nombre], [Descripcion], [Estado],
[FechaCreacion]) VALUES (1, N'Electrónicos', N'Productos electrónicos y
tecnológicos', 1, CAST(N'2024-10-25 18:46:02.550' AS DateTime))
INSERT [dbo].[Categorias] ([CategoriaID], [Nombre], [Descripcion], [Estado],
[FechaCreacion]) VALUES (2, N'Línea Blanca', N'Electrodomésticos y equipos para el
hogar', 1, CAST(N'2024-10-25 18:46:02.550' AS DateTime))
INSERT [dbo].[Categorias] ([CategoriaID], [Nombre], [Descripcion], [Estado],
[FechaCreacion]) VALUES (3, N'Muebles', N'Muebles para hogar y oficina', 1,
CAST(N'2024-10-25 18:46:02.550' AS DateTime))
INSERT [dbo].[Categorias] ([CategoriaID], [Nombre], [Descripcion], [Estado],
[FechaCreacion]) VALUES (4, N'Deportes', N'Equipamiento y ropa deportiva', 1,
CAST(N'2024-10-25 18:46:02.550' AS DateTime))
INSERT [dbo].[Categorias] ([CategoriaID], [Nombre], [Descripcion], [Estado],
[FechaCreacion]) VALUES (5, N'Juguetes', N'Juguetes y artículos recreativos', 1,
CAST(N'2024-10-25 18:46:02.550' AS DateTime))
INSERT [dbo].[Clientes] ([ClienteID], [TipoDocumento], [NumeroDocumento], [Nombre],
[Email], [Direccion], [Ciudad], [Telefono], [FechaNacimiento], [Estado],
[FechaRegistro]) VALUES (1, N'CI', N'45678912', N'Juan Pérez',
N'[email protected]', N'Calle Lima 123', N'Lima', N'987654321', CAST(N'1988-05-
13' AS Date), 1, CAST(N'2024-10-25 18:48:31.243' AS DateTime))
INSERT [dbo].[Clientes] ([ClienteID], [TipoDocumento], [NumeroDocumento], [Nombre],
[Email], [Direccion], [Ciudad], [Telefono], [FechaNacimiento], [Estado],
[FechaRegistro]) VALUES (2, N'CI', N'23456789', N'María García',
N'[email protected]', N'Av. Arequipa 456', N'Lima', N'987123456', CAST(N'2000-
03-03' AS Date), 1, CAST(N'2024-10-25 18:48:31.243' AS DateTime))
INSERT [dbo].[Clientes] ([ClienteID], [TipoDocumento], [NumeroDocumento], [Nombre],
[Email], [Direccion], [Ciudad], [Telefono], [FechaNacimiento], [Estado],
[FechaRegistro]) VALUES (3, N'PASAPORTE', N'10234567890', N'Comercial ABC',
N'[email protected]', N'Jr. Cusco 789', N'Cusco', N'984567123', CAST(N'1990-
07-15' AS Date), 1, CAST(N'2024-10-25 18:48:31.243' AS DateTime))
INSERT [dbo].[Compras] ([CompraID], [ProveedorID], [FechaCompra], [NumeroFactura],
[Subtotal], [IGV], [Total], [Estado]) VALUES (1, 1, CAST(N'2024-01-10 00:00:00.000'
AS DateTime), N'F001-5678', CAST(8474.58 AS Decimal(10, 2)), CAST(1525.42 AS
Decimal(10, 2)), CAST(10000.00 AS Decimal(10, 2)), N'Completada')
INSERT [dbo].[Compras] ([CompraID], [ProveedorID], [FechaCompra], [NumeroFactura],
[Subtotal], [IGV], [Total], [Estado]) VALUES (2, 2, CAST(N'2024-01-12 00:00:00.000'
AS DateTime), N'F002-1234', CAST(4237.29 AS Decimal(10, 2)), CAST(762.71 AS
Decimal(10, 2)), CAST(5000.00 AS Decimal(10, 2)), N'Completada')
INSERT [dbo].[DetalleCompras] ([DetalleCompraID], [CompraID], [ProductoID],
[Cantidad], [PrecioUnitario], [Subtotal]) VALUES (1, 1, 1, 2, CAST(2000.00 AS
Decimal(10, 2)), CAST(4000.00 AS Decimal(10, 2)))
INSERT [dbo].[DetalleCompras] ([DetalleCompraID], [CompraID], [ProductoID],
[Cantidad], [PrecioUnitario], [Subtotal]) VALUES (2, 1, 2, 2, CAST(3000.00 AS
Decimal(10, 2)), CAST(6000.00 AS Decimal(10, 2)))
INSERT [dbo].[DetalleCompras] ([DetalleCompraID], [CompraID], [ProductoID],
[Cantidad], [PrecioUnitario], [Subtotal]) VALUES (3, 2, 3, 3, CAST(1666.67 AS
Decimal(10, 2)), CAST(5000.00 AS Decimal(10, 2)))
INSERT [dbo].[DetalleVentas] ([DetalleVentaID], [VentaID], [ProductoID],
[Cantidad], [PrecioUnitario], [Descuento], [Subtotal]) VALUES (1, 1, 1, 1,
CAST(2499.99 AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), CAST(2499.99 AS
Decimal(10, 2)))
INSERT [dbo].[DetalleVentas] ([DetalleVentaID], [VentaID], [ProductoID],
[Cantidad], [PrecioUnitario], [Descuento], [Subtotal]) VALUES (2, 2, 4, 1,
CAST(1499.99 AS Decimal(10, 2)), CAST(100.00 AS Decimal(10, 2)), CAST(1399.99 AS
Decimal(10, 2)))
INSERT [dbo].[DetalleVentas] ([DetalleVentaID], [VentaID], [ProductoID],
[Cantidad], [PrecioUnitario], [Descuento], [Subtotal]) VALUES (3, 3, 2, 1,
CAST(3299.99 AS Decimal(10, 2)), CAST(100.00 AS Decimal(10, 2)), CAST(3199.99 AS
Decimal(10, 2)))
INSERT [dbo].[DetalleVentas] ([DetalleVentaID], [VentaID], [ProductoID],
[Cantidad], [PrecioUnitario], [Descuento], [Subtotal]) VALUES (4, 3, 5, 1,
CAST(999.99 AS Decimal(10, 2)), CAST(100.00 AS Decimal(10, 2)), CAST(899.99 AS
Decimal(10, 2)))
INSERT [dbo].[Empleados] ([EmpleadoID], [TipoDocumento], [NumeroDocumento],
[Nombre], [Direccion], [Telefono], [Email], [Cargo], [Salario],
[FechaContratacion], [Estado]) VALUES (1, N'CI', N'12345678', N'Pedro Ramírez',
N'Av. Los Álamos 123', N'956781234', N'[email protected]', N'Vendedor',
CAST(2500.00 AS Decimal(10, 2)), CAST(N'2022-01-15' AS Date), 1)
INSERT [dbo].[Empleados] ([EmpleadoID], [TipoDocumento], [NumeroDocumento],
[Nombre], [Direccion], [Telefono], [Email], [Cargo], [Salario],
[FechaContratacion], [Estado]) VALUES (2, N'CI', N'87654321', N'Ana Torres', N'Jr.
Las Flores 456', N'945678123', N'[email protected]', N'Supervisor',
CAST(3500.00 AS Decimal(10, 2)), CAST(N'2021-06-01' AS Date), 1)
INSERT [dbo].[Empleados] ([EmpleadoID], [TipoDocumento], [NumeroDocumento],
[Nombre], [Direccion], [Telefono], [Email], [Cargo], [Salario],
[FechaContratacion], [Estado]) VALUES (3, N'CI', N'45612378', N'Carlos López',
N'Calle Los Pinos 789', N'934567812', N'[email protected]', N'Cajero',
CAST(2000.00 AS Decimal(10, 2)), CAST(N'2022-03-08' AS Date), 1)
INSERT [dbo].[Inventario] ([InventarioID], [ProductoID], [FechaMovimiento],
[TipoMovimiento], [Cantidad], [PrecioUnitario], [Referencia]) VALUES (1, 1,
CAST(N'2024-01-10 09:00:00.000' AS DateTime), N'Entrada', 2, CAST(2000.00 AS
Decimal(10, 2)), N'Compra-1')
INSERT [dbo].[Inventario] ([InventarioID], [ProductoID], [FechaMovimiento],
[TipoMovimiento], [Cantidad], [PrecioUnitario], [Referencia]) VALUES (2, 2,
CAST(N'2024-01-10 09:00:00.000' AS DateTime), N'Entrada', 2, CAST(3000.00 AS
Decimal(10, 2)), N'Compra-1')
INSERT [dbo].[Inventario] ([InventarioID], [ProductoID], [FechaMovimiento],
[TipoMovimiento], [Cantidad], [PrecioUnitario], [Referencia]) VALUES (3, 3,
CAST(N'2024-01-12 10:00:00.000' AS DateTime), N'Entrada', 3, CAST(1666.67 AS
Decimal(10, 2)), N'Compra-2')
INSERT [dbo].[Inventario] ([InventarioID], [ProductoID], [FechaMovimiento],
[TipoMovimiento], [Cantidad], [PrecioUnitario], [Referencia]) VALUES (4, 1,
CAST(N'2024-01-15 10:30:00.000' AS DateTime), N'Salida', 1, CAST(2499.99 AS
Decimal(10, 2)), N'Venta-1')
INSERT [dbo].[Inventario] ([InventarioID], [ProductoID], [FechaMovimiento],
[TipoMovimiento], [Cantidad], [PrecioUnitario], [Referencia]) VALUES (5, 4,
CAST(N'2024-01-16 15:45:00.000' AS DateTime), N'Salida', 1, CAST(1499.99 AS
Decimal(10, 2)), N'Venta-2')
INSERT [dbo].[Inventario] ([InventarioID], [ProductoID], [FechaMovimiento],
[TipoMovimiento], [Cantidad], [PrecioUnitario], [Referencia]) VALUES (6, 2,
CAST(N'2024-01-17 11:20:00.000' AS DateTime), N'Salida', 1, CAST(3299.99 AS
Decimal(10, 2)), N'Venta-3')
INSERT [dbo].[Productos] ([ProductoID], [CategoriaID], [Nombre], [Descripcion],
[PrecioUnitario], [Stock], [StockMinimo], [UnidadMedida], [Estado],
[FechaCreacion]) VALUES (1, 1, N'Smart TV 55"', N'Televisor LED Smart 4K',
CAST(2499.99 AS Decimal(10, 2)), 15, 5, N'Unidad', 1, CAST(N'2024-10-25
18:46:02.553' AS DateTime))
INSERT [dbo].[Productos] ([ProductoID], [CategoriaID], [Nombre], [Descripcion],
[PrecioUnitario], [Stock], [StockMinimo], [UnidadMedida], [Estado],
[FechaCreacion]) VALUES (2, 1, N'Laptop HP', N'Laptop HP 15.6" Core i5',
CAST(3299.99 AS Decimal(10, 2)), 20, 8, N'Unidad', 1, CAST(N'2024-10-25
18:46:02.553' AS DateTime))
INSERT [dbo].[Productos] ([ProductoID], [CategoriaID], [Nombre], [Descripcion],
[PrecioUnitario], [Stock], [StockMinimo], [UnidadMedida], [Estado],
[FechaCreacion]) VALUES (3, 2, N'Refrigeradora', N'Refrigeradora No Frost 420L',
CAST(1899.99 AS Decimal(10, 2)), 10, 3, N'Unidad', 1, CAST(N'2024-10-25
18:46:02.553' AS DateTime))
INSERT [dbo].[Productos] ([ProductoID], [CategoriaID], [Nombre], [Descripcion],
[PrecioUnitario], [Stock], [StockMinimo], [UnidadMedida], [Estado],
[FechaCreacion]) VALUES (4, 2, N'Lavadora', N'Lavadora Automática 15kg',
CAST(1499.99 AS Decimal(10, 2)), 12, 4, N'Unidad', 1, CAST(N'2024-10-25
18:46:02.553' AS DateTime))
INSERT [dbo].[Productos] ([ProductoID], [CategoriaID], [Nombre], [Descripcion],
[PrecioUnitario], [Stock], [StockMinimo], [UnidadMedida], [Estado],
[FechaCreacion]) VALUES (5, 3, N'Sofá Reclinable', N'Sofá Reclinable de 3 Cuerpos',
CAST(999.99 AS Decimal(10, 2)), 8, 2, N'Unidad', 1, CAST(N'2024-10-25 18:46:02.553'
AS DateTime))
INSERT [dbo].[ProductosPromocion] ([PromocionID], [ProductoID]) VALUES (1, 1)
INSERT [dbo].[ProductosPromocion] ([PromocionID], [ProductoID]) VALUES (1, 2)
INSERT [dbo].[ProductosPromocion] ([PromocionID], [ProductoID]) VALUES (2, 3)
INSERT [dbo].[ProductosPromocion] ([PromocionID], [ProductoID]) VALUES (2, 4)
INSERT [dbo].[Promociones] ([PromocionID], [Nombre], [Descripcion], [FechaInicio],
[FechaFin], [Descuento], [Estado]) VALUES (1, N'Cyber Wow', N'Descuentos en
electrónicos', CAST(N'2024-01-15' AS Date), CAST(N'2024-01-18' AS Date), CAST(15.00
AS Decimal(5, 2)), 1)
INSERT [dbo].[Promociones] ([PromocionID], [Nombre], [Descripcion], [FechaInicio],
[FechaFin], [Descuento], [Estado]) VALUES (2, N'Liquidación Verano', N'Ofertas en
línea blanca', CAST(N'2024-01-02' AS Date), CAST(N'2024-01-07' AS Date), CAST(20.00
AS Decimal(5, 2)), 1)
INSERT [dbo].[Proveedores] ([ProveedorID], [RazonSocial], [RUC], [Direccion],
[Ciudad], [Telefono], [Email], [Estado], [FechaRegistro]) VALUES (1, N'Tecnoimport
SAC', N'20123456789', N'Av. Industrial 123', N'Lima', N'01-4567890',
N'[email protected]', 1, CAST(N'2024-10-25 18:46:02.553' AS DateTime))
INSERT [dbo].[Proveedores] ([ProveedorID], [RazonSocial], [RUC], [Direccion],
[Ciudad], [Telefono], [Email], [Estado], [FechaRegistro]) VALUES (2, N'Electrohogar
EIRL', N'20987654321', N'Jr. Comercio 456', N'Arequipa', N'054-234567',
N'[email protected]', 1, CAST(N'2024-10-25 18:46:02.553' AS DateTime))
INSERT [dbo].[Proveedores] ([ProveedorID], [RazonSocial], [RUC], [Direccion],
[Ciudad], [Telefono], [Email], [Estado], [FechaRegistro]) VALUES (3, N'Muebles
Modernos SA', N'20456789123', N'Av. La Marina 789', N'Lima', N'01-3456789',
N'[email protected]', 1, CAST(N'2024-10-25 18:46:02.553' AS DateTime))
INSERT [dbo].[Ventas] ([VentaID], [ClienteID], [EmpleadoID], [FechaVenta],
[TipoComprobante], [NumeroComprobante], [Subtotal], [IGV], [Descuento], [Total],
[Estado], [SucursalID]) VALUES (1, 1, 1, CAST(N'2024-01-15 10:30:00.000' AS
DateTime), N'Factura', N'F001-00001', CAST(2118.64 AS Decimal(10, 2)), CAST(381.35
AS Decimal(10, 2)), CAST(0.00 AS Decimal(10, 2)), CAST(2500.00 AS Decimal(10, 2)),
N'Completada', 1)
INSERT [dbo].[Ventas] ([VentaID], [ClienteID], [EmpleadoID], [FechaVenta],
[TipoComprobante], [NumeroComprobante], [Subtotal], [IGV], [Descuento], [Total],
[Estado], [SucursalID]) VALUES (2, 2, 2, CAST(N'2024-01-16 15:45:00.000' AS
DateTime), N'Boleta', N'B001-00001', CAST(1271.19 AS Decimal(10, 2)), CAST(228.81
AS Decimal(10, 2)), CAST(100.00 AS Decimal(10, 2)), CAST(1400.00 AS Decimal(10,
2)), N'Completada', 1)
INSERT [dbo].[Ventas] ([VentaID], [ClienteID], [EmpleadoID], [FechaVenta],
[TipoComprobante], [NumeroComprobante], [Subtotal], [IGV], [Descuento], [Total],
[Estado], [SucursalID]) VALUES (3, 3, 1, CAST(N'2024-01-17 11:20:00.000' AS
DateTime), N'Factura', N'F001-00002', CAST(4237.29 AS Decimal(10, 2)), CAST(762.71
AS Decimal(10, 2)), CAST(200.00 AS Decimal(10, 2)), CAST(4800.00 AS Decimal(10,
2)), N'Completada', 1)
ALTER TABLE [dbo].[Compras] WITH CHECK ADD FOREIGN KEY([ProveedorID])
REFERENCES [dbo].[Proveedores] ([ProveedorID])
GO
ALTER TABLE [dbo].[DetalleCompras] WITH CHECK ADD FOREIGN KEY([CompraID])
REFERENCES [dbo].[Compras] ([CompraID])
GO
ALTER TABLE [dbo].[DetalleCompras] WITH CHECK ADD FOREIGN KEY([ProductoID])
REFERENCES [dbo].[Productos] ([ProductoID])
GO
ALTER TABLE [dbo].[DetalleVentas] WITH CHECK ADD FOREIGN KEY([ProductoID])
REFERENCES [dbo].[Productos] ([ProductoID])
GO
ALTER TABLE [dbo].[DetalleVentas] WITH CHECK ADD FOREIGN KEY([VentaID])
REFERENCES [dbo].[Ventas] ([VentaID])
GO
ALTER TABLE [dbo].[Inventario] WITH CHECK ADD FOREIGN KEY([ProductoID])
REFERENCES [dbo].[Productos] ([ProductoID])
GO
ALTER TABLE [dbo].[Productos] WITH CHECK ADD FOREIGN KEY([CategoriaID])
REFERENCES [dbo].[Categorias] ([CategoriaID])
GO
ALTER TABLE [dbo].[ProductosPromocion] WITH CHECK ADD FOREIGN KEY([ProductoID])
REFERENCES [dbo].[Productos] ([ProductoID])
GO
ALTER TABLE [dbo].[ProductosPromocion] WITH CHECK ADD FOREIGN KEY([PromocionID])
REFERENCES [dbo].[Promociones] ([PromocionID])
GO
ALTER TABLE [dbo].[Ventas] WITH CHECK ADD FOREIGN KEY([ClienteID])
REFERENCES [dbo].[Clientes] ([ClienteID])
GO
ALTER TABLE [dbo].[Ventas] WITH CHECK ADD FOREIGN KEY([EmpleadoID])
REFERENCES [dbo].[Empleados] ([EmpleadoID])
GO
USE [master]
GO
ALTER DATABASE [Sucursal1] SET READ_WRITE
GO

También podría gustarte