From ed5ea9ae4c2e1a9f114e2302a9b3ca20168535c8 Mon Sep 17 00:00:00 2001
From: sunpengfei <i@angelzzz.com>
Date: 星期二, 12 八月 2025 09:55:56 +0800
Subject: [PATCH] feat:开发
---
FlexJobApi.Database.Migrations/Migrations/20250812014647_UpdateUser0812.cs | 152 +++
FlexJobApi.Database.Migrations/Migrations/20250812014647_UpdateUser0812.Designer.cs | 2208 ++++++++++++++++++++++++++++++++++++++++++++++++++++
FlexJobApi.Database.Migrations/REDEME.MD | 2
FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 102 ++
FlexJobApi.Core/Models/UserServer/UserResumes/Queries/GetUserResumeQuery.cs | 4
5 files changed, 2,457 insertions(+), 11 deletions(-)
diff --git a/FlexJobApi.Core/Models/UserServer/UserResumes/Queries/GetUserResumeQuery.cs b/FlexJobApi.Core/Models/UserServer/UserResumes/Queries/GetUserResumeQuery.cs
index 9df8bfc..e74306a 100644
--- a/FlexJobApi.Core/Models/UserServer/UserResumes/Queries/GetUserResumeQuery.cs
+++ b/FlexJobApi.Core/Models/UserServer/UserResumes/Queries/GetUserResumeQuery.cs
@@ -189,7 +189,7 @@
/// <summary>
/// 鎶ュ悕鏃堕棿
/// </summary>
- public DateTime? CreatedTime { get; set; }
+ public DateTimeOffset? CreatedTime { get; set; }
/// <summary>
/// 褰曠敤鐘舵��
@@ -334,11 +334,13 @@
/// <summary>
/// 浼佷笟鍏ㄧО
/// </summary>
+ [AdaptIgnore]
public string EnterpriseName => TaskInfo.Enterprise.EnterpriseName;
/// <summary>
/// 浠诲姟鍚嶇О
/// </summary>
+ [AdaptIgnore]
public string Name => TaskInfo.Name;
/// <summary>
diff --git a/FlexJobApi.Database.Migrations/Migrations/20250812014647_UpdateUser0812.Designer.cs b/FlexJobApi.Database.Migrations/Migrations/20250812014647_UpdateUser0812.Designer.cs
new file mode 100644
index 0000000..cc72a56
--- /dev/null
+++ b/FlexJobApi.Database.Migrations/Migrations/20250812014647_UpdateUser0812.Designer.cs
@@ -0,0 +1,2208 @@
+锘�// <auto-generated />
+using System;
+using FlexJobApi.EntityFramework.Core;
+using Microsoft.EntityFrameworkCore;
+using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Metadata;
+using Microsoft.EntityFrameworkCore.Migrations;
+using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
+
+#nullable disable
+
+namespace FlexJobApi.Database.Migrations.Migrations
+{
+ [DbContext(typeof(DefaultDbContext))]
+ [Migration("20250812014647_UpdateUser0812")]
+ partial class UpdateUser0812
+ {
+ /// <inheritdoc />
+ protected override void BuildTargetModel(ModelBuilder modelBuilder)
+ {
+#pragma warning disable 612, 618
+ modelBuilder
+ .HasAnnotation("ProductVersion", "9.0.7")
+ .HasAnnotation("Relational:MaxIdentifierLength", 128);
+
+ SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
+
+ modelBuilder.Entity("FlexJobApi.Core.Department", 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<Guid>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDisabled")
+ .HasColumnType("bit");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<Guid?>("ParentId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Path")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Remark")
+ .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.HasIndex("EnterpriseId");
+
+ b.HasIndex("ParentId");
+
+ b.ToTable("Department");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.DictionaryCategory", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ 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?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("FieldNames")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Remark")
+ .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("DictionaryCategory");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("CategoryId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Code")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Content")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("Deep")
+ .HasColumnType("int");
+
+ b.Property<string>("Field1")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Field2")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Field3")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Field4")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Field5")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDisabled")
+ .HasColumnType("bit");
+
+ b.Property<Guid?>("ParentId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Path")
+ .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.HasIndex("CategoryId");
+
+ b.HasIndex("Code")
+ .IsUnique();
+
+ b.HasIndex("ParentId");
+
+ b.ToTable("DictionaryData");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Enterprise", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("BankBranchName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("BankCard")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ 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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("EnterpriseName")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("IndustryTypeCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<bool>("IsCheckedBankCard")
+ .HasColumnType("bit");
+
+ 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)");
+
+ 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<string>("SocietyCreditCode")
+ .IsRequired()
+ .HasMaxLength(18)
+ .HasColumnType("nvarchar(18)");
+
+ 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.HasIndex("CityCode");
+
+ 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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("EnterpriseName")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<int?>("EnterpriseRealMethod")
+ .HasColumnType("int");
+
+ b.Property<string>("Identity")
+ .HasMaxLength(18)
+ .HasColumnType("nvarchar(18)");
+
+ b.Property<string>("IdentityBackImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("IdentityImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .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>("Name")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<int?>("PersonalRealMethod")
+ .HasColumnType("int");
+
+ b.Property<string>("PhoneNumber")
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<bool?>("Proxy")
+ .HasColumnType("bit");
+
+ b.Property<string>("ProxyPowerAttorneyUrl")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("SocietyCreditCode")
+ .IsRequired()
+ .HasMaxLength(18)
+ .HasColumnType("nvarchar(18)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("EnterpriseAuth");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("ClientType")
+ .HasColumnType("int");
+
+ b.Property<string>("Code")
+ .IsRequired()
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Group")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Icon")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsCache")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDisabled")
+ .HasColumnType("bit");
+
+ b.Property<string>("Location")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<Guid?>("ParentId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Path")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Remark")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Type")
+ .HasColumnType("int");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Url")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("UserType")
+ .HasColumnType("int");
+
+ b.Property<int>("VisitLevel")
+ .HasColumnType("int");
+
+ b.Property<string>("Width")
+ .HasColumnType("nvarchar(max)");
+
+ b.HasKey("Id");
+
+ b.HasIndex("ParentId");
+
+ 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<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .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")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("ResponseTypeName")
+ .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?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.ToTable("Resource");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Role", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("ClientType")
+ .HasColumnType("int");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("DataPower")
+ .HasColumnType("int");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsDisabled")
+ .HasColumnType("bit");
+
+ b.Property<int>("MinLevel")
+ .HasColumnType("int");
+
+ b.Property<string>("Name")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Remark")
+ .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.Property<int>("UserType")
+ .HasColumnType("int");
+
+ b.HasKey("Id");
+
+ b.ToTable("Role");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.RoleMenu", 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")
+ .HasColumnType("bit");
+
+ b.Property<Guid>("MenuId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("RoleId")
+ .HasColumnType("uniqueidentifier");
+
+ 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.HasIndex("MenuId");
+
+ b.HasIndex("RoleId");
+
+ b.ToTable("RoleMenu");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.RoleResource", 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<int>("DataPower")
+ .HasColumnType("int");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<Guid>("ResourceId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("RoleId")
+ .HasColumnType("uniqueidentifier");
+
+ 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.HasIndex("ResourceId");
+
+ b.HasIndex("RoleId");
+
+ 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>("AddressDetail")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("AddressName")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("AgeMaxLimit")
+ .HasColumnType("int");
+
+ b.Property<int>("AgeMinLimit")
+ .HasColumnType("int");
+
+ b.Property<DateTime>("BeginTime")
+ .HasColumnType("datetime2");
+
+ 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?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTime>("EndTime")
+ .HasColumnType("datetime2");
+
+ b.Property<Guid>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int>("GenderLimit")
+ .HasColumnType("int");
+
+ 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");
+
+ b.Property<decimal>("ServiceFee")
+ .HasColumnType("decimal(18,2)");
+
+ b.Property<int>("SettlementCycle")
+ .HasColumnType("int");
+
+ b.Property<int?>("SettlementStatus")
+ .HasColumnType("int");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<int>("Status")
+ .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.HasIndex("CityCode");
+
+ b.HasIndex("EnterpriseId");
+
+ b.HasIndex("ProvinceCode");
+
+ b.ToTable("TaskInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoBenefit", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("BenefitCode")
+ .IsRequired()
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("BenefitCode");
+
+ b.HasIndex("TaskInfoId");
+
+ b.ToTable("TaskInfoBenefit");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoCredentialLimit", 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")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("TypeCode")
+ .IsRequired()
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("TaskInfoId");
+
+ b.HasIndex("TypeCode");
+
+ b.ToTable("TaskInfoCredentialLimit");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("ArrangeStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("ArrangeTime")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("ContractUrl")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("EnterpriseSignContractStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("EnterpriseSignContractTime")
+ .HasColumnType("datetime2");
+
+ b.Property<int>("HireStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("HireTime")
+ .HasColumnType("datetime2");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ 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?>("UserSignContractStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("UserSignContractTime")
+ .HasColumnType("datetime2");
+
+ b.HasKey("Id");
+
+ b.HasIndex("TaskInfoId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("TaskInfoUser");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.User", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("Age")
+ .HasColumnType("int");
+
+ b.Property<string>("Avatar")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<DateTime?>("Birthday")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("CityCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("ContactPhoneNumber")
+ .HasMaxLength(11)
+ .HasColumnType("nvarchar(11)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("EducationalBackgroundCode")
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<Guid?>("EnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ 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")
+ .HasColumnType("int");
+
+ 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<int?>("RealMethod")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("RealTime")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("Remark")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<int>("Status")
+ .HasColumnType("int");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Type")
+ .HasColumnType("int");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("UserName")
+ .IsRequired()
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<int?>("Weight")
+ .HasColumnType("int");
+
+ b.Property<string>("WorkExperience")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("WorkSeniority")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("WxmpOpenId")
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.HasKey("Id");
+
+ b.HasIndex("CityCode");
+
+ b.HasIndex("EducationalBackgroundCode");
+
+ b.HasIndex("EnterpriseId");
+
+ b.HasIndex("PersonalIdentityCode");
+
+ b.HasIndex("ProvinceCode");
+
+ b.ToTable("User");
+
+ 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,
+ Level = 999,
+ Name = "绠＄悊鍛�",
+ Password = "iEYggKrMhQ3ASUGLobra1w==:fn/DsMJUbD9FGpvBvR3moMpMPptdxzZlourPVhU479I=",
+ Sort = 0,
+ Status = 10,
+ Type = 100,
+ UserName = "system"
+ });
+ });
+
+ 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()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Bank")
+ .IsRequired()
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<string>("Code")
+ .IsRequired()
+ .HasMaxLength(32)
+ .HasColumnType("nvarchar(32)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<string>("PhoneNumber")
+ .IsRequired()
+ .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.Property<Guid>("UserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserBankCard");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserCredential", b =>
+ {
+ b.Property<Guid>("Id")
+ .ValueGeneratedOnAdd()
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("BackImg")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("Code")
+ .HasMaxLength(128)
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<Guid?>("CreatedEnterpriseId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTimeOffset>("CreatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<DateTime>("EndDate")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("Img")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ b.Property<bool>("IsForever")
+ .HasColumnType("bit");
+
+ b.Property<string>("IssueUnit")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<DateTime>("StartDate")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("TraceId")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<string>("TypeCode")
+ .IsRequired()
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<DateTimeOffset?>("UpdatedTime")
+ .HasColumnType("datetimeoffset");
+
+ b.Property<Guid?>("UpdatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("UserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.HasKey("Id");
+
+ b.HasIndex("TypeCode");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserCredential");
+ });
+
+ 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?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<Guid>("DepartmentId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ 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.HasKey("Id");
+
+ b.HasIndex("DepartmentId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserDepartment");
+ });
+
+ 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?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("ExpectJobCode")
+ .IsRequired()
+ .HasColumnType("nvarchar(128)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ 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.HasKey("Id");
+
+ b.HasIndex("ExpectJobCode");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserExpectJob");
+ });
+
+ 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?>("CreatedUserId")
+ .HasColumnType("uniqueidentifier");
+
+ b.Property<string>("Img")
+ .HasColumnType("nvarchar(max)");
+
+ b.Property<bool>("IsDeleted")
+ .HasColumnType("bit");
+
+ 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.HasKey("Id");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserPhoto");
+ });
+
+ 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")
+ .HasColumnType("bit");
+
+ b.Property<Guid>("RoleId")
+ .HasColumnType("uniqueidentifier");
+
+ 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.HasKey("Id");
+
+ b.HasIndex("RoleId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserRole");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserTaskCollect", 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")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ 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.HasKey("Id");
+
+ b.HasIndex("TaskInfoId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserTaskCollect");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Department", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
+ .WithMany("Departments")
+ .HasForeignKey("EnterpriseId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.Department", "Parent")
+ .WithMany("Children")
+ .HasForeignKey("ParentId");
+
+ b.Navigation("Enterprise");
+
+ b.Navigation("Parent");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryCategory", "Category")
+ .WithMany()
+ .HasForeignKey("CategoryId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Parent")
+ .WithMany("Children")
+ .HasForeignKey("ParentId");
+
+ b.Navigation("Category");
+
+ b.Navigation("Parent");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Enterprise", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "City")
+ .WithMany()
+ .HasForeignKey("CityCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ 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("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 =>
+ {
+ b.HasOne("FlexJobApi.Core.Menu", "Parent")
+ .WithMany("Children")
+ .HasForeignKey("ParentId");
+
+ b.Navigation("Parent");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.RoleMenu", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Menu", "Menu")
+ .WithMany()
+ .HasForeignKey("MenuId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.Role", "Role")
+ .WithMany("RoleMenus")
+ .HasForeignKey("RoleId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Menu");
+
+ b.Navigation("Role");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.RoleResource", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Resource", "Resource")
+ .WithMany()
+ .HasForeignKey("ResourceId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.Role", "Role")
+ .WithMany("RoleResources")
+ .HasForeignKey("RoleId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Resource");
+
+ b.Navigation("Role");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "City")
+ .WithMany()
+ .HasForeignKey("CityCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
+ .WithMany()
+ .HasForeignKey("EnterpriseId")
+ .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.DictionaryData", "Benefit")
+ .WithMany()
+ .HasForeignKey("BenefitCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany("Benefits")
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Benefit");
+
+ b.Navigation("TaskInfo");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoCredentialLimit", b =>
+ {
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany("CredentialLimits")
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Type")
+ .WithMany()
+ .HasForeignKey("TypeCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.Navigation("TaskInfo");
+
+ b.Navigation("Type");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b =>
+ {
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany("TaskInfoUsers")
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("TaskInfoUsers")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("TaskInfo");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.User", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "City")
+ .WithMany()
+ .HasForeignKey("CityCode")
+ .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("Users")
+ .HasForeignKey("EnterpriseId");
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "PersonalIdentity")
+ .WithMany()
+ .HasForeignKey("PersonalIdentityCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.HasOne("FlexJobApi.Core.DictionaryData", "Province")
+ .WithMany()
+ .HasForeignKey("ProvinceCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict);
+
+ b.Navigation("City");
+
+ b.Navigation("EducationalBackground");
+
+ b.Navigation("Enterprise");
+
+ b.Navigation("PersonalIdentity");
+
+ b.Navigation("Province");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserAuth", b =>
+ {
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithOne("UserAuth")
+ .HasForeignKey("FlexJobApi.Core.UserAuth", "Id")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("User");
+ });
+
+ 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()
+ .HasForeignKey("TypeCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("UserCredentials")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Type");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserDepartment", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Department", "Department")
+ .WithMany()
+ .HasForeignKey("DepartmentId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("UserDepartments")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Department");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserExpectJob", b =>
+ {
+ b.HasOne("FlexJobApi.Core.DictionaryData", "ExpectJob")
+ .WithMany()
+ .HasForeignKey("ExpectJobCode")
+ .HasPrincipalKey("Code")
+ .OnDelete(DeleteBehavior.Restrict)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("UserExpectJobs")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("ExpectJob");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserPhoto", b =>
+ {
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("Photos")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserRole", b =>
+ {
+ b.HasOne("FlexJobApi.Core.Role", "Role")
+ .WithMany("UserRoles")
+ .HasForeignKey("RoleId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany("UserRoles")
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("Role");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.UserTaskCollect", b =>
+ {
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany()
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany()
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("TaskInfo");
+
+ b.Navigation("User");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Department", b =>
+ {
+ b.Navigation("Children");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.DictionaryData", b =>
+ {
+ b.Navigation("Children");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Enterprise", b =>
+ {
+ b.Navigation("Departments");
+
+ b.Navigation("EnterpriseAuth");
+
+ b.Navigation("Users");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Menu", b =>
+ {
+ b.Navigation("Children");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.Role", b =>
+ {
+ b.Navigation("RoleMenus");
+
+ b.Navigation("RoleResources");
+
+ b.Navigation("UserRoles");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.TaskInfo", b =>
+ {
+ b.Navigation("Benefits");
+
+ b.Navigation("CredentialLimits");
+
+ b.Navigation("TaskInfoUsers");
+ });
+
+ modelBuilder.Entity("FlexJobApi.Core.User", b =>
+ {
+ b.Navigation("BankCards");
+
+ b.Navigation("Photos");
+
+ b.Navigation("TaskInfoUsers");
+
+ b.Navigation("UserAuth");
+
+ b.Navigation("UserCredentials");
+
+ b.Navigation("UserDepartments");
+
+ b.Navigation("UserExpectJobs");
+
+ b.Navigation("UserRoles");
+ });
+#pragma warning restore 612, 618
+ }
+ }
+}
diff --git a/FlexJobApi.Database.Migrations/Migrations/20250812014647_UpdateUser0812.cs b/FlexJobApi.Database.Migrations/Migrations/20250812014647_UpdateUser0812.cs
new file mode 100644
index 0000000..3f29dd8
--- /dev/null
+++ b/FlexJobApi.Database.Migrations/Migrations/20250812014647_UpdateUser0812.cs
@@ -0,0 +1,152 @@
+锘縰sing System;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+#nullable disable
+
+namespace FlexJobApi.Database.Migrations.Migrations
+{
+ /// <inheritdoc />
+ public partial class UpdateUser0812 : Migration
+ {
+ /// <inheritdoc />
+ protected override void Up(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.RenameColumn(
+ name: "SignContractTime",
+ table: "TaskInfoUser",
+ newName: "UserSignContractTime");
+
+ migrationBuilder.RenameColumn(
+ name: "SignContractStatus",
+ table: "TaskInfoUser",
+ newName: "UserSignContractStatus");
+
+ migrationBuilder.AddColumn<DateTime>(
+ name: "RealTime",
+ table: "User",
+ type: "datetime2",
+ nullable: true);
+
+ migrationBuilder.AddColumn<int>(
+ name: "ArrangeStatus",
+ table: "TaskInfoUser",
+ type: "int",
+ nullable: true);
+
+ migrationBuilder.AddColumn<DateTime>(
+ name: "ArrangeTime",
+ table: "TaskInfoUser",
+ type: "datetime2",
+ nullable: true);
+
+ migrationBuilder.AddColumn<string>(
+ name: "ContractUrl",
+ table: "TaskInfoUser",
+ type: "nvarchar(max)",
+ nullable: true);
+
+ migrationBuilder.AddColumn<int>(
+ name: "EnterpriseSignContractStatus",
+ table: "TaskInfoUser",
+ type: "int",
+ nullable: true);
+
+ migrationBuilder.AddColumn<DateTime>(
+ name: "EnterpriseSignContractTime",
+ table: "TaskInfoUser",
+ type: "datetime2",
+ nullable: true);
+
+ migrationBuilder.CreateTable(
+ name: "UserTaskCollect",
+ columns: table => new
+ {
+ Id = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
+ UserId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
+ TaskInfoId = table.Column<Guid>(type: "uniqueidentifier", nullable: false),
+ CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: false),
+ UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true),
+ Sort = table.Column<int>(type: "int", nullable: false),
+ TraceId = table.Column<string>(type: "nvarchar(max)", nullable: true),
+ CreatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
+ CreatedEnterpriseId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
+ UpdatedUserId = table.Column<Guid>(type: "uniqueidentifier", nullable: true),
+ IsDeleted = table.Column<bool>(type: "bit", nullable: false)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_UserTaskCollect", x => x.Id);
+ table.ForeignKey(
+ name: "FK_UserTaskCollect_TaskInfo_TaskInfoId",
+ column: x => x.TaskInfoId,
+ principalTable: "TaskInfo",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Cascade);
+ table.ForeignKey(
+ name: "FK_UserTaskCollect_User_UserId",
+ column: x => x.UserId,
+ principalTable: "User",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Cascade);
+ });
+
+ migrationBuilder.UpdateData(
+ table: "User",
+ keyColumn: "Id",
+ keyValue: new Guid("11111111-1111-1111-1111-111111111111"),
+ column: "RealTime",
+ value: null);
+
+ migrationBuilder.CreateIndex(
+ name: "IX_UserTaskCollect_TaskInfoId",
+ table: "UserTaskCollect",
+ column: "TaskInfoId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_UserTaskCollect_UserId",
+ table: "UserTaskCollect",
+ column: "UserId");
+ }
+
+ /// <inheritdoc />
+ protected override void Down(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropTable(
+ name: "UserTaskCollect");
+
+ migrationBuilder.DropColumn(
+ name: "RealTime",
+ table: "User");
+
+ migrationBuilder.DropColumn(
+ name: "ArrangeStatus",
+ table: "TaskInfoUser");
+
+ migrationBuilder.DropColumn(
+ name: "ArrangeTime",
+ table: "TaskInfoUser");
+
+ migrationBuilder.DropColumn(
+ name: "ContractUrl",
+ table: "TaskInfoUser");
+
+ migrationBuilder.DropColumn(
+ name: "EnterpriseSignContractStatus",
+ table: "TaskInfoUser");
+
+ migrationBuilder.DropColumn(
+ name: "EnterpriseSignContractTime",
+ table: "TaskInfoUser");
+
+ migrationBuilder.RenameColumn(
+ name: "UserSignContractTime",
+ table: "TaskInfoUser",
+ newName: "SignContractTime");
+
+ migrationBuilder.RenameColumn(
+ name: "UserSignContractStatus",
+ table: "TaskInfoUser",
+ newName: "SignContractStatus");
+ }
+ }
+}
diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
index 3503226..70cab4d 100644
--- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
+++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs
@@ -1129,6 +1129,15 @@
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
+ b.Property<int?>("ArrangeStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("ArrangeTime")
+ .HasColumnType("datetime2");
+
+ b.Property<string>("ContractUrl")
+ .HasColumnType("nvarchar(max)");
+
b.Property<Guid?>("CreatedEnterpriseId")
.HasColumnType("uniqueidentifier");
@@ -1138,6 +1147,12 @@
b.Property<Guid?>("CreatedUserId")
.HasColumnType("uniqueidentifier");
+ b.Property<int?>("EnterpriseSignContractStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("EnterpriseSignContractTime")
+ .HasColumnType("datetime2");
+
b.Property<int>("HireStatus")
.HasColumnType("int");
@@ -1146,12 +1161,6 @@
b.Property<bool>("IsDeleted")
.HasColumnType("bit");
-
- b.Property<int?>("SignContractStatus")
- .HasColumnType("int");
-
- b.Property<DateTime?>("SignContractTime")
- .HasColumnType("datetime2");
b.Property<int>("Sort")
.HasColumnType("int");
@@ -1170,6 +1179,12 @@
b.Property<Guid>("UserId")
.HasColumnType("uniqueidentifier");
+
+ b.Property<int?>("UserSignContractStatus")
+ .HasColumnType("int");
+
+ b.Property<DateTime?>("UserSignContractTime")
+ .HasColumnType("datetime2");
b.HasKey("Id");
@@ -1266,6 +1281,9 @@
b.Property<int?>("RealMethod")
.HasColumnType("int");
+
+ b.Property<DateTime?>("RealTime")
+ .HasColumnType("datetime2");
b.Property<string>("Remark")
.HasColumnType("nvarchar(max)");
@@ -1700,6 +1718,51 @@
b.ToTable("UserRole");
});
+ modelBuilder.Entity("FlexJobApi.Core.UserTaskCollect", 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")
+ .HasColumnType("bit");
+
+ b.Property<int>("Sort")
+ .HasColumnType("int");
+
+ b.Property<Guid>("TaskInfoId")
+ .HasColumnType("uniqueidentifier");
+
+ 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.HasKey("Id");
+
+ b.HasIndex("TaskInfoId");
+
+ b.HasIndex("UserId");
+
+ b.ToTable("UserTaskCollect");
+ });
+
modelBuilder.Entity("FlexJobApi.Core.Department", b =>
{
b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise")
@@ -1889,13 +1952,13 @@
modelBuilder.Entity("FlexJobApi.Core.TaskInfoUser", b =>
{
b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
- .WithMany("Users")
+ .WithMany("TaskInfoUsers")
.HasForeignKey("TaskInfoId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("FlexJobApi.Core.User", "User")
- .WithMany()
+ .WithMany("TaskInfoUsers")
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
@@ -2057,6 +2120,25 @@
b.Navigation("User");
});
+ modelBuilder.Entity("FlexJobApi.Core.UserTaskCollect", b =>
+ {
+ b.HasOne("FlexJobApi.Core.TaskInfo", "TaskInfo")
+ .WithMany()
+ .HasForeignKey("TaskInfoId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.HasOne("FlexJobApi.Core.User", "User")
+ .WithMany()
+ .HasForeignKey("UserId")
+ .OnDelete(DeleteBehavior.Cascade)
+ .IsRequired();
+
+ b.Navigation("TaskInfo");
+
+ b.Navigation("User");
+ });
+
modelBuilder.Entity("FlexJobApi.Core.Department", b =>
{
b.Navigation("Children");
@@ -2096,7 +2178,7 @@
b.Navigation("CredentialLimits");
- b.Navigation("Users");
+ b.Navigation("TaskInfoUsers");
});
modelBuilder.Entity("FlexJobApi.Core.User", b =>
@@ -2105,6 +2187,8 @@
b.Navigation("Photos");
+ b.Navigation("TaskInfoUsers");
+
b.Navigation("UserAuth");
b.Navigation("UserCredentials");
diff --git a/FlexJobApi.Database.Migrations/REDEME.MD b/FlexJobApi.Database.Migrations/REDEME.MD
index 374502d..592cc08 100644
--- a/FlexJobApi.Database.Migrations/REDEME.MD
+++ b/FlexJobApi.Database.Migrations/REDEME.MD
@@ -1,7 +1,7 @@
-------------------------------主数据库---------------------------------------
新增迁移文件
-dotnet ef migrations add UpdateUser0811002 -s "../FlexJobApi.Web.Entry" -c DefaultDbContext
+dotnet ef migrations add UpdateUser0812 -s "../FlexJobApi.Web.Entry" -c DefaultDbContext
删除迁移文件
dotnet ef migrations remove -s "../FlexJobApi.Web.Entry" -c DefaultDbContext
--
Gitblit v1.9.1