195 lines
7.6 KiB
C#
195 lines
7.6 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using Microsoft.EntityFrameworkCore;
|
||
using Pomelo.EntityFrameworkCore.MySql.Scaffolding.Internal;
|
||
|
||
namespace WinFormsApp6.Models;
|
||
|
||
public partial class Ispr2624NesterovEdHospitalContext : DbContext
|
||
{
|
||
public Ispr2624NesterovEdHospitalContext()
|
||
{
|
||
}
|
||
|
||
public Ispr2624NesterovEdHospitalContext(DbContextOptions<Ispr2624NesterovEdHospitalContext> options)
|
||
: base(options)
|
||
{
|
||
}
|
||
|
||
public virtual DbSet<Chamber> Chambers { get; set; }
|
||
|
||
public virtual DbSet<Diagnosis> Diagnoses { get; set; }
|
||
|
||
public virtual DbSet<Doctor> Doctors { get; set; }
|
||
|
||
public virtual DbSet<Medicine> Medicines { get; set; }
|
||
|
||
public virtual DbSet<Nurse> Nurses { get; set; }
|
||
|
||
public virtual DbSet<Pacient> Pacients { get; set; }
|
||
|
||
public virtual DbSet<Procedure> Procedures { get; set; }
|
||
|
||
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
|
||
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see https://go.microsoft.com/fwlink/?LinkId=723263.
|
||
=> optionsBuilder.UseMySql("server=cfif31.ru;database=ISPr26-24_NesterovED_hospital;uid=ISPr26-24_NesterovED;pwd=ISPr26-24_NesterovED", Microsoft.EntityFrameworkCore.ServerVersion.Parse("8.0.41-mysql"));
|
||
|
||
protected override void OnModelCreating(ModelBuilder modelBuilder)
|
||
{
|
||
modelBuilder
|
||
.UseCollation("utf8mb4_0900_ai_ci")
|
||
.HasCharSet("utf8mb4");
|
||
|
||
modelBuilder.Entity<Chamber>(entity =>
|
||
{
|
||
entity.HasKey(e => e.Idchambers).HasName("PRIMARY");
|
||
|
||
entity.ToTable("chambers");
|
||
|
||
entity.Property(e => e.Idchambers)
|
||
.ValueGeneratedNever()
|
||
.HasColumnName("idchambers");
|
||
entity.Property(e => e.КолВоМест).HasColumnName("Кол-во мест");
|
||
});
|
||
|
||
modelBuilder.Entity<Diagnosis>(entity =>
|
||
{
|
||
entity.HasKey(e => e.Iddiagnoses).HasName("PRIMARY");
|
||
|
||
entity.ToTable("diagnoses");
|
||
|
||
entity.Property(e => e.Iddiagnoses)
|
||
.ValueGeneratedNever()
|
||
.HasColumnName("iddiagnoses");
|
||
entity.Property(e => e.Название).HasMaxLength(100);
|
||
entity.Property(e => e.Описание).HasColumnType("text");
|
||
});
|
||
|
||
modelBuilder.Entity<Doctor>(entity =>
|
||
{
|
||
entity.HasKey(e => e.Iddoctors).HasName("PRIMARY");
|
||
|
||
entity.ToTable("doctors");
|
||
|
||
entity.Property(e => e.Iddoctors)
|
||
.ValueGeneratedNever()
|
||
.HasColumnName("iddoctors");
|
||
entity.Property(e => e.Специализация).HasMaxLength(50);
|
||
entity.Property(e => e.Телефон).HasMaxLength(15);
|
||
entity.Property(e => e.Фио)
|
||
.HasMaxLength(100)
|
||
.HasColumnName("ФИО");
|
||
});
|
||
|
||
modelBuilder.Entity<Medicine>(entity =>
|
||
{
|
||
entity.HasKey(e => e.Idmedicine).HasName("PRIMARY");
|
||
|
||
entity.ToTable("medicine");
|
||
|
||
entity.Property(e => e.Idmedicine)
|
||
.ValueGeneratedNever()
|
||
.HasColumnName("idmedicine");
|
||
entity.Property(e => e.Название).HasMaxLength(100);
|
||
entity.Property(e => e.Производитель).HasMaxLength(100);
|
||
entity.Property(e => e.Цена).HasPrecision(10, 2);
|
||
});
|
||
|
||
modelBuilder.Entity<Nurse>(entity =>
|
||
{
|
||
entity.HasKey(e => e.Idnurses).HasName("PRIMARY");
|
||
|
||
entity.ToTable("nurses");
|
||
|
||
entity.Property(e => e.Idnurses)
|
||
.ValueGeneratedNever()
|
||
.HasColumnName("idnurses");
|
||
entity.Property(e => e.Отделение).HasMaxLength(50);
|
||
entity.Property(e => e.Телефон).HasMaxLength(15);
|
||
entity.Property(e => e.Фио)
|
||
.HasMaxLength(100)
|
||
.HasColumnName("ФИО");
|
||
});
|
||
|
||
modelBuilder.Entity<Pacient>(entity =>
|
||
{
|
||
entity.HasKey(e => e.IdPacient).HasName("PRIMARY");
|
||
|
||
entity.ToTable("Pacient");
|
||
|
||
entity.HasIndex(e => e.Idchambers, "fk_idPacient_chambers_idx");
|
||
|
||
entity.HasIndex(e => e.Iddiagnoses, "fk_idPacient_diagnoses_idx");
|
||
|
||
entity.HasIndex(e => e.Iddoctors, "fk_idPacient_doctors_idx");
|
||
|
||
entity.HasIndex(e => e.Idmedicine, "fk_idPacient_medicine_idx");
|
||
|
||
entity.HasIndex(e => e.Idnurses, "fk_idPacient_nurses_idx");
|
||
|
||
entity.HasIndex(e => e.Idprocedures, "fk_idPacient_procedures_idx");
|
||
|
||
entity.Property(e => e.IdPacient)
|
||
.ValueGeneratedNever()
|
||
.HasColumnName("idPacient");
|
||
entity.Property(e => e.Idchambers).HasColumnName("idchambers");
|
||
entity.Property(e => e.Iddiagnoses).HasColumnName("iddiagnoses");
|
||
entity.Property(e => e.Iddoctors).HasColumnName("iddoctors");
|
||
entity.Property(e => e.Idmedicine).HasColumnName("idmedicine");
|
||
entity.Property(e => e.Idnurses).HasColumnName("idnurses");
|
||
entity.Property(e => e.Idprocedures).HasColumnName("idprocedures");
|
||
entity.Property(e => e.Адрес).HasMaxLength(255);
|
||
entity.Property(e => e.ДатаРождения).HasColumnName("Дата_рождения");
|
||
entity.Property(e => e.Пол)
|
||
.HasMaxLength(1)
|
||
.IsFixedLength();
|
||
entity.Property(e => e.Телефон).HasMaxLength(15);
|
||
entity.Property(e => e.Фио)
|
||
.HasMaxLength(100)
|
||
.HasColumnName("ФИО");
|
||
|
||
entity.HasOne(d => d.IdchambersNavigation).WithMany(p => p.Pacients)
|
||
.HasForeignKey(d => d.Idchambers)
|
||
.HasConstraintName("fk_idPacient_chambers");
|
||
|
||
entity.HasOne(d => d.IddiagnosesNavigation).WithMany(p => p.Pacients)
|
||
.HasForeignKey(d => d.Iddiagnoses)
|
||
.HasConstraintName("fk_idPacient_diagnoses");
|
||
|
||
entity.HasOne(d => d.IddoctorsNavigation).WithMany(p => p.Pacients)
|
||
.HasForeignKey(d => d.Iddoctors)
|
||
.HasConstraintName("fk_idPacient_doctors");
|
||
|
||
entity.HasOne(d => d.IdmedicineNavigation).WithMany(p => p.Pacients)
|
||
.HasForeignKey(d => d.Idmedicine)
|
||
.HasConstraintName("fk_idPacient_medicine");
|
||
|
||
entity.HasOne(d => d.IdnursesNavigation).WithMany(p => p.Pacients)
|
||
.HasForeignKey(d => d.Idnurses)
|
||
.HasConstraintName("fk_idPacient_nurses");
|
||
|
||
entity.HasOne(d => d.IdproceduresNavigation).WithMany(p => p.Pacients)
|
||
.HasForeignKey(d => d.Idprocedures)
|
||
.HasConstraintName("fk_idPacient_procedures");
|
||
});
|
||
|
||
modelBuilder.Entity<Procedure>(entity =>
|
||
{
|
||
entity.HasKey(e => e.Idprocedures).HasName("PRIMARY");
|
||
|
||
entity.ToTable("procedures");
|
||
|
||
entity.Property(e => e.Idprocedures)
|
||
.ValueGeneratedNever()
|
||
.HasColumnName("idprocedures");
|
||
entity.Property(e => e.Название).HasMaxLength(100);
|
||
entity.Property(e => e.Описание).HasColumnType("text");
|
||
entity.Property(e => e.Цена).HasPrecision(10, 2);
|
||
});
|
||
|
||
OnModelCreatingPartial(modelBuilder);
|
||
}
|
||
|
||
partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
|
||
}
|