281 lines
23 KiB
C#
281 lines
23 KiB
C#
using Microsoft.EntityFrameworkCore.Migrations;
|
||
using System;
|
||
|
||
#nullable disable
|
||
|
||
namespace VOL.Core.Migrations
|
||
{
|
||
public partial class _20250115v1 : Migration
|
||
{
|
||
protected override void Up(MigrationBuilder migrationBuilder)
|
||
{
|
||
migrationBuilder.CreateTable(
|
||
name: "XW_Device",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<int>(type: "int", nullable: false, comment: "编号")
|
||
.Annotation("SqlServer:Identity", "1, 1"),
|
||
Type = table.Column<float>(type: "float", nullable: true, comment: "类型"),
|
||
DeviceType = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "设备型号"),
|
||
DeviceSerial = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "设备序列号"),
|
||
DeviceMac = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "设备 MAC 地址"),
|
||
DeviceImei = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "设备 IMEI 地址"),
|
||
CameraIp = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "AI 摄像机 IP 地址"),
|
||
GunJumpingIp = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "抢跑 IP"),
|
||
Eai100Flag = table.Column<bool>(type: "bit", nullable: true, comment: "是否是 EAI100 摄像头"),
|
||
OrgId = table.Column<int>(type: "int", nullable: true, comment: "组织 ID"),
|
||
OrgName = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "组织名称"),
|
||
UserId = table.Column<int>(type: "int", nullable: true, comment: "用户 ID"),
|
||
UserName = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "用户名称"),
|
||
SoftWareVer = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "软件版本"),
|
||
HardwareVer = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "硬件版本"),
|
||
DeployTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "应用时间"),
|
||
LastLoginTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "最后登录时间"),
|
||
Remark = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "备注"),
|
||
State = table.Column<int>(type: "int", nullable: true, comment: "授权状态"),
|
||
Status = table.Column<int>(type: "int", nullable: true, comment: "状态"),
|
||
CreateTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "创建时间"),
|
||
CreateBy = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "创建人"),
|
||
UpdateTime = table.Column<DateTime>(type: "datetime", nullable: true, comment: "修改时间"),
|
||
UpdateBy = table.Column<string>(type: "nvarchar(255)", nullable: true, comment: "修改人"),
|
||
SimilarNumber = table.Column<int>(type: "int", nullable: true, comment: "学校人脸的相似度")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_XW_Device", x => x.Id);
|
||
});
|
||
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "XW_SportsTestData",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<int>(type: "int", nullable: false, comment: "Id")
|
||
.Annotation("SqlServer:Identity", "1, 1"),
|
||
ExaminationId = table.Column<int>(type: "int", nullable: true, comment: "考试id"),
|
||
ExaminationName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "考试名称"),
|
||
ProjectType = table.Column<int>(type: "int", nullable: true, comment: "项目类型(1体检 2体质)"),
|
||
ProjectId = table.Column<int>(type: "int", nullable: true, comment: "项目ID"),
|
||
ProjectName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "项目名称"),
|
||
RosterType = table.Column<int>(type: "int", nullable: true, comment: "模式类型(1随堂模式2名单模式3刷卡或手动录入)"),
|
||
OrgId = table.Column<int>(type: "int", nullable: true, comment: "学校ID"),
|
||
GradeId = table.Column<int>(type: "int", nullable: true, comment: "年级ID"),
|
||
GradeName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "年级名称"),
|
||
ClassId = table.Column<int>(type: "int", nullable: true, comment: "班级或者名单id（根据roster_type来判断）"),
|
||
ClassName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "班级名称"),
|
||
GroupId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "组别"),
|
||
TeacherId = table.Column<int>(type: "int", nullable: true, comment: "老师ID"),
|
||
TeacherName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "老师名称"),
|
||
ModelType = table.Column<int>(type: "int", nullable: true, comment: "训练模式"),
|
||
MarkType = table.Column<int>(type: "int", nullable: true, comment: "评分标准类型(1国家标准2地方标准3自定义标准)"),
|
||
ProjectKind = table.Column<int>(type: "int", nullable: true, comment: "项目类型(1跳绳2跑步)"),
|
||
ProjectRuleId = table.Column<int>(type: "int", nullable: true, comment: "训练标准ID"),
|
||
ProjectKindName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "项目类型名称"),
|
||
MarkTypeName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "评分标准类型名称"),
|
||
ModelTypeName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "项目模式名称"),
|
||
TrainCount = table.Column<int>(type: "int", nullable: true, comment: "训练人数"),
|
||
StartTime = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "开始时间"),
|
||
EndTime = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "结束时间"),
|
||
MaleTotal = table.Column<int>(type: "int", nullable: true, comment: "男生总数"),
|
||
FemaleTotal = table.Column<int>(type: "int", nullable: true, comment: "女生总数"),
|
||
MaleCount = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生总成绩"),
|
||
MaleMaxCount = table.Column<int>(type: "int", nullable: true, comment: "男生最大值"),
|
||
MaleMinCount = table.Column<int>(type: "int", nullable: true, comment: "男生最小值"),
|
||
FemaleCount = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生总成绩"),
|
||
FemaleMaxCount = table.Column<int>(type: "int", nullable: true, comment: "女生最大值"),
|
||
FemaleMinCount = table.Column<int>(type: "int", nullable: true, comment: "女生最小值"),
|
||
MaleScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生总分数"),
|
||
MaleMaxScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生最大分数"),
|
||
MaleMinScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生最小分数"),
|
||
FemaleScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生总分数"),
|
||
FemaleMaxScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生最大分数"),
|
||
FemaleMinScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生最小分数"),
|
||
MaleFine = table.Column<int>(type: "int", nullable: true, comment: "男生优秀人数"),
|
||
MaleGood = table.Column<int>(type: "int", nullable: true, comment: "男生良好人数"),
|
||
MalePass = table.Column<int>(type: "int", nullable: true, comment: "男生及格人数"),
|
||
MaleFail = table.Column<int>(type: "int", nullable: true, comment: "男生不及格人数"),
|
||
FemaleFine = table.Column<int>(type: "int", nullable: true, comment: "女生优秀人数"),
|
||
FemaleGood = table.Column<int>(type: "int", nullable: true, comment: "女生良好人数"),
|
||
FemalePass = table.Column<int>(type: "int", nullable: true, comment: "女生及格人数"),
|
||
FemaleFail = table.Column<int>(type: "int", nullable: true, comment: "女生不及格人数"),
|
||
PassingRate = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "及格率"),
|
||
MaleAvgCount = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生平均个数"),
|
||
FemaleAvgCount = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生平均个数"),
|
||
MaleAvgScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生平均分数"),
|
||
FemaleAvgScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生平均分数"),
|
||
MaleMedianCount = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生中位数"),
|
||
FemaleMedianCount = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生中位数"),
|
||
MaleAvgImproveCount = table.Column<int>(type: "int", nullable: true, comment: "男生平均值"),
|
||
MaleMaxImproveCount = table.Column<int>(type: "int", nullable: true, comment: "男生最大值"),
|
||
MaleMinImproveCount = table.Column<int>(type: "int", nullable: true, comment: "男生最小值"),
|
||
FemaleAvgImproveCount = table.Column<int>(type: "int", nullable: true, comment: "女生平均值"),
|
||
FemaleMaxImproveCount = table.Column<int>(type: "int", nullable: true, comment: "女生最大值"),
|
||
FemaleMinImproveCount = table.Column<int>(type: "int", nullable: true, comment: "女生最小值"),
|
||
MaleAvgImproveScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生平均分数"),
|
||
MaleMaxImproveScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生最大分数"),
|
||
MaleMinImproveScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "男生最小分数"),
|
||
FemaleAvgImproveScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生平均分数"),
|
||
FemaleMaxImproveScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生最大分数"),
|
||
FemaleMinImproveScore = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生最小分数"),
|
||
MinErrorCount = table.Column<int>(type: "int", nullable: true, comment: "失误最少的同学次数"),
|
||
MinIntoStateTime = table.Column<int>(type: "int", nullable: true, comment: "进入状态最快的同学耗时（心率借用这个字段。班级运动时间）"),
|
||
MinAvgTime = table.Column<int>(type: "int", nullable: true, comment: "第一名平均耗时"),
|
||
TotalErrorCount = table.Column<int>(type: "int", nullable: true, comment: "失误总次数"),
|
||
LossesCount1 = table.Column<int>(type: "int", nullable: true, comment: "失误损失次数"),
|
||
LossesCount2 = table.Column<int>(type: "int", nullable: true, comment: "甩绳速度偏慢损失次数"),
|
||
LossesCount3 = table.Column<int>(type: "int", nullable: true, comment: "进入状态过慢损失次数"),
|
||
CheckCode = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "提交标识"),
|
||
CreateTime = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "创建时间"),
|
||
CreateBy = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "创建人"),
|
||
UpdateTime = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "修改时间"),
|
||
UpdateBy = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "修改人"),
|
||
DoubleFlag = table.Column<bool>(type: "bit", nullable: true, comment: "是否双人模式"),
|
||
Source = table.Column<int>(type: "int", nullable: true, comment: "数据来源(1:pad, 2:微信小程序)"),
|
||
StudentName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "学生姓名")
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_XW_SportsTestData", x => x.Id);
|
||
});
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "XW_TrainSetting",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<int>(type: "int", nullable: false, comment: "Id")
|
||
.Annotation("SqlServer:Identity", "1, 1"),
|
||
TrainId = table.Column<int>(type: "int", nullable: true, comment: "训练ID"),
|
||
CircleCount = table.Column<int>(type: "int", nullable: true, comment: "圈数"),
|
||
CircleInterval = table.Column<int>(type: "int", nullable: true, comment: "每圈时间间隔"),
|
||
FirstCircleWhole = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "首圈是否整圈(1-不完整，2-完整)"),
|
||
FirstCircleInterval = table.Column<int>(type: "int", nullable: true, comment: "首圈时间间隔"),
|
||
DecimalPlace = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "保留秒以下的小数位数"),
|
||
CircleCountGirl = table.Column<int>(type: "int", nullable: true, comment: "女生圈数"),
|
||
CircleIntervalGirl = table.Column<int>(type: "int", nullable: true, comment: "女生每圈时间间隔"),
|
||
FirstCircleWholeGirl = table.Column<decimal>(type: "decimal(18,2)", nullable: true, comment: "女生首圈是否整圈(1-不完整，2-完整)"),
|
||
FirstCircleIntervalGirl = table.Column<int>(type: "int", nullable: true, comment: "女生首圈时间间隔"),
|
||
CreateTime = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "创建时间"),
|
||
CreateBy = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "创建人"),
|
||
XW_SportsTestDataId = table.Column<int>(type: "int", nullable: false)
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_XW_TrainSetting", x => x.Id);
|
||
});
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "XW_CameraInfo",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<int>(type: "int", nullable: false, comment: "编号")
|
||
.Annotation("SqlServer:Identity", "1, 1"),
|
||
SerialNumber = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "摄像头序列号"),
|
||
Version = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "摄像头版本信息"),
|
||
XW_DeviceId = table.Column<int>(type: "int", nullable: false)
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_XW_CameraInfo", x => x.Id);
|
||
table.ForeignKey(
|
||
name: "FK_XW_CameraInfo_XW_Device_XW_DeviceId",
|
||
column: x => x.XW_DeviceId,
|
||
principalTable: "XW_Device",
|
||
principalColumn: "Id",
|
||
onDelete: ReferentialAction.Cascade);
|
||
});
|
||
|
||
migrationBuilder.CreateTable(
|
||
name: "XW_TrainStudents",
|
||
columns: table => new
|
||
{
|
||
Id = table.Column<int>(type: "int", nullable: false, comment: "Id")
|
||
.Annotation("SqlServer:Identity", "1, 1"),
|
||
TrainId = table.Column<int>(type: "int", nullable: true, comment: "训练ID"),
|
||
ProjectId = table.Column<int>(type: "int", nullable: true, comment: "项目ID"),
|
||
ProjectKind = table.Column<double>(type: "float", nullable: true, comment: "项目类型(1跳绳2跑步)"),
|
||
OrgId = table.Column<int>(type: "int", nullable: true, comment: "学校ID"),
|
||
GradeId = table.Column<int>(type: "int", nullable: true, comment: "年级ID"),
|
||
GradeName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "年级名称"),
|
||
ClassId = table.Column<int>(type: "int", nullable: true, comment: "班级ID"),
|
||
ClassName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "班级名称"),
|
||
GroupName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "组别"),
|
||
GroupOrder = table.Column<int>(type: "int", nullable: true, comment: "组号"),
|
||
TeacherId = table.Column<int>(type: "int", nullable: true, comment: "老师ID"),
|
||
DeviceId = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "设备ID"),
|
||
StudentId = table.Column<int>(type: "int", nullable: true, comment: "学生ID"),
|
||
StudentName = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "学生名称"),
|
||
Sex = table.Column<double>(type: "float", nullable: true, comment: "性别(1男2女)"),
|
||
StudentNo = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "学号"),
|
||
Achievement = table.Column<int>(type: "int", nullable: true, comment: "标准成绩"),
|
||
OriginalAchievement = table.Column<int>(type: "int", nullable: true, comment: "原始标准成绩（被格式化小数点之前的）"),
|
||
Achievement2 = table.Column<int>(type: "int", nullable: true, comment: "标准成绩2"),
|
||
OriginalAchievement2 = table.Column<int>(type: "int", nullable: true, comment: "原始标准成绩2（被格式化小数点之前的）"),
|
||
Score = table.Column<double>(type: "float", nullable: true, comment: "得分"),
|
||
PlusesScore = table.Column<double>(type: "float", nullable: true, comment: "加分项得分"),
|
||
Rating = table.Column<int>(type: "int", nullable: true, comment: "评分等级"),
|
||
RankingInGender = table.Column<int>(type: "int", nullable: true, comment: "男生或女生排名"),
|
||
Ranking = table.Column<int>(type: "int", nullable: true, comment: "全体排名"),
|
||
ErrorCount = table.Column<int>(type: "int", nullable: true, comment: "失误总次数"),
|
||
ErrorTime = table.Column<int>(type: "int", nullable: true, comment: "失误总耗时"),
|
||
AvgTime = table.Column<int>(type: "int", nullable: true, comment: "平均耗时"),
|
||
MedianTime = table.Column<int>(type: "int", nullable: true, comment: "有效平均值(中位数)"),
|
||
LossesCount1 = table.Column<int>(type: "int", nullable: true, comment: "失误损失次数"),
|
||
LossesCount2 = table.Column<int>(type: "int", nullable: true, comment: "甩绳速度偏慢损失次数"),
|
||
LossesCount3 = table.Column<int>(type: "int", nullable: true, comment: "进入状态过慢损失次数"),
|
||
HigherScore = table.Column<int>(type: "int", nullable: true, comment: "高一档分数段"),
|
||
IntoStateTime = table.Column<int>(type: "int", nullable: true, comment: "进入状态耗时"),
|
||
ImproveCount = table.Column<int>(type: "int", nullable: true, comment: "次数提升空间"),
|
||
ImproveScore = table.Column<double>(type: "float", nullable: true, comment: "分数提升空间"),
|
||
FamilySendFlag = table.Column<int>(type: "int", nullable: true, comment: "家长消息发送标识"),
|
||
Completed = table.Column<bool>(type: "bit", nullable: true, comment: "是否已经完成"),
|
||
QuantityCompleted = table.Column<int>(type: "int", nullable: true, comment: "实际完成的数量（圈数）"),
|
||
ModelType = table.Column<int>(type: "int", nullable: true, comment: "报表显示"),
|
||
StartTime = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "开始时间"),
|
||
Teacher = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "教师"),
|
||
CreateTime = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "创建时间"),
|
||
CreateBy = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "创建人"),
|
||
UpdateTime = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "修改时间"),
|
||
UpdateBy = table.Column<string>(type: "nvarchar(max)", nullable: true, comment: "修改人"),
|
||
XW_SportsTestDataId = table.Column<int>(type: "int", nullable: true)
|
||
},
|
||
constraints: table =>
|
||
{
|
||
table.PrimaryKey("PK_XW_TrainStudents", x => x.Id);
|
||
table.ForeignKey(
|
||
name: "FK_XW_TrainStudents_XW_SportsTestData_XW_SportsTestDataId",
|
||
column: x => x.XW_SportsTestDataId,
|
||
principalTable: "XW_SportsTestData",
|
||
principalColumn: "Id");
|
||
});
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_XW_CameraInfo_XW_DeviceId",
|
||
table: "XW_CameraInfo",
|
||
column: "XW_DeviceId");
|
||
|
||
migrationBuilder.CreateIndex(
|
||
name: "IX_XW_TrainStudents_XW_SportsTestDataId",
|
||
table: "XW_TrainStudents",
|
||
column: "XW_SportsTestDataId");
|
||
}
|
||
|
||
protected override void Down(MigrationBuilder migrationBuilder)
|
||
{
|
||
migrationBuilder.DropTable(
|
||
name: "XW_CameraInfo");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "XW_TrainSetting");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "XW_TrainStudents");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "XW_Device");
|
||
|
||
migrationBuilder.DropTable(
|
||
name: "XW_SportsTestData");
|
||
}
|
||
}
|
||
}
|