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

namespace MES.Service.Modes;

/// <summary>
///     巡检孙表
/// </summary>
[Table("QS_QA_ITEM_XJ02")]
[SugarTable("QS_QA_ITEM_XJ02")] //用于SqlSugar
public class QsQaItemXj02
{
    /// <summary>
    ///     创建人
    /// </summary>
    [Column("CREATE_BY")]
    [SugarColumn(ColumnName = "CREATE_BY")] //用于SqlSugar
    [StringLength(50, ErrorMessage = "创建人长度不能超出50")]
    public string? CreateBy { get; set; }

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

    /// <summary>
    ///     检验结果
    /// </summary>
    [Column("FCHECK_RESU")]
    [SugarColumn(ColumnName = "FCHECK_RESU")] //用于SqlSugar
    [StringLength(100, ErrorMessage = "检验结果长度不能超出100")]
    public string? FcheckResu { get; set; }

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

    /// <summary>
    ///     巡检主表id
    /// </summary>
    [Column("GID")]
    [SugarColumn(ColumnName = "GID")] //用于SqlSugar
    public decimal? Gid { get; set; }

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

    /// <summary>
    ///     首检子表id
    /// </summary>
    [Column("PID")]
    [SugarColumn(ColumnName = "PID")] //用于SqlSugar
    public decimal? Pid { get; set; }

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

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

    [Column("Remarks")]
    [SugarColumn(ColumnName = "Remarks")] //用于SqlSugar
    [StringLength(200, ErrorMessage = "备注不能超出200")]
    public string? Remarks { get; set; }

    [SugarColumn(IsIgnore = true)] public int? count { get; set; }
}