{"metadata":{"kernel_spec":{"name":"SQL","language":"sql","display_name":"SQL"},"language_info":{"name":"sql","version":""}},"nbformat":4,"nbformat_minor":2,"cells":[{"cell_type":"markdown","source":["# [BD_PITER_PRO_UPDATE_V4]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']","object_type":"Database"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["USE [master]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']","object_type":"Database"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Database [BD_PITER_PRO_UPDATE_V4]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE DATABASE [BD_PITER_PRO_UPDATE_V4]\r\n CONTAINMENT = NONE\r\n ON  PRIMARY \r\n( NAME = N'BD_PITER_PRO_UPDATE_V4', FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL14.MSSQLSERVER\\MSSQL\\DATA\\BD_PITER_PRO_UPDATE_V4.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )\r\n LOG ON \r\n( NAME = N'BD_PITER_PRO_UPDATE_V4_log', FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL14.MSSQLSERVER\\MSSQL\\DATA\\BD_PITER_PRO_UPDATE_V4_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )\r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET COMPATIBILITY_LEVEL = 140\r\n","GO\r\n","IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))\r\nbegin\r\nEXEC [BD_PITER_PRO_UPDATE_V4].[dbo].[sp_fulltext_database] @action = 'enable'\r\nend\r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET ANSI_NULL_DEFAULT OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET ANSI_NULLS OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET ANSI_PADDING OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET ANSI_WARNINGS OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET ARITHABORT OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET AUTO_CLOSE OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET AUTO_SHRINK OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET AUTO_UPDATE_STATISTICS ON \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET CURSOR_CLOSE_ON_COMMIT OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET CURSOR_DEFAULT  GLOBAL \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET CONCAT_NULL_YIELDS_NULL OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET NUMERIC_ROUNDABORT OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET QUOTED_IDENTIFIER OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET RECURSIVE_TRIGGERS OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET  DISABLE_BROKER \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET AUTO_UPDATE_STATISTICS_ASYNC OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET DATE_CORRELATION_OPTIMIZATION OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET TRUSTWORTHY OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET ALLOW_SNAPSHOT_ISOLATION OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET PARAMETERIZATION SIMPLE \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET READ_COMMITTED_SNAPSHOT OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET HONOR_BROKER_PRIORITY OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET RECOVERY FULL \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET  MULTI_USER \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET PAGE_VERIFY CHECKSUM  \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET DB_CHAINING OFF \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET TARGET_RECOVERY_TIME = 60 SECONDS \r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET DELAYED_DURABILITY = DISABLED \r\n","GO\r\n","EXEC sys.sp_db_vardecimal_storage_format N'BD_PITER_PRO_UPDATE_V4', N'ON'\r\n","GO\r\n","ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET QUERY_STORE = OFF\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']","object_type":"Database"}},{"cell_type":"markdown","source":["# [Auditoria]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Auditoria']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["USE [BD_PITER_PRO_UPDATE_V4]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Auditoria']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [Auditoria]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [Auditoria]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Auditoria']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [Comunicaciones]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Comunicaciones']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [Comunicaciones]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [Comunicaciones]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Comunicaciones']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [DataWarehouse]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='DataWarehouse']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [DataWarehouse]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [DataWarehouse]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='DataWarehouse']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [Fidelizacion]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Fidelizacion']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [Fidelizacion]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [Fidelizacion]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Fidelizacion']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [InternetCosas]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='InternetCosas']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [InternetCosas]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [InternetCosas]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='InternetCosas']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [Nucleo]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Nucleo']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [Nucleo]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [Nucleo]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Nucleo']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [Pagos]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Pagos']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [Pagos]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [Pagos]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Pagos']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [Procesos]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Procesos']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [Procesos]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [Procesos]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Procesos']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [Reservas]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Reservas']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [Reservas]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [Reservas]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Reservas']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [SaaS_Gestion]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='SaaS_Gestion']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [SaaS_Gestion]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [SaaS_Gestion]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='SaaS_Gestion']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [Seguridad]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Seguridad']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [Seguridad]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [Seguridad]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Seguridad']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [Ventas]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Ventas']","object_type":"Schema"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Schema [Ventas]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE SCHEMA [Ventas]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Schema[@Name='Ventas']","object_type":"Schema"}},{"cell_type":"markdown","source":["# [Pagos].[Ingresos_Historial]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ingresos_Historial' and @Schema='Pagos']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [Pagos].[Ingresos_Historial]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [Pagos].[Ingresos_Historial](\r\n\t[id_ingresos] [uniqueidentifier] NOT NULL,\r\n\t[orden_id] [uniqueidentifier] NULL,\r\n\t[caja_diaria_id] [uniqueidentifier] NULL,\r\n\t[monto] [decimal](18, 2) NOT NULL,\r\n\t[metodo_pago] [nvarchar](50) NULL,\r\n\t[referencia_pago] [nvarchar](100) NULL,\r\n\t[SysStartTime] [datetime2](7) NOT NULL,\r\n\t[SysEndTime] [datetime2](7) NOT NULL\r\n) ON [PRIMARY]\r\nWITH\r\n(\r\nDATA_COMPRESSION = PAGE\r\n)\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ingresos_Historial' and @Schema='Pagos']","object_type":"Table"}},{"cell_type":"markdown","source":["# [ix_Ingresos_Historial]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ingresos_Historial' and @Schema='Pagos']/Index[@Name='ix_Ingresos_Historial']","object_type":"Index"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Index [ix_Ingresos_Historial]    Script Date: 24/01/2026 9:37:13 ******/\r\nCREATE CLUSTERED INDEX [ix_Ingresos_Historial] ON [Pagos].[Ingresos_Historial]\r\n(\r\n\t[SysEndTime] ASC,\r\n\t[SysStartTime] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, DATA_COMPRESSION = PAGE) ON [PRIMARY]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ingresos_Historial' and @Schema='Pagos']/Index[@Name='ix_Ingresos_Historial']","object_type":"Index"}},{"cell_type":"markdown","source":["# [dbo].[Pagos_Ingresos]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Ingresos' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Pagos_Ingresos]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Pagos_Ingresos](\r\n\t[id_ingresos] [uniqueidentifier] NOT NULL,\r\n\t[orden_id] [uniqueidentifier] NULL,\r\n\t[caja_diaria_id] [uniqueidentifier] NULL,\r\n\t[monto] [decimal](18, 2) NOT NULL,\r\n\t[metodo_pago] [nvarchar](50) NULL,\r\n\t[referencia_pago] [nvarchar](100) NULL,\r\n\t[SysStartTime] [datetime2](7) GENERATED ALWAYS AS ROW START NOT NULL,\r\n\t[SysEndTime] [datetime2](7) GENERATED ALWAYS AS ROW END NOT NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_ingresos] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],\r\n\tPERIOD FOR SYSTEM_TIME ([SysStartTime], [SysEndTime])\r\n) ON [PRIMARY]\r\nWITH\r\n(\r\nSYSTEM_VERSIONING = ON (HISTORY_TABLE = [Pagos].[Ingresos_Historial])\r\n)\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Ingresos' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Ventas_Ordenes]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Ventas_Ordenes]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Ventas_Ordenes](\r\n\t[id_ordenes] [uniqueidentifier] NOT NULL,\r\n\t[sucursal_id] [uniqueidentifier] NULL,\r\n\t[usuario_id] [uniqueidentifier] NULL,\r\n\t[cocinero_id] [uniqueidentifier] NULL,\r\n\t[cliente_id] [uniqueidentifier] NULL,\r\n\t[cliente_nombre] [nvarchar](100) NULL,\r\n\t[monto_total] [decimal](18, 2) NULL,\r\n\t[estado] [nvarchar](50) NULL,\r\n\t[es_fallida] [bit] NULL,\r\n\t[motivo_anulacion] [nvarchar](200) NULL,\r\n\t[creado_at] [datetimeoffset](7) NULL,\r\n\t[fecha_preparacion_inicio] [datetimeoffset](7) NULL,\r\n\t[fecha_termino_cocina] [datetimeoffset](7) NULL,\r\n\t[fecha_entrega_mesa] [datetimeoffset](7) NULL,\r\n\t[fecha_servido] [datetimeoffset](7) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_ordenes] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Ventas_Detalle_Orden]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Detalle_Orden' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Ventas_Detalle_Orden]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Ventas_Detalle_Orden](\r\n\t[id_detalleOrd] [uniqueidentifier] NOT NULL,\r\n\t[orden_id] [uniqueidentifier] NULL,\r\n\t[producto_id] [uniqueidentifier] NULL,\r\n\t[cantidad] [int] NOT NULL,\r\n\t[precio_aplicado] [decimal](18, 2) NOT NULL,\r\n\t[subtotal]  AS ([cantidad]*[precio_aplicado]) PERSISTED,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_detalleOrd] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Detalle_Orden' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Nucleo_Sucursales]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Nucleo_Sucursales]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Nucleo_Sucursales](\r\n\t[id_sucursal] [uniqueidentifier] NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[nombre] [nvarchar](150) NULL,\r\n\t[direccion] [nvarchar](max) NULL,\r\n\t[ubicacion_gps] [geography] NULL,\r\n\t[activo] [bit] NULL,\r\n\t[latitud] [float] NULL,\r\n\t[longitud] [float] NULL,\r\n\t[imagen_url] [varchar](255) NULL,\r\n\t[telefono] [nvarchar](50) NULL,\r\n\t[gerente_encargado_id] [uniqueidentifier] NULL,\r\n\t[horarios] [nvarchar](max) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_sucursal] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Ventas_Productos]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Ventas_Productos]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Ventas_Productos](\r\n\t[id_producto] [uniqueidentifier] NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[nombre] [nvarchar](150) NULL,\r\n\t[sku] [nvarchar](50) NULL,\r\n\t[categoria] [nvarchar](50) NULL,\r\n\t[imagen_url] [nvarchar](max) NULL,\r\n\t[es_inventariable] [bit] NULL,\r\n\t[tiempo_preparacion_estandar] [int] NULL,\r\n\t[atributos_json] [nvarchar](max) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_producto] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Ventas_Vista_Carga_Cocina]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/View[@Name='Ventas_Vista_Carga_Cocina' and @Schema='dbo']","object_type":"View"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  View [dbo].[Ventas_Vista_Carga_Cocina]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE   VIEW [dbo].[Ventas_Vista_Carga_Cocina] AS\r\nSELECT \r\n    S.id_sucursal AS sucursal_id,\r\n    COUNT(DISTINCT O.id_ordenes) AS ordenes_en_cola,\r\n    SUM(P.tiempo_preparacion_estandar * D.cantidad) AS minutos_carga_total,\r\n    (SUM(P.tiempo_preparacion_estandar * D.cantidad) / 3.0) + 5 AS tiempo_espera_real_minutos\r\nFROM Ventas_Ordenes O\r\nJOIN Ventas_Detalle_Orden D ON O.id_ordenes = D.orden_id\r\nJOIN Ventas_Productos P ON D.producto_id = P.id_producto\r\nJOIN Nucleo_Sucursales S ON O.sucursal_id = S.id_sucursal\r\nWHERE O.estado IN ('PENDIENTE', 'COCINA')\r\nGROUP BY S.id_sucursal;\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/View[@Name='Ventas_Vista_Carga_Cocina' and @Schema='dbo']","object_type":"View"}},{"cell_type":"markdown","source":["# [dbo].[Auditoria_Log_Acciones]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Auditoria_Log_Acciones' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Auditoria_Log_Acciones]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Auditoria_Log_Acciones](\r\n\t[id_log] [bigint] IDENTITY(1,1) NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[usuario_id] [uniqueidentifier] NULL,\r\n\t[modulo] [nvarchar](100) NULL,\r\n\t[accion] [nvarchar](100) NULL,\r\n\t[entidad_afectada] [nvarchar](100) NULL,\r\n\t[id_entidad] [nvarchar](100) NULL,\r\n\t[datos_antes] [nvarchar](max) NULL,\r\n\t[datos_despues] [nvarchar](max) NULL,\r\n\t[descripcion] [nvarchar](max) NULL,\r\n\t[fecha] [datetimeoffset](7) NULL,\r\n\t[ip_origen] [nvarchar](50) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_log] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Auditoria_Log_Acciones' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Comunicaciones_Notificaciones]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Comunicaciones_Notificaciones]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Comunicaciones_Notificaciones](\r\n\t[id_notifi] [uniqueidentifier] NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[usuario_id] [uniqueidentifier] NULL,\r\n\t[titulo] [nvarchar](150) NULL,\r\n\t[mensaje] [nvarchar](max) NULL,\r\n\t[tipo] [nvarchar](50) NULL,\r\n\t[leido] [bit] NULL,\r\n\t[fecha] [datetimeoffset](7) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_notifi] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[DataWarehouse_Dim_Rendimiento_Personal]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Dim_Rendimiento_Personal' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[DataWarehouse_Dim_Rendimiento_Personal]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[DataWarehouse_Dim_Rendimiento_Personal](\r\n\t[id_dwD] [bigint] IDENTITY(1,1) NOT NULL,\r\n\t[usuario_id] [uniqueidentifier] NULL,\r\n\t[sucursal_id] [uniqueidentifier] NULL,\r\n\t[rol_en_orden] [nvarchar](50) NULL,\r\n\t[total_ordenes_atendidas] [int] NULL,\r\n\t[monto_total_generado] [decimal](18, 2) NULL,\r\n\t[total_ventas_fallidas] [int] NULL,\r\n\t[promedio_tiempo_respuesta] [float] NULL,\r\n\t[promedio_tiempo_cocina] [float] NULL,\r\n\t[mes] [int] NULL,\r\n\t[anio] [int] NULL,\r\n\t[fecha_calculo] [datetimeoffset](7) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_dwD] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Dim_Rendimiento_Personal' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[DataWarehouse_Fact_Ventas_Historico]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Fact_Ventas_Historico' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[DataWarehouse_Fact_Ventas_Historico]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[DataWarehouse_Fact_Ventas_Historico](\r\n\t[id_dwF] [bigint] IDENTITY(1,1) NOT NULL,\r\n\t[fecha_venta] [date] NULL,\r\n\t[sucursal_nombre] [nvarchar](150) NULL,\r\n\t[producto_nombre] [nvarchar](150) NULL,\r\n\t[categoria] [nvarchar](50) NULL,\r\n\t[cantidad_vendida] [int] NULL,\r\n\t[total_ganado] [decimal](18, 2) NULL,\r\n\t[mes] [int] NULL,\r\n\t[anio] [int] NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_dwF] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Fact_Ventas_Historico' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Fidelizacion_Niveles]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Fidelizacion_Niveles' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Fidelizacion_Niveles]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Fidelizacion_Niveles](\r\n\t[id_fidel] [int] IDENTITY(1,1) NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[nombre] [nvarchar](50) NULL,\r\n\t[descuento_porcentaje] [decimal](5, 2) NULL,\r\n\t[precio_suscripcion] [decimal](18, 2) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_fidel] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Fidelizacion_Niveles' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[InternetCosas_Dispositivos]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Dispositivos' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[InternetCosas_Dispositivos]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[InternetCosas_Dispositivos](\r\n\t[mac] [nvarchar](100) NOT NULL,\r\n\t[recurso_id] [uniqueidentifier] NULL,\r\n\t[ruc] [varchar](20) NULL,\r\n\t[sucursal_id] [varchar](20) NULL,\r\n\t[numero_mesa] [int] NULL,\r\n\t[estado] [varchar](20) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[mac] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Dispositivos' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[InternetCosas_Eventos]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Eventos' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[InternetCosas_Eventos]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[InternetCosas_Eventos](\r\n\t[id_evento] [bigint] IDENTITY(1,1) NOT NULL,\r\n\t[dispositivo_id] [nvarchar](100) NULL,\r\n\t[evento] [nvarchar](50) NULL,\r\n\t[fecha] [datetimeoffset](7) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_evento] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Eventos' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Nucleo_Empresas]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Empresas' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Nucleo_Empresas]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Nucleo_Empresas](\r\n\t[id_empresa] [uniqueidentifier] NOT NULL,\r\n\t[razon_social] [nvarchar](150) NOT NULL,\r\n\t[ruc_nit] [nvarchar](20) NULL,\r\n\t[tipo_negocio] [nvarchar](50) NULL,\r\n\t[estado] [nvarchar](20) NULL,\r\n\t[configuracion_json] [nvarchar](max) NULL,\r\n\t[creado_at] [datetimeoffset](7) NULL,\r\n\t[logo_url] [nvarchar](max) NULL,\r\n\t[plan_id] [uniqueidentifier] NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_empresa] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Empresas' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Nucleo_Recursos]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Recursos' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Nucleo_Recursos]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Nucleo_Recursos](\r\n\t[id_recurso] [uniqueidentifier] NOT NULL,\r\n\t[sucursal_id] [uniqueidentifier] NULL,\r\n\t[nombre] [nvarchar](50) NULL,\r\n\t[tipo] [nvarchar](50) NULL,\r\n\t[estado] [nvarchar](50) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_recurso] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Recursos' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Pagos_Cajas_Diarias]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Pagos_Cajas_Diarias]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Pagos_Cajas_Diarias](\r\n\t[id_cajaDi] [uniqueidentifier] NOT NULL,\r\n\t[sucursal_id] [uniqueidentifier] NULL,\r\n\t[usuario_id] [uniqueidentifier] NULL,\r\n\t[fecha_apertura] [datetimeoffset](7) NULL,\r\n\t[fecha_cierre] [datetimeoffset](7) NULL,\r\n\t[monto_inicial] [decimal](18, 2) NOT NULL,\r\n\t[monto_final_esperado]  AS ([monto_inicial]+[total_ingresos_efectivo]),\r\n\t[total_ingresos_efectivo] [decimal](18, 2) NULL,\r\n\t[monto_final_real] [decimal](18, 2) NULL,\r\n\t[estado] [nvarchar](20) NULL,\r\n\t[observaciones] [nvarchar](max) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_cajaDi] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Procesos_Cola_Eventos]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Procesos_Cola_Eventos' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Procesos_Cola_Eventos]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Procesos_Cola_Eventos](\r\n\t[id_colaE] [bigint] IDENTITY(1,1) NOT NULL,\r\n\t[tipo_evento] [nvarchar](100) NULL,\r\n\t[payload] [nvarchar](max) NULL,\r\n\t[procesado] [bit] NULL,\r\n\t[fecha_creacion] [datetimeoffset](7) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_colaE] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Procesos_Cola_Eventos' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Reservas_Reservaciones]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Reservas_Reservaciones]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Reservas_Reservaciones](\r\n\t[id_reserva] [uniqueidentifier] NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[cliente_id] [uniqueidentifier] NULL,\r\n\t[recurso_id] [uniqueidentifier] NULL,\r\n\t[fecha_inicio] [datetimeoffset](7) NOT NULL,\r\n\t[fecha_fin] [datetimeoffset](7) NOT NULL,\r\n\t[estado] [nvarchar](20) NULL,\r\n\t[observaciones] [nvarchar](max) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_reserva] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[SaaS_Gestion_CaracteristicasPlan]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_CaracteristicasPlan' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[SaaS_Gestion_CaracteristicasPlan]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[SaaS_Gestion_CaracteristicasPlan](\r\n\t[id_ContiPlan] [uniqueidentifier] NOT NULL,\r\n\t[codigo] [nvarchar](50) NOT NULL,\r\n\t[nombre] [nvarchar](100) NOT NULL,\r\n\t[descripcion] [nvarchar](255) NULL,\r\n\t[activo] [bit] NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_ContiPlan] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],\r\nUNIQUE NONCLUSTERED \r\n(\r\n\t[codigo] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_CaracteristicasPlan' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[SaaS_Gestion_Empresa_CaracteristicaPl]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Empresa_CaracteristicaPl' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[SaaS_Gestion_Empresa_CaracteristicaPl]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[SaaS_Gestion_Empresa_CaracteristicaPl](\r\n\t[id_EmpCaracteristicaPl] [uniqueidentifier] NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NOT NULL,\r\n\t[feature_id] [uniqueidentifier] NOT NULL,\r\n\t[valor_over_habilitar] [bit] NOT NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_EmpCaracteristicaPl] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],\r\n CONSTRAINT [UQ_Empresa_Feature] UNIQUE NONCLUSTERED \r\n(\r\n\t[empresa_id] ASC,\r\n\t[feature_id] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Empresa_CaracteristicaPl' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[SaaS_Gestion_Facturacion_Servicio]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Facturacion_Servicio' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[SaaS_Gestion_Facturacion_Servicio]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[SaaS_Gestion_Facturacion_Servicio](\r\n\t[id_Factura] [uniqueidentifier] NOT NULL,\r\n\t[suscripcion_id] [uniqueidentifier] NULL,\r\n\t[monto_pagado] [decimal](18, 2) NULL,\r\n\t[fecha_pago] [datetimeoffset](7) NULL,\r\n\t[metodo_pago] [nvarchar](50) NULL,\r\n\t[nro_operacion] [nvarchar](100) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_Factura] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Facturacion_Servicio' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[SaaS_Gestion_Plan_ContenidoPlan]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Plan_ContenidoPlan' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[SaaS_Gestion_Plan_ContenidoPlan]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[SaaS_Gestion_Plan_ContenidoPlan](\r\n\t[id_contenidoPl] [uniqueidentifier] NOT NULL,\r\n\t[id_plan] [uniqueidentifier] NOT NULL,\r\n\t[id_CaracteristicasPlan] [uniqueidentifier] NOT NULL,\r\n\t[valor] [bit] NOT NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_contenidoPl] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],\r\n CONSTRAINT [UQ_Plan_Feature] UNIQUE NONCLUSTERED \r\n(\r\n\t[id_plan] ASC,\r\n\t[id_CaracteristicasPlan] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Plan_ContenidoPlan' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[SaaS_Gestion_Planes]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[SaaS_Gestion_Planes]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[SaaS_Gestion_Planes](\r\n\t[plan_id] [uniqueidentifier] NOT NULL,\r\n\t[nombre] [nvarchar](50) NOT NULL,\r\n\t[precio_mensual] [decimal](18, 2) NOT NULL,\r\n\t[limite_sucursales] [int] NULL,\r\n\t[limite_usuarios] [int] NULL,\r\n\t[acceso_iot] [bit] NULL,\r\n\t[activo] [bit] NULL,\r\n\t[descripcion] [nvarchar](255) NULL,\r\n\t[ciclo_facturacion] [int] NULL,\r\n\t[icono_url] [nvarchar](max) NULL,\r\n\t[beneficio_camaleon] [bit] NULL,\r\n\t[beneficio_publicidad] [bit] NULL,\r\n\t[beneficio_soporte_vip] [bit] NULL,\r\n\t[beneficio_analitica] [bit] NULL,\r\n\t[beneficio_eventos] [bit] NULL,\r\n\t[destacado] [bit] NULL,\r\n\t[nivel] [nvarchar](20) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[plan_id] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[SaaS_Gestion_Suscripciones]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[SaaS_Gestion_Suscripciones]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[SaaS_Gestion_Suscripciones](\r\n\t[id_subsP] [uniqueidentifier] NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[plan_id] [uniqueidentifier] NULL,\r\n\t[fecha_inicio] [datetime] NOT NULL,\r\n\t[fecha_vencimiento] [datetime] NOT NULL,\r\n\t[estado] [nvarchar](20) NULL,\r\n\t[renovacion_auto] [bit] NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_subsP] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Seguridad_Perfil_Permisos]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfil_Permisos' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Seguridad_Perfil_Permisos]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Seguridad_Perfil_Permisos](\r\n\t[perfil_id] [int] NOT NULL,\r\n\t[permiso_id] [int] NOT NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[perfil_id] ASC,\r\n\t[permiso_id] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfil_Permisos' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Seguridad_Perfiles]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfiles' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Seguridad_Perfiles]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Seguridad_Perfiles](\r\n\t[id_perfil] [int] IDENTITY(1,1) NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[nombre] [nvarchar](50) NOT NULL,\r\n\t[descripcion] [nvarchar](200) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_perfil] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfiles' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Seguridad_Permisos_Sistema]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Permisos_Sistema' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Seguridad_Permisos_Sistema]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Seguridad_Permisos_Sistema](\r\n\t[id_secur_perf] [int] IDENTITY(1,1) NOT NULL,\r\n\t[codigo_interno] [nvarchar](50) NULL,\r\n\t[descripcion] [nvarchar](100) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_secur_perf] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],\r\nUNIQUE NONCLUSTERED \r\n(\r\n\t[codigo_interno] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Permisos_Sistema' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Seguridad_Sesiones]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Sesiones' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Seguridad_Sesiones]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Seguridad_Sesiones](\r\n\t[id_sesiones] [uniqueidentifier] NOT NULL,\r\n\t[usuario_id] [uniqueidentifier] NULL,\r\n\t[token_hash] [nvarchar](255) NULL,\r\n\t[fecha_expiracion] [datetimeoffset](7) NULL,\r\n\t[ip] [nvarchar](50) NULL,\r\n\t[user_agent] [nvarchar](255) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_sesiones] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Sesiones' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Seguridad_Usuarios]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Seguridad_Usuarios]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Seguridad_Usuarios](\r\n\t[id_usuario] [uniqueidentifier] NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[sucursal_asignada_id] [uniqueidentifier] NULL,\r\n\t[perfil_id] [int] NULL,\r\n\t[reporte_a_id] [uniqueidentifier] NULL,\r\n\t[nombre_completo] [nvarchar](100) NULL,\r\n\t[email] [nvarchar](255) NOT NULL,\r\n\t[password_hash] [nvarchar](max) NOT NULL,\r\n\t[estado] [nvarchar](20) NULL,\r\n\t[foto_url] [nvarchar](max) NULL,\r\n\t[color_preferido] [varchar](20) NULL,\r\n\t[color_fondo_preferido] [varchar](20) NULL,\r\n\t[dni] [varchar](20) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_usuario] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Ventas_Clientes]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Ventas_Clientes]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Ventas_Clientes](\r\n\t[id_cliente] [uniqueidentifier] NOT NULL,\r\n\t[empresa_id] [uniqueidentifier] NULL,\r\n\t[nivel_fidelizacion_id] [int] NULL,\r\n\t[nombre_completo] [nvarchar](150) NULL,\r\n\t[documento_identidad] [nvarchar](20) NULL,\r\n\t[email] [nvarchar](150) NULL,\r\n\t[telefono] [nvarchar](20) NULL,\r\n\t[es_miembro_vip] [bit] NULL,\r\n\t[creado_at] [datetimeoffset](7) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_cliente] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Ventas_Listas_Precios]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Listas_Precios' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Ventas_Listas_Precios]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Ventas_Listas_Precios](\r\n\t[id_lista] [int] IDENTITY(1,1) NOT NULL,\r\n\t[sucursal_id] [uniqueidentifier] NULL,\r\n\t[nombre] [nvarchar](50) NULL,\r\n\t[fecha_inicio] [datetime] NULL,\r\n\t[fecha_fin] [datetime] NULL,\r\n\t[prioridad] [int] NULL,\r\n\t[activa] [bit] NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_lista] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Listas_Precios' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Ventas_Movimientos_Stock]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Ventas_Movimientos_Stock]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Ventas_Movimientos_Stock](\r\n\t[id_mov_stock] [bigint] IDENTITY(1,1) NOT NULL,\r\n\t[producto_id] [uniqueidentifier] NULL,\r\n\t[sucursal_id] [uniqueidentifier] NULL,\r\n\t[usuario_id] [uniqueidentifier] NULL,\r\n\t[tipo] [nvarchar](50) NULL,\r\n\t[cantidad] [int] NULL,\r\n\t[motivo] [nvarchar](200) NULL,\r\n\t[fecha] [datetimeoffset](7) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_mov_stock] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Ventas_Precios_Producto]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Precios_Producto' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Ventas_Precios_Producto]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Ventas_Precios_Producto](\r\n\t[id_precios] [int] NOT NULL,\r\n\t[producto_id] [uniqueidentifier] NOT NULL,\r\n\t[precio] [decimal](18, 2) NOT NULL,\r\n\t[moneda] [char](3) NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[id_precios] ASC,\r\n\t[producto_id] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Precios_Producto' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [dbo].[Ventas_Stock]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Stock' and @Schema='dbo']","object_type":"Table"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  Table [dbo].[Ventas_Stock]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","CREATE TABLE [dbo].[Ventas_Stock](\r\n\t[producto_id] [uniqueidentifier] NOT NULL,\r\n\t[sucursal_id] [uniqueidentifier] NOT NULL,\r\n\t[cantidad_actual] [int] NOT NULL,\r\n\t[stock_minimo] [int] NULL,\r\nPRIMARY KEY CLUSTERED \r\n(\r\n\t[producto_id] ASC,\r\n\t[sucursal_id] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY]\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Stock' and @Schema='dbo']","object_type":"Table"}},{"cell_type":"markdown","source":["# [DF__Auditoria__fecha__3E1D39E1]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Auditoria_Log_Acciones' and @Schema='dbo']/Column[@Name='fecha']/Default[@Name='DF__Auditoria__fecha__3E1D39E1']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Auditoria_Log_Acciones] ADD  DEFAULT (sysdatetimeoffset()) FOR [fecha]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Auditoria_Log_Acciones' and @Schema='dbo']/Column[@Name='fecha']/Default[@Name='DF__Auditoria__fecha__3E1D39E1']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Comunicac__id_no__40F9A68C]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/Column[@Name='id_notifi']/Default[@Name='DF__Comunicac__id_no__40F9A68C']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Comunicaciones_Notificaciones] ADD  DEFAULT (newid()) FOR [id_notifi]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/Column[@Name='id_notifi']/Default[@Name='DF__Comunicac__id_no__40F9A68C']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Comunicac__leido__43D61337]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/Column[@Name='leido']/Default[@Name='DF__Comunicac__leido__43D61337']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Comunicaciones_Notificaciones] ADD  DEFAULT ((0)) FOR [leido]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/Column[@Name='leido']/Default[@Name='DF__Comunicac__leido__43D61337']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Comunicac__fecha__44CA3770]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/Column[@Name='fecha']/Default[@Name='DF__Comunicac__fecha__44CA3770']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Comunicaciones_Notificaciones] ADD  DEFAULT (sysdatetimeoffset()) FOR [fecha]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/Column[@Name='fecha']/Default[@Name='DF__Comunicac__fecha__44CA3770']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__DataWareh__fecha__4F47C5E3]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Dim_Rendimiento_Personal' and @Schema='dbo']/Column[@Name='fecha_calculo']/Default[@Name='DF__DataWareh__fecha__4F47C5E3']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[DataWarehouse_Dim_Rendimiento_Personal] ADD  DEFAULT (sysdatetimeoffset()) FOR [fecha_calculo]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Dim_Rendimiento_Personal' and @Schema='dbo']/Column[@Name='fecha_calculo']/Default[@Name='DF__DataWareh__fecha__4F47C5E3']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Fidelizac__descu__5441852A]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Fidelizacion_Niveles' and @Schema='dbo']/Column[@Name='descuento_porcentaje']/Default[@Name='DF__Fidelizac__descu__5441852A']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Fidelizacion_Niveles] ADD  DEFAULT ((0)) FOR [descuento_porcentaje]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Fidelizacion_Niveles' and @Schema='dbo']/Column[@Name='descuento_porcentaje']/Default[@Name='DF__Fidelizac__descu__5441852A']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Fidelizac__preci__5535A963]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Fidelizacion_Niveles' and @Schema='dbo']/Column[@Name='precio_suscripcion']/Default[@Name='DF__Fidelizac__preci__5535A963']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Fidelizacion_Niveles] ADD  DEFAULT ((0)) FOR [precio_suscripcion]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Fidelizacion_Niveles' and @Schema='dbo']/Column[@Name='precio_suscripcion']/Default[@Name='DF__Fidelizac__preci__5535A963']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__InternetC__fecha__395884C4]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Eventos' and @Schema='dbo']/Column[@Name='fecha']/Default[@Name='DF__InternetC__fecha__395884C4']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[InternetCosas_Eventos] ADD  DEFAULT (sysdatetimeoffset()) FOR [fecha]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Eventos' and @Schema='dbo']/Column[@Name='fecha']/Default[@Name='DF__InternetC__fecha__395884C4']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Nucleo_Em__id_em__3E52440B]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Empresas' and @Schema='dbo']/Column[@Name='id_empresa']/Default[@Name='DF__Nucleo_Em__id_em__3E52440B']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Empresas] ADD  DEFAULT (newid()) FOR [id_empresa]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Empresas' and @Schema='dbo']/Column[@Name='id_empresa']/Default[@Name='DF__Nucleo_Em__id_em__3E52440B']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Nucleo_Em__estad__3F466844]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Empresas' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Nucleo_Em__estad__3F466844']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Empresas] ADD  DEFAULT ('ACTIVA') FOR [estado]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Empresas' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Nucleo_Em__estad__3F466844']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Nucleo_Em__cread__403A8C7D]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Empresas' and @Schema='dbo']/Column[@Name='creado_at']/Default[@Name='DF__Nucleo_Em__cread__403A8C7D']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Empresas] ADD  DEFAULT (sysdatetimeoffset()) FOR [creado_at]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Empresas' and @Schema='dbo']/Column[@Name='creado_at']/Default[@Name='DF__Nucleo_Em__cread__403A8C7D']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Nucleo_Re__id_re__0D7A0286]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Recursos' and @Schema='dbo']/Column[@Name='id_recurso']/Default[@Name='DF__Nucleo_Re__id_re__0D7A0286']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Recursos] ADD  DEFAULT (newid()) FOR [id_recurso]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Recursos' and @Schema='dbo']/Column[@Name='id_recurso']/Default[@Name='DF__Nucleo_Re__id_re__0D7A0286']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Nucleo_Re__estad__0F624AF8]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Recursos' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Nucleo_Re__estad__0F624AF8']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Recursos] ADD  DEFAULT ('LIBRE') FOR [estado]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Recursos' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Nucleo_Re__estad__0F624AF8']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Nucleo_Su__id_su__4E88ABD4]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']/Column[@Name='id_sucursal']/Default[@Name='DF__Nucleo_Su__id_su__4E88ABD4']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Sucursales] ADD  DEFAULT (newid()) FOR [id_sucursal]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']/Column[@Name='id_sucursal']/Default[@Name='DF__Nucleo_Su__id_su__4E88ABD4']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Nucleo_Su__activ__5070F446]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']/Column[@Name='activo']/Default[@Name='DF__Nucleo_Su__activ__5070F446']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Sucursales] ADD  DEFAULT ((1)) FOR [activo]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']/Column[@Name='activo']/Default[@Name='DF__Nucleo_Su__activ__5070F446']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Pagos_Caj__id_ca__282DF8C2]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/Column[@Name='id_cajaDi']/Default[@Name='DF__Pagos_Caj__id_ca__282DF8C2']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Pagos_Cajas_Diarias] ADD  DEFAULT (newid()) FOR [id_cajaDi]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/Column[@Name='id_cajaDi']/Default[@Name='DF__Pagos_Caj__id_ca__282DF8C2']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Pagos_Caj__fecha__2B0A656D]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/Column[@Name='fecha_apertura']/Default[@Name='DF__Pagos_Caj__fecha__2B0A656D']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Pagos_Cajas_Diarias] ADD  DEFAULT (sysdatetimeoffset()) FOR [fecha_apertura]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/Column[@Name='fecha_apertura']/Default[@Name='DF__Pagos_Caj__fecha__2B0A656D']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Pagos_Caj__total__2BFE89A6]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/Column[@Name='total_ingresos_efectivo']/Default[@Name='DF__Pagos_Caj__total__2BFE89A6']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Pagos_Cajas_Diarias] ADD  DEFAULT ((0)) FOR [total_ingresos_efectivo]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/Column[@Name='total_ingresos_efectivo']/Default[@Name='DF__Pagos_Caj__total__2BFE89A6']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Pagos_Caj__estad__2CF2ADDF]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Pagos_Caj__estad__2CF2ADDF']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Pagos_Cajas_Diarias] ADD  DEFAULT ('ABIERTA') FOR [estado]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Pagos_Caj__estad__2CF2ADDF']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Pagos_Ing__id_in__2FCF1A8A]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Ingresos' and @Schema='dbo']/Column[@Name='id_ingresos']/Default[@Name='DF__Pagos_Ing__id_in__2FCF1A8A']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Pagos_Ingresos] ADD  DEFAULT (newid()) FOR [id_ingresos]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Ingresos' and @Schema='dbo']/Column[@Name='id_ingresos']/Default[@Name='DF__Pagos_Ing__id_in__2FCF1A8A']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Procesos___proce__47A6A41B]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Procesos_Cola_Eventos' and @Schema='dbo']/Column[@Name='procesado']/Default[@Name='DF__Procesos___proce__47A6A41B']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Procesos_Cola_Eventos] ADD  DEFAULT ((0)) FOR [procesado]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Procesos_Cola_Eventos' and @Schema='dbo']/Column[@Name='procesado']/Default[@Name='DF__Procesos___proce__47A6A41B']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Procesos___fecha__489AC854]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Procesos_Cola_Eventos' and @Schema='dbo']/Column[@Name='fecha_creacion']/Default[@Name='DF__Procesos___fecha__489AC854']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Procesos_Cola_Eventos] ADD  DEFAULT (sysdatetimeoffset()) FOR [fecha_creacion]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Procesos_Cola_Eventos' and @Schema='dbo']/Column[@Name='fecha_creacion']/Default[@Name='DF__Procesos___fecha__489AC854']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Reservas___id_re__123EB7A3]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/Column[@Name='id_reserva']/Default[@Name='DF__Reservas___id_re__123EB7A3']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Reservas_Reservaciones] ADD  DEFAULT (newid()) FOR [id_reserva]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/Column[@Name='id_reserva']/Default[@Name='DF__Reservas___id_re__123EB7A3']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Reservas___estad__160F4887]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Reservas___estad__160F4887']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Reservas_Reservaciones] ADD  DEFAULT ('CONFIRMADA') FOR [estado]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Reservas___estad__160F4887']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__id_Co__531856C7]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_CaracteristicasPlan' and @Schema='dbo']/Column[@Name='id_ContiPlan']/Default[@Name='DF__SaaS_Gest__id_Co__531856C7']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_CaracteristicasPlan] ADD  DEFAULT (newid()) FOR [id_ContiPlan]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_CaracteristicasPlan' and @Schema='dbo']/Column[@Name='id_ContiPlan']/Default[@Name='DF__SaaS_Gest__id_Co__531856C7']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__activ__540C7B00]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_CaracteristicasPlan' and @Schema='dbo']/Column[@Name='activo']/Default[@Name='DF__SaaS_Gest__activ__540C7B00']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_CaracteristicasPlan] ADD  DEFAULT ((1)) FOR [activo]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_CaracteristicasPlan' and @Schema='dbo']/Column[@Name='activo']/Default[@Name='DF__SaaS_Gest__activ__540C7B00']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__id_Em__5D95E53A]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Empresa_CaracteristicaPl' and @Schema='dbo']/Column[@Name='id_EmpCaracteristicaPl']/Default[@Name='DF__SaaS_Gest__id_Em__5D95E53A']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Empresa_CaracteristicaPl] ADD  DEFAULT (newid()) FOR [id_EmpCaracteristicaPl]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Empresa_CaracteristicaPl' and @Schema='dbo']/Column[@Name='id_EmpCaracteristicaPl']/Default[@Name='DF__SaaS_Gest__id_Em__5D95E53A']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__id_Fa__49C3F6B7]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Facturacion_Servicio' and @Schema='dbo']/Column[@Name='id_Factura']/Default[@Name='DF__SaaS_Gest__id_Fa__49C3F6B7']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Facturacion_Servicio] ADD  DEFAULT (newid()) FOR [id_Factura]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Facturacion_Servicio' and @Schema='dbo']/Column[@Name='id_Factura']/Default[@Name='DF__SaaS_Gest__id_Fa__49C3F6B7']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__fecha__4BAC3F29]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Facturacion_Servicio' and @Schema='dbo']/Column[@Name='fecha_pago']/Default[@Name='DF__SaaS_Gest__fecha__4BAC3F29']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Facturacion_Servicio] ADD  DEFAULT (sysdatetimeoffset()) FOR [fecha_pago]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Facturacion_Servicio' and @Schema='dbo']/Column[@Name='fecha_pago']/Default[@Name='DF__SaaS_Gest__fecha__4BAC3F29']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__id_co__57DD0BE4]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Plan_ContenidoPlan' and @Schema='dbo']/Column[@Name='id_contenidoPl']/Default[@Name='DF__SaaS_Gest__id_co__57DD0BE4']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Plan_ContenidoPlan] ADD  DEFAULT (newid()) FOR [id_contenidoPl]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Plan_ContenidoPlan' and @Schema='dbo']/Column[@Name='id_contenidoPl']/Default[@Name='DF__SaaS_Gest__id_co__57DD0BE4']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__plan___37A5467C]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='plan_id']/Default[@Name='DF__SaaS_Gest__plan___37A5467C']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT (newid()) FOR [plan_id]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='plan_id']/Default[@Name='DF__SaaS_Gest__plan___37A5467C']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__limit__38996AB5]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='limite_sucursales']/Default[@Name='DF__SaaS_Gest__limit__38996AB5']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((1)) FOR [limite_sucursales]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='limite_sucursales']/Default[@Name='DF__SaaS_Gest__limit__38996AB5']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__limit__398D8EEE]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='limite_usuarios']/Default[@Name='DF__SaaS_Gest__limit__398D8EEE']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((5)) FOR [limite_usuarios]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='limite_usuarios']/Default[@Name='DF__SaaS_Gest__limit__398D8EEE']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__acces__3A81B327]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='acceso_iot']/Default[@Name='DF__SaaS_Gest__acces__3A81B327']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((0)) FOR [acceso_iot]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='acceso_iot']/Default[@Name='DF__SaaS_Gest__acces__3A81B327']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__activ__3B75D760]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='activo']/Default[@Name='DF__SaaS_Gest__activ__3B75D760']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((1)) FOR [activo]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='activo']/Default[@Name='DF__SaaS_Gest__activ__3B75D760']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__ciclo__625A9A57]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='ciclo_facturacion']/Default[@Name='DF__SaaS_Gest__ciclo__625A9A57']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((0)) FOR [ciclo_facturacion]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='ciclo_facturacion']/Default[@Name='DF__SaaS_Gest__ciclo__625A9A57']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__benef__634EBE90]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_camaleon']/Default[@Name='DF__SaaS_Gest__benef__634EBE90']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((0)) FOR [beneficio_camaleon]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_camaleon']/Default[@Name='DF__SaaS_Gest__benef__634EBE90']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__benef__6442E2C9]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_publicidad']/Default[@Name='DF__SaaS_Gest__benef__6442E2C9']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((0)) FOR [beneficio_publicidad]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_publicidad']/Default[@Name='DF__SaaS_Gest__benef__6442E2C9']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__benef__65370702]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_soporte_vip']/Default[@Name='DF__SaaS_Gest__benef__65370702']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((0)) FOR [beneficio_soporte_vip]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_soporte_vip']/Default[@Name='DF__SaaS_Gest__benef__65370702']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__benef__662B2B3B]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_analitica']/Default[@Name='DF__SaaS_Gest__benef__662B2B3B']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((0)) FOR [beneficio_analitica]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_analitica']/Default[@Name='DF__SaaS_Gest__benef__662B2B3B']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__benef__671F4F74]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_eventos']/Default[@Name='DF__SaaS_Gest__benef__671F4F74']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((0)) FOR [beneficio_eventos]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='beneficio_eventos']/Default[@Name='DF__SaaS_Gest__benef__671F4F74']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__desta__73852659]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='destacado']/Default[@Name='DF__SaaS_Gest__desta__73852659']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ((0)) FOR [destacado]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='destacado']/Default[@Name='DF__SaaS_Gest__desta__73852659']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__nivel__74794A92]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='nivel']/Default[@Name='DF__SaaS_Gest__nivel__74794A92']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Planes] ADD  DEFAULT ('BASICO') FOR [nivel]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Planes' and @Schema='dbo']/Column[@Name='nivel']/Default[@Name='DF__SaaS_Gest__nivel__74794A92']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__id_su__4316F928]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/Column[@Name='id_subsP']/Default[@Name='DF__SaaS_Gest__id_su__4316F928']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Suscripciones] ADD  DEFAULT (newid()) FOR [id_subsP]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/Column[@Name='id_subsP']/Default[@Name='DF__SaaS_Gest__id_su__4316F928']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__estad__45F365D3]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__SaaS_Gest__estad__45F365D3']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Suscripciones] ADD  DEFAULT ('ACTIVO') FOR [estado]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__SaaS_Gest__estad__45F365D3']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__SaaS_Gest__renov__46E78A0C]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/Column[@Name='renovacion_auto']/Default[@Name='DF__SaaS_Gest__renov__46E78A0C']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Suscripciones] ADD  DEFAULT ((1)) FOR [renovacion_auto]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/Column[@Name='renovacion_auto']/Default[@Name='DF__SaaS_Gest__renov__46E78A0C']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Seguridad__id_se__6FE99F9F]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Sesiones' and @Schema='dbo']/Column[@Name='id_sesiones']/Default[@Name='DF__Seguridad__id_se__6FE99F9F']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Sesiones] ADD  DEFAULT (newid()) FOR [id_sesiones]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Sesiones' and @Schema='dbo']/Column[@Name='id_sesiones']/Default[@Name='DF__Seguridad__id_se__6FE99F9F']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Seguridad__id_us__68487DD7]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/Column[@Name='id_usuario']/Default[@Name='DF__Seguridad__id_us__68487DD7']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Usuarios] ADD  DEFAULT (newid()) FOR [id_usuario]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/Column[@Name='id_usuario']/Default[@Name='DF__Seguridad__id_us__68487DD7']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Seguridad__estad__6D0D32F4]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Seguridad__estad__6D0D32F4']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Usuarios] ADD  DEFAULT ('ACTIVO') FOR [estado]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Seguridad__estad__6D0D32F4']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Seguridad__color__756D6ECB]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/Column[@Name='color_preferido']/Default[@Name='DF__Seguridad__color__756D6ECB']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Usuarios] ADD  DEFAULT ('0xFFFF6B00') FOR [color_preferido]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/Column[@Name='color_preferido']/Default[@Name='DF__Seguridad__color__756D6ECB']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Seguridad__color__76619304]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/Column[@Name='color_fondo_preferido']/Default[@Name='DF__Seguridad__color__76619304']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Usuarios] ADD  DEFAULT ('0xFF0B1121') FOR [color_fondo_preferido]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/Column[@Name='color_fondo_preferido']/Default[@Name='DF__Seguridad__color__76619304']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Cl__id_cl__5812160E]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/Column[@Name='id_cliente']/Default[@Name='DF__Ventas_Cl__id_cl__5812160E']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Clientes] ADD  DEFAULT (newid()) FOR [id_cliente]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/Column[@Name='id_cliente']/Default[@Name='DF__Ventas_Cl__id_cl__5812160E']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Cl__es_mi__5AEE82B9]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/Column[@Name='es_miembro_vip']/Default[@Name='DF__Ventas_Cl__es_mi__5AEE82B9']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Clientes] ADD  DEFAULT ((0)) FOR [es_miembro_vip]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/Column[@Name='es_miembro_vip']/Default[@Name='DF__Ventas_Cl__es_mi__5AEE82B9']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Cl__cread__5BE2A6F2]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/Column[@Name='creado_at']/Default[@Name='DF__Ventas_Cl__cread__5BE2A6F2']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Clientes] ADD  DEFAULT (sysdatetimeoffset()) FOR [creado_at]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/Column[@Name='creado_at']/Default[@Name='DF__Ventas_Cl__cread__5BE2A6F2']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_De__id_de__236943A5]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Detalle_Orden' and @Schema='dbo']/Column[@Name='id_detalleOrd']/Default[@Name='DF__Ventas_De__id_de__236943A5']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Detalle_Orden] ADD  DEFAULT (newid()) FOR [id_detalleOrd]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Detalle_Orden' and @Schema='dbo']/Column[@Name='id_detalleOrd']/Default[@Name='DF__Ventas_De__id_de__236943A5']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Li__prior__7A672E12]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Listas_Precios' and @Schema='dbo']/Column[@Name='prioridad']/Default[@Name='DF__Ventas_Li__prior__7A672E12']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Listas_Precios] ADD  DEFAULT ((0)) FOR [prioridad]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Listas_Precios' and @Schema='dbo']/Column[@Name='prioridad']/Default[@Name='DF__Ventas_Li__prior__7A672E12']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Li__activ__7B5B524B]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Listas_Precios' and @Schema='dbo']/Column[@Name='activa']/Default[@Name='DF__Ventas_Li__activ__7B5B524B']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Listas_Precios] ADD  DEFAULT ((1)) FOR [activa]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Listas_Precios' and @Schema='dbo']/Column[@Name='activa']/Default[@Name='DF__Ventas_Li__activ__7B5B524B']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Mo__fecha__0A9D95DB]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']/Column[@Name='fecha']/Default[@Name='DF__Ventas_Mo__fecha__0A9D95DB']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Movimientos_Stock] ADD  DEFAULT (sysdatetimeoffset()) FOR [fecha]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']/Column[@Name='fecha']/Default[@Name='DF__Ventas_Mo__fecha__0A9D95DB']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Or__id_or__18EBB532]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='id_ordenes']/Default[@Name='DF__Ventas_Or__id_or__18EBB532']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Ordenes] ADD  DEFAULT (newid()) FOR [id_ordenes]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='id_ordenes']/Default[@Name='DF__Ventas_Or__id_or__18EBB532']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Or__monto__1DB06A4F]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='monto_total']/Default[@Name='DF__Ventas_Or__monto__1DB06A4F']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Ordenes] ADD  DEFAULT ((0)) FOR [monto_total]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='monto_total']/Default[@Name='DF__Ventas_Or__monto__1DB06A4F']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Or__estad__1EA48E88]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Ventas_Or__estad__1EA48E88']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Ordenes] ADD  DEFAULT ('PENDIENTE') FOR [estado]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='estado']/Default[@Name='DF__Ventas_Or__estad__1EA48E88']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Or__es_fa__1F98B2C1]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='es_fallida']/Default[@Name='DF__Ventas_Or__es_fa__1F98B2C1']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Ordenes] ADD  DEFAULT ((0)) FOR [es_fallida]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='es_fallida']/Default[@Name='DF__Ventas_Or__es_fa__1F98B2C1']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Or__cread__208CD6FA]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='creado_at']/Default[@Name='DF__Ventas_Or__cread__208CD6FA']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Ordenes] ADD  DEFAULT (sysdatetimeoffset()) FOR [creado_at]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/Column[@Name='creado_at']/Default[@Name='DF__Ventas_Or__cread__208CD6FA']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Pr__moned__00200768]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Precios_Producto' and @Schema='dbo']/Column[@Name='moneda']/Default[@Name='DF__Ventas_Pr__moned__00200768']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Precios_Producto] ADD  DEFAULT ('PEN') FOR [moneda]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Precios_Producto' and @Schema='dbo']/Column[@Name='moneda']/Default[@Name='DF__Ventas_Pr__moned__00200768']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Pr__id_pr__73BA3083]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']/Column[@Name='id_producto']/Default[@Name='DF__Ventas_Pr__id_pr__73BA3083']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Productos] ADD  DEFAULT (newid()) FOR [id_producto]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']/Column[@Name='id_producto']/Default[@Name='DF__Ventas_Pr__id_pr__73BA3083']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Pr__es_in__75A278F5]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']/Column[@Name='es_inventariable']/Default[@Name='DF__Ventas_Pr__es_in__75A278F5']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Productos] ADD  DEFAULT ((1)) FOR [es_inventariable]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']/Column[@Name='es_inventariable']/Default[@Name='DF__Ventas_Pr__es_in__75A278F5']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_Pr__tiemp__76969D2E]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']/Column[@Name='tiempo_preparacion_estandar']/Default[@Name='DF__Ventas_Pr__tiemp__76969D2E']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Productos] ADD  DEFAULT ((15)) FOR [tiempo_preparacion_estandar]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']/Column[@Name='tiempo_preparacion_estandar']/Default[@Name='DF__Ventas_Pr__tiemp__76969D2E']","object_type":"Default"}},{"cell_type":"markdown","source":["# [DF__Ventas_St__stock__04E4BC85]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Stock' and @Schema='dbo']/Column[@Name='stock_minimo']/Default[@Name='DF__Ventas_St__stock__04E4BC85']","object_type":"Default"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Stock] ADD  DEFAULT ((0)) FOR [stock_minimo]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Stock' and @Schema='dbo']/Column[@Name='stock_minimo']/Default[@Name='DF__Ventas_St__stock__04E4BC85']","object_type":"Default"}},{"cell_type":"markdown","source":["# [FK__Auditoria__empre__3C34F16F]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Auditoria_Log_Acciones' and @Schema='dbo']/ForeignKey[@Name='FK__Auditoria__empre__3C34F16F']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Auditoria_Log_Acciones]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Auditoria_Log_Acciones' and @Schema='dbo']/ForeignKey[@Name='FK__Auditoria__empre__3C34F16F']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Auditoria__usuar__3D2915A8]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Auditoria_Log_Acciones' and @Schema='dbo']/ForeignKey[@Name='FK__Auditoria__usuar__3D2915A8']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Auditoria_Log_Acciones]  WITH CHECK ADD FOREIGN KEY([usuario_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Auditoria_Log_Acciones' and @Schema='dbo']/ForeignKey[@Name='FK__Auditoria__usuar__3D2915A8']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Comunicac__empre__41EDCAC5]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Comunicac__empre__41EDCAC5']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Comunicaciones_Notificaciones]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Comunicac__empre__41EDCAC5']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Comunicac__usuar__42E1EEFE]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Comunicac__usuar__42E1EEFE']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Comunicaciones_Notificaciones]  WITH CHECK ADD FOREIGN KEY([usuario_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Comunicaciones_Notificaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Comunicac__usuar__42E1EEFE']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__DataWareh__sucur__4E53A1AA]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Dim_Rendimiento_Personal' and @Schema='dbo']/ForeignKey[@Name='FK__DataWareh__sucur__4E53A1AA']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[DataWarehouse_Dim_Rendimiento_Personal]  WITH CHECK ADD FOREIGN KEY([sucursal_id])\r\nREFERENCES [dbo].[Nucleo_Sucursales] ([id_sucursal])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Dim_Rendimiento_Personal' and @Schema='dbo']/ForeignKey[@Name='FK__DataWareh__sucur__4E53A1AA']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__DataWareh__usuar__4D5F7D71]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Dim_Rendimiento_Personal' and @Schema='dbo']/ForeignKey[@Name='FK__DataWareh__usuar__4D5F7D71']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[DataWarehouse_Dim_Rendimiento_Personal]  WITH CHECK ADD FOREIGN KEY([usuario_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='DataWarehouse_Dim_Rendimiento_Personal' and @Schema='dbo']/ForeignKey[@Name='FK__DataWareh__usuar__4D5F7D71']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Fidelizac__empre__534D60F1]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Fidelizacion_Niveles' and @Schema='dbo']/ForeignKey[@Name='FK__Fidelizac__empre__534D60F1']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Fidelizacion_Niveles]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Fidelizacion_Niveles' and @Schema='dbo']/ForeignKey[@Name='FK__Fidelizac__empre__534D60F1']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__InternetC__recur__3587F3E0]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Dispositivos' and @Schema='dbo']/ForeignKey[@Name='FK__InternetC__recur__3587F3E0']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[InternetCosas_Dispositivos]  WITH CHECK ADD FOREIGN KEY([recurso_id])\r\nREFERENCES [dbo].[Nucleo_Recursos] ([id_recurso])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Dispositivos' and @Schema='dbo']/ForeignKey[@Name='FK__InternetC__recur__3587F3E0']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__InternetC__dispo__3864608B]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Eventos' and @Schema='dbo']/ForeignKey[@Name='FK__InternetC__dispo__3864608B']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[InternetCosas_Eventos]  WITH CHECK ADD FOREIGN KEY([dispositivo_id])\r\nREFERENCES [dbo].[InternetCosas_Dispositivos] ([mac])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='InternetCosas_Eventos' and @Schema='dbo']/ForeignKey[@Name='FK__InternetC__dispo__3864608B']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Nucleo_Re__sucur__0E6E26BF]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Recursos' and @Schema='dbo']/ForeignKey[@Name='FK__Nucleo_Re__sucur__0E6E26BF']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Recursos]  WITH CHECK ADD FOREIGN KEY([sucursal_id])\r\nREFERENCES [dbo].[Nucleo_Sucursales] ([id_sucursal])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Recursos' and @Schema='dbo']/ForeignKey[@Name='FK__Nucleo_Re__sucur__0E6E26BF']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Nucleo_Su__empre__4F7CD00D]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']/ForeignKey[@Name='FK__Nucleo_Su__empre__4F7CD00D']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Sucursales]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']/ForeignKey[@Name='FK__Nucleo_Su__empre__4F7CD00D']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK_Sucursal_Gerente]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']/ForeignKey[@Name='FK_Sucursal_Gerente']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Nucleo_Sucursales]  WITH CHECK ADD  CONSTRAINT [FK_Sucursal_Gerente] FOREIGN KEY([gerente_encargado_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n","ALTER TABLE [dbo].[Nucleo_Sucursales] CHECK CONSTRAINT [FK_Sucursal_Gerente]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Nucleo_Sucursales' and @Schema='dbo']/ForeignKey[@Name='FK_Sucursal_Gerente']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Pagos_Caj__sucur__29221CFB]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/ForeignKey[@Name='FK__Pagos_Caj__sucur__29221CFB']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Pagos_Cajas_Diarias]  WITH CHECK ADD FOREIGN KEY([sucursal_id])\r\nREFERENCES [dbo].[Nucleo_Sucursales] ([id_sucursal])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/ForeignKey[@Name='FK__Pagos_Caj__sucur__29221CFB']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Pagos_Caj__usuar__2A164134]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/ForeignKey[@Name='FK__Pagos_Caj__usuar__2A164134']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Pagos_Cajas_Diarias]  WITH CHECK ADD FOREIGN KEY([usuario_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Cajas_Diarias' and @Schema='dbo']/ForeignKey[@Name='FK__Pagos_Caj__usuar__2A164134']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Pagos_Ing__caja___31B762FC]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Ingresos' and @Schema='dbo']/ForeignKey[@Name='FK__Pagos_Ing__caja___31B762FC']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Pagos_Ingresos]  WITH CHECK ADD FOREIGN KEY([caja_diaria_id])\r\nREFERENCES [dbo].[Pagos_Cajas_Diarias] ([id_cajaDi])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Ingresos' and @Schema='dbo']/ForeignKey[@Name='FK__Pagos_Ing__caja___31B762FC']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Pagos_Ing__orden__30C33EC3]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Ingresos' and @Schema='dbo']/ForeignKey[@Name='FK__Pagos_Ing__orden__30C33EC3']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Pagos_Ingresos]  WITH CHECK ADD FOREIGN KEY([orden_id])\r\nREFERENCES [dbo].[Ventas_Ordenes] ([id_ordenes])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Pagos_Ingresos' and @Schema='dbo']/ForeignKey[@Name='FK__Pagos_Ing__orden__30C33EC3']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Reservas___clien__14270015]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Reservas___clien__14270015']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Reservas_Reservaciones]  WITH CHECK ADD FOREIGN KEY([cliente_id])\r\nREFERENCES [dbo].[Ventas_Clientes] ([id_cliente])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Reservas___clien__14270015']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Reservas___empre__1332DBDC]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Reservas___empre__1332DBDC']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Reservas_Reservaciones]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Reservas___empre__1332DBDC']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Reservas___recur__151B244E]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Reservas___recur__151B244E']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Reservas_Reservaciones]  WITH CHECK ADD FOREIGN KEY([recurso_id])\r\nREFERENCES [dbo].[Nucleo_Recursos] ([id_recurso])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Reservas_Reservaciones' and @Schema='dbo']/ForeignKey[@Name='FK__Reservas___recur__151B244E']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK_EmpresaFeatures_Empresa]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Empresa_CaracteristicaPl' and @Schema='dbo']/ForeignKey[@Name='FK_EmpresaFeatures_Empresa']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Empresa_CaracteristicaPl]  WITH CHECK ADD  CONSTRAINT [FK_EmpresaFeatures_Empresa] FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n","ALTER TABLE [dbo].[SaaS_Gestion_Empresa_CaracteristicaPl] CHECK CONSTRAINT [FK_EmpresaFeatures_Empresa]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Empresa_CaracteristicaPl' and @Schema='dbo']/ForeignKey[@Name='FK_EmpresaFeatures_Empresa']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK_EmpresaFeatures_Feature]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Empresa_CaracteristicaPl' and @Schema='dbo']/ForeignKey[@Name='FK_EmpresaFeatures_Feature']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Empresa_CaracteristicaPl]  WITH CHECK ADD  CONSTRAINT [FK_EmpresaFeatures_Feature] FOREIGN KEY([feature_id])\r\nREFERENCES [dbo].[SaaS_Gestion_CaracteristicasPlan] ([id_ContiPlan])\r\n","GO\r\n","ALTER TABLE [dbo].[SaaS_Gestion_Empresa_CaracteristicaPl] CHECK CONSTRAINT [FK_EmpresaFeatures_Feature]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Empresa_CaracteristicaPl' and @Schema='dbo']/ForeignKey[@Name='FK_EmpresaFeatures_Feature']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__SaaS_Gest__suscr__4AB81AF0]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Facturacion_Servicio' and @Schema='dbo']/ForeignKey[@Name='FK__SaaS_Gest__suscr__4AB81AF0']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Facturacion_Servicio]  WITH CHECK ADD FOREIGN KEY([suscripcion_id])\r\nREFERENCES [dbo].[SaaS_Gestion_Suscripciones] ([id_subsP])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Facturacion_Servicio' and @Schema='dbo']/ForeignKey[@Name='FK__SaaS_Gest__suscr__4AB81AF0']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK_ContenidoPlan_CaracteristicasPlan]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Plan_ContenidoPlan' and @Schema='dbo']/ForeignKey[@Name='FK_ContenidoPlan_CaracteristicasPlan']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Plan_ContenidoPlan]  WITH CHECK ADD  CONSTRAINT [FK_ContenidoPlan_CaracteristicasPlan] FOREIGN KEY([id_CaracteristicasPlan])\r\nREFERENCES [dbo].[SaaS_Gestion_CaracteristicasPlan] ([id_ContiPlan])\r\n","GO\r\n","ALTER TABLE [dbo].[SaaS_Gestion_Plan_ContenidoPlan] CHECK CONSTRAINT [FK_ContenidoPlan_CaracteristicasPlan]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Plan_ContenidoPlan' and @Schema='dbo']/ForeignKey[@Name='FK_ContenidoPlan_CaracteristicasPlan']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK_ContenidoPlan_Plan]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Plan_ContenidoPlan' and @Schema='dbo']/ForeignKey[@Name='FK_ContenidoPlan_Plan']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Plan_ContenidoPlan]  WITH CHECK ADD  CONSTRAINT [FK_ContenidoPlan_Plan] FOREIGN KEY([id_plan])\r\nREFERENCES [dbo].[SaaS_Gestion_Planes] ([plan_id])\r\n","GO\r\n","ALTER TABLE [dbo].[SaaS_Gestion_Plan_ContenidoPlan] CHECK CONSTRAINT [FK_ContenidoPlan_Plan]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Plan_ContenidoPlan' and @Schema='dbo']/ForeignKey[@Name='FK_ContenidoPlan_Plan']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__SaaS_Gest__empre__440B1D61]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/ForeignKey[@Name='FK__SaaS_Gest__empre__440B1D61']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Suscripciones]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/ForeignKey[@Name='FK__SaaS_Gest__empre__440B1D61']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__SaaS_Gest__plan___44FF419A]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/ForeignKey[@Name='FK__SaaS_Gest__plan___44FF419A']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[SaaS_Gestion_Suscripciones]  WITH CHECK ADD FOREIGN KEY([plan_id])\r\nREFERENCES [dbo].[SaaS_Gestion_Planes] ([plan_id])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='SaaS_Gestion_Suscripciones' and @Schema='dbo']/ForeignKey[@Name='FK__SaaS_Gest__plan___44FF419A']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Seguridad__perfi__6477ECF3]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfil_Permisos' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__perfi__6477ECF3']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Perfil_Permisos]  WITH CHECK ADD FOREIGN KEY([perfil_id])\r\nREFERENCES [dbo].[Seguridad_Perfiles] ([id_perfil])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfil_Permisos' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__perfi__6477ECF3']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Seguridad__permi__656C112C]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfil_Permisos' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__permi__656C112C']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Perfil_Permisos]  WITH CHECK ADD FOREIGN KEY([permiso_id])\r\nREFERENCES [dbo].[Seguridad_Permisos_Sistema] ([id_secur_perf])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfil_Permisos' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__permi__656C112C']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Seguridad__empre__5EBF139D]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfiles' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__empre__5EBF139D']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Perfiles]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Perfiles' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__empre__5EBF139D']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Seguridad__usuar__70DDC3D8]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Sesiones' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__usuar__70DDC3D8']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Sesiones]  WITH CHECK ADD FOREIGN KEY([usuario_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Sesiones' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__usuar__70DDC3D8']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Seguridad__empre__693CA210]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__empre__693CA210']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Usuarios]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__empre__693CA210']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Seguridad__perfi__6B24EA82]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__perfi__6B24EA82']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Usuarios]  WITH CHECK ADD FOREIGN KEY([perfil_id])\r\nREFERENCES [dbo].[Seguridad_Perfiles] ([id_perfil])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__perfi__6B24EA82']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Seguridad__repor__6C190EBB]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__repor__6C190EBB']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Usuarios]  WITH CHECK ADD FOREIGN KEY([reporte_a_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__repor__6C190EBB']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Seguridad__sucur__6A30C649]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__sucur__6A30C649']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Seguridad_Usuarios]  WITH CHECK ADD FOREIGN KEY([sucursal_asignada_id])\r\nREFERENCES [dbo].[Nucleo_Sucursales] ([id_sucursal])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Seguridad_Usuarios' and @Schema='dbo']/ForeignKey[@Name='FK__Seguridad__sucur__6A30C649']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Cl__empre__59063A47]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Cl__empre__59063A47']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Clientes]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Cl__empre__59063A47']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Cl__nivel__59FA5E80]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Cl__nivel__59FA5E80']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Clientes]  WITH CHECK ADD FOREIGN KEY([nivel_fidelizacion_id])\r\nREFERENCES [dbo].[Fidelizacion_Niveles] ([id_fidel])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Clientes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Cl__nivel__59FA5E80']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_De__orden__245D67DE]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Detalle_Orden' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_De__orden__245D67DE']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Detalle_Orden]  WITH CHECK ADD FOREIGN KEY([orden_id])\r\nREFERENCES [dbo].[Ventas_Ordenes] ([id_ordenes])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Detalle_Orden' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_De__orden__245D67DE']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_De__produ__25518C17]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Detalle_Orden' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_De__produ__25518C17']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Detalle_Orden]  WITH CHECK ADD FOREIGN KEY([producto_id])\r\nREFERENCES [dbo].[Ventas_Productos] ([id_producto])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Detalle_Orden' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_De__produ__25518C17']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Li__sucur__797309D9]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Listas_Precios' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Li__sucur__797309D9']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Listas_Precios]  WITH CHECK ADD FOREIGN KEY([sucursal_id])\r\nREFERENCES [dbo].[Nucleo_Sucursales] ([id_sucursal])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Listas_Precios' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Li__sucur__797309D9']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Mo__produ__07C12930]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Mo__produ__07C12930']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Movimientos_Stock]  WITH CHECK ADD FOREIGN KEY([producto_id])\r\nREFERENCES [dbo].[Ventas_Productos] ([id_producto])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Mo__produ__07C12930']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Mo__sucur__08B54D69]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Mo__sucur__08B54D69']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Movimientos_Stock]  WITH CHECK ADD FOREIGN KEY([sucursal_id])\r\nREFERENCES [dbo].[Nucleo_Sucursales] ([id_sucursal])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Mo__sucur__08B54D69']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Mo__usuar__09A971A2]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Mo__usuar__09A971A2']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Movimientos_Stock]  WITH CHECK ADD FOREIGN KEY([usuario_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Movimientos_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Mo__usuar__09A971A2']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Or__clien__1CBC4616]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Or__clien__1CBC4616']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Ordenes]  WITH CHECK ADD FOREIGN KEY([cliente_id])\r\nREFERENCES [dbo].[Ventas_Clientes] ([id_cliente])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Or__clien__1CBC4616']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Or__cocin__1BC821DD]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Or__cocin__1BC821DD']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Ordenes]  WITH CHECK ADD FOREIGN KEY([cocinero_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Or__cocin__1BC821DD']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Or__sucur__19DFD96B]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Or__sucur__19DFD96B']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Ordenes]  WITH CHECK ADD FOREIGN KEY([sucursal_id])\r\nREFERENCES [dbo].[Nucleo_Sucursales] ([id_sucursal])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Or__sucur__19DFD96B']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Or__usuar__1AD3FDA4]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Or__usuar__1AD3FDA4']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Ordenes]  WITH CHECK ADD FOREIGN KEY([usuario_id])\r\nREFERENCES [dbo].[Seguridad_Usuarios] ([id_usuario])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Ordenes' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Or__usuar__1AD3FDA4']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Pr__id_pr__7E37BEF6]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Precios_Producto' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Pr__id_pr__7E37BEF6']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Precios_Producto]  WITH CHECK ADD FOREIGN KEY([id_precios])\r\nREFERENCES [dbo].[Ventas_Listas_Precios] ([id_lista])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Precios_Producto' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Pr__id_pr__7E37BEF6']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Pr__produ__7F2BE32F]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Precios_Producto' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Pr__produ__7F2BE32F']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Precios_Producto]  WITH CHECK ADD FOREIGN KEY([producto_id])\r\nREFERENCES [dbo].[Ventas_Productos] ([id_producto])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Precios_Producto' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Pr__produ__7F2BE32F']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_Pr__empre__74AE54BC]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Pr__empre__74AE54BC']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Productos]  WITH CHECK ADD FOREIGN KEY([empresa_id])\r\nREFERENCES [dbo].[Nucleo_Empresas] ([id_empresa])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Productos' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_Pr__empre__74AE54BC']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_St__produ__02FC7413]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_St__produ__02FC7413']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Stock]  WITH CHECK ADD FOREIGN KEY([producto_id])\r\nREFERENCES [dbo].[Ventas_Productos] ([id_producto])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_St__produ__02FC7413']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [FK__Ventas_St__sucur__03F0984C]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_St__sucur__03F0984C']","object_type":"ForeignKey"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER TABLE [dbo].[Ventas_Stock]  WITH CHECK ADD FOREIGN KEY([sucursal_id])\r\nREFERENCES [dbo].[Nucleo_Sucursales] ([id_sucursal])\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/Table[@Name='Ventas_Stock' and @Schema='dbo']/ForeignKey[@Name='FK__Ventas_St__sucur__03F0984C']","object_type":"ForeignKey"}},{"cell_type":"markdown","source":["# [dbo].[DataWarehouse_ETL_Ventas_Diarias]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/StoredProcedure[@Name='DataWarehouse_ETL_Ventas_Diarias' and @Schema='dbo']","object_type":"StoredProcedure"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["/****** Object:  StoredProcedure [dbo].[DataWarehouse_ETL_Ventas_Diarias]    Script Date: 24/01/2026 9:37:13 ******/\r\nSET ANSI_NULLS ON\r\n","GO\r\n","SET QUOTED_IDENTIFIER ON\r\n","GO\r\n","\r\nCREATE   PROCEDURE [dbo].[DataWarehouse_ETL_Ventas_Diarias]\r\nAS\r\nBEGIN\r\n    SET NOCOUNT ON;\r\n\r\n    MERGE DataWarehouse_Fact_Ventas_Historico AS Target\r\n    USING (\r\n        SELECT \r\n            CAST(O.creado_at AS DATE) AS fecha,\r\n            S.nombre AS sucursal_nombre,\r\n            P.nombre AS producto_nombre,\r\n            P.categoria,\r\n            SUM(D.cantidad) AS cantidad,\r\n            SUM(D.subtotal) AS total,\r\n            MONTH(O.creado_at) AS mes,\r\n            YEAR(O.creado_at) AS anio\r\n        FROM Ventas_Ordenes O\r\n        JOIN Ventas_Detalle_Orden D ON O.id_ordenes = D.orden_id\r\n        JOIN Ventas_Productos P ON D.producto_id = P.id_producto\r\n        JOIN Nucleo_Sucursales S ON O.sucursal_id = S.id_sucursal\r\n        WHERE O.estado = 'PAGADO'\r\n        GROUP BY \r\n            CAST(O.creado_at AS DATE),\r\n            S.nombre,\r\n            P.nombre,\r\n            P.categoria,\r\n            MONTH(O.creado_at),\r\n            YEAR(O.creado_at)\r\n    ) AS Source\r\n    ON (\r\n        Target.fecha_venta = Source.fecha\r\n        AND Target.producto_nombre = Source.producto_nombre\r\n        AND Target.sucursal_nombre = Source.sucursal_nombre\r\n    )\r\n\r\n    WHEN MATCHED THEN\r\n        UPDATE SET \r\n            Target.cantidad_vendida = Source.cantidad,\r\n            Target.total_ganado = Source.total,\r\n            Target.mes = Source.mes,\r\n            Target.anio = Source.anio\r\n\r\n    WHEN NOT MATCHED THEN\r\n        INSERT (\r\n            fecha_venta,\r\n            sucursal_nombre,\r\n            producto_nombre,\r\n            categoria,\r\n            cantidad_vendida,\r\n            total_ganado,\r\n            mes,\r\n            anio\r\n        )\r\n        VALUES (\r\n            Source.fecha,\r\n            Source.sucursal_nombre,\r\n            Source.producto_nombre,\r\n            Source.categoria,\r\n            Source.cantidad,\r\n            Source.total,\r\n            Source.mes,\r\n            Source.anio\r\n        );\r\nEND;\r\nGO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']/StoredProcedure[@Name='DataWarehouse_ETL_Ventas_Diarias' and @Schema='dbo']","object_type":"StoredProcedure"}},{"cell_type":"markdown","source":["# [BD_PITER_PRO_UPDATE_V4]"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']","object_type":"Database"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["USE [master]\r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']","object_type":"Database"}},{"outputs":[],"execution_count":0,"cell_type":"code","source":["ALTER DATABASE [BD_PITER_PRO_UPDATE_V4] SET  READ_WRITE \r\n","GO\r\n"],"metadata":{"urn":"Server[@Name='WIN-67BSNFJHBKB']/Database[@Name='BD_PITER_PRO_UPDATE_V4']","object_type":"Database"}}]}