//
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("20240226083813_userHistory")]
partial class userHistory
{
///
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("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("Channel")
.HasColumnType("nvarchar(max)");
b.Property("CreateDate")
.HasColumnType("datetime2");
b.Property("CreateUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorDescription")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("InnerException")
.HasColumnType("nvarchar(max)");
b.Property("Input")
.HasColumnType("nvarchar(max)");
b.Property("Method")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QueryString")
.HasColumnType("nvarchar(max)");
b.Property("ServerIP")
.HasColumnType("nvarchar(max)");
b.Property("ServiceResponseTimeInSeconds")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("UserIP")
.HasColumnType("nvarchar(max)");
b.Property("userAgent")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("AuthLogs");
});
modelBuilder.Entity("MTWorkHR.Core.Entities.Base.AttachmentType", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("IsRequired")
.HasColumnType("bit");
b.Property("NameAr")
.IsRequired()
.HasMaxLength(250)
.HasColumnType("nvarchar(250)");
b.Property("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("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("CRNumber")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("CompanyName")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("CreateDate")
.HasColumnType("datetime2")
.HasColumnOrder(3);
b.Property("CreateUser")
.HasMaxLength(450)
.HasColumnType("nvarchar(450)")
.HasColumnOrder(1);
b.Property("IsDeleted")
.HasColumnType("bit");
b.Property("TaxNumber")
.HasColumnType("int");
b.Property("UpdateDate")
.HasColumnType("datetime2")
.HasColumnOrder(4);
b.Property("UpdateUser")
.HasMaxLength(450)
.HasColumnType("nvarchar(450)")
.HasColumnOrder(2);
b.Property("UserId")
.HasColumnType("bigint");
b.HasKey("Id");
b.ToTable("Companies");
});
modelBuilder.Entity("MTWorkHR.Core.Entities.FileLog", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("Channel")
.HasColumnType("nvarchar(max)");
b.Property("CreateDate")
.HasColumnType("datetime2");
b.Property("CreateUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorDescription")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("InnerException")
.HasColumnType("nvarchar(max)");
b.Property("Input")
.HasColumnType("nvarchar(max)");
b.Property("Method")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QueryString")
.HasColumnType("nvarchar(max)");
b.Property("ServerIP")
.HasColumnType("nvarchar(max)");
b.Property("ServiceResponseTimeInSeconds")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("UserIP")
.HasColumnType("nvarchar(max)");
b.Property("userAgent")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("FileLogs");
});
modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("NameAr")
.IsRequired()
.HasMaxLength(250)
.HasColumnType("nvarchar(250)");
b.Property("NameEn")
.IsRequired()
.HasMaxLength(250)
.HasColumnType("nvarchar(250)");
b.HasKey("Id");
b.ToTable("Projects");
});
modelBuilder.Entity("MTWorkHR.Core.Entities.RoleLog", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("Channel")
.HasColumnType("nvarchar(max)");
b.Property("CreateDate")
.HasColumnType("datetime2");
b.Property("CreateUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorDescription")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("InnerException")
.HasColumnType("nvarchar(max)");
b.Property("Input")
.HasColumnType("nvarchar(max)");
b.Property("Method")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QueryString")
.HasColumnType("nvarchar(max)");
b.Property("ServerIP")
.HasColumnType("nvarchar(max)");
b.Property("ServiceResponseTimeInSeconds")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("UserIP")
.HasColumnType("nvarchar(max)");
b.Property("userAgent")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("RoleLogs");
});
modelBuilder.Entity("MTWorkHR.Core.Entities.SettingLog", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("Channel")
.HasColumnType("nvarchar(max)");
b.Property("CreateDate")
.HasColumnType("datetime2");
b.Property("CreateUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorDescription")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("InnerException")
.HasColumnType("nvarchar(max)");
b.Property("Input")
.HasColumnType("nvarchar(max)");
b.Property("Method")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QueryString")
.HasColumnType("nvarchar(max)");
b.Property("ServerIP")
.HasColumnType("nvarchar(max)");
b.Property("ServiceResponseTimeInSeconds")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("UserIP")
.HasColumnType("nvarchar(max)");
b.Property("userAgent")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("SettingLogs");
});
modelBuilder.Entity("MTWorkHR.Core.Entities.UserLog", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("Channel")
.HasColumnType("nvarchar(max)");
b.Property("CreateDate")
.HasColumnType("datetime2");
b.Property("CreateUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("ErrorDescription")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("InnerException")
.HasColumnType("nvarchar(max)");
b.Property("Input")
.HasColumnType("nvarchar(max)");
b.Property("Method")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QueryString")
.HasColumnType("nvarchar(max)");
b.Property("ServerIP")
.HasColumnType("nvarchar(max)");
b.Property("ServiceResponseTimeInSeconds")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("UserIP")
.HasColumnType("nvarchar(max)");
b.Property("userAgent")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.ToTable("UserLogs");
});
modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("AssignedUserId")
.HasColumnType("bigint");
b.Property("CreateDate")
.HasColumnType("datetime2")
.HasColumnOrder(3);
b.Property("CreateUser")
.HasMaxLength(450)
.HasColumnType("nvarchar(450)")
.HasColumnOrder(1);
b.Property("DeleteUserId")
.HasMaxLength(450)
.HasColumnType("nvarchar(450)")
.HasColumnOrder(8);
b.Property("Description")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("DueDate")
.HasColumnType("datetime2");
b.Property("IsDeleted")
.HasColumnType("bit")
.HasColumnOrder(7);
b.Property("Priority")
.HasColumnType("int");
b.Property("ProjectId")
.HasColumnType("bigint");
b.Property("StatusId")
.HasColumnType("bigint");
b.Property("Title")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("UpdateDate")
.HasColumnType("datetime2")
.HasColumnOrder(4);
b.Property("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("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("AttachmentTypeId")
.HasColumnType("bigint");
b.Property("CreateDate")
.HasColumnType("datetime2")
.HasColumnOrder(3);
b.Property("CreateUser")
.HasMaxLength(450)
.HasColumnType("nvarchar(450)")
.HasColumnOrder(1);
b.Property("FileName")
.IsRequired()
.HasMaxLength(250)
.HasColumnType("nvarchar(250)");
b.Property("OriginalName")
.IsRequired()
.HasMaxLength(250)
.HasColumnType("nvarchar(250)");
b.Property("TaskId")
.HasColumnType("bigint");
b.Property("UpdateDate")
.HasColumnType("datetime2")
.HasColumnOrder(4);
b.Property("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("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("AssignedToUserId")
.HasColumnType("bigint");
b.Property("Comment")
.IsRequired()
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property("CreateDate")
.HasColumnType("datetime2")
.HasColumnOrder(3);
b.Property("CreateUser")
.HasMaxLength(450)
.HasColumnType("nvarchar(450)")
.HasColumnOrder(1);
b.Property("CurrentStatusId")
.HasColumnType("bigint");
b.Property("IsDeleted")
.HasColumnType("bit");
b.Property("UpdateDate")
.HasColumnType("datetime2")
.HasColumnOrder(4);
b.Property("UpdateUser")
.HasMaxLength(450)
.HasColumnType("nvarchar(450)")
.HasColumnOrder(2);
b.Property("UserTaskId")
.HasColumnType("bigint");
b.HasKey("Id");
b.HasIndex("CurrentStatusId");
b.HasIndex("UserTaskId");
b.ToTable("UserTaskHistories");
});
modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskStatus", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"));
b.Property("NameAr")
.IsRequired()
.HasMaxLength(250)
.HasColumnType("nvarchar(250)");
b.Property("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.HasOne("MTWorkHR.Core.Entities.UserTask", null)
.WithMany("UserTaskHistories")
.HasForeignKey("UserTaskId");
b.Navigation("TaskStatus");
});
modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
{
b.Navigation("TaskAttachments");
b.Navigation("UserTaskHistories");
});
#pragma warning restore 612, 618
}
}
}