using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// SPI/AOI 检测明细实体，记录缺陷分类统计及产线效率指标。
|
/// </summary>
|
[SugarTable("MES_SPI_AOI_DETAIL")]
|
public class MesSpiAoiDetail
|
{
|
/// <summary>
|
/// 主键ID，由 Oracle 序列 SEQ_SPI_AOI_DETAIL 生成。
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_SPI_AOI_DETAIL")]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 主表 ID（外键），关联 <see cref="MesSpiAoiHeader" />。
|
/// </summary>
|
[SugarColumn(ColumnName = "HEADER_ID")]
|
public decimal HeaderId { get; set; }
|
|
/// <summary>
|
/// 偏位数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "OFFSET_COUNT")]
|
public int OffsetCount { get; set; }
|
|
/// <summary>
|
/// 缺件数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "MISSING_COUNT")]
|
public int MissingCount { get; set; }
|
|
/// <summary>
|
/// 反向安装数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "REVERSE_COUNT")]
|
public int ReverseCount { get; set; }
|
|
/// <summary>
|
/// 翘起数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "LIFTED_COUNT")]
|
public int LiftedCount { get; set; }
|
|
/// <summary>
|
/// 浮高数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "FLOAT_HIGH_COUNT")]
|
public int FloatHighCount { get; set; }
|
|
/// <summary>
|
/// 立碑数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "TOMBSTONE_COUNT")]
|
public int TombstoneCount { get; set; }
|
|
/// <summary>
|
/// 翻转数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "FLIP_COUNT")]
|
public int FlipCount { get; set; }
|
|
/// <summary>
|
/// 错件数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "WRONG_PART_COUNT")]
|
public int WrongPartCount { get; set; }
|
|
/// <summary>
|
/// 翘脚数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "LEAD_LIFT_COUNT")]
|
public int LeadLiftCount { get; set; }
|
|
/// <summary>
|
/// 虚焊数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "COLD_JOINT_COUNT")]
|
public int ColdJointCount { get; set; }
|
|
/// <summary>
|
/// 空焊数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "NO_SOLDER_COUNT")]
|
public int NoSolderCount { get; set; }
|
|
/// <summary>
|
/// 少锡数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "INSUFFICIENT_SOLDER_COUNT")]
|
public int InsufficientSolderCount { get; set; }
|
|
/// <summary>
|
/// 多锡数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "EXCESS_SOLDER_COUNT")]
|
public int ExcessSolderCount { get; set; }
|
|
/// <summary>
|
/// 连锡数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "BRIDGE_COUNT")]
|
public int BridgeCount { get; set; }
|
|
/// <summary>
|
/// 漏铜数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "COPPER_EXPOSURE_COUNT")]
|
public int CopperExposureCount { get; set; }
|
|
/// <summary>
|
/// 拉尖数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "SPIKE_COUNT")]
|
public int SpikeCount { get; set; }
|
|
/// <summary>
|
/// 异物残留数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "FOREIGN_MATTER_COUNT")]
|
public int ForeignMatterCount { get; set; }
|
|
/// <summary>
|
/// 溢胶数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "GLUE_OVERFLOW_COUNT")]
|
public int GlueOverflowCount { get; set; }
|
|
/// <summary>
|
/// 引脚偏位数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "PIN_OFFSET_COUNT")]
|
public int PinOffsetCount { get; set; }
|
|
/// <summary>
|
/// 产线显示名称。
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_DISPLAY_NAME")]
|
public string? LineDisplayName { get; set; }
|
|
/// <summary>
|
/// 检测机台名称。
|
/// </summary>
|
[SugarColumn(ColumnName = "MACHINE_NAME")]
|
public string? MachineName { get; set; }
|
|
/// <summary>
|
/// 投入板数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "INPUT_BOARDS")]
|
public int InputBoards { get; set; }
|
|
/// <summary>
|
/// OK 板数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "OK_BOARDS")]
|
public int OkBoards { get; set; }
|
|
/// <summary>
|
/// 通过板数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "PASS_BOARDS")]
|
public int PassBoards { get; set; }
|
|
/// <summary>
|
/// 合格率（单位：%）。
|
/// </summary>
|
[SugarColumn(ColumnName = "PASS_RATE")]
|
public decimal? PassRate { get; set; }
|
|
/// <summary>
|
/// 不良板数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "DEFECT_BOARDS")]
|
public int DefectBoards { get; set; }
|
|
/// <summary>
|
/// 不良率（单位：%）。
|
/// </summary>
|
[SugarColumn(ColumnName = "DEFECT_RATE")]
|
public decimal? DefectRate { get; set; }
|
|
/// <summary>
|
/// 不良数（单位：PPM）。
|
/// </summary>
|
[SugarColumn(ColumnName = "DEFECT_PPM")]
|
public int? DefectPpm { get; set; }
|
|
/// <summary>
|
/// 不良点数。
|
/// </summary>
|
[SugarColumn(ColumnName = "DEFECT_POINTS")]
|
public int DefectPoints { get; set; }
|
|
/// <summary>
|
/// 实测点数。
|
/// </summary>
|
[SugarColumn(ColumnName = "MEASURED_POINTS")]
|
public int MeasuredPoints { get; set; }
|
|
/// <summary>
|
/// 待测点数。
|
/// </summary>
|
[SugarColumn(ColumnName = "PENDING_POINTS")]
|
public int PendingPoints { get; set; }
|
|
/// <summary>
|
/// 创建时间，默认写入数据库时间戳。
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATED_AT")]
|
public DateTime CreatedAt { get; set; }
|
|
/// <summary>
|
/// 更新时间，默认写入数据库时间戳。
|
/// </summary>
|
[SugarColumn(ColumnName = "UPDATED_AT")]
|
public DateTime UpdatedAt { get; set; }
|
}
|
