// <auto-generated />
using System;
using GWMS.Data;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

#nullable disable

namespace GWMS.Data.Migrations
{
    [DbContext(typeof(GWMSContext))]
    partial class GWMSContextModelSnapshot : ModelSnapshot
    {
        protected override void BuildModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            modelBuilder
                .HasAnnotation("ProductVersion", "6.0.2")
                .HasAnnotation("Relational:MaxIdentifierLength", 64);

            modelBuilder.Entity("GWMS.Data.DatabaseModels.AlarmLogModel", b =>
                {
                    b.Property<int>("AlarmLogId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    b.Property<DateTime>("DtEvent")
                        .HasColumnType("datetime(6)");

                    b.Property<int>("Index")
                        .HasColumnType("int");

                    b.Property<string>("MemAddress")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)");

                    b.Property<int>("PlantId")
                        .HasColumnType("int");

                    b.Property<uint>("Status")
                        .HasColumnType("int unsigned");

                    b.Property<string>("ValDecoded")
                        .HasColumnType("longtext");

                    b.HasKey("AlarmLogId");

                    b.HasIndex("PlantId");

                    b.ToTable("AlarmLog");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.AnKeyValModel", b =>
                {
                    b.Property<string>("KeyName")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasColumnOrder(0);

                    b.Property<string>("Descript")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)")
                        .HasColumnOrder(4)
                        .HasComment("Descrizione dell'item");

                    b.Property<int>("ValFloat")
                        .HasColumnType("int")
                        .HasColumnOrder(2);

                    b.Property<int>("ValInt")
                        .HasColumnType("int")
                        .HasColumnOrder(1);

                    b.Property<string>("ValString")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)")
                        .HasColumnOrder(3);

                    b.HasKey("KeyName");

                    b.ToTable("AnKeyVal");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.ConfigModel", b =>
                {
                    b.Property<string>("KeyName")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasColumnOrder(0);

                    b.Property<string>("Note")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)")
                        .HasColumnOrder(3);

                    b.Property<string>("Val")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasColumnOrder(1);

                    b.Property<string>("ValStd")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasColumnOrder(2)
                        .HasComment("Valore di default/riferimento per la variabile");

                    b.HasKey("KeyName");

                    b.ToTable("Config");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.ItemModel", b =>
                {
                    b.Property<int>("ItemId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasColumnOrder(0);

                    b.Property<string>("ItemCode")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)")
                        .HasColumnOrder(1);

                    b.Property<string>("ItemDesc")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)")
                        .HasColumnOrder(2);

                    b.Property<string>("ItemType")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasColumnOrder(3);

                    b.Property<string>("UM")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasColumnOrder(4);

                    b.HasKey("ItemId");

                    b.ToTable("Items");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.ListValModel", b =>
                {
                    b.Property<string>("TabName")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasColumnName("TabName")
                        .HasColumnOrder(0);

                    b.Property<string>("FieldName")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasColumnName("FieldName")
                        .HasColumnOrder(1);

                    b.Property<string>("Val")
                        .HasMaxLength(50)
                        .HasColumnType("varchar(50)")
                        .HasColumnName("Val")
                        .HasColumnOrder(2);

                    b.Property<string>("Descript")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)")
                        .HasColumnName("Descript")
                        .HasColumnOrder(3);

                    b.Property<int>("Ordinal")
                        .HasColumnType("int")
                        .HasColumnName("Ordinal")
                        .HasColumnOrder(4);

                    b.HasKey("TabName", "FieldName", "Val");

                    b.ToTable("ListVal");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.OrderModel", b =>
                {
                    b.Property<int>("OrderId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    b.Property<DateTime>("DtETA")
                        .HasColumnType("datetime(6)");

                    b.Property<DateTime>("DtExecEnd")
                        .HasColumnType("datetime(6)");

                    b.Property<DateTime>("DtExecStart")
                        .HasColumnType("datetime(6)");

                    b.Property<DateTime>("DtOrder")
                        .HasColumnType("datetime(6)");

                    b.Property<double>("ExecutionQty")
                        .HasColumnType("double");

                    b.Property<double>("LevelEnd")
                        .HasColumnType("double");

                    b.Property<double>("LevelStart")
                        .HasColumnType("double");

                    b.Property<string>("OrderCode")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)");

                    b.Property<string>("OrderDesc")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.Property<double>("OrderQty")
                        .HasColumnType("double");

                    b.Property<int>("PlantId")
                        .HasColumnType("int");

                    b.Property<int>("SupplierId")
                        .HasColumnType("int");

                    b.Property<int>("TransporterId")
                        .HasColumnType("int");

                    b.HasKey("OrderId");

                    b.HasIndex("PlantId");

                    b.HasIndex("SupplierId");

                    b.HasIndex("TransporterId");

                    b.ToTable("Order");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.ParamSendModel", b =>
                {
                    b.Property<int>("PlantId")
                        .HasColumnType("int");

                    b.Property<string>("ParamUid")
                        .HasColumnType("varchar(255)");

                    b.Property<DateTime>("LastSend")
                        .HasColumnType("datetime(6)");

                    b.Property<DateTime>("VetoSend")
                        .HasColumnType("datetime(6)");

                    b.Property<bool>("enabled")
                        .HasColumnType("tinyint(1)");

                    b.Property<int>("windEnd")
                        .HasColumnType("int");

                    b.Property<int>("windStart")
                        .HasColumnType("int");

                    b.HasKey("PlantId", "ParamUid");

                    b.ToTable("ParamSend");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.ParamSetModel", b =>
                {
                    b.Property<int>("ParamSetId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    b.Property<string>("Note")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.Property<string>("ParamUid")
                        .HasColumnType("longtext");

                    b.Property<int>("PlantId")
                        .HasColumnType("int");

                    b.Property<DateTime>("Scadenza")
                        .HasColumnType("datetime(6)");

                    b.Property<decimal>("TargetVal")
                        .HasColumnType("decimal(65,30)");

                    b.HasKey("ParamSetId");

                    b.ToTable("ParamSet");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantDetailModel", b =>
                {
                    b.Property<int>("PlantId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    b.Property<double>("LevelMax")
                        .HasColumnType("double");

                    b.Property<double>("LevelReorder")
                        .HasColumnType("double");

                    b.Property<double>("OrderQtyStd")
                        .HasColumnType("double");

                    b.Property<string>("PlantCode")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)");

                    b.Property<string>("PlantDesc")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.HasKey("PlantId");

                    b.ToTable("PlantDetail");

                    b.HasData(
                        new
                        {
                            PlantId = 1,
                            LevelMax = 26000.0,
                            LevelReorder = 15000.0,
                            OrderQtyStd = 18000.0,
                            PlantCode = "PIZ03",
                            PlantDesc = "Collecchio"
                        },
                        new
                        {
                            PlantId = 2,
                            LevelMax = 28000.0,
                            LevelReorder = 15000.0,
                            OrderQtyStd = 18000.0,
                            PlantCode = "PIZ04",
                            PlantDesc = "Noceto"
                        },
                        new
                        {
                            PlantId = 3,
                            LevelMax = 24000.0,
                            LevelReorder = 15000.0,
                            OrderQtyStd = 18000.0,
                            PlantCode = "PIZ05",
                            PlantDesc = "Baganzola"
                        },
                        new
                        {
                            PlantId = 4,
                            LevelMax = 26000.0,
                            LevelReorder = 15000.0,
                            OrderQtyStd = 18000.0,
                            PlantCode = "PIZ08",
                            PlantDesc = "Pilastrello"
                        },
                        new
                        {
                            PlantId = 5,
                            LevelMax = 26000.0,
                            LevelReorder = 15000.0,
                            OrderQtyStd = 18000.0,
                            PlantCode = "PIZ09",
                            PlantDesc = "Guardamiglio"
                        });
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantLogModel", b =>
                {
                    b.Property<int>("PlantDataId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    b.Property<DateTime>("DtEvent")
                        .HasColumnType("datetime(6)");

                    b.Property<string>("FluxType")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.Property<int>("PlantId")
                        .HasColumnType("int");

                    b.Property<double>("ValNumber")
                        .HasColumnType("double");

                    b.Property<string>("ValString")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.HasKey("PlantDataId");

                    b.HasIndex(new[] { "PlantId", "DtEvent" }, "IX_PlantLog_PlantDtEv");

                    b.HasIndex(new[] { "PlantId" }, "IX_PlantLog_PlantId");

                    b.ToTable("PlantLog");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantStatusModel", b =>
                {
                    b.Property<int>("PlantId")
                        .HasColumnType("int");

                    b.Property<string>("FluxType")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.Property<DateTime>("DtEvent")
                        .HasColumnType("datetime(6)");

                    b.Property<double>("ValNumber")
                        .HasColumnType("double");

                    b.Property<string>("ValString")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.HasKey("PlantId", "FluxType");

                    b.ToTable("PlantStatus");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.RebootLogModel", b =>
                {
                    b.Property<int>("RecordId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    b.Property<DateTime>("DtEvent")
                        .HasColumnType("datetime(6)");

                    b.Property<string>("Item")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.Property<string>("Payload")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.HasKey("RecordId");

                    b.ToTable("RebootLog");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.SupplierModel", b =>
                {
                    b.Property<int>("SupplierId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    b.Property<string>("SupplierCode")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)");

                    b.Property<string>("SupplierDesc")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.HasKey("SupplierId");

                    b.ToTable("Supplier");

                    b.HasData(
                        new
                        {
                            SupplierId = 1,
                            SupplierCode = "LIQUIGAS",
                            SupplierDesc = "Liquigas"
                        },
                        new
                        {
                            SupplierId = 2,
                            SupplierCode = "VULKANGAS",
                            SupplierDesc = "Vulkangas"
                        });
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.TransporterModel", b =>
                {
                    b.Property<int>("TransporterId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    b.Property<double>("PositionLatitude")
                        .HasColumnType("double");

                    b.Property<double>("PositionLongitude")
                        .HasColumnType("double");

                    b.Property<DateTime>("PositionUpdated")
                        .HasColumnType("datetime(6)");

                    b.Property<string>("TransporterCode")
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)");

                    b.Property<string>("TransporterDesc")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.HasKey("TransporterId");

                    b.ToTable("Transporter");

                    b.HasData(
                        new
                        {
                            TransporterId = 1,
                            PositionLatitude = 0.0,
                            PositionLongitude = 0.0,
                            PositionUpdated = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
                            TransporterCode = "LEVO",
                            TransporterDesc = "Levorato"
                        },
                        new
                        {
                            TransporterId = 2,
                            PositionLatitude = 0.0,
                            PositionLongitude = 0.0,
                            PositionUpdated = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
                            TransporterCode = "TRAF",
                            TransporterDesc = "Traffik"
                        });
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.WeekPlanModel", b =>
                {
                    b.Property<int>("WeekPlanId")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasColumnOrder(0);

                    b.Property<int>("DayNum")
                        .HasColumnType("int");

                    b.Property<int>("DeliveryHour")
                        .HasColumnType("int");

                    b.Property<string>("Note")
                        .HasMaxLength(250)
                        .HasColumnType("varchar(250)");

                    b.Property<int>("PlantId")
                        .HasColumnType("int");

                    b.Property<int>("SupplierId")
                        .HasColumnType("int");

                    b.Property<int>("TransporterId")
                        .HasColumnType("int");

                    b.HasKey("WeekPlanId");

                    b.HasIndex("PlantId");

                    b.HasIndex("SupplierId");

                    b.HasIndex("TransporterId");

                    b.ToTable("WeekPlan");

                    b.HasData(
                        new
                        {
                            WeekPlanId = 1,
                            DayNum = 1,
                            DeliveryHour = 20,
                            Note = "18K",
                            PlantId = 2,
                            SupplierId = 1,
                            TransporterId = 1
                        },
                        new
                        {
                            WeekPlanId = 2,
                            DayNum = 2,
                            DeliveryHour = 20,
                            Note = "18K",
                            PlantId = 2,
                            SupplierId = 1,
                            TransporterId = 1
                        },
                        new
                        {
                            WeekPlanId = 3,
                            DayNum = 3,
                            DeliveryHour = 20,
                            Note = "18K",
                            PlantId = 2,
                            SupplierId = 1,
                            TransporterId = 2
                        },
                        new
                        {
                            WeekPlanId = 4,
                            DayNum = 4,
                            DeliveryHour = 15,
                            Note = "9K",
                            PlantId = 2,
                            SupplierId = 1,
                            TransporterId = 1
                        },
                        new
                        {
                            WeekPlanId = 5,
                            DayNum = 4,
                            DeliveryHour = 20,
                            Note = "18K",
                            PlantId = 2,
                            SupplierId = 1,
                            TransporterId = 1
                        },
                        new
                        {
                            WeekPlanId = 6,
                            DayNum = 6,
                            DeliveryHour = 20,
                            Note = "18K",
                            PlantId = 2,
                            SupplierId = 1,
                            TransporterId = 1
                        },
                        new
                        {
                            WeekPlanId = 7,
                            DayNum = 2,
                            DeliveryHour = 14,
                            Note = "3K",
                            PlantId = 3,
                            SupplierId = 1,
                            TransporterId = 1
                        },
                        new
                        {
                            WeekPlanId = 8,
                            DayNum = 2,
                            DeliveryHour = 15,
                            Note = "15K",
                            PlantId = 4,
                            SupplierId = 1,
                            TransporterId = 1
                        },
                        new
                        {
                            WeekPlanId = 9,
                            DayNum = 2,
                            DeliveryHour = 17,
                            Note = "18K",
                            PlantId = 1,
                            SupplierId = 2,
                            TransporterId = 2
                        });
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.AlarmLogModel", b =>
                {
                    b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant")
                        .WithMany()
                        .HasForeignKey("PlantId")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.Navigation("Plant");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.OrderModel", b =>
                {
                    b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant")
                        .WithMany()
                        .HasForeignKey("PlantId")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.HasOne("GWMS.Data.DatabaseModels.SupplierModel", "Supplier")
                        .WithMany()
                        .HasForeignKey("SupplierId")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.HasOne("GWMS.Data.DatabaseModels.TransporterModel", "Transporter")
                        .WithMany()
                        .HasForeignKey("TransporterId")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.Navigation("Plant");

                    b.Navigation("Supplier");

                    b.Navigation("Transporter");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantLogModel", b =>
                {
                    b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant")
                        .WithMany()
                        .HasForeignKey("PlantId")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.Navigation("Plant");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.PlantStatusModel", b =>
                {
                    b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant")
                        .WithMany()
                        .HasForeignKey("PlantId")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.Navigation("Plant");
                });

            modelBuilder.Entity("GWMS.Data.DatabaseModels.WeekPlanModel", b =>
                {
                    b.HasOne("GWMS.Data.DatabaseModels.PlantDetailModel", "Plant")
                        .WithMany()
                        .HasForeignKey("PlantId")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.HasOne("GWMS.Data.DatabaseModels.SupplierModel", "Supplier")
                        .WithMany()
                        .HasForeignKey("SupplierId")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.HasOne("GWMS.Data.DatabaseModels.TransporterModel", "Transporter")
                        .WithMany()
                        .HasForeignKey("TransporterId")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.Navigation("Plant");

                    b.Navigation("Supplier");

                    b.Navigation("Transporter");
                });
#pragma warning restore 612, 618
        }
    }
}