Samuele Locatelli
560 lines
19 KiB
C#
560 lines
19 KiB
C#
// <auto-generated />
|
|
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<string>("Family")
|
|
.HasColumnType("varchar(255)");
|
|
|
|
b.Property<string>("ValueOriginal")
|
|
.HasColumnType("varchar(255)");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("tinyint(1)");
|
|
|
|
b.Property<string>("ValueAlias")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.HasKey("Family", "ValueOriginal");
|
|
|
|
b.ToTable("AliasList");
|
|
});
|
|
|
|
modelBuilder.Entity("MagMan.Data.Tenant.DbModels.ConfigModel", b =>
|
|
{
|
|
b.Property<string>("KeyName")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)")
|
|
.HasColumnOrder(0);
|
|
|
|
b.Property<string>("Note")
|
|
.IsRequired()
|
|
.HasMaxLength(250)
|
|
.HasColumnType("varchar(250)")
|
|
.HasColumnOrder(3);
|
|
|
|
b.Property<string>("Val")
|
|
.IsRequired()
|
|
.HasMaxLength(50)
|
|
.HasColumnType("varchar(50)")
|
|
.HasColumnOrder(1);
|
|
|
|
b.Property<string>("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<int>("DayId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("DayId");
|
|
|
|
b.Property<DateTime>("DtRif")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<int>("MachineID")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<double>("OreDis")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<double>("OreLav")
|
|
.HasColumnType("double");
|
|
|
|
b.HasKey("DayId");
|
|
|
|
b.ToTable("DayStat");
|
|
});
|
|
|
|
modelBuilder.Entity("MagMan.Data.Tenant.DbModels.EventModel", b =>
|
|
{
|
|
b.Property<int>("IdxEv")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("Azione")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("CssClass")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<bool>("EventoTablet")
|
|
.HasColumnType("tinyint(1)");
|
|
|
|
b.Property<string>("Icon")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("KeyEvento")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("Nome")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("NoteEvento")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("TabAzione")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.HasKey("IdxEv");
|
|
|
|
b.ToTable("AnagEventi");
|
|
});
|
|
|
|
modelBuilder.Entity("MagMan.Data.Tenant.DbModels.LogMachineModel", b =>
|
|
{
|
|
b.Property<int>("LogDbId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("DbId");
|
|
|
|
b.Property<DateTime>("DtEvent")
|
|
.HasColumnType("datetime(6)")
|
|
.HasColumnName("DtEvent");
|
|
|
|
b.Property<int>("EvType")
|
|
.HasColumnType("int")
|
|
.HasColumnName("EvType");
|
|
|
|
b.Property<int>("KeyNum")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("MachineID")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("ProjDbId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("SupervId")
|
|
.IsRequired()
|
|
.HasColumnType("longtext")
|
|
.HasColumnName("SupervId");
|
|
|
|
b.Property<string>("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<int>("MachGroupDbId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("DbId");
|
|
|
|
b.Property<DateTime>("DtEnd")
|
|
.HasColumnType("datetime(6)")
|
|
.HasColumnName("DtEnd");
|
|
|
|
b.Property<DateTime>("DtStart")
|
|
.HasColumnType("datetime(6)")
|
|
.HasColumnName("DtStart");
|
|
|
|
b.Property<int>("MachGroupId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("MachGroupId");
|
|
|
|
b.Property<int>("ProjDbId")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("MachGroupDbId");
|
|
|
|
b.ToTable("MachGroupList");
|
|
});
|
|
|
|
modelBuilder.Entity("MagMan.Data.Tenant.DbModels.MaterialModel", b =>
|
|
{
|
|
b.Property<int>("MatId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<decimal>("HMm")
|
|
.HasColumnType("decimal(65,30)");
|
|
|
|
b.Property<decimal>("LMm")
|
|
.HasColumnType("decimal(65,30)");
|
|
|
|
b.Property<string>("MatCode")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("MatDesc")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<decimal>("WMm")
|
|
.HasColumnType("decimal(65,30)");
|
|
|
|
b.HasKey("MatId");
|
|
|
|
b.ToTable("MaterialsList");
|
|
});
|
|
|
|
modelBuilder.Entity("MagMan.Data.Tenant.DbModels.MovMagModel", b =>
|
|
{
|
|
b.Property<int>("MovID")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<DateTime>("DtRec")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<string>("Note")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<int>("QtyRec")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("RawItemId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("UserId")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.HasKey("MovID");
|
|
|
|
b.HasIndex("RawItemId");
|
|
|
|
b.ToTable("MovMag");
|
|
});
|
|
|
|
modelBuilder.Entity("MagMan.Data.Tenant.DbModels.PartModel", b =>
|
|
{
|
|
b.Property<int>("PartDbId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("DbId");
|
|
|
|
b.Property<DateTime>("DtEnd")
|
|
.HasColumnType("datetime(6)")
|
|
.HasColumnName("DtEnd");
|
|
|
|
b.Property<DateTime>("DtStart")
|
|
.HasColumnType("datetime(6)")
|
|
.HasColumnName("DtStart");
|
|
|
|
b.Property<int>("MachGroupId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("MachGroupId");
|
|
|
|
b.Property<int>("PartId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("PartId");
|
|
|
|
b.Property<int>("ProjDbId")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("PartDbId");
|
|
|
|
b.ToTable("PartList");
|
|
});
|
|
|
|
modelBuilder.Entity("MagMan.Data.Tenant.DbModels.ProjModel", b =>
|
|
{
|
|
b.Property<int>("ProjDbId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("BTLFileName")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<DateTime>("DtCreated")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<DateTime>("DtLastAction")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<DateTime>("DtSchedule")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<DateTime>("DtStartProd")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("tinyint(1)");
|
|
|
|
b.Property<bool>("IsArchived")
|
|
.HasColumnType("tinyint(1)");
|
|
|
|
b.Property<int>("KeyNum")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("ListName")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("Machine")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<int>("MachineID")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("PType")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<double>("ProcTimeEst")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<double>("ProcTimeReal")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<string>("ProjDescription")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<int>("ProjExtDbId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("ProjExtId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<double>("ValAct")
|
|
.HasColumnType("double");
|
|
|
|
b.Property<double>("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<int>("RawItemId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<decimal>("HMm")
|
|
.HasColumnType("decimal(65,30)");
|
|
|
|
b.Property<bool>("IsDeleted")
|
|
.HasColumnType("tinyint(1)");
|
|
|
|
b.Property<bool>("IsRemn")
|
|
.HasColumnType("tinyint(1)");
|
|
|
|
b.Property<decimal>("LMm")
|
|
.HasColumnType("decimal(65,30)");
|
|
|
|
b.Property<string>("Location")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<int>("MatId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("Note")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<int>("QtyAvail")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<decimal>("WMm")
|
|
.HasColumnType("decimal(65,30)");
|
|
|
|
b.HasKey("RawItemId");
|
|
|
|
b.HasIndex("MatId");
|
|
|
|
b.ToTable("RawItemList");
|
|
});
|
|
|
|
modelBuilder.Entity("MagMan.Data.Tenant.DbModels.RequestPlanModel", b =>
|
|
{
|
|
b.Property<int>("RequestId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<DateTime>("DtRequest")
|
|
.HasColumnType("datetime(6)");
|
|
|
|
b.Property<bool>("IsActive")
|
|
.HasColumnType("tinyint(1)");
|
|
|
|
b.Property<int>("ProjDbId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("ReqState")
|
|
.HasColumnType("int");
|
|
|
|
b.HasKey("RequestId");
|
|
|
|
b.ToTable("RequestPlan");
|
|
});
|
|
|
|
modelBuilder.Entity("MagMan.Data.Tenant.DbModels.ResourceModel", b =>
|
|
{
|
|
b.Property<int>("ResourceId")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("Qty")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("RawItemId")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<int>("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<int>("IdxStato")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("ClasseTempo")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("Descrizione")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("KeyStato")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<string>("NoteStato")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<int>("Priorita")
|
|
.HasColumnType("int");
|
|
|
|
b.Property<string>("Semaforo")
|
|
.IsRequired()
|
|
.HasColumnType("longtext");
|
|
|
|
b.Property<bool>("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
|
|
}
|
|
}
|
|
}
|