From fd1d2c1d5f519ddb4667019d6685ff270ad6716b Mon Sep 17 00:00:00 2001 From: sunpengfei <i@angelzzz.com> Date: 星期四, 11 九月 2025 09:49:42 +0800 Subject: [PATCH] feat:开发 --- FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs | 394 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 389 insertions(+), 5 deletions(-) diff --git a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs index 6be3a83..7d883bf 100644 --- a/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs +++ b/FlexJobApi.Database.Migrations/Migrations/DefaultDbContextModelSnapshot.cs @@ -22,6 +22,68 @@ SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder); + modelBuilder.Entity("FlexJobApi.Core.CodeUrl", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + 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?>("ExpiredTime") + .HasColumnType("datetime2"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<string>("ParamValue1") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ParamValue2") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ParamValue3") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ParamValue4") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ParamValue5") + .HasColumnType("nvarchar(max)"); + + b.Property<int>("Scene") + .HasColumnType("int"); + + 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<string>("Url") + .HasColumnType("nvarchar(max)"); + + b.HasKey("Id"); + + b.ToTable("CodeUrl"); + }); + modelBuilder.Entity("FlexJobApi.Core.ContractTemplate", b => { b.Property<Guid>("Id") @@ -1012,6 +1074,15 @@ b.Property<Guid>("EnterpriseId") .HasColumnType("uniqueidentifier"); + b.Property<string>("ErrorCode") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("FailReason") + .HasColumnType("nvarchar(max)"); + + b.Property<decimal>("FreezeBalance") + .HasColumnType("decimal(18,2)"); + b.Property<DateTime?>("InvalidTime") .HasColumnType("datetime2"); @@ -1219,6 +1290,9 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<decimal>("AfterBalance") + .HasColumnType("decimal(18,2)"); + b.Property<decimal>("Amount") .HasColumnType("decimal(18,2)"); @@ -1267,6 +1341,12 @@ b.Property<string>("Link") .HasColumnType("nvarchar(max)"); + b.Property<DateTime?>("OperatorTime") + .HasColumnType("datetime2"); + + b.Property<Guid?>("OperatorUserId") + .HasColumnType("uniqueidentifier"); + b.Property<decimal?>("OrderFee") .HasColumnType("decimal(18,2)"); @@ -1278,6 +1358,15 @@ b.Property<string>("ProductCode") .HasColumnType("nvarchar(max)"); + + b.Property<string>("ReceiveAccount") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ReceiveName") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("ReceiveUserId") + .HasColumnType("uniqueidentifier"); b.Property<string>("ReceiverOpenId") .HasColumnType("nvarchar(max)"); @@ -1299,6 +1388,9 @@ b.Property<string>("SubStatus") .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("TaskUserId") + .HasColumnType("uniqueidentifier"); b.Property<string>("TraceId") .HasColumnType("nvarchar(max)"); @@ -1322,6 +1414,12 @@ .HasColumnType("uniqueidentifier"); b.HasKey("Id"); + + b.HasIndex("OperatorUserId"); + + b.HasIndex("ReceiveUserId"); + + b.HasIndex("TaskUserId"); b.HasIndex("WalletId"); @@ -1833,6 +1931,9 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<decimal?>("ActualSettlementAmount") + .HasColumnType("decimal(18,2)"); + b.Property<string>("AddressDetail") .HasColumnType("nvarchar(max)"); @@ -1915,14 +2016,41 @@ b.Property<decimal>("ServiceFee") .HasColumnType("decimal(18,2)"); + b.Property<decimal?>("SettlementAmount") + .HasColumnType("decimal(18,2)"); + b.Property<int>("SettlementCycle") .HasColumnType("int"); + + b.Property<Guid?>("SettlementOperatorUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("SettlementOrderName") + .HasColumnType("nvarchar(max)"); + + b.Property<int?>("SettlementOrderStatus") + .HasColumnType("int"); + + b.Property<DateTime?>("SettlementOrderTime") + .HasColumnType("datetime2"); + + b.Property<string>("SettlementOrderUrl") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("SettlementRemark") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTime?>("SettlementStartTime") + .HasColumnType("datetime2"); b.Property<int?>("SettlementStatus") .HasColumnType("int"); b.Property<DateTime?>("SettlementTime") .HasColumnType("datetime2"); + + b.Property<int>("SettlementUserCount") + .HasColumnType("int"); b.Property<int>("Sort") .HasColumnType("int"); @@ -1946,6 +2074,8 @@ b.HasIndex("EnterpriseId"); b.HasIndex("ProvinceCode"); + + b.HasIndex("SettlementOperatorUserId"); b.ToTable("TaskInfo"); }); @@ -2048,11 +2178,23 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<decimal>("ActualAmount") + .HasColumnType("decimal(18,2)"); + + b.Property<decimal?>("ActualSettlementAmount") + .HasColumnType("decimal(18,2)"); + b.Property<int?>("ArrangeStatus") .HasColumnType("int"); b.Property<DateTime?>("ArrangeTime") .HasColumnType("datetime2"); + + b.Property<string>("Bank") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("BankBranch") + .HasColumnType("nvarchar(max)"); b.Property<int?>("CheckReceiveStatus") .HasColumnType("int"); @@ -2085,6 +2227,24 @@ .HasColumnType("datetime2"); b.Property<DateTime?>("LastSubmitTime") + .HasColumnType("datetime2"); + + b.Property<string>("ReceiveAccount") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ReceiveName") + .HasColumnType("nvarchar(max)"); + + b.Property<decimal?>("SettlementAmount") + .HasColumnType("decimal(18,2)"); + + b.Property<string>("SettlementRemark") + .HasColumnType("nvarchar(max)"); + + b.Property<int?>("SettlementStatus") + .HasColumnType("int"); + + b.Property<DateTime?>("SettlementTime") .HasColumnType("datetime2"); b.Property<int>("Sort") @@ -2503,13 +2663,16 @@ .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); + b.Property<int>("Access") + .HasColumnType("int"); + b.Property<string>("Bank") - .IsRequired() - .HasMaxLength(128) - .HasColumnType("nvarchar(128)"); + .HasColumnType("nvarchar(max)"); + + b.Property<string>("BankBranch") + .HasColumnType("nvarchar(max)"); b.Property<string>("Code") - .IsRequired() .HasMaxLength(32) .HasColumnType("nvarchar(32)"); @@ -2526,7 +2689,6 @@ .HasColumnType("bit"); b.Property<string>("PhoneNumber") - .IsRequired() .HasMaxLength(11) .HasColumnType("nvarchar(11)"); @@ -2842,6 +3004,164 @@ b.ToTable("UserRole"); }); + modelBuilder.Entity("FlexJobApi.Core.UserWallet", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<decimal>("Balance") + .HasColumnType("decimal(18,2)"); + + 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<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("UserWallet"); + }); + + modelBuilder.Entity("FlexJobApi.Core.UserWalletTransaction", b => + { + b.Property<Guid>("Id") + .ValueGeneratedOnAdd() + .HasColumnType("uniqueidentifier"); + + b.Property<decimal>("ActualAmount") + .HasColumnType("decimal(18,2)"); + + b.Property<decimal>("AfterBalance") + .HasColumnType("decimal(18,2)"); + + b.Property<decimal>("Amount") + .HasColumnType("decimal(18,2)"); + + b.Property<DateTime?>("ArrivalTimeEnd") + .HasColumnType("datetime2"); + + b.Property<decimal>("Balance") + .HasColumnType("decimal(18,2)"); + + 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<string>("EnterpriseName") + .HasColumnType("nvarchar(max)"); + + b.Property<Guid?>("EnterpriseWalletTransactionId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("ErrorCode") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("FailReason") + .HasColumnType("nvarchar(max)"); + + b.Property<bool>("IsDeleted") + .HasColumnType("bit"); + + b.Property<DateTime?>("OperatorTime") + .HasColumnType("datetime2"); + + b.Property<Guid?>("OperatorUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("ReceiveAccount") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("ReceiveName") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("Remark") + .HasColumnType("nvarchar(max)"); + + b.Property<decimal>("ServiceFee") + .HasColumnType("decimal(18,2)"); + + b.Property<decimal?>("SettlementAmount") + .HasColumnType("decimal(18,2)"); + + b.Property<DateTime?>("SettlementTime") + .HasColumnType("datetime2"); + + b.Property<int>("Sort") + .HasColumnType("int"); + + b.Property<Guid?>("TaskUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<string>("Title") + .HasColumnType("nvarchar(max)"); + + b.Property<string>("TraceId") + .HasColumnType("nvarchar(max)"); + + b.Property<DateTime?>("TransDate") + .HasColumnType("datetime2"); + + b.Property<int>("TransactionStatus") + .HasColumnType("int"); + + b.Property<int>("Type") + .HasColumnType("int"); + + b.Property<DateTimeOffset?>("UpdatedTime") + .HasColumnType("datetimeoffset"); + + b.Property<Guid?>("UpdatedUserId") + .HasColumnType("uniqueidentifier"); + + b.Property<Guid>("WalletId") + .HasColumnType("uniqueidentifier"); + + b.HasKey("Id"); + + b.HasIndex("EnterpriseWalletTransactionId"); + + b.HasIndex("OperatorUserId"); + + b.HasIndex("TaskUserId"); + + b.HasIndex("WalletId"); + + b.ToTable("UserWalletTransaction"); + }); + modelBuilder.Entity("FlexJobApi.Core.ContractTemplate", b => { b.HasOne("FlexJobApi.Core.Enterprise", "Enterprise") @@ -3058,11 +3378,29 @@ modelBuilder.Entity("FlexJobApi.Core.EnterpriseWalletTransaction", b => { + b.HasOne("FlexJobApi.Core.User", "OperatorUser") + .WithMany() + .HasForeignKey("OperatorUserId"); + + b.HasOne("FlexJobApi.Core.User", "ReceiveUser") + .WithMany() + .HasForeignKey("ReceiveUserId"); + + b.HasOne("FlexJobApi.Core.TaskInfoUser", "TaskUser") + .WithMany() + .HasForeignKey("TaskUserId"); + b.HasOne("FlexJobApi.Core.EnterpriseWallet", "Wallet") .WithMany() .HasForeignKey("WalletId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); + + b.Navigation("OperatorUser"); + + b.Navigation("ReceiveUser"); + + b.Navigation("TaskUser"); b.Navigation("Wallet"); }); @@ -3134,11 +3472,17 @@ .HasPrincipalKey("Code") .OnDelete(DeleteBehavior.Restrict); + b.HasOne("FlexJobApi.Core.User", "SettlementOperatorUser") + .WithMany() + .HasForeignKey("SettlementOperatorUserId"); + b.Navigation("City"); b.Navigation("Enterprise"); b.Navigation("Province"); + + b.Navigation("SettlementOperatorUser"); }); modelBuilder.Entity("FlexJobApi.Core.TaskInfoBenefit", b => @@ -3404,6 +3748,46 @@ b.Navigation("User"); }); + modelBuilder.Entity("FlexJobApi.Core.UserWallet", b => + { + b.HasOne("FlexJobApi.Core.User", "User") + .WithMany() + .HasForeignKey("UserId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("User"); + }); + + modelBuilder.Entity("FlexJobApi.Core.UserWalletTransaction", b => + { + b.HasOne("FlexJobApi.Core.EnterpriseWalletTransaction", "EnterpriseWalletTransaction") + .WithMany() + .HasForeignKey("EnterpriseWalletTransactionId"); + + b.HasOne("FlexJobApi.Core.User", "OperatorUser") + .WithMany() + .HasForeignKey("OperatorUserId"); + + b.HasOne("FlexJobApi.Core.TaskInfoUser", "TaskUser") + .WithMany() + .HasForeignKey("TaskUserId"); + + b.HasOne("FlexJobApi.Core.UserWallet", "Wallet") + .WithMany() + .HasForeignKey("WalletId") + .OnDelete(DeleteBehavior.Cascade) + .IsRequired(); + + b.Navigation("EnterpriseWalletTransaction"); + + b.Navigation("OperatorUser"); + + b.Navigation("TaskUser"); + + b.Navigation("Wallet"); + }); + modelBuilder.Entity("FlexJobApi.Core.ContractTemplate", b => { b.Navigation("Values"); -- Gitblit v1.9.1