From 23e80983df6bbf508642b4d7f7b2ace36a0264c5 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期一, 18 八月 2025 13:54:16 +0800 Subject: [PATCH] feat:开发 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 466 +++++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 383 insertions(+), 83 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index 51515c9..722f1c0 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -218,6 +218,9 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<string>("Address") + .HasColumnType("nvarchar(max)"); + b.Property<string>("BankBranchName") .HasColumnType("nvarchar(max)"); @@ -255,6 +258,15 @@ .IsRequired() .HasMaxLength(128) .HasColumnType("nvarchar(128)"); + + b.Property<string>("EnterpriseType") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("EstablishmentDate") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("IndustrialParkId") + .HasColumnType("uniqueidentifier"); b.Property<string>("IndustryTypeCode") .HasColumnType("nvarchar(128)"); @@ -296,6 +308,9 @@ b.Property<decimal?>("RealVerifyCost") .HasColumnType("decimal(18,2)"); + + b.Property<string>("RegisteredCapital") + .HasColumnType("nvarchar(max)"); b.Property<decimal?>("SignCost") .HasColumnType("decimal(18,2)"); @@ -436,6 +451,9 @@ b.Property<int?>("Age") .HasColumnType("int"); + b.Property<DateTime?>("Birthday") + .HasColumnType("datetime2"); + b.Property<string>("ContactPhoneNumber") .HasMaxLength(11) .HasColumnType("nvarchar(11)"); @@ -463,12 +481,6 @@ 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)"); @@ -514,6 +526,63 @@ b.HasIndex("UserId"); b.ToTable("EnterpriseEmployee"); + }); + + modelBuilder.Entity("FlexJobApi.Core.EnterpriseUserCollect", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<DateTime?>("CollectedTime") + .HasColumnType("datetime2"); + + b.Property<DateTime?>("ContactedTime") + .HasColumnType("datetime2"); + + 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<bool>("IsCollected") + .HasColumnType("bit"); + + b.Property<bool>("IsContacted") + .HasColumnType("bit"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + 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.HasKey("Id"); + + b.HasIndex("EnterpriseId"); + + b.HasIndex("UserId"); + + b.ToTable("EnterpriseUserCollect"); }); modelBuilder.Entity("FlexJobApi.Core.Menu", b => @@ -643,6 +712,9 @@ b.Property<string>("DynamicAssemblyName") .HasColumnType("nvarchar(max)"); + + b.Property<bool>("FileUpload") + .HasColumnType("bit"); b.Property<bool>("IsDeleted") .HasColumnType("bit"); @@ -1039,6 +1111,9 @@ b.Property<int?>("CheckReceiveStatus") .HasColumnType("int"); + b.Property<DateTime?>("CheckReceiveTime") + .HasColumnType("datetime2"); + b.Property<string>("CityCode") .HasColumnType("nvarchar(128)"); @@ -1065,6 +1140,12 @@ b.Property<bool>("IsDeleted") .HasColumnType("bit"); + + b.Property<DateTime?>("LastCheckReceiveTime") + .HasColumnType("datetime2"); + + b.Property<DateTime?>("LastSubmitTime") + .HasColumnType("datetime2"); b.Property<decimal?>("Latitude") .HasColumnType("decimal(18,6)"); @@ -1224,6 +1305,12 @@ b.Property<DateTime?>("ArrangeTime") .HasColumnType("datetime2"); + b.Property<int?>("CheckReceiveStatus") + .HasColumnType("int"); + + b.Property<DateTime?>("CheckReceiveTime") + .HasColumnType("datetime2"); + b.Property<Guid?>("CreatedEnterpriseId") .HasColumnType("uniqueidentifier"); @@ -1234,6 +1321,153 @@ .HasColumnType("uniqueidentifier"); b.Property<Guid>("EnterpriseEmployeeId") + .HasColumnType("uniqueidentifier"); + + b.Property<int>("HireStatus") + .HasColumnType("int"); + + b.Property<DateTime?>("HireTime") + .HasColumnType("datetime2"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<DateTime?>("LastCheckReceiveTime") + .HasColumnType("datetime2"); + + b.Property<DateTime?>("LastSubmitTime") + .HasColumnType("datetime2"); + + 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.HasKey("Id"); + + b.HasIndex("EnterpriseEmployeeId"); + + b.HasIndex("TaskInfoId"); + + b.ToTable("TaskInfoUser"); + }); + + modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmit", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<int>("CheckReceiveStatus") + .HasColumnType("int"); + + b.Property<DateTime?>("CheckReceiveTime") + .HasColumnType("datetime2"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTime>("Date") + .HasColumnType("datetime2"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<Guid>("TaskInfoUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.HasIndex("TaskInfoUserId"); + + b.ToTable("TaskInfoUserSubmit"); + }); + + modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmitFile", 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>("File") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<Guid>("SubmitId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.HasIndex("SubmitId"); + + b.ToTable("TaskInfoUserSubmitFile"); + }); + + modelBuilder.Entity("FlexJobApi.Core.TaskUserCollect", 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") @@ -1254,18 +1488,16 @@ 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"); b.HasIndex("UserId"); - b.ToTable("TaskInfoUser"); + b.ToTable("TaskUserCollect"); }); modelBuilder.Entity("FlexJobApi.Core.User", b => @@ -1297,6 +1529,12 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<int?>("DataSource") + .HasColumnType("int"); + + b.Property<Guid?>("DataSourceId") .HasColumnType("uniqueidentifier"); b.Property<string>("EducationalBackgroundCode") @@ -1566,7 +1804,7 @@ b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<DateTime>("EndDate") + b.Property<DateTime?>("EndDate") .HasColumnType("datetime2"); b.Property<string>("Img") @@ -1584,7 +1822,7 @@ b.Property<int>("Sort") .HasColumnType("int"); - b.Property<DateTime>("StartDate") + b.Property<DateTime?>("StartDate") .HasColumnType("datetime2"); b.Property<string>("TraceId") @@ -1703,6 +1941,49 @@ b.ToTable("UserExpectJob"); }); + modelBuilder.Entity("FlexJobApi.Core.UserManageIndustrialPark", 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<Guid>("IndustrialParkId") + .HasColumnType("uniqueidentifier"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + 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.HasKey("Id"); + + b.HasIndex("UserId"); + + b.ToTable("UserManageIndustrialPark"); + }); + modelBuilder.Entity("FlexJobApi.Core.UserPhoto", b => { b.Property<Guid>("Id") @@ -1791,51 +2072,6 @@ 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 => { b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise") @@ -1917,8 +2153,27 @@ .IsRequired(); b.HasOne("FlexJobApi.Core.User", "User") - .WithMany() + .WithMany("EnterpriseEmployees") .HasForeignKey("UserId"); + + b.Navigation("Enterprise"); + + b.Navigation("User"); + }); + + modelBuilder.Entity("FlexJobApi.Core.EnterpriseUserCollect", b => + { + b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise") + .WithMany() + .HasForeignKey("EnterpriseId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany("EnterpriseUserCollects") + .HasForeignKey("UserId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); b.Navigation("Enterprise"); @@ -2053,13 +2308,50 @@ .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.HasOne("FlexJobApi.Core.User", null) - .WithMany("TaskInfoUsers") - .HasForeignKey("UserId"); - b.Navigation("EnterpriseEmployee"); b.Navigation("TaskInfo"); + }); + + modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmit", b => + { + b.HasOne("FlexJobApi.Core.TaskInfoUser", "TaskInfoUser") + .WithMany("Submits") + .HasForeignKey("TaskInfoUserId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("TaskInfoUser"); + }); + + modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmitFile", b => + { + b.HasOne("FlexJobApi.Core.TaskInfoUserSubmit", "Submit") + .WithMany("Files") + .HasForeignKey("SubmitId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("Submit"); + }); + + modelBuilder.Entity("FlexJobApi.Core.TaskUserCollect", b => + { + b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo") + .WithMany("TaskUserCollects") + .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.User", b => @@ -2184,6 +2476,17 @@ b.Navigation("User"); }); + modelBuilder.Entity("FlexJobApi.Core.UserManageIndustrialPark", b => + { + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany("UserManageIndustrialParks") + .HasForeignKey("UserId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("User"); + }); + modelBuilder.Entity("FlexJobApi.Core.UserPhoto", b => { b.HasOne("FlexJobApi.Core.User", "User") @@ -2210,25 +2513,6 @@ .IsRequired(); b.Navigation("Role"); - - 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"); }); @@ -2278,15 +2562,29 @@ b.Navigation("CredentialLimits"); b.Navigation("TaskInfoUsers"); + + b.Navigation("TaskUserCollects"); + }); + + modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b => + { + b.Navigation("Submits"); + }); + + modelBuilder.Entity("FlexJobApi.Core.TaskInfoUserSubmit", b => + { + b.Navigation("Files"); }); modelBuilder.Entity("FlexJobApi.Core.User", b => { b.Navigation("BankCards"); - b.Navigation("Photos"); + b.Navigation("EnterpriseEmployees"); - b.Navigation("TaskInfoUsers"); + b.Navigation("EnterpriseUserCollects"); + + b.Navigation("Photos"); b.Navigation("UserAuth"); @@ -2296,6 +2594,8 @@ b.Navigation("UserExpectJobs"); + b.Navigation("UserManageIndustrialParks"); + b.Navigation("UserRoles"); }); #pragma warning restore 612, 618 -- Gitblit v1.9.1