From 1759ab1a7d3e536eb812dcfbf5a7c8792ed28b2e Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期一, 11 八月 2025 09:04:29 +0800 Subject: [PATCH] feat:简历开发 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 767 ++++++++++++++++++++++++++++++++++++++++------------------- 1 files changed, 520 insertions(+), 247 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index a69c87f..2d845ee 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -28,10 +28,13 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<Guid>("EnterpriseId") @@ -65,7 +68,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -88,10 +91,13 @@ .HasMaxLength(128) .HasColumnType("nvarchar(128)"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<string>("FieldNames") @@ -117,7 +123,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -143,10 +149,13 @@ .IsRequired() .HasColumnType("nvarchar(max)"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<int>("Deep") @@ -188,7 +197,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -233,14 +242,19 @@ .HasMaxLength(32) .HasColumnType("nvarchar(32)"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("EnterpriseAuthId") - .HasColumnType("uniqueidentifier"); + b.Property<string>("EnterpriseName") + .IsRequired() + .HasMaxLength(128) + .HasColumnType("nvarchar(128)"); b.Property<string>("IndustryTypeCode") .HasColumnType("nvarchar(128)"); @@ -250,6 +264,20 @@ b.Property<bool>("IsDeleted") .HasColumnType("bit"); + + b.Property<bool>("IsReal") + .HasColumnType("bit"); + + b.Property<string>("LegalIdentity") + .HasMaxLength(18) + .HasColumnType("nvarchar(18)"); + + b.Property<string>("LegalPerson") + .HasMaxLength(32) + .HasColumnType("nvarchar(32)"); + + b.Property<string>("LicenseImage") + .HasColumnType("nvarchar(max)"); b.Property<string>("MainBusiness") .HasColumnType("nvarchar(max)"); @@ -278,6 +306,11 @@ b.Property<decimal>("SmsCost") .HasColumnType("decimal(18,2)"); + b.Property<string>("SocietyCreditCode") + .IsRequired() + .HasMaxLength(18) + .HasColumnType("nvarchar(18)"); + b.Property<int>("Sort") .HasColumnType("int"); @@ -287,14 +320,12 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); b.HasIndex("CityCode"); - - b.HasIndex("EnterpriseAuthId"); b.HasIndex("IndustryTypeCode"); @@ -316,10 +347,13 @@ b.Property<string>("BankCardImg") .HasColumnType("nvarchar(max)"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<string>("EnterpriseName") @@ -341,9 +375,6 @@ .HasColumnType("nvarchar(max)"); b.Property<bool>("IsDeleted") - .HasColumnType("bit"); - - b.Property<bool>("IsReal") .HasColumnType("bit"); b.Property<string>("LegalIdentity") @@ -388,7 +419,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -409,10 +440,13 @@ .IsRequired() .HasColumnType("nvarchar(max)"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<string>("Group") @@ -459,7 +493,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.Property<string>("Url") @@ -509,10 +543,13 @@ b.Property<string>("ControllerSummary") .HasColumnType("nvarchar(max)"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<string>("DynamicAssemblyName") @@ -540,11 +577,9 @@ .HasColumnType("nvarchar(max)"); b.Property<string>("ResponseTypeFullName") - .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ResponseTypeName") - .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("Route") @@ -569,7 +604,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -586,10 +621,13 @@ b.Property<int>("ClientType") .HasColumnType("int"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<int>("DataPower") @@ -621,7 +659,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.Property<int>("UserType") @@ -638,10 +676,13 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") @@ -662,7 +703,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -680,10 +721,13 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<int>("DataPower") @@ -707,7 +751,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -719,13 +763,176 @@ b.ToTable("RoleResource"); }); + modelBuilder.Entity("FlexJobApi.Core.ScheduleJobDetail", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<string>("AssemblyName") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("Concurrent") + .HasColumnType("bit"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Description") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("GroupName") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IncludeAnnotations") + .HasColumnType("bit"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<string>("JobId") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("JobType") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("Properties") + .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?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.ToTable("ScheduleJobDetail"); + }); + + modelBuilder.Entity("FlexJobApi.Core.ScheduleJobTrigger", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Args") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("AssemblyName") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Description") + .HasColumnType("nvarchar(max)"); + + b.Property<long>("ElapsedTime") + .HasColumnType("bigint"); + + b.Property<DateTime?>("EndTime") + .HasColumnType("datetime2"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<string>("JobId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTime?>("LastRunTime") + .HasColumnType("datetime2"); + + b.Property<long>("MaxNumberOfErrors") + .HasColumnType("bigint"); + + b.Property<long>("MaxNumberOfRuns") + .HasColumnType("bigint"); + + b.Property<DateTime?>("NextRunTime") + .HasColumnType("datetime2"); + + b.Property<long>("NumRetries") + .HasColumnType("bigint"); + + b.Property<long>("NumberOfErrors") + .HasColumnType("bigint"); + + b.Property<long>("NumberOfRuns") + .HasColumnType("bigint"); + + b.Property<bool>("ResetOnlyOnce") + .HasColumnType("bit"); + + b.Property<string>("Result") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("RetryTimeout") + .HasColumnType("int"); + + b.Property<bool>("RunOnStart") + .HasColumnType("bit"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<bool>("StartNow") + .HasColumnType("bit"); + + b.Property<DateTime?>("StartTime") + .HasColumnType("datetime2"); + + b.Property<long>("Status") + .HasColumnType("bigint"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("TriggerId") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("TriggerType") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.ToTable("ScheduleJobTrigger"); + }); + modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); - b.Property<string>("Address") + b.Property<string>("AddressDetail") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("AddressName") .HasColumnType("nvarchar(max)"); b.Property<int>("AgeMaxLimit") @@ -740,16 +947,22 @@ b.Property<int>("BillingMethod") .HasColumnType("int"); + b.Property<int?>("CheckReceiveStatus") + .HasColumnType("int"); + b.Property<string>("CityCode") .HasColumnType("nvarchar(128)"); b.Property<string>("Code") .HasColumnType("nvarchar(max)"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<DateTime>("EndTime") @@ -764,12 +977,21 @@ b.Property<bool>("IsDeleted") .HasColumnType("bit"); + b.Property<decimal?>("Latitude") + .HasColumnType("decimal(18,6)"); + + b.Property<decimal?>("Longitude") + .HasColumnType("decimal(18,6)"); + b.Property<string>("Name") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property<string>("ProvinceCode") .HasColumnType("nvarchar(128)"); + + b.Property<int>("RecommendStatus") + .HasColumnType("int"); b.Property<int>("ReleaseStatus") .HasColumnType("int"); @@ -778,6 +1000,9 @@ .HasColumnType("decimal(18,2)"); b.Property<int>("SettlementCycle") + .HasColumnType("int"); + + b.Property<int?>("SettlementStatus") .HasColumnType("int"); b.Property<int>("Sort") @@ -792,7 +1017,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -816,10 +1041,13 @@ .IsRequired() .HasColumnType("nvarchar(128)"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") @@ -837,7 +1065,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -855,10 +1083,13 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") @@ -880,7 +1111,7 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); @@ -898,10 +1129,13 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<int>("HireStatus") @@ -931,125 +1165,46 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("UserInfoId") + b.Property<Guid>("UserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); b.HasIndex("TaskInfoId"); - b.HasIndex("UserInfoId"); + b.HasIndex("UserId"); b.ToTable("TaskInfoUser"); }); - modelBuilder.Entity("FlexJobApi.Core.UserAuth", b => + modelBuilder.Entity("FlexJobApi.Core.User", 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>("Identity") - .HasColumnType("nvarchar(max)"); - - b.Property<string>("IdentityBackImg") - .HasColumnType("nvarchar(max)"); - - b.Property<string>("IdentityImg") - .HasColumnType("nvarchar(max)"); - - b.Property<bool>("IsCheckPhoneNumber") - .HasColumnType("bit"); - - b.Property<bool>("IsDeleted") - .HasColumnType("bit"); - - b.Property<bool>("IsReal") - .HasColumnType("bit"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("nvarchar(32)"); - - b.Property<string>("Password") - .HasColumnType("nvarchar(max)"); - - b.Property<string>("PhoneNumber") - .HasMaxLength(11) - .HasColumnType("nvarchar(11)"); - - b.Property<int?>("RealAccess") + b.Property<int?>("Age") .HasColumnType("int"); - - 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.Property<string>("UserName") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("nvarchar(32)"); - - b.HasKey("Id"); - - b.ToTable("UserAuth"); - - b.HasData( - new - { - Id = new Guid("11111111-1111-1111-1111-111111111111"), - CreatedTime = new DateTimeOffset(new DateTime(2000, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), - IsCheckPhoneNumber = false, - IsDeleted = false, - IsReal = false, - Name = "绠$悊鍛�", - Password = "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=", - Sort = 0, - UserName = "system" - }); - }); - - modelBuilder.Entity("FlexJobApi.Core.UserInfo", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uniqueidentifier"); b.Property<string>("Avatar") .HasColumnType("nvarchar(max)"); + b.Property<DateTime?>("Birthday") + .HasColumnType("datetime2"); + b.Property<string>("CityCode") .HasColumnType("nvarchar(128)"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<string>("EducationalBackgroundCode") @@ -1061,10 +1216,22 @@ b.Property<int?>("FreeTime") .HasColumnType("int"); + b.Property<int?>("Gender") + .HasColumnType("int"); + b.Property<int?>("Height") .HasColumnType("int"); + b.Property<string>("Identity") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IsCheckPhoneNumber") + .HasColumnType("bit"); + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<bool>("IsReal") .HasColumnType("bit"); b.Property<int?>("JobSeekingStatus") @@ -1073,11 +1240,25 @@ b.Property<int>("Level") .HasColumnType("int"); + b.Property<string>("Name") + .HasMaxLength(32) + .HasColumnType("nvarchar(32)"); + + b.Property<string>("Password") + .HasColumnType("nvarchar(max)"); + b.Property<string>("PersonalIdentityCode") .HasColumnType("nvarchar(128)"); + b.Property<string>("PhoneNumber") + .HasMaxLength(11) + .HasColumnType("nvarchar(11)"); + b.Property<string>("ProvinceCode") .HasColumnType("nvarchar(128)"); + + b.Property<int?>("RealAccess") + .HasColumnType("int"); b.Property<string>("Remark") .HasColumnType("nvarchar(max)"); @@ -1097,11 +1278,13 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("UserAuthId") - .HasColumnType("uniqueidentifier"); + b.Property<string>("UserName") + .IsRequired() + .HasMaxLength(32) + .HasColumnType("nvarchar(32)"); b.Property<int?>("Weight") .HasColumnType("int"); @@ -1128,25 +1311,87 @@ b.HasIndex("ProvinceCode"); - b.HasIndex("UserAuthId"); - - b.ToTable("UserInfo"); + b.ToTable("User"); b.HasData( new { - Id = new Guid("11111111-1111-1111-1111-111111111112"), + Id = new Guid("11111111-1111-1111-1111-111111111111"), CreatedTime = new DateTimeOffset(new DateTime(2000, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), new TimeSpan(0, 8, 0, 0, 0)), + IsCheckPhoneNumber = false, IsDeleted = false, + IsReal = false, Level = 999, + Name = "绠$悊鍛�", + Password = "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=", Sort = 0, - Status = 0, + Status = 10, Type = 100, - UserAuthId = new Guid("11111111-1111-1111-1111-111111111111") + UserName = "system" }); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoBankCard", b => + modelBuilder.Entity("FlexJobApi.Core.UserAuth", 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<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + + b.Property<DateTimeOffset>("CreatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("CreatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Identity") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("IdentityBackImg") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("IdentityImg") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<string>("Name") + .IsRequired() + .HasMaxLength(32) + .HasColumnType("nvarchar(32)"); + + b.Property<string>("PhoneNumber") + .HasMaxLength(11) + .HasColumnType("nvarchar(11)"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.ToTable("UserAuth"); + }); + + modelBuilder.Entity("FlexJobApi.Core.UserBankCard", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() @@ -1162,10 +1407,13 @@ .HasMaxLength(32) .HasColumnType("nvarchar(32)"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") @@ -1185,20 +1433,20 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("UserInfoId") + b.Property<Guid>("UserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.HasIndex("UserInfoId"); + b.HasIndex("UserId"); - b.ToTable("UserInfoBankCard"); + b.ToTable("UserBankCard"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoCredential", b => + modelBuilder.Entity("FlexJobApi.Core.UserCredential", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() @@ -1208,14 +1456,16 @@ .HasColumnType("nvarchar(max)"); b.Property<string>("Code") - .IsRequired() .HasMaxLength(128) .HasColumnType("nvarchar(128)"); + + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<DateTime>("EndDate") @@ -1249,31 +1499,34 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("UserInfoId") + b.Property<Guid>("UserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); b.HasIndex("TypeCode"); - b.HasIndex("UserInfoId"); + b.HasIndex("UserId"); - b.ToTable("UserInfoCredential"); + b.ToTable("UserCredential"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoDepartment", b => + modelBuilder.Entity("FlexJobApi.Core.UserDepartment", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<Guid>("DepartmentId") @@ -1291,39 +1544,42 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("UserInfoId") + b.Property<Guid>("UserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); b.HasIndex("DepartmentId"); - b.HasIndex("UserInfoId"); + b.HasIndex("UserId"); - b.ToTable("UserInfoDepartment"); + b.ToTable("UserDepartment"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoExpectJob", b => + modelBuilder.Entity("FlexJobApi.Core.UserExpectJob", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); + + b.Property<string>("ExpectJobCode") + .IsRequired() + .HasColumnType("nvarchar(128)"); b.Property<bool>("IsDeleted") .HasColumnType("bit"); - - b.Property<string>("PersonalIdentityCode") - .IsRequired() - .HasColumnType("nvarchar(128)"); b.Property<int>("Sort") .HasColumnType("int"); @@ -1334,31 +1590,34 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("UserInfoId") + b.Property<Guid>("UserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.HasIndex("PersonalIdentityCode"); + b.HasIndex("ExpectJobCode"); - b.HasIndex("UserInfoId"); + b.HasIndex("UserId"); - b.ToTable("UserInfoExpectJob"); + b.ToTable("UserExpectJob"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoPhoto", b => + modelBuilder.Entity("FlexJobApi.Core.UserPhoto", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<string>("Img") @@ -1376,29 +1635,32 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("UserInfoId") + b.Property<Guid>("UserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); - b.HasIndex("UserInfoId"); + b.HasIndex("UserId"); - b.ToTable("UserInfoPhoto"); + b.ToTable("UserPhoto"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoRole", b => + modelBuilder.Entity("FlexJobApi.Core.UserRole", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<Guid?>("CreatedEnterpriseId") + .HasColumnType("uniqueidentifier"); + b.Property<DateTimeOffset>("CreatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("CreatedUserInfoId") + b.Property<Guid?>("CreatedUserId") .HasColumnType("uniqueidentifier"); b.Property<bool>("IsDeleted") @@ -1416,19 +1678,19 @@ b.Property<DateTimeOffset?>("UpdatedTime") .HasColumnType("datetimeoffset"); - b.Property<Guid?>("UpdatedUserInfoId") + b.Property<Guid?>("UpdatedUserId") .HasColumnType("uniqueidentifier"); - b.Property<Guid>("UserInfoId") + b.Property<Guid>("UserId") .HasColumnType("uniqueidentifier"); b.HasKey("Id"); b.HasIndex("RoleId"); - b.HasIndex("UserInfoId"); + b.HasIndex("UserId"); - b.ToTable("UserInfoRole"); + b.ToTable("UserRole"); }); modelBuilder.Entity("FlexJobApi.Core.Department", b => @@ -1473,12 +1735,6 @@ .HasPrincipalKey("Code") .OnDelete(DeleteBehavior.Restrict); - b.HasOne("FlexJobApi.Core.EnterpriseAuth", "EnterpriseAuth") - .WithMany() - .HasForeignKey("EnterpriseAuthId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - b.HasOne("FlexJobApi.Core.DictionaryData", "IndustryType") .WithMany() .HasForeignKey("IndustryTypeCode") @@ -1493,11 +1749,20 @@ b.Navigation("City"); - b.Navigation("EnterpriseAuth"); - b.Navigation("IndustryType"); b.Navigation("Province"); + }); + + modelBuilder.Entity("FlexJobApi.Core.EnterpriseAuth", b => + { + b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise") + .WithOne("EnterpriseAuth") + .HasForeignKey("FlexJobApi.Core.EnterpriseAuth", "Id") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("Enterprise"); }); modelBuilder.Entity("FlexJobApi.Core.Menu", b => @@ -1586,7 +1851,7 @@ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo") .WithMany("Benefits") .HasForeignKey("TaskInfoId") - .OnDelete(DeleteBehavior.Restrict) + .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Benefit"); @@ -1617,23 +1882,23 @@ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b => { b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo") - .WithMany() + .WithMany("Users") .HasForeignKey("TaskInfoId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo") + b.HasOne("FlexJobApi.Core.User", "User") .WithMany() - .HasForeignKey("UserInfoId") + .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("TaskInfo"); - b.Navigation("UserInfo"); + b.Navigation("User"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfo", b => + modelBuilder.Entity("FlexJobApi.Core.User", b => { b.HasOne("FlexJobApi.Core.DictionaryData", "City") .WithMany() @@ -1648,7 +1913,7 @@ .OnDelete(DeleteBehavior.Restrict); b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise") - .WithMany("UserInfos") + .WithMany("Users") .HasForeignKey("EnterpriseId"); b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity") @@ -1663,12 +1928,6 @@ .HasPrincipalKey("Code") .OnDelete(DeleteBehavior.Restrict); - b.HasOne("FlexJobApi.Core.UserAuth", "UserAuth") - .WithMany("UserInfos") - .HasForeignKey("UserAuthId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - b.Navigation("City"); b.Navigation("EducationalBackground"); @@ -1678,22 +1937,31 @@ b.Navigation("PersonalIdentity"); b.Navigation("Province"); - - b.Navigation("UserAuth"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoBankCard", b => + modelBuilder.Entity("FlexJobApi.Core.UserAuth", b => { - b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo") - .WithMany() - .HasForeignKey("UserInfoId") + b.HasOne("FlexJobApi.Core.User", "User") + .WithOne("UserAuth") + .HasForeignKey("FlexJobApi.Core.UserAuth", "Id") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.Navigation("UserInfo"); + b.Navigation("User"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoCredential", b => + modelBuilder.Entity("FlexJobApi.Core.UserBankCard", b => + { + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany("BankCards") + .HasForeignKey("UserId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("User"); + }); + + modelBuilder.Entity("FlexJobApi.Core.UserCredential", b => { b.HasOne("FlexJobApi.Core.DictionaryData", "Type") .WithMany() @@ -1702,18 +1970,18 @@ .OnDelete(DeleteBehavior.Restrict) .IsRequired(); - b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo") - .WithMany("UserInfoCredentials") - .HasForeignKey("UserInfoId") + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany("UserCredentials") + .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Type"); - b.Navigation("UserInfo"); + b.Navigation("User"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoDepartment", b => + modelBuilder.Entity("FlexJobApi.Core.UserDepartment", b => { b.HasOne("FlexJobApi.Core.Department", "Department") .WithMany() @@ -1721,65 +1989,65 @@ .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo") - .WithMany("UserInfoDepartments") - .HasForeignKey("UserInfoId") + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany("UserDepartments") + .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Department"); - b.Navigation("UserInfo"); + b.Navigation("User"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoExpectJob", b => + modelBuilder.Entity("FlexJobApi.Core.UserExpectJob", b => { - b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity") + b.HasOne("FlexJobApi.Core.DictionaryData", "ExpectJob") .WithMany() - .HasForeignKey("PersonalIdentityCode") + .HasForeignKey("ExpectJobCode") .HasPrincipalKey("Code") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); - b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo") - .WithMany("UserInfoExpectJobs") - .HasForeignKey("UserInfoId") + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany("UserExpectJobs") + .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.Navigation("PersonalIdentity"); + b.Navigation("ExpectJob"); - b.Navigation("UserInfo"); + b.Navigation("User"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoPhoto", b => + modelBuilder.Entity("FlexJobApi.Core.UserPhoto", b => { - b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo") - .WithMany() - .HasForeignKey("UserInfoId") + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany("Photos") + .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.Navigation("UserInfo"); + b.Navigation("User"); }); - modelBuilder.Entity("FlexJobApi.Core.UserInfoRole", b => + modelBuilder.Entity("FlexJobApi.Core.UserRole", b => { b.HasOne("FlexJobApi.Core.Role", "Role") - .WithMany("UserInfoRoles") + .WithMany("UserRoles") .HasForeignKey("RoleId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); - b.HasOne("FlexJobApi.Core.UserInfo", "UserInfo") - .WithMany("UserInfoRoles") - .HasForeignKey("UserInfoId") + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany("UserRoles") + .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Role"); - b.Navigation("UserInfo"); + b.Navigation("User"); }); modelBuilder.Entity("FlexJobApi.Core.Department", b => @@ -1796,7 +2064,9 @@ { b.Navigation("Departments"); - b.Navigation("UserInfos"); + b.Navigation("EnterpriseAuth"); + + b.Navigation("Users"); }); modelBuilder.Entity("FlexJobApi.Core.Menu", b => @@ -1810,7 +2080,7 @@ b.Navigation("RoleResources"); - b.Navigation("UserInfoRoles"); + b.Navigation("UserRoles"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b => @@ -1818,22 +2088,25 @@ b.Navigation("Benefits"); b.Navigation("CredentialLimits"); + + b.Navigation("Users"); }); - modelBuilder.Entity("FlexJobApi.Core.UserAuth", b => + modelBuilder.Entity("FlexJobApi.Core.User", b => { - b.Navigation("UserInfos"); - }); + b.Navigation("BankCards"); - modelBuilder.Entity("FlexJobApi.Core.UserInfo", b => - { - b.Navigation("UserInfoCredentials"); + b.Navigation("Photos"); - b.Navigation("UserInfoDepartments"); + b.Navigation("UserAuth"); - b.Navigation("UserInfoExpectJobs"); + b.Navigation("UserCredentials"); - b.Navigation("UserInfoRoles"); + b.Navigation("UserDepartments"); + + b.Navigation("UserExpectJobs"); + + b.Navigation("UserRoles"); }); #pragma warning restore 612, 618 } -- Gitblit v1.9.1