YD_WeChatApplet.Api/WeChatApplet/Migrations/SmartSports/SmartSportsContextModelSnapshot.cs
2025-06-06 14:57:20 +08:00

692 lines
26 KiB
C#

// <auto-generated />
using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using YD_WeChatApplet.Context;
#nullable disable
namespace YD_WeChatApplet.Api.Migrations.SmartSports
{
[DbContext(typeof(SmartSportsContext))]
partial class SmartSportsContextModelSnapshot : ModelSnapshot
{
protected override void BuildModel(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.SmartSportsEntitys.S_Class", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasComment("Id");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
b.Property<string>("ClassName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("班级名称");
b.Property<DateTime?>("CreateDate")
.HasColumnType("datetime")
.HasComment("创建时间");
b.Property<int?>("Creator")
.HasColumnType("int)")
.HasComment("创建人");
b.Property<int>("GradeId")
.HasColumnType("int")
.HasComment("年级Id");
b.Property<string>("GradeName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("年级名称");
b.Property<int?>("Modifier")
.HasColumnType("int)")
.HasComment("修改人");
b.Property<DateTime?>("ModifyDate")
.HasColumnType("datetime")
.HasComment("修改时间");
b.Property<string>("Remarks")
.HasColumnType("text")
.HasComment("备注");
b.Property<string>("SchoolCode")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学校编号");
b.HasKey("Id");
b.ToTable("S_Class");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.S_ClassAssocTeacher", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasComment("Id");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
b.Property<int>("ClassId")
.HasColumnType("int")
.HasComment("班级Id");
b.Property<DateTime?>("CreateDate")
.HasColumnType("datetime")
.HasComment("创建时间");
b.Property<int>("Creator")
.HasColumnType("int)")
.HasComment("创建人");
b.Property<int>("Modifier")
.HasColumnType("int)")
.HasComment("修改人");
b.Property<DateTime?>("ModifyDate")
.HasColumnType("datetime")
.HasComment("修改时间");
b.Property<string>("Remarks")
.HasColumnType("text")
.HasComment("备注");
b.Property<int>("TeacherId")
.HasColumnType("int")
.HasComment("老师Id");
b.HasKey("Id");
b.ToTable("S_ClassAssocTeacher");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.S_HomeWork", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasComment("Id");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
b.Property<int>("Amount")
.HasColumnType("int")
.HasComment("作业数量");
b.Property<int>("ClassId")
.HasColumnType("int")
.HasComment("班级Id");
b.Property<string>("ClassName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("班级名称");
b.Property<int>("Duration")
.HasColumnType("int")
.HasComment("作业时长");
b.Property<DateTime>("EndTime")
.HasColumnType("datetime")
.HasComment("结束时间");
b.Property<int>("GradeId")
.HasColumnType("int")
.HasComment("年级Id");
b.Property<string>("GradeName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("年级名称");
b.Property<int>("GroupNumber")
.HasColumnType("int")
.HasComment("作业数量");
b.Property<bool>("IsRepeat")
.HasColumnType("bit")
.HasComment("是否重复");
b.Property<string>("RepetitionPeriod")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("重复周期");
b.Property<string>("SchoolCode")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学校编号");
b.Property<DateTime>("StartTime")
.HasColumnType("datetime")
.HasComment("开始时间");
b.Property<int>("StudentScope")
.HasColumnType("int")
.HasComment("学生范围");
b.Property<int>("TeacherId")
.HasColumnType("int")
.HasComment("老师Id");
b.Property<string>("TeacherName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("老师名称");
b.Property<string>("TeacherPhoneNo")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("老师手机号");
b.Property<string>("WorkName")
.IsRequired()
.HasColumnType("nvarchar(200)")
.HasComment("作业名称");
b.Property<int>("WorkStatus")
.HasColumnType("int")
.HasComment("作业状态");
b.Property<string>("WorkText")
.IsRequired()
.HasColumnType("nvarchar(max)")
.HasComment("作业内容");
b.Property<int>("WorkType")
.HasColumnType("int")
.HasComment("作业类型");
b.Property<string>("WorkTypeName")
.IsRequired()
.HasColumnType("nvarchar(200)")
.HasComment("作业类型名称");
b.HasKey("Id");
b.ToTable("S_HomeWork");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.S_HomeWorkStudents", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasComment("Id");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
b.Property<int>("HomeWorkId")
.HasColumnType("int");
b.Property<string>("Photo")
.IsRequired()
.HasColumnType("nvarchar(2000)")
.HasComment("学生照片");
b.Property<string>("SchoolCode")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学校编号");
b.Property<int>("Sex")
.HasColumnType("int")
.HasComment("性别");
b.Property<string>("StudentName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学生名称");
b.Property<string>("StudentNo")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学生学号");
b.Property<int>("WorkStatus")
.HasColumnType("int")
.HasComment("学生作业状态");
b.HasKey("Id");
b.HasIndex("HomeWorkId");
b.ToTable("S_HomeWorkStudents");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.S_Student", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasComment("Id");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
b.Property<int>("Age")
.HasColumnType("int")
.HasComment("年龄");
b.Property<string>("AppletPwd")
.HasColumnType("nvarchar(100)")
.HasComment("小程序密码");
b.Property<DateTime?>("Birthday")
.HasColumnType("datetime")
.HasComment("出生日期");
b.Property<int>("ClassId")
.HasColumnType("int")
.HasComment("班级Id");
b.Property<string>("ClassName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("班级名称");
b.Property<DateTime?>("CreateDate")
.HasColumnType("datetime")
.HasComment("创建时间");
b.Property<int>("Creator")
.HasColumnType("int)")
.HasComment("创建人");
b.Property<string>("HeartRateFrontNo")
.HasColumnType("nvarchar(100)")
.HasComment("心率设备正面编号");
b.Property<string>("HeartRateId")
.HasColumnType("nvarchar(100)")
.HasComment("心率设备ID");
b.Property<string>("HeartRateQRCode")
.HasColumnType("nvarchar(100)")
.HasComment("心率设备二维码编号");
b.Property<string>("HomeAddress")
.HasColumnType("nvarchar(200)")
.HasComment("家庭住址");
b.Property<string>("IDCard")
.HasColumnType("nvarchar(50)")
.HasComment("身份证");
b.Property<int>("Modifier")
.HasColumnType("int)")
.HasComment("修改人");
b.Property<DateTime?>("ModifyDate")
.HasColumnType("datetime")
.HasComment("修改时间");
b.Property<string>("Nation")
.HasColumnType("nvarchar(20)")
.HasComment("民族");
b.Property<string>("ParentName")
.HasColumnType("nvarchar(20)")
.HasComment("家长姓名");
b.Property<string>("ParentPhoneNo")
.HasColumnType("nvarchar(20)")
.HasComment("家长联系方式");
b.Property<string>("Photo")
.IsRequired()
.HasColumnType("nvarchar(2000)")
.HasComment("学生照片");
b.Property<string>("PlaceSchoolRollNo")
.HasColumnType("nvarchar(100)")
.HasComment("地方学籍号");
b.Property<string>("Remarks")
.HasColumnType("text")
.HasComment("备注");
b.Property<string>("RopeSkipNo")
.HasColumnType("nvarchar(100)")
.HasComment("跳绳二维码编号");
b.Property<string>("RopeSkipQRCode")
.HasColumnType("nvarchar(100)")
.HasComment("跳绳编号");
b.Property<string>("RunChipNo")
.HasColumnType("nvarchar(100)")
.HasComment("中长跑芯片编号");
b.Property<string>("SchoolCode")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学校编号");
b.Property<string>("SchoolRollNo")
.HasColumnType("nvarchar(100)")
.HasComment("学籍号");
b.Property<int>("Sex")
.HasColumnType("int")
.HasComment("性别");
b.Property<string>("StudentName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学生名称");
b.Property<string>("StudentNation")
.HasColumnType("nvarchar(50)")
.HasComment("学生名族");
b.Property<string>("StudentNo")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学生学号");
b.Property<int>("StudentStatus")
.HasColumnType("int")
.HasComment("状态");
b.Property<int?>("TotalTrainNumber")
.HasColumnType("int")
.HasComment("训练次数");
b.Property<double?>("TotalTrainTime")
.HasColumnType("float")
.HasComment("训练时长");
b.HasKey("Id");
b.ToTable("S_Student");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.S_SubmittedAssignments", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasComment("Id");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
b.Property<string>("FileName")
.IsRequired()
.HasColumnType("nvarchar(200)")
.HasComment("文件名称");
b.Property<string>("FilePath")
.IsRequired()
.HasColumnType("nvarchar(2000)")
.HasComment("文件地址");
b.Property<int?>("FileSize")
.HasColumnType("int")
.HasComment("文件大小");
b.Property<int>("FileType")
.HasColumnType("int")
.HasComment("文件类型");
b.Property<int>("HomeWorkId")
.HasColumnType("int")
.HasComment("作业Id");
b.Property<string>("SchoolCode")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学校编号");
b.Property<string>("StudentNo")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学生学号");
b.HasKey("Id");
b.ToTable("S_SubmittedAssignments");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.S_Teacher", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasComment("Id");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
b.Property<int?>("AccumulatedTeachingTimes")
.HasColumnType("int")
.HasComment("授课次数");
b.Property<int>("Age")
.HasColumnType("int")
.HasComment("教师年龄");
b.Property<string>("AppletPwd")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("小程序密码");
b.Property<DateTime?>("CreateDate")
.HasColumnType("datetime")
.HasComment("创建时间");
b.Property<int?>("Creator")
.HasColumnType("int)")
.HasComment("创建人");
b.Property<DateTime>("InductionDate")
.HasColumnType("datetime")
.HasComment("入职日期");
b.Property<int?>("Modifier")
.HasColumnType("int)")
.HasComment("修改人");
b.Property<DateTime?>("ModifyDate")
.HasColumnType("datetime")
.HasComment("修改时间");
b.Property<string>("Ology")
.HasColumnType("nvarchar(20)")
.HasComment("老师学科");
b.Property<string>("Remarks")
.HasColumnType("text")
.HasComment("备注");
b.Property<string>("SchoolCode")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("学校编号");
b.Property<int>("Sex")
.HasColumnType("int")
.HasComment("教师性别");
b.Property<string>("TeacherName")
.IsRequired()
.HasColumnType("nvarchar(100)")
.HasComment("教师名称");
b.Property<string>("TeacherPhoneNo")
.IsRequired()
.HasColumnType("nvarchar(20)")
.HasComment("老师联系方式");
b.Property<string>("TeacherPhoto")
.HasColumnType("nvarchar(2000)")
.HasComment("老师照片");
b.Property<int>("TeacherStatus")
.HasColumnType("int")
.HasComment("状态");
b.HasKey("Id");
b.ToTable("S_Teacher");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.Sys_User", b =>
{
b.Property<int>("User_Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("User_Id"), 1L, 1);
b.Property<string>("Address")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property<int?>("AppType")
.HasColumnType("int");
b.Property<DateTime?>("AuditDate")
.HasColumnType("datetime");
b.Property<DateTime?>("CreateDate")
.HasColumnType("datetime");
b.Property<int?>("CreateID")
.HasColumnType("int");
b.Property<string>("Creator")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property<string>("DeptName")
.IsRequired()
.HasMaxLength(150)
.HasColumnType("nvarchar(150)");
b.Property<int?>("Dept_Id")
.HasColumnType("int");
b.Property<string>("Email")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<int>("Enable")
.HasColumnType("int");
b.Property<int>("Gender")
.HasColumnType("int");
b.Property<string>("HeadImageUrl")
.IsRequired()
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property<DateTime?>("LastLoginDate")
.HasColumnType("datetime");
b.Property<DateTime?>("LastModifyPwdDate")
.HasColumnType("datetime");
b.Property<string>("Modifier")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property<DateTime?>("ModifyDate")
.HasColumnType("datetime");
b.Property<int?>("ModifyID")
.HasColumnType("int");
b.Property<string>("PhoneNo")
.IsRequired()
.HasMaxLength(11)
.HasColumnType("nvarchar(11)");
b.Property<string>("Remark")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property<string>("RoleName")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property<int>("Role_Id")
.HasColumnType("int");
b.Property<string>("SchoolCode")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property<string>("SchoolName")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property<string>("Token")
.IsRequired()
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property<string>("UserName")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property<string>("UserPwd")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property<string>("UserTrueName")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.HasKey("User_Id");
b.ToTable("Sys_User");
});
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.Navigation("HomeWork");
});
modelBuilder.Entity("YD_WeChatApplet.Api.SmartSportsEntitys.S_HomeWork", b =>
{
b.Navigation("HomeWorkStudents");
});
#pragma warning restore 612, 618
}
}
}