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

namespace MES.Service.Modes;

/// <summary>
///     检验项目主表
/// </summary>
[Table("MES_QA")]
[SugarTable("MES_QA")] //用于SqlSugar
public class MesQa
{
    /// <summary>
    ///     创建人
    /// </summary>
    [Column("CREATE_BY")]
    [SugarColumn(ColumnName = "CREATE_BY")] //用于SqlSugar
    [StringLength(20, ErrorMessage = "创建人长度不能超出20")]
    public string? CreateBy { get; set; }

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

    /// <summary>
    ///     审核状态
    /// </summary>
    [Column("FSUBMIT")]
    [SugarColumn(ColumnName = "FSUBMIT")] //用于SqlSugar
    public decimal? Fsubmit { get; set; }

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

    /// <summary>
    ///     审核时间
    /// </summary>
    [Column("FSUBMIT_DATE")]
    [SugarColumn(ColumnName = "FSUBMIT_DATE")] //用于SqlSugar
    public DateTime? FsubmitDate { get; set; }

    /// <summary>
    ///     序列SEQ_QS
    /// </summary>
    [Column("ID")]
    [SugarColumn(ColumnName = "ID")] //用于SqlSugar
    public decimal? Id { get; set; }

    /// <summary>
    ///     物料编号
    /// </summary>
    [Column("ITEM_NO")]
    [SugarColumn(ColumnName = "ITEM_NO")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "物料编号长度不能超出50")]
    public string? ItemNo { get; set; }

    /// <summary>
    ///     1为首检，2为巡检，3为入库检
    /// </summary>
    [Column("QS_TYPE")]
    [SugarColumn(ColumnName = "QS_TYPE")] //用于SqlSugar
    [StringLength(1, ErrorMessage = "1为首检，2为巡检，3为入库检长度不能超出1")]
    public string? QsType { get; set; }
}