AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Entity/S0/Quality/AdoS0QualityEntities.cs

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

// ========== 单表主数据 ==========

[SugarTable("qms_lymjbmd", "原材料白名单")]
public class AdoS0QmsRawWhitelist
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "gysbm", ColumnDescription = "供应商编码", IsNullable = true, Length = 255)]
    public string? SupplierCode { get; set; }

    [SugarColumn(ColumnName = "gysmc", ColumnDescription = "供应商名称", IsNullable = true, Length = 255)]
    public string? SupplierName { get; set; }

    [SugarColumn(ColumnName = "wlbm", ColumnDescription = "物料编码", IsNullable = true, Length = 255)]
    public string? MaterialCode { get; set; }

    [SugarColumn(ColumnName = "wlmc", ColumnDescription = "物料名称", IsNullable = true, Length = 255)]
    public string? MaterialName { get; set; }

    [SugarColumn(ColumnName = "dim_type", ColumnDescription = "维度类型（supplier/material/material_supplier）", IsNullable = true, Length = 50)]
    public string? DimensionType { get; set; }
}

[SugarTable("qms_sampscheme", "抽样方案")]
public class AdoS0QmsSamplingScheme
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "FNUMBER", ColumnDescription = "编号", IsNullable = true, Length = 255)]
    public string? Number { get; set; }

    [SugarColumn(ColumnName = "FNAME", ColumnDescription = "名称", IsNullable = true, Length = 255)]
    public string? Name { get; set; }

    [SugarColumn(ColumnName = "FSAMPLINGTYPE", ColumnDescription = "抽样类型", IsNullable = true, Length = 255)]
    public string? SamplingType { get; set; }

    [SugarColumn(ColumnName = "FINSPECTIONLEVEL", ColumnDescription = "检验水准", IsNullable = true, Length = 255)]
    public string? InspectionLevel { get; set; }

    [SugarColumn(ColumnName = "FSTRICTNESS", ColumnDescription = "严格程度", IsNullable = true, Length = 255)]
    public string? Strictness { get; set; }

    [SugarColumn(ColumnName = "FAQLVALUE", ColumnDescription = "AQL值", IsNullable = true, Length = 255)]
    public string? AqlValue { get; set; }

    [SugarColumn(ColumnName = "FINSPECTIONTYPE", ColumnDescription = "检验类型", IsNullable = true, Length = 255)]
    public string? InspectionType { get; set; }

    [SugarColumn(ColumnName = "FINSPECTORGID", ColumnDescription = "检验组织", IsNullable = true, ColumnDataType = "bigint")]
    public long? InspectOrgId { get; set; }

    [SugarColumn(ColumnName = "FINSPECTUSERID", ColumnDescription = "检验员", IsNullable = true, Length = 255)]
    public string? InspectUserId { get; set; }

    [SugarColumn(ColumnName = "FSTATUS", ColumnDescription = "状态", IsNullable = true, Length = 255)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "FENABLE", ColumnDescription = "启用", IsNullable = true, Length = 255)]
    public string? EnableStatus { get; set; }

    [SugarColumn(ColumnName = "FCOMMENT", ColumnDescription = "备注", IsNullable = true, Length = 255)]
    public string? Comment { get; set; }

    [SugarColumn(ColumnName = "FFIXEDRATE", ColumnDescription = "固定抽样比例(%)", ColumnDataType = "decimal(10,4)", IsNullable = true)]
    public decimal? FixedSamplingRate { get; set; }

    [SugarColumn(ColumnName = "FCREATETIME", ColumnDescription = "创建时间", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "FMODIFYTIME", ColumnDescription = "修改时间", IsNullable = true)]
    public DateTime? ModifyTime { get; set; }
}

[SugarTable("qms_inspectioninstru", "检验仪器")]
public class AdoS0QmsInspectionInstrument
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "FNUMBER", ColumnDescription = "编号", IsNullable = true, Length = 255)]
    public string? Number { get; set; }

    [SugarColumn(ColumnName = "FNAME", ColumnDescription = "名称", IsNullable = true, Length = 255)]
    public string? Name { get; set; }

    [SugarColumn(ColumnName = "FMODEL", ColumnDescription = "型号", IsNullable = true, Length = 255)]
    public string? Model { get; set; }

    [SugarColumn(ColumnName = "FSPECIFICATION", ColumnDescription = "规格", IsNullable = true, Length = 255)]
    public string? Specification { get; set; }

    [SugarColumn(ColumnName = "FMANUFACTURER", ColumnDescription = "生产厂家", IsNullable = true, Length = 255)]
    public string? Manufacturer { get; set; }

    [SugarColumn(ColumnName = "FSTATUS", ColumnDescription = "状态", IsNullable = true, Length = 255)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "FENABLE", ColumnDescription = "启用", IsNullable = true, Length = 255)]
    public string? EnableStatus { get; set; }

    [SugarColumn(ColumnName = "FCOMMENT", ColumnDescription = "备注", IsNullable = true, Length = 255)]
    public string? Comment { get; set; }

    [SugarColumn(ColumnName = "gauge_category", ColumnDescription = "计量器具分类", IsNullable = true, Length = 255)]
    public string? GaugeCategory { get; set; }

    [SugarColumn(ColumnName = "calibration_cycle_days", ColumnDescription = "校准周期(天)", IsNullable = true, ColumnDataType = "int")]
    public int? CalibrationCycleDays { get; set; }

    [SugarColumn(ColumnName = "next_calibration_date", ColumnDescription = "下次校准日期", IsNullable = true, Length = 50)]
    public string? NextCalibrationDate { get; set; }

    [SugarColumn(ColumnName = "FCREATETIME", ColumnDescription = "创建时间", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "FMODIFYTIME", ColumnDescription = "修改时间", IsNullable = true)]
    public DateTime? ModifyTime { get; set; }
}

[SugarTable("qms_inspection_method", "检验方法")]
public class AdoS0QmsInspectionMethod
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "FNUMBER", ColumnDescription = "编号", IsNullable = true, Length = 255)]
    public string? Number { get; set; }

    [SugarColumn(ColumnName = "FNAME", ColumnDescription = "名称", IsNullable = true, Length = 255)]
    public string? Name { get; set; }

    [SugarColumn(ColumnName = "FCTRLSTRATEGY", ColumnDescription = "控制策略", IsNullable = true, Length = 255)]
    public string? ControlStrategy { get; set; }

    [SugarColumn(ColumnName = "FSTATUS", ColumnDescription = "状态", IsNullable = true, Length = 255)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "FENABLE", ColumnDescription = "启用", IsNullable = true, Length = 255)]
    public string? EnableStatus { get; set; }

    [SugarColumn(ColumnName = "FCOMMENT", ColumnDescription = "备注", IsNullable = true, Length = 255)]
    public string? Comment { get; set; }

    [SugarColumn(ColumnName = "FCREATETIME", ColumnDescription = "创建时间", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "FMODIFYTIME", ColumnDescription = "修改时间", IsNullable = true)]
    public DateTime? ModifyTime { get; set; }
}

[SugarTable("qms_inspectionitems", "检验项目")]
public class AdoS0QmsInspectionItem
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "FNUMBER", ColumnDescription = "编号", IsNullable = true, Length = 255)]
    public string? Number { get; set; }

    [SugarColumn(ColumnName = "FNAME", ColumnDescription = "名称", IsNullable = true, Length = 255)]
    public string? Name { get; set; }

    [SugarColumn(ColumnName = "FCHECKMETHOD", ColumnDescription = "检验方法", IsNullable = true, ColumnDataType = "bigint")]
    public long? CheckMethodId { get; set; }

    [SugarColumn(ColumnName = "FCHECKBASIS", ColumnDescription = "检验依据", IsNullable = true, ColumnDataType = "bigint")]
    public long? CheckBasisId { get; set; }

    [SugarColumn(ColumnName = "FCHECKINSTRUCT", ColumnDescription = "检验指导书", IsNullable = true, ColumnDataType = "bigint")]
    public long? CheckInstructId { get; set; }

    [SugarColumn(ColumnName = "FRADIOGROUPFIELD", ColumnDescription = "单选组1", IsNullable = true, Length = 255)]
    public string? RadioGroupField { get; set; }

    [SugarColumn(ColumnName = "FRADIOGROUPFIELD1", ColumnDescription = "单选组2", IsNullable = true, Length = 255)]
    public string? RadioGroupField1 { get; set; }

    [SugarColumn(ColumnName = "zblx", ColumnDescription = "指标类型", IsNullable = true, ColumnDataType = "bigint")]
    public long? MetricType { get; set; }

    [SugarColumn(ColumnName = "FSTATUS", ColumnDescription = "状态", IsNullable = true, Length = 255)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "FENABLE", ColumnDescription = "启用", IsNullable = true, Length = 255)]
    public string? EnableStatus { get; set; }

    [SugarColumn(ColumnName = "FCOMMENT", ColumnDescription = "备注", IsNullable = true, Length = 255)]
    public string? Comment { get; set; }

    [SugarColumn(ColumnName = "FCREATETIME", ColumnDescription = "创建时间", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "FMODIFYTIME", ColumnDescription = "修改时间", IsNullable = true)]
    public DateTime? ModifyTime { get; set; }
}

[SugarTable("qms_inspectionfreq", "检验频率")]
public class AdoS0QmsInspectionFrequency
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "FNUMBER", ColumnDescription = "编号", IsNullable = true, Length = 255)]
    public string? Number { get; set; }

    [SugarColumn(ColumnName = "FNAME", ColumnDescription = "名称", IsNullable = true, Length = 255)]
    public string? Name { get; set; }

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

    [SugarColumn(ColumnName = "FSTATUS", ColumnDescription = "状态", IsNullable = true, Length = 255)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "FENABLE", ColumnDescription = "启用", IsNullable = true, Length = 255)]
    public string? EnableStatus { get; set; }

    [SugarColumn(ColumnName = "FCREATETIME", ColumnDescription = "创建时间", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "FMODIFYTIME", ColumnDescription = "修改时间", IsNullable = true)]
    public DateTime? ModifyTime { get; set; }
}

// ========== 聚合头表 ==========

[SugarTable("qms_inspectioncrit", "检验依据")]
public class AdoS0QmsInspectionBasis
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "FNUMBER", ColumnDescription = "编号", IsNullable = true, Length = 255)]
    public string? Number { get; set; }

    [SugarColumn(ColumnName = "FNAME", ColumnDescription = "名称", IsNullable = true, Length = 255)]
    public string? Name { get; set; }

    [SugarColumn(ColumnName = "FCTRLSTRATEGY", ColumnDescription = "控制策略", IsNullable = true, Length = 255)]
    public string? ControlStrategy { get; set; }

    [SugarColumn(ColumnName = "FCREATEORGID", ColumnDescription = "创建组织", IsNullable = true, ColumnDataType = "bigint")]
    public long? CreateOrgId { get; set; }

    [SugarColumn(ColumnName = "FUSEORG", ColumnDescription = "使用组织", IsNullable = true, ColumnDataType = "bigint")]
    public long? UseOrgId { get; set; }

    [SugarColumn(ColumnName = "FCOMMENT", ColumnDescription = "备注", IsNullable = true, Length = 255)]
    public string? Comment { get; set; }

    [SugarColumn(ColumnName = "FSTATUS", ColumnDescription = "状态", IsNullable = true, Length = 255)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "FENABLE", ColumnDescription = "启用", IsNullable = true, Length = 255)]
    public string? EnableStatus { get; set; }

    [SugarColumn(ColumnName = "FCREATETIME", ColumnDescription = "创建时间", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "FMODIFYTIME", ColumnDescription = "修改时间", IsNullable = true)]
    public DateTime? ModifyTime { get; set; }
}

[SugarTable("qms_inspectionstd", "检验标准")]
public class AdoS0QmsInspectionStandard
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "FNUMBER", ColumnDescription = "编号", IsNullable = true, Length = 30)]
    public string? Number { get; set; }

    [SugarColumn(ColumnName = "FNAME", ColumnDescription = "名称", IsNullable = true, Length = 255)]
    public string? Name { get; set; }

    [SugarColumn(ColumnName = "FCOMMENT", ColumnDescription = "备注", IsNullable = true, Length = 255)]
    public string? Comment { get; set; }

    [SugarColumn(ColumnName = "FCTRLSTRATEGY", ColumnDescription = "控制策略", IsNullable = true, Length = 30)]
    public string? ControlStrategy { get; set; }

    [SugarColumn(ColumnName = "FCREATEORGID", ColumnDescription = "创建组织", IsNullable = true, ColumnDataType = "bigint")]
    public long? CreateOrgId { get; set; }

    [SugarColumn(ColumnName = "FUSEORG", ColumnDescription = "使用组织", IsNullable = true, ColumnDataType = "bigint")]
    public long? UseOrgId { get; set; }

    [SugarColumn(ColumnName = "FSTATUS", ColumnDescription = "状态", IsNullable = true, Length = 30)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "FENABLE", ColumnDescription = "启用", IsNullable = true, Length = 30)]
    public string? EnableStatus { get; set; }
}

[SugarTable("qms_inspectpro", "检验方案")]
public class AdoS0QmsInspectionPlan
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "FNUMBER", ColumnDescription = "编号", IsNullable = true, Length = 255)]
    public string? Number { get; set; }

    [SugarColumn(ColumnName = "FNAME", ColumnDescription = "名称", IsNullable = true, Length = 255)]
    public string? Name { get; set; }

    [SugarColumn(ColumnName = "FBIZSTYPEID", ColumnDescription = "检验业务类型", IsNullable = true, Length = 255)]
    public string? BizTypeId { get; set; }

    [SugarColumn(ColumnName = "FCOMMENT", ColumnDescription = "备注", IsNullable = true, Length = 255)]
    public string? Comment { get; set; }

    [SugarColumn(ColumnName = "FCTRLSTRATEGY", ColumnDescription = "控制策略", IsNullable = true, Length = 255)]
    public string? ControlStrategy { get; set; }

    [SugarColumn(ColumnName = "FCREATEORGID", ColumnDescription = "创建组织", IsNullable = true, ColumnDataType = "bigint")]
    public long? CreateOrgId { get; set; }

    [SugarColumn(ColumnName = "FUSEORGID", ColumnDescription = "使用组织", IsNullable = true, ColumnDataType = "bigint")]
    public long? UseOrgId { get; set; }

    [SugarColumn(ColumnName = "FSTATUS", ColumnDescription = "状态", IsNullable = true, Length = 255)]
    public string? Status { get; set; }

    [SugarColumn(ColumnName = "FENABLE", ColumnDescription = "启用", IsNullable = true, Length = 255)]
    public string? EnableStatus { get; set; }

    [SugarColumn(ColumnName = "FCREATETIME", ColumnDescription = "创建时间", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "FMODIFYTIME", ColumnDescription = "修改时间", IsNullable = true)]
    public DateTime? ModifyTime { get; set; }
}

[SugarTable("qms_jygf", "原材料检验规范")]
public class AdoS0QmsRawInspectionSpec
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "wjbh", ColumnDescription = "文件编号", IsNullable = true, Length = 255)]
    public string? FileNumber { get; set; }

    [SugarColumn(ColumnName = "bb", ColumnDescription = "版本", IsNullable = true, Length = 255)]
    public string? VersionNo { get; set; }

    [SugarColumn(ColumnName = "th", ColumnDescription = "图号", IsNullable = true, Length = 255)]
    public string? DrawingNo { get; set; }

    [SugarColumn(ColumnName = "yclmc", ColumnDescription = "原材料名称", IsNullable = true, Length = 255)]
    public string? RawMaterialName { get; set; }

    [SugarColumn(ColumnName = "wlbm", ColumnDescription = "物料编码", IsNullable = true, Length = 255)]
    public string? MaterialCode { get; set; }

    [SugarColumn(ColumnName = "sxrq", ColumnDescription = "生效日期", IsNullable = true, Length = 255)]
    public string? EffectiveDate { get; set; }

    [SugarColumn(ColumnName = "tzbb", ColumnDescription = "图纸版本", IsNullable = true, Length = 255)]
    public string? DrawingVersion { get; set; }

    [SugarColumn(ColumnName = "czclph", ColumnDescription = "材质/材料牌号", IsNullable = true, Length = 255)]
    public string? MaterialGrade { get; set; }

    [SugarColumn(ColumnName = "xm", ColumnDescription = "穴/模", IsNullable = true, Length = 255)]
    public string? CavityOrMold { get; set; }

    [SugarColumn(ColumnName = "fj", ColumnDescription = "附件", IsNullable = true, ColumnDataType = "text")]
    public string? Attachment { get; set; }

    [SugarColumn(ColumnName = "filename", ColumnDescription = "附件文件名", IsNullable = true, ColumnDataType = "text")]
    public string? FileName { get; set; }

    [SugarColumn(ColumnName = "title", ColumnDescription = "附件标题", IsNullable = true, Length = 255)]
    public string? Title { get; set; }
}

[SugarTable("qms_gcjygf", "过程检验规范")]
public class AdoS0QmsProcessInspectionSpec
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "syxh", ColumnDescription = "适用型号", IsNullable = true, Length = 255)]
    public string? ApplicableModel { get; set; }

    [SugarColumn(ColumnName = "wjbh", ColumnDescription = "文件编号", IsNullable = true, Length = 255)]
    public string? FileNumber { get; set; }

    [SugarColumn(ColumnName = "bb", ColumnDescription = "版本", IsNullable = true, Length = 255)]
    public string? VersionNo { get; set; }

    [SugarColumn(ColumnName = "sxrj", ColumnDescription = "生效日期", IsNullable = true, Length = 255)]
    public string? EffectiveDate { get; set; }

    [SugarColumn(ColumnName = "fj", ColumnDescription = "附件", IsNullable = true, ColumnDataType = "text")]
    public string? Attachment { get; set; }

    [SugarColumn(ColumnName = "wlbm", ColumnDescription = "物料编码", IsNullable = true, ColumnDataType = "text")]
    public string? MaterialCode { get; set; }

    [SugarColumn(ColumnName = "fj2", ColumnDescription = "附件2", IsNullable = true, ColumnDataType = "text")]
    public string? Attachment2 { get; set; }

    [SugarColumn(ColumnName = "version", ColumnDescription = "版本号", IsNullable = true, ColumnDataType = "int")]
    public int? Version { get; set; }
}

[SugarTable("qms_fqcjygf", "FQC检验规范")]
public class AdoS0QmsFqcInspectionSpec
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "syxh", ColumnDescription = "适用型号", IsNullable = true, Length = 255)]
    public string? ApplicableModel { get; set; }

    [SugarColumn(ColumnName = "wjbh", ColumnDescription = "文件编号", IsNullable = true, Length = 255)]
    public string? FileNumber { get; set; }

    [SugarColumn(ColumnName = "bb", ColumnDescription = "版本", IsNullable = true, Length = 255)]
    public string? VersionNo { get; set; }

    [SugarColumn(ColumnName = "sxrj", ColumnDescription = "生效日期", IsNullable = true, Length = 255)]
    public string? EffectiveDate { get; set; }

    [SugarColumn(ColumnName = "fj", ColumnDescription = "附件", IsNullable = true, ColumnDataType = "text")]
    public string? Attachment { get; set; }

    [SugarColumn(ColumnName = "wlbm", ColumnDescription = "物料编码", IsNullable = true, ColumnDataType = "text")]
    public string? MaterialCode { get; set; }

    [SugarColumn(ColumnName = "fj2", ColumnDescription = "附件2", IsNullable = true, ColumnDataType = "text")]
    public string? Attachment2 { get; set; }

    [SugarColumn(ColumnName = "version", ColumnDescription = "版本号", IsNullable = true, ColumnDataType = "int")]
    public int? Version { get; set; }
}

[SugarTable("qms_oqcjygf", "OQC检验规范")]
public class AdoS0QmsOqcInspectionSpec
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "syxh", ColumnDescription = "适用型号", IsNullable = true, Length = 255)]
    public string? ApplicableModel { get; set; }

    [SugarColumn(ColumnName = "wjbh", ColumnDescription = "文件编号", IsNullable = true, Length = 255)]
    public string? FileNumber { get; set; }

    [SugarColumn(ColumnName = "bb", ColumnDescription = "版本", IsNullable = true, Length = 255)]
    public string? VersionNo { get; set; }

    [SugarColumn(ColumnName = "sxrj", ColumnDescription = "生效日期", IsNullable = true, Length = 255)]
    public string? EffectiveDate { get; set; }

    [SugarColumn(ColumnName = "fj", ColumnDescription = "附件", IsNullable = true, ColumnDataType = "text")]
    public string? Attachment { get; set; }

    [SugarColumn(ColumnName = "wlbm", ColumnDescription = "物料编码", IsNullable = true, ColumnDataType = "text")]
    public string? MaterialCode { get; set; }

    [SugarColumn(ColumnName = "fj2", ColumnDescription = "附件2", IsNullable = true, ColumnDataType = "text")]
    public string? Attachment2 { get; set; }

    [SugarColumn(ColumnName = "version", ColumnDescription = "版本号", IsNullable = true, ColumnDataType = "int")]
    public int? Version { get; set; }
}

// ========== 聚合子表 ==========

[SugarTable("qms_inspeccrit_entry", "检验依据-技术文档")]
public class AdoS0QmsInspectionBasisEntry
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "glid", ColumnDescription = "主表ID", IsNullable = true, ColumnDataType = "bigint")]
    public long? MasterId { get; set; }

    [SugarColumn(ColumnName = "FSEQ", ColumnDescription = "序号", IsNullable = true, ColumnDataType = "bigint")]
    public long? Seq { get; set; }

    [SugarColumn(ColumnName = "FWORDNUM", ColumnDescription = "文档编号", IsNullable = true, Length = 255)]
    public string? DocumentNumber { get; set; }

    [SugarColumn(ColumnName = "FWORDNAME", ColumnDescription = "文档名称", IsNullable = true, Length = 255)]
    public string? DocumentName { get; set; }

    [SugarColumn(ColumnName = "FJ", ColumnDescription = "附件", IsNullable = true, Length = 255)]
    public string? Attachment { get; set; }
}

[SugarTable("qms_inspectionstdentry", "检验标准-检验项目")]
public class AdoS0QmsInspectionStandardEntry
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "FENTRYID", ColumnDescription = "主表ID", IsNullable = true, ColumnDataType = "bigint")]
    public long? MasterId { get; set; }

    [SugarColumn(ColumnName = "FSEQ", ColumnDescription = "序号", IsNullable = true, ColumnDataType = "bigint")]
    public long? Seq { get; set; }

    [SugarColumn(ColumnName = "FCHECKITEMS", ColumnDescription = "检验项目", IsNullable = true, Length = 255)]
    public string? CheckItems { get; set; }

    [SugarColumn(ColumnName = "FCHECKCONTENT", ColumnDescription = "检验内容", IsNullable = true, Length = 255)]
    public string? CheckContent { get; set; }

    [SugarColumn(ColumnName = "FNORMTYPE", ColumnDescription = "比较符", IsNullable = true, Length = 255)]
    public string? NormType { get; set; }

    [SugarColumn(ColumnName = "FSPECVALUE", ColumnDescription = "标准", IsNullable = true, Length = 255)]
    public string? SpecValue { get; set; }

    [SugarColumn(ColumnName = "FTOPVALUE", ColumnDescription = "上限", IsNullable = true, ColumnDataType = "decimal(23,10)")]
    public decimal? TopValue { get; set; }

    [SugarColumn(ColumnName = "FDOWNVALUE", ColumnDescription = "下限", IsNullable = true, ColumnDataType = "decimal(23,10)")]
    public decimal? DownValue { get; set; }

    [SugarColumn(ColumnName = "FCHECKBASIS", ColumnDescription = "检验依据", IsNullable = true, ColumnDataType = "bigint")]
    public long? CheckBasisId { get; set; }

    [SugarColumn(ColumnName = "FCHECKMETHOD", ColumnDescription = "检验方法", IsNullable = true, ColumnDataType = "bigint")]
    public long? CheckMethodId { get; set; }

    [SugarColumn(ColumnName = "FCHECKFREQ", ColumnDescription = "检验频率", IsNullable = true, ColumnDataType = "bigint")]
    public long? CheckFrequencyId { get; set; }

    [SugarColumn(ColumnName = "FCHECKINSTRUCT", ColumnDescription = "检验指导书", IsNullable = true, ColumnDataType = "bigint")]
    public long? CheckInstructId { get; set; }

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

    [SugarColumn(ColumnName = "FKEYQUALITY", ColumnDescription = "关键质量", IsNullable = true, ColumnDataType = "bigint")]
    public long? KeyQuality { get; set; }
}

[SugarTable("qms_inspro_ent", "检验方案-方案设置")]
public class AdoS0QmsInspectionPlanEntry
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "glid", ColumnDescription = "主表ID", IsNullable = true, ColumnDataType = "bigint")]
    public long? MasterId { get; set; }

    [SugarColumn(ColumnName = "FSEQ", ColumnDescription = "序号", IsNullable = true, ColumnDataType = "int")]
    public int? Seq { get; set; }

    [SugarColumn(ColumnName = "FSETUPTYPE", ColumnDescription = "设置类型", IsNullable = true, Length = 255)]
    public string? SetupType { get; set; }

    [SugarColumn(ColumnName = "FMATERIELID", ColumnDescription = "物料编码", IsNullable = true, Length = 255)]
    public string? MaterialCode { get; set; }

    [SugarColumn(ColumnName = "wlmc", ColumnDescription = "物料名称", IsNullable = true, Length = 255)]
    public string? MaterialName { get; set; }

    [SugarColumn(ColumnName = "FMATERIELTYPEID", ColumnDescription = "物料分类", IsNullable = true, ColumnDataType = "bigint")]
    public long? MaterialTypeId { get; set; }

    [SugarColumn(ColumnName = "FSUPPLIERID", ColumnDescription = "供应商", IsNullable = true, Length = 255)]
    public string? SupplierId { get; set; }

    [SugarColumn(ColumnName = "FSAMPLEPROID", ColumnDescription = "抽样方案", IsNullable = true, ColumnDataType = "bigint")]
    public long? SamplingSchemeId { get; set; }

    [SugarColumn(ColumnName = "FINSPECTSTDID", ColumnDescription = "检验标准", IsNullable = true, ColumnDataType = "bigint")]
    public long? InspectionStandardId { get; set; }

    [SugarColumn(ColumnName = "FINSPECTORGID", ColumnDescription = "检验组织", IsNullable = true, ColumnDataType = "bigint")]
    public long? InspectOrgId { get; set; }

    [SugarColumn(ColumnName = "FINSPECTUSERID", ColumnDescription = "检验员", IsNullable = true, ColumnDataType = "bigint")]
    public long? InspectUserId { get; set; }

    [SugarColumn(ColumnName = "FQROUTEID", ColumnDescription = "工艺路线", IsNullable = true, ColumnDataType = "bigint")]
    public long? QRouteId { get; set; }

    [SugarColumn(ColumnName = "FOPERATIONNO", ColumnDescription = "工序号", IsNullable = true, Length = 255)]
    public string? OperationNo { get; set; }

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

    [SugarColumn(ColumnName = "FWSTRSPROID", ColumnDescription = "检验频率", IsNullable = true, ColumnDataType = "bigint")]
    public long? InspectionFrequencyId { get; set; }

    [SugarColumn(ColumnName = "FROCESSSEQ", ColumnDescription = "工序顺序", IsNullable = true, Length = 255)]
    public string? ProcessSeq { get; set; }

    [SugarColumn(ColumnName = "jylx", ColumnDescription = "检验类型", IsNullable = true, ColumnDataType = "bigint")]
    public long? InspectionType { get; set; }
}

[SugarTable("qms_jygfzb", "原材料检验规范-检验明细")]
public class AdoS0QmsRawInspectionSpecEntry
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "glid", ColumnDescription = "主表ID", IsNullable = true, ColumnDataType = "bigint")]
    public long? MasterId { get; set; }

    [SugarColumn(ColumnName = "xh", ColumnDescription = "序号", IsNullable = true, ColumnDataType = "int")]
    public int? Seq { get; set; }

    [SugarColumn(ColumnName = "jyxm", ColumnDescription = "检验项目", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionItem { get; set; }

    [SugarColumn(ColumnName = "jybz", ColumnDescription = "检验标准", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionStandard { get; set; }

    [SugarColumn(ColumnName = "jygjjyff", ColumnDescription = "检验工具/检验方法", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionMethod { get; set; }

    [SugarColumn(ColumnName = "txfl", ColumnDescription = "图像分类", IsNullable = true, ColumnDataType = "text")]
    public string? ImageCategory { get; set; }

    [SugarColumn(ColumnName = "cyfa", ColumnDescription = "抽样方案", IsNullable = true, ColumnDataType = "text")]
    public string? SamplingScheme { get; set; }

    [SugarColumn(ColumnName = "zs", ColumnDescription = "注释", IsNullable = true, ColumnDataType = "text")]
    public string? Remark { get; set; }

    [SugarColumn(ColumnName = "fj", ColumnDescription = "附件", IsNullable = true, ColumnDataType = "text")]
    public string? Attachment { get; set; }

    [SugarColumn(ColumnName = "sx", ColumnDescription = "上限", IsNullable = true, Length = 50)]
    public string? UpperLimit { get; set; }

    [SugarColumn(ColumnName = "xx", ColumnDescription = "下限", IsNullable = true, Length = 50)]
    public string? LowerLimit { get; set; }
}

[SugarTable("qms_gcjygfzb", "过程检验规范-检验明细")]
public class AdoS0QmsProcessInspectionSpecEntry
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "glid", ColumnDescription = "主表ID", IsNullable = true, ColumnDataType = "bigint")]
    public long? MasterId { get; set; }

    [SugarColumn(ColumnName = "gxdh", ColumnDescription = "工序代号", IsNullable = true, ColumnDataType = "text")]
    public string? OperationCode { get; set; }

    [SugarColumn(ColumnName = "gxmc", ColumnDescription = "工序名称", IsNullable = true, ColumnDataType = "text")]
    public string? OperationName { get; set; }

    [SugarColumn(ColumnName = "jyxm", ColumnDescription = "检验项目", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionItem { get; set; }

    [SugarColumn(ColumnName = "jyff", ColumnDescription = "检验方法", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionMethod { get; set; }

    [SugarColumn(ColumnName = "jygg", ColumnDescription = "检验规格", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionSpec { get; set; }

    [SugarColumn(ColumnName = "txfl", ColumnDescription = "图像分类", IsNullable = true, ColumnDataType = "text")]
    public string? ImageCategory { get; set; }

    [SugarColumn(ColumnName = "jypc", ColumnDescription = "检验频次", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionFrequency { get; set; }

    [SugarColumn(ColumnName = "jsbz", ColumnDescription = "技术标准", IsNullable = true, ColumnDataType = "text")]
    public string? TechnicalStandard { get; set; }

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

    [SugarColumn(ColumnName = "sx", ColumnDescription = "上限", IsNullable = true, Length = 50)]
    public string? UpperLimit { get; set; }

    [SugarColumn(ColumnName = "xx", ColumnDescription = "下限", IsNullable = true, Length = 50)]
    public string? LowerLimit { get; set; }
}

[SugarTable("qms_fqcjygfzb", "FQC检验规范-检验明细")]
public class AdoS0QmsFqcInspectionSpecEntry
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "glid", ColumnDescription = "主表ID", IsNullable = true, ColumnDataType = "bigint")]
    public long? MasterId { get; set; }

    [SugarColumn(ColumnName = "gxdh", ColumnDescription = "工序代号", IsNullable = true, ColumnDataType = "text")]
    public string? OperationCode { get; set; }

    [SugarColumn(ColumnName = "gxmc", ColumnDescription = "工序名称", IsNullable = true, ColumnDataType = "text")]
    public string? OperationName { get; set; }

    [SugarColumn(ColumnName = "jyxm", ColumnDescription = "检验项目", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionItem { get; set; }

    [SugarColumn(ColumnName = "jyff", ColumnDescription = "检验方法", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionMethod { get; set; }

    [SugarColumn(ColumnName = "jygg", ColumnDescription = "检验规格", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionSpec { get; set; }

    [SugarColumn(ColumnName = "txfl", ColumnDescription = "图像分类", IsNullable = true, ColumnDataType = "text")]
    public string? ImageCategory { get; set; }

    [SugarColumn(ColumnName = "jypc", ColumnDescription = "检验频次", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionFrequency { get; set; }

    [SugarColumn(ColumnName = "jsbz", ColumnDescription = "技术标准", IsNullable = true, ColumnDataType = "text")]
    public string? TechnicalStandard { get; set; }

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

    [SugarColumn(ColumnName = "sx", ColumnDescription = "上限", IsNullable = true, Length = 50)]
    public string? UpperLimit { get; set; }

    [SugarColumn(ColumnName = "xx", ColumnDescription = "下限", IsNullable = true, Length = 50)]
    public string? LowerLimit { get; set; }
}

[SugarTable("qms_oqcjygfzb", "OQC检验规范-检验明细")]
public class AdoS0QmsOqcInspectionSpecEntry
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "glid", ColumnDescription = "主表ID", IsNullable = true, ColumnDataType = "bigint")]
    public long? MasterId { get; set; }

    [SugarColumn(ColumnName = "gxdh", ColumnDescription = "工序代号", IsNullable = true, ColumnDataType = "text")]
    public string? OperationCode { get; set; }

    [SugarColumn(ColumnName = "gxmc", ColumnDescription = "工序名称", IsNullable = true, ColumnDataType = "text")]
    public string? OperationName { get; set; }

    [SugarColumn(ColumnName = "jyxm", ColumnDescription = "检验项目", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionItem { get; set; }

    [SugarColumn(ColumnName = "jyff", ColumnDescription = "检验方法", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionMethod { get; set; }

    [SugarColumn(ColumnName = "jygg", ColumnDescription = "检验规格", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionSpec { get; set; }

    [SugarColumn(ColumnName = "txfl", ColumnDescription = "图像分类", IsNullable = true, ColumnDataType = "text")]
    public string? ImageCategory { get; set; }

    [SugarColumn(ColumnName = "jypc", ColumnDescription = "检验频次", IsNullable = true, ColumnDataType = "text")]
    public string? InspectionFrequency { get; set; }

    [SugarColumn(ColumnName = "jsbz", ColumnDescription = "技术标准", IsNullable = true, ColumnDataType = "text")]
    public string? TechnicalStandard { get; set; }

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

    [SugarColumn(ColumnName = "sx", ColumnDescription = "上限", IsNullable = true, Length = 50)]
    public string? UpperLimit { get; set; }

    [SugarColumn(ColumnName = "xx", ColumnDescription = "下限", IsNullable = true, Length = 50)]
    public string? LowerLimit { get; set; }
}

[SugarTable("qms_quality_base_type", "质量基础主数据")]
public class AdoS0QmsQualityBaseType
{
    [SugarColumn(ColumnName = "id", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户Id", IsNullable = false, ColumnDataType = "bigint")]
    public long TenantId { get; set; } = 1300000000001L;

    [SugarColumn(ColumnName = "type_category", Length = 100)]
    public string TypeCategory { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "type_code", Length = 100)]
    public string TypeCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "short_name", Length = 200)]
    public string ShortName { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "full_name", Length = 255, IsNullable = true)]
    public string? FullName { get; set; }

    [SugarColumn(ColumnName = "is_active", ColumnDataType = "boolean")]
    public bool IsActive { get; set; } = true;

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

    [SugarColumn(ColumnName = "create_time", IsNullable = true)]
    public DateTime? CreateTime { get; set; }

    [SugarColumn(ColumnName = "modify_time", IsNullable = true)]
    public DateTime? ModifyTime { get; set; }
}