// using System; using MagMan.Data.Tenant; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace MagMan.Data.Tenant.Migrations { [DbContext(typeof(MagManContext))] partial class MagManContextModelSnapshot : ModelSnapshot { protected override void BuildModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "6.0.28") .HasAnnotation("Relational:MaxIdentifierLength", 64); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.AliasModel", b => { b.Property("Family") .HasColumnType("varchar(255)"); b.Property("ValueOriginal") .HasColumnType("varchar(255)"); b.Property("IsActive") .HasColumnType("tinyint(1)"); b.Property("ValueAlias") .IsRequired() .HasColumnType("longtext"); b.HasKey("Family", "ValueOriginal"); b.ToTable("AliasList"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.ConfigModel", b => { b.Property("KeyName") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasColumnOrder(0); b.Property("Note") .IsRequired() .HasMaxLength(250) .HasColumnType("varchar(250)") .HasColumnOrder(3); b.Property("Val") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasColumnOrder(1); b.Property("ValStd") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasColumnOrder(2) .HasComment("Valore di default/riferimento per la variabile"); b.HasKey("KeyName"); b.ToTable("Config"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.DayStatModel", b => { b.Property("DayId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("DayId"); b.Property("DtRif") .HasColumnType("datetime(6)"); b.Property("MachineID") .HasColumnType("int"); b.Property("OreDis") .HasColumnType("double"); b.Property("OreLav") .HasColumnType("double"); b.HasKey("DayId"); b.ToTable("DayStat"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.EventModel", b => { b.Property("IdxEv") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("Azione") .IsRequired() .HasColumnType("longtext"); b.Property("CssClass") .IsRequired() .HasColumnType("longtext"); b.Property("EventoTablet") .HasColumnType("tinyint(1)"); b.Property("Icon") .IsRequired() .HasColumnType("longtext"); b.Property("KeyEvento") .IsRequired() .HasColumnType("longtext"); b.Property("Nome") .IsRequired() .HasColumnType("longtext"); b.Property("NoteEvento") .IsRequired() .HasColumnType("longtext"); b.Property("TabAzione") .IsRequired() .HasColumnType("longtext"); b.HasKey("IdxEv"); b.ToTable("AnagEventi"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.LogMachineModel", b => { b.Property("LogDbId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("DbId"); b.Property("DtEvent") .HasColumnType("datetime(6)") .HasColumnName("DtEvent"); b.Property("EvType") .HasColumnType("int") .HasColumnName("EvType"); b.Property("KeyNum") .HasColumnType("int"); b.Property("MachineID") .HasColumnType("int"); b.Property("ProjDbId") .HasColumnType("int"); b.Property("SupervId") .IsRequired() .HasColumnType("longtext") .HasColumnName("SupervId"); b.Property("VarValue") .IsRequired() .HasColumnType("longtext") .HasColumnName("VarValue"); b.HasKey("LogDbId"); b.HasIndex("KeyNum"); b.HasIndex("MachineID"); b.ToTable("LogMachine"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.MachGroupModel", b => { b.Property("MachGroupDbId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("DbId"); b.Property("DtEnd") .HasColumnType("datetime(6)") .HasColumnName("DtEnd"); b.Property("DtStart") .HasColumnType("datetime(6)") .HasColumnName("DtStart"); b.Property("MachGroupId") .HasColumnType("int") .HasColumnName("MachGroupId"); b.Property("ProjDbId") .HasColumnType("int"); b.HasKey("MachGroupDbId"); b.ToTable("MachGroupList"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.MaterialModel", b => { b.Property("MatId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("HMm") .HasColumnType("decimal(65,30)"); b.Property("LMm") .HasColumnType("decimal(65,30)"); b.Property("MatCode") .IsRequired() .HasColumnType("longtext"); b.Property("MatDesc") .IsRequired() .HasColumnType("longtext"); b.Property("WMm") .HasColumnType("decimal(65,30)"); b.HasKey("MatId"); b.ToTable("MaterialsList"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.MovMagModel", b => { b.Property("MovID") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("DtRec") .HasColumnType("datetime(6)"); b.Property("Note") .IsRequired() .HasColumnType("longtext"); b.Property("QtyRec") .HasColumnType("int"); b.Property("RawItemId") .HasColumnType("int"); b.Property("UserId") .IsRequired() .HasColumnType("longtext"); b.HasKey("MovID"); b.HasIndex("RawItemId"); b.ToTable("MovMag"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.PartModel", b => { b.Property("PartDbId") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnName("DbId"); b.Property("DtEnd") .HasColumnType("datetime(6)") .HasColumnName("DtEnd"); b.Property("DtStart") .HasColumnType("datetime(6)") .HasColumnName("DtStart"); b.Property("MachGroupId") .HasColumnType("int") .HasColumnName("MachGroupId"); b.Property("PartId") .HasColumnType("int") .HasColumnName("PartId"); b.Property("ProjDbId") .HasColumnType("int"); b.HasKey("PartDbId"); b.ToTable("PartList"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.ProjModel", b => { b.Property("ProjDbId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("BTLFileName") .IsRequired() .HasColumnType("longtext"); b.Property("DtCreated") .HasColumnType("datetime(6)"); b.Property("DtLastAction") .HasColumnType("datetime(6)"); b.Property("DtSchedule") .HasColumnType("datetime(6)"); b.Property("DtStartProd") .HasColumnType("datetime(6)"); b.Property("IsActive") .HasColumnType("tinyint(1)"); b.Property("IsArchived") .HasColumnType("tinyint(1)"); b.Property("KeyNum") .HasColumnType("int"); b.Property("ListName") .IsRequired() .HasColumnType("longtext"); b.Property("Machine") .IsRequired() .HasColumnType("longtext"); b.Property("MachineID") .HasColumnType("int"); b.Property("PType") .HasColumnType("int"); b.Property("ProcTimeEst") .HasColumnType("double"); b.Property("ProcTimeReal") .HasColumnType("double"); b.Property("ProjDescription") .IsRequired() .HasColumnType("longtext"); b.Property("ProjExtDbId") .HasColumnType("int"); b.Property("ProjExtId") .HasColumnType("int"); b.Property("ValAct") .HasColumnType("double"); b.Property("ValMax") .HasColumnType("double"); b.HasKey("ProjDbId"); b.HasIndex("IsActive"); b.HasIndex("IsArchived"); b.HasIndex("KeyNum"); b.HasIndex("MachineID"); b.HasIndex("ProjExtDbId"); b.ToTable("ProjList"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.RawItemModel", b => { b.Property("RawItemId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("HMm") .HasColumnType("decimal(65,30)"); b.Property("IsDeleted") .HasColumnType("tinyint(1)"); b.Property("IsRemn") .HasColumnType("tinyint(1)"); b.Property("LMm") .HasColumnType("decimal(65,30)"); b.Property("Location") .IsRequired() .HasColumnType("longtext"); b.Property("MatId") .HasColumnType("int"); b.Property("Note") .IsRequired() .HasColumnType("longtext"); b.Property("QtyAvail") .HasColumnType("int"); b.Property("WMm") .HasColumnType("decimal(65,30)"); b.HasKey("RawItemId"); b.HasIndex("MatId"); b.ToTable("RawItemList"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.RequestPlanModel", b => { b.Property("RequestId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("DtRequest") .HasColumnType("datetime(6)"); b.Property("IsActive") .HasColumnType("tinyint(1)"); b.Property("ProjDbId") .HasColumnType("int"); b.Property("ReqState") .HasColumnType("int"); b.HasKey("RequestId"); b.ToTable("RequestPlan"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.ResourceModel", b => { b.Property("ResourceId") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("Qty") .HasColumnType("int"); b.Property("RawItemId") .HasColumnType("int"); b.Property("RequestId") .HasColumnType("int"); b.HasKey("ResourceId"); b.HasIndex("RawItemId"); b.HasIndex("RequestId"); b.ToTable("ResourceList"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.StatusModel", b => { b.Property("IdxStato") .ValueGeneratedOnAdd() .HasColumnType("int"); b.Property("ClasseTempo") .IsRequired() .HasColumnType("longtext"); b.Property("Descrizione") .IsRequired() .HasColumnType("longtext"); b.Property("KeyStato") .IsRequired() .HasColumnType("longtext"); b.Property("NoteStato") .IsRequired() .HasColumnType("longtext"); b.Property("Priorita") .HasColumnType("int"); b.Property("Semaforo") .IsRequired() .HasColumnType("longtext"); b.Property("ShowArticolo") .HasColumnType("tinyint(1)"); b.HasKey("IdxStato"); b.ToTable("AnagStati"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.MovMagModel", b => { b.HasOne("MagMan.Data.Tenant.DbModels.RawItemModel", "ItemNav") .WithMany() .HasForeignKey("RawItemId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("ItemNav"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.RawItemModel", b => { b.HasOne("MagMan.Data.Tenant.DbModels.MaterialModel", "MaterialNav") .WithMany("RawItemList") .HasForeignKey("MatId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("MaterialNav"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.ResourceModel", b => { b.HasOne("MagMan.Data.Tenant.DbModels.RawItemModel", "ItemNav") .WithMany() .HasForeignKey("RawItemId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("MagMan.Data.Tenant.DbModels.RequestPlanModel", "RequestNav") .WithMany("ResourcesList") .HasForeignKey("RequestId") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("ItemNav"); b.Navigation("RequestNav"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.MaterialModel", b => { b.Navigation("RawItemList"); }); modelBuilder.Entity("MagMan.Data.Tenant.DbModels.RequestPlanModel", b => { b.Navigation("ResourcesList"); }); #pragma warning restore 612, 618 } } }