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

namespace MES.Service.Modes;

/// <summary>
/// 超期检验结果表 MES_CQ_ITEMS_DETECT_DETAIL12
/// </summary>
[Table("MES_CQ_ITEMS_DETECT_DETAIL12")]
[SugarTable("MES_CQ_ITEMS_DETECT_DETAIL12")]
public class MesCqItemsDetectDetail12
{
    /// <summary>
    /// 主键ID
    /// </summary>
    [Column("ID")]
    [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_CQ_ID", ColumnName = "ID")]
    public decimal? Id { get; set; }

    /// <summary>
    /// 主表ID（关联MES_CQ_ITEMS_DETECT_DETAIL5）
    /// </summary>
    [SugarColumn(ColumnName = "MAIN_ID")]
    public decimal? MainId { get; set; }

    /// <summary>
    /// 检验单号
    /// </summary>
    [SugarColumn(ColumnName = "RELEASE_NO")]
    public string? ReleaseNo { get; set; }

    /// <summary>
    /// 标准值
    /// </summary>
    [SugarColumn(ColumnName = "FSTAND")]
    public string? Fstand { get; set; }

    /// <summary>
    /// 检验结果
    /// </summary>
    [SugarColumn(ColumnName = "FCHECK_RESU")]
    public string? FcheckResu { get; set; }

    /// <summary>
    /// 创建人
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string? CreateBy { get; set; }

    /// <summary>
    /// 创建日期
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    /// 更新人
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string? LastupdateBy { get; set; }

    /// <summary>
    /// 更新日期（数据库中不存在此字段）
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    /// 工厂
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY")]
    public string? Factory { get; set; }

    /// <summary>
    /// 公司
    /// </summary>
    [SugarColumn(ColumnName = "COMPANY")]
    public string? Company { get; set; }

    /// <summary>
    /// 数量（用于批量插入）
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public int? count { get; set; }
}