namespace Admin.NET.Plugin.AiDOP.Entity;

/// <summary>
/// Demo 计划表 ado_plans
/// </summary>
[SugarTable("ado_plans", "AiDOP Demo 计划")]
public class AdoPlan
{
    [SugarColumn(ColumnDescription = "主键", IsPrimaryKey = true, IsIdentity = true, ColumnDataType = "integer")]
    public long Id { get; set; }

    [SugarColumn(ColumnDescription = "计划号", Length = 50)]
    public string PlanNo { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "计划类型", Length = 50)]
    public string PlanType { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "产品Id", IsNullable = true)]
    public long? ProductId { get; set; }

    [SugarColumn(ColumnDescription = "产品名称", Length = 200)]
    public string ProductName { get; set; } = string.Empty;

    [SugarColumn(ColumnDescription = "计划数量")]
    public int Quantity { get; set; }

    [SugarColumn(ColumnDescription = "已完成数量")]
    public int CompletedQuantity { get; set; }

    [SugarColumn(ColumnDescription = "开始日期", IsNullable = true)]
    public DateTime? StartDate { get; set; }

    [SugarColumn(ColumnDescription = "结束日期", IsNullable = true)]
    public DateTime? EndDate { get; set; }

    [SugarColumn(ColumnDescription = "状态", Length = 50)]
    public string Status { get; set; } = "未开始";

    [SugarColumn(ColumnDescription = "优先级", Length = 50)]
    public string Priority { get; set; } = "中";

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

    [SugarColumn(ColumnDescription = "创建时间")]
    public DateTime CreatedTime { get; set; }

    [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
    public DateTime? UpdatedTime { get; set; }

    [SugarColumn(ColumnDescription = "创建人", Length = 100, IsNullable = true)]
    public string? CreatedBy { get; set; }
}