// <auto-generated />
using System;
using LiMan.DB;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

namespace LiMan.DB.Migrations
{
    [DbContext(typeof(LMDbContext))]
    [Migration("20211220181913_AddFileAttach")]
    partial class AddFileAttach
    {
        protected override void BuildTargetModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            modelBuilder
                .HasAnnotation("Relational:Collation", "SQL_Latin1_General_CP1_CI_AS")
                .HasAnnotation("Relational:MaxIdentifierLength", 128)
                .HasAnnotation("ProductVersion", "5.0.10")
                .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

            modelBuilder.Entity("LiMan.DB.DBModels.ApplicativoModel", b =>
                {
                    b.Property<string>("CodApp")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("Descrizione")
                        .HasMaxLength(250)
                        .HasColumnType("nvarchar(250)");

                    b.HasKey("CodApp");

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

            modelBuilder.Entity("LiMan.DB.DBModels.FileAttachModel", b =>
                {
                    b.Property<int>("IdxFileAttach")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

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

                    b.Property<string>("FullStoragePath")
                        .HasColumnType("nvarchar(max)");

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

                    b.Property<string>("OriginalName")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("StorageName")
                        .HasColumnType("nvarchar(max)");

                    b.HasKey("IdxFileAttach");

                    b.HasIndex("IdxTicket");

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

            modelBuilder.Entity("LiMan.DB.DBModels.InstallazioneModel", b =>
                {
                    b.Property<string>("CodInst")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("Cliente")
                        .HasMaxLength(250)
                        .HasColumnType("nvarchar(250)");

                    b.Property<string>("Contatto")
                        .HasMaxLength(250)
                        .HasColumnType("nvarchar(250)");

                    b.Property<string>("Descrizione")
                        .HasMaxLength(250)
                        .HasColumnType("nvarchar(250)");

                    b.Property<string>("Email")
                        .HasMaxLength(250)
                        .HasColumnType("nvarchar(250)");

                    b.HasKey("CodInst");

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

            modelBuilder.Entity("LiMan.DB.DBModels.LicenzaModel", b =>
                {
                    b.Property<int>("IdxLic")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Chiave")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("CodApp")
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("CodInst")
                        .HasColumnType("nvarchar(50)");

                    b.Property<DateTime>("DataEnigma")
                        .HasColumnType("datetime2");

                    b.Property<string>("Descrizione")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Enigma")
                        .HasColumnType("nvarchar(max)");

                    b.Property<bool>("Locked")
                        .HasColumnType("bit");

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

                    b.Property<string>("Payload")
                        .HasColumnType("nvarchar(max)");

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

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

                    b.HasKey("IdxLic");

                    b.HasIndex("CodApp");

                    b.HasIndex("CodInst");

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

            modelBuilder.Entity("LiMan.DB.DBModels.LogCallModel", b =>
                {
                    b.Property<DateTime>("DataRif")
                        .HasColumnType("datetime2");

                    b.Property<string>("CodInst")
                        .HasColumnType("nvarchar(450)");

                    b.Property<string>("CodApp")
                        .HasColumnType("nvarchar(450)");

                    b.Property<string>("TargetUrl")
                        .HasColumnType("nvarchar(450)");

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

                    b.HasKey("DataRif", "CodInst", "CodApp", "TargetUrl");

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

            modelBuilder.Entity("LiMan.DB.DBModels.LogLicenzaModel", b =>
                {
                    b.Property<int>("IdxLogLic")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Chiave")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("CodApp")
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("CodInst")
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("Descrizione")
                        .HasColumnType("nvarchar(max)");

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

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

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

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

                    b.HasKey("IdxLogLic");

                    b.HasIndex("CodApp");

                    b.HasIndex("CodInst");

                    b.HasIndex("IdxLic");

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

            modelBuilder.Entity("LiMan.DB.DBModels.SubLicenzaModel", b =>
                {
                    b.Property<int>("IdxSubLic")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Chiave")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("CodImpiego")
                        .HasColumnType("nvarchar(max)");

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

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

                    b.Property<DateTime>("VetoUnlock")
                        .HasColumnType("datetime2");

                    b.HasKey("IdxSubLic");

                    b.HasIndex("IdxLic");

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

            modelBuilder.Entity("LiMan.DB.DBModels.TicketModel", b =>
                {
                    b.Property<int>("IdxTicket")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("CodImpiego")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ContactEmail")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ContactName")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ContactPhone")
                        .HasColumnType("nvarchar(max)");

                    b.Property<DateTime>("DtReq")
                        .HasColumnType("datetime2");

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

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

                    b.Property<string>("ReqBody")
                        .HasColumnType("nvarchar(max)");

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

                    b.Property<string>("SupplAnsw")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("SupplEmail")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("SupplUserCode")
                        .HasColumnType("nvarchar(max)");

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

                    b.HasKey("IdxTicket");

                    b.HasIndex("IdxLic");

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

            modelBuilder.Entity("LiMan.DB.DBModels.FileAttachModel", b =>
                {
                    b.HasOne("LiMan.DB.DBModels.TicketModel", "TicketNav")
                        .WithMany()
                        .HasForeignKey("IdxTicket")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("LiMan.DB.DBModels.LicenzaModel", b =>
                {
                    b.HasOne("LiMan.DB.DBModels.ApplicativoModel", "ApplicativoNav")
                        .WithMany()
                        .HasForeignKey("CodApp");

                    b.HasOne("LiMan.DB.DBModels.InstallazioneModel", "InstallazioneNav")
                        .WithMany()
                        .HasForeignKey("CodInst");

                    b.Navigation("ApplicativoNav");

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

            modelBuilder.Entity("LiMan.DB.DBModels.LogLicenzaModel", b =>
                {
                    b.HasOne("LiMan.DB.DBModels.ApplicativoModel", "ApplicativoNav")
                        .WithMany()
                        .HasForeignKey("CodApp");

                    b.HasOne("LiMan.DB.DBModels.InstallazioneModel", "InstallazioneNav")
                        .WithMany()
                        .HasForeignKey("CodInst");

                    b.HasOne("LiMan.DB.DBModels.LicenzaModel", "LicenzaNav")
                        .WithMany()
                        .HasForeignKey("IdxLic")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("ApplicativoNav");

                    b.Navigation("InstallazioneNav");

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

            modelBuilder.Entity("LiMan.DB.DBModels.SubLicenzaModel", b =>
                {
                    b.HasOne("LiMan.DB.DBModels.LicenzaModel", "LicenzaNav")
                        .WithMany("Attivazioni")
                        .HasForeignKey("IdxLic")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("LiMan.DB.DBModels.TicketModel", b =>
                {
                    b.HasOne("LiMan.DB.DBModels.LicenzaModel", "LicenzaNav")
                        .WithMany("Tickets")
                        .HasForeignKey("IdxLic")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("LiMan.DB.DBModels.LicenzaModel", b =>
                {
                    b.Navigation("Attivazioni");

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