From fb98eea517acdef61d9d9c1a1f537a728282fac9 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期五, 22 八月 2025 10:01:54 +0800 Subject: [PATCH] feat:开发 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 513 +++++++++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 442 insertions(+), 71 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index 03f805a..11b3f64 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -22,6 +22,143 @@ SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); + modelBuilder.Entity("FlexJobApi.Core.ContractTemplate", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<int?>("Access") + .HasColumnType("int"); + + b.Property<string>("Code") + .HasMaxLength(32) + .HasColumnType("nvarchar(32)"); + + b.Property<DateTime?>("CompletedTime") + .HasColumnType("datetime2"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<Guid?>("ElectronSignContractTemplateId") + .HasColumnType("uniqueidentifier"); + + b.Property<Guid>("EnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("File") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<bool>("IsDisabled") + .HasColumnType("bit"); + + b.Property<string>("Name") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<int>("Status") + .HasColumnType("int"); + + b.Property<string>("TemplateEditData") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("TemplateId") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("TemplateJsonData") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("WxmpQrCode") + .HasColumnType("nvarchar(max)"); + + b.HasKey("Id"); + + b.HasIndex("EnterpriseId"); + + b.ToTable("ContractTemplate"); + }); + + modelBuilder.Entity("FlexJobApi.Core.ContractTemplateValue", 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<string>("Label") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("Name") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("Recorder") + .HasColumnType("int"); + + b.Property<bool>("Required") + .HasColumnType("bit"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<Guid>("TemplateId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("Type") + .HasColumnType("int"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<int?>("UserType") + .HasColumnType("int"); + + b.HasKey("Id"); + + b.HasIndex("TemplateId"); + + b.ToTable("ContractTemplateValue"); + }); + modelBuilder.Entity("FlexJobApi.Core.Department", b => { b.Property<Guid>("Id") @@ -218,6 +355,9 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<string>("Address") + .HasColumnType("nvarchar(max)"); + b.Property<string>("BankBranchName") .HasColumnType("nvarchar(max)"); @@ -255,6 +395,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 +445,9 @@ b.Property<decimal?>("RealVerifyCost") .HasColumnType("decimal(18,2)"); + + b.Property<string>("RegisteredCapital") + .HasColumnType("nvarchar(max)"); b.Property<decimal?>("SignCost") .HasColumnType("decimal(18,2)"); @@ -347,6 +499,9 @@ b.Property<string>("BankCardImg") .HasColumnType("nvarchar(max)"); + b.Property<string>("CertAccount") + .HasColumnType("nvarchar(max)"); + b.Property<Guid?>("CreatedEnterpriseId") .HasColumnType("uniqueidentifier"); @@ -354,6 +509,9 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<Guid?>("ElectronSignEnterpriseId") .HasColumnType("uniqueidentifier"); b.Property<string>("EnterpriseName") @@ -436,6 +594,9 @@ b.Property<int?>("Age") .HasColumnType("int"); + b.Property<DateTime?>("Birthday") + .HasColumnType("datetime2"); + b.Property<string>("ContactPhoneNumber") .HasMaxLength(11) .HasColumnType("nvarchar(11)"); @@ -463,12 +624,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 +669,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 => @@ -626,8 +838,8 @@ .IsRequired() .HasColumnType("nvarchar(max)"); - b.Property<int>("Controller") - .HasColumnType("int"); + b.Property<string>("ControllerName") + .HasColumnType("nvarchar(max)"); b.Property<string>("ControllerSummary") .HasColumnType("nvarchar(max)"); @@ -643,6 +855,9 @@ b.Property<string>("DynamicAssemblyName") .HasColumnType("nvarchar(max)"); + + b.Property<bool>("FileUpload") + .HasColumnType("bit"); b.Property<bool>("IsDeleted") .HasColumnType("bit"); @@ -677,9 +892,6 @@ b.Property<string>("RouteArea") .HasColumnType("nvarchar(max)"); - - b.Property<int>("Service") - .HasColumnType("int"); b.Property<string>("ServiceName") .HasColumnType("nvarchar(max)"); @@ -1039,6 +1251,9 @@ b.Property<int?>("CheckReceiveStatus") .HasColumnType("int"); + b.Property<DateTime?>("CheckReceiveTime") + .HasColumnType("datetime2"); + b.Property<string>("CityCode") .HasColumnType("nvarchar(128)"); @@ -1066,6 +1281,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)"); @@ -1082,6 +1303,9 @@ b.Property<int>("RecommendStatus") .HasColumnType("int"); + b.Property<DateTime?>("RecommendTime") + .HasColumnType("datetime2"); + b.Property<int>("ReleaseStatus") .HasColumnType("int"); @@ -1093,6 +1317,9 @@ b.Property<int?>("SettlementStatus") .HasColumnType("int"); + + b.Property<DateTime?>("SettlementTime") + .HasColumnType("datetime2"); b.Property<int>("Sort") .HasColumnType("int"); @@ -1242,8 +1469,17 @@ 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"); @@ -1365,6 +1601,51 @@ 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") + .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("TaskUserCollect"); + }); + modelBuilder.Entity("FlexJobApi.Core.User", b => { b.Property<Guid>("Id") @@ -1394,6 +1675,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") @@ -1445,9 +1732,6 @@ b.Property<string>("ProvinceCode") .HasColumnType("nvarchar(128)"); - - b.Property<int?>("RealAccess") - .HasColumnType("int"); b.Property<int?>("RealMethod") .HasColumnType("int"); @@ -1532,12 +1816,18 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<int?>("Age") + .HasColumnType("int"); + b.Property<string>("BankCard") .HasMaxLength(32) .HasColumnType("nvarchar(32)"); b.Property<string>("BankCardImg") .HasColumnType("nvarchar(max)"); + + b.Property<DateTime?>("Birthday") + .HasColumnType("datetime2"); b.Property<Guid?>("CreatedEnterpriseId") .HasColumnType("uniqueidentifier"); @@ -1547,6 +1837,15 @@ b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); + + b.Property<Guid?>("ElectronSignUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("FaceRealUrl") + .HasColumnType("nvarchar(max)"); + + b.Property<int?>("Gender") + .HasColumnType("int"); b.Property<string>("Identity") .HasColumnType("nvarchar(max)"); @@ -1568,6 +1867,15 @@ b.Property<string>("PhoneNumber") .HasMaxLength(11) .HasColumnType("nvarchar(11)"); + + b.Property<int?>("RealAccess") + .HasColumnType("int"); + + b.Property<string>("RealFailMessage") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("RealStatus") + .HasColumnType("int"); b.Property<int>("Sort") .HasColumnType("int"); @@ -1663,7 +1971,7 @@ b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<DateTime>("EndDate") + b.Property<DateTime?>("EndDate") .HasColumnType("datetime2"); b.Property<string>("Img") @@ -1681,7 +1989,7 @@ b.Property<int>("Sort") .HasColumnType("int"); - b.Property<DateTime>("StartDate") + b.Property<DateTime?>("StartDate") .HasColumnType("datetime2"); b.Property<string>("TraceId") @@ -1800,6 +2108,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") @@ -1888,49 +2239,26 @@ b.ToTable("UserRole"); }); - modelBuilder.Entity("FlexJobApi.Core.UserTaskCollect", b => + modelBuilder.Entity("FlexJobApi.Core.ContractTemplate", b => { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uniqueidentifier"); + b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise") + .WithMany("ContractTemplates") + .HasForeignKey("EnterpriseId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); - b.Property<Guid?>("CreatedEnterpriseId") - .HasColumnType("uniqueidentifier"); + b.Navigation("Enterprise"); + }); - b.Property<DateTimeOffset>("CreatedTime") - .HasColumnType("datetimeoffset"); + modelBuilder.Entity("FlexJobApi.Core.ContractTemplateValue", b => + { + b.HasOne("FlexJobApi.Core.ContractTemplate", "Template") + .WithMany("Values") + .HasForeignKey("TemplateId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); - 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"); + b.Navigation("Template"); }); modelBuilder.Entity("FlexJobApi.Core.Department", b => @@ -2016,6 +2344,25 @@ b.HasOne("FlexJobApi.Core.User", "User") .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"); @@ -2177,6 +2524,25 @@ 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 => { b.HasOne("FlexJobApi.Core.DictionaryData", "City") @@ -2299,6 +2665,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") @@ -2329,23 +2706,9 @@ b.Navigation("User"); }); - modelBuilder.Entity("FlexJobApi.Core.UserTaskCollect", b => + modelBuilder.Entity("FlexJobApi.Core.ContractTemplate", 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"); + b.Navigation("Values"); }); modelBuilder.Entity("FlexJobApi.Core.Department", b => @@ -2360,6 +2723,8 @@ modelBuilder.Entity("FlexJobApi.Core.Enterprise", b => { + b.Navigation("ContractTemplates"); + b.Navigation("Departments"); b.Navigation("EnterpriseAuth"); @@ -2393,6 +2758,8 @@ b.Navigation("CredentialLimits"); b.Navigation("TaskInfoUsers"); + + b.Navigation("TaskUserCollects"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b => @@ -2411,6 +2778,8 @@ b.Navigation("EnterpriseEmployees"); + b.Navigation("EnterpriseUserCollects"); + b.Navigation("Photos"); b.Navigation("UserAuth"); @@ -2421,6 +2790,8 @@ b.Navigation("UserExpectJobs"); + b.Navigation("UserManageIndustrialParks"); + b.Navigation("UserRoles"); }); #pragma warning restore 612, 618 -- Gitblit v1.9.1