// 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("20240313083213_attendance")] partial class attendance { /// 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("UserRolesId") .HasColumnType("nvarchar(450)"); b.Property("UsersId") .HasColumnType("nvarchar(450)"); b.HasKey("UserRolesId", "UsersId"); b.HasIndex("UsersId"); b.ToTable("ApplicationRoleApplicationUser"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Attendance", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AttendanceDate") .HasColumnType("datetime2"); b.Property("CheckInTime") .HasColumnType("datetime2"); b.Property("CheckOutTime") .HasColumnType("datetime2"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("LeaveReason") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("LeaveType") .HasColumnType("int"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserName") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Attendances"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.AttendanceLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("AttendanceLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.AuthLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("AuthLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Base.AttachmentType", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("IsRequired") .HasColumnType("bit"); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("AttachmentTypes"); b.HasData( new { Id = 1L, IsRequired = false, NameAr = "السيرة الذاتية", NameEn = "CV" }, new { Id = 2L, IsRequired = false, NameAr = "الهوية", NameEn = "Identification" }); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Company", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CRNumber") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CompanyName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("TaxNumber") .HasColumnType("int"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserId") .HasColumnType("bigint"); b.HasKey("Id"); b.ToTable("Companies"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.FileLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("FileLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("Description") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("EndDate") .HasColumnType("datetime2"); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("Location") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("MeetingLink") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("StartDate") .HasColumnType("datetime2"); b.Property("Title") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.ToTable("Meetings"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("MeetingLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AssignedUserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("MeetingId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("MeetingId"); b.ToTable("MeetingUser"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Permission", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CategoryName") .IsRequired() .HasMaxLength(150) .HasColumnType("nvarchar(150)"); b.Property("Desc") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("Name") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("Show") .HasColumnType("bit"); b.HasKey("Id"); b.ToTable("Permissions"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.ToTable("Projects"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.RoleLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("RoleLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.SettingLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("SettingLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.ToTable("Teams"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.TeamLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("TeamLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AssignedUserId") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("IsAdmin") .HasColumnType("bit"); b.Property("TeamId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("TeamId"); b.ToTable("TeamUser"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("UserLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AssignedUserId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("DeleteUserId") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(8); b.Property("Description") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("DueDate") .HasColumnType("datetime2"); b.Property("IsDeleted") .HasColumnType("bit") .HasColumnOrder(7); b.Property("Priority") .HasColumnType("int"); b.Property("ProjectId") .HasColumnType("bigint"); b.Property("StatusId") .HasColumnType("bigint"); b.Property("Title") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("ProjectId"); b.HasIndex("StatusId"); b.ToTable("UserTasks"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AttachmentTypeId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("FileName") .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("OriginalName") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("TaskId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.HasKey("Id"); b.HasIndex("AttachmentTypeId"); b.HasIndex("TaskId"); b.ToTable("UserTaskAttachments"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AssignedToUserId") .HasColumnType("bigint"); b.Property("Comment") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("CurrentStatusId") .HasColumnType("bigint"); b.Property("IsDeleted") .HasColumnType("bit"); b.Property("TaskId") .HasColumnType("bigint"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserTaskId") .HasColumnType("bigint"); b.HasKey("Id"); b.HasIndex("CurrentStatusId"); b.HasIndex("UserTaskId"); b.ToTable("UserTaskHistories"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskLog", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("Channel") .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("ErrorDescription") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("InnerException") .HasColumnType("nvarchar(max)"); b.Property("Input") .HasColumnType("nvarchar(max)"); b.Property("Method") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("QueryString") .HasColumnType("nvarchar(max)"); b.Property("ServerIP") .HasColumnType("nvarchar(max)"); b.Property("ServiceResponseTimeInSeconds") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UserIP") .HasColumnType("nvarchar(max)"); b.Property("userAgent") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("UserTaskLogs"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskStatus", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("NameAr") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("NameEn") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.HasKey("Id"); b.ToTable("UserTaskStatuses"); b.HasData( new { Id = 1L, NameAr = "جديدة", NameEn = "New" }, new { Id = 2L, NameAr = "قيد العمل", NameEn = "Under progress" }, new { Id = 3L, NameAr = "أغلقت", NameEn = "Closed" }, new { Id = 4L, NameAr = "تمت", NameEn = "Completed" }, new { Id = 5L, NameAr = "مؤجلة", NameEn = "Delayed" }); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b => { b.Property("Id") .HasColumnType("nvarchar(450)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasColumnType("nvarchar(max)"); b.Property("CreateDate") .HasColumnType("datetime2"); b.Property("CreateUser") .HasColumnType("nvarchar(max)"); b.Property("DeleteUserId") .HasColumnType("nvarchar(max)"); b.Property("IsAdmin") .HasColumnType("bit"); b.Property("IsDeleted") .HasColumnType("bit"); b.Property("Name") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("NormalizedName") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("UpdateDate") .HasColumnType("datetime2"); b.Property("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" }); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b => { b.Property("Id") .HasColumnType("nvarchar(450)"); b.Property("AccessFailedCount") .HasColumnType("int"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasColumnType("nvarchar(max)"); b.Property("CreateUser") .HasColumnType("nvarchar(max)"); b.Property("DeleteUserId") .HasColumnType("nvarchar(max)"); b.Property("Email") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("EmailConfirmed") .HasColumnType("bit"); b.Property("FavoriteName") .HasColumnType("nvarchar(max)"); b.Property("FirstName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("IncomeTaxValue") .HasColumnType("decimal(18,2)"); b.Property("IsDeleted") .HasColumnType("bit"); b.Property("IsStopped") .HasColumnType("bit"); b.Property("JobTitle") .HasColumnType("nvarchar(max)"); b.Property("LastName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("LockoutEnabled") .HasColumnType("bit"); b.Property("LockoutEnd") .HasColumnType("datetimeoffset"); b.Property("ManagerId") .HasColumnType("nvarchar(450)"); b.Property("NormalizedEmail") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("NormalizedUserName") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("PassportNumber") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("PasswordHash") .HasColumnType("nvarchar(max)"); b.Property("PhoneNumber") .HasColumnType("nvarchar(max)"); b.Property("PhoneNumberConfirmed") .HasColumnType("bit"); b.Property("QualificationId") .HasColumnType("int"); b.Property("SecurityStamp") .HasColumnType("nvarchar(max)"); b.Property("TaxNumber") .HasColumnType("decimal(18,2)"); b.Property("TwoFactorEnabled") .HasColumnType("bit"); b.Property("University") .HasColumnType("nvarchar(max)"); b.Property("UpdateUser") .HasColumnType("nvarchar(max)"); b.Property("UserName") .HasMaxLength(256) .HasColumnType("nvarchar(256)"); b.Property("UserType") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("ManagerId"); b.HasIndex("NormalizedEmail") .HasDatabaseName("EmailIndex"); b.HasIndex("NormalizedUserName") .IsUnique() .HasDatabaseName("UserNameIndex") .HasFilter("[NormalizedUserName] IS NOT NULL"); b.ToTable("AspNetUsers", (string)null); b.HasData( new { Id = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA", AccessFailedCount = 0, ConcurrencyStamp = "7cc87689-9eab-4280-b8e3-1834080783a5", Email = "a@b.com", EmailConfirmed = true, FirstName = "Zinab", IncomeTaxValue = 1m, IsDeleted = false, IsStopped = false, LastName = "Elgendy", LockoutEnabled = false, NormalizedEmail = "A@B.COM", NormalizedUserName = "ADMIN", PassportNumber = "1234567", PasswordHash = "AQAAAAIAAYagAAAAEPg+ASbciPFxtyxQq8Wx5ilBUQ0RbAoITXXkOQm1PzC5BzySX0sn/wUmOjBKPDGV9w==", PhoneNumber = "1234567890", PhoneNumberConfirmed = true, QualificationId = 1, SecurityStamp = "49bb16c3-4704-4c60-908d-dc8506950acc", TaxNumber = 111m, TwoFactorEnabled = false, UserName = "Admin", UserType = 1 }, new { Id = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB", AccessFailedCount = 0, ConcurrencyStamp = "4af7b4cf-802a-455b-b598-997e167745b3", Email = "ali@b.com", EmailConfirmed = true, FirstName = "Ali", IncomeTaxValue = 100m, IsDeleted = false, IsStopped = false, LastName = "Farok", LockoutEnabled = false, NormalizedEmail = "ALI@B.COM", NormalizedUserName = "ALI", PassportNumber = "7654321001010", PasswordHash = "AQAAAAIAAYagAAAAEI3QJkcZjCH4Y8Db4rEgL8Mmll5oCvYcWiXZjQSN9bGW4SMcjHe3ZPMnkN/l9DmJeQ==", PhoneNumber = "1234567890", PhoneNumberConfirmed = true, QualificationId = 1, SecurityStamp = "62549056-1b9d-46d4-84f8-adea3e4d8b68", TaxNumber = 222m, TwoFactorEnabled = false, UserName = "ali", UserType = 1 }); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("PermissionId") .HasColumnType("bigint"); b.Property("PermissionName") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("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("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AddressDesc") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("City") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("CountryId") .HasColumnType("int"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("PostalCode") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("UserId") .IsUnique(); b.ToTable("UserAddress"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("AttachmentTypeId") .HasColumnType("bigint"); b.Property("CreateDate") .HasColumnType("datetime2") .HasColumnOrder(3); b.Property("CreateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(1); b.Property("FileName") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("OriginalName") .IsRequired() .HasMaxLength(250) .HasColumnType("nvarchar(250)"); b.Property("UpdateDate") .HasColumnType("datetime2") .HasColumnOrder(4); b.Property("UpdateUser") .HasMaxLength(450) .HasColumnType("nvarchar(450)") .HasColumnOrder(2); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("AttachmentTypeId"); b.HasIndex("UserId"); b.ToTable("UserAttachments"); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("ClaimType") .HasColumnType("nvarchar(max)"); b.Property("ClaimValue") .HasColumnType("nvarchar(max)"); b.Property("RoleId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("RoleId"); b.ToTable("AspNetRoleClaims", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id")); b.Property("ClaimType") .HasColumnType("nvarchar(max)"); b.Property("ClaimValue") .HasColumnType("nvarchar(max)"); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("Id"); b.HasIndex("UserId"); b.ToTable("AspNetUserClaims", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b => { b.Property("LoginProvider") .HasColumnType("nvarchar(450)"); b.Property("ProviderKey") .HasColumnType("nvarchar(450)"); b.Property("ProviderDisplayName") .HasColumnType("nvarchar(max)"); b.Property("UserId") .IsRequired() .HasColumnType("nvarchar(450)"); b.HasKey("LoginProvider", "ProviderKey"); b.HasIndex("UserId"); b.ToTable("AspNetUserLogins", (string)null); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b => { b.Property("UserId") .HasColumnType("nvarchar(450)"); b.Property("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", b => { b.Property("UserId") .HasColumnType("nvarchar(450)"); b.Property("LoginProvider") .HasColumnType("nvarchar(450)"); b.Property("Name") .HasColumnType("nvarchar(450)"); b.Property("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.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.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.UserTask", b => { b.HasOne("MTWorkHR.Core.Entities.Project", "Project") .WithMany() .HasForeignKey("ProjectId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus") .WithMany() .HasForeignKey("StatusId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Project"); b.Navigation("TaskStatus"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b => { b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType") .WithMany() .HasForeignKey("AttachmentTypeId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask") .WithMany("TaskAttachments") .HasForeignKey("TaskId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("AttachmentType"); b.Navigation("UserTask"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b => { b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus") .WithMany() .HasForeignKey("CurrentStatusId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("MTWorkHR.Core.Entities.UserTask", null) .WithMany("UserTaskHistories") .HasForeignKey("UserTaskId"); b.Navigation("TaskStatus"); }); modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "Manager") .WithMany() .HasForeignKey("ManagerId"); b.Navigation("Manager"); }); 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.Infrastructure.Entities.ApplicationUser", "User") .WithOne("UserAddress") .HasForeignKey("MTWorkHR.Infrastructure.Entities.UserAddress", "UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); 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", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null) .WithMany() .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", 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", b => { b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b => { b.Navigation("MeetingUsers"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b => { b.Navigation("TeamUsers"); }); modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b => { b.Navigation("TaskAttachments"); b.Navigation("UserTaskHistories"); }); 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 } } }