pref:优化

sunpengfei

2025-08-08 53ee0a68605433db362abae3ed1af03fd23a7832

 FlexJobApi.Database.Migrations/Migrations/LogDb/LogDbContextModelSnapshot.cs

@@ -29,58 +29,52 @@
                        .HasColumnType("uniqueidentifier");

                    b.Property<int>("Access")
                        .HasColumnType("int")
                        .HasComment("通道");
                        .HasColumnType("int");

                    b.Property<string>("ClientIpAddress")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("客户IP地址");
                        .HasColumnType("nvarchar(32)");

                    b.Property<string>("Content")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("内容");
                        .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<bool>("IsDeleted")
                        .HasColumnType("bit");

                    b.Property<int>("Level")
                        .HasColumnType("int")
                        .HasComment("级别");
                        .HasColumnType("int");

                    b.Property<int>("Sort")
                        .HasColumnType("int");

                    b.Property<string>("StackTrace")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("堆栈跟踪");
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("UpdateUserInfoId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("UpdatedUserId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("Url")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("链接地址");
                        .HasColumnType("nvarchar(max)");

                    b.HasKey("Id");

                    b.ToTable("ConsoleLog", t =>
                        {
                            t.HasComment("控制台日志");
                        });
                    b.ToTable("ConsoleLog");
                });

            modelBuilder.Entity("FlexJobApi.Core.DbAuditLog", b =>
@@ -89,30 +83,29 @@
                        .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")
                        .HasColumnType("bit");

                    b.Property<string>("NewValues")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("新值");
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("OldValues")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("旧值");
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("Operate")
                        .HasColumnType("int")
                        .HasComment("操作");
                        .HasColumnType("int");

                    b.Property<Guid>("PrimaryKey")
                        .HasColumnType("uniqueidentifier")
                        .HasComment("主键");
                        .HasColumnType("uniqueidentifier");

                    b.Property<int>("Sort")
                        .HasColumnType("int");
@@ -120,70 +113,72 @@
                    b.Property<string>("TableName")
                        .IsRequired()
                        .HasMaxLength(128)
                        .HasColumnType("nvarchar(128)")
                        .HasComment("表名");
                        .HasColumnType("nvarchar(128)");

                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("UpdateUserInfoId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("UpdatedUserId")
                        .HasColumnType("uniqueidentifier");

                    b.HasKey("Id");

                    b.ToTable("DbAuditLog", t =>
                        {
                            t.HasComment("数据库审计日志");
                        });
                    b.ToTable("DbAuditLog");
                });

            modelBuilder.Entity("FlexJobApi.Core.Entities.Common.WebApiLog", b =>
            modelBuilder.Entity("FlexJobApi.Core.Entities.Common.ResourceLog", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<string>("Callback")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("回调数据");

                    b.Property<string>("ClientIpAddress")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("客户端IP地址");
                        .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<long>("ElapsedMilliseconds")
                        .HasColumnType("bigint")
                        .HasComment("耗时毫秒数");
                    b.Property<string>("Domain")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Headers")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("请求头");
                    b.Property<long>("ElapsedMilliseconds")
                        .HasColumnType("bigint");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit");

                    b.Property<bool>("IsSuccess")
                        .HasColumnType("bit")
                        .HasComment("是否成功");
                        .HasColumnType("bit");

                    b.Property<string>("Method")
                        .IsRequired()
                        .HasMaxLength(6)
                        .HasColumnType("nvarchar(6)")
                        .HasComment("请求方式");
                    b.Property<int>("Method")
                        .HasColumnType("int");

                    b.Property<string>("Path")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("RefererUrl")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Request")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("请求参数");
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("RequestHeaders")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Response")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ResponseHeaders")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("Sort")
                        .HasColumnType("int");
@@ -191,23 +186,15 @@
                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("UpdateUserInfoId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<string>("Url")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("链接地址");
                    b.Property<Guid?>("UpdatedUserId")
                        .HasColumnType("uniqueidentifier");

                    b.HasKey("Id");

                    b.ToTable("WebApiLog", t =>
                        {
                            t.HasComment("接口日志");
                        });
                    b.ToTable("ResourceLog");
                });

            modelBuilder.Entity("FlexJobApi.Core.ExceptionLog", b =>
@@ -218,49 +205,45 @@

                    b.Property<string>("Code")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)")
                        .HasComment("代码");
                        .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")
                        .HasColumnType("bit");

                    b.Property<string>("Message")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("消息");
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("Sort")
                        .HasColumnType("int");

                    b.Property<string>("StackTrace")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("堆栈跟踪");
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Type")
                        .HasMaxLength(256)
                        .HasColumnType("nvarchar(256)")
                        .HasComment("类型");

                    b.Property<Guid?>("UpdateUserInfoId")
                        .HasColumnType("uniqueidentifier");
                        .HasColumnType("nvarchar(256)");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("UpdatedUserId")
                        .HasColumnType("uniqueidentifier");

                    b.HasKey("Id");

                    b.ToTable("ExceptionLog", t =>
                        {
                            t.HasComment("异常日志");
                        });
                    b.ToTable("ExceptionLog");
                });

            modelBuilder.Entity("FlexJobApi.Core.QueueLog", b =>
@@ -270,33 +253,31 @@
                        .HasColumnType("uniqueidentifier");

                    b.Property<int>("Access")
                        .HasColumnType("int")
                        .HasComment("通道");
                        .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<string>("Data")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)")
                        .HasComment("数据");
                        .HasColumnType("nvarchar(max)");

                    b.Property<long>("ElapsedMilliseconds")
                        .HasColumnType("bigint")
                        .HasComment("耗时毫秒数");
                        .HasColumnType("bigint");

                    b.Property<string>("EventId")
                        .IsRequired()
                        .HasMaxLength(128)
                        .HasColumnType("nvarchar(128)")
                        .HasComment("事件Id");
                        .HasColumnType("nvarchar(128)");

                    b.Property<bool>("IsConsumOnce")
                        .HasColumnType("bit")
                        .HasComment("消息是否只消费一次");
                        .HasColumnType("bit");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit");
@@ -307,18 +288,15 @@
                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("UpdateUserInfoId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("UpdatedUserId")
                        .HasColumnType("uniqueidentifier");

                    b.HasKey("Id");

                    b.ToTable("QueueLog", t =>
                        {
                            t.HasComment("消息队列日志");
                        });
                    b.ToTable("QueueLog");
                });

            modelBuilder.Entity("FlexJobApi.Core.SmsLog", b =>
@@ -328,31 +306,30 @@
                        .HasColumnType("uniqueidentifier");

                    b.Property<int>("Access")
                        .HasColumnType("int")
                        .HasComment("通道");
                        .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<DateTime?>("Expiry")
                        .HasColumnType("datetime2")
                        .HasComment("有效期");
                        .HasColumnType("datetime2");

                    b.Property<bool>("IsDeleted")
                        .HasColumnType("bit");

                    b.Property<bool>("IsUsed")
                        .HasColumnType("bit")
                        .HasComment("是否使用");
                        .HasColumnType("bit");

                    b.Property<string>("PhoneNumber")
                        .IsRequired()
                        .HasMaxLength(11)
                        .HasColumnType("nvarchar(11)")
                        .HasComment("手机号码");
                        .HasColumnType("nvarchar(11)");

                    b.Property<int>("Sort")
                        .HasColumnType("int");
@@ -360,28 +337,23 @@
                    b.Property<string>("TemplateCode")
                        .IsRequired()
                        .HasMaxLength(128)
                        .HasColumnType("nvarchar(128)")
                        .HasComment("模板代码");
                        .HasColumnType("nvarchar(128)");

                    b.Property<string>("TemplateParam")
                        .HasColumnType("nvarchar(max)")
                        .HasComment("模板参数");
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("TraceId")
                        .HasColumnType("nvarchar(max)");

                    b.Property<Guid?>("UpdateUserInfoId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<DateTimeOffset?>("UpdatedTime")
                        .HasColumnType("datetimeoffset");

                    b.Property<Guid?>("UpdatedUserId")
                        .HasColumnType("uniqueidentifier");

                    b.HasKey("Id");

                    b.ToTable("SmsLog", t =>
                        {
                            t.HasComment("短信日志");
                        });
                    b.ToTable("SmsLog");
                });
#pragma warning restore 612, 618
        }