From 29767916b8e523a425970b3e21397f39803ac2b7 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期一, 11 八月 2025 15:17:50 +0800 Subject: [PATCH] feat:开发 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 348 +++++++++++++++++++++++++++++++++++++++------------------ 1 files changed, 237 insertions(+), 111 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index 5e897d6..3503226 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -577,11 +577,9 @@ .HasColumnType("nvarchar(max)"); b.Property<string>("ResponseTypeFullName") - .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ResponseTypeName") - .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("Route") @@ -765,6 +763,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") @@ -820,10 +978,10 @@ .HasColumnType("bit"); b.Property<decimal?>("Latitude") - .HasColumnType("decimal(18,2)"); + .HasColumnType("decimal(18,6)"); b.Property<decimal?>("Longitude") - .HasColumnType("decimal(18,2)"); + .HasColumnType("decimal(18,6)"); b.Property<string>("Name") .IsRequired() @@ -1028,11 +1186,21 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<int?>("Age") + .HasColumnType("int"); + 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"); @@ -1043,8 +1211,23 @@ 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") + .HasColumnType("nvarchar(max)"); b.Property<bool>("IsCheckPhoneNumber") .HasColumnType("bit"); @@ -1055,16 +1238,21 @@ b.Property<bool>("IsReal") .HasColumnType("bit"); + b.Property<int?>("JobSeekingStatus") + .HasColumnType("int"); + b.Property<int>("Level") .HasColumnType("int"); b.Property<string>("Name") - .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.Property<string>("Password") .HasColumnType("nvarchar(max)"); + + b.Property<string>("PersonalIdentityCode") + .HasColumnType("nvarchar(128)"); b.Property<string>("PhoneNumber") .HasMaxLength(11) @@ -1074,6 +1262,9 @@ .HasColumnType("nvarchar(128)"); b.Property<int?>("RealAccess") + .HasColumnType("int"); + + b.Property<int?>("RealMethod") .HasColumnType("int"); b.Property<string>("Remark") @@ -1102,6 +1293,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)"); @@ -1110,7 +1310,11 @@ b.HasIndex("CityCode"); + b.HasIndex("EducationalBackgroundCode"); + b.HasIndex("EnterpriseId"); + + b.HasIndex("PersonalIdentityCode"); b.HasIndex("ProvinceCode"); @@ -1259,7 +1463,6 @@ .HasColumnType("nvarchar(max)"); b.Property<string>("Code") - .IsRequired() .HasMaxLength(128) .HasColumnType("nvarchar(128)"); @@ -1378,12 +1581,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"); @@ -1402,7 +1605,7 @@ b.HasKey("Id"); - b.HasIndex("PersonalIdentityCode"); + b.HasIndex("ExpectJobCode"); b.HasIndex("UserId"); @@ -1450,74 +1653,6 @@ b.HasIndex("UserId"); 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 => @@ -1723,7 +1858,7 @@ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo") .WithMany("Benefits") .HasForeignKey("TaskInfoId") - .OnDelete(DeleteBehavior.Restrict) + .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Benefit"); @@ -1754,7 +1889,7 @@ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b => { b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo") - .WithMany() + .WithMany("Users") .HasForeignKey("TaskInfoId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); @@ -1778,9 +1913,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() @@ -1790,7 +1937,11 @@ b.Navigation("City"); + b.Navigation("EducationalBackground"); + b.Navigation("Enterprise"); + + b.Navigation("PersonalIdentity"); b.Navigation("Province"); }); @@ -1858,9 +2009,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(); @@ -1871,7 +2022,7 @@ .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.Navigation("PersonalIdentity"); + b.Navigation("ExpectJob"); b.Navigation("User"); }); @@ -1883,33 +2034,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"); }); @@ -1971,6 +2095,8 @@ b.Navigation("Benefits"); b.Navigation("CredentialLimits"); + + b.Navigation("Users"); }); modelBuilder.Entity("FlexJobApi.Core.User", b => -- Gitblit v1.9.1