YD_SmartSports.Api/VOL.Entity/DomainModels/Ai/Ai_SportsTestData.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using VOL.Entity.Enum;
using VOL.Entity.SystemModels;

namespace VOL.Entity.DomainModels
{
    /// <summary>
    /// Ai体测数据
    /// </summary>
    [Table("Ai_SportsTestData")]
    [Entity(TableCnName = "Ai训练数据表", TableName = "Ai_SportsTestData")]
    public class Ai_SportsTestData : BaseEntity
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        [Display(Description = "主键Id")]
        [Comment("Id")]
        public int Id { get; set; }

        /// <summary>
        ///学校Code
        /// </summary>
        [Display(Name = "学校Code")]
        [Comment("学校Code")]
        [Column(TypeName = "nvarchar(100)")]
        public string SchoolCode { get; set; }

        /// <summary>
        /// AI设备的唯一编码
        /// </summary>
        [Display(Name = "AI设备的唯一编码")]
        [Comment("AI设备的唯一编码")]
        [Column(TypeName = "nvarchar(100)")]
        public string Code { get; set; }

        /// <summary>
        /// 课堂记录Id
        /// </summary>
        [Display(Name = "课堂记录Id")]
        [Comment("课堂记录Id")]
        [Column(TypeName = "int")]
        public int ClassRoomRecordId { get; set; }

        /// <summary>
        /// Ai赛场Id
        /// </summary>
        [Display(Name = "Ai赛场Id")]
        [Comment("Ai赛场Id")]
        [Column(TypeName = "int")]
        public int? ActivitiesId { get; set; }

        /// <summary>
        /// 设备上传成绩时唯一标识, 重复时服务端不保存数据
        /// </summary>
        [Display(Name = "设备上传成绩时唯一标识, 重复时服务端不保存数据")]
        [Comment("设备上传成绩时唯一标识, 重复时服务端不保存数据")]
        public long UniqueId { get; set; }

        /// <summary>
        /// 年级编号
        /// </summary>
        [Display(Name = "年级编号")]
        [Comment("年级编号")]
        [Column(TypeName = "int")]
        public int GradeId { get; set; }

        /// <summary>
        ///班级Id
        /// </summary>
        [Display(Name = "班级Id")]
        [Comment("班级Id")]
        [Column(TypeName = "int")]
        public int ClassId { get; set; }

        /// <summary>
        /// 年级名称
        /// </summary>
        [Display(Name = "年级名称")]
        [Comment("年级名称")]
        [Column(TypeName = "nvarchar(100)")]
        public string GradeName { get; set; }

        /// <summary>
        /// 班级名称
        /// </summary>
        [Display(Name = "班级名称")]
        [Comment("班级名称")]
        [Column(TypeName = "nvarchar(100)")]
        public string ClassName { get; set; }

        /// <summary>
        /// 班级人数
        /// </summary>
        [Display(Name = "班级人数")]
        [Comment("班级人数")]
        [Column(TypeName = "int")]
        public int? StudentCount { get; set; }

        /// <summary>
        ///老师Id
        /// </summary>
        [Display(Name = "老师Id")]
        [Comment("老师Id")]
        [Column(TypeName = "int")]
        public int TeacherId { get; set; }

        /// <summary>
        /// 模式类型
        /// </summary>
        [Display(Name = "模式类型")]
        [Comment("模式类型")]
        [Column(TypeName = "int")]
        public Ai_ModeEnum ModeType { get; set; }

        /// <summary>
        /// 模式名称
        /// </summary>
        [Display(Name = "模式名称")]
        [Comment("模式名称")]
        [Column(TypeName = "nvarchar(100)")]
        public string ModelName { get; set; }

        /// <summary>
        /// 训练模块[[1:专项教学/2:测评考级/3:AI赛场/4:AI体测]
        /// </summary>
        [Display(Name = "训练模块[[1:专项教学/2:测评考级/3:AI赛场/4:AI体测]")]
        [Comment("训练模块[[1:专项教学/2:测评考级/3:AI赛场/4:AI体测]")]
        [Column(TypeName = "int")]
        public Ai_TrainingModuleEnum TrainingModule { get; set; }

        /// <summary>
        /// 数据类型[1:训练数据/2:体测数据]
        /// </summary>
        [Display(Name = "模式类型")]
        [Comment("模式类型")]
        [Column(TypeName = "int")]
        public SportsTestDataType DataType { get; set; }

        /// <summary>
        /// 项目类型
        /// </summary>
        [Display(Name = "项目类型")]
        [Comment("项目类型")]
        [Column(TypeName = "int")]
        public int CategoryValue { get; set; }

        /// <summary>
        /// 开始时间
        /// </summary>
        [Display(Name = "开始时间")]
        [Comment("开始时间")]
        [Column(TypeName = "datetime")]
        public DateTime? StartTime { get; set; }

        /// <summary>
        /// 结束时间
        /// </summary>
        [Display(Name = "结束时间")]
        [Comment("结束时间")]
        [Column(TypeName = "datetime")]
        public DateTime? EndTime { get; set; }

        /// <summary>
        ///测试时间
        /// </summary>
        [Display(Name = "测试时间")]
        [Comment("测试时间")]
        [Column(TypeName = "datetime")]
        [Editable(true)]
        public DateTime ScoreTime { get; set; }

        /// <summary>
        ///学号
        /// </summary>
        [Display(Name = "学号")]
        [Comment("学号")]
        [Column(TypeName = "nvarchar(100)")]
        public string StudentNo { get; set; }

        /// <summary>
        ///姓名
        /// </summary>
        [Display(Name = "姓名")]
        [Comment("姓名")]
        [Column(TypeName = "nvarchar(100)")]
        public string StudentName { get; set; }

        /// <summary>
        ///性别
        /// </summary>
        [Display(Name = "性别")]
        [Comment("学校Co性别de")]
        [Column(TypeName = "int")]
        public SexType Sex { get; set; }

        /// <summary>
        /// 测试成绩
        /// </summary>
        [Display(Name = "测试成绩")]
        [Comment("测试成绩")]
        [Column(TypeName = "float")]
        public double Value { get; set; }

        /// <summary>
        ///运动时长/分钟
        /// </summary>
        [Display(Name = "运动时长/分钟")]
        [Comment("运动时长/分钟")]
        [Column(TypeName = "int")]
        public int? MotionDuration { get; set; }

        /// <summary>
        ///得分
        /// </summary>
        [Display(Name = "得分")]
        [Comment("得分")]
        [Column(TypeName = "float")]
        public float Score { get; set; }

        /// <summary>
        ///附加分
        /// </summary>
        [Display(Name = "附加分")]
        [Comment("附加分")]
        [Column(TypeName = "float")]
        public float AdditionalScore { get; set; }

        /// <summary>
        /// 训练成绩等级[1:优秀,2:良好,3:及格,4:不及格]
        /// 心率项目[1:达标,2:未达标]
        /// </summary>
        [Display(Name = "训练成绩等级")]
        [Comment("训练成绩等级")]
        [Column(TypeName = "int")]
        public AchievementRank RankEnum { get; set; }

        /// <summary>
        /// 等级 
        /// </summary>
        [Display(Name = "等级")]
        [Comment("等级")]
        [Column(TypeName = "nvarchar(100)")]
        public string Rank { get; set; }

        /// <summary>
        ///错误个数[敏捷：错误个数]
        /// </summary>
        [Display(Name = "错误个数")]
        [Comment("错误个数")]
        [Column(TypeName = "int")]
        public int? ErrorNumber { get; set; }

        /// <summary>
        ///正确个数[敏捷：正确个数]
        /// </summary>
        [Display(Name = "正确个数")]
        [Comment("正确个数")]
        [Column(TypeName = "int")]
        public int? CorrectNumber { get; set; }

        /// <summary>
        ///最大
        /// </summary>
        [Display(Name = "最大")]
        [Comment("最大")]
        [Column(TypeName = "int")]
        public double? MaxValue { get; set; }

        /// <summary>
        ///最小
        /// </summary>
        [Display(Name = "最小")]
        [Comment("最小")]
        [Column(TypeName = "int")]
        public double? MinValue { get; set; }

        /// <summary>
        /// 设备评价语
        /// </summary>
        [Display(Name = "设备评价语")]
        [Comment("设备评价语")]
        [Column(TypeName = "nvarchar(4000)")]
        public string Remark { get; set; }

        /// <summary>
        /// 持续时间
        /// </summary>
        [Display(Name = "持续时间")]
        [Comment("持续时间")]
        [Column(TypeName = "int")]
        public int? Duration { get; set; }

        /// <summary>
        /// 错误成绩
        /// </summary>
        [Display(Name = "错误成绩")]
        [Comment("错误成绩")]
        [Column(TypeName = "float")]
        public float? WrongResults { get; set; }

        /// <summary>
        /// 动作解析
        /// </summary>
        [Display(Name = "动作解析")]
        [Comment("动作解析")]
        [Column(TypeName = "nvarchar(4000)")]
        public string? CorrectJudge { get; set; }

        /// <summary>
        /// 身高[单位：厘米]
        /// </summary>
        [Display(Name = "身高")]
        [Comment("身高")]
        [Column(TypeName = "float")]
        public float? Height { get; set; }

        /// <summary>
        /// 体重[单位：千克]
        /// </summary>
        [Display(Name = "体重")]
        [Comment("体重")]
        [Column(TypeName = "float")]
        public float? Weight { get; set; }

        /// <summary>
        /// 当前年份
        /// </summary>
        [Display(Name = "当前年份")]
        [Comment("当前年份")]
        [Column(TypeName = "int)")]
        public int Year { get; set; }

        /// <summary>
        /// 学期
        /// </summary>
        [Display(Name = "学期")]
        [Comment("学期")]
        [Column(TypeName = "int)")]
        public SemesterEnum Semester { get; set; }

        /// <summary>
        /// 文件名称
        /// </summary>
        [Display(Name = "文件名称")]
        [Comment("文件名称")]
        [Column(TypeName = "nvarchar(2000)")]
        public string? FileName { get; set; }

        /// <summary>
        /// 文件路径
        /// </summary>
        [Display(Name = "文件路径")]
        [Comment("文件路径")]
        [Column(TypeName = "nvarchar(2000)")]
        public string? FileUrl { get; set; }

        /// <summary>
        /// 是否显示
        /// </summary>
        [Display(Name = "是否显示")]
        [Comment("是否显示")]
        [Column(TypeName = "bit")]
        [Editable(true)]
        public bool IsDisplay { get; set; }

        /// <summary>
        /// 导航属性
        /// </summary>
        //public List<Ai_SportsTestVideo> FileList { get; set; }
    }
}