From 345de08ba60e93aa448083cf70ccccbd4cfdd0e3 Mon Sep 17 00:00:00 2001
From: sunpengfei <i@angelzzz.com>
Date: 星期五, 08 八月 2025 17:08:27 +0800
Subject: [PATCH] pref:优化
---
FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 704 +++++++++++++++++++++++++++++++++++----------------------
1 files changed, 429 insertions(+), 275 deletions(-)
diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
index a69c87f..fbfc3c8 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");
@@ -725,7 +769,10 @@
.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 +787,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 +817,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 +840,9 @@
.HasColumnType("decimal(18,2)");
b.Property<int>("SettlementCycle")
+ .HasColumnType("int");
+
+ b.Property<int?>("SettlementStatus")
.HasColumnType("int");
b.Property<int>("Sort")
@@ -792,7 +857,7 @@
b.Property<DateTimeOffset?>("UpdatedTime")
.HasColumnType("datetimeoffset");
- b.Property<Guid?>("UpdatedUserInfoId")
+ b.Property<Guid?>("UpdatedUserId")
.HasColumnType("uniqueidentifier");
b.HasKey("Id");
@@ -816,10 +881,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 +905,7 @@
b.Property<DateTimeOffset?>("UpdatedTime")
.HasColumnType("datetimeoffset");
- b.Property<Guid?>("UpdatedUserInfoId")
+ b.Property<Guid?>("UpdatedUserId")
.HasColumnType("uniqueidentifier");
b.HasKey("Id");
@@ -855,10 +923,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 +951,7 @@
b.Property<DateTimeOffset?>("UpdatedTime")
.HasColumnType("datetimeoffset");
- b.Property<Guid?>("UpdatedUserInfoId")
+ b.Property<Guid?>("UpdatedUserId")
.HasColumnType("uniqueidentifier");
b.HasKey("Id");
@@ -898,10 +969,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,48 +1005,44 @@
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")
+ b.Property<string>("Avatar")
.HasColumnType("nvarchar(max)");
+
+ 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>("Identity")
- .HasColumnType("nvarchar(max)");
-
- b.Property<string>("IdentityBackImg")
- .HasColumnType("nvarchar(max)");
-
- b.Property<string>("IdentityImg")
- .HasColumnType("nvarchar(max)");
+ b.Property<Guid?>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
b.Property<bool>("IsCheckPhoneNumber")
.HasColumnType("bit");
@@ -982,6 +1052,9 @@
b.Property<bool>("IsReal")
.HasColumnType("bit");
+
+ b.Property<int>("Level")
+ .HasColumnType("int");
b.Property<string>("Name")
.IsRequired()
@@ -995,89 +1068,11 @@
.HasMaxLength(11)
.HasColumnType("nvarchar(11)");
- b.Property<int?>("RealAccess")
- .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<string>("CityCode")
- .HasColumnType("nvarchar(128)");
-
- b.Property<DateTimeOffset>("CreatedTime")
- .HasColumnType("datetimeoffset");
-
- b.Property<Guid?>("CreatedUserInfoId")
- .HasColumnType("uniqueidentifier");
-
- b.Property<string>("EducationalBackgroundCode")
- .HasColumnType("nvarchar(128)");
-
- b.Property<Guid?>("EnterpriseId")
- .HasColumnType("uniqueidentifier");
-
- b.Property<int?>("FreeTime")
- .HasColumnType("int");
-
- b.Property<int?>("Height")
- .HasColumnType("int");
-
- b.Property<bool>("IsDeleted")
- .HasColumnType("bit");
-
- b.Property<int?>("JobSeekingStatus")
- .HasColumnType("int");
-
- b.Property<int>("Level")
- .HasColumnType("int");
-
- b.Property<string>("PersonalIdentityCode")
- .HasColumnType("nvarchar(128)");
-
b.Property<string>("ProvinceCode")
.HasColumnType("nvarchar(128)");
+
+ b.Property<int?>("RealAccess")
+ .HasColumnType("int");
b.Property<string>("Remark")
.HasColumnType("nvarchar(max)");
@@ -1097,20 +1092,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<int?>("Weight")
- .HasColumnType("int");
-
- b.Property<string>("WorkExperience")
- .HasColumnType("nvarchar(max)");
-
- b.Property<string>("WorkSeniority")
- .HasColumnType("nvarchar(max)");
+ b.Property<string>("UserName")
+ .IsRequired()
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
b.Property<string>("WxmpOpenId")
.HasMaxLength(32)
@@ -1120,33 +1108,91 @@
b.HasIndex("CityCode");
- b.HasIndex("EducationalBackgroundCode");
-
b.HasIndex("EnterpriseId");
-
- b.HasIndex("PersonalIdentityCode");
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 +1208,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 +1234,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()
@@ -1212,10 +1261,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<DateTime>("EndDate")
@@ -1249,31 +1301,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,31 +1346,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("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<bool>("IsDeleted")
@@ -1334,31 +1392,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("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 +1437,100 @@
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.UserResume", 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>("EducationalBackgroundCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<int?>("FreeTime")
+ .HasColumnType("int");
+
+ b.Property<int?>("Height")
+ .HasColumnType("int");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<int?>("JobSeekingStatus")
+ .HasColumnType("int");
+
+ b.Property<string>("PersonalIdentityCode")
+ .HasColumnType("nvarchar(128)");
+
+ 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.Property<Guid>("UserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("Weight")
+ .HasColumnType("int");
+
+ b.Property<string>("WorkExperience")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("WorkSeniority")
+ .HasColumnType("nvarchar(max)");
+
+ b.HasKey("Id");
+
+ b.HasIndex("EducationalBackgroundCode");
+
+ b.HasIndex("PersonalIdentityCode");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserResume");
+ });
+
+ 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?>("CreatedUserId")
.HasColumnType("uniqueidentifier");
b.Property<bool>("IsDeleted")
@@ -1416,19 +1548,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 +1605,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 +1619,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 +1721,7 @@
b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
.WithMany("Benefits")
.HasForeignKey("TaskInfoId")
- .OnDelete(DeleteBehavior.Restrict)
+ .OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("Benefit");
@@ -1617,23 +1752,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()
@@ -1641,21 +1776,9 @@
.HasPrincipalKey("Code")
.OnDelete(DeleteBehavior.Restrict);
- b.HasOne("FlexJobApi.Core.DictionaryData", "EducationalBackground")
- .WithMany()
- .HasForeignKey("EducationalBackgroundCode")
- .HasPrincipalKey("Code")
- .OnDelete(DeleteBehavior.Restrict);
-
b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
- .WithMany("UserInfos")
+ .WithMany("Users")
.HasForeignKey("EnterpriseId");
-
- b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity")
- .WithMany()
- .HasForeignKey("PersonalIdentityCode")
- .HasPrincipalKey("Code")
- .OnDelete(DeleteBehavior.Restrict);
b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
.WithMany()
@@ -1663,37 +1786,36 @@
.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");
b.Navigation("Enterprise");
- 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 +1824,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,18 +1843,18 @@
.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")
.WithMany()
@@ -1741,45 +1863,72 @@
.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("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.UserResume", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "EducationalBackground")
+ .WithMany()
+ .HasForeignKey("EducationalBackgroundCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity")
+ .WithMany()
+ .HasForeignKey("PersonalIdentityCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany()
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("EducationalBackground");
+
+ b.Navigation("PersonalIdentity");
+
+ b.Navigation("User");
+ });
+
+ 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 +1945,9 @@
{
b.Navigation("Departments");
- b.Navigation("UserInfos");
+ b.Navigation("EnterpriseAuth");
+
+ b.Navigation("Users");
});
modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
@@ -1810,7 +1961,7 @@
b.Navigation("RoleResources");
- b.Navigation("UserInfoRoles");
+ b.Navigation("UserRoles");
});
modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b =>
@@ -1818,22 +1969,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