From 860e1fe5396005cfcc3dd68e1b20cd3b35010e83 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期二, 12 八月 2025 14:33:21 +0800 Subject: [PATCH] feat:开发 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 551 ++++++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 426 insertions(+), 125 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index 13ee61a..51515c9 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -427,6 +427,95 @@ b.ToTable("EnterpriseAuth"); }); + modelBuilder.Entity("FlexJobApi.Core.EnterpriseEmployee", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<int?>("Age") + .HasColumnType("int"); + + b.Property<string>("ContactPhoneNumber") + .HasMaxLength(11) + .HasColumnType("nvarchar(11)"); + + b.Property<string>("ContractUrl") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<Guid>("EnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<int?>("EnterpriseSignContractStatus") + .HasColumnType("int"); + + b.Property<DateTime?>("EnterpriseSignContractTime") + .HasColumnType("datetime2"); + + b.Property<int?>("Gender") + .HasColumnType("int"); + + b.Property<int>("HireStatus") + .HasColumnType("int"); + + b.Property<DateTime?>("HireTime") + .HasColumnType("datetime2"); + + b.Property<string>("Identity") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("IdentityBackImg") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("IdentityImg") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<string>("Name") + .HasMaxLength(32) + .HasColumnType("nvarchar(32)"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<Guid?>("UserId") + .HasColumnType("uniqueidentifier"); + + b.Property<int?>("UserSignContractStatus") + .HasColumnType("int"); + + b.Property<DateTime?>("UserSignContractTime") + .HasColumnType("datetime2"); + + b.HasKey("Id"); + + b.HasIndex("EnterpriseId"); + + b.HasIndex("UserId"); + + b.ToTable("EnterpriseEmployee"); + }); + modelBuilder.Entity("FlexJobApi.Core.Menu", b => { b.Property<Guid>("Id") @@ -763,6 +852,166 @@ b.ToTable("RoleResource"); }); + modelBuilder.Entity("FlexJobApi.Core.ScheduleJobDetail", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<string>("AssemblyName") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("Concurrent") + .HasColumnType("bit"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Description") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("GroupName") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IncludeAnnotations") + .HasColumnType("bit"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<string>("JobId") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("JobType") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("Properties") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.ToTable("ScheduleJobDetail"); + }); + + modelBuilder.Entity("FlexJobApi.Core.ScheduleJobTrigger", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Args") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("AssemblyName") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Description") + .HasColumnType("nvarchar(max)"); + + b.Property<long>("ElapsedTime") + .HasColumnType("bigint"); + + b.Property<DateTime?>("EndTime") + .HasColumnType("datetime2"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<string>("JobId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTime?>("LastRunTime") + .HasColumnType("datetime2"); + + b.Property<long>("MaxNumberOfErrors") + .HasColumnType("bigint"); + + b.Property<long>("MaxNumberOfRuns") + .HasColumnType("bigint"); + + b.Property<DateTime?>("NextRunTime") + .HasColumnType("datetime2"); + + b.Property<long>("NumRetries") + .HasColumnType("bigint"); + + b.Property<long>("NumberOfErrors") + .HasColumnType("bigint"); + + b.Property<long>("NumberOfRuns") + .HasColumnType("bigint"); + + b.Property<bool>("ResetOnlyOnce") + .HasColumnType("bit"); + + b.Property<string>("Result") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("RetryTimeout") + .HasColumnType("int"); + + b.Property<bool>("RunOnStart") + .HasColumnType("bit"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<bool>("StartNow") + .HasColumnType("bit"); + + b.Property<DateTime?>("StartTime") + .HasColumnType("datetime2"); + + b.Property<long>("Status") + .HasColumnType("bigint"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("TriggerId") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("TriggerType") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.ToTable("ScheduleJobTrigger"); + }); + modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b => { b.Property<Guid>("Id") @@ -969,6 +1218,12 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<int?>("ArrangeStatus") + .HasColumnType("int"); + + b.Property<DateTime?>("ArrangeTime") + .HasColumnType("datetime2"); + b.Property<Guid?>("CreatedEnterpriseId") .HasColumnType("uniqueidentifier"); @@ -978,20 +1233,11 @@ b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<int>("HireStatus") - .HasColumnType("int"); - - b.Property<DateTime?>("HireTime") - .HasColumnType("datetime2"); + b.Property<Guid>("EnterpriseEmployeeId") + .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") .HasColumnType("bit"); - - b.Property<int?>("SignContractStatus") - .HasColumnType("int"); - - b.Property<DateTime?>("SignContractTime") - .HasColumnType("datetime2"); b.Property<int>("Sort") .HasColumnType("int"); @@ -1008,10 +1254,12 @@ b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("UserId") + b.Property<Guid?>("UserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); + + b.HasIndex("EnterpriseEmployeeId"); b.HasIndex("TaskInfoId"); @@ -1032,8 +1280,15 @@ b.Property<string>("Avatar") .HasColumnType("nvarchar(max)"); + b.Property<DateTime?>("Birthday") + .HasColumnType("datetime2"); + b.Property<string>("CityCode") .HasColumnType("nvarchar(128)"); + + b.Property<string>("ContactPhoneNumber") + .HasMaxLength(11) + .HasColumnType("nvarchar(11)"); b.Property<Guid?>("CreatedEnterpriseId") .HasColumnType("uniqueidentifier"); @@ -1044,10 +1299,19 @@ b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); + b.Property<string>("EducationalBackgroundCode") + .HasColumnType("nvarchar(128)"); + b.Property<Guid?>("EnterpriseId") .HasColumnType("uniqueidentifier"); + b.Property<int?>("FreeTime") + .HasColumnType("int"); + b.Property<int?>("Gender") + .HasColumnType("int"); + + b.Property<int?>("Height") .HasColumnType("int"); b.Property<string>("Identity") @@ -1062,6 +1326,9 @@ b.Property<bool>("IsReal") .HasColumnType("bit"); + b.Property<int?>("JobSeekingStatus") + .HasColumnType("int"); + b.Property<int>("Level") .HasColumnType("int"); @@ -1072,6 +1339,9 @@ b.Property<string>("Password") .HasColumnType("nvarchar(max)"); + b.Property<string>("PersonalIdentityCode") + .HasColumnType("nvarchar(128)"); + b.Property<string>("PhoneNumber") .HasMaxLength(11) .HasColumnType("nvarchar(11)"); @@ -1081,6 +1351,12 @@ b.Property<int?>("RealAccess") .HasColumnType("int"); + + b.Property<int?>("RealMethod") + .HasColumnType("int"); + + b.Property<DateTime?>("RealTime") + .HasColumnType("datetime2"); b.Property<string>("Remark") .HasColumnType("nvarchar(max)"); @@ -1108,6 +1384,15 @@ .HasMaxLength(32) .HasColumnType("nvarchar(32)"); + b.Property<int?>("Weight") + .HasColumnType("int"); + + b.Property<string>("WorkExperience") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("WorkSeniority") + .HasColumnType("nvarchar(max)"); + b.Property<string>("WxmpOpenId") .HasMaxLength(32) .HasColumnType("nvarchar(32)"); @@ -1116,7 +1401,11 @@ b.HasIndex("CityCode"); + b.HasIndex("EducationalBackgroundCode"); + b.HasIndex("EnterpriseId"); + + b.HasIndex("PersonalIdentityCode"); b.HasIndex("ProvinceCode"); @@ -1265,7 +1554,6 @@ .HasColumnType("nvarchar(max)"); b.Property<string>("Code") - .IsRequired() .HasMaxLength(128) .HasColumnType("nvarchar(128)"); @@ -1384,12 +1672,12 @@ b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<bool>("IsDeleted") - .HasColumnType("bit"); - - b.Property<string>("PersonalIdentityCode") + b.Property<string>("ExpectJobCode") .IsRequired() .HasColumnType("nvarchar(128)"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); b.Property<int>("Sort") .HasColumnType("int"); @@ -1408,7 +1696,7 @@ b.HasKey("Id"); - b.HasIndex("PersonalIdentityCode"); + b.HasIndex("ExpectJobCode"); b.HasIndex("UserId"); @@ -1458,74 +1746,6 @@ b.ToTable("UserPhoto"); }); - modelBuilder.Entity("FlexJobApi.Core.UserResume", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uniqueidentifier"); - - b.Property<Guid?>("CreatedEnterpriseId") - .HasColumnType("uniqueidentifier"); - - b.Property<DateTimeOffset>("CreatedTime") - .HasColumnType("datetimeoffset"); - - b.Property<Guid?>("CreatedUserId") - .HasColumnType("uniqueidentifier"); - - b.Property<string>("EducationalBackgroundCode") - .HasColumnType("nvarchar(128)"); - - b.Property<int?>("FreeTime") - .HasColumnType("int"); - - b.Property<int?>("Height") - .HasColumnType("int"); - - b.Property<bool>("IsDeleted") - .HasColumnType("bit"); - - b.Property<int?>("JobSeekingStatus") - .HasColumnType("int"); - - b.Property<string>("PersonalIdentityCode") - .HasColumnType("nvarchar(128)"); - - b.Property<int>("Sort") - .HasColumnType("int"); - - b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)"); - - b.Property<DateTimeOffset?>("UpdatedTime") - .HasColumnType("datetimeoffset"); - - b.Property<Guid?>("UpdatedUserId") - .HasColumnType("uniqueidentifier"); - - b.Property<Guid>("UserId") - .HasColumnType("uniqueidentifier"); - - b.Property<int?>("Weight") - .HasColumnType("int"); - - b.Property<string>("WorkExperience") - .HasColumnType("nvarchar(max)"); - - b.Property<string>("WorkSeniority") - .HasColumnType("nvarchar(max)"); - - b.HasKey("Id"); - - b.HasIndex("EducationalBackgroundCode"); - - b.HasIndex("PersonalIdentityCode"); - - b.HasIndex("UserId"); - - b.ToTable("UserResume"); - }); - modelBuilder.Entity("FlexJobApi.Core.UserRole", b => { b.Property<Guid>("Id") @@ -1569,6 +1789,51 @@ b.HasIndex("UserId"); b.ToTable("UserRole"); + }); + + modelBuilder.Entity("FlexJobApi.Core.UserTaskCollect", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<Guid>("TaskInfoId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<Guid>("UserId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.HasIndex("TaskInfoId"); + + b.HasIndex("UserId"); + + b.ToTable("UserTaskCollect"); }); modelBuilder.Entity("FlexJobApi.Core.Department", b => @@ -1641,6 +1906,23 @@ .IsRequired(); b.Navigation("Enterprise"); + }); + + modelBuilder.Entity("FlexJobApi.Core.EnterpriseEmployee", b => + { + b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise") + .WithMany() + .HasForeignKey("EnterpriseId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany() + .HasForeignKey("UserId"); + + b.Navigation("Enterprise"); + + b.Navigation("User"); }); modelBuilder.Entity("FlexJobApi.Core.Menu", b => @@ -1759,21 +2041,25 @@ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b => { + b.HasOne("FlexJobApi.Core.EnterpriseEmployee", "EnterpriseEmployee") + .WithMany("TaskInfoUsers") + .HasForeignKey("EnterpriseEmployeeId") + .OnDelete(DeleteBehavior.Restrict) + .IsRequired(); + b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo") - .WithMany("Users") + .WithMany("TaskInfoUsers") .HasForeignKey("TaskInfoId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.HasOne("FlexJobApi.Core.User", "User") - .WithMany() - .HasForeignKey("UserId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); + b.HasOne("FlexJobApi.Core.User", null) + .WithMany("TaskInfoUsers") + .HasForeignKey("UserId"); + + b.Navigation("EnterpriseEmployee"); b.Navigation("TaskInfo"); - - b.Navigation("User"); }); modelBuilder.Entity("FlexJobApi.Core.User", b => @@ -1784,9 +2070,21 @@ .HasPrincipalKey("Code") .OnDelete(DeleteBehavior.Restrict); + b.HasOne("FlexJobApi.Core.DictionaryData", "EducationalBackground") + .WithMany() + .HasForeignKey("EducationalBackgroundCode") + .HasPrincipalKey("Code") + .OnDelete(DeleteBehavior.Restrict); + b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise") .WithMany("Users") .HasForeignKey("EnterpriseId"); + + b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity") + .WithMany() + .HasForeignKey("PersonalIdentityCode") + .HasPrincipalKey("Code") + .OnDelete(DeleteBehavior.Restrict); b.HasOne("FlexJobApi.Core.DictionaryData", "Province") .WithMany() @@ -1796,7 +2094,11 @@ b.Navigation("City"); + b.Navigation("EducationalBackground"); + b.Navigation("Enterprise"); + + b.Navigation("PersonalIdentity"); b.Navigation("Province"); }); @@ -1864,9 +2166,9 @@ modelBuilder.Entity("FlexJobApi.Core.UserExpectJob", b => { - b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity") + b.HasOne("FlexJobApi.Core.DictionaryData", "ExpectJob") .WithMany() - .HasForeignKey("PersonalIdentityCode") + .HasForeignKey("ExpectJobCode") .HasPrincipalKey("Code") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); @@ -1877,7 +2179,7 @@ .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.Navigation("PersonalIdentity"); + b.Navigation("ExpectJob"); b.Navigation("User"); }); @@ -1889,33 +2191,6 @@ .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - - b.Navigation("User"); - }); - - modelBuilder.Entity("FlexJobApi.Core.UserResume", b => - { - b.HasOne("FlexJobApi.Core.DictionaryData", "EducationalBackground") - .WithMany() - .HasForeignKey("EducationalBackgroundCode") - .HasPrincipalKey("Code") - .OnDelete(DeleteBehavior.Restrict); - - b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity") - .WithMany() - .HasForeignKey("PersonalIdentityCode") - .HasPrincipalKey("Code") - .OnDelete(DeleteBehavior.Restrict); - - b.HasOne("FlexJobApi.Core.User", "User") - .WithMany() - .HasForeignKey("UserId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("EducationalBackground"); - - b.Navigation("PersonalIdentity"); b.Navigation("User"); }); @@ -1939,6 +2214,25 @@ b.Navigation("User"); }); + modelBuilder.Entity("FlexJobApi.Core.UserTaskCollect", b => + { + b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo") + .WithMany() + .HasForeignKey("TaskInfoId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany() + .HasForeignKey("UserId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("TaskInfo"); + + b.Navigation("User"); + }); + modelBuilder.Entity("FlexJobApi.Core.Department", b => { b.Navigation("Children"); @@ -1956,6 +2250,11 @@ b.Navigation("EnterpriseAuth"); b.Navigation("Users"); + }); + + modelBuilder.Entity("FlexJobApi.Core.EnterpriseEmployee", b => + { + b.Navigation("TaskInfoUsers"); }); modelBuilder.Entity("FlexJobApi.Core.Menu", b => @@ -1978,7 +2277,7 @@ b.Navigation("CredentialLimits"); - b.Navigation("Users"); + b.Navigation("TaskInfoUsers"); }); modelBuilder.Entity("FlexJobApi.Core.User", b => @@ -1987,6 +2286,8 @@ b.Navigation("Photos"); + b.Navigation("TaskInfoUsers"); + b.Navigation("UserAuth"); b.Navigation("UserCredentials"); -- Gitblit v1.9.1