using System;
using System.Collections.Generic;
using Microsoft.EntityFrameworkCore;

namespace MySQLAccess.PGModels;

public partial class PostgresContext : DbContext
{
    public PostgresContext()
    {
    }

    public PostgresContext(DbContextOptions<PostgresContext> options)
        : base(options)
    {
    }

    public virtual DbSet<DeviceAlertDatum> DeviceAlertData { get; set; }

    public virtual DbSet<DeviceRegisterDatum> DeviceRegisterData { get; set; }

    public virtual DbSet<DeviceStatus> DeviceStatuses { get; set; }

    public virtual DbSet<Deviceinfo> Deviceinfos { get; set; }

    public virtual DbSet<EmqxLogininfo> EmqxLogininfos { get; set; }

    public virtual DbSet<MachineType> MachineTypes { get; set; }

    public virtual DbSet<MachineTypeFun> MachineTypeFuns { get; set; }

    public virtual DbSet<MqttMonitorDatum> MqttMonitorData { get; set; }

    public virtual DbSet<RoleFunMapping> RoleFunMappings { get; set; }

    public virtual DbSet<Roleinfo> Roleinfos { get; set; }

    public virtual DbSet<TcpCloseDatum> TcpCloseData { get; set; }

    public virtual DbSet<TcpConnDatum> TcpConnData { get; set; }

    public virtual DbSet<TcpHeartbeatDatum> TcpHeartbeatData { get; set; }

    public virtual DbSet<TcpReceiveDatum> TcpReceiveData { get; set; }

    public virtual DbSet<TcpSendDatum> TcpSendData { get; set; }

    public virtual DbSet<TcpUserDevOperationLog> TcpUserDevOperationLogs { get; set; }

    public virtual DbSet<Userinfo> Userinfos { get; set; }

//    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
//#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see https://go.microsoft.com/fwlink/?LinkId=723263.
//        => optionsBuilder.UseNpgsql("Server=122.152.232.170;Database=postgres;user id=postgres;password=t3414T\"7wCU.&15]*QFu%_4CDhJI7g2b;port=65433;");

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<DeviceAlertDatum>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("device_alert_data_pkey");

            entity.ToTable("device_alert_data");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.ClientId)
                .HasComment("客户端ID，关联deviceinfo表")
                .HasColumnName("ClientID");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp without time zone");
            entity.Property(e => e.EndPoint)
                .HasMaxLength(64)
                .HasComment("设备端点地址");
            entity.Property(e => e.RealAddress)
                .HasMaxLength(255)
                .HasComment("设备真实地址");
            entity.Property(e => e.Value).HasComment("告警数据值（二进制格式）");
        });

        modelBuilder.Entity<DeviceRegisterDatum>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("device_register_data_pkey");

            entity.ToTable("device_register_data");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.ClientId)
                .HasComment("客户端ID")
                .HasColumnName("ClientID");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp without time zone");
            entity.Property(e => e.DeviceClassId)
                .HasMaxLength(16)
                .HasComment("设备分类ID")
                .HasColumnName("DeviceClassID");
            entity.Property(e => e.EndPoint)
                .HasMaxLength(64)
                .HasComment("设备端点地址");
            entity.Property(e => e.MachineTypeId)
                .HasMaxLength(32)
                .HasComment("机型ID")
                .HasColumnName("MachineTypeID");
            entity.Property(e => e.McuhardVersion)
                .HasMaxLength(16)
                .HasComment("MCU硬件版本")
                .HasColumnName("MCUHardVersion");
            entity.Property(e => e.McusoftVersion)
                .HasMaxLength(16)
                .HasComment("MCU软件版本")
                .HasColumnName("MCUSoftVersion");
            entity.Property(e => e.Mcuuuid)
                .HasMaxLength(64)
                .HasComment("MCU唯一标识")
                .HasColumnName("MCUUUID");
            entity.Property(e => e.Pid)
                .HasMaxLength(32)
                .HasComment("产品ID")
                .HasColumnName("PID");
            entity.Property(e => e.ReStartReason)
                .HasMaxLength(16)
                .HasComment("重启原因");
            entity.Property(e => e.RealAddress)
                .HasMaxLength(255)
                .HasComment("设备真实地址");
        });

        modelBuilder.Entity<DeviceStatus>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("device_status_pkey");

            entity.ToTable("device_status");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasIdentityOptions(null, null, null, null, true, null)
                .HasColumnName("ID");
            entity.Property(e => e.DeviceId)
                .HasComment("设备ID")
                .HasColumnName("DeviceID");
            entity.Property(e => e.EndPoint)
                .HasMaxLength(64)
                .HasComment("设备端点地址");
            entity.Property(e => e.Status)
                .HasMaxLength(64)
                .HasComment("设备状态");
            entity.Property(e => e.UpdateTime)
                .HasComment("更新时间")
                .HasColumnType("timestamp without time zone");
            entity.Property(e => e.UpdateTimeUnix)
                .HasComment("更新时间（Unix时间戳）")
                .HasColumnName("UpdateTime_Unix");
        });

        modelBuilder.Entity<Deviceinfo>(entity =>
        {
            entity.HasKey(e => e.ClientId).HasName("deviceinfo_pkey");

            entity.ToTable("deviceinfo");

            entity.Property(e => e.ClientId).HasComment("客户端ID（主键）");
            entity.Property(e => e.Brandld).HasComment("厂牌ID");
            entity.Property(e => e.ClientStatus).HasComment("客户端状态（0未使用，1已分配，2已激活，3已注销）");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.CreateTimeUnix).HasComment("创建时间（Unix时间戳）");
            entity.Property(e => e.DeviceName)
                .HasMaxLength(255)
                .HasComment("设备名称");
            entity.Property(e => e.ExcelBatchFlag).HasComment("Excel批次标记");
            entity.Property(e => e.ExcelFileName)
                .HasMaxLength(255)
                .HasComment("Excel文件名");
            entity.Property(e => e.HotelCode).HasComment("酒店代码");
            entity.Property(e => e.IsDelete)
                .HasDefaultValue(false)
                .HasComment("是否删除标记");
            entity.Property(e => e.MachineType)
                .HasComment("机型类型")
                .HasColumnName("Machine_Type");
            entity.Property(e => e.McuUuid)
                .HasMaxLength(255)
                .HasComment("设备UUID")
                .HasColumnName("MCU_UUID");
            entity.Property(e => e.OrderNo)
                .HasMaxLength(255)
                .HasComment("订单号");
            entity.Property(e => e.ProductId).HasComment("ProductID");
            entity.Property(e => e.Remark).HasComment("备注信息");
            entity.Property(e => e.SecretKey)
                .HasMaxLength(255)
                .HasComment("设备密钥");
            entity.Property(e => e.UpdateTime)
                .HasComment("更新时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.UpdateTimeUnix).HasComment("更新时间（Unix时间戳）");
            entity.Property(e => e.Uuid)
                .HasMaxLength(64)
                .HasComment("设备唯一标识")
                .HasColumnName("UUID");
        });

        modelBuilder.Entity<EmqxLogininfo>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("emqx_logininfo_pkey");

            entity.ToTable("emqx_logininfo");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.CreateTimeUnix).HasComment("创建时间（Unix时间戳）");
            entity.Property(e => e.DeviceUuid)
                .HasMaxLength(64)
                .HasComment("设备UUID")
                .HasColumnName("DeviceUUID");
            entity.Property(e => e.PassWord)
                .HasMaxLength(255)
                .HasComment("密码");
            entity.Property(e => e.UpdateTime)
                .HasComment("更新时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.UpdateTimeUnix).HasComment("更新时间（Unix时间戳）");
            entity.Property(e => e.UserName)
                .HasMaxLength(255)
                .HasComment("用户名");
        });

        modelBuilder.Entity<MachineType>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("machine_type_pkey");

            entity.ToTable("machine_type");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.ConnTypeName)
                .HasMaxLength(255)
                .HasComment("连接方式名称");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.DeviceClass)
                .HasMaxLength(255)
                .HasComment("设备分类");
            entity.Property(e => e.DeviceInfo).HasComment("设备信息描述");
            entity.Property(e => e.DeviceTypeName)
                .HasMaxLength(255)
                .HasComment("设备类型名称");
            entity.Property(e => e.Image).HasComment("设备图片");
            entity.Property(e => e.IsDelete)
                .HasDefaultValue(false)
                .HasComment("是否删除标记");
            entity.Property(e => e.ProductId).HasComment("产品ID");
            entity.Property(e => e.UpdateTime)
                .HasComment("更新时间")
                .HasColumnType("timestamp(6) without time zone");
        });

        modelBuilder.Entity<MachineTypeFun>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("device_fun_pkey");

            entity.ToTable("machine_type_fun");

            entity.Property(e => e.Id).HasComment("主键ID");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.FunctionName)
                .HasMaxLength(255)
                .HasComment("功能名称");
            entity.Property(e => e.IsDelete)
                .HasDefaultValue(false)
                .HasComment("是否删除标记");
            entity.Property(e => e.MachineTypeId).HasComment("机型类型ID");
        });

        modelBuilder.Entity<MqttMonitorDatum>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("mqtt_monitor_data_pkey");

            entity.ToTable("mqtt_monitor_data");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("id");
            entity.Property(e => e.Createtime)
                .HasComment("创建时间（Unix时间戳）")
                .HasColumnName("createtime");
            entity.Property(e => e.CreatetimeD)
                .HasComment("创建时间（日期时间格式）")
                .HasColumnType("timestamp(6) without time zone")
                .HasColumnName("createtime_d");
            entity.Property(e => e.Payload)
                .HasComment("MQTT消息负载")
                .HasColumnName("payload");
            entity.Property(e => e.Topic)
                .HasMaxLength(255)
                .HasComment("MQTT主题")
                .HasColumnName("topic");
        });

        modelBuilder.Entity<RoleFunMapping>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("role_fun_mapping_pkey");

            entity.ToTable("role_fun_mapping");

            entity.Property(e => e.Id).HasComment("主键ID");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.DeviceFunId).HasComment("设备功能ID");
            entity.Property(e => e.IsDelete)
                .HasDefaultValue(false)
                .HasComment("是否删除标记");
            entity.Property(e => e.RoleId).HasComment("角色ID");
        });

        modelBuilder.Entity<Roleinfo>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("roleinfo_pkey");

            entity.ToTable("roleinfo");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.DeviceLicense)
                .HasMaxLength(255)
                .HasComment("设备权限");
            entity.Property(e => e.IsDelete)
                .HasDefaultValue(false)
                .HasComment("是否删除标记");
            entity.Property(e => e.Permission)
                .HasMaxLength(255)
                .HasComment("页面权限");
            entity.Property(e => e.Rolename)
                .HasMaxLength(255)
                .HasComment("角色名称");
            entity.Property(e => e.UpdateTime)
                .HasComment("更新时间")
                .HasColumnType("timestamp(6) without time zone");
        });

        modelBuilder.Entity<TcpCloseDatum>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("tcp_close_data_pkey");

            entity.ToTable("tcp_close_data");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.ClientId)
                .HasComment("客户端ID")
                .HasColumnName("ClientID");
            entity.Property(e => e.CloseReason)
                .HasMaxLength(255)
                .HasComment("关闭原因")
                .HasColumnName("Close_Reason");
            entity.Property(e => e.CreatetimeUnix)
                .HasComment("创建时间（Unix时间戳）")
                .HasColumnName("Createtime_Unix");
            entity.Property(e => e.DataTakeOutTime)
                .HasComment("数据提取时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.RealAddress)
                .HasMaxLength(255)
                .HasComment("真实地址");
            entity.Property(e => e.WwwIp)
                .HasMaxLength(255)
                .HasComment("服务器IP地址")
                .HasColumnName("WWW_IP");
            entity.Property(e => e.WwwPort)
                .HasComment("服务器端口")
                .HasColumnName("WWW_Port");
        });

        modelBuilder.Entity<TcpConnDatum>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("tcp_conn_data_pkey");

            entity.ToTable("tcp_conn_data");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.ClientId)
                .HasComment("客户端ID")
                .HasColumnName("ClientID");
            entity.Property(e => e.ConnectTime)
                .HasComment("连接时间")
                .HasColumnType("timestamp without time zone");
            entity.Property(e => e.ConnectTimeUnix)
                .HasComment("连接时间（Unix时间戳）")
                .HasColumnName("ConnectTime_Unix");
            entity.Property(e => e.RealAddress)
                .HasMaxLength(255)
                .HasComment("真实地址");
            entity.Property(e => e.WwwIp)
                .HasMaxLength(255)
                .HasComment("服务器IP地址")
                .HasColumnName("WWW_IP");
            entity.Property(e => e.WwwPort)
                .HasComment("服务器端口")
                .HasColumnName("WWW_Port");
        });

        modelBuilder.Entity<TcpHeartbeatDatum>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("tcp_heartbeat_data_pkey");

            entity.ToTable("tcp_heartbeat_data");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.AdcOriginalValuue)
                .HasMaxLength(32)
                .HasComment("ADC原始值")
                .HasColumnName("adc_original_valuue");
            entity.Property(e => e.AnyHuman)
                .HasMaxLength(255)
                .HasComment("是否有人");
            entity.Property(e => e.BgValue)
                .HasMaxLength(255)
                .HasComment("背景值")
                .HasColumnName("Bg_Value");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.DeviceId)
                .HasMaxLength(255)
                .HasComment("设备ID");
            entity.Property(e => e.DiffValue)
                .HasMaxLength(255)
                .HasComment("差值")
                .HasColumnName("Diff_Value");
            entity.Property(e => e.EnvValue)
                .HasMaxLength(255)
                .HasComment("环境值")
                .HasColumnName("Env_Value");
            entity.Property(e => e.ErrorCode)
                .HasMaxLength(32)
                .HasComment("错误代码")
                .HasColumnName("error_code");
            entity.Property(e => e.GuZhangCheck)
                .HasMaxLength(255)
                .HasComment("故障检查")
                .HasColumnName("GuZhang_Check");
            entity.Property(e => e.Humidity)
                .HasMaxLength(255)
                .HasComment("湿度");
            entity.Property(e => e.McuT)
                .HasMaxLength(255)
                .HasComment("MCU温度")
                .HasColumnName("MCU_T");
            entity.Property(e => e.NongDuBaiFenBi)
                .HasMaxLength(255)
                .HasComment("浓度百分比")
                .HasColumnName("NongDu_BaiFenBi");
            entity.Property(e => e.OriginalDataId)
                .HasComment("原始数据ID")
                .HasColumnName("OriginalDataID");
            entity.Property(e => e.RealTimeValue)
                .HasMaxLength(255)
                .HasComment("实时值")
                .HasColumnName("RealTime_Value");
            entity.Property(e => e.StableStatus)
                .HasMaxLength(255)
                .HasComment("稳定状态")
                .HasColumnName("Stable_Status");
            entity.Property(e => e.Temperature)
                .HasMaxLength(255)
                .HasComment("温度");
            entity.Property(e => e.ThresholdValue1)
                .HasMaxLength(255)
                .HasComment("阈值1")
                .HasColumnName("Threshold_Value1");
            entity.Property(e => e.ThresholdValue2)
                .HasMaxLength(255)
                .HasComment("阈值2")
                .HasColumnName("Threshold_Value2");
            entity.Property(e => e.WorkStatus)
                .HasMaxLength(255)
                .HasComment("工作状态")
                .HasColumnName("Work_Status");
        });

        modelBuilder.Entity<TcpReceiveDatum>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("tcp_receive_data_pkey");

            entity.ToTable("tcp_receive_data");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.ClientId)
                .HasComment("客户端ID")
                .HasColumnName("ClientID");
            entity.Property(e => e.CommandType).HasComment("命令类型");
            entity.Property(e => e.DencryptData).HasComment("解密后数据");
            entity.Property(e => e.EndPoint)
                .HasMaxLength(255)
                .HasComment("端点地址");
            entity.Property(e => e.InsertDate)
                .HasComment("插入日期")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.InsertUnix).HasComment("插入时间（Unix时间戳）");
            entity.Property(e => e.OriginalData).HasComment("原始数据");
        });

        modelBuilder.Entity<TcpSendDatum>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("tcp_send_data_pkey");

            entity.ToTable("tcp_send_data");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasIdentityOptions(null, null, null, null, true, null)
                .HasColumnName("ID");
            entity.Property(e => e.ClientId)
                .HasComment("客户端ID")
                .HasColumnName("ClientID");
            entity.Property(e => e.CommandType)
                .HasMaxLength(16)
                .HasComment("命令类型");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp without time zone");
            entity.Property(e => e.CreateTimeUnix)
                .HasComment("创建时间（Unix时间戳）")
                .HasColumnName("CreateTime_Unix");
            entity.Property(e => e.SendData).HasComment("发送数据");
        });

        modelBuilder.Entity<TcpUserDevOperationLog>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("tcp_user_dev_operation_log_pkey");

            entity.ToTable("tcp_user_dev_operation_log");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasIdentityOptions(null, null, null, null, true, null)
                .HasColumnName("ID");
            entity.Property(e => e.Action).HasComment("操作动作");
            entity.Property(e => e.ClientId)
                .HasComment("客户端ID")
                .HasColumnName("ClientID");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp without time zone");
            entity.Property(e => e.Remark).HasComment("备注信息");
            entity.Property(e => e.UserId)
                .HasComment("用户ID")
                .HasColumnName("User_ID");
            entity.Property(e => e.UserIp)
                .HasMaxLength(255)
                .HasComment("用户IP地址")
                .HasColumnName("User_IP");
            entity.Property(e => e.UserLocation)
                .HasMaxLength(255)
                .HasComment("用户位置")
                .HasColumnName("User_Location");
            entity.Property(e => e.UserSystem)
                .HasMaxLength(255)
                .HasComment("用户系统信息")
                .HasColumnName("User_System");
        });

        modelBuilder.Entity<Userinfo>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("userinfo_pkey");

            entity.ToTable("userinfo");

            entity.Property(e => e.Id)
                .HasComment("主键ID")
                .HasColumnName("ID");
            entity.Property(e => e.CompanyName)
                .HasMaxLength(255)
                .HasComment("公司名称");
            entity.Property(e => e.CreateTime)
                .HasComment("创建时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.IsDelete)
                .HasDefaultValue(false)
                .HasComment("是否删除标记");
            entity.Property(e => e.Mobile)
                .HasMaxLength(255)
                .HasComment("手机号码");
            entity.Property(e => e.PassWord)
                .HasMaxLength(255)
                .HasComment("密码");
            entity.Property(e => e.Permission)
                .HasMaxLength(255)
                .HasComment("权限信息");
            entity.Property(e => e.PswEncryption)
                .HasMaxLength(255)
                .HasComment("密码加密密钥");
            entity.Property(e => e.RealName)
                .HasMaxLength(255)
                .HasComment("真实姓名");
            entity.Property(e => e.RoleId).HasComment("角色ID");
            entity.Property(e => e.UpdateTime)
                .HasComment("更新时间")
                .HasColumnType("timestamp(6) without time zone");
            entity.Property(e => e.UserName)
                .HasMaxLength(255)
                .HasComment("用户名");
        });

        OnModelCreatingPartial(modelBuilder);
    }

    partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
}