From c97916f276a328fa70696a8582dc0c23144424f9 Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期三, 06 八月 2025 16:59:32 +0800 Subject: [PATCH] feat:企业开发 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 474 +++++++++++++++++++++++----------------------------------- 1 files changed, 191 insertions(+), 283 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index e20265a..ec10f59 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -202,6 +202,10 @@ .HasColumnType("bit") .HasComment("鏄惁鍒犻櫎"); + b.Property<bool>("IsDisabled") + .HasColumnType("bit") + .HasComment("鏄惁绂佺敤"); + b.Property<Guid?>("ParentId") .HasColumnType("uniqueidentifier") .HasComment("涓婄骇Id"); @@ -243,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("娉曚汉鎴栫粡鍔炰汉閾惰鍗$収鐗嘔d"); + 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) @@ -269,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("缁熶竴绀句細淇$敤浠g爜"); + 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") @@ -358,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 => { @@ -370,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") @@ -455,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 => @@ -633,9 +566,20 @@ .HasColumnType("uniqueidentifier"); b.Property<string>("ActionName") - .IsRequired() .HasColumnType("nvarchar(max)") .HasComment("濮旀墭鍚嶇О"); + + b.Property<string>("ActionSummary") + .HasColumnType("nvarchar(max)") + .HasComment("濮旀墭鎽樿"); + + b.Property<bool>("AllowAnonymous") + .HasColumnType("bit") + .HasComment("蹇界暐鏉冮檺"); + + b.Property<string>("ApplicationName") + .HasColumnType("nvarchar(max)") + .HasComment("搴旂敤鍚嶇О"); b.Property<string>("Code") .IsRequired() @@ -646,12 +590,20 @@ .HasColumnType("int") .HasComment("鎺у埗鍣�"); + b.Property<string>("ControllerSummary") + .HasColumnType("nvarchar(max)") + .HasComment("鎺у埗鍣ㄦ憳瑕�"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") .HasColumnType("uniqueidentifier") .HasComment("鍒涘缓鎿嶄綔浜�"); + + b.Property<string>("DynamicAssemblyName") + .HasColumnType("nvarchar(max)") + .HasComment("鍔ㄦ�佺▼搴忛泦鍚嶇О"); b.Property<bool>("IsDeleted") .HasColumnType("bit") @@ -694,6 +646,18 @@ .IsRequired() .HasColumnType("nvarchar(max)") .HasComment("璺敱"); + + b.Property<string>("RouteArea") + .HasColumnType("nvarchar(max)") + .HasComment("璺敱鍖哄煙"); + + b.Property<int>("Service") + .HasColumnType("int") + .HasComment("鏈嶅姟"); + + b.Property<string>("ServiceName") + .HasColumnType("nvarchar(max)") + .HasComment("鏈嶅姟鍚嶇О"); b.Property<int>("Sort") .HasColumnType("int") @@ -1167,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("閾惰鍗$収鐗嘔d"); + b.Property<string>("BankCardImg") + .HasColumnType("nvarchar(max)") + .HasComment("閾惰鍗$収鐗�"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); @@ -1191,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") @@ -1253,14 +1213,6 @@ b.HasKey("Id"); - b.HasIndex("AvatarId"); - - b.HasIndex("BankCardImgId"); - - b.HasIndex("IdentityBackImgId"); - - b.HasIndex("IdentityImgId"); - b.ToTable("UserAuth", t => { t.HasComment("鐢ㄦ埛"); @@ -1286,6 +1238,9 @@ b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + + b.Property<string>("Avatar") + .HasColumnType("nvarchar(max)"); b.Property<Guid?>("CityId") .HasColumnType("uniqueidentifier") @@ -1329,6 +1284,9 @@ b.Property<Guid?>("PersonalIdentityId") .HasColumnType("uniqueidentifier") .HasComment("韬唤Id"); + + b.Property<Guid?>("ProvinceId") + .HasColumnType("uniqueidentifier"); b.Property<string>("Remark") .HasColumnType("nvarchar(max)") @@ -1387,6 +1345,8 @@ b.HasIndex("EnterpriseId"); b.HasIndex("PersonalIdentityId"); + + b.HasIndex("ProvinceId"); b.HasIndex("UserAuthId"); @@ -1479,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() @@ -1500,9 +1460,9 @@ .HasColumnType("datetime2") .HasComment("缁撴潫鏃ユ湡"); - b.Property<Guid>("ImgId") - .HasColumnType("uniqueidentifier") - .HasComment("璇佷功姝i潰鐓х墖Id"); + b.Property<string>("Img") + .HasColumnType("nvarchar(max)") + .HasComment("璇佷功姝i潰鐓х墖"); b.Property<bool>("IsDeleted") .HasColumnType("bit") @@ -1544,10 +1504,6 @@ .HasComment("鐢ㄦ埛淇℃伅Id"); b.HasKey("Id"); - - b.HasIndex("BackImgId"); - - b.HasIndex("ImgId"); b.HasIndex("TypeId"); @@ -1676,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") @@ -1704,8 +1660,6 @@ .HasComment("鐢ㄦ埛淇℃伅Id"); b.HasKey("Id"); - - b.HasIndex("ImgId"); b.HasIndex("UserInfoId"); @@ -1803,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 => @@ -1954,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") @@ -1999,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") @@ -2012,6 +1940,8 @@ b.Navigation("Enterprise"); b.Navigation("PersonalIdentity"); + + b.Navigation("Province"); b.Navigation("UserAuth"); }); @@ -2029,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"); @@ -2048,10 +1968,6 @@ .HasForeignKey("UserInfoId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - - b.Navigation("BackImg"); - - b.Navigation("Img"); b.Navigation("Type"); @@ -2098,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"); }); -- Gitblit v1.9.1