// using System; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; using YD_WeChatApplet.Context; #nullable disable namespace YD_WeChatApplet.Api.Migrations { [DbContext(typeof(UserContext))] [Migration("20250520064331_20250520v3")] partial class _20250520v3 { protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "6.0.0") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1); modelBuilder.Entity("VOL.Entity.DomainModels.WCA_GroupMembers", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("CreateTime") .HasColumnType("datetime") .HasComment("创建时间"); b.Property("UserGroupId") .HasColumnType("int"); b.Property("UserId") .HasColumnType("int") .HasComment("用户Id"); b.HasKey("Id"); b.HasIndex("UserGroupId"); b.ToTable("WCA_GroupMembers"); }); modelBuilder.Entity("VOL.Entity.DomainModels.WCA_GroupTask", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Amount") .HasColumnType("int") .HasComment("作业数量"); b.Property("CreateTime") .HasColumnType("datetime") .HasComment("创建时间"); b.Property("Duration") .HasColumnType("int") .HasComment("作业时长"); b.Property("EndTime") .HasColumnType("datetime") .HasComment("结束时间"); b.Property("GroupNumber") .HasColumnType("int") .HasComment("作业数量"); b.Property("GroupTaskName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("作业名称"); b.Property("IsRepeat") .HasColumnType("bit") .HasComment("是否重复"); b.Property("RepetitionPeriod") .IsRequired() .HasColumnType("nvarchar(100)") .HasComment("重复周期"); b.Property("StartTime") .HasColumnType("datetime") .HasComment("开始时间"); b.Property("UserGroupId") .HasColumnType("int"); b.Property("WorkModeType") .HasColumnType("int") .HasComment("作业类型"); b.Property("WorkModeTypeName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("模式类型名称"); b.Property("WorkText") .HasColumnType("nvarchar(max)") .HasComment("作业内容"); b.Property("WorkTypeName") .HasColumnType("nvarchar(200)") .HasComment("作业类型名称"); b.HasKey("Id"); b.HasIndex("UserGroupId"); b.ToTable("WCA_GroupTask"); }); modelBuilder.Entity("VOL.Entity.DomainModels.WCA_GroupTaskResult", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Amount") .HasColumnType("int") .HasComment("作业数量"); b.Property("CreateTime") .HasColumnType("datetime") .HasComment("创建时间"); b.Property("DataSource") .HasColumnType("int") .HasComment("数据来源"); b.Property("Duration") .HasColumnType("int") .HasComment("作业时长"); b.Property("GroupTaskId") .HasColumnType("int"); b.Property("UserId") .HasColumnType("int") .HasComment("用户Id"); b.Property("WorkModeType") .HasColumnType("int") .HasComment("作业类型"); b.Property("WorkModeTypeName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("模式类型名称"); b.HasKey("Id"); b.HasIndex("GroupTaskId"); b.ToTable("WCA_GroupTaskResult"); }); modelBuilder.Entity("VOL.Entity.DomainModels.WCA_PersonalGoalResult", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Amount") .HasColumnType("int") .HasComment("作业数量"); b.Property("CreateTime") .HasColumnType("datetime") .HasComment("创建时间"); b.Property("DataSource") .HasColumnType("int") .HasComment("数据来源"); b.Property("Duration") .HasColumnType("int") .HasComment("作业时长"); b.Property("PersonalGoalId") .HasColumnType("int"); b.Property("PersonalGoalName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("名称"); b.Property("PersonalGoalType") .HasColumnType("int") .HasComment("目标类型"); b.Property("Score") .HasColumnType("int") .HasComment("得分"); b.Property("UserId") .HasColumnType("int") .HasComment("用户Id"); b.Property("WorkModeType") .HasColumnType("int") .HasComment("作业类型"); b.Property("WorkModeTypeName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("模式类型名称"); b.HasKey("Id"); b.ToTable("WCA_PersonalGoalResult"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.User", b => { b.Property("User_Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("User_Id"), 1L, 1); b.Property("Address") .HasMaxLength(200) .HasColumnType("nvarchar(200)") .HasComment("地址"); b.Property("BirthDate") .HasColumnType("nvarchar(100)") .HasComment("出生日期"); b.Property("CreateDate") .HasColumnType("datetime") .HasComment("创建时间"); b.Property("Creator") .HasColumnType("int)") .HasComment("创建人"); b.Property("Email") .HasMaxLength(100) .HasColumnType("nvarchar(100)") .HasComment("Email"); b.Property("Enable") .HasColumnType("tinyint") .HasComment("是否可用"); b.Property("Gender") .HasColumnType("int") .HasComment("性别"); b.Property("HeadImageUrl") .HasMaxLength(500) .HasColumnType("nvarchar(500)") .HasComment("头像"); b.Property("Height") .HasColumnType("float") .HasComment("身高"); b.Property("Modifier") .HasColumnType("int)") .HasComment("修改人"); b.Property("ModifyDate") .HasColumnType("datetime") .HasComment("修改时间"); b.Property("PhoneNo") .HasMaxLength(11) .HasColumnType("nvarchar(11)") .HasComment("手机号"); b.Property("RelevanceId") .HasColumnType("uniqueidentifier"); b.Property("Remarks") .HasColumnType("text") .HasComment("备注"); b.Property("RoleName") .HasMaxLength(200) .HasColumnType("nvarchar(200)") .HasComment("角色"); b.Property("Role_Id") .HasColumnType("int") .HasComment("角色Id"); b.Property("SchoolCode") .HasColumnType("nvarchar(100)") .HasComment("学校编号"); b.Property("UserName") .IsRequired() .HasMaxLength(100) .HasColumnType("nvarchar(100)") .HasComment("帐号"); b.Property("UserPwd") .HasMaxLength(200) .HasColumnType("nvarchar(200)") .HasComment("密码"); b.Property("UserTrueName") .HasMaxLength(200) .HasColumnType("nvarchar(200)") .HasComment("姓名"); b.Property("Weight") .HasColumnType("float") .HasComment("体重"); b.Property("wx_HeadImgUrl") .HasMaxLength(2000) .HasColumnType("nvarchar(2000)") .HasComment("微信头像"); b.Property("wx_NickName") .HasMaxLength(200) .HasColumnType("nvarchar(200)") .HasComment("微信昵称"); b.Property("wx_OpenID") .HasMaxLength(200) .HasColumnType("nvarchar(200)") .HasComment("微信OpenId"); b.Property("wx_UnionID") .HasMaxLength(200) .HasColumnType("nvarchar(200)") .HasComment("微信UnionId"); b.HasKey("User_Id"); b.ToTable("User"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.User_Auth", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Bind_Id") .HasColumnType("int") .HasComment("绑定Id"); b.Property("Role_Id") .HasColumnType("int") .HasComment("角色Id"); b.Property("Self_Id") .HasColumnType("int") .HasComment("自身Id"); b.Property("Token") .IsRequired() .HasColumnType("nvarchar(max)") .HasComment("Token"); b.HasKey("Id"); b.ToTable("User_Auth"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_BackgroundMusic", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Name") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("名称"); b.Property("ResourceType") .HasColumnType("int") .HasComment("资源类型[1:音乐/2:节拍]"); b.Property("Url") .IsRequired() .HasColumnType("nvarchar(2000)") .HasComment("资源地址"); b.HasKey("Id"); b.ToTable("WCA_BackgroundMusic"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_Category", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("CategoryEnum") .IsRequired() .HasColumnType("nvarchar(100)") .HasComment("类别枚举名称"); b.Property("CategoryKey") .IsRequired() .HasColumnType("nvarchar(100)") .HasComment("运动类型Key"); b.Property("CategoryName") .IsRequired() .HasColumnType("nvarchar(100)") .HasComment("类别中文名称"); b.Property("CategoryValue") .HasColumnType("int") .HasComment("类别枚举值"); b.Property("KcalIndex") .HasColumnType("float") .HasComment("卡路里指数"); b.Property("Remarks") .IsRequired() .HasColumnType("text") .HasComment("备注"); b.HasKey("Id"); b.ToTable("WCA_Category"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_ExerciseData", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Age") .HasColumnType("int") .HasComment("年龄"); b.Property("Amount") .HasColumnType("int") .HasComment("数量"); b.Property("Calorie") .HasColumnType("int") .HasComment("卡路里"); b.Property("CreateTime") .HasColumnType("datetime") .HasComment("创建时间"); b.Property("DataSource") .HasColumnType("int") .HasComment("数据来源"); b.Property("Duration") .HasColumnType("int") .HasComment("时长"); b.Property("EndTime") .HasColumnType("datetime") .HasComment("结束时间"); b.Property("GroupNumber") .HasColumnType("int") .HasComment("作业数量"); b.Property("HomeWorkId") .HasColumnType("int") .HasComment("作业Id"); b.Property("RoleId") .HasColumnType("int") .HasComment("角色"); b.Property("Sex") .HasColumnType("int") .HasComment("性别"); b.Property("StartTime") .HasColumnType("datetime") .HasComment("开始时间"); b.Property("Status") .HasColumnType("int") .HasComment("状态"); b.Property("StudentName") .HasColumnType("nvarchar(100)") .HasComment("学生名称"); b.Property("StudentNo") .HasColumnType("nvarchar(100)") .HasComment("学生学号"); b.Property("UserId") .HasColumnType("int") .HasComment("用户Id"); b.Property("UserName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("用户姓名"); b.Property("WorkModeType") .HasColumnType("int") .HasComment("作业类型"); b.Property("WorkModeTypeName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("模式类型名称"); b.Property("WorkType") .HasColumnType("int") .HasComment("作业类型"); b.Property("WorkTypeName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("作业类型名称"); b.HasKey("Id"); b.ToTable("WCA_ExerciseData"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_MyPlayList", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("ResourceDetailsId") .HasColumnType("int") .HasComment("资源详情Id"); b.Property("ResourceType") .HasColumnType("int") .HasComment("资源类型"); b.Property("UserId") .HasColumnType("int") .HasComment("用户Id"); b.HasKey("Id"); b.ToTable("WCA_MyPlayList"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_PersonalGoal", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("GoalAmount") .HasColumnType("int") .HasComment("目标数量"); b.Property("GoalDate") .HasColumnType("datetime") .HasComment("目标日期"); b.Property("GoalDuration") .HasColumnType("int") .HasComment("目标时长"); b.Property("UserId") .HasColumnType("int") .HasComment("用户Id"); b.HasKey("Id"); b.ToTable("WCA_PersonalGoal"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_ResourceDetails", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("ImageUrl") .IsRequired() .HasColumnType("nvarchar(2000)") .HasComment("封面地址"); b.Property("ResourceName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("资源名称"); b.Property("ResourceTypeId") .HasColumnType("int") .HasComment("资源类型Id"); b.Property("ResourceUrl") .IsRequired() .HasColumnType("nvarchar(2000)") .HasComment("资源地址"); b.HasKey("Id"); b.ToTable("WCA_ResourceDetails"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_ResourceType", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("ParentId") .HasColumnType("int") .HasComment("父Id"); b.Property("TypeName") .IsRequired() .HasColumnType("nvarchar(200)") .HasComment("类型名称"); b.HasKey("Id"); b.ToTable("WCA_ResourceType"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_UserGroup", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("CreateTime") .HasColumnType("datetime") .HasComment("创建时间"); b.Property("CreaterId") .HasColumnType("int") .HasComment("创建人Id"); b.Property("GroupName") .IsRequired() .HasColumnType("nvarchar(100)") .HasComment("群组名称"); b.Property("UserId") .HasColumnType("int") .HasComment("用户Id"); b.HasKey("Id"); b.ToTable("WCA_UserGroup"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_UserPreference", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Bpm") .HasColumnType("int") .HasComment("节拍"); b.Property("Countdown") .HasColumnType("int") .HasComment("倒计时"); b.Property("CreateTime") .HasColumnType("datetime") .HasComment("创建时间"); b.Property("Interval") .HasColumnType("int") .HasComment("间隔"); b.Property("IsMusic") .HasColumnType("bit") .HasComment("是否是音乐"); b.Property("ResourceId") .HasColumnType("int") .HasComment("资源Id"); b.Property("UserId") .HasColumnType("int") .HasComment("用户Id"); b.HasKey("Id"); b.ToTable("WCA_UserPreference"); }); modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_Week", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Name") .IsRequired() .HasColumnType("nvarchar(100)") .HasComment("Name"); b.Property("Remarks") .IsRequired() .HasColumnType("text") .HasComment("备注"); b.HasKey("Id"); b.ToTable("WCA_Week"); }); modelBuilder.Entity("YD_WeChatApplet.Entitys.TestTable", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasComment("Id"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Json") .IsRequired() .HasColumnType("nvarchar(100)") .HasComment("Json"); b.Property("Name") .IsRequired() .HasColumnType("nvarchar(100)") .HasComment("Name"); b.HasKey("Id"); b.ToTable("TestTable"); }); modelBuilder.Entity("VOL.Entity.DomainModels.WCA_GroupMembers", b => { b.HasOne("YD_WeChatApplet.Api.Entitys.WCA_UserGroup", "UserGroup") .WithMany() .HasForeignKey("UserGroupId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("UserGroup"); }); modelBuilder.Entity("VOL.Entity.DomainModels.WCA_GroupTask", b => { b.HasOne("YD_WeChatApplet.Api.Entitys.WCA_UserGroup", "UserGroup") .WithMany() .HasForeignKey("UserGroupId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("UserGroup"); }); modelBuilder.Entity("VOL.Entity.DomainModels.WCA_GroupTaskResult", b => { b.HasOne("VOL.Entity.DomainModels.WCA_GroupTask", "GroupTask") .WithMany() .HasForeignKey("GroupTaskId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("GroupTask"); }); #pragma warning restore 612, 618 } } }