AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Entity/S0/Manufacturing/AdoS0MfgMastersAndSop.cs

namespace Admin.NET.Plugin.AiDOP.Entity.S0.Manufacturing;

[SugarTable("ado_s0_mfg_person_skill_assignment", "S0 人员技能分配")]
public class AdoS0MfgPersonSkillAssignment
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "人员编码", Length = 100)]
    public string PersonCode { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "工作组", Length = 100, IsNullable = true)]
    public string? WorkGroup { get; set; }

    [SugarColumn(ColumnDescription = "技能", ColumnDataType = "bigint")]
    public long SkillId { get; set; }

    [SugarColumn(ColumnDescription = "技能等级")]
    public int SkillLevel { get; set; }

    [SugarColumn(ColumnDescription = "生产效率", DecimalDigits = 5, Length = 18)]
    public decimal ProductionEfficiency { get; set; } = 1m;

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_material_substitution", "S0 物料替代")]
public class AdoS0MfgMaterialSubstitution
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "物料", ColumnDataType = "bigint")]
    public long MaterialId { get; set; }

    [SugarColumn(ColumnDescription = "替代物料", ColumnDataType = "bigint")]
    public long SubstituteMaterialId { get; set; }

    [SugarColumn(ColumnDescription = "替代比例", DecimalDigits = 5, Length = 18)]
    public decimal SubstituteRatio { get; set; } = 1m;

    [SugarColumn(ColumnDescription = "优先级")]
    public int Priority { get; set; }

    [SugarColumn(ColumnDescription = "父物料", ColumnDataType = "bigint", IsNullable = true)]
    public long? ParentMaterialId { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_work_order_control", "S0 工单控制参数")]
[SugarIndex("uk_ado_s0_mfg_woc_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgWorkOrderControl
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "控制类型", Length = 50, IsNullable = true)]
    public string? ControlType { get; set; }

    [SugarColumn(ColumnDescription = "参数值", Length = 500, IsNullable = true)]
    public string? ParamValue { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_person_skill", "S0 人员技能主数据")]
[SugarIndex("uk_ado_s0_mfg_ps_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgPersonSkill
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "技能等级", Length = 50, IsNullable = true)]
    public string? SkillLevel { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_line_post", "S0 线体岗位")]
[SugarIndex("uk_ado_s0_mfg_lp_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgLinePost
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "产线", ColumnDataType = "bigint", IsNullable = true)]
    public long? ProductionLineId { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_line_post_skill", "S0 线体岗位技能")]
public class AdoS0MfgLinePostSkill
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "岗位", ColumnDataType = "bigint")]
    public long LinePostId { get; set; }

    [SugarColumn(ColumnDescription = "人员技能", ColumnDataType = "bigint")]
    public long PersonSkillId { get; set; }

    [SugarColumn(ColumnDescription = "要求等级", Length = 50, IsNullable = true)]
    public string? RequiredLevel { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "生效日期", IsNullable = true)]
    public DateTime? EffectiveDate { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_work_center", "S0 工作中心")]
[SugarIndex("uk_ado_s0_mfg_wc_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgWorkCenter
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "中心类型", Length = 50, IsNullable = true)]
    public string? CenterType { get; set; }

    [SugarColumn(ColumnDescription = "产能", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? Capacity { get; set; }

    [SugarColumn(ColumnDescription = "部门", ColumnDataType = "bigint", IsNullable = true)]
    public long? DepartmentId { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_line_material", "S0 线边物料")]
public class AdoS0MfgLineMaterial
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "产线", ColumnDataType = "bigint", IsNullable = true)]
    public long? ProductionLineId { get; set; }

    [SugarColumn(ColumnDescription = "物料", ColumnDataType = "bigint")]
    public long MaterialId { get; set; }

    [SugarColumn(ColumnDescription = "工序", ColumnDataType = "bigint", IsNullable = true)]
    public long? OperationId { get; set; }

    [SugarColumn(ColumnDescription = "工作中心", ColumnDataType = "bigint", IsNullable = true)]
    public long? WorkCenterId { get; set; }

    [SugarColumn(ColumnDescription = "设备编码", Length = 100, IsNullable = true)]
    public string? EquipmentCode { get; set; }

    [SugarColumn(ColumnDescription = "标准产能", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? StdCapacityPerUnit { get; set; }

    [SugarColumn(ColumnDescription = "换型时间", DecimalDigits = 5, Length = 18, IsNullable = true)]
    public decimal? ChangeoverTime { get; set; }

    [SugarColumn(ColumnDescription = "设备类型", Length = 50, IsNullable = true)]
    public string? EquipmentTypeCode { get; set; }

    [SugarColumn(ColumnDescription = "模具类型", Length = 50, IsNullable = true)]
    public string? MoldTypeCode { get; set; }

    [SugarColumn(ColumnDescription = "要求技能编码", Length = 100, IsNullable = true)]
    public string? RequiredSkillCode { get; set; }

    [SugarColumn(ColumnDescription = "物料角色", Length = 50, IsNullable = true)]
    public string? MaterialRole { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_element_param", "S0 生产要素参数")]
[SugarIndex("uk_ado_s0_mfg_ep_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(ElementCategory), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgElementParam
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "要素编码", Length = 100, IsNullable = true)]
    public string? ElementCode { get; set; }

    [SugarColumn(ColumnDescription = "要素名称", Length = 200, IsNullable = true)]
    public string? ElementName { get; set; }

    [SugarColumn(ColumnDescription = "要素分类", Length = 50, IsNullable = true)]
    public string? ElementCategory { get; set; }

    [SugarColumn(ColumnDescription = "参数编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "参数名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "值类型", Length = 50, IsNullable = true)]
    public string? ParamType { get; set; }

    [SugarColumn(ColumnDescription = "单位", Length = 50, IsNullable = true)]
    public string? Unit { get; set; }

    [SugarColumn(ColumnDescription = "标准值", Length = 200, IsNullable = true)]
    public string? StdValue { get; set; }

    [SugarColumn(ColumnDescription = "上限", DecimalDigits = 6, Length = 18, IsNullable = true)]
    public decimal? UpperLimit { get; set; }

    [SugarColumn(ColumnDescription = "下限", DecimalDigits = 6, Length = 18, IsNullable = true)]
    public decimal? LowerLimit { get; set; }

    [SugarColumn(ColumnDescription = "枚举选项", Length = 2000, IsNullable = true)]
    public string? EnumOptions { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_material_process_element", "S0 物料工艺要素")]
public class AdoS0MfgMaterialProcessElement
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "物料", ColumnDataType = "bigint")]
    public long MaterialId { get; set; }

    [SugarColumn(ColumnDescription = "工序", ColumnDataType = "bigint")]
    public long OperationId { get; set; }

    [SugarColumn(ColumnDescription = "产线", ColumnDataType = "bigint", IsNullable = true)]
    public long? ProductionLineId { get; set; }

    [SugarColumn(ColumnDescription = "要素类型", Length = 50, IsNullable = true)]
    public string? ElementType { get; set; }

    [SugarColumn(ColumnDescription = "要素编码", Length = 100, IsNullable = true)]
    public string? ElementCode { get; set; }

    [SugarColumn(ColumnDescription = "要素名称", Length = 200, IsNullable = true)]
    public string? ElementName { get; set; }

    [SugarColumn(ColumnDescription = "要素参数", ColumnDataType = "bigint")]
    public long ElementParamId { get; set; }

    [SugarColumn(ColumnDescription = "参数值", Length = 500, IsNullable = true)]
    public string? ParamValue { get; set; }

    [SugarColumn(ColumnDescription = "关键要素", ColumnDataType = "boolean")]
    public bool IsKeyElement { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_preprocess_element", "S0 前处理要素头")]
[SugarIndex("uk_ado_s0_mfg_ppe_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgPreprocessElement
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "物料", ColumnDataType = "bigint", IsNullable = true)]
    public long? MaterialId { get; set; }

    [SugarColumn(ColumnDescription = "工序", ColumnDataType = "bigint", IsNullable = true)]
    public long? OperationId { get; set; }

    [SugarColumn(ColumnDescription = "关键要素", ColumnDataType = "boolean")]
    public bool IsKeyElement { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_preprocess_element_param", "S0 前处理要素参数行")]
public class AdoS0MfgPreprocessElementParam
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "前处理要素", ColumnDataType = "bigint")]
    public long PreprocessElementId { get; set; }

    [SugarColumn(ColumnDescription = "要素参数", ColumnDataType = "bigint")]
    public long ElementParamId { get; set; }

    [SugarColumn(ColumnDescription = "参数值", Length = 500, IsNullable = true)]
    public string? ParamValue { get; set; }

    [SugarColumn(ColumnDescription = "排序")]
    public int SortNo { get; set; }

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_sop_file_type", "S0 SOP 文件类型")]
[SugarIndex("uk_ado_s0_mfg_sft_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgSopFileType
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}

[SugarTable("ado_s0_mfg_sop_document", "S0 SOP 文档")]
[SugarIndex("uk_ado_s0_mfg_sd_code", nameof(CompanyRefId), OrderByType.Asc, nameof(FactoryRefId), OrderByType.Asc, nameof(Code), OrderByType.Asc, IsUnique = true)]
public class AdoS0MfgSopDocument
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "公司", ColumnDataType = "bigint")]
    public long CompanyRefId { get; set; }

    [SugarColumn(ColumnDescription = "工厂", ColumnDataType = "bigint")]
    public long FactoryRefId { get; set; }

    [SugarColumn(ColumnDescription = "编码", Length = 100)]
    public string Code { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "名称", Length = 200)]
    public string Name { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "产线", ColumnDataType = "bigint", IsNullable = true)]
    public long? ProductionLineId { get; set; }

    [SugarColumn(ColumnDescription = "SOP 类型", ColumnDataType = "bigint")]
    public long SopFileTypeId { get; set; }

    [SugarColumn(ColumnDescription = "物料", ColumnDataType = "bigint", IsNullable = true)]
    public long? MaterialId { get; set; }

    [SugarColumn(ColumnDescription = "工序", ColumnDataType = "bigint", IsNullable = true)]
    public long? OperationId { get; set; }

    [SugarColumn(ColumnDescription = "文件版本", Length = 50, IsNullable = true)]
    public string? FileVersion { get; set; }

    [SugarColumn(ColumnDescription = "文件 ID", ColumnDataType = "bigint", IsNullable = true)]
    public long? FileId { get; set; }

    [SugarColumn(ColumnDescription = "文档状态", Length = 50)]
    public string DocStatus { get; set; } = "draft";

    [SugarColumn(ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string? Remark { get; set; }

    [SugarColumn(ColumnDescription = "启用", ColumnDataType = "boolean")]
    public bool IsEnabled { get; set; } = true;

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedAt { get; set; } = DateTime.Now;

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedAt { get; set; }
}