123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684 |
- // <auto-generated />
- using System;
- using MTWorkHR.Infrastructure.Data;
- 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("20240225115219_UserTasks")]
- partial class UserTasks
- {
- /// <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("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("AttachmentType");
- 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<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasColumnOrder(0);
- SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
- b.Property<string>("CRNumber")
- .IsRequired()
- .HasColumnType("nvarchar(max)");
- b.Property<string>("CompanyName")
- .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>("IsDeleted")
- .HasColumnType("bit");
- 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<long>("UserId")
- .HasColumnType("bigint");
- b.HasKey("Id");
- b.ToTable("Companies");
- });
- 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.Project", 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("Projects");
- });
- 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.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<long>("AssignedUserId")
- .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")
- .IsRequired()
- .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("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<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>("OriginalName")
- .IsRequired()
- .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<long>("AssignedToUserId")
- .HasColumnType("bigint");
- b.Property<string>("Comment")
- .IsRequired()
- .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<DateTime?>("UpdateDate")
- .HasColumnType("datetime2")
- .HasColumnOrder(4);
- b.Property<string>("UpdateUser")
- .HasMaxLength(450)
- .HasColumnType("nvarchar(450)")
- .HasColumnOrder(2);
- b.HasKey("Id");
- b.HasIndex("CurrentStatusId");
- b.ToTable("UserTaskHistories");
- });
- 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");
- });
- 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.Navigation("TaskStatus");
- });
- modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
- {
- b.Navigation("TaskAttachments");
- });
- #pragma warning restore 612, 618
- }
- }
- }
|