579 lines
22 KiB
C#
579 lines
22 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("20220222194505_YearlyItems")]
|
|
partial class YearlyItems
|
|
{
|
|
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.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.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.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>("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.empolyerAgg.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<DateTime>("CreationDate")
|
|
.HasColumnType("datetime2");
|
|
|
|
b.Property<long>("EmployerId")
|
|
.HasColumnType("bigint");
|
|
|
|
b.Property<string>("InsuranceCode")
|
|
.IsRequired()
|
|
.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>("WorkshopName")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.HasColumnType("nvarchar(255)");
|
|
|
|
b.HasKey("id");
|
|
|
|
b.HasIndex("EmployerId");
|
|
|
|
b.ToTable("Workshops");
|
|
});
|
|
|
|
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.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.empolyerAgg.Workshop", b =>
|
|
{
|
|
b.HasOne("Company.Domain.empolyerAgg.Employer", "Employer")
|
|
.WithMany("Workshops")
|
|
.HasForeignKey("EmployerId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired();
|
|
|
|
b.Navigation("Employer");
|
|
});
|
|
|
|
modelBuilder.Entity("Company.Domain.ContarctingPartyAgg.PersonalContractingParty", b =>
|
|
{
|
|
b.Navigation("Employers");
|
|
});
|
|
|
|
modelBuilder.Entity("Company.Domain.EmployeeAgg.Employee", b =>
|
|
{
|
|
b.Navigation("EmployeeChildrenList");
|
|
});
|
|
|
|
modelBuilder.Entity("Company.Domain.YearlySalaryAgg.YearlySalary", b =>
|
|
{
|
|
b.Navigation("YearlySalaryItemsList");
|
|
});
|
|
|
|
modelBuilder.Entity("Company.Domain.empolyerAgg.Employer", b =>
|
|
{
|
|
b.Navigation("Workshops");
|
|
});
|
|
#pragma warning restore 612, 618
|
|
}
|
|
}
|
|
}
|