using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     AQL抽样基准样本量子码
/// </summary>
[Table("MES_QM_AQL2")]
[SugarTable("MES_QM_AQL2")] //用于SqlSugar
public class MesQmAql2
{
    /// <summary>
    ///     ID(seq_me_id)
    /// </summary>
    [Key]
    [Column("ID")]
    [SugarColumn(ColumnName = "ID")] //用于SqlSugar
    public decimal Id { get; set; }

    /// <summary>
    ///     AQL抽样基准ID
    /// </summary>
    [Column("AQL1_ID")]
    [SugarColumn(ColumnName = "AQL1_ID")] //用于SqlSugar
    public decimal? Aql1Id { get; set; }

    /// <summary>
    /// </summary>
    [Column("COMPANY")]
    [SugarColumn(ColumnName = "COMPANY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "Company长度不能超出20")]
    public string Company { get; set; }

    /// <summary>
    ///     创建人
    /// </summary>
    [Column("CREATE_BY")]
    [SugarColumn(ColumnName = "CREATE_BY")] //用于SqlSugar
    [StringLength(32, ErrorMessage = "创建人长度不能超出32")]
    public string CreateBy { get; set; }

    /// <summary>
    ///     创建时间
    /// </summary>
    [Column("CREATE_DATE")]
    [SugarColumn(ColumnName = "CREATE_DATE")] //用于SqlSugar
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     创建人姓名
    /// </summary>
    [Column("CREATE_NAME")]
    [SugarColumn(ColumnName = "CREATE_NAME")] //用于SqlSugar
    [StringLength(32, ErrorMessage = "创建人姓名长度不能超出32")]
    public string CreateName { get; set; }

    /// <summary>
    ///     修改/新增状态
    /// </summary>
    [Column("EDIT_STATUS")]
    [SugarColumn(ColumnName = "EDIT_STATUS")] //用于SqlSugar
    public decimal? EditStatus { get; set; }

    /// <summary>
    /// </summary>
    [Column("FACTORY")]
    [SugarColumn(ColumnName = "FACTORY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "Factory长度不能超出20")]
    public string Factory { get; set; }

    /// <summary>
    ///     一般检验水平|I
    /// </summary>
    [Column("FLEVEL_I")]
    [SugarColumn(ColumnName = "FLEVEL_I")] //用于SqlSugar
    [StringLength(1, ErrorMessage = "一般检验水平|I长度不能超出1")]
    public string FlevelI { get; set; }

    /// <summary>
    ///     一般检验水平|II
    /// </summary>
    [Column("FLEVEL_II")]
    [SugarColumn(ColumnName = "FLEVEL_II")] //用于SqlSugar
    [StringLength(1, ErrorMessage = "一般检验水平|II长度不能超出1")]
    public string FlevelIi { get; set; }

    /// <summary>
    ///     一般检验水平|III
    /// </summary>
    [Column("FLEVEL_III")]
    [SugarColumn(ColumnName = "FLEVEL_III")] //用于SqlSugar
    [StringLength(1, ErrorMessage = "一般检验水平|III长度不能超出1")]
    public string FlevelIii { get; set; }

    /// <summary>
    ///     特殊检验水平|S-1
    /// </summary>
    [Column("FLEVEL_S1")]
    [SugarColumn(ColumnName = "FLEVEL_S1")] //用于SqlSugar
    [StringLength(1, ErrorMessage = "特殊检验水平|S-1长度不能超出1")]
    public string FlevelS1 { get; set; }

    /// <summary>
    ///     特殊检验水平|S-2
    /// </summary>
    [Column("FLEVEL_S2")]
    [SugarColumn(ColumnName = "FLEVEL_S2")] //用于SqlSugar
    [StringLength(1, ErrorMessage = "特殊检验水平|S-2长度不能超出1")]
    public string FlevelS2 { get; set; }

    /// <summary>
    ///     特殊检验水平|S-3
    /// </summary>
    [Column("FLEVEL_S3")]
    [SugarColumn(ColumnName = "FLEVEL_S3")] //用于SqlSugar
    [StringLength(1, ErrorMessage = "特殊检验水平|S-3长度不能超出1")]
    public string FlevelS3 { get; set; }

    /// <summary>
    ///     特殊检验水平|S-4
    /// </summary>
    [Column("FLEVEL_S4")]
    [SugarColumn(ColumnName = "FLEVEL_S4")] //用于SqlSugar
    [StringLength(1, ErrorMessage = "特殊检验水平|S-4长度不能超出1")]
    public string FlevelS4 { get; set; }

    /// <summary>
    ///     最后更新人
    /// </summary>
    [Column("LASTUPDATE_BY")]
    [SugarColumn(ColumnName = "LASTUPDATE_BY")] //用于SqlSugar
    [StringLength(32, ErrorMessage = "最后更新人长度不能超出32")]
    public string LastupdateBy { get; set; }

    /// <summary>
    ///     最后更新时间
    /// </summary>
    [Column("LASTUPDATE_DATE")]
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //用于SqlSugar
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     更新人姓名
    /// </summary>
    [Column("LASTUPDATE_NAME")]
    [SugarColumn(ColumnName = "LASTUPDATE_NAME")] //用于SqlSugar
    [StringLength(32, ErrorMessage = "更新人姓名长度不能超出32")]
    public string LastupdateName { get; set; }

    /// <summary>
    ///     批量开始
    /// </summary>
    [Column("LOT_FROM")]
    [SugarColumn(ColumnName = "LOT_FROM")] //用于SqlSugar
    public decimal? LotFrom { get; set; }

    /// <summary>
    ///     批量结束
    /// </summary>
    [Column("LOT_TO")]
    [SugarColumn(ColumnName = "LOT_TO")] //用于SqlSugar
    public decimal? LotTo { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [Column("MEMO")]
    [SugarColumn(ColumnName = "MEMO")] //用于SqlSugar
    [StringLength(255, ErrorMessage = "备注长度不能超出255")]
    public string Memo { get; set; }
}