// <auto-generated /> using System; using MTWorkHR.Infrastructure.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace MTWorkHR.Infrastructure.Migrations { [DbContext(typeof(HRDataContext))] [Migration("20240225115219_UserTasks")] partial class UserTasks { /// <inheritdoc /> protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "8.0.1") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); modelBuilder.Entity("MTWorkHR.Core.Entities.AuthLog", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<string>("Channel") .HasColumnType("nvarchar(max)"); b.Property<DateTime>("CreateDate") .HasColumnType("datetime2"); b.Property<string>("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("InnerException") .HasColumnType("nvarchar(max)"); b.Property<string>("Input") .HasColumnType("nvarchar(max)"); b.Property<string>("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("QueryString") .HasColumnType("nvarchar(max)"); b.Property<string>("ServerIP") .HasColumnType("nvarchar(max)"); b.Property<string>("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("UserIP") .HasColumnType("nvarchar(max)"); b.Property<string>("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("AuthLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Base.AttachmentType", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<bool>("IsRequired") .HasColumnType("bit"); b.Property<string>("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property<string>("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("AttachmentType"); b.HasData( new { Id = 1L, IsRequired = false, NameAr = "السيرة الذاتية", NameEn = "CV" }, new { Id = 2L, IsRequired = false, NameAr = "الهوية", NameEn = "Identification" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Company", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<string>("CRNumber") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("CompanyName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<DateTime>("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property<string>("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property<bool>("IsDeleted") .HasColumnType("bit"); b.Property<int>("TaxNumber") .HasColumnType("int"); b.Property<DateTime?>("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property<string>("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property<long>("UserId") .HasColumnType("bigint"); b.HasKey("Id"); b.ToTable("Companies"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.FileLog", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<string>("Channel") .HasColumnType("nvarchar(max)"); b.Property<DateTime>("CreateDate") .HasColumnType("datetime2"); b.Property<string>("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("InnerException") .HasColumnType("nvarchar(max)"); b.Property<string>("Input") .HasColumnType("nvarchar(max)"); b.Property<string>("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("QueryString") .HasColumnType("nvarchar(max)"); b.Property<string>("ServerIP") .HasColumnType("nvarchar(max)"); b.Property<string>("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("UserIP") .HasColumnType("nvarchar(max)"); b.Property<string>("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("FileLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<string>("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property<string>("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("Projects"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.RoleLog", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<string>("Channel") .HasColumnType("nvarchar(max)"); b.Property<DateTime>("CreateDate") .HasColumnType("datetime2"); b.Property<string>("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("InnerException") .HasColumnType("nvarchar(max)"); b.Property<string>("Input") .HasColumnType("nvarchar(max)"); b.Property<string>("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("QueryString") .HasColumnType("nvarchar(max)"); b.Property<string>("ServerIP") .HasColumnType("nvarchar(max)"); b.Property<string>("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("UserIP") .HasColumnType("nvarchar(max)"); b.Property<string>("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("RoleLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.SettingLog", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<string>("Channel") .HasColumnType("nvarchar(max)"); b.Property<DateTime>("CreateDate") .HasColumnType("datetime2"); b.Property<string>("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("InnerException") .HasColumnType("nvarchar(max)"); b.Property<string>("Input") .HasColumnType("nvarchar(max)"); b.Property<string>("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("QueryString") .HasColumnType("nvarchar(max)"); b.Property<string>("ServerIP") .HasColumnType("nvarchar(max)"); b.Property<string>("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("UserIP") .HasColumnType("nvarchar(max)"); b.Property<string>("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("SettingLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserLog", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<string>("Channel") .HasColumnType("nvarchar(max)"); b.Property<DateTime>("CreateDate") .HasColumnType("datetime2"); b.Property<string>("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("InnerException") .HasColumnType("nvarchar(max)"); b.Property<string>("Input") .HasColumnType("nvarchar(max)"); b.Property<string>("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("QueryString") .HasColumnType("nvarchar(max)"); b.Property<string>("ServerIP") .HasColumnType("nvarchar(max)"); b.Property<string>("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("UserIP") .HasColumnType("nvarchar(max)"); b.Property<string>("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("UserLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<long>("AssignedUserId") .HasColumnType("bigint"); b.Property<DateTime>("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property<string>("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property<string>("DeleteUserId") .IsRequired() .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property<string>("Description") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<DateTime>("DueDate") .HasColumnType("datetime2"); b.Property<bool>("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property<int>("Priority") .HasColumnType("int"); b.Property<long>("ProjectId") .HasColumnType("bigint"); b.Property<long>("StatusId") .HasColumnType("bigint"); b.Property<string>("Title") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<DateTime?>("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property<string>("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("ProjectId"); b.HasIndex("StatusId"); b.ToTable("UserTasks"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<long>("AttachmentTypeId") .HasColumnType("bigint"); b.Property<DateTime>("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property<string>("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property<string>("FileName") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property<string>("OriginalName") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property<long>("TaskId") .HasColumnType("bigint"); b.Property<DateTime?>("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property<string>("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("AttachmentTypeId"); b.HasIndex("TaskId"); b.ToTable("UserTaskAttachments"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<long>("AssignedToUserId") .HasColumnType("bigint"); b.Property<string>("Comment") .IsRequired() .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property<DateTime>("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property<string>("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property<long>("CurrentStatusId") .HasColumnType("bigint"); b.Property<bool>("IsDeleted") .HasColumnType("bit"); b.Property<DateTime?>("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property<string>("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("CurrentStatusId"); b.ToTable("UserTaskHistories"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskStatus", b => { b.Property<long>("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id")); b.Property<string>("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property<string>("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("UserTaskStatuses"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b => { b.HasOne("MTWorkHR.Core.Entities.Project", "Project") .WithMany() .HasForeignKey("ProjectId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus") .WithMany() .HasForeignKey("StatusId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Project"); b.Navigation("TaskStatus"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b => { b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType") .WithMany() .HasForeignKey("AttachmentTypeId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask") .WithMany("TaskAttachments") .HasForeignKey("TaskId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("AttachmentType"); b.Navigation("UserTask"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b => { b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus") .WithMany() .HasForeignKey("CurrentStatusId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("TaskStatus"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b => { b.Navigation("TaskAttachments"); }); #pragma warning restore 612, 618 } } }