using Furion.DatabaseAccessor;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace YBEE.EQM.Core;

/// <summary>
/// 有效分分析：学科有效分
/// </summary>
[Comment("有效分分析：学科有效分")]
public class EsaLineCourseScore : IEntity
{
    /// <summary>
    /// 主键
    /// </summary>
    [Comment("主键")]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    [Key, Required]
    public int Id { get; set; }
    /// <summary>
    /// 分析级别
    /// </summary>
    [Comment("分析级别")]
    [Required, Column(TypeName = "smallint")]
    public EsaLevel EsaLevel { get; set; }
    /// <summary>
    /// 分析计划ID
    /// </summary>
    [Comment("分析计划ID")]
    public int EsaPlanId { get; set; }
    /// <summary>
    /// 基线ID
    /// </summary>
    [Comment("基线ID")]
    [Required]
    public int EsaBaseLineId { get; set; }
    /// <summary>
    /// 机构ID
    /// </summary>
    [Comment("机构ID")]
    public short? SysOrgId { get; set; }
    /// <summary>
    /// 年级ID
    /// </summary>
    [Comment("年级ID")]
    [Required]
    public short GradeId { get; set; }
    /// <summary>
    /// 划线等级
    /// </summary>
    [Comment("划线等级")]
    [Required, Column(TypeName = "smallint")]
    public EsaLineLevel EsaLineLevel { get; set; }
    /// <summary>
    /// 科目ID
    /// </summary>
    [Comment("科目ID")]
    [Required]
    public short CourseId { get; set; }

    /// <summary>
    /// 平均分
    /// </summary>
    [Comment("平均分")]
    [Required, Column(TypeName = "decimal(10, 2)")]
    public decimal AvgScore { get; set; } = 0;
    /// <summary>
    /// 上线平均分
    /// </summary>
    [Comment("上线平均分")]
    [Required, Column(TypeName = "decimal(10, 2)")]
    public decimal LineAvgScore { get; set; } = 0;
    /// <summary>
    /// 有效分
    /// </summary>
    [Comment("有效分")]
    [Required, Column(TypeName = "decimal(10, 2)")]
    public decimal LineScore { get; set; } = 0;
    /// <summary>
    /// 相对差
    /// </summary>
    [Comment("相对差")]
    [Required, Column(TypeName = "decimal(10, 8)")]
    public decimal RelativeDiff { get; set; } = 0;
}