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 = "AREA_OVERFLOW_COUNT")]
|
public int AreaOverflowCount { get; set; }
|
|
/// <summary>
|
/// 面积不足数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "AREA_UNDERFLOW_COUNT")]
|
public int AreaUnderflowCount { get; set; }
|
|
/// <summary>
|
/// 高度超出数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "EXCEEDING_HEIGHT_COUNT")]
|
public int ExceedingHeightCount { get; set; }
|
|
/// <summary>
|
/// 高度不足数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "INSUFFICIENT_HEIGHT_COUNT")]
|
public int InsufficientHeightCount { get; set; }
|
|
/// <summary>
|
/// X偏移数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "X_DEVIATION_COUNT")]
|
public int XDeviationCount { get; set; }
|
|
/// <summary>
|
/// Y偏移数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "Y_DEVIATION_COUNT")]
|
public int YDeviationCount { get; set; }
|
|
/// <summary>
|
/// 塌陷数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "COLLAPSE_COUNT")]
|
public int CollapseCount { get; set; }
|
|
/// <summary>
|
/// 拉尖数量（焊锡拉尖）。
|
/// </summary>
|
[SugarColumn(ColumnName = "SOLDER_PULL_TIP_COUNT")]
|
public int SolderPullTipCount { get; set; }
|
|
/// <summary>
|
/// 异形数量。
|
/// </summary>
|
[SugarColumn(ColumnName = "ABNORMALITY_COUNT")]
|
public int AbnormalityCount { 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; }
|
}
|
