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

#nullable disable

namespace LiMan.DB.Migrations
{
    [DbContext(typeof(LMDbContext))]
    [Migration("20240806142953_AddRelModel01")]
    partial class AddRelModel01
    {
        protected override void BuildTargetModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            modelBuilder
                .UseCollation("SQL_Latin1_General_CP1_CI_AS")
                .HasAnnotation("ProductVersion", "6.0.28")
                .HasAnnotation("Relational:MaxIdentifierLength", 128);

            SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);

            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.Property<string>("TplConnString")
                        .HasMaxLength(2500)
                        .HasColumnType("nvarchar(2500)");

                    b.HasKey("CodApp");

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

            modelBuilder.Entity("LiMan.DB.DBModels.AuthClaimModel", b =>
                {
                    b.Property<int>("ClaimID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("ClaimID"), 1L, 1);

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

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

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

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

                    b.HasKey("ClaimID");

                    b.HasIndex("RoleID");

                    b.HasIndex("UserID");

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

            modelBuilder.Entity("LiMan.DB.DBModels.AuthRoleModel", b =>
                {
                    b.Property<int>("RoleID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("RoleID"), 1L, 1);

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

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

                    b.HasKey("RoleID");

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

            modelBuilder.Entity("LiMan.DB.DBModels.AuthUserModel", b =>
                {
                    b.Property<int>("UserID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("UserID"), 1L, 1);

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

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

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

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

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

                    b.HasKey("UserID");

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

            modelBuilder.Entity("LiMan.DB.DBModels.FileAttachModel", b =>
                {
                    b.Property<int>("IdxFileAttach")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxFileAttach"), 1L, 1);

                    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");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxLic"), 1L, 1);

                    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");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxLogLic"), 1L, 1);

                    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.ReleaseModel", b =>
                {
                    b.Property<int>("IdxRel")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxRel"), 1L, 1);

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

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

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

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

                    b.HasKey("IdxRel");

                    b.HasIndex("CodApp");

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

            modelBuilder.Entity("LiMan.DB.DBModels.StatsCallModel", b =>
                {
                    b.Property<int>("YearRef")
                        .HasColumnType("int");

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

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

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

                    b.HasKey("YearRef", "CodInst", "CodApp");

                    b.ToView("v_StatsCall");
                });

            modelBuilder.Entity("LiMan.DB.DBModels.SubLicenzaModel", b =>
                {
                    b.Property<int>("IdxSubLic")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxSubLic"), 1L, 1);

                    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");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("IdxTicket"), 1L, 1);

                    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>("TType")
                        .HasColumnType("int");

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

                    b.HasKey("IdxTicket");

                    b.HasIndex("IdxLic");

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

            modelBuilder.Entity("LiMan.DB.DBModels.AuthClaimModel", b =>
                {
                    b.HasOne("LiMan.DB.DBModels.AuthRoleModel", "RoleNav")
                        .WithMany("Claims")
                        .HasForeignKey("RoleID")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("LiMan.DB.DBModels.AuthUserModel", "UserNav")
                        .WithMany("Claims")
                        .HasForeignKey("UserID")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("RoleNav");

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

            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.ReleaseModel", b =>
                {
                    b.HasOne("LiMan.DB.DBModels.ApplicativoModel", "ApplicativoNav")
                        .WithMany()
                        .HasForeignKey("CodApp");

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

            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.AuthRoleModel", b =>
                {
                    b.Navigation("Claims");
                });

            modelBuilder.Entity("LiMan.DB.DBModels.AuthUserModel", b =>
                {
                    b.Navigation("Claims");
                });

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

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