namespace Admin.NET.Plugin.AiDOP.Entity;

[SugarTable("ado_smart_ops_kpi_target_import_batch", "KPI目标Excel导入批次")]
public class AdoSmartOpsKpiTargetImportBatch
{
    [SugarColumn(ColumnName = "id", IsPrimaryKey = true, IsIdentity = true)]
    public long Id { get; set; }

    [SugarColumn(ColumnName = "batch_no", Length = 64)]
    public string BatchNo { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "tenant_id")]
    public long TenantId { get; set; }

    [SugarColumn(ColumnName = "factory_id")]
    public long FactoryId { get; set; }

    [SugarColumn(ColumnName = "file_name", Length = 255)]
    public string FileName { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "file_sha256", Length = 64)]
    public string FileSha256 { get; set; } = string.Empty;

    [SugarColumn(ColumnName = "status", Length = 32)]
    public string Status { get; set; } = "VALIDATING";

    [SugarColumn(ColumnName = "total_rows")]
    public int TotalRows { get; set; }

    [SugarColumn(ColumnName = "valid_rows")]
    public int ValidRows { get; set; }

    [SugarColumn(ColumnName = "error_rows")]
    public int ErrorRows { get; set; }

    [SugarColumn(ColumnName = "payload_json", ColumnDataType = "mediumtext", IsNullable = true)]
    public string? PayloadJson { get; set; }

    [SugarColumn(ColumnName = "error_json", ColumnDataType = "mediumtext", IsNullable = true)]
    public string? ErrorJson { get; set; }

    [SugarColumn(ColumnName = "created_by", Length = 100, IsNullable = true)]
    public string? CreatedBy { get; set; }

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

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