feat:企业开发

sunpengfei

2025-08-06 c914975bffe90f808a05dba2c53d4a750e8403c0

 FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs

@@ -247,19 +247,26 @@
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("BankBranchName")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("BankCard")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("法人或经办人银行卡号");

                    b.Property<Guid?>("BankCardImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("法人或经办人银行卡照片Id");
                    b.Property<string>("BankName")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ContactNumber")
                    b.Property<Guid?>("CityId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("ContactEmail")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ContactPhoneNumber")
                        .HasMaxLength(11)
                        .HasColumnType("nvarchar(11)")
                        .HasComment("联系电话");
                        .HasColumnType("nvarchar(11)");

                    b.Property<string>("Contacts")
                        .HasMaxLength(32)
@@ -273,77 +280,46 @@
                        .HasColumnType("uniqueidentifier")
                        .HasComment("创建操作人");

                    b.Property<string>("EnterpriseName")
                        .IsRequired()
                        .HasMaxLength(128)
                        .HasColumnType("nvarchar(128)")
                        .HasComment("企业全称");
                    b.Property<Guid>("EnterpriseAuthId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<int?>("EnterpriseRealMethod")
                        .HasColumnType("int")
                        .HasComment("企业认证方式");
                    b.Property<Guid?>("IndustryTypeId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("Identity")
                        .HasMaxLength(18)
                        .HasColumnType("nvarchar(18)")
                        .HasComment("法人或经办人身份证号");

                    b.Property<Guid?>("IdentityBackImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("法人或经办人身份证国徽面Id");

                    b.Property<Guid?>("IdentityImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("法人或经办人身份证人像面Id");
                    b.Property<bool>("IsCheckedBankCard")
                        .HasColumnType("bit");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("是否删除");

                    b.Property<bool>("IsReal")
                        .HasColumnType("bit")
                        .HasComment("是否实名");
                    b.Property<string>("MainBusiness")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("LegalPerson")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("法人姓名");
                    b.Property<decimal?>("MergeSignCost")
                        .HasColumnType("decimal(18,2)");

                    b.Property<Guid?>("LicenseImageId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("营业执照照片Id");
                    b.Property<int?>("PayAccess")
                        .HasColumnType("int");

                    b.Property<string>("Name")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("法人或经办人姓名");

                    b.Property<int?>("PersonalRealMethod")
                        .HasColumnType("int")
                        .HasComment("法人或经办人实名方式");

                    b.Property<string>("PhoneNumber")
                        .HasMaxLength(11)
                        .HasColumnType("nvarchar(11)")
                        .HasComment("法人或经办人手机号");

                    b.Property<bool?>("Proxy")
                        .HasColumnType("bit")
                        .HasComment("是否委托经办人");

                    b.Property<string>("ProxyPowerAttorneyUrl")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("企业授权书");
                    b.Property<Guid?>("ProvinceId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<int?>("RealAccess")
                        .HasColumnType("int")
                        .HasComment("实名通道");

                    b.Property<string>("SocietyCreditCode")
                        .IsRequired()
                        .HasMaxLength(18)
                        .HasColumnType("nvarchar(18)")
                        .HasComment("统一社会信用代码");
                    b.Property<decimal?>("RealVerifyCost")
                        .HasColumnType("decimal(18,2)");

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

                    b.Property<int?>("SmsAccess")
                        .HasColumnType("int");

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

                    b.Property<int>("Sort")
                        .HasColumnType("int")
@@ -362,11 +338,13 @@

                    b.HasKey("Id");

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

                    b.HasIndex("IdentityImgId");
                    b.HasIndex("EnterpriseAuthId");

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

                    b.HasIndex("ProvinceId");

                    b.ToTable("Enterprise", t =>
                        {
@@ -374,73 +352,83 @@
                        });
                });

            modelBuilder.Entity("FlexJobApi.Core.FileStore", b =>
            modelBuilder.Entity("FlexJobApi.Core.EnterpriseAuth", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("AbsolutePath")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("绝对路径");
                    b.Property<string>("BankCard")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)");

                    b.Property<int>("Access")
                        .HasColumnType("int")
                        .HasComment("通道");
                    b.Property<string>("BankCardImg")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ContentType")
                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("CreatedUserInfoId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("创建操作人");

                    b.Property<string>("EnterpriseName")
                        .IsRequired()
                        .HasMaxLength(128)
                        .HasColumnType("nvarchar(128)")
                        .HasComment("内容类型");
                        .HasColumnType("nvarchar(128)");

                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");
                    b.Property<int?>("EnterpriseRealMethod")
                        .HasColumnType("int");

                    b.Property<Guid?>("CreatedUserInfoId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("创建操作人");
                    b.Property<string>("Identity")
                        .HasMaxLength(18)
                        .HasColumnType("nvarchar(18)");

                    b.Property<string>("Extension")
                        .IsRequired()
                    b.Property<string>("IdentityBackImg")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("IdentityImg")
                        .HasColumnType("nvarchar(max)");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("是否删除");

                    b.Property<bool>("IsReal")
                        .HasColumnType("bit");

                    b.Property<string>("LegalIdentity")
                        .HasMaxLength(18)
                        .HasColumnType("nvarchar(18)");

                    b.Property<string>("LegalPerson")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("扩展名");
                        .HasColumnType("nvarchar(32)");

                    b.Property<int>("FileType")
                        .HasColumnType("int")
                        .HasComment("文件类型");

                    b.Property<string>("Hash")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("哈希");

                    b.Property<int?>("ImageHeight")
                        .HasColumnType("int")
                        .HasComment("高度（像素）");

                    b.Property<int?>("ImageWidth")
                        .HasColumnType("int")
                        .HasComment("宽度（像素）");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("是否删除");

                    b.Property<long>("Length")
                        .HasColumnType("bigint")
                        .HasComment("文件大小（字节）");
                    b.Property<string>("LicenseImage")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Name")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("名称");
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)");

                    b.Property<string>("RelativePath")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("相对路径");
                    b.Property<int?>("PersonalRealMethod")
                        .HasColumnType("int");

                    b.Property<string>("PhoneNumber")
                        .HasMaxLength(11)
                        .HasColumnType("nvarchar(11)");

                    b.Property<bool?>("Proxy")
                        .HasColumnType("bit");

                    b.Property<string>("ProxyPowerAttorneyUrl")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("SocietyCreditCode")
                        .IsRequired()
                        .HasMaxLength(18)
                        .HasColumnType("nvarchar(18)");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
@@ -459,66 +447,7 @@

                    b.HasKey("Id");

                    b.ToTable("FileStore", t =>
                        {
                            t.HasComment("文件存储");
                        });
                });

            modelBuilder.Entity("FlexJobApi.Core.FileVirtualPath", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("CreatedUserInfoId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("创建操作人");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
                        .HasComment("是否删除");

                    b.Property<string>("Name")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("名称");

                    b.Property<int>("Sort")
                        .HasColumnType("int")
                        .HasComment("排序");

                    b.Property<Guid>("StoreId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("文件存储Id");

                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("跟踪Id");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("UpdatedUserInfoId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("最后更新操作人");

                    b.Property<string>("VirtualPath")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("虚拟路径");

                    b.HasKey("Id");

                    b.HasIndex("StoreId");

                    b.ToTable("FileVirtualPath", t =>
                        {
                            t.HasComment("文件虚拟路径");
                        });
                    b.ToTable("EnterpriseAuth");
                });

            modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
@@ -1202,18 +1131,14 @@
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<Guid?>("AvatarId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("头像Id");

                    b.Property<string>("BankCard")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("银行卡号");

                    b.Property<Guid?>("BankCardImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("银行卡照片Id");
                    b.Property<string>("BankCardImg")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("银行卡照片");

                    b.Property<DateTimeOffset>("CreatedTime")
                        .HasColumnType("datetimeoffset");
@@ -1226,13 +1151,13 @@
                        .HasColumnType("nvarchar(max)")
                        .HasComment("身份证号");

                    b.Property<Guid?>("IdentityBackImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("身份证国徽面Id");
                    b.Property<string>("IdentityBackImg")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("身份证国徽面");

                    b.Property<Guid?>("IdentityImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("身份证人像面Id");
                    b.Property<string>("IdentityImg")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("身份证人像面");

                    b.Property<bool>("IsCheckPhoneNumber")
                        .HasColumnType("bit")
@@ -1288,14 +1213,6 @@

                    b.HasKey("Id");

                    b.HasIndex("AvatarId");

                    b.HasIndex("BankCardImgId");

                    b.HasIndex("IdentityBackImgId");

                    b.HasIndex("IdentityImgId");

                    b.ToTable("UserAuth", t =>
                        {
                            t.HasComment("用户");
@@ -1321,6 +1238,9 @@
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("Avatar")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("CityId")
                        .HasColumnType("uniqueidentifier")
@@ -1364,6 +1284,9 @@
                    b.Property<Guid?>("PersonalIdentityId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("身份Id");

                    b.Property<Guid?>("ProvinceId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("Remark")
                        .HasColumnType("nvarchar(max)")
@@ -1422,6 +1345,8 @@
                    b.HasIndex("EnterpriseId");

                    b.HasIndex("PersonalIdentityId");

                    b.HasIndex("ProvinceId");

                    b.HasIndex("UserAuthId");

@@ -1514,9 +1439,9 @@
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<Guid?>("BackImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("证书反面照片Id");
                    b.Property<string>("BackImg")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("证书反面照片");

                    b.Property<string>("Code")
                        .IsRequired()
@@ -1535,9 +1460,9 @@
                        .HasColumnType("datetime2")
                        .HasComment("结束日期");

                    b.Property<Guid>("ImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("证书正面照片Id");
                    b.Property<string>("Img")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("证书正面照片");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
@@ -1579,10 +1504,6 @@
                        .HasComment("用户信息Id");

                    b.HasKey("Id");

                    b.HasIndex("BackImgId");

                    b.HasIndex("ImgId");

                    b.HasIndex("TypeId");

@@ -1711,9 +1632,9 @@
                        .HasColumnType("uniqueidentifier")
                        .HasComment("创建操作人");

                    b.Property<Guid>("ImgId")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("照片Id");
                    b.Property<string>("Img")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("照片");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit")
@@ -1739,8 +1660,6 @@
                        .HasComment("用户信息Id");

                    b.HasKey("Id");

                    b.HasIndex("ImgId");

                    b.HasIndex("UserInfoId");

@@ -1838,34 +1757,31 @@

            modelBuilder.Entity("FlexJobApi.Core.Enterprise", b =>
                {
                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "IdentityBackImg")
                    b.HasOne("FlexJobApi.Core.DictionaryData", "City")
                        .WithMany()
                        .HasForeignKey("IdentityBackImgId");
                        .HasForeignKey("CityId");

                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "IdentityImg")
                    b.HasOne("FlexJobApi.Core.EnterpriseAuth", "EnterpriseAuth")
                        .WithMany()
                        .HasForeignKey("IdentityImgId");

                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "LicenseImage")
                        .WithMany()
                        .HasForeignKey("LicenseImageId");

                    b.Navigation("IdentityBackImg");

                    b.Navigation("IdentityImg");

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

            modelBuilder.Entity("FlexJobApi.Core.FileVirtualPath", b =>
                {
                    b.HasOne("FlexJobApi.Core.FileStore", "Store")
                        .WithMany()
                        .HasForeignKey("StoreId")
                        .HasForeignKey("EnterpriseAuthId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("Store");
                    b.HasOne("FlexJobApi.Core.DictionaryData", "IndustryType")
                        .WithMany()
                        .HasForeignKey("IndustryTypeId");

                    b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
                        .WithMany()
                        .HasForeignKey("ProvinceId");

                    b.Navigation("City");

                    b.Navigation("EnterpriseAuth");

                    b.Navigation("IndustryType");

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

            modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
@@ -1989,33 +1905,6 @@
                    b.Navigation("UserInfo");
                });

            modelBuilder.Entity("FlexJobApi.Core.UserAuth", b =>
                {
                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "Avatar")
                        .WithMany()
                        .HasForeignKey("AvatarId");

                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "BankCardImg")
                        .WithMany()
                        .HasForeignKey("BankCardImgId");

                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "IdentityBackImg")
                        .WithMany()
                        .HasForeignKey("IdentityBackImgId");

                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "IdentityImg")
                        .WithMany()
                        .HasForeignKey("IdentityImgId");

                    b.Navigation("Avatar");

                    b.Navigation("BankCardImg");

                    b.Navigation("IdentityBackImg");

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

            modelBuilder.Entity("FlexJobApi.Core.UserInfo", b =>
                {
                    b.HasOne("FlexJobApi.Core.DictionaryData", "City")
@@ -2034,6 +1923,10 @@
                        .WithMany()
                        .HasForeignKey("PersonalIdentityId");

                    b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
                        .WithMany()
                        .HasForeignKey("ProvinceId");

                    b.HasOne("FlexJobApi.Core.UserAuth", "UserAuth")
                        .WithMany("UserInfos")
                        .HasForeignKey("UserAuthId")
@@ -2047,6 +1940,8 @@
                    b.Navigation("Enterprise");

                    b.Navigation("PersonalIdentity");

                    b.Navigation("Province");

                    b.Navigation("UserAuth");
                });
@@ -2064,16 +1959,6 @@

            modelBuilder.Entity("FlexJobApi.Core.UserInfoCredential", b =>
                {
                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "BackImg")
                        .WithMany()
                        .HasForeignKey("BackImgId");

                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "Img")
                        .WithMany()
                        .HasForeignKey("ImgId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("FlexJobApi.Core.DictionaryData", "Type")
                        .WithMany()
                        .HasForeignKey("TypeId");
@@ -2083,10 +1968,6 @@
                        .HasForeignKey("UserInfoId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("BackImg");

                    b.Navigation("Img");

                    b.Navigation("Type");

@@ -2133,19 +2014,11 @@

            modelBuilder.Entity("FlexJobApi.Core.UserInfoPhoto", b =>
                {
                    b.HasOne("FlexJobApi.Core.FileVirtualPath", "Img")
                        .WithMany()
                        .HasForeignKey("ImgId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo")
                        .WithMany()
                        .HasForeignKey("UserInfoId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("Img");

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