using SqlSugar;

namespace MES.Service.Modes;

[SugarTable("INSPECTOR_CHANGE_LOG")]
public class InspectorChangeLog
{
    /// <summary>
    ///     主键，唯一标识
    /// </summary>
    [SugarColumn(ColumnName = "CHANGE_ID", IsPrimaryKey = true,
        IsIdentity = true)]
    public long ChangeId { get; set; }

    /// <summary>
    ///     检验单号
    /// </summary>
    [SugarColumn(ColumnName = "INSPECTION_NO", Length = 50, IsNullable = false)]
    public string? InspectionNo { get; set; }

    /// <summary>
    ///     检验员
    /// </summary>
    [SugarColumn(ColumnName = "INSPECTOR", Length = 50, IsNullable = false)]
    public string? Inspector { get; set; }

    /// <summary>
    ///     修改时间（默认当前时间）
    /// </summary>

    [SugarColumn(ColumnName = "CHANGE_TIME", DefaultValue = "SYSDATE")]
    public DateTime? ChangeTime { get; set; }

    /// <summary>
    ///     修改人
    /// </summary>

    [SugarColumn(ColumnName = "CHANGED_BY", Length = 50, IsNullable = false)]
    public string? ChangedBy { get; set; }

    /// <summary>
    ///     是否有效（Y:有效 N：无效）
    /// </summary>
    [SugarColumn(ColumnName = "IS_VALID", DefaultValue = "Y", Length = 1)]
    public string? IsValid { get; set; }
}