Summary
Keywords
Full Transcript
📌 En este tercer video del curso de Desarrollo Web con .NET y Angular, aprenderás cómo crear la base de datos para nuestra aplicación web. Usaremos SQL Server como gestor de base de datos y crearemos las tablas necesarias para almacenar la información de nuestra aplicación. Además, te enseñaremos cómo establecer relaciones entre tablas y cómo definir las restricciones de integridad para garantizar la consistencia de la información. ¡No te pierdas esta lección clave para el desarrollo de aplicaciones web con .NET y Angular! 👀Mira también: ✅ Creación de un Proyecto Angular:Aprende a Estructurar tus Carpetas y Crear Módulos y Componentes 👉 https://www.youtube.com/watch?v=qC1zMJCqWFs&t=84s ✅ Conectando Angular con el Backend: Implementando servicios y consumiendo datos con Observables 👉 https://www.youtube.com/watch?v=nU6ik66uN5E ✅ Programando el módulo de Médicos en Angular. Listado paginado 👉 https://www.youtube.com/watch?v=JY6br4griUI&t=178s ✅ Creación de la Solución en .NET y Organización de la Arquitectura de Software 👉 https://www.youtube.com/watch?v=-U7ZWwOQ8w8&t=6s ✅ Implementando Clases de Acceso a Datos con Entity Framework 👉 https://www.youtube.com/watch?v=4-rD3Ic7YwM&t=2s ✅ Creación de un Controlador Web API para un CRUD en .NET 👉 https://www.youtube.com/watch?v=g1VZJFiNdQg #angular #dotnet #cursoangular #cursodotnet #programacionweb #backend #framework #CSharp #sqlserver #software #SinMiedoALaProgramacion ============ SCRIPT PARA CREAR LAS TABLAS DE LA BASE DE DATOS ============ CREATE TABLE [dbo].[Egreso]( [id] [bigint] IDENTITY(1,1) NOT NULL, [fecha] [datetime] NOT NULL, [tratamiento] [varchar](max) NULL, [monto] [decimal](18, 2) NOT NULL, [borrado] [bit] NOT NULL, [medicoId] [bigint] NOT NULL, [ingresoId] [bigint] NOT NULL, CONSTRAINT [PK_Egreso] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Ingreso]( [id] [bigint] IDENTITY(1,1) NOT NULL, [fecha] [datetime] NOT NULL, [numeroSala] [int] NOT NULL, [numeroCama] [int] NOT NULL, [diagnostico] [varchar](max) NOT NULL, [observacion] [varchar](max) NULL, [borrado] [bit] NOT NULL, [medicoId] [bigint] NOT NULL, [pacienteId] [bigint] NOT NULL, CONSTRAINT [PK_Ingreso] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Medico]( [id] [bigint] IDENTITY(1,1) NOT NULL, [cedula] [varchar](10) NOT NULL, [nombre] [varchar](50) NOT NULL, [apellidoPaterno] [varchar](50) NOT NULL, [apellidoMaterno] [varchar](50) NULL, [esEspecialista] [bit] NOT NULL, [habilitado] [bit] NOT NULL, [borrado] [bit] NOT NULL, CONSTRAINT [PK_Medico] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[Paciente]( [id] [bigint] IDENTITY(1,1) NOT NULL, [cedula] [varchar](10) NOT NULL, [nombre] [varchar](50) NOT NULL, [apellidoPaterno] [varchar](50) NOT NULL, [apellidoMaterno] [varchar](50) NULL, [direccion] [varchar](500) NOT NULL, [celular] [varchar](10) NOT NULL, [correoElectronico] [varchar](50) NOT NULL, [borrado] [bit] NOT NULL, CONSTRAINT [PK_Paciente] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Egreso] ADD CONSTRAINT [DF_Egreso_borrado] DEFAULT ((0)) FOR [borrado] GO ALTER TABLE [dbo].[Ingreso] ADD CONSTRAINT [DF_Ingreso_borrado] DEFAULT ((0)) FOR [borrado] GO ALTER TABLE [dbo].[Medico] ADD CONSTRAINT [DF_Medico_habilitado] DEFAULT ((1)) FOR [habilitado] GO ALTER TABLE [dbo].[Medico] ADD CONSTRAINT [DF_Medico_borrado] DEFAULT ((0)) FOR [borrado] GO ALTER TABLE [dbo].[Paciente] ADD CONSTRAINT [DF_Paciente_borrado] DEFAULT ((0)) FOR [borrado] GO ALTER TABLE [dbo].[Egreso] WITH CHECK ADD CONSTRAINT [FK_Egreso_Ingreso] FOREIGN KEY([ingresoId]) REFERENCES [dbo].[Ingreso] ([id]) GO ALTER TABLE [dbo].[Egreso] CHECK CONSTRAINT [FK_Egreso_Ingreso] GO ALTER TABLE [dbo].[Egreso] WITH CHECK ADD CONSTRAINT [FK_Egreso_Medico] FOREIGN KEY([medicoId]) REFERENCES [dbo].[Medico] ([id]) GO ALTER TABLE [dbo].[Egreso] CHECK CONSTRAINT [FK_Egreso_Medico] GO ALTER TABLE [dbo].[Ingreso] WITH CHECK ADD CONSTRAINT [FK_Ingreso_Medico] FOREIGN KEY([medicoId]) REFERENCES [dbo].[Medico] ([id]) GO ALTER TABLE [dbo].[Ingreso] CHECK CONSTRAINT [FK_Ingreso_Medico] GO ALTER TABLE [dbo].[Ingreso] WITH CHECK ADD CONSTRAINT [FK_Ingreso_Paciente] FOREIGN KEY([pacienteId]) REFERENCES [dbo].[Paciente] ([id]) GO ALTER TABLE [dbo].[Ingreso] CHECK CONSTRAINT [FK_Ingreso_Paciente] GO
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
