From 313c5cbe5c63fa07f78fa24d8cc33b75435a266f Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期四, 07 八月 2025 17:00:40 +0800 Subject: [PATCH] feat:字典优化 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 1518 +++++++++++++++++++++++---------------------------------- 1 files changed, 623 insertions(+), 895 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index 91283db..a69c87f 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -32,51 +32,41 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("EnterpriseId") - .HasColumnType("uniqueidentifier") - .HasComment("浼佷笟Id"); + .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<bool>("IsDisabled") - .HasColumnType("bit") - .HasComment("鏄惁绂佺敤"); + .HasColumnType("bit"); b.Property<string>("Name") .IsRequired() - .HasColumnType("nvarchar(max)") - .HasComment("鍚嶇О"); + .HasColumnType("nvarchar(max)"); b.Property<Guid?>("ParentId") - .HasColumnType("uniqueidentifier") - .HasComment("涓婄骇Id"); + .HasColumnType("uniqueidentifier"); b.Property<string>("Path") .HasColumnType("nvarchar(max)"); b.Property<string>("Remark") - .HasColumnType("nvarchar(max)") - .HasComment("澶囨敞"); + .HasColumnType("nvarchar(max)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -84,10 +74,7 @@ b.HasIndex("ParentId"); - b.ToTable("Department", t => - { - t.HasComment("閮ㄩ棬"); - }); + b.ToTable("Department"); }); modelBuilder.Entity("FlexJobApi.Core.DictionaryCategory", b => @@ -99,51 +86,43 @@ b.Property<string>("Code") .IsRequired() .HasMaxLength(128) - .HasColumnType("nvarchar(128)") - .HasComment("缂栧彿"); + .HasColumnType("nvarchar(128)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<string>("FieldNames") - .HasColumnType("nvarchar(max)") - .HasComment("瀛楁鍚嶏紙閫楀彿闅斿紑锛�"); + .HasColumnType("nvarchar(max)"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<string>("Name") .IsRequired() .HasMaxLength(128) - .HasColumnType("nvarchar(128)") - .HasComment("鍚嶇О"); + .HasColumnType("nvarchar(128)"); + + b.Property<string>("Remark") + .HasColumnType("nvarchar(max)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.ToTable("DictionaryCategory", t => - { - t.HasComment("瀛楀吀绫诲埆"); - }); + b.ToTable("DictionaryCategory"); }); modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b => @@ -153,82 +132,75 @@ .HasColumnType("uniqueidentifier"); b.Property<Guid>("CategoryId") - .HasColumnType("uniqueidentifier") - .HasComment("绫诲埆Id"); + .HasColumnType("uniqueidentifier"); b.Property<string>("Code") + .IsRequired() .HasMaxLength(128) - .HasColumnType("nvarchar(128)") - .HasComment("缂栧彿"); + .HasColumnType("nvarchar(128)"); b.Property<string>("Content") .IsRequired() - .HasColumnType("nvarchar(max)") - .HasComment("鏄剧ず鍐呭"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); + + b.Property<int>("Deep") + .HasColumnType("int"); b.Property<string>("Field1") - .HasColumnType("nvarchar(max)") - .HasComment("瀛楁1"); + .HasColumnType("nvarchar(max)"); b.Property<string>("Field2") - .HasColumnType("nvarchar(max)") - .HasComment("瀛楁2"); + .HasColumnType("nvarchar(max)"); b.Property<string>("Field3") - .HasColumnType("nvarchar(max)") - .HasComment("瀛楁3"); + .HasColumnType("nvarchar(max)"); b.Property<string>("Field4") - .HasColumnType("nvarchar(max)") - .HasComment("瀛楁4"); + .HasColumnType("nvarchar(max)"); b.Property<string>("Field5") - .HasColumnType("nvarchar(max)") - .HasComment("瀛楁5"); + .HasColumnType("nvarchar(max)"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); + + b.Property<bool>("IsDisabled") + .HasColumnType("bit"); b.Property<Guid?>("ParentId") - .HasColumnType("uniqueidentifier") - .HasComment("涓婄骇Id"); + .HasColumnType("uniqueidentifier"); b.Property<string>("Path") .HasColumnType("nvarchar(max)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); b.HasIndex("CategoryId"); + b.HasIndex("Code") + .IsUnique(); + b.HasIndex("ParentId"); - b.ToTable("DictionaryData", t => - { - t.HasComment("瀛楀吀鏁版嵁"); - }); + b.ToTable("DictionaryData"); }); modelBuilder.Entity("FlexJobApi.Core.Enterprise", b => @@ -237,268 +209,191 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<string>("BankBranchName") + .HasColumnType("nvarchar(max)"); + b.Property<string>("BankCard") .HasMaxLength(32) - .HasColumnType("nvarchar(32)") - .HasComment("娉曚汉鎴栫粡鍔炰汉閾惰鍗″彿"); + .HasColumnType("nvarchar(32)"); - b.Property<Guid?>("BankCardImgId") - .HasColumnType("uniqueidentifier") - .HasComment("娉曚汉鎴栫粡鍔炰汉閾惰鍗$収鐗嘔d"); + b.Property<string>("BankName") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("CityCode") + .HasColumnType("nvarchar(128)"); + + b.Property<string>("ContactEmail") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ContactPhoneNumber") + .HasMaxLength(11) + .HasColumnType("nvarchar(11)"); + + b.Property<string>("Contacts") + .HasMaxLength(32) + .HasColumnType("nvarchar(32)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); + + b.Property<Guid>("EnterpriseAuthId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("IndustryTypeCode") + .HasColumnType("nvarchar(128)"); + + b.Property<bool>("IsCheckedBankCard") + .HasColumnType("bit"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<string>("MainBusiness") + .HasColumnType("nvarchar(max)"); + + b.Property<decimal?>("MergeSignCost") + .HasColumnType("decimal(18,2)"); + + b.Property<int?>("PayAccess") + .HasColumnType("int"); + + b.Property<string>("ProvinceCode") + .HasColumnType("nvarchar(128)"); + + b.Property<int?>("RealAccess") + .HasColumnType("int"); + + 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"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserInfoId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.HasIndex("CityCode"); + + b.HasIndex("EnterpriseAuthId"); + + b.HasIndex("IndustryTypeCode"); + + b.HasIndex("ProvinceCode"); + + b.ToTable("Enterprise"); + }); + + modelBuilder.Entity("FlexJobApi.Core.EnterpriseAuth", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<string>("BankCard") + .HasMaxLength(32) + .HasColumnType("nvarchar(32)"); + + b.Property<string>("BankCardImg") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserInfoId") + .HasColumnType("uniqueidentifier"); b.Property<string>("EnterpriseName") .IsRequired() .HasMaxLength(128) - .HasColumnType("nvarchar(128)") - .HasComment("浼佷笟鍏ㄧО"); + .HasColumnType("nvarchar(128)"); b.Property<int?>("EnterpriseRealMethod") - .HasColumnType("int") - .HasComment("浼佷笟璁よ瘉鏂瑰紡"); + .HasColumnType("int"); b.Property<string>("Identity") .HasMaxLength(18) - .HasColumnType("nvarchar(18)") - .HasComment("娉曚汉鎴栫粡鍔炰汉韬唤璇佸彿"); + .HasColumnType("nvarchar(18)"); - b.Property<Guid?>("IdentityBackImgId") - .HasColumnType("uniqueidentifier") - .HasComment("娉曚汉鎴栫粡鍔炰汉韬唤璇佸浗寰介潰Id"); + b.Property<string>("IdentityBackImg") + .HasColumnType("nvarchar(max)"); - b.Property<Guid?>("IdentityImgId") - .HasColumnType("uniqueidentifier") - .HasComment("娉曚汉鎴栫粡鍔炰汉韬唤璇佷汉鍍忛潰Id"); + b.Property<string>("IdentityImg") + .HasColumnType("nvarchar(max)"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<bool>("IsReal") - .HasColumnType("bit") - .HasComment("鏄惁瀹炲悕"); + .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<Guid?>("LicenseImageId") - .HasColumnType("uniqueidentifier") - .HasComment("钀ヤ笟鎵х収鐓х墖Id"); + b.Property<string>("LicenseImage") + .HasColumnType("nvarchar(max)"); b.Property<string>("Name") .HasMaxLength(32) - .HasColumnType("nvarchar(32)") - .HasComment("娉曚汉鎴栫粡鍔炰汉濮撳悕"); + .HasColumnType("nvarchar(32)"); b.Property<int?>("PersonalRealMethod") - .HasColumnType("int") - .HasComment("娉曚汉鎴栫粡鍔炰汉瀹炲悕鏂瑰紡"); + .HasColumnType("int"); b.Property<string>("PhoneNumber") .HasMaxLength(11) - .HasColumnType("nvarchar(11)") - .HasComment("娉曚汉鎴栫粡鍔炰汉鎵嬫満鍙�"); + .HasColumnType("nvarchar(11)"); b.Property<bool?>("Proxy") - .HasColumnType("bit") - .HasComment("鏄惁濮旀墭缁忓姙浜�"); + .HasColumnType("bit"); b.Property<string>("ProxyPowerAttorneyUrl") - .HasColumnType("nvarchar(max)") - .HasComment("浼佷笟鎺堟潈涔�"); - - b.Property<int?>("RealAccess") - .HasColumnType("int") - .HasComment("瀹炲悕閫氶亾"); + .HasColumnType("nvarchar(max)"); b.Property<string>("SocietyCreditCode") .IsRequired() .HasMaxLength(18) - .HasColumnType("nvarchar(18)") - .HasComment("缁熶竴绀句細淇$敤浠g爜"); + .HasColumnType("nvarchar(18)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); - - b.HasKey("Id"); - - b.HasIndex("IdentityBackImgId"); - - b.HasIndex("IdentityImgId"); - - b.HasIndex("LicenseImageId"); - - b.ToTable("Enterprise", t => - { - t.HasComment("浼佷笟"); - }); - }); - - modelBuilder.Entity("FlexJobApi.Core.FileStore", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); - b.Property<string>("AbsolutePath") - .IsRequired() - .HasColumnType("nvarchar(max)") - .HasComment("缁濆璺緞"); - - b.Property<int>("Access") - .HasColumnType("int") - .HasComment("閫氶亾"); - - b.Property<string>("ContentType") - .IsRequired() - .HasMaxLength(128) - .HasColumnType("nvarchar(128)") - .HasComment("鍐呭绫诲瀷"); - - b.Property<DateTimeOffset>("CreatedTime") - .HasColumnType("datetimeoffset"); - - b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); - - b.Property<string>("Extension") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("nvarchar(32)") - .HasComment("鎵╁睍鍚�"); - - 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>("Name") - .IsRequired() - .HasColumnType("nvarchar(max)") - .HasComment("鍚嶇О"); - - b.Property<string>("RelativePath") - .HasColumnType("nvarchar(max)") - .HasComment("鐩稿璺緞"); - - b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); - - b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); - - b.Property<DateTimeOffset?>("UpdatedTime") - .HasColumnType("datetimeoffset"); - - b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); - 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 => @@ -507,85 +402,74 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<int>("ClientType") + .HasColumnType("int"); + b.Property<string>("Code") .IsRequired() - .HasColumnType("nvarchar(max)") - .HasComment("缂栧彿"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<string>("Group") - .HasColumnType("nvarchar(max)") - .HasComment("鍒嗙粍鍚嶇О锛堢敤浜庢寜閽�/瀛楁锛�"); + .HasColumnType("nvarchar(max)"); b.Property<string>("Icon") - .HasColumnType("nvarchar(max)") - .HasComment("鍥炬爣"); + .HasColumnType("nvarchar(max)"); b.Property<bool>("IsCache") - .HasColumnType("bit") - .HasComment("鏄惁缂撳瓨"); + .HasColumnType("bit"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<bool>("IsDisabled") - .HasColumnType("bit") - .HasComment("鏄惁绂佺敤"); + .HasColumnType("bit"); - b.Property<bool>("IsHidden") - .HasColumnType("bit") - .HasComment("鏄惁闅愯棌"); + b.Property<string>("Location") + .HasColumnType("nvarchar(max)"); b.Property<string>("Name") .IsRequired() .HasMaxLength(128) - .HasColumnType("nvarchar(128)") - .HasComment("鍚嶇О"); + .HasColumnType("nvarchar(128)"); b.Property<Guid?>("ParentId") - .HasColumnType("uniqueidentifier") - .HasComment("涓婄骇Id"); + .HasColumnType("uniqueidentifier"); b.Property<string>("Path") .HasColumnType("nvarchar(max)"); b.Property<string>("Remark") - .HasColumnType("nvarchar(max)") - .HasComment("澶囨敞"); + .HasColumnType("nvarchar(max)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<int>("Type") - .HasColumnType("int") - .HasComment("绫诲瀷"); + .HasColumnType("int"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<string>("Url") - .HasColumnType("nvarchar(max)") - .HasComment("閾炬帴鍦板潃"); + .HasColumnType("nvarchar(max)"); + + b.Property<int>("UserType") + .HasColumnType("int"); b.Property<int>("VisitLevel") - .HasColumnType("int") - .HasComment("璁块棶绾у埆"); + .HasColumnType("int"); b.Property<string>("Width") .HasColumnType("nvarchar(max)"); @@ -594,10 +478,103 @@ b.HasIndex("ParentId"); - b.ToTable("Menu", t => - { - t.HasComment("鑿滃崟"); - }); + b.ToTable("Menu"); + }); + + modelBuilder.Entity("FlexJobApi.Core.Resource", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<string>("ActionName") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ActionSummary") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("AllowAnonymous") + .HasColumnType("bit"); + + b.Property<string>("ApplicationName") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("Code") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<int>("Controller") + .HasColumnType("int"); + + b.Property<string>("ControllerSummary") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserInfoId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("DynamicAssemblyName") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<bool>("IsExpired") + .HasColumnType("bit"); + + b.Property<int>("Method") + .HasColumnType("int"); + + b.Property<string>("Name") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<string>("RequestTypeFullName") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<string>("RequestTypeName") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ResponseTypeFullName") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ResponseTypeName") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<string>("Route") + .IsRequired() + .HasColumnType("nvarchar(max)"); + + b.Property<string>("RouteArea") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("Service") + .HasColumnType("int"); + + b.Property<string>("ServiceName") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserInfoId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.ToTable("Resource"); }); modelBuilder.Entity("FlexJobApi.Core.Role", b => @@ -607,55 +584,52 @@ .HasColumnType("uniqueidentifier"); b.Property<int>("ClientType") - .HasColumnType("int") - .HasComment("瀹㈡埛绔被鍨�"); + .HasColumnType("int"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); + + b.Property<int>("DataPower") + .HasColumnType("int"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); + + b.Property<bool>("IsDisabled") + .HasColumnType("bit"); b.Property<int>("MinLevel") - .HasColumnType("int") - .HasComment("鏈�浣庣骇鍒�"); + .HasColumnType("int"); b.Property<string>("Name") .IsRequired() .HasMaxLength(128) - .HasColumnType("nvarchar(128)") - .HasComment("鍚嶇О"); + .HasColumnType("nvarchar(128)"); + + b.Property<string>("Remark") + .HasColumnType("nvarchar(max)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<int>("UserType") - .HasColumnType("int") - .HasComment("鐢ㄦ埛绫诲瀷"); + .HasColumnType("int"); b.HasKey("Id"); - b.ToTable("Role", t => - { - t.HasComment("瑙掕壊"); - }); + b.ToTable("Role"); }); modelBuilder.Entity("FlexJobApi.Core.RoleMenu", b => @@ -668,35 +642,28 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<Guid>("MenuId") - .HasColumnType("uniqueidentifier") - .HasComment("鑿滃崟Id"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("RoleId") - .HasColumnType("uniqueidentifier") - .HasComment("瑙掕壊Id"); + .HasColumnType("uniqueidentifier"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -704,13 +671,10 @@ b.HasIndex("RoleId"); - b.ToTable("RoleMenu", t => - { - t.HasComment("瑙掕壊鑿滃崟"); - }); + b.ToTable("RoleMenu"); }); - modelBuilder.Entity("FlexJobApi.Core.RoleWebApi", b => + modelBuilder.Entity("FlexJobApi.Core.RoleResource", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() @@ -720,50 +684,39 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); - b.Property<int?>("DataPower") - .HasColumnType("int") - .HasComment("鏁版嵁鏉冮檺"); + b.Property<int>("DataPower") + .HasColumnType("int"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); - b.Property<Guid>("MenuId") - .HasColumnType("uniqueidentifier") - .HasComment("鑿滃崟Id"); + b.Property<Guid>("ResourceId") + .HasColumnType("uniqueidentifier"); b.Property<Guid>("RoleId") - .HasColumnType("uniqueidentifier") - .HasComment("瑙掕壊Id"); + .HasColumnType("uniqueidentifier"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.HasIndex("MenuId"); + b.HasIndex("ResourceId"); b.HasIndex("RoleId"); - b.ToTable("RoleWebApi", t => - { - t.HasComment("瑙掕壊鎺ュ彛"); - }); + b.ToTable("RoleResource"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b => @@ -773,90 +726,84 @@ .HasColumnType("uniqueidentifier"); b.Property<string>("Address") - .HasColumnType("nvarchar(max)") - .HasComment("浠诲姟鍦扮偣璇︾粏鍦板潃"); + .HasColumnType("nvarchar(max)"); b.Property<int>("AgeMaxLimit") - .HasColumnType("int") - .HasComment("骞撮緞鑼冨洿澶�"); + .HasColumnType("int"); b.Property<int>("AgeMinLimit") - .HasColumnType("int") - .HasComment("骞撮緞鑼冨洿鏈�灏�"); + .HasColumnType("int"); b.Property<DateTime>("BeginTime") - .HasColumnType("datetime2") - .HasComment("浠诲姟寮�濮嬫椂闂�"); + .HasColumnType("datetime2"); b.Property<int>("BillingMethod") - .HasColumnType("int") - .HasComment("璁¤垂鏂瑰紡"); + .HasColumnType("int"); - b.Property<Guid>("CityId") - .HasColumnType("uniqueidentifier") - .HasComment("浠诲姟鍦扮偣鎵�灞炲尯鍩烮d"); + b.Property<string>("CityCode") + .HasColumnType("nvarchar(128)"); + + b.Property<string>("Code") + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<DateTime>("EndTime") - .HasColumnType("datetime2") - .HasComment("浠诲姟缁撴潫鏃堕棿"); + .HasColumnType("datetime2"); b.Property<Guid>("EnterpriseId") - .HasColumnType("uniqueidentifier") - .HasComment("浼佷笟Id"); + .HasColumnType("uniqueidentifier"); b.Property<int>("GenderLimit") - .HasColumnType("int") - .HasComment("鎬у埆瑕佹眰"); + .HasColumnType("int"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<string>("Name") .IsRequired() - .HasColumnType("nvarchar(max)") - .HasComment("浠诲姟鍚嶇О"); + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ProvinceCode") + .HasColumnType("nvarchar(128)"); + + b.Property<int>("ReleaseStatus") + .HasColumnType("int"); b.Property<decimal>("ServiceFee") - .HasColumnType("decimal(18,2)") - .HasComment("鏈嶅姟璐�"); + .HasColumnType("decimal(18,2)"); b.Property<int>("SettlementCycle") - .HasColumnType("int") - .HasComment("缁撶畻鏂瑰紡"); + .HasColumnType("int"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); + + b.Property<int>("Status") + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.HasIndex("CityId"); + b.HasIndex("CityCode"); b.HasIndex("EnterpriseId"); - b.ToTable("TaskInfo", t => - { - t.HasComment("浠诲姟淇℃伅"); - }); + b.HasIndex("ProvinceCode"); + + b.ToTable("TaskInfo"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoBenefit", b => @@ -865,53 +812,41 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); - b.Property<Guid>("BenefitId") - .HasColumnType("uniqueidentifier") - .HasComment("绂忓埄Id"); - - b.Property<Guid>("BenefitId1") - .HasColumnType("uniqueidentifier"); + b.Property<string>("BenefitCode") + .IsRequired() + .HasColumnType("nvarchar(128)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<Guid>("TaskInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("浠诲姟Id"); + .HasColumnType("uniqueidentifier"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.HasIndex("BenefitId"); + b.HasIndex("BenefitCode"); - b.HasIndex("BenefitId1"); + b.HasIndex("TaskInfoId"); - b.ToTable("TaskInfoBenefit", t => - { - t.HasComment("浠诲姟绂忓埄"); - }); + b.ToTable("TaskInfoBenefit"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoCredentialLimit", b => @@ -924,41 +859,35 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<Guid>("TaskInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("浠诲姟Id"); + .HasColumnType("uniqueidentifier"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); - b.Property<Guid?>("TypeId") - .HasColumnType("uniqueidentifier") - .HasComment("璇佷功绫诲瀷Id"); + b.Property<string>("TypeCode") + .IsRequired() + .HasColumnType("nvarchar(128)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); b.HasIndex("TaskInfoId"); - b.HasIndex("TypeId"); + b.HasIndex("TypeCode"); b.ToTable("TaskInfoCredentialLimit"); }); @@ -973,51 +902,40 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<int>("HireStatus") - .HasColumnType("int") - .HasComment("褰曠敤鐘舵��"); + .HasColumnType("int"); b.Property<DateTime?>("HireTime") - .HasColumnType("datetime2") - .HasComment("褰曠敤鏃堕棿"); + .HasColumnType("datetime2"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<int?>("SignContractStatus") - .HasColumnType("int") - .HasComment("绛剧害鐘舵��"); + .HasColumnType("int"); b.Property<DateTime?>("SignContractTime") - .HasColumnType("datetime2") - .HasComment("绛剧害鏃堕棿"); + .HasColumnType("datetime2"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<Guid>("TaskInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("浠诲姟Id"); + .HasColumnType("uniqueidentifier"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("UserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鐢ㄦ埛淇℃伅Id"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -1025,10 +943,7 @@ b.HasIndex("UserInfoId"); - b.ToTable("TaskInfoUser", t => - { - t.HasComment("浠诲姟鐢ㄦ埛淇℃伅"); - }); + b.ToTable("TaskInfoUser"); }); modelBuilder.Entity("FlexJobApi.Core.UserAuth", b => @@ -1037,104 +952,72 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); - b.Property<Guid?>("AvatarId") - .HasColumnType("uniqueidentifier") - .HasComment("澶村儚Id"); - b.Property<string>("BankCard") .HasMaxLength(32) - .HasColumnType("nvarchar(32)") - .HasComment("閾惰鍗″彿"); + .HasColumnType("nvarchar(32)"); - b.Property<Guid?>("BankCardImgId") - .HasColumnType("uniqueidentifier") - .HasComment("閾惰鍗$収鐗嘔d"); + b.Property<string>("BankCardImg") + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<string>("Identity") - .HasColumnType("nvarchar(max)") - .HasComment("韬唤璇佸彿"); + .HasColumnType("nvarchar(max)"); - b.Property<Guid?>("IdentityBackImgId") - .HasColumnType("uniqueidentifier") - .HasComment("韬唤璇佸浗寰介潰Id"); + b.Property<string>("IdentityBackImg") + .HasColumnType("nvarchar(max)"); - b.Property<Guid?>("IdentityImgId") - .HasColumnType("uniqueidentifier") - .HasComment("韬唤璇佷汉鍍忛潰Id"); + b.Property<string>("IdentityImg") + .HasColumnType("nvarchar(max)"); b.Property<bool>("IsCheckPhoneNumber") - .HasColumnType("bit") - .HasComment("鏄惁宸叉牎楠屾墜鏈哄彿"); + .HasColumnType("bit"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<bool>("IsReal") - .HasColumnType("bit") - .HasComment("鏄惁瀹炲悕"); + .HasColumnType("bit"); b.Property<string>("Name") .IsRequired() .HasMaxLength(32) - .HasColumnType("nvarchar(32)") - .HasComment("濮撳悕"); + .HasColumnType("nvarchar(32)"); b.Property<string>("Password") - .HasColumnType("nvarchar(max)") - .HasComment("瀵嗙爜"); + .HasColumnType("nvarchar(max)"); b.Property<string>("PhoneNumber") .HasMaxLength(11) - .HasColumnType("nvarchar(11)") - .HasComment("鎵嬫満鍙�"); + .HasColumnType("nvarchar(11)"); b.Property<int?>("RealAccess") - .HasColumnType("int") - .HasComment("瀹炲悕閫氶亾"); + .HasColumnType("int"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<string>("UserName") .IsRequired() .HasMaxLength(32) - .HasColumnType("nvarchar(32)") - .HasComment("鐢ㄦ埛鍚�"); + .HasColumnType("nvarchar(32)"); b.HasKey("Id"); - b.HasIndex("AvatarId"); - - b.HasIndex("BankCardImgId"); - - b.HasIndex("IdentityBackImgId"); - - b.HasIndex("IdentityImgId"); - - b.ToTable("UserAuth", t => - { - t.HasComment("鐢ㄦ埛"); - }); + b.ToTable("UserAuth"); b.HasData( new @@ -1145,8 +1028,9 @@ IsDeleted = false, IsReal = false, Name = "绠$悊鍛�", + Password = "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=", Sort = 0, - UserName = "admin" + UserName = "system" }); }); @@ -1156,105 +1040,97 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); - b.Property<Guid?>("CityId") - .HasColumnType("uniqueidentifier") - .HasComment("甯搁┗鍩庡競Id"); + b.Property<string>("Avatar") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("CityCode") + .HasColumnType("nvarchar(128)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); - b.Property<Guid?>("EducationalBackgroundId") - .HasColumnType("uniqueidentifier") - .HasComment("瀛﹀巻Id"); + b.Property<string>("EducationalBackgroundCode") + .HasColumnType("nvarchar(128)"); b.Property<Guid?>("EnterpriseId") - .HasColumnType("uniqueidentifier") - .HasComment("浼佷笟Id"); + .HasColumnType("uniqueidentifier"); b.Property<int?>("FreeTime") - .HasColumnType("int") - .HasComment("绌洪棽鏃堕棿"); + .HasColumnType("int"); b.Property<int?>("Height") - .HasColumnType("int") - .HasComment("韬珮"); + .HasColumnType("int"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<int?>("JobSeekingStatus") - .HasColumnType("int") - .HasComment("姹傝亴鐘舵��"); + .HasColumnType("int"); b.Property<int>("Level") - .HasColumnType("int") - .HasComment("绾у埆"); + .HasColumnType("int"); - b.Property<Guid?>("PersonalIdentityId") - .HasColumnType("uniqueidentifier") - .HasComment("韬唤Id"); + b.Property<string>("PersonalIdentityCode") + .HasColumnType("nvarchar(128)"); + + b.Property<string>("ProvinceCode") + .HasColumnType("nvarchar(128)"); + + b.Property<string>("Remark") + .HasColumnType("nvarchar(max)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); + + b.Property<int>("Status") + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<int>("Type") - .HasColumnType("int") - .HasComment("鐢ㄦ埛绫诲瀷"); + .HasColumnType("int"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("UserAuthId") - .HasColumnType("uniqueidentifier") - .HasComment("鐢ㄦ埛Id"); + .HasColumnType("uniqueidentifier"); b.Property<int?>("Weight") - .HasColumnType("int") - .HasComment("浣撻噸"); + .HasColumnType("int"); b.Property<string>("WorkExperience") - .HasColumnType("nvarchar(max)") - .HasComment("宸ヤ綔缁忛獙"); + .HasColumnType("nvarchar(max)"); b.Property<string>("WorkSeniority") - .HasColumnType("nvarchar(max)") - .HasComment("宸ヤ綔璧勫巻"); + .HasColumnType("nvarchar(max)"); b.Property<string>("WxmpOpenId") .HasMaxLength(32) - .HasColumnType("nvarchar(32)") - .HasComment("寰俊寮�鏀綢d"); + .HasColumnType("nvarchar(32)"); 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("ProvinceCode"); b.HasIndex("UserAuthId"); - b.ToTable("UserInfo", t => - { - t.HasComment("鐢ㄦ埛淇℃伅"); - }); + b.ToTable("UserInfo"); b.HasData( new @@ -1264,6 +1140,7 @@ IsDeleted = false, Level = 999, Sort = 0, + Status = 0, Type = 100, UserAuthId = new Guid("11111111-1111-1111-1111-111111111111") }); @@ -1278,59 +1155,47 @@ b.Property<string>("Bank") .IsRequired() .HasMaxLength(128) - .HasColumnType("nvarchar(128)") - .HasComment("寮�鎴疯"); + .HasColumnType("nvarchar(128)"); b.Property<string>("Code") .IsRequired() .HasMaxLength(32) - .HasColumnType("nvarchar(32)") - .HasComment("閾惰鍗″彿"); + .HasColumnType("nvarchar(32)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<string>("PhoneNumber") .IsRequired() .HasMaxLength(11) - .HasColumnType("nvarchar(11)") - .HasComment("閾惰棰勭暀鎵嬫満鍙�"); + .HasColumnType("nvarchar(11)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("UserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鐢ㄦ埛淇℃伅Id"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); b.HasIndex("UserInfoId"); - b.ToTable("UserInfoBankCard", t => - { - t.HasComment("鐢ㄦ埛閾惰鍗′俊鎭�"); - }); + b.ToTable("UserInfoBankCard"); }); modelBuilder.Entity("FlexJobApi.Core.UserInfoCredential", b => @@ -1339,84 +1204,64 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); - b.Property<Guid?>("BackImgId") - .HasColumnType("uniqueidentifier") - .HasComment("璇佷功鍙嶉潰鐓х墖Id"); + b.Property<string>("BackImg") + .HasColumnType("nvarchar(max)"); b.Property<string>("Code") .IsRequired() .HasMaxLength(128) - .HasColumnType("nvarchar(128)") - .HasComment("璇佷功缂栧彿"); + .HasColumnType("nvarchar(128)"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<DateTime>("EndDate") - .HasColumnType("datetime2") - .HasComment("缁撴潫鏃ユ湡"); + .HasColumnType("datetime2"); - b.Property<Guid>("ImgId") - .HasColumnType("uniqueidentifier") - .HasComment("璇佷功姝i潰鐓х墖Id"); + b.Property<string>("Img") + .HasColumnType("nvarchar(max)"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<bool>("IsForever") - .HasColumnType("bit") - .HasComment("姘镐箙璇佷功"); + .HasColumnType("bit"); b.Property<string>("IssueUnit") - .HasColumnType("nvarchar(max)") - .HasComment("鍙戣瘉鍗曚綅"); + .HasColumnType("nvarchar(max)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<DateTime>("StartDate") - .HasColumnType("datetime2") - .HasComment("寮�濮嬫棩鏈�"); + .HasColumnType("datetime2"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); - b.Property<Guid?>("TypeId") - .HasColumnType("uniqueidentifier") - .HasComment("璇佷功绫诲瀷Id"); + b.Property<string>("TypeCode") + .IsRequired() + .HasColumnType("nvarchar(128)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("UserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鐢ㄦ埛淇℃伅Id"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.HasIndex("BackImgId"); - - b.HasIndex("ImgId"); - - b.HasIndex("TypeId"); + b.HasIndex("TypeCode"); b.HasIndex("UserInfoId"); - b.ToTable("UserInfoCredential", t => - { - t.HasComment("鐢ㄦ埛淇℃伅璧勬牸璇佷功"); - }); + b.ToTable("UserInfoCredential"); }); modelBuilder.Entity("FlexJobApi.Core.UserInfoDepartment", b => @@ -1429,35 +1274,28 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("DepartmentId") - .HasColumnType("uniqueidentifier") - .HasComment("閮ㄩ棬Id"); + .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("UserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鐢ㄦ埛淇℃伅Id"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -1465,10 +1303,7 @@ b.HasIndex("UserInfoId"); - b.ToTable("UserInfoDepartment", t => - { - t.HasComment("鐢ㄦ埛淇℃伅閮ㄩ棬"); - }); + b.ToTable("UserInfoDepartment"); }); modelBuilder.Entity("FlexJobApi.Core.UserInfoExpectJob", b => @@ -1481,46 +1316,37 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); - b.Property<Guid>("PersonalIdentityId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈熸湜宀椾綅Id"); + b.Property<string>("PersonalIdentityCode") + .IsRequired() + .HasColumnType("nvarchar(128)"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("UserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鐢ㄦ埛淇℃伅Id"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.HasIndex("PersonalIdentityId"); + b.HasIndex("PersonalIdentityCode"); b.HasIndex("UserInfoId"); - b.ToTable("UserInfoExpectJob", t => - { - t.HasComment("鐢ㄦ埛淇℃伅鏈熸湜宀椾綅"); - }); + b.ToTable("UserInfoExpectJob"); }); modelBuilder.Entity("FlexJobApi.Core.UserInfoPhoto", b => @@ -1533,46 +1359,34 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); - b.Property<Guid>("ImgId") - .HasColumnType("uniqueidentifier") - .HasComment("鐓х墖Id"); + b.Property<string>("Img") + .HasColumnType("nvarchar(max)"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("UserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鐢ㄦ埛淇℃伅Id"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.HasIndex("ImgId"); - b.HasIndex("UserInfoId"); - b.ToTable("UserInfoPhoto", t => - { - t.HasComment("鐢ㄦ埛淇℃伅鐢熸椿鐓�"); - }); + b.ToTable("UserInfoPhoto"); }); modelBuilder.Entity("FlexJobApi.Core.UserInfoRole", b => @@ -1585,35 +1399,28 @@ .HasColumnType("datetimeoffset"); b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); + .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); + .HasColumnType("bit"); b.Property<Guid>("RoleId") - .HasColumnType("uniqueidentifier") - .HasComment("瑙掕壊Id"); + .HasColumnType("uniqueidentifier"); b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); + .HasColumnType("int"); b.Property<string>("TraceId") - .HasColumnType("nvarchar(max)") - .HasComment("璺熻釜Id"); + .HasColumnType("nvarchar(max)"); b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); b.Property<Guid?>("UpdatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); + .HasColumnType("uniqueidentifier"); b.Property<Guid>("UserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鐢ㄦ埛淇℃伅Id"); + .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -1621,72 +1428,7 @@ b.HasIndex("UserInfoId"); - b.ToTable("UserInfoRole", t => - { - t.HasComment("鐢ㄦ埛淇℃伅瑙掕壊"); - }); - }); - - modelBuilder.Entity("FlexJobApi.Core.WebApi", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uniqueidentifier"); - - b.Property<string>("Code") - .IsRequired() - .HasColumnType("nvarchar(max)") - .HasComment("缂栧彿"); - - b.Property<DateTimeOffset>("CreatedTime") - .HasColumnType("datetimeoffset"); - - b.Property<Guid?>("CreatedUserInfoId") - .HasColumnType("uniqueidentifier") - .HasComment("鍒涘缓鎿嶄綔浜�"); - - b.Property<bool>("IsDeleted") - .HasColumnType("bit") - .HasComment("鏄惁鍒犻櫎"); - - b.Property<bool>("IsDisabled") - .HasColumnType("bit") - .HasComment("鏄惁绂佺敤"); - - b.Property<int>("Method") - .HasColumnType("int") - .HasComment("璇锋眰鏂瑰紡"); - - b.Property<string>("Name") - .IsRequired() - .HasColumnType("nvarchar(max)") - .HasComment("鍚嶇О"); - - b.Property<int>("Sort") - .HasColumnType("int") - .HasComment("鎺掑簭"); - - 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>("Url") - .HasColumnType("nvarchar(max)") - .HasComment("璺敱鍦板潃"); - - b.HasKey("Id"); - - b.ToTable("WebApi", t => - { - t.HasComment("鎺ュ彛"); - }); + b.ToTable("UserInfoRole"); }); modelBuilder.Entity("FlexJobApi.Core.Department", b => @@ -1698,7 +1440,7 @@ .IsRequired(); b.HasOne("FlexJobApi.Core.Department", "Parent") - .WithMany("Childrens") + .WithMany("Children") .HasForeignKey("ParentId"); b.Navigation("Enterprise"); @@ -1715,7 +1457,7 @@ .IsRequired(); b.HasOne("FlexJobApi.Core.DictionaryData", "Parent") - .WithMany("Childrens") + .WithMany("Children") .HasForeignKey("ParentId"); b.Navigation("Category"); @@ -1725,40 +1467,43 @@ modelBuilder.Entity("FlexJobApi.Core.Enterprise", b => { - b.HasOne("FlexJobApi.Core.FileVirtualPath", "IdentityBackImg") + b.HasOne("FlexJobApi.Core.DictionaryData", "City") .WithMany() - .HasForeignKey("IdentityBackImgId"); + .HasForeignKey("CityCode") + .HasPrincipalKey("Code") + .OnDelete(DeleteBehavior.Restrict); - 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("IndustryTypeCode") + .HasPrincipalKey("Code") + .OnDelete(DeleteBehavior.Restrict); + + b.HasOne("FlexJobApi.Core.DictionaryData", "Province") + .WithMany() + .HasForeignKey("ProvinceCode") + .HasPrincipalKey("Code") + .OnDelete(DeleteBehavior.Restrict); + + b.Navigation("City"); + + b.Navigation("EnterpriseAuth"); + + b.Navigation("IndustryType"); + + b.Navigation("Province"); }); modelBuilder.Entity("FlexJobApi.Core.Menu", b => { b.HasOne("FlexJobApi.Core.Menu", "Parent") - .WithMany("Childrens") + .WithMany("Children") .HasForeignKey("ParentId"); b.Navigation("Parent"); @@ -1783,21 +1528,21 @@ b.Navigation("Role"); }); - modelBuilder.Entity("FlexJobApi.Core.RoleWebApi", b => + modelBuilder.Entity("FlexJobApi.Core.RoleResource", b => { - b.HasOne("FlexJobApi.Core.Menu", "Menu") + b.HasOne("FlexJobApi.Core.Resource", "Resource") .WithMany() - .HasForeignKey("MenuId") + .HasForeignKey("ResourceId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("FlexJobApi.Core.Role", "Role") - .WithMany("RoleWebApis") + .WithMany("RoleResources") .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.Navigation("Menu"); + b.Navigation("Resource"); b.Navigation("Role"); }); @@ -1806,9 +1551,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() @@ -1816,23 +1561,32 @@ .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.TaskInfo", "TaskInfo") - .WithMany("Benefits") - .HasForeignKey("BenefitId") + b.HasOne("FlexJobApi.Core.DictionaryData", "Benefit") + .WithMany() + .HasForeignKey("BenefitCode") + .HasPrincipalKey("Code") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); - b.HasOne("FlexJobApi.Core.DictionaryData", "Benefit") - .WithMany() - .HasForeignKey("BenefitId1") - .OnDelete(DeleteBehavior.Cascade) + b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo") + .WithMany("Benefits") + .HasForeignKey("TaskInfoId") + .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("Benefit"); @@ -1850,7 +1604,10 @@ b.HasOne("FlexJobApi.Core.DictionaryData", "Type") .WithMany() - .HasForeignKey("TypeId"); + .HasForeignKey("TypeCode") + .HasPrincipalKey("Code") + .OnDelete(DeleteBehavior.Restrict) + .IsRequired(); b.Navigation("TaskInfo"); @@ -1876,42 +1633,19 @@ 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") .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") @@ -1919,7 +1653,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("ProvinceCode") + .HasPrincipalKey("Code") + .OnDelete(DeleteBehavior.Restrict); b.HasOne("FlexJobApi.Core.UserAuth", "UserAuth") .WithMany("UserInfos") @@ -1934,6 +1676,8 @@ b.Navigation("Enterprise"); b.Navigation("PersonalIdentity"); + + b.Navigation("Province"); b.Navigation("UserAuth"); }); @@ -1951,29 +1695,18 @@ 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"); + .HasForeignKey("TypeCode") + .HasPrincipalKey("Code") + .OnDelete(DeleteBehavior.Restrict) + .IsRequired(); b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo") .WithMany("UserInfoCredentials") .HasForeignKey("UserInfoId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - - b.Navigation("BackImg"); - - b.Navigation("Img"); b.Navigation("Type"); @@ -2003,8 +1736,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") @@ -2020,19 +1754,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"); }); @@ -2040,7 +1766,7 @@ modelBuilder.Entity("FlexJobApi.Core.UserInfoRole", b => { b.HasOne("FlexJobApi.Core.Role", "Role") - .WithMany() + .WithMany("UserInfoRoles") .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); @@ -2058,12 +1784,12 @@ modelBuilder.Entity("FlexJobApi.Core.Department", b => { - b.Navigation("Childrens"); + b.Navigation("Children"); }); modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b => { - b.Navigation("Childrens"); + b.Navigation("Children"); }); modelBuilder.Entity("FlexJobApi.Core.Enterprise", b => @@ -2075,14 +1801,16 @@ modelBuilder.Entity("FlexJobApi.Core.Menu", b => { - b.Navigation("Childrens"); + b.Navigation("Children"); }); modelBuilder.Entity("FlexJobApi.Core.Role", b => { b.Navigation("RoleMenus"); - b.Navigation("RoleWebApis"); + b.Navigation("RoleResources"); + + b.Navigation("UserInfoRoles"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b => -- Gitblit v1.9.1