From bc6813b74e9a390eae2181d460c647445b7cb25a Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期三, 06 八月 2025 11:22:18 +0800 Subject: [PATCH] feat:数据字典开发 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 304 +++++++++++++++++++++++++++++++++++--------------- 1 files changed, 214 insertions(+), 90 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index a0ea0fc..2b196b6 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -56,6 +56,10 @@ .HasColumnType("uniqueidentifier") .HasComment("涓婄骇Id"); + b.Property<string>("Path") + .HasColumnType("nvarchar(max)") + .HasComment("閮ㄩ棬璺緞"); + b.Property<string>("Remark") .HasColumnType("nvarchar(max)") .HasComment("澶囨敞"); @@ -119,6 +123,10 @@ .HasMaxLength(128) .HasColumnType("nvarchar(128)") .HasComment("鍚嶇О"); + + b.Property<string>("Remark") + .HasColumnType("nvarchar(max)") + .HasComment("澶囨敞"); b.Property<int>("Sort") .HasColumnType("int") @@ -194,9 +202,17 @@ .HasColumnType("bit") .HasComment("鏄惁鍒犻櫎"); + b.Property<bool>("IsDisabled") + .HasColumnType("bit") + .HasComment("鏄惁绂佺敤"); + b.Property<Guid?>("ParentId") .HasColumnType("uniqueidentifier") .HasComment("涓婄骇Id"); + + b.Property<string>("Path") + .HasColumnType("nvarchar(max)") + .HasComment("瀛楀吀璺緞"); b.Property<int>("Sort") .HasColumnType("int") @@ -239,6 +255,16 @@ b.Property<Guid?>("BankCardImgId") .HasColumnType("uniqueidentifier") .HasComment("娉曚汉鎴栫粡鍔炰汉閾惰鍗$収鐗嘔d"); + + b.Property<string>("ContactNumber") + .HasMaxLength(11) + .HasColumnType("nvarchar(11)") + .HasComment("鑱旂郴鐢佃瘽"); + + b.Property<string>("Contacts") + .HasMaxLength(32) + .HasColumnType("nvarchar(32)") + .HasComment("鑱旂郴浜�"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); @@ -501,9 +527,9 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); - b.Property<string>("BindField") - .HasColumnType("nvarchar(max)") - .HasComment("缁戝畾瀛楁"); + b.Property<int>("ClientType") + .HasColumnType("int") + .HasComment("瀹㈡埛绔被鍨�"); b.Property<string>("Code") .IsRequired() @@ -537,9 +563,9 @@ .HasColumnType("bit") .HasComment("鏄惁绂佺敤"); - b.Property<bool>("IsHidden") - .HasColumnType("bit") - .HasComment("鏄惁闅愯棌"); + b.Property<string>("Location") + .HasColumnType("nvarchar(max)") + .HasComment("浣嶇疆锛堢敤浜庢寜閽級"); b.Property<string>("Name") .IsRequired() @@ -550,6 +576,10 @@ b.Property<Guid?>("ParentId") .HasColumnType("uniqueidentifier") .HasComment("涓婄骇Id"); + + b.Property<string>("Path") + .HasColumnType("nvarchar(max)") + .HasComment("鑿滃崟璺緞"); b.Property<string>("Remark") .HasColumnType("nvarchar(max)") @@ -578,9 +608,17 @@ .HasColumnType("nvarchar(max)") .HasComment("閾炬帴鍦板潃"); + b.Property<int>("UserType") + .HasColumnType("int") + .HasComment("鐢ㄦ埛绫诲瀷"); + b.Property<int>("VisitLevel") .HasColumnType("int") .HasComment("璁块棶绾у埆"); + + b.Property<string>("Width") + .HasColumnType("nvarchar(max)") + .HasComment("鍒楀锛堢敤浜庢寜閽�/鍒�/鍏冪礌锛�"); b.HasKey("Id"); @@ -589,6 +627,129 @@ b.ToTable("Menu", t => { t.HasComment("鑿滃崟"); + }); + }); + + modelBuilder.Entity("FlexJobApi.Core.Resource", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<string>("ActionName") + .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() + .HasColumnType("nvarchar(max)") + .HasComment("缂栧彿"); + + b.Property<int>("Controller") + .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") + .HasComment("鏄惁鍒犻櫎"); + + b.Property<bool>("IsExpired") + .HasColumnType("bit") + .HasComment("鏄惁宸茶繃鏈�"); + + b.Property<int>("Method") + .HasColumnType("int") + .HasComment("璇锋眰鏂瑰紡"); + + b.Property<string>("Name") + .IsRequired() + .HasColumnType("nvarchar(max)") + .HasComment("鍚嶇О"); + + b.Property<string>("RequestTypeFullName") + .IsRequired() + .HasColumnType("nvarchar(max)") + .HasComment("璇锋眰绫诲瀷鍏ㄥ悕"); + + b.Property<string>("RequestTypeName") + .IsRequired() + .HasColumnType("nvarchar(max)") + .HasComment("璇锋眰绫诲瀷鍚嶇О"); + + b.Property<string>("ResponseTypeFullName") + .IsRequired() + .HasColumnType("nvarchar(max)") + .HasComment("鍝嶅簲绫诲瀷鍏ㄥ悕"); + + b.Property<string>("ResponseTypeName") + .IsRequired() + .HasColumnType("nvarchar(max)") + .HasComment("鍝嶅簲绫诲瀷鍚嶇О"); + + b.Property<string>("Route") + .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") + .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("Resource", t => + { + t.HasComment("璧勬簮"); }); }); @@ -609,9 +770,17 @@ .HasColumnType("uniqueidentifier") .HasComment("鍒涘缓鎿嶄綔浜�"); + b.Property<int>("DataPower") + .HasColumnType("int") + .HasComment("鏁版嵁鏉冮檺"); + b.Property<bool>("IsDeleted") .HasColumnType("bit") .HasComment("鏄惁鍒犻櫎"); + + b.Property<bool>("IsDisabled") + .HasColumnType("bit") + .HasComment("鏄惁绂佺敤"); b.Property<int>("MinLevel") .HasColumnType("int") @@ -622,6 +791,10 @@ .HasMaxLength(128) .HasColumnType("nvarchar(128)") .HasComment("鍚嶇О"); + + b.Property<string>("Remark") + .HasColumnType("nvarchar(max)") + .HasComment("澶囨敞"); b.Property<int>("Sort") .HasColumnType("int") @@ -702,7 +875,7 @@ }); }); - modelBuilder.Entity("FlexJobApi.Core.RoleWebApi", b => + modelBuilder.Entity("FlexJobApi.Core.RoleResource", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() @@ -715,7 +888,7 @@ .HasColumnType("uniqueidentifier") .HasComment("鍒涘缓鎿嶄綔浜�"); - b.Property<int?>("DataPower") + b.Property<int>("DataPower") .HasColumnType("int") .HasComment("鏁版嵁鏉冮檺"); @@ -723,9 +896,9 @@ .HasColumnType("bit") .HasComment("鏄惁鍒犻櫎"); - b.Property<Guid>("MenuId") + b.Property<Guid>("ResourceId") .HasColumnType("uniqueidentifier") - .HasComment("鑿滃崟Id"); + .HasComment("璧勬簮Id"); b.Property<Guid>("RoleId") .HasColumnType("uniqueidentifier") @@ -748,13 +921,13 @@ b.HasKey("Id"); - b.HasIndex("MenuId"); + b.HasIndex("ResourceId"); b.HasIndex("RoleId"); - b.ToTable("RoleWebApi", t => + b.ToTable("RoleResource", t => { - t.HasComment("瑙掕壊鎺ュ彛"); + t.HasComment("瑙掕壊璧勬簮"); }); }); @@ -1137,8 +1310,9 @@ IsDeleted = false, IsReal = false, Name = "绠$悊鍛�", + Password = "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=", Sort = 0, - UserName = "admin" + UserName = "system" }); }); @@ -1191,9 +1365,17 @@ .HasColumnType("uniqueidentifier") .HasComment("韬唤Id"); + b.Property<string>("Remark") + .HasColumnType("nvarchar(max)") + .HasComment("澶囨敞"); + b.Property<int>("Sort") .HasColumnType("int") .HasComment("鎺掑簭"); + + b.Property<int>("Status") + .HasColumnType("int") + .HasComment("鐘舵��"); b.Property<string>("TraceId") .HasColumnType("nvarchar(max)") @@ -1211,7 +1393,8 @@ .HasComment("鏈�鍚庢洿鏂版搷浣滀汉"); b.Property<Guid>("UserAuthId") - .HasColumnType("uniqueidentifier"); + .HasColumnType("uniqueidentifier") + .HasComment("鐢ㄦ埛Id"); b.Property<int?>("Weight") .HasColumnType("int") @@ -1255,6 +1438,7 @@ IsDeleted = false, Level = 999, Sort = 0, + Status = 0, Type = 100, UserAuthId = new Guid("11111111-1111-1111-1111-111111111111") }); @@ -1618,68 +1802,6 @@ }); }); - 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("鎺ュ彛"); - }); - }); - modelBuilder.Entity("FlexJobApi.Core.Department", b => { b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise") @@ -1689,7 +1811,7 @@ .IsRequired(); b.HasOne("FlexJobApi.Core.Department", "Parent") - .WithMany("Childrens") + .WithMany("Children") .HasForeignKey("ParentId"); b.Navigation("Enterprise"); @@ -1706,7 +1828,7 @@ .IsRequired(); b.HasOne("FlexJobApi.Core.DictionaryData", "Parent") - .WithMany("Childrens") + .WithMany("Children") .HasForeignKey("ParentId"); b.Navigation("Category"); @@ -1749,7 +1871,7 @@ modelBuilder.Entity("FlexJobApi.Core.Menu", b => { b.HasOne("FlexJobApi.Core.Menu", "Parent") - .WithMany("Childrens") + .WithMany("Children") .HasForeignKey("ParentId"); b.Navigation("Parent"); @@ -1774,21 +1896,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"); }); @@ -2031,7 +2153,7 @@ modelBuilder.Entity("FlexJobApi.Core.UserInfoRole", b => { b.HasOne("FlexJobApi.Core.Role", "Role") - .WithMany() + .WithMany("UserInfoRoles") .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); @@ -2049,12 +2171,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 => @@ -2066,14 +2188,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