feat:字典开发

sunpengfei

2025-08-07 b4943813a032976e0febdd7f22d8bcf084e331c5

 FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs

@@ -135,6 +135,7 @@
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("Code")
                        .IsRequired()
                        .HasMaxLength(128)
                        .HasColumnType("nvarchar(128)");

@@ -191,6 +192,9 @@

                    b.HasIndex("CategoryId");

                    b.HasIndex("Code")
                        .IsUnique();

                    b.HasIndex("ParentId");

                    b.ToTable("DictionaryData");
@@ -212,8 +216,8 @@
                    b.Property<string>("BankName")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("CityId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("CityCode")
                        .HasColumnType("nvarchar(128)");

                    b.Property<string>("ContactEmail")
                        .HasColumnType("nvarchar(max)");
@@ -235,8 +239,8 @@
                    b.Property<Guid>("EnterpriseAuthId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<Guid?>("IndustryTypeId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("IndustryTypeCode")
                        .HasColumnType("nvarchar(128)");

                    b.Property<bool>("IsCheckedBankCard")
                        .HasColumnType("bit");
@@ -253,8 +257,8 @@
                    b.Property<int?>("PayAccess")
                        .HasColumnType("int");

                    b.Property<Guid?>("ProvinceId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("ProvinceCode")
                        .HasColumnType("nvarchar(128)");

                    b.Property<int?>("RealAccess")
                        .HasColumnType("int");
@@ -285,13 +289,13 @@

                    b.HasKey("Id");

                    b.HasIndex("CityId");
                    b.HasIndex("CityCode");

                    b.HasIndex("EnterpriseAuthId");

                    b.HasIndex("IndustryTypeId");
                    b.HasIndex("IndustryTypeCode");

                    b.HasIndex("ProvinceId");
                    b.HasIndex("ProvinceCode");

                    b.ToTable("Enterprise");
                });
@@ -733,8 +737,8 @@
                    b.Property<int>("BillingMethod")
                        .HasColumnType("int");

                    b.Property<Guid>("CityId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("CityCode")
                        .HasColumnType("nvarchar(128)");

                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");
@@ -758,6 +762,9 @@
                        .IsRequired()
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ProvinceCode")
                        .HasColumnType("nvarchar(128)");

                    b.Property<decimal>("ServiceFee")
                        .HasColumnType("decimal(18,2)");

@@ -778,9 +785,11 @@

                    b.HasKey("Id");

                    b.HasIndex("CityId");
                    b.HasIndex("CityCode");

                    b.HasIndex("EnterpriseId");

                    b.HasIndex("ProvinceCode");

                    b.ToTable("TaskInfo");
                });
@@ -791,8 +800,9 @@
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<Guid>("BenefitId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("BenefitCode")
                        .IsRequired()
                        .HasColumnType("nvarchar(128)");

                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");
@@ -820,7 +830,7 @@

                    b.HasKey("Id");

                    b.HasIndex("BenefitId");
                    b.HasIndex("BenefitCode");

                    b.HasIndex("TaskInfoId");

@@ -851,8 +861,9 @@
                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("TypeId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("TypeCode")
                        .IsRequired()
                        .HasColumnType("nvarchar(128)");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");
@@ -864,7 +875,7 @@

                    b.HasIndex("TaskInfoId");

                    b.HasIndex("TypeId");
                    b.HasIndex("TypeCode");

                    b.ToTable("TaskInfoCredentialLimit");
                });
@@ -1020,8 +1031,8 @@
                    b.Property<string>("Avatar")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("CityId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("CityCode")
                        .HasColumnType("nvarchar(128)");

                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");
@@ -1029,8 +1040,8 @@
                    b.Property<Guid?>("CreatedUserInfoId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<Guid?>("EducationalBackgroundId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("EducationalBackgroundCode")
                        .HasColumnType("nvarchar(128)");

                    b.Property<Guid?>("EnterpriseId")
                        .HasColumnType("uniqueidentifier");
@@ -1050,11 +1061,11 @@
                    b.Property<int>("Level")
                        .HasColumnType("int");

                    b.Property<Guid?>("PersonalIdentityId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("PersonalIdentityCode")
                        .HasColumnType("nvarchar(128)");

                    b.Property<Guid?>("ProvinceId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("ProvinceCode")
                        .HasColumnType("nvarchar(128)");

                    b.Property<string>("Remark")
                        .HasColumnType("nvarchar(max)");
@@ -1095,15 +1106,15 @@

                    b.HasKey("Id");

                    b.HasIndex("CityId");
                    b.HasIndex("CityCode");

                    b.HasIndex("EducationalBackgroundId");
                    b.HasIndex("EducationalBackgroundCode");

                    b.HasIndex("EnterpriseId");

                    b.HasIndex("PersonalIdentityId");
                    b.HasIndex("PersonalIdentityCode");

                    b.HasIndex("ProvinceId");
                    b.HasIndex("ProvinceCode");

                    b.HasIndex("UserAuthId");

@@ -1219,8 +1230,9 @@
                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("TypeId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("TypeCode")
                        .IsRequired()
                        .HasColumnType("nvarchar(128)");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");
@@ -1233,7 +1245,7 @@

                    b.HasKey("Id");

                    b.HasIndex("TypeId");
                    b.HasIndex("TypeCode");

                    b.HasIndex("UserInfoId");

@@ -1297,8 +1309,9 @@
                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit");

                    b.Property<Guid>("PersonalIdentityId")
                        .HasColumnType("uniqueidentifier");
                    b.Property<string>("PersonalIdentityCode")
                        .IsRequired()
                        .HasColumnType("nvarchar(128)");

                    b.Property<int>("Sort")
                        .HasColumnType("int");
@@ -1317,7 +1330,7 @@

                    b.HasKey("Id");

                    b.HasIndex("PersonalIdentityId");
                    b.HasIndex("PersonalIdentityCode");

                    b.HasIndex("UserInfoId");

@@ -1444,7 +1457,9 @@
                {
                    b.HasOne("FlexJobApi.Core.DictionaryData", "City")
                        .WithMany()
                        .HasForeignKey("CityId");
                        .HasForeignKey("CityCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict);

                    b.HasOne("FlexJobApi.Core.EnterpriseAuth", "EnterpriseAuth")
                        .WithMany()
@@ -1454,11 +1469,15 @@

                    b.HasOne("FlexJobApi.Core.DictionaryData", "IndustryType")
                        .WithMany()
                        .HasForeignKey("IndustryTypeId");
                        .HasForeignKey("IndustryTypeCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict);

                    b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
                        .WithMany()
                        .HasForeignKey("ProvinceId");
                        .HasForeignKey("ProvinceCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict);

                    b.Navigation("City");

@@ -1520,9 +1539,9 @@
                {
                    b.HasOne("FlexJobApi.Core.DictionaryData", "City")
                        .WithMany()
                        .HasForeignKey("CityId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();
                        .HasForeignKey("CityCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict);

                    b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
                        .WithMany()
@@ -1530,17 +1549,26 @@
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
                        .WithMany()
                        .HasForeignKey("ProvinceCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict);

                    b.Navigation("City");

                    b.Navigation("Enterprise");

                    b.Navigation("Province");
                });

            modelBuilder.Entity("FlexJobApi.Core.TaskInfoBenefit", b =>
                {
                    b.HasOne("FlexJobApi.Core.DictionaryData", "Benefit")
                        .WithMany()
                        .HasForeignKey("BenefitId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .HasForeignKey("BenefitCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
@@ -1564,7 +1592,10 @@

                    b.HasOne("FlexJobApi.Core.DictionaryData", "Type")
                        .WithMany()
                        .HasForeignKey("TypeId");
                        .HasForeignKey("TypeCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.Navigation("TaskInfo");

@@ -1594,11 +1625,15 @@
                {
                    b.HasOne("FlexJobApi.Core.DictionaryData", "City")
                        .WithMany()
                        .HasForeignKey("CityId");
                        .HasForeignKey("CityCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict);

                    b.HasOne("FlexJobApi.Core.DictionaryData", "EducationalBackground")
                        .WithMany()
                        .HasForeignKey("EducationalBackgroundId");
                        .HasForeignKey("EducationalBackgroundCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict);

                    b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
                        .WithMany("UserInfos")
@@ -1606,11 +1641,15 @@

                    b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity")
                        .WithMany()
                        .HasForeignKey("PersonalIdentityId");
                        .HasForeignKey("PersonalIdentityCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict);

                    b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
                        .WithMany()
                        .HasForeignKey("ProvinceId");
                        .HasForeignKey("ProvinceCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict);

                    b.HasOne("FlexJobApi.Core.UserAuth", "UserAuth")
                        .WithMany("UserInfos")
@@ -1646,7 +1685,10 @@
                {
                    b.HasOne("FlexJobApi.Core.DictionaryData", "Type")
                        .WithMany()
                        .HasForeignKey("TypeId");
                        .HasForeignKey("TypeCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")
                        .WithMany("UserInfoCredentials")
@@ -1682,8 +1724,9 @@
                {
                    b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity")
                        .WithMany()
                        .HasForeignKey("PersonalIdentityId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .HasForeignKey("PersonalIdentityCode")
                        .HasPrincipalKey("Code")
                        .OnDelete(DeleteBehavior.Restrict)
                        .IsRequired();

                    b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")