//
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("20250310060814_20250310v2")]
partial class _20250310v2
{
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("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("datetime")
.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")
.IsRequired()
.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.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("CategoryName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("类别中文名称");
b.Property("CategoryValue")
.HasColumnType("int")
.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("Duration")
.HasColumnType("int")
.HasComment("时长");
b.Property("EndTime")
.HasColumnType("datetime")
.HasComment("结束时间");
b.Property("RoleId")
.HasColumnType("int")
.HasComment("角色");
b.Property("Sex")
.HasColumnType("int")
.HasComment("性别");
b.Property("StartTime")
.HasColumnType("datetime")
.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("WorkStatus")
.HasColumnType("int")
.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_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("TypeName")
.IsRequired()
.HasColumnType("nvarchar(200)")
.HasComment("类型名称");
b.HasKey("Id");
b.ToTable("WCA_ResourceType");
});
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.Api.SmartSportsEntitys.S_HomeWork", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasComment("Id");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1);
b.Property("Amount")
.HasColumnType("int")
.HasComment("作业数量");
b.Property("ClassId")
.HasColumnType("int")
.HasComment("班级Id");
b.Property("ClassName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("班级名称");
b.Property("CreateTime")
.HasColumnType("datetime")
.HasComment("创建时间");
b.Property("Duration")
.HasColumnType("int")
.HasComment("作业时长");
b.Property("EndTime")
.HasColumnType("datetime")
.HasComment("结束时间");
b.Property("GradeId")
.HasColumnType("int")
.HasComment("年级Id");
b.Property("GradeName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("年级名称");
b.Property("GroupNumber")
.HasColumnType("int")
.HasComment("作业数量");
b.Property("IsRepeat")
.HasColumnType("bit")
.HasComment("是否重复");
b.Property("RepetitionPeriod")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("重复周期");
b.Property("SchoolCode")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学校编号");
b.Property("StartTime")
.HasColumnType("datetime")
.HasComment("开始时间");
b.Property("StudentScope")
.HasColumnType("int")
.HasComment("学生范围");
b.Property("TeacherId")
.HasColumnType("int")
.HasComment("老师Id");
b.Property("TeacherName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("老师名称");
b.Property("TeacherPhoneNo")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("老师手机号");
b.Property("WorkModeType")
.HasColumnType("int")
.HasComment("作业类型");
b.Property("WorkModeTypeName")
.IsRequired()
.HasColumnType("nvarchar(200)")
.HasComment("模式类型名称");
b.Property("WorkName")
.IsRequired()
.HasColumnType("nvarchar(200)")
.HasComment("作业名称");
b.Property("WorkStatus")
.HasColumnType("int")
.HasComment("作业状态");
b.Property("WorkText")
.IsRequired()
.HasColumnType("nvarchar(max)")
.HasComment("作业内容");
b.Property("WorkType")
.HasColumnType("int")
.HasComment("作业类型");
b.Property("WorkTypeName")
.IsRequired()
.HasColumnType("nvarchar(200)")
.HasComment("作业类型名称");
b.HasKey("Id");
b.ToTable("S_HomeWork");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.S_HomeWorkStudents", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasComment("Id");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1);
b.Property("Age")
.HasColumnType("int")
.HasComment("年龄");
b.Property("HomeWorkId")
.HasColumnType("int");
b.Property("Photo")
.IsRequired()
.HasColumnType("nvarchar(2000)")
.HasComment("学生照片");
b.Property("SchoolCode")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学校编号");
b.Property("Sex")
.HasColumnType("int")
.HasComment("性别");
b.Property("StudentName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学生名称");
b.Property("StudentNo")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学生学号");
b.Property("Value")
.HasColumnType("int")
.HasComment("成绩");
b.Property("WCA_ExerciseDataId")
.HasColumnType("int");
b.Property("WorkStatus")
.HasColumnType("int")
.HasComment("学生作业状态");
b.HasKey("Id");
b.HasIndex("HomeWorkId");
b.HasIndex("WCA_ExerciseDataId");
b.ToTable("S_HomeWorkStudents");
});
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("YD_WeChatApplet.Api.SmartSportsEntitys.S_HomeWorkStudents", b =>
{
b.HasOne("YD_WeChatApplet.Api.SmartSportsEntitys.S_HomeWork", "HomeWork")
.WithMany("HomeWorkStudents")
.HasForeignKey("HomeWorkId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("YD_WeChatApplet.Api.Entitys.WCA_ExerciseData", null)
.WithMany("HomeWorkStudents")
.HasForeignKey("WCA_ExerciseDataId");
b.Navigation("HomeWork");
});
modelBuilder.Entity("YD_WeChatApplet.Api.Entitys.WCA_ExerciseData", b =>
{
b.Navigation("HomeWorkStudents");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.S_HomeWork", b =>
{
b.Navigation("HomeWorkStudents");
});
#pragma warning restore 612, 618
}
}
}