//
using System;
using MTWorkHR.Identity.DBContext;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
#nullable disable
namespace MTWorkHR.Identity.Migrations
{
[DbContext(typeof(HRIdentityDBContext))]
partial class HRIdentityDBContextModelSnapshot : ModelSnapshot
{
protected override void BuildModel(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.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.Identity.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.Identity.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.Identity.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.Identity.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.Identity.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.Identity.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.Identity.Entities.ApplicationRole", null)
.WithMany()
.HasForeignKey("UserRolesId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("MTWorkHR.Identity.Entities.ApplicationUser", null)
.WithMany()
.HasForeignKey("UsersId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("MTWorkHR.Identity.Entities.ApplicationUser", b =>
{
b.HasOne("MTWorkHR.Identity.Entities.ApplicationUser", "Manager")
.WithMany()
.HasForeignKey("ManagerId");
b.Navigation("Manager");
});
modelBuilder.Entity("MTWorkHR.Identity.Entities.RolePermission", b =>
{
b.HasOne("MTWorkHR.Identity.Entities.Permission", "Permission")
.WithMany()
.HasForeignKey("PermissionId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("MTWorkHR.Identity.Entities.ApplicationRole", "Role")
.WithMany("RolePermissions")
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Permission");
b.Navigation("Role");
});
modelBuilder.Entity("MTWorkHR.Identity.Entities.UserAddress", b =>
{
b.HasOne("MTWorkHR.Identity.Entities.ApplicationUser", "User")
.WithOne("UserAddress")
.HasForeignKey("MTWorkHR.Identity.Entities.UserAddress", "UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("User");
});
modelBuilder.Entity("MTWorkHR.Identity.Entities.UserAttachment", b =>
{
b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType")
.WithMany()
.HasForeignKey("AttachmentTypeId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("MTWorkHR.Identity.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.Identity.Entities.ApplicationRole", null)
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim", b =>
{
b.HasOne("MTWorkHR.Identity.Entities.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin", b =>
{
b.HasOne("MTWorkHR.Identity.Entities.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole", b =>
{
b.HasOne("MTWorkHR.Identity.Entities.ApplicationRole", null)
.WithMany()
.HasForeignKey("RoleId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("MTWorkHR.Identity.Entities.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken", b =>
{
b.HasOne("MTWorkHR.Identity.Entities.ApplicationUser", null)
.WithMany()
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("MTWorkHR.Identity.Entities.ApplicationRole", b =>
{
b.Navigation("RolePermissions");
});
modelBuilder.Entity("MTWorkHR.Identity.Entities.ApplicationUser", b =>
{
b.Navigation("UserAddress")
.IsRequired();
b.Navigation("UserAttachments");
});
#pragma warning restore 612, 618
}
}
}