AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/Entity/AdoSmartOpsKpiAtomicDay.cs

namespace Admin.NET.Plugin.AiDOP.Entity;

/// <summary>
/// KPI 最小颗粒度原子聚合层（日粒度）。存可二次聚合基础量，不存模块级最终汇总。
/// 表结构由 AidopTenantMigration 与版本迁移脚本维护，禁止全局 CodeFirst 对大表做启动期 ALTER。
/// </summary>
[IgnoreTable]
[SugarTable("ado_smart_ops_kpi_atomic_day", "KPI原子聚合层(日)")]
public class AdoSmartOpsKpiAtomicDay
{
    [SugarColumn(ColumnName = "id", ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "bigint")]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "tenant_id", ColumnDescription = "租户ID", ColumnDataType = "bigint")]
    public long TenantId { get; set; }

    [SugarColumn(ColumnName = "factory_id", ColumnDescription = "工厂ID", ColumnDataType = "bigint", DefaultValue = "1")]
    public long FactoryId { get; set; } = 1;

    [SugarColumn(ColumnName = "domain_code", ColumnDescription = "业务对象域", Length = 50)]
    public string DomainCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "metric_code", ColumnDescription = "指标编码", Length = 50)]
    public string MetricCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "metric_level", ColumnDescription = "指标层级", ColumnDataType = "tinyint", DefaultValue = "1")]
    public int MetricLevel { get; set; } = 1;

    [SugarColumn(ColumnName = "stat_date", ColumnDescription = "统计日期", ColumnDataType = "date")]
    public DateTime StatDate { get; set; }

    [SugarColumn(ColumnName = "customer_code", ColumnDescription = "客户编码", Length = 100, DefaultValue = "")]
    public string CustomerCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "product_code", ColumnDescription = "产品编码", Length = 100, DefaultValue = "")]
    public string ProductCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "order_no", ColumnDescription = "订单号", Length = 100, DefaultValue = "")]
    public string OrderNo { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "production_line", ColumnDescription = "产线", Length = 100, DefaultValue = "")]
    public string ProductionLine { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "supplier_code", ColumnDescription = "供应商编码", Length = 100, DefaultValue = "")]
    public string SupplierCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "material_code", ColumnDescription = "物料编码", Length = 100, DefaultValue = "")]
    public string MaterialCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "po_no", ColumnDescription = "采购单号", Length = 100, DefaultValue = "")]
    public string PoNo { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "warehouse_code", ColumnDescription = "仓库编码", Length = 100, DefaultValue = "")]
    public string WarehouseCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "work_order_no", ColumnDescription = "工单号", Length = 100, DefaultValue = "")]
    public string WorkOrderNo { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "equipment_code", ColumnDescription = "设备编码", Length = 100, DefaultValue = "")]
    public string EquipmentCode { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "outbound_no", ColumnDescription = "出库单号", Length = 100, DefaultValue = "")]
    public string OutboundNo { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "sum_value", ColumnDescription = "可累加值", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? SumValue { get; set; }

    [SugarColumn(ColumnName = "numerator_value", ColumnDescription = "比率分子", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? NumeratorValue { get; set; }

    [SugarColumn(ColumnName = "denominator_value", ColumnDescription = "比率分母", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? DenominatorValue { get; set; }

    [SugarColumn(ColumnName = "sample_count", ColumnDescription = "样本数", IsNullable = true)]
    public int? SampleCount { get; set; }

    [SugarColumn(ColumnName = "min_value", ColumnDescription = "最小值", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? MinValue { get; set; }

    [SugarColumn(ColumnName = "max_value", ColumnDescription = "最大值", Length = 18, DecimalDigits = 6, IsNullable = true)]
    public decimal? MaxValue { get; set; }

    [SugarColumn(ColumnName = "batch_id", ColumnDescription = "MDP批次", Length = 100, IsNullable = true)]
    public string? BatchId { get; set; }

    [SugarColumn(ColumnName = "calc_time", ColumnDescription = "计算时间", IsNullable = true)]
    public DateTime? CalcTime { get; set; }

    [SugarColumn(ColumnName = "grain", ColumnDescription = "统计粒度", Length = 20, DefaultValue = "day")]
    public string Grain { get; set; } = "day";

    [SugarColumn(ColumnName = "is_deleted", ColumnDescription = "删除标识", ColumnDataType = "tinyint", DefaultValue = "0")]
    public int IsDeleted { get; set; }
}