//
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
}
}
}