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

namespace MES.Service.Modes;

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

    /// <summary>
    ///     公司
    /// </summary>
    [Column("COMPANY")]
    [SugarColumn(ColumnName = "COMPANY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "公司长度不能超出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(100, ErrorMessage = "所属工厂长度不能超出100")]
    public string Factory { get; set; }

    /// <summary>
    ///     审批日期
    /// </summary>
    [Column("FONE_CHECKDATE")]
    [SugarColumn(ColumnName = "FONE_CHECKDATE")] //用于SqlSugar
    public DateTime? FoneCheckdate { get; set; }

    /// <summary>
    ///     审批标记
    /// </summary>
    [Column("FONE_CHECKED")]
    [SugarColumn(ColumnName = "FONE_CHECKED")] //用于SqlSugar
    public decimal? FoneChecked { get; set; }

    /// <summary>
    ///     审批人
    /// </summary>
    [Column("FONE_CHECKOR")]
    [SugarColumn(ColumnName = "FONE_CHECKOR")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "审批人长度不能超出50")]
    public string FoneCheckor { get; set; }

    /// <summary>
    ///     确认日期
    /// </summary>
    [Column("FTWO_CHECKDATE")]
    [SugarColumn(ColumnName = "FTWO_CHECKDATE")] //用于SqlSugar
    public DateTime? FtwoCheckdate { get; set; }

    /// <summary>
    ///     确认标记
    /// </summary>
    [Column("FTWO_CHECKED")]
    [SugarColumn(ColumnName = "FTWO_CHECKED")] //用于SqlSugar
    public decimal? FtwoChecked { get; set; }

    /// <summary>
    ///     确认人
    /// </summary>
    [Column("FTWO_CHECKOR")]
    [SugarColumn(ColumnName = "FTWO_CHECKOR")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "确认人长度不能超出50")]
    public string FtwoCheckor { get; set; }

    /// <summary>
    ///     版本号
    /// </summary>
    [Column("FVERSION")]
    [SugarColumn(ColumnName = "FVERSION")] //用于SqlSugar
    public decimal? Fversion { get; set; }

    /// <summary>
    ///     是否可用
    /// </summary>
    [Column("ISENABLED")]
    [SugarColumn(ColumnName = "ISENABLED")] //用于SqlSugar
    public decimal? Isenabled { 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("MEMO")]
    [SugarColumn(ColumnName = "MEMO")] //用于SqlSugar
    [StringLength(255, ErrorMessage = "备注信息长度不能超出255")]
    public string Memo { get; set; }

    /// <summary>
    ///     标准名称
    /// </summary>
    [Column("SAMPLE_SIZE_NAME")]
    [SugarColumn(ColumnName = "SAMPLE_SIZE_NAME")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "标准名称长度不能超出50")]
    public string SampleSizeName { get; set; }

    /// <summary>
    ///     标准编码
    /// </summary>
    [Column("SAMPLE_SIZE_NO")]
    [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "标准编码长度不能超出50")]
    public string SampleSizeNo { get; set; }
}