MTWorkHR/MTWorkHR.Infrastructure/Migrations/20241224101338_altrContracyAttachs.Designer.cs

// <auto-generated />
using System;
using MTWorkHR.Infrastructure.DBContext;
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("20241224101338_altrContracyAttachs")]
    partial class altrContracyAttachs
    {
        /// <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("ApplicationRoleApplicationUser", b =>
                {
                    b.Property<string>("UserRolesId")
                        .HasColumnType("nvarchar(450)");

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

                    b.HasKey("UserRolesId", "UsersId");

                    b.HasIndex("UsersId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.Attendance", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

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

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

                    b.Property<long>("CompanyId")
                        .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")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(8);

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasColumnOrder(7);

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

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

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

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

                    b.HasKey("Id");

                    b.HasIndex("CompanyId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.AttendanceLog", 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("AttendanceLogs");
                });

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

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            IsRequired = false,
                            NameAr = "السيرة الذاتية",
                            NameEn = "CV"
                        },
                        new
                        {
                            Id = 2L,
                            IsRequired = false,
                            NameAr = "جواز السفر",
                            NameEn = "Passport"
                        },
                        new
                        {
                            Id = 3L,
                            IsRequired = false,
                            NameAr = "شهادة التعليم",
                            NameEn = "Education Certification"
                        },
                        new
                        {
                            Id = 4L,
                            IsRequired = false,
                            NameAr = "شهادة الخبرة",
                            NameEn = "Experience Certification"
                        },
                        new
                        {
                            Id = 5L,
                            IsRequired = false,
                            NameAr = "شهادة الاحتراف",
                            NameEn = "Professional Certification"
                        },
                        new
                        {
                            Id = 6L,
                            IsRequired = false,
                            NameAr = "التسجيل التجارى",
                            NameEn = "Commercial Regestration"
                        },
                        new
                        {
                            Id = 7L,
                            IsRequired = false,
                            NameAr = "البطاقة الضريبية",
                            NameEn = "Tax Declaration"
                        },
                        new
                        {
                            Id = 8L,
                            IsRequired = false,
                            NameAr = "الهوية",
                            NameEn = "Identification"
                        },
                        new
                        {
                            Id = 9L,
                            IsRequired = false,
                            NameAr = "الصورة",
                            NameEn = "Image"
                        });
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.ChatAttachment", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long>("ChatMessageId")
                        .HasColumnType("bigint");

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

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

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

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

                    b.Property<string>("FileType")
                        .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("ChatMessageId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ChatMessage", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<string>("Content")
                        .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>("IsSeen")
                        .HasColumnType("bit");

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

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

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

                    b.Property<string>("SenderName")
                        .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.ToTable("ChatMessages");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.City", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

                    b.Property<long>("CountryId")
                        .HasColumnType("bigint");

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

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

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

                    b.HasKey("Id");

                    b.HasIndex("CountryId");

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

            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>("Address")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)");

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

                    b.Property<long?>("CityId")
                        .HasColumnType("bigint");

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

                    b.Property<long?>("CountryId")
                        .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")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(8);

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

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasColumnOrder(7);

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

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

                    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<string>("UserId")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)");

                    b.HasKey("Id");

                    b.HasIndex("CityId");

                    b.HasIndex("CountryId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.Contract", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<int?>("AcademicQualificationId")
                        .HasColumnType("int");

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

                    b.Property<long>("CompanyId")
                        .HasColumnType("bigint");

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

                    b.Property<int?>("ContractDurationId")
                        .HasColumnType("int");

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

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

                    b.Property<int?>("ContractorTaxResidencyId")
                        .HasColumnType("int");

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

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

                    b.Property<string>("DeleteUserId")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(8);

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

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

                    b.Property<decimal?>("FirstPatchAmount")
                        .HasColumnType("decimal(18,2)");

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

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

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

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasColumnOrder(7);

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

                    b.Property<int?>("JobId")
                        .HasColumnType("int");

                    b.Property<string>("JobNumber")
                        .HasMaxLength(150)
                        .HasColumnType("nvarchar(150)");

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

                    b.Property<decimal?>("LastPatchAmount")
                        .HasColumnType("decimal(18,2)");

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

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

                    b.Property<int?>("NoticePeriodBeforeTermination")
                        .HasColumnType("int");

                    b.Property<decimal?>("Salary")
                        .HasColumnType("decimal(18,2)");

                    b.Property<int?>("SpecializationId")
                        .HasColumnType("int");

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

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

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

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

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

                    b.Property<int?>("VacationDays")
                        .HasColumnType("int");

                    b.Property<int?>("WhoCanTerminateContract")
                        .HasColumnType("int");

                    b.Property<int?>("WhoCanTerminateContractInTrial")
                        .HasColumnType("int");

                    b.Property<int?>("WorkCountryId")
                        .HasColumnType("int");

                    b.Property<int?>("WorkStateId")
                        .HasColumnType("int");

                    b.Property<int?>("WorkingHours")
                        .HasColumnType("int");

                    b.Property<int?>("WorkingHoursNum")
                        .HasColumnType("int");

                    b.HasKey("Id");

                    b.HasIndex("CompanyId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ContractAllowance", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

                    b.Property<long>("AllowanceType")
                        .HasColumnType("bigint");

                    b.Property<long>("ContractId")
                        .HasColumnType("bigint");

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

                    b.Property<decimal>("EntitlementAmount")
                        .HasColumnType("decimal(18,2)");

                    b.Property<decimal>("EntitlementPercent")
                        .HasColumnType("decimal(18,2)");

                    b.Property<string>("PaymentType")
                        .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("ContractId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTask", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<decimal?>("Amount")
                        .HasColumnType("decimal(18,2)");

                    b.Property<long>("ContractId")
                        .HasColumnType("bigint");

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

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

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

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

                    b.HasKey("Id");

                    b.HasIndex("ContractId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTaskAttachment", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long?>("AttachmentTypeId")
                        .HasColumnType("bigint");

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

                    b.Property<long>("ContractTaskId")
                        .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")
                        .HasMaxLength(250)
                        .HasColumnType("nvarchar(250)");

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

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

                    b.HasKey("Id");

                    b.HasIndex("ContractTaskId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ContractWorkingDay", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long>("ContractId")
                        .HasColumnType("bigint");

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

                    b.Property<string>("WorkingDay")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.HasKey("Id");

                    b.HasIndex("ContractId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.CountryLookup", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

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

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

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

                    b.HasKey("Id");

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

            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.HubConnection", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

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

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

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

                    b.HasKey("Id");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.Industry", 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("Industries");

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            NameAr = "صناعة الطيران والفضاء",
                            NameEn = "Aerospace industry"
                        },
                        new
                        {
                            Id = 2L,
                            NameAr = "صناعة الزراعة",
                            NameEn = "Agricultural industry"
                        },
                        new
                        {
                            Id = 3L,
                            NameAr = "صناعة السيارات",
                            NameEn = "Automotive industry"
                        },
                        new
                        {
                            Id = 4L,
                            NameAr = "صناعة المعادن الأساسية",
                            NameEn = "Basic metal"
                        },
                        new
                        {
                            Id = 5L,
                            NameAr = "صناعة الكيماويات",
                            NameEn = "Chemical industry"
                        },
                        new
                        {
                            Id = 6L,
                            NameAr = "صناعة الحواسيب",
                            NameEn = "Computer industry"
                        },
                        new
                        {
                            Id = 7L,
                            NameAr = "صناعة البناء",
                            NameEn = "Construction industry"
                        },
                        new
                        {
                            Id = 8L,
                            NameAr = "صناعة الإبداعية",
                            NameEn = "Creative industry"
                        },
                        new
                        {
                            Id = 9L,
                            NameAr = "صناعة الثقافة",
                            NameEn = "Cultural industry"
                        },
                        new
                        {
                            Id = 10L,
                            NameAr = "صناعة الدفاع",
                            NameEn = "Defense industry"
                        },
                        new
                        {
                            Id = 11L,
                            NameAr = "صناعة التعليم",
                            NameEn = "Education industry"
                        },
                        new
                        {
                            Id = 12L,
                            NameAr = "صناعة الطاقة الكهربائية",
                            NameEn = "Electric power"
                        },
                        new
                        {
                            Id = 13L,
                            NameAr = "صناعة الإلكترونيات",
                            NameEn = "Electronics industry"
                        },
                        new
                        {
                            Id = 14L,
                            NameAr = "صناعة الطاقة",
                            NameEn = "Energy industry"
                        },
                        new
                        {
                            Id = 15L,
                            NameAr = "صناعة الهندسة",
                            NameEn = "Engineering industry"
                        },
                        new
                        {
                            Id = 16L,
                            NameAr = "صناعة الترفيه",
                            NameEn = "Entertainment industry"
                        },
                        new
                        {
                            Id = 17L,
                            NameAr = "صناعة الزراعة",
                            NameEn = "Farming industry"
                        },
                        new
                        {
                            Id = 18L,
                            NameAr = "صناعة الموضة",
                            NameEn = "Fashion industry"
                        },
                        new
                        {
                            Id = 19L,
                            NameAr = "صناعة السينما",
                            NameEn = "Film industry"
                        },
                        new
                        {
                            Id = 20L,
                            NameAr = "صناعة الخدمات المالية",
                            NameEn = "Financial services"
                        },
                        new
                        {
                            Id = 21L,
                            NameAr = "صناعة الصيد",
                            NameEn = "Fishing industry"
                        },
                        new
                        {
                            Id = 22L,
                            NameAr = "صناعة الأغذية",
                            NameEn = "Food industry"
                        },
                        new
                        {
                            Id = 23L,
                            NameAr = "صناعة الغابات",
                            NameEn = "Forestry industry"
                        },
                        new
                        {
                            Id = 24L,
                            NameAr = "صناعة القمار",
                            NameEn = "Gambling industry"
                        },
                        new
                        {
                            Id = 25L,
                            NameAr = "صناعة الغاز",
                            NameEn = "Gas industry"
                        },
                        new
                        {
                            Id = 26L,
                            NameAr = "صناعة البيئة",
                            NameEn = "Green industry"
                        },
                        new
                        {
                            Id = 27L,
                            NameAr = "صناعة الخدمات الصحية",
                            NameEn = "Health services industry"
                        },
                        new
                        {
                            Id = 28L,
                            NameAr = "صناعة الضيافة",
                            NameEn = "Hospitality industry"
                        },
                        new
                        {
                            Id = 29L,
                            NameAr = "صناعة الفنادق",
                            NameEn = "Hotels industry"
                        },
                        new
                        {
                            Id = 30L,
                            NameAr = "صناعة الروبوتات الصناعية",
                            NameEn = "Industrial robot"
                        },
                        new
                        {
                            Id = 31L,
                            NameAr = "صناعة المعلومات",
                            NameEn = "Information industry"
                        },
                        new
                        {
                            Id = 32L,
                            NameAr = "صناعة تكنولوجيا المعلومات",
                            NameEn = "Information technology"
                        },
                        new
                        {
                            Id = 33L,
                            NameAr = "صناعة البنية التحتية",
                            NameEn = "Infrastructure industry"
                        },
                        new
                        {
                            Id = 34L,
                            NameAr = "صناعة التأمين",
                            NameEn = "Insurance industry"
                        },
                        new
                        {
                            Id = 35L,
                            NameAr = "صناعة الترفيه",
                            NameEn = "Leisure industry"
                        },
                        new
                        {
                            Id = 36L,
                            NameAr = "صناعة التكنولوجيا المنخفضة",
                            NameEn = "Low technology"
                        },
                        new
                        {
                            Id = 37L,
                            NameAr = "صناعة التصنيع",
                            NameEn = "Manufacturing industry"
                        },
                        new
                        {
                            Id = 38L,
                            NameAr = "صناعة اللحوم",
                            NameEn = "Meat industry"
                        },
                        new
                        {
                            Id = 39L,
                            NameAr = "صناعة الإعلام",
                            NameEn = "Media industry"
                        },
                        new
                        {
                            Id = 40L,
                            NameAr = "صناعة التجارة",
                            NameEn = "Merchandising industry"
                        },
                        new
                        {
                            Id = 41L,
                            NameAr = "صناعة التعدين",
                            NameEn = "Mining industry"
                        },
                        new
                        {
                            Id = 42L,
                            NameAr = "صناعة الموسيقى",
                            NameEn = "Music industry"
                        },
                        new
                        {
                            Id = 43L,
                            NameAr = "صناعة وسائل الإعلام",
                            NameEn = "News media"
                        },
                        new
                        {
                            Id = 44L,
                            NameAr = "صناعة النفط والغاز",
                            NameEn = "Oil and gas industry"
                        },
                        new
                        {
                            Id = 45L,
                            NameAr = "صناعة الأدوية",
                            NameEn = "Pharmaceutical industry"
                        },
                        new
                        {
                            Id = 46L,
                            NameAr = "صناعة المهنية",
                            NameEn = "Professional industry"
                        },
                        new
                        {
                            Id = 47L,
                            NameAr = "صناعة النشر",
                            NameEn = "Publishing industry"
                        },
                        new
                        {
                            Id = 48L,
                            NameAr = "صناعة الورق واللب",
                            NameEn = "Pulp and paper industry"
                        },
                        new
                        {
                            Id = 49L,
                            NameAr = "صناعة السكك الحديدية",
                            NameEn = "Railway industry"
                        },
                        new
                        {
                            Id = 50L,
                            NameAr = "الانشاءات",
                            NameEn = "Real estate"
                        });
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.JobTitle", 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("JobTitles");

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            NameAr = "مساعد ادارى",
                            NameEn = "Administrative Assistant"
                        },
                        new
                        {
                            Id = 2L,
                            NameAr = "موظف استقبال",
                            NameEn = "Receptionist"
                        },
                        new
                        {
                            Id = 3L,
                            NameAr = "مدير مكتب",
                            NameEn = "Office Manager"
                        },
                        new
                        {
                            Id = 4L,
                            NameAr = "مدقق محتوى",
                            NameEn = "Auditing Clerk"
                        },
                        new
                        {
                            Id = 5L,
                            NameAr = "محاسب",
                            NameEn = "Bookkeeper"
                        },
                        new
                        {
                            Id = 6L,
                            NameAr = "مدير تنفيذى",
                            NameEn = "Account Executive"
                        },
                        new
                        {
                            Id = 7L,
                            NameAr = "مدير فرع",
                            NameEn = "Branch Manager"
                        },
                        new
                        {
                            Id = 8L,
                            NameAr = "مدير",
                            NameEn = "Business Manager"
                        },
                        new
                        {
                            Id = 9L,
                            NameAr = "مسؤول الجودة",
                            NameEn = "Quality Control Coordinator"
                        },
                        new
                        {
                            Id = 10L,
                            NameAr = "مدير ادارى",
                            NameEn = "Administrative Manager"
                        },
                        new
                        {
                            Id = 11L,
                            NameAr = "الرئيس التنفيذي",
                            NameEn = "Chief Executive Officer"
                        },
                        new
                        {
                            Id = 12L,
                            NameAr = "محلل",
                            NameEn = "Business Analyst"
                        },
                        new
                        {
                            Id = 13L,
                            NameAr = "مدير المخاطر",
                            NameEn = "Risk Manager"
                        },
                        new
                        {
                            Id = 14L,
                            NameAr = "موارد بشرية",
                            NameEn = "Human Resources"
                        },
                        new
                        {
                            Id = 15L,
                            NameAr = "مساعد مكتب",
                            NameEn = "Office Assistant"
                        },
                        new
                        {
                            Id = 16L,
                            NameAr = "السكرتارية",
                            NameEn = "Secretary"
                        },
                        new
                        {
                            Id = 17L,
                            NameAr = "موظف مكتب",
                            NameEn = "Office Clerk"
                        },
                        new
                        {
                            Id = 18L,
                            NameAr = "جامع الحسابات",
                            NameEn = "Account Collector"
                        },
                        new
                        {
                            Id = 19L,
                            NameAr = "أخصائي إداري",
                            NameEn = "Administrative Specialist"
                        },
                        new
                        {
                            Id = 20L,
                            NameAr = "مساعد تنفيذي",
                            NameEn = "Executive Assistant"
                        },
                        new
                        {
                            Id = 21L,
                            NameAr = "مسؤل البرنامج",
                            NameEn = "Program Administrator"
                        },
                        new
                        {
                            Id = 22L,
                            NameAr = "مدير البرنامج",
                            NameEn = "Program Manager"
                        },
                        new
                        {
                            Id = 23L,
                            NameAr = "محلل إداري",
                            NameEn = "Administrative Analyst"
                        },
                        new
                        {
                            Id = 24L,
                            NameAr = "مدخل بيانات",
                            NameEn = "Data Entry"
                        });
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.LeaveType", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

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

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

                    b.HasKey("Id");

                    b.ToTable("LeaveTypes");

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            DefaultDays = 21,
                            NameAr = "أجازة سنوية",
                            NameEn = "Annual Leave"
                        },
                        new
                        {
                            Id = 2L,
                            DefaultDays = 15,
                            NameAr = "أجازة مرضية",
                            NameEn = "Sick Leave"
                        },
                        new
                        {
                            Id = 3L,
                            DefaultDays = 20,
                            NameAr = "أجازة زواج",
                            NameEn = "Marriage Leave"
                        },
                        new
                        {
                            Id = 4L,
                            DefaultDays = 10,
                            NameAr = "أجازة وضع",
                            NameEn = "Paternity leave"
                        },
                        new
                        {
                            Id = 5L,
                            DefaultDays = 10,
                            NameAr = "أجازة طارئة",
                            NameEn = "Emergency leave"
                        });
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.LoginOTP", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

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

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

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

                    b.HasKey("Id");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long>("CompanyId")
                        .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")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(8);

                    b.Property<string>("Description")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

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

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasColumnOrder(7);

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

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

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

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

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

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

                    b.HasKey("Id");

                    b.HasIndex("CompanyId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingLog", 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("MeetingLogs");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

                    b.Property<string>("AssignedUserName")
                        .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<long>("MeetingId")
                        .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("MeetingId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.Nationality", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

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

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

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            CountryCode = "AF",
                            NameAr = "أفغاني",
                            NameEn = "Afghan"
                        },
                        new
                        {
                            Id = 2L,
                            CountryCode = "AL",
                            NameAr = "ألباني",
                            NameEn = "Albanian"
                        },
                        new
                        {
                            Id = 3L,
                            CountryCode = "DZ",
                            NameAr = "جزائري",
                            NameEn = "Algerian"
                        },
                        new
                        {
                            Id = 4L,
                            CountryCode = "AS",
                            NameAr = "أمريكي ساموي",
                            NameEn = "American Samoan"
                        },
                        new
                        {
                            Id = 5L,
                            CountryCode = "US",
                            NameAr = "أمريكي",
                            NameEn = "American"
                        },
                        new
                        {
                            Id = 6L,
                            CountryCode = "AD",
                            NameAr = "أندوري",
                            NameEn = "Andorran"
                        },
                        new
                        {
                            Id = 7L,
                            CountryCode = "AO",
                            NameAr = "أنغولي",
                            NameEn = "Angolan"
                        },
                        new
                        {
                            Id = 8L,
                            CountryCode = "AI",
                            NameAr = "أنغويلي",
                            NameEn = "Anguillian"
                        },
                        new
                        {
                            Id = 9L,
                            CountryCode = "AG",
                            NameAr = "أنتيغي",
                            NameEn = "Antiguan"
                        },
                        new
                        {
                            Id = 10L,
                            CountryCode = "AR",
                            NameAr = "أرجنتيني",
                            NameEn = "Argentinian"
                        },
                        new
                        {
                            Id = 11L,
                            CountryCode = "AM",
                            NameAr = "أرميني",
                            NameEn = "Armenian"
                        },
                        new
                        {
                            Id = 12L,
                            CountryCode = "AW",
                            NameAr = "أروبي",
                            NameEn = "Aruban"
                        },
                        new
                        {
                            Id = 13L,
                            CountryCode = "AU",
                            NameAr = "أسترالي",
                            NameEn = "Australian"
                        },
                        new
                        {
                            Id = 14L,
                            CountryCode = "AT",
                            NameAr = "نمساوي",
                            NameEn = "Austrian"
                        },
                        new
                        {
                            Id = 15L,
                            CountryCode = "AZ",
                            NameAr = "أذربيجاني",
                            NameEn = "Azerbaijani"
                        },
                        new
                        {
                            Id = 16L,
                            CountryCode = "BS",
                            NameAr = "باهامي",
                            NameEn = "Bahamian"
                        },
                        new
                        {
                            Id = 17L,
                            CountryCode = "BH",
                            NameAr = "بحريني",
                            NameEn = "Bahraini"
                        },
                        new
                        {
                            Id = 18L,
                            CountryCode = "BD",
                            NameAr = "بنغلاديشي",
                            NameEn = "Bangladeshi"
                        },
                        new
                        {
                            Id = 19L,
                            CountryCode = "BB",
                            NameAr = "باربادوسي",
                            NameEn = "Barbadian"
                        },
                        new
                        {
                            Id = 20L,
                            CountryCode = "BY",
                            NameAr = "بيلاروسي",
                            NameEn = "Belarusian"
                        },
                        new
                        {
                            Id = 21L,
                            CountryCode = "BE",
                            NameAr = "بلجيكي",
                            NameEn = "Belgian"
                        },
                        new
                        {
                            Id = 22L,
                            CountryCode = "BZ",
                            NameAr = "بليزي",
                            NameEn = "Belizean"
                        },
                        new
                        {
                            Id = 23L,
                            CountryCode = "BJ",
                            NameAr = "بنيني",
                            NameEn = "Beninese"
                        },
                        new
                        {
                            Id = 24L,
                            CountryCode = "BT",
                            NameAr = "بوتاني",
                            NameEn = "Bhutanese"
                        },
                        new
                        {
                            Id = 25L,
                            CountryCode = "BO",
                            NameAr = "بوليفي",
                            NameEn = "Bolivian"
                        },
                        new
                        {
                            Id = 26L,
                            CountryCode = "BA",
                            NameAr = "بوسني",
                            NameEn = "Bosnian"
                        },
                        new
                        {
                            Id = 27L,
                            CountryCode = "BR",
                            NameAr = "برازيلي",
                            NameEn = "Brazilian"
                        },
                        new
                        {
                            Id = 28L,
                            CountryCode = "GB",
                            NameAr = "بريطاني",
                            NameEn = "British"
                        },
                        new
                        {
                            Id = 29L,
                            CountryCode = "BN",
                            NameAr = "بروني",
                            NameEn = "Bruneian"
                        },
                        new
                        {
                            Id = 30L,
                            CountryCode = "BG",
                            NameAr = "بلغاري",
                            NameEn = "Bulgarian"
                        },
                        new
                        {
                            Id = 31L,
                            CountryCode = "BF",
                            NameAr = "بوركيني",
                            NameEn = "Burkinabe"
                        },
                        new
                        {
                            Id = 32L,
                            CountryCode = "MM",
                            NameAr = "بورمي",
                            NameEn = "Burmese"
                        },
                        new
                        {
                            Id = 33L,
                            CountryCode = "BI",
                            NameAr = "بوروندي",
                            NameEn = "Burundian"
                        },
                        new
                        {
                            Id = 34L,
                            CountryCode = "KH",
                            NameAr = "كمبودي",
                            NameEn = "Cambodian"
                        },
                        new
                        {
                            Id = 35L,
                            CountryCode = "CM",
                            NameAr = "كاميروني",
                            NameEn = "Cameroonian"
                        },
                        new
                        {
                            Id = 36L,
                            CountryCode = "CA",
                            NameAr = "كندي",
                            NameEn = "Canadian"
                        },
                        new
                        {
                            Id = 37L,
                            CountryCode = "CV",
                            NameAr = "الرأس الأخضر",
                            NameEn = "Cape Verdean"
                        },
                        new
                        {
                            Id = 38L,
                            CountryCode = "CF",
                            NameAr = "أفريقي أوسط",
                            NameEn = "Central African"
                        },
                        new
                        {
                            Id = 39L,
                            CountryCode = "TD",
                            NameAr = "تشادي",
                            NameEn = "Chadian"
                        },
                        new
                        {
                            Id = 40L,
                            CountryCode = "CL",
                            NameAr = "تشيلي",
                            NameEn = "Chilean"
                        },
                        new
                        {
                            Id = 41L,
                            CountryCode = "CN",
                            NameAr = "صيني",
                            NameEn = "Chinese"
                        },
                        new
                        {
                            Id = 42L,
                            CountryCode = "CO",
                            NameAr = "كولومبي",
                            NameEn = "Colombian"
                        },
                        new
                        {
                            Id = 43L,
                            CountryCode = "KM",
                            NameAr = "قُمُري",
                            NameEn = "Comorian"
                        },
                        new
                        {
                            Id = 44L,
                            CountryCode = "CG",
                            NameAr = "كونغولي",
                            NameEn = "Congolese"
                        },
                        new
                        {
                            Id = 45L,
                            CountryCode = "CR",
                            NameAr = "كوستاريكي",
                            NameEn = "Costa Rican"
                        },
                        new
                        {
                            Id = 46L,
                            CountryCode = "HR",
                            NameAr = "كرواتي",
                            NameEn = "Croatian"
                        },
                        new
                        {
                            Id = 47L,
                            CountryCode = "CU",
                            NameAr = "كوبي",
                            NameEn = "Cuban"
                        },
                        new
                        {
                            Id = 48L,
                            CountryCode = "CY",
                            NameAr = "قبرصي",
                            NameEn = "Cypriot"
                        },
                        new
                        {
                            Id = 49L,
                            CountryCode = "CZ",
                            NameAr = "تشيكي",
                            NameEn = "Czech"
                        },
                        new
                        {
                            Id = 50L,
                            CountryCode = "DK",
                            NameAr = "دنماركي",
                            NameEn = "Danish"
                        },
                        new
                        {
                            Id = 51L,
                            CountryCode = "DJ",
                            NameAr = "جيبوتي",
                            NameEn = "Djiboutian"
                        },
                        new
                        {
                            Id = 52L,
                            CountryCode = "DO",
                            NameAr = "دومينيكاني",
                            NameEn = "Dominican"
                        },
                        new
                        {
                            Id = 53L,
                            CountryCode = "NL",
                            NameAr = "هولندي",
                            NameEn = "Dutch"
                        },
                        new
                        {
                            Id = 54L,
                            CountryCode = "EC",
                            NameAr = "إكوادوري",
                            NameEn = "Ecuadorean"
                        },
                        new
                        {
                            Id = 55L,
                            CountryCode = "EG",
                            NameAr = "مصري",
                            NameEn = "Egyptian"
                        },
                        new
                        {
                            Id = 56L,
                            CountryCode = "AE",
                            NameAr = "إماراتي",
                            NameEn = "Emirati"
                        },
                        new
                        {
                            Id = 57L,
                            CountryCode = "GQ",
                            NameAr = "غيني استوائي",
                            NameEn = "Equatorial Guinean"
                        },
                        new
                        {
                            Id = 58L,
                            CountryCode = "ER",
                            NameAr = "إريتيري",
                            NameEn = "Eritrean"
                        },
                        new
                        {
                            Id = 59L,
                            CountryCode = "EE",
                            NameAr = "إستوني",
                            NameEn = "Estonian"
                        },
                        new
                        {
                            Id = 60L,
                            CountryCode = "ET",
                            NameAr = "أثيوبي",
                            NameEn = "Ethiopian"
                        },
                        new
                        {
                            Id = 61L,
                            CountryCode = "FJ",
                            NameAr = "فيجي",
                            NameEn = "Fijian"
                        },
                        new
                        {
                            Id = 62L,
                            CountryCode = "FI",
                            NameAr = "فنلندي",
                            NameEn = "Finnish"
                        },
                        new
                        {
                            Id = 63L,
                            CountryCode = "FR",
                            NameAr = "فرنسي",
                            NameEn = "French"
                        },
                        new
                        {
                            Id = 64L,
                            CountryCode = "GA",
                            NameAr = "غابوني",
                            NameEn = "Gabonese"
                        },
                        new
                        {
                            Id = 65L,
                            CountryCode = "GM",
                            NameAr = "غامبي",
                            NameEn = "Gambian"
                        },
                        new
                        {
                            Id = 66L,
                            CountryCode = "GE",
                            NameAr = "جورجي",
                            NameEn = "Georgian"
                        },
                        new
                        {
                            Id = 67L,
                            CountryCode = "DE",
                            NameAr = "ألماني",
                            NameEn = "German"
                        },
                        new
                        {
                            Id = 68L,
                            CountryCode = "GH",
                            NameAr = "غاني",
                            NameEn = "Ghanaian"
                        },
                        new
                        {
                            Id = 69L,
                            CountryCode = "GI",
                            NameAr = "جبل طارق",
                            NameEn = "Gibraltarian"
                        },
                        new
                        {
                            Id = 70L,
                            CountryCode = "GR",
                            NameAr = "يوناني",
                            NameEn = "Greek"
                        },
                        new
                        {
                            Id = 71L,
                            CountryCode = "GL",
                            NameAr = "جرينلندي",
                            NameEn = "Greenlandic"
                        },
                        new
                        {
                            Id = 72L,
                            CountryCode = "GD",
                            NameAr = "غرينادي",
                            NameEn = "Grenadian"
                        },
                        new
                        {
                            Id = 73L,
                            CountryCode = "GU",
                            NameAr = "غوامي",
                            NameEn = "Guamanian"
                        },
                        new
                        {
                            Id = 74L,
                            CountryCode = "GT",
                            NameAr = "غواتيمالي",
                            NameEn = "Guatemalan"
                        },
                        new
                        {
                            Id = 75L,
                            CountryCode = "GN",
                            NameAr = "غيني",
                            NameEn = "Guinean"
                        },
                        new
                        {
                            Id = 76L,
                            CountryCode = "GW",
                            NameAr = "غيني",
                            NameEn = "Guinean"
                        },
                        new
                        {
                            Id = 77L,
                            CountryCode = "GY",
                            NameAr = "غياني",
                            NameEn = "Guyanese"
                        },
                        new
                        {
                            Id = 78L,
                            CountryCode = "HT",
                            NameAr = "هايتي",
                            NameEn = "Haitian"
                        },
                        new
                        {
                            Id = 79L,
                            CountryCode = "HN",
                            NameAr = "هندوراسي",
                            NameEn = "Honduran"
                        },
                        new
                        {
                            Id = 80L,
                            CountryCode = "HK",
                            NameAr = "هونغ كونغي",
                            NameEn = "Hong Konger"
                        },
                        new
                        {
                            Id = 81L,
                            CountryCode = "HU",
                            NameAr = "مجري",
                            NameEn = "Hungarian"
                        },
                        new
                        {
                            Id = 82L,
                            CountryCode = "IS",
                            NameAr = "آيسلندي",
                            NameEn = "Icelander"
                        },
                        new
                        {
                            Id = 83L,
                            CountryCode = "IN",
                            NameAr = "هندي",
                            NameEn = "Indian"
                        },
                        new
                        {
                            Id = 84L,
                            CountryCode = "ID",
                            NameAr = "إندونيسي",
                            NameEn = "Indonesian"
                        },
                        new
                        {
                            Id = 85L,
                            CountryCode = "IR",
                            NameAr = "إيراني",
                            NameEn = "Iranian"
                        },
                        new
                        {
                            Id = 86L,
                            CountryCode = "IQ",
                            NameAr = "عراقي",
                            NameEn = "Iraqi"
                        },
                        new
                        {
                            Id = 87L,
                            CountryCode = "IE",
                            NameAr = "إيرلندي",
                            NameEn = "Irish"
                        },
                        new
                        {
                            Id = 89L,
                            CountryCode = "IT",
                            NameAr = "إيطالي",
                            NameEn = "Italian"
                        },
                        new
                        {
                            Id = 90L,
                            CountryCode = "JM",
                            NameAr = "جامايكي",
                            NameEn = "Jamaican"
                        },
                        new
                        {
                            Id = 91L,
                            CountryCode = "JP",
                            NameAr = "ياباني",
                            NameEn = "Japanese"
                        },
                        new
                        {
                            Id = 92L,
                            CountryCode = "JE",
                            NameAr = "جيرسي",
                            NameEn = "Jersey"
                        },
                        new
                        {
                            Id = 93L,
                            CountryCode = "JO",
                            NameAr = "أردني",
                            NameEn = "Jordanian"
                        },
                        new
                        {
                            Id = 94L,
                            CountryCode = "KZ",
                            NameAr = "كازاخي",
                            NameEn = "Kazakh"
                        },
                        new
                        {
                            Id = 95L,
                            CountryCode = "KE",
                            NameAr = "كيني",
                            NameEn = "Kenyan"
                        },
                        new
                        {
                            Id = 96L,
                            CountryCode = "KI",
                            NameAr = "كيريباتي",
                            NameEn = "Kiribati"
                        },
                        new
                        {
                            Id = 97L,
                            CountryCode = "KP",
                            NameAr = "كوري شمالي",
                            NameEn = "North Korean"
                        },
                        new
                        {
                            Id = 98L,
                            CountryCode = "KR",
                            NameAr = "كوري جنوبي",
                            NameEn = "South Korean"
                        },
                        new
                        {
                            Id = 99L,
                            CountryCode = "KW",
                            NameAr = "كويتي",
                            NameEn = "Kuwaiti"
                        },
                        new
                        {
                            Id = 100L,
                            CountryCode = "KG",
                            NameAr = "قرغيزستاني",
                            NameEn = "Kyrgyzstani"
                        },
                        new
                        {
                            Id = 101L,
                            CountryCode = "LA",
                            NameAr = "لاوي",
                            NameEn = "Lao"
                        },
                        new
                        {
                            Id = 102L,
                            CountryCode = "LV",
                            NameAr = "لاتفي",
                            NameEn = "Latvian"
                        },
                        new
                        {
                            Id = 103L,
                            CountryCode = "LB",
                            NameAr = "لبناني",
                            NameEn = "Lebanese"
                        },
                        new
                        {
                            Id = 104L,
                            CountryCode = "LS",
                            NameAr = "ليسوتو",
                            NameEn = "Lesotho"
                        },
                        new
                        {
                            Id = 105L,
                            CountryCode = "LR",
                            NameAr = "ليبيريي",
                            NameEn = "Liberian"
                        },
                        new
                        {
                            Id = 106L,
                            CountryCode = "LY",
                            NameAr = "ليبي",
                            NameEn = "Libyan"
                        },
                        new
                        {
                            Id = 107L,
                            CountryCode = "LI",
                            NameAr = "ليختنشتايني",
                            NameEn = "Liechtensteiner"
                        },
                        new
                        {
                            Id = 108L,
                            CountryCode = "LT",
                            NameAr = "ليتواني",
                            NameEn = "Lithuanian"
                        },
                        new
                        {
                            Id = 109L,
                            CountryCode = "LU",
                            NameAr = "لوكسمبورغي",
                            NameEn = "Luxembourgish"
                        },
                        new
                        {
                            Id = 110L,
                            CountryCode = "MG",
                            NameAr = "ملغاشي",
                            NameEn = "Malagasy"
                        },
                        new
                        {
                            Id = 111L,
                            CountryCode = "MW",
                            NameAr = "ملووي",
                            NameEn = "Malawian"
                        },
                        new
                        {
                            Id = 112L,
                            CountryCode = "MY",
                            NameAr = "ماليزيا",
                            NameEn = "Malaysian"
                        },
                        new
                        {
                            Id = 113L,
                            CountryCode = "MV",
                            NameAr = "مالديفي",
                            NameEn = "Maldivian"
                        },
                        new
                        {
                            Id = 114L,
                            CountryCode = "ML",
                            NameAr = "مالي",
                            NameEn = "Malian"
                        },
                        new
                        {
                            Id = 115L,
                            CountryCode = "MT",
                            NameAr = "مالطي",
                            NameEn = "Maltese"
                        },
                        new
                        {
                            Id = 116L,
                            CountryCode = "MH",
                            NameAr = "مارشالي",
                            NameEn = "Marshallese"
                        },
                        new
                        {
                            Id = 117L,
                            CountryCode = "MR",
                            NameAr = "موريتاني",
                            NameEn = "Mauritanian"
                        },
                        new
                        {
                            Id = 118L,
                            CountryCode = "MU",
                            NameAr = "موريشيوسي",
                            NameEn = "Mauritian"
                        },
                        new
                        {
                            Id = 119L,
                            CountryCode = "MX",
                            NameAr = "مكسيكي",
                            NameEn = "Mexican"
                        },
                        new
                        {
                            Id = 120L,
                            CountryCode = "FM",
                            NameAr = "ماكروني",
                            NameEn = "Micronesian"
                        },
                        new
                        {
                            Id = 121L,
                            CountryCode = "MD",
                            NameAr = "مولدوفي",
                            NameEn = "Moldovan"
                        },
                        new
                        {
                            Id = 122L,
                            CountryCode = "MC",
                            NameAr = "موناكي",
                            NameEn = "Monacan"
                        },
                        new
                        {
                            Id = 123L,
                            CountryCode = "MN",
                            NameAr = "منغولي",
                            NameEn = "Mongolian"
                        },
                        new
                        {
                            Id = 124L,
                            CountryCode = "ME",
                            NameAr = "مونتينيغري",
                            NameEn = "Montenegrin"
                        },
                        new
                        {
                            Id = 125L,
                            CountryCode = "MA",
                            NameAr = "مغربي",
                            NameEn = "Moroccan"
                        },
                        new
                        {
                            Id = 126L,
                            CountryCode = "MZ",
                            NameAr = "موزمبيقي",
                            NameEn = "Mozambican"
                        },
                        new
                        {
                            Id = 127L,
                            CountryCode = "NA",
                            NameAr = "ناميبي",
                            NameEn = "Namibian"
                        },
                        new
                        {
                            Id = 128L,
                            CountryCode = "NR",
                            NameAr = "نيواروي",
                            NameEn = "Nauruan"
                        },
                        new
                        {
                            Id = 129L,
                            CountryCode = "NP",
                            NameAr = "نيبالي",
                            NameEn = "Nepali"
                        },
                        new
                        {
                            Id = 130L,
                            CountryCode = "NL",
                            NameAr = "هولندي",
                            NameEn = "Dutch"
                        },
                        new
                        {
                            Id = 131L,
                            CountryCode = "NZ",
                            NameAr = "نيوزيلندي",
                            NameEn = "New Zealander"
                        },
                        new
                        {
                            Id = 132L,
                            CountryCode = "NI",
                            NameAr = "نيكاراغوي",
                            NameEn = "Nicaraguan"
                        },
                        new
                        {
                            Id = 133L,
                            CountryCode = "NE",
                            NameAr = "نيجيري",
                            NameEn = "Nigerien"
                        },
                        new
                        {
                            Id = 134L,
                            CountryCode = "NG",
                            NameAr = "نيجيري",
                            NameEn = "Nigerian"
                        },
                        new
                        {
                            Id = 135L,
                            CountryCode = "MK",
                            NameAr = "مقدوني شمالي",
                            NameEn = "North Macedonian"
                        },
                        new
                        {
                            Id = 136L,
                            CountryCode = "NO",
                            NameAr = "نرويجي",
                            NameEn = "Norwegian"
                        },
                        new
                        {
                            Id = 137L,
                            CountryCode = "OM",
                            NameAr = "عماني",
                            NameEn = "Omani"
                        },
                        new
                        {
                            Id = 138L,
                            CountryCode = "PK",
                            NameAr = "باكستاني",
                            NameEn = "Pakistani"
                        },
                        new
                        {
                            Id = 139L,
                            CountryCode = "PW",
                            NameAr = "بالاوي",
                            NameEn = "Palauan"
                        },
                        new
                        {
                            Id = 140L,
                            CountryCode = "PA",
                            NameAr = "بنمي",
                            NameEn = "Panamanian"
                        },
                        new
                        {
                            Id = 141L,
                            CountryCode = "PG",
                            NameAr = "بابوا غينيا الجديدة",
                            NameEn = "Papua New Guinean"
                        },
                        new
                        {
                            Id = 142L,
                            CountryCode = "PY",
                            NameAr = "باراغواني",
                            NameEn = "Paraguayan"
                        },
                        new
                        {
                            Id = 143L,
                            CountryCode = "PE",
                            NameAr = "بيروفي",
                            NameEn = "Peruvian"
                        },
                        new
                        {
                            Id = 144L,
                            CountryCode = "PH",
                            NameAr = "فلبيني",
                            NameEn = "Filipino"
                        },
                        new
                        {
                            Id = 145L,
                            CountryCode = "PL",
                            NameAr = "بولندي",
                            NameEn = "Polish"
                        },
                        new
                        {
                            Id = 146L,
                            CountryCode = "PT",
                            NameAr = "برتغالي",
                            NameEn = "Portuguese"
                        },
                        new
                        {
                            Id = 147L,
                            CountryCode = "QA",
                            NameAr = "قطري",
                            NameEn = "Qatari"
                        },
                        new
                        {
                            Id = 148L,
                            CountryCode = "RE",
                            NameAr = "لا ريونيون",
                            NameEn = "Réunionese"
                        },
                        new
                        {
                            Id = 149L,
                            CountryCode = "RO",
                            NameAr = "روماني",
                            NameEn = "Romanian"
                        },
                        new
                        {
                            Id = 150L,
                            CountryCode = "RU",
                            NameAr = "روسي",
                            NameEn = "Russian"
                        },
                        new
                        {
                            Id = 151L,
                            CountryCode = "RW",
                            NameAr = "رواندي",
                            NameEn = "Rwandan"
                        },
                        new
                        {
                            Id = 152L,
                            CountryCode = "BL",
                            NameAr = "سانت بارتيليمي",
                            NameEn = "Saint Barthélemy"
                        },
                        new
                        {
                            Id = 153L,
                            CountryCode = "SH",
                            NameAr = "سانت هيلاني",
                            NameEn = "Saint Helenian"
                        },
                        new
                        {
                            Id = 154L,
                            CountryCode = "KN",
                            NameAr = "سانت كيتس ونيفيس",
                            NameEn = "Saint Kitts and Nevis"
                        },
                        new
                        {
                            Id = 155L,
                            CountryCode = "LC",
                            NameAr = "سانت لوسيان",
                            NameEn = "Saint Lucian"
                        },
                        new
                        {
                            Id = 156L,
                            CountryCode = "MF",
                            NameAr = "سانت مارتن",
                            NameEn = "Saint Martin"
                        },
                        new
                        {
                            Id = 157L,
                            CountryCode = "SX",
                            NameAr = "سانت مارتن",
                            NameEn = "Sint Maarten"
                        },
                        new
                        {
                            Id = 158L,
                            CountryCode = "WS",
                            NameAr = "سماوي",
                            NameEn = "Samoan"
                        },
                        new
                        {
                            Id = 159L,
                            CountryCode = "SM",
                            NameAr = "سانماريني",
                            NameEn = "Sammarinese"
                        },
                        new
                        {
                            Id = 160L,
                            CountryCode = "ST",
                            NameAr = "ساو توماني",
                            NameEn = "Sao Tomean"
                        },
                        new
                        {
                            Id = 161L,
                            CountryCode = "SA",
                            NameAr = "سعودي",
                            NameEn = "Saudi"
                        },
                        new
                        {
                            Id = 162L,
                            CountryCode = "SN",
                            NameAr = "سنغالي",
                            NameEn = "Senegalese"
                        },
                        new
                        {
                            Id = 163L,
                            CountryCode = "RS",
                            NameAr = "صربي",
                            NameEn = "Serbian"
                        },
                        new
                        {
                            Id = 164L,
                            CountryCode = "SC",
                            NameAr = "سيشلي",
                            NameEn = "Seychellois"
                        },
                        new
                        {
                            Id = 165L,
                            CountryCode = "SL",
                            NameAr = "سيراليوني",
                            NameEn = "Sierra Leonean"
                        },
                        new
                        {
                            Id = 166L,
                            CountryCode = "SG",
                            NameAr = "سنغافوري",
                            NameEn = "Singaporean"
                        },
                        new
                        {
                            Id = 167L,
                            CountryCode = "SK",
                            NameAr = "سلوفاكي",
                            NameEn = "Slovak"
                        },
                        new
                        {
                            Id = 168L,
                            CountryCode = "SI",
                            NameAr = "سلوفيني",
                            NameEn = "Slovenian"
                        },
                        new
                        {
                            Id = 169L,
                            CountryCode = "SB",
                            NameAr = "سولوموني",
                            NameEn = "Solomon Islander"
                        },
                        new
                        {
                            Id = 170L,
                            CountryCode = "SO",
                            NameAr = "صومالي",
                            NameEn = "Somali"
                        },
                        new
                        {
                            Id = 171L,
                            CountryCode = "ZA",
                            NameAr = "جنوب أفريقي",
                            NameEn = "South African"
                        },
                        new
                        {
                            Id = 172L,
                            CountryCode = "SS",
                            NameAr = "جنوب سوداني",
                            NameEn = "South Sudanese"
                        },
                        new
                        {
                            Id = 173L,
                            CountryCode = "ES",
                            NameAr = "إسباني",
                            NameEn = "Spanish"
                        },
                        new
                        {
                            Id = 174L,
                            CountryCode = "LK",
                            NameAr = "سريلانكي",
                            NameEn = "Sri Lankan"
                        },
                        new
                        {
                            Id = 175L,
                            CountryCode = "SD",
                            NameAr = "سوداني",
                            NameEn = "Sudanese"
                        },
                        new
                        {
                            Id = 176L,
                            CountryCode = "SR",
                            NameAr = "سورينامي",
                            NameEn = "Surinamese"
                        },
                        new
                        {
                            Id = 177L,
                            CountryCode = "SZ",
                            NameAr = "سواتي",
                            NameEn = "Swazi"
                        },
                        new
                        {
                            Id = 178L,
                            CountryCode = "SE",
                            NameAr = "سويدي",
                            NameEn = "Swedish"
                        },
                        new
                        {
                            Id = 179L,
                            CountryCode = "CH",
                            NameAr = "سويسري",
                            NameEn = "Swiss"
                        },
                        new
                        {
                            Id = 180L,
                            CountryCode = "SY",
                            NameAr = "سوري",
                            NameEn = "Syrian"
                        },
                        new
                        {
                            Id = 181L,
                            CountryCode = "TW",
                            NameAr = "تايواني",
                            NameEn = "Taiwanese"
                        },
                        new
                        {
                            Id = 182L,
                            CountryCode = "TJ",
                            NameAr = "طاجيكي",
                            NameEn = "Tajik"
                        },
                        new
                        {
                            Id = 183L,
                            CountryCode = "TZ",
                            NameAr = "تنزاني",
                            NameEn = "Tanzanian"
                        },
                        new
                        {
                            Id = 184L,
                            CountryCode = "TH",
                            NameAr = "تايلندي",
                            NameEn = "Thai"
                        },
                        new
                        {
                            Id = 185L,
                            CountryCode = "TL",
                            NameAr = "تيموري",
                            NameEn = "Timorese"
                        },
                        new
                        {
                            Id = 186L,
                            CountryCode = "TG",
                            NameAr = "توغولي",
                            NameEn = "Togolese"
                        },
                        new
                        {
                            Id = 187L,
                            CountryCode = "TK",
                            NameAr = "توكلاوي",
                            NameEn = "Tokelauan"
                        },
                        new
                        {
                            Id = 188L,
                            CountryCode = "TO",
                            NameAr = "تونغي",
                            NameEn = "Tongan"
                        },
                        new
                        {
                            Id = 189L,
                            CountryCode = "TT",
                            NameAr = "ترينيدادي",
                            NameEn = "Trinidadian"
                        },
                        new
                        {
                            Id = 190L,
                            CountryCode = "TN",
                            NameAr = "تونسي",
                            NameEn = "Tunisian"
                        },
                        new
                        {
                            Id = 191L,
                            CountryCode = "TR",
                            NameAr = "تركي",
                            NameEn = "Turkish"
                        },
                        new
                        {
                            Id = 192L,
                            CountryCode = "TM",
                            NameAr = "تركماني",
                            NameEn = "Turkmen"
                        },
                        new
                        {
                            Id = 193L,
                            CountryCode = "TC",
                            NameAr = "تركي وكايكوسي",
                            NameEn = "Turks and Caicos Islander"
                        },
                        new
                        {
                            Id = 194L,
                            CountryCode = "TV",
                            NameAr = "توفالي",
                            NameEn = "Tuvaluan"
                        },
                        new
                        {
                            Id = 195L,
                            CountryCode = "UG",
                            NameAr = "أوغندي",
                            NameEn = "Ugandan"
                        },
                        new
                        {
                            Id = 196L,
                            CountryCode = "UA",
                            NameAr = "أوكراني",
                            NameEn = "Ukrainian"
                        },
                        new
                        {
                            Id = 197L,
                            CountryCode = "AE",
                            NameAr = "إماراتي",
                            NameEn = "Emirati"
                        },
                        new
                        {
                            Id = 198L,
                            CountryCode = "GB",
                            NameAr = "بريطاني",
                            NameEn = "British"
                        },
                        new
                        {
                            Id = 199L,
                            CountryCode = "US",
                            NameAr = "أمريكي",
                            NameEn = "American"
                        },
                        new
                        {
                            Id = 200L,
                            CountryCode = "UY",
                            NameAr = "أوروغواي",
                            NameEn = "Uruguayan"
                        },
                        new
                        {
                            Id = 201L,
                            CountryCode = "UZ",
                            NameAr = "أوزبكي",
                            NameEn = "Uzbek"
                        },
                        new
                        {
                            Id = 202L,
                            CountryCode = "VU",
                            NameAr = "فانواتي",
                            NameEn = "Vanuatuan"
                        },
                        new
                        {
                            Id = 203L,
                            CountryCode = "VE",
                            NameAr = "فنزويلي",
                            NameEn = "Venezuelan"
                        },
                        new
                        {
                            Id = 204L,
                            CountryCode = "VN",
                            NameAr = "فيتنامي",
                            NameEn = "Vietnamese"
                        },
                        new
                        {
                            Id = 205L,
                            CountryCode = "WF",
                            NameAr = "واليس وفوتونا",
                            NameEn = "Wallis and Futuna"
                        },
                        new
                        {
                            Id = 206L,
                            CountryCode = "YE",
                            NameAr = "يمني",
                            NameEn = "Yemeni"
                        },
                        new
                        {
                            Id = 207L,
                            CountryCode = "ZM",
                            NameAr = "زامبي",
                            NameEn = "Zambian"
                        },
                        new
                        {
                            Id = 208L,
                            CountryCode = "ZW",
                            NameAr = "زيمبابوي",
                            NameEn = "Zimbabwean"
                        });
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.OrderAllocation", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long>("CompanyId")
                        .HasColumnType("bigint");

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

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

                    b.Property<long?>("LeaveTypeId")
                        .HasColumnType("bigint");

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

                    b.Property<long>("OrderTypeId")
                        .HasColumnType("bigint");

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

                    b.HasKey("Id");

                    b.HasIndex("CompanyId");

                    b.HasIndex("LeaveTypeId");

                    b.HasIndex("OrderTypeId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.OrderType", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

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

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

                    b.HasKey("Id");

                    b.ToTable("OrderTypes");

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            DefaultDays = 2,
                            NameAr = "إذن",
                            NameEn = "Leave"
                        },
                        new
                        {
                            Id = 2L,
                            DefaultDays = 15,
                            NameAr = "طبية",
                            NameEn = "Medical"
                        },
                        new
                        {
                            Id = 3L,
                            DefaultDays = 20,
                            NameAr = "وقت إضافي",
                            NameEn = "Overtime"
                        },
                        new
                        {
                            Id = 4L,
                            DefaultDays = 0,
                            NameAr = "رحلة عمل",
                            NameEn = "Business trip"
                        },
                        new
                        {
                            Id = 5L,
                            DefaultDays = 0,
                            NameAr = "دورة تدريبية",
                            NameEn = "Course"
                        });
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.Permission", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<string>("CategoryName")
                        .IsRequired()
                        .HasMaxLength(150)
                        .HasColumnType("nvarchar(150)");

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

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

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

                    b.HasKey("Id");

                    b.ToTable("Permissions");

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            CategoryName = "User",
                            Desc = "Project",
                            Name = "Project",
                            Show = true
                        },
                        new
                        {
                            Id = 2L,
                            CategoryName = "User",
                            Desc = "Project.Create",
                            Name = "Project.Create",
                            Show = false
                        },
                        new
                        {
                            Id = 3L,
                            CategoryName = "User",
                            Desc = "Project.Update",
                            Name = "Project.Update",
                            Show = false
                        },
                        new
                        {
                            Id = 4L,
                            CategoryName = "User",
                            Desc = "Project.Delete",
                            Name = "Project.Delete",
                            Show = false
                        },
                        new
                        {
                            Id = 5L,
                            CategoryName = "User",
                            Desc = "Meeting",
                            Name = "Meeting",
                            Show = true
                        },
                        new
                        {
                            Id = 6L,
                            CategoryName = "User",
                            Desc = "Meeting.Create",
                            Name = "Meeting.Create",
                            Show = false
                        },
                        new
                        {
                            Id = 7L,
                            CategoryName = "User",
                            Desc = "Meeting.Update",
                            Name = "Meeting.Update",
                            Show = false
                        },
                        new
                        {
                            Id = 8L,
                            CategoryName = "User",
                            Desc = "Meeting.Delete",
                            Name = "Meeting.Delete",
                            Show = false
                        },
                        new
                        {
                            Id = 9L,
                            CategoryName = "User",
                            Desc = "Team",
                            Name = "Team",
                            Show = true
                        },
                        new
                        {
                            Id = 10L,
                            CategoryName = "User",
                            Desc = "Team.Create",
                            Name = "Team.Create",
                            Show = false
                        },
                        new
                        {
                            Id = 11L,
                            CategoryName = "User",
                            Desc = "Team.Update",
                            Name = "Team.Update",
                            Show = false
                        },
                        new
                        {
                            Id = 12L,
                            CategoryName = "User",
                            Desc = "Team.Delete",
                            Name = "Team.Delete",
                            Show = false
                        },
                        new
                        {
                            Id = 13L,
                            CategoryName = "Sales",
                            Desc = "UserTask",
                            Name = "UserTask",
                            Show = true
                        },
                        new
                        {
                            Id = 14L,
                            CategoryName = "Sales",
                            Desc = "UserTask.Create",
                            Name = "UserTask.Create",
                            Show = false
                        },
                        new
                        {
                            Id = 15L,
                            CategoryName = "Sales",
                            Desc = "UserTask.Update",
                            Name = "UserTask.Update",
                            Show = false
                        },
                        new
                        {
                            Id = 16L,
                            CategoryName = "User",
                            Desc = "UserTask.Delete",
                            Name = "UserTask.Delete",
                            Show = false
                        },
                        new
                        {
                            Id = 17L,
                            CategoryName = "User",
                            Desc = "Company",
                            Name = "Company",
                            Show = true
                        },
                        new
                        {
                            Id = 18L,
                            CategoryName = "User",
                            Desc = "Company.Create",
                            Name = "Company.Create",
                            Show = false
                        },
                        new
                        {
                            Id = 19L,
                            CategoryName = "User",
                            Desc = "Company.Update",
                            Name = "Company.Update",
                            Show = false
                        },
                        new
                        {
                            Id = 20L,
                            CategoryName = "User",
                            Desc = "Company.Delete",
                            Name = "Company.Delete",
                            Show = false
                        },
                        new
                        {
                            Id = 21L,
                            CategoryName = "Adminstration",
                            Desc = "User",
                            Name = "User",
                            Show = true
                        },
                        new
                        {
                            Id = 22L,
                            CategoryName = "Adminstration",
                            Desc = "User.Create",
                            Name = "User.Create",
                            Show = false
                        },
                        new
                        {
                            Id = 23L,
                            CategoryName = "Adminstration",
                            Desc = "User.Update",
                            Name = "User.Update",
                            Show = false
                        },
                        new
                        {
                            Id = 24L,
                            CategoryName = "Adminstration",
                            Desc = "User.Delete",
                            Name = "User.Delete",
                            Show = false
                        },
                        new
                        {
                            Id = 25L,
                            CategoryName = "Adminstration",
                            Desc = "Role",
                            Name = "Role",
                            Show = true
                        },
                        new
                        {
                            Id = 26L,
                            CategoryName = "Adminstration",
                            Desc = "Role.Create",
                            Name = "Role.Create",
                            Show = false
                        },
                        new
                        {
                            Id = 27L,
                            CategoryName = "Adminstration",
                            Desc = "Role.Update",
                            Name = "Role.Update",
                            Show = false
                        },
                        new
                        {
                            Id = 28L,
                            CategoryName = "Adminstration",
                            Desc = "Role.Delete",
                            Name = "Role.Delete",
                            Show = false
                        });
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long>("CompanyId")
                        .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")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(8);

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

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasColumnOrder(7);

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

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

                    b.HasKey("Id");

                    b.HasIndex("CompanyId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStage", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<decimal?>("AmountPercent")
                        .HasColumnType("decimal(18,2)");

                    b.Property<long>("ContractId")
                        .HasColumnType("bigint");

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

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

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

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

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

                    b.HasKey("Id");

                    b.HasIndex("ContractId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStageAttachment", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long?>("AttachmentTypeId")
                        .HasColumnType("bigint");

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

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

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

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

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

                    b.Property<long>("ProjectStageId")
                        .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("ProjectStageId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectTeam", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

                    b.Property<long>("ProjectId")
                        .HasColumnType("bigint");

                    b.Property<long>("TeamId")
                        .HasColumnType("bigint");

                    b.Property<string>("TeamName")
                        .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.ToTable("ProjectTeam");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.Qualification", 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("Qualifications");

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            NameAr = "بكالوريوس",
                            NameEn = "BSC"
                        },
                        new
                        {
                            Id = 2L,
                            NameAr = "درجة الماجيستير",
                            NameEn = "Master"
                        },
                        new
                        {
                            Id = 3L,
                            NameAr = "درحة الدكتوراه",
                            NameEn = "Doctor"
                        });
                });

            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.TaskUser", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

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

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

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

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long>("CompanyId")
                        .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")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(8);

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasColumnOrder(7);

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

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

                    b.HasKey("Id");

                    b.HasIndex("CompanyId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.TeamLog", 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("TeamLogs");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

                    b.Property<string>("AssignedUserName")
                        .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>("IsAdmin")
                        .HasColumnType("bit");

                    b.Property<long>("TeamId")
                        .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("TeamId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.University", 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("Universities");

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            NameAr = "جامعة الملك فهد",
                            NameEn = "Fahd Univ"
                        },
                        new
                        {
                            Id = 2L,
                            NameAr = "جامعة الرياض",
                            NameEn = "Riydh Univ"
                        },
                        new
                        {
                            Id = 3L,
                            NameAr = "جامعة جدة",
                            NameEn = "Geda Univ"
                        });
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.User.OrderRequest", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<int?>("CityId")
                        .HasColumnType("int");

                    b.Property<long>("CompanyId")
                        .HasColumnType("bigint");

                    b.Property<int?>("CountryId")
                        .HasColumnType("int");

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

                    b.Property<string>("DeleteUserId")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(8);

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

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

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasColumnOrder(7);

                    b.Property<long?>("LeaveTypeId")
                        .HasColumnType("bigint");

                    b.Property<int?>("OrderStatus")
                        .HasColumnType("int");

                    b.Property<long>("OrderTypeId")
                        .HasColumnType("bigint");

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

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

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

                    b.Property<string>("StartTime")
                        .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("CompanyId");

                    b.HasIndex("LeaveTypeId");

                    b.HasIndex("OrderTypeId");

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

            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<string>("AssignedUserId")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)");

                    b.Property<long>("CompanyId")
                        .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")
                        .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("CompanyId");

                    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<byte[]>("Content")
                        .IsRequired()
                        .HasColumnType("varbinary(max)");

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

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

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

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

                    b.Property<string>("OriginalName")
                        .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<string>("AssignedToUserId")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Comment")
                        .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<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("CurrentStatusId");

                    b.HasIndex("TaskId");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskLog", 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("UserTaskLogs");
                });

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

                    b.HasData(
                        new
                        {
                            Id = 1L,
                            NameAr = "جديدة",
                            NameEn = "To Do"
                        },
                        new
                        {
                            Id = 2L,
                            NameAr = "قيد العمل",
                            NameEn = "In progress"
                        },
                        new
                        {
                            Id = 3L,
                            NameAr = "تحتاج مراجعة",
                            NameEn = "Need Review"
                        },
                        new
                        {
                            Id = 4L,
                            NameAr = "تمت",
                            NameEn = "Done"
                        });
                });

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b =>
                {
                    b.Property<string>("Id")
                        .HasColumnType("nvarchar(450)");

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

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

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

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

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

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

                    b.Property<string>("Name")
                        .HasMaxLength(256)
                        .HasColumnType("nvarchar(256)");

                    b.Property<string>("NormalizedName")
                        .HasMaxLength(256)
                        .HasColumnType("nvarchar(256)");

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

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

                    b.HasKey("Id");

                    b.HasIndex("NormalizedName")
                        .IsUnique()
                        .HasDatabaseName("RoleNameIndex")
                        .HasFilter("[NormalizedName] IS NOT NULL");

                    b.ToTable("AspNetRoles", (string)null);

                    b.HasData(
                        new
                        {
                            Id = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A",
                            CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
                            IsAdmin = true,
                            IsDeleted = false,
                            Name = "Admin",
                            NormalizedName = "ADMIN"
                        },
                        new
                        {
                            Id = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E",
                            CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
                            IsAdmin = false,
                            IsDeleted = false,
                            Name = "Employee",
                            NormalizedName = "EMPLOYEE"
                        },
                        new
                        {
                            Id = "CO5B3B92-2311-48F8-9DEC-F9FAEF1F211R",
                            CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
                            IsAdmin = false,
                            IsDeleted = false,
                            Name = "Contractor",
                            NormalizedName = "CONTRACTOR"
                        },
                        new
                        {
                            Id = "BS5B3B92-2311-48F8-9DEC-F9FAEF1F2110",
                            CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
                            IsAdmin = false,
                            IsDeleted = false,
                            Name = "Business",
                            NormalizedName = "BUSINESS"
                        });
                });

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
                {
                    b.Property<string>("Id")
                        .HasColumnType("nvarchar(450)");

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

                    b.Property<long?>("CompanyId")
                        .HasColumnType("bigint");

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

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

                    b.Property<long?>("CountryId")
                        .HasColumnType("bigint");

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

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

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

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

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

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

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

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

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

                    b.Property<decimal?>("IncomeTaxValue")
                        .HasColumnType("decimal(18,2)");

                    b.Property<long?>("IndustryId")
                        .HasColumnType("bigint");

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

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

                    b.Property<long?>("JobTitleId")
                        .HasColumnType("bigint");

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

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

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

                    b.Property<DateTimeOffset?>("LockoutEnd")
                        .HasColumnType("datetimeoffset");

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

                    b.Property<long?>("NationalityId")
                        .HasColumnType("bigint");

                    b.Property<string>("NormalizedEmail")
                        .HasMaxLength(256)
                        .HasColumnType("nvarchar(256)");

                    b.Property<string>("NormalizedUserName")
                        .HasMaxLength(256)
                        .HasColumnType("nvarchar(256)");

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

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

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

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

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

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

                    b.Property<long?>("QualificationId")
                        .HasColumnType("bigint");

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

                    b.Property<decimal?>("TaxNumber")
                        .HasColumnType("decimal(18,2)");

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

                    b.Property<long?>("UniversityId")
                        .HasColumnType("bigint");

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

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

                    b.Property<string>("UserName")
                        .HasMaxLength(256)
                        .HasColumnType("nvarchar(256)");

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

                    b.HasKey("Id");

                    b.HasIndex("CountryId");

                    b.HasIndex("IndustryId");

                    b.HasIndex("JobTitleId");

                    b.HasIndex("ManagerId");

                    b.HasIndex("NationalityId");

                    b.HasIndex("NormalizedEmail")
                        .HasDatabaseName("EmailIndex");

                    b.HasIndex("NormalizedUserName")
                        .IsUnique()
                        .HasDatabaseName("UserNameIndex")
                        .HasFilter("[NormalizedUserName] IS NOT NULL");

                    b.HasIndex("QualificationId");

                    b.HasIndex("UniversityId");

                    b.ToTable("AspNetUsers", (string)null);

                    b.HasData(
                        new
                        {
                            Id = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA",
                            AccessFailedCount = 0,
                            CompanyId = 1L,
                            ConcurrencyStamp = "7cc87689-9eab-4280-b8e3-1834080783a5",
                            DateOfBirth = new DateTime(2000, 2, 10, 0, 0, 0, 0, DateTimeKind.Unspecified),
                            Email = "a@b.com",
                            EmailConfirmed = true,
                            FirstName = "Zinab",
                            IdNumber = "123",
                            IncomeTaxValue = 1m,
                            IsDeleted = false,
                            IsStopped = false,
                            LastName = "Elgendy",
                            LockoutEnabled = false,
                            NormalizedEmail = "A@B.COM",
                            NormalizedUserName = "A@B.COM",
                            PassportNumber = "1234567",
                            PasswordHash = "AQAAAAIAAYagAAAAEPg+ASbciPFxtyxQq8Wx5ilBUQ0RbAoITXXkOQm1PzC5BzySX0sn/wUmOjBKPDGV9w==",
                            PhoneNumber = "1234567890",
                            PhoneNumberConfirmed = true,
                            SecurityStamp = "49bb16c3-4704-4c60-908d-dc8506950acc",
                            TaxNumber = 111m,
                            TwoFactorEnabled = false,
                            UserName = "A@b.com",
                            UserType = 1
                        },
                        new
                        {
                            Id = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB",
                            AccessFailedCount = 0,
                            CompanyId = 1L,
                            ConcurrencyStamp = "4af7b4cf-802a-455b-b598-997e167745b3",
                            DateOfBirth = new DateTime(2001, 5, 13, 0, 0, 0, 0, DateTimeKind.Unspecified),
                            Email = "ali@b.com",
                            EmailConfirmed = true,
                            FirstName = "Ali",
                            IdNumber = "343434",
                            IncomeTaxValue = 100m,
                            IsDeleted = false,
                            IsStopped = false,
                            LastName = "Farok",
                            LockoutEnabled = false,
                            NormalizedEmail = "ALI@B.COM",
                            NormalizedUserName = "ALI@B.COM",
                            PassportNumber = "7654321001010",
                            PasswordHash = "AQAAAAIAAYagAAAAEI3QJkcZjCH4Y8Db4rEgL8Mmll5oCvYcWiXZjQSN9bGW4SMcjHe3ZPMnkN/l9DmJeQ==",
                            PhoneNumber = "1234567888",
                            PhoneNumberConfirmed = true,
                            SecurityStamp = "62549056-1b9d-46d4-84f8-adea3e4d8b68",
                            TaxNumber = 222m,
                            TwoFactorEnabled = false,
                            UserName = "Ali@b.com",
                            UserType = 1
                        });
                });

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long>("PermissionId")
                        .HasColumnType("bigint");

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

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

                    b.HasKey("Id");

                    b.HasIndex("PermissionId");

                    b.HasIndex("RoleId");

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

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAddress", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

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

                    b.Property<long?>("CityId")
                        .HasColumnType("bigint");

                    b.Property<long?>("CountryId")
                        .HasColumnType("bigint");

                    b.Property<DateTime>("CreateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(3);

                    b.Property<string>("CreateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(1);

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

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

                    b.HasKey("Id");

                    b.HasIndex("CityId");

                    b.HasIndex("CountryId");

                    b.HasIndex("UserId")
                        .IsUnique();

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

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnOrder(0);

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));

                    b.Property<long>("AttachmentTypeId")
                        .HasColumnType("bigint");

                    b.Property<byte[]>("Content")
                        .IsRequired()
                        .HasColumnType("varbinary(max)");

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

                    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>("FilePath")
                        .HasColumnType("nvarchar(max)");

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

                    b.Property<DateTime?>("UpdateDate")
                        .HasColumnType("datetime2")
                        .HasColumnOrder(4);

                    b.Property<string>("UpdateUser")
                        .HasMaxLength(450)
                        .HasColumnType("nvarchar(450)")
                        .HasColumnOrder(2);

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

                    b.HasKey("Id");

                    b.HasIndex("AttachmentTypeId");

                    b.HasIndex("UserId");

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

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));

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

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

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

                    b.HasKey("Id");

                    b.HasIndex("RoleId");

                    b.ToTable("AspNetRoleClaims", (string)null);
                });

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

                    SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));

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

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

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

                    b.HasKey("Id");

                    b.HasIndex("UserId");

                    b.ToTable("AspNetUserClaims", (string)null);
                });

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
                {
                    b.Property<string>("LoginProvider")
                        .HasColumnType("nvarchar(450)");

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

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

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

                    b.HasKey("LoginProvider", "ProviderKey");

                    b.HasIndex("UserId");

                    b.ToTable("AspNetUserLogins", (string)null);
                });

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
                {
                    b.Property<string>("UserId")
                        .HasColumnType("nvarchar(450)");

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

                    b.HasKey("UserId", "RoleId");

                    b.HasIndex("RoleId");

                    b.ToTable("AspNetUserRoles", (string)null);

                    b.HasData(
                        new
                        {
                            UserId = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA",
                            RoleId = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A"
                        },
                        new
                        {
                            UserId = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB",
                            RoleId = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E"
                        });
                });

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
                {
                    b.Property<string>("UserId")
                        .HasColumnType("nvarchar(450)");

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

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

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

                    b.HasKey("UserId", "LoginProvider", "Name");

                    b.ToTable("AspNetUserTokens", (string)null);
                });

            modelBuilder.Entity("ApplicationRoleApplicationUser", b =>
                {
                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
                        .WithMany()
                        .HasForeignKey("UserRolesId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
                        .WithMany()
                        .HasForeignKey("UsersId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.ChatAttachment", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.ChatMessage", "ChatMessage")
                        .WithMany("ChatAttachments")
                        .HasForeignKey("ChatMessageId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.City", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
                        .WithMany()
                        .HasForeignKey("CountryId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.Company", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.City", "City")
                        .WithMany()
                        .HasForeignKey("CityId");

                    b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
                        .WithMany()
                        .HasForeignKey("CountryId");

                    b.Navigation("City");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ContractAllowance", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.Contract", "Contract")
                        .WithMany("FixedAllowances")
                        .HasForeignKey("ContractId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTask", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.Contract", "Contract")
                        .WithMany("ContractTasks")
                        .HasForeignKey("ContractId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTaskAttachment", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.ContractTask", "ContractTask")
                        .WithMany("TaskAttachments")
                        .HasForeignKey("ContractTaskId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ContractWorkingDay", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.Contract", "Contract")
                        .WithMany("WorkingDays")
                        .HasForeignKey("ContractId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.Meeting", "Meeting")
                        .WithMany("MeetingUsers")
                        .HasForeignKey("MeetingId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.OrderAllocation", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.LeaveType", "LeaveType")
                        .WithMany()
                        .HasForeignKey("LeaveTypeId");

                    b.HasOne("MTWorkHR.Core.Entities.OrderType", "OrderType")
                        .WithMany()
                        .HasForeignKey("OrderTypeId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("LeaveType");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStage", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.Contract", "Contract")
                        .WithMany("ProjectStages")
                        .HasForeignKey("ContractId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStageAttachment", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.ProjectStage", "ProjectStage")
                        .WithMany("StageAttachments")
                        .HasForeignKey("ProjectStageId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectTeam", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.Project", "Project")
                        .WithMany("ProjectTeams")
                        .HasForeignKey("ProjectId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.TaskUser", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask")
                        .WithMany("TaskUsers")
                        .HasForeignKey("TaskId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.Team", "Team")
                        .WithMany("TeamUsers")
                        .HasForeignKey("TeamId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.User.OrderRequest", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.LeaveType", "LeaveType")
                        .WithMany()
                        .HasForeignKey("LeaveTypeId");

                    b.HasOne("MTWorkHR.Core.Entities.OrderType", "OrderType")
                        .WithMany()
                        .HasForeignKey("OrderTypeId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("LeaveType");

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

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

                    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", "UserTask")
                        .WithMany("TaskHistories")
                        .HasForeignKey("TaskId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("TaskStatus");

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

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
                        .WithMany()
                        .HasForeignKey("CountryId");

                    b.HasOne("MTWorkHR.Core.Entities.Industry", "Industry")
                        .WithMany()
                        .HasForeignKey("IndustryId");

                    b.HasOne("MTWorkHR.Core.Entities.JobTitle", "JobTitle")
                        .WithMany()
                        .HasForeignKey("JobTitleId");

                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "Manager")
                        .WithMany()
                        .HasForeignKey("ManagerId");

                    b.HasOne("MTWorkHR.Core.Entities.Nationality", "Nationality")
                        .WithMany()
                        .HasForeignKey("NationalityId");

                    b.HasOne("MTWorkHR.Core.Entities.Qualification", "Qualification")
                        .WithMany()
                        .HasForeignKey("QualificationId");

                    b.HasOne("MTWorkHR.Core.Entities.University", "University")
                        .WithMany()
                        .HasForeignKey("UniversityId");

                    b.Navigation("Country");

                    b.Navigation("Industry");

                    b.Navigation("JobTitle");

                    b.Navigation("Manager");

                    b.Navigation("Nationality");

                    b.Navigation("Qualification");

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

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.Permission", "Permission")
                        .WithMany()
                        .HasForeignKey("PermissionId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", "Role")
                        .WithMany("RolePermissions")
                        .HasForeignKey("RoleId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("Permission");

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

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAddress", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.City", "City")
                        .WithMany()
                        .HasForeignKey("CityId");

                    b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
                        .WithMany()
                        .HasForeignKey("CountryId");

                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "User")
                        .WithOne("UserAddress")
                        .HasForeignKey("MTWorkHR.Infrastructure.Entities.UserAddress", "UserId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("City");

                    b.Navigation("Country");

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

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b =>
                {
                    b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType")
                        .WithMany()
                        .HasForeignKey("AttachmentTypeId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "User")
                        .WithMany("UserAttachments")
                        .HasForeignKey("UserId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("AttachmentType");

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

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
                {
                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
                        .WithMany()
                        .HasForeignKey("RoleId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();
                });

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
                {
                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
                        .WithMany()
                        .HasForeignKey("UserId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();
                });

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
                {
                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
                        .WithMany()
                        .HasForeignKey("UserId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();
                });

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
                {
                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
                        .WithMany()
                        .HasForeignKey("RoleId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
                        .WithMany()
                        .HasForeignKey("UserId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();
                });

            modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
                {
                    b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
                        .WithMany()
                        .HasForeignKey("UserId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.ChatMessage", b =>
                {
                    b.Navigation("ChatAttachments");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.Contract", b =>
                {
                    b.Navigation("ContractTasks");

                    b.Navigation("FixedAllowances");

                    b.Navigation("ProjectStages");

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

            modelBuilder.Entity("MTWorkHR.Core.Entities.ContractTask", b =>
                {
                    b.Navigation("TaskAttachments");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b =>
                {
                    b.Navigation("MeetingUsers");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b =>
                {
                    b.Navigation("ProjectTeams");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.ProjectStage", b =>
                {
                    b.Navigation("StageAttachments");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b =>
                {
                    b.Navigation("TeamUsers");
                });

            modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
                {
                    b.Navigation("TaskAttachments");

                    b.Navigation("TaskHistories");

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

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b =>
                {
                    b.Navigation("RolePermissions");
                });

            modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
                {
                    b.Navigation("UserAddress")
                        .IsRequired();

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