Files
Backend-Api/CompanyManagment.EFCore/Migrations/20220326042821_InsurancCodeAllowNull.Designer.cs
2024-07-05 21:36:15 +03:30

847 lines
31 KiB
C#

// <auto-generated />
using System;
using CompanyManagment.EFCore;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
namespace CompanyManagment.EFCore.Migrations
{
[DbContext(typeof(CompanyContext))]
[Migration("20220326042821_InsurancCodeAllowNull")]
partial class InsurancCodeAllowNull
{
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("ProductVersion", "5.0.11")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("Company.Domain.ContarctingPartyAgg.PersonalContractingParty", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Address")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property<string>("AgentPhone")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<string>("FName")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("IdNumber")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property<string>("IsLegal")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("LName")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("NationalId")
.IsRequired()
.HasMaxLength(15)
.HasColumnType("nvarchar(15)");
b.Property<string>("Nationalcode")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("Phone")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("RegisterId")
.IsRequired()
.HasMaxLength(15)
.HasColumnType("nvarchar(15)");
b.HasKey("id");
b.ToTable("PersonalContractingParties");
});
modelBuilder.Entity("Company.Domain.ContractAgg.Contract", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("ArchiveCode")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<DateTime>("ContarctStart")
.HasColumnType("datetime2");
b.Property<DateTime>("ContractEnd")
.HasColumnType("datetime2");
b.Property<string>("ContractNo")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("ContractType")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<double>("DayliWage")
.HasColumnType("float");
b.Property<long>("EmployeeId")
.HasColumnType("bigint");
b.Property<long>("EmployerId")
.HasColumnType("bigint");
b.Property<DateTime>("GetWorkDate")
.HasColumnType("datetime2");
b.Property<string>("IsActiveString")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("JobType")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<long>("JobTypeId")
.HasColumnType("bigint");
b.Property<long>("PersonnelCode")
.HasColumnType("bigint");
b.Property<double>("SalaryAgg")
.HasColumnType("float");
b.Property<DateTime>("SetContractDate")
.HasColumnType("datetime2");
b.Property<string>("WorkshopAddress1")
.IsRequired()
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property<string>("WorkshopAddress2")
.IsRequired()
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property<long>("WorkshopIds")
.HasColumnType("bigint");
b.Property<long>("YearlySalaryId")
.HasColumnType("bigint");
b.HasKey("id");
b.HasIndex("EmployeeId");
b.HasIndex("EmployerId");
b.HasIndex("JobTypeId");
b.HasIndex("WorkshopIds");
b.HasIndex("YearlySalaryId");
b.ToTable("Contracts");
});
modelBuilder.Entity("Company.Domain.EmployeeAgg.Employee", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Address")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property<string>("BankBranch")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("BankCardNumber")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("City")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<DateTime>("DateOfBirth")
.HasColumnType("datetime2");
b.Property<DateTime>("DateOfIssue")
.HasColumnType("datetime2");
b.Property<string>("FName")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("FatherName")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("FieldOfStudy")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Gender")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("IdNumber")
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property<string>("InsuranceCode")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("InsuranceHistoryByMonth")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("InsuranceHistoryByYear")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<bool>("IsActive")
.HasColumnType("bit");
b.Property<string>("IsActiveString")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("LName")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("LevelOfEducation")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("MaritalStatus")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("MilitaryService")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("NationalCode")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("Nationality")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("NumberOfChildren")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("OfficePhone")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("Phone")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("PlaceOfIssue")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("State")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.HasKey("id");
b.ToTable("Employees");
});
modelBuilder.Entity("Company.Domain.EmployeeChildrenAgg.EmployeeChildren", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<DateTime>("DateOfBirth")
.HasColumnType("datetime2");
b.Property<long>("EmployeeId")
.HasColumnType("bigint");
b.Property<string>("FName")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("ParentNationalCode")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.HasKey("id");
b.HasIndex("EmployeeId");
b.ToTable("EmployeeChildren");
});
modelBuilder.Entity("Company.Domain.JobAgg.Job", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<string>("JobCode")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("JobName")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.HasKey("id");
b.ToTable("Jobs");
});
modelBuilder.Entity("Company.Domain.WorkshopAgg.Workshop", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Address")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property<string>("AgentName")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("AgentPhone")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("ArchiveCode")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("City")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("ContractTerm")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<string>("InsuranceCode")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<bool>("IsActive")
.HasColumnType("bit");
b.Property<string>("IsActiveString")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("State")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("TypeOfContract")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("TypeOfInsuranceSend")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("TypeOfOwnership")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("WorkshopFullName")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("WorkshopName")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("WorkshopSureName")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.HasKey("id");
b.ToTable("Workshops");
});
modelBuilder.Entity("Company.Domain.WorkshopEmployerAgg.WorkshopEmployer", b =>
{
b.Property<long>("WorkshopId")
.HasColumnType("bigint");
b.Property<long>("EmployerId")
.HasColumnType("bigint");
b.HasKey("WorkshopId", "EmployerId");
b.HasIndex("EmployerId");
b.ToTable("WorkshopeEmployers");
});
modelBuilder.Entity("Company.Domain.YearlySalaryAgg.YearlySalary", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<int>("ConnectionId")
.HasColumnType("int");
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<DateTime>("EndDate")
.HasColumnType("datetime2");
b.Property<DateTime>("StartDate")
.HasColumnType("datetime2");
b.Property<string>("Year")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.HasKey("id");
b.ToTable("YearlySalariess");
});
modelBuilder.Entity("Company.Domain.YearlySalaryItemsAgg.YearlySalaryItem", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<string>("ItemName")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<double>("ItemValue")
.HasColumnType("float");
b.Property<int>("ParentConnectionId")
.HasColumnType("int");
b.Property<string>("ValueType")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<long>("YearlySalaryId")
.HasColumnType("bigint");
b.HasKey("id");
b.HasIndex("YearlySalaryId");
b.ToTable("YearlyItems");
});
modelBuilder.Entity("Company.Domain.YearlysSalaryTitleAgg.YearlySalaryTitle", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<string>("Title1")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Title10")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Title2")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Title3")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Title4")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Title5")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Title6")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Title7")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Title8")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Title9")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.HasKey("id");
b.ToTable("YearlySalaryTitles");
});
modelBuilder.Entity("Company.Domain.empolyerAgg.Employer", b =>
{
b.Property<long>("id")
.ValueGeneratedOnAdd()
.HasColumnType("bigint")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property<string>("Address")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property<string>("AgentPhone")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<long>("ContractingPartyId")
.HasColumnType("bigint");
b.Property<DateTime>("CreationDate")
.HasColumnType("datetime2");
b.Property<DateTime>("DateOfBirth")
.HasColumnType("datetime2");
b.Property<DateTime>("DateOfIssue")
.HasColumnType("datetime2");
b.Property<string>("EmployerLName")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("EmployerNo")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("EservicePassword")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("EserviceUserName")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("FName")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("FatherName")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("FullName")
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("Gender")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("IdNumber")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property<bool>("IsActive")
.HasColumnType("bit");
b.Property<string>("IsLegal")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("LName")
.IsRequired()
.HasMaxLength(255)
.HasColumnType("nvarchar(255)");
b.Property<string>("MclsPassword")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("MclsUserName")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("NationalId")
.IsRequired()
.HasMaxLength(15)
.HasColumnType("nvarchar(15)");
b.Property<string>("Nationalcode")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property<string>("Nationality")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("Phone")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("PlaceOfIssue")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property<string>("RegisterId")
.IsRequired()
.HasMaxLength(15)
.HasColumnType("nvarchar(15)");
b.Property<string>("SanaPassword")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("SanaUserName")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("TaxOfficeUserName")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("TaxOfficepassword")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.HasKey("id");
b.HasIndex("ContractingPartyId");
b.ToTable("Employers");
});
modelBuilder.Entity("Company.Domain.ContractAgg.Contract", b =>
{
b.HasOne("Company.Domain.EmployeeAgg.Employee", "Employee")
.WithMany("Contracts")
.HasForeignKey("EmployeeId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Company.Domain.empolyerAgg.Employer", "Employer")
.WithMany("Contracts")
.HasForeignKey("EmployerId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Company.Domain.JobAgg.Job", "Job")
.WithMany("ContractsList")
.HasForeignKey("JobTypeId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Company.Domain.WorkshopAgg.Workshop", "Workshop")
.WithMany("Contracts2")
.HasForeignKey("WorkshopIds")
.OnDelete(DeleteBehavior.NoAction)
.IsRequired();
b.HasOne("Company.Domain.YearlySalaryAgg.YearlySalary", "YearlySalary")
.WithMany("Contracts")
.HasForeignKey("YearlySalaryId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Employee");
b.Navigation("Employer");
b.Navigation("Job");
b.Navigation("Workshop");
b.Navigation("YearlySalary");
});
modelBuilder.Entity("Company.Domain.EmployeeChildrenAgg.EmployeeChildren", b =>
{
b.HasOne("Company.Domain.EmployeeAgg.Employee", "Employee")
.WithMany("EmployeeChildrenList")
.HasForeignKey("EmployeeId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Employee");
});
modelBuilder.Entity("Company.Domain.WorkshopEmployerAgg.WorkshopEmployer", b =>
{
b.HasOne("Company.Domain.empolyerAgg.Employer", "Employer")
.WithMany("WorkshopEmployers")
.HasForeignKey("EmployerId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("Company.Domain.WorkshopAgg.Workshop", "Workshop")
.WithMany("WorkshopEmployers")
.HasForeignKey("WorkshopId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Employer");
b.Navigation("Workshop");
});
modelBuilder.Entity("Company.Domain.YearlySalaryItemsAgg.YearlySalaryItem", b =>
{
b.HasOne("Company.Domain.YearlySalaryAgg.YearlySalary", "YearlySalary")
.WithMany("YearlySalaryItemsList")
.HasForeignKey("YearlySalaryId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("YearlySalary");
});
modelBuilder.Entity("Company.Domain.empolyerAgg.Employer", b =>
{
b.HasOne("Company.Domain.ContarctingPartyAgg.PersonalContractingParty", "ContractingParty")
.WithMany("Employers")
.HasForeignKey("ContractingPartyId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("ContractingParty");
});
modelBuilder.Entity("Company.Domain.ContarctingPartyAgg.PersonalContractingParty", b =>
{
b.Navigation("Employers");
});
modelBuilder.Entity("Company.Domain.EmployeeAgg.Employee", b =>
{
b.Navigation("Contracts");
b.Navigation("EmployeeChildrenList");
});
modelBuilder.Entity("Company.Domain.JobAgg.Job", b =>
{
b.Navigation("ContractsList");
});
modelBuilder.Entity("Company.Domain.WorkshopAgg.Workshop", b =>
{
b.Navigation("Contracts2");
b.Navigation("WorkshopEmployers");
});
modelBuilder.Entity("Company.Domain.YearlySalaryAgg.YearlySalary", b =>
{
b.Navigation("Contracts");
b.Navigation("YearlySalaryItemsList");
});
modelBuilder.Entity("Company.Domain.empolyerAgg.Employer", b =>
{
b.Navigation("Contracts");
b.Navigation("WorkshopEmployers");
});
#pragma warning restore 612, 618
}
}
}