using System; using System.Collections.Generic; using Microsoft.EntityFrameworkCore; using Pomelo.EntityFrameworkCore.MySql.Scaffolding.Internal; namespace SupplierManager.Models; public partial class AgentApprovalSystemContext : DbContext { public AgentApprovalSystemContext() { } public AgentApprovalSystemContext(DbContextOptions options) : base(options) { } public virtual DbSet AasCompanyInfos { get; set; } public virtual DbSet AasCustomerInfos { get; set; } public virtual DbSet AasProjectInfos { get; set; } public virtual DbSet AasProjectReportReadies { get; set; } public virtual DbSet AasProjectShenpis { get; set; } public virtual DbSet AasUsers { get; set; } public virtual DbSet AasUserPermissions { get; set; } public virtual DbSet AasUsersOperateLogs { get; set; } public virtual DbSet Autokeygeneraters { get; set; } public virtual DbSet WyLogs { get; set; } public virtual DbSet WyUsers { 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.UseMySql("server=blv-cloud-db.mysql.rds.aliyuncs.com;database=agent_approval_system;uid=blv_rcu;pwd=fnadiaJDIJ7546;charset=utf8;port=3307", Microsoft.EntityFrameworkCore.ServerVersion.Parse("8.0.28-mysql")); protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder .UseCollation("utf8mb4_bin") .HasCharSet("utf8mb4"); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("aas_company_info"); entity.Property(e => e.Id).HasColumnName("id"); entity.Property(e => e.Code) .HasMaxLength(255) .HasComment("公司代码") .HasColumnName("code"); entity.Property(e => e.Createtime) .HasColumnType("datetime") .HasColumnName("createtime"); entity.Property(e => e.Identity) .HasMaxLength(255) .HasComment("身份") .HasColumnName("identity"); entity.Property(e => e.Industry) .HasMaxLength(255) .HasComment("所属行业") .HasColumnName("industry"); entity.Property(e => e.LicenseCode) .HasMaxLength(255) .HasComment("营业执照") .HasColumnName("licenseCode"); entity.Property(e => e.Logoaddress) .HasComment("logo地址") .HasColumnType("text") .HasColumnName("logoaddress"); entity.Property(e => e.NameCn) .HasMaxLength(255) .HasComment("中文名") .HasColumnName("nameCn"); entity.Property(e => e.NameEn) .HasMaxLength(255) .HasComment("英文名") .HasColumnName("nameEn"); entity.Property(e => e.Region) .HasMaxLength(255) .HasColumnName("region"); entity.Property(e => e.Updatetime) .HasColumnType("datetime") .HasColumnName("updatetime"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("aas_customer_info"); entity.Property(e => e.Id) .ValueGeneratedNever() .HasColumnName("id"); entity.Property(e => e.ComName) .HasMaxLength(255) .HasColumnName("com_name"); entity.Property(e => e.Job) .HasMaxLength(255) .HasColumnName("job"); entity.Property(e => e.Mark) .HasColumnType("text") .HasColumnName("mark"); entity.Property(e => e.Mobile) .HasMaxLength(255) .HasColumnName("mobile"); entity.Property(e => e.Realname) .HasMaxLength(255) .HasColumnName("realname"); entity.Property(e => e.Weixin) .HasMaxLength(255) .HasColumnName("weixin"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("aas_project_info"); entity.HasIndex(e => e.UpdatetimeUnix, "Unixupdatetime"); entity.HasIndex(e => e.CompanyId, "comid"); entity.Property(e => e.Id).HasColumnName("id"); entity.Property(e => e.AddressDetail) .HasMaxLength(255) .HasComment("详细地址") .HasColumnName("address_detail"); entity.Property(e => e.Blueprint) .HasComment("设计图") .HasColumnType("text") .HasColumnName("blueprint"); entity.Property(e => e.CompanyId) .HasComment("公司ID") .HasColumnName("company_id"); entity.Property(e => e.Createtime) .HasColumnType("datetime") .HasColumnName("createtime"); entity.Property(e => e.CreatetimeUnix) .HasComment("Unix时间") .HasColumnName("createtime_unix"); entity.Property(e => e.Customization) .HasMaxLength(255) .HasComment("套餐名称") .HasColumnName("customization"); entity.Property(e => e.HangyeClass) .HasMaxLength(255) .HasComment("行业类型") .HasColumnName("hangye_class"); entity.Property(e => e.ProjectCode) .HasMaxLength(255) .HasComment("项目编码") .HasColumnName("project_code"); entity.Property(e => e.ProjectName) .HasMaxLength(255) .HasComment("项目名称") .HasColumnName("project_name"); entity.Property(e => e.Quyu) .HasMaxLength(255) .HasComment("所属区域") .HasColumnName("quyu"); entity.Property(e => e.RoomTotalCount) .HasComment("房间总数") .HasColumnName("room_total_count"); entity.Property(e => e.RoomTypeCount) .HasComment("房型数量") .HasColumnName("room_type_count"); entity.Property(e => e.Shengfen) .HasMaxLength(255) .HasComment("所属省份") .HasColumnName("shengfen"); entity.Property(e => e.ShengpiStatus) .HasMaxLength(64) .HasComment("审批状态") .HasColumnName("shengpi_status"); entity.Property(e => e.Uid) .HasComment("申请人") .HasColumnName("uid"); entity.Property(e => e.Updatetime) .HasColumnType("datetime") .HasColumnName("updatetime"); entity.Property(e => e.UpdatetimeUnix).HasColumnName("updatetime_unix"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("aas_project_report_ready"); entity.Property(e => e.Id).HasColumnName("id"); entity.Property(e => e.Createtime) .HasColumnType("datetime") .HasColumnName("createtime"); entity.Property(e => e.CustomerContactsH) .HasMaxLength(255) .HasColumnName("customer_contacts_h"); entity.Property(e => e.ProjectCode) .HasMaxLength(255) .HasColumnName("project_code"); entity.Property(e => e.Unixtime).HasColumnName("unixtime"); entity.Property(e => e.Updatetime) .HasColumnType("datetime") .HasColumnName("updatetime"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("aas_project_shenpi"); entity.Property(e => e.Id).HasColumnName("id"); entity.Property(e => e.Createtime) .HasColumnType("datetime") .HasColumnName("createtime"); entity.Property(e => e.ProjectCode) .HasMaxLength(255) .HasComment("项目代码") .HasColumnName("project_code"); entity.Property(e => e.RejectReason) .HasMaxLength(255) .HasComment("驳回理由") .HasColumnName("reject_reason"); entity.Property(e => e.ShenpiNumber) .HasComment("审批序号") .HasColumnName("shenpi_number"); entity.Property(e => e.ShenpiSuggest) .HasMaxLength(255) .HasComment("审批建议") .HasColumnName("shenpi_suggest"); entity.Property(e => e.Updatetime) .HasColumnType("datetime") .HasColumnName("updatetime"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("aas_users"); entity.Property(e => e.Id) .HasComment("主键") .HasColumnName("id"); entity.Property(e => e.Avatar) .HasComment("账户头像") .HasColumnType("text") .HasColumnName("avatar"); entity.Property(e => e.ComId) .HasComment("所属公司ID") .HasColumnName("com_id"); entity.Property(e => e.CreationTime) .HasComment("创建时间") .HasColumnType("datetime") .HasColumnName("creation_time"); entity.Property(e => e.Email) .HasMaxLength(255) .HasComment("邮箱") .HasColumnName("email"); entity.Property(e => e.Isdelete) .HasComment("是否删除") .HasColumnName("isdelete"); entity.Property(e => e.Mobile) .HasMaxLength(255) .HasComment("电话号码") .HasColumnName("mobile"); entity.Property(e => e.Password) .HasMaxLength(255) .HasComment("密码") .HasColumnName("password"); entity.Property(e => e.Position) .HasMaxLength(255) .HasComment("职位") .HasColumnName("position"); entity.Property(e => e.PswEncryption) .HasMaxLength(255) .HasComment("密码加密处理") .HasColumnName("psw_encryption"); entity.Property(e => e.Realname) .HasMaxLength(64) .HasComment("真实姓名") .HasColumnName("realname"); entity.Property(e => e.RoleId) .HasComment("角色ID") .HasColumnName("role_id"); entity.Property(e => e.UpdateTime) .HasComment("更新时间") .HasColumnType("datetime") .HasColumnName("update_time"); entity.Property(e => e.Username) .HasMaxLength(64) .HasComment("用户名（登录名）") .HasColumnName("username"); entity.Property(e => e.Weixin) .HasMaxLength(255) .HasComment("微信号") .HasColumnName("weixin"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("aas_user_permission"); entity.Property(e => e.Id).HasColumnName("id"); entity.Property(e => e.ProxyClass) .HasMaxLength(255) .HasColumnName("proxy_class"); entity.Property(e => e.ProxyRegion) .HasMaxLength(255) .HasColumnName("proxy_region"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("aas_users_operate_log"); entity.Property(e => e.Id) .HasComment("主键") .HasColumnName("id"); entity.Property(e => e.Browser) .HasMaxLength(255) .HasComment("浏览器版本") .HasColumnName("browser") .UseCollation("utf8_general_ci") .HasCharSet("utf8"); entity.Property(e => e.CreationTime) .HasComment("创建时间") .HasColumnType("datetime") .HasColumnName("creation_time"); entity.Property(e => e.Device) .HasMaxLength(255) .HasComment("设备型号") .HasColumnName("device") .UseCollation("utf8_general_ci") .HasCharSet("utf8"); entity.Property(e => e.Ip) .HasMaxLength(255) .HasComment("ip地址") .HasColumnName("ip") .UseCollation("utf8_general_ci") .HasCharSet("utf8"); entity.Property(e => e.Location) .HasMaxLength(255) .HasComment("地理位置") .HasColumnName("location") .UseCollation("utf8_general_ci") .HasCharSet("utf8"); entity.Property(e => e.Operate) .HasComment("执行操作") .HasColumnType("text") .HasColumnName("operate"); entity.Property(e => e.Operation) .HasMaxLength(255) .HasComment("操作类型") .HasColumnName("operation") .UseCollation("utf8_general_ci") .HasCharSet("utf8"); entity.Property(e => e.TypeId) .HasComment("日志类型ID") .HasColumnName("type_id"); entity.Property(e => e.Username) .HasMaxLength(100) .HasComment("用户名字") .HasColumnName("username") .UseCollation("utf8_general_ci") .HasCharSet("utf8"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("autokeygenerater"); entity.Property(e => e.CompanyCode).HasColumnName("Company_code"); entity.Property(e => e.ProjectInfoCode).HasColumnName("ProjectInfo_code"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity.ToTable("wy_logs"); entity.Property(e => e.Id) .HasComment("主键") .HasColumnName("id"); entity.Property(e => e.CreationTime) .HasComment("创建时间") .HasColumnName("creation_time"); entity.Property(e => e.Introduced) .HasComment("传入参数") .HasColumnType("text") .HasColumnName("introduced"); entity.Property(e => e.Ip) .HasMaxLength(255) .HasComment("ip地址") .HasColumnName("ip") .UseCollation("utf8_general_ci") .HasCharSet("utf8"); entity.Property(e => e.Operation) .HasMaxLength(255) .HasComment("操作类型") .HasColumnName("operation") .UseCollation("utf8_general_ci") .HasCharSet("utf8"); entity.Property(e => e.ReturnValue) .HasComment("返回值") .HasColumnType("text") .HasColumnName("return_value"); }); modelBuilder.Entity(entity => { entity.HasKey(e => e.Id).HasName("PRIMARY"); entity .ToTable("wy_users", tb => tb.HasComment("用户信息表")) .UseCollation("utf8mb4_general_ci"); entity.HasIndex(e => e.Username, "idx_account"); entity.Property(e => e.Id) .HasComment("主键") .HasColumnName("id"); entity.Property(e => e.Avatar) .HasMaxLength(500) .HasComment("头像") .HasColumnName("avatar"); entity.Property(e => e.Birthday) .HasComment("生日") .HasColumnType("datetime") .HasColumnName("birthday"); entity.Property(e => e.Code) .HasMaxLength(12) .HasComment("用户编号") .HasColumnName("code"); entity.Property(e => e.ComId) .HasComment("所属公司ID") .HasColumnName("com_id"); entity.Property(e => e.CreateDept) .HasComment("创建部门") .HasColumnName("create_dept"); entity.Property(e => e.CreateUser) .HasComment("创建人") .HasColumnName("create_user"); entity.Property(e => e.CreationTime) .HasDefaultValueSql("CURRENT_TIMESTAMP") .HasComment("创建时间") .HasColumnType("datetime") .HasColumnName("creation_time"); entity.Property(e => e.DeptId) .HasMaxLength(1000) .HasComment("部门id") .HasColumnName("dept_id"); entity.Property(e => e.Email) .HasMaxLength(45) .HasComment("邮箱") .HasColumnName("email"); entity.Property(e => e.Isdelete) .HasDefaultValueSql("'0'") .HasComment("是否已删除") .HasColumnName("isdelete"); entity.Property(e => e.Mobile) .HasMaxLength(45) .HasComment("手机") .HasColumnName("mobile"); entity.Property(e => e.Name) .HasMaxLength(20) .HasComment("昵称") .HasColumnName("name"); entity.Property(e => e.Password) .HasMaxLength(45) .HasComment("密码") .HasColumnName("password"); entity.Property(e => e.Position) .HasMaxLength(255) .HasComment("职位") .HasColumnName("position") .UseCollation("utf8mb4_bin"); entity.Property(e => e.PostId) .HasMaxLength(1000) .HasComment("岗位id") .HasColumnName("post_id"); entity.Property(e => e.Realname) .HasMaxLength(10) .HasComment("真名") .HasColumnName("realname"); entity.Property(e => e.RoleId) .HasMaxLength(1000) .HasComment("角色id") .HasColumnName("role_id"); entity.Property(e => e.RoleIdAas) .HasComment("角色ID") .HasColumnName("role_id_aas"); entity.Property(e => e.Sex) .HasComment("性别") .HasColumnName("sex"); entity.Property(e => e.Status) .HasComment("状态") .HasColumnName("status"); entity.Property(e => e.TenantId) .HasMaxLength(12) .HasDefaultValueSql("'000000'") .HasComment("租户ID") .HasColumnName("tenant_id"); entity.Property(e => e.UpdateTime) .ValueGeneratedOnAddOrUpdate() .HasDefaultValueSql("CURRENT_TIMESTAMP") .HasComment("修改时间") .HasColumnType("datetime") .HasColumnName("update_time"); entity.Property(e => e.UpdateUser) .HasComment("修改人") .HasColumnName("update_user"); entity.Property(e => e.UserType) .HasComment("用户平台") .HasColumnName("user_type"); entity.Property(e => e.Username) .HasMaxLength(45) .HasComment("账号") .HasColumnName("username"); entity.Property(e => e.Weixin) .HasMaxLength(255) .HasComment("微信") .HasColumnName("weixin"); }); OnModelCreatingPartial(modelBuilder); } partial void OnModelCreatingPartial(ModelBuilder modelBuilder); }