using SqlSugar;

namespace FoodLabeling.Application.Services.DbModels;

[SugarTable("fl_label")]
public class FlLabelDbEntity
{
    [SugarColumn(IsPrimaryKey = true)]
    public string Id { get; set; } = string.Empty;

    public bool IsDeleted { get; set; }

    public DateTime CreationTime { get; set; }

    public string? CreatorId { get; set; }

    public string? LastModifierId { get; set; }

    public DateTime? LastModificationTime { get; set; }

    public string ConcurrencyStamp { get; set; } = string.Empty;

    public string? LabelCode { get; set; }

    public string LabelName { get; set; } = string.Empty;

    public string TemplateId { get; set; } = string.Empty;

    public string? LocationId { get; set; }

    /// <summary>
    /// 适用 Region 范围：ALL / SPECIFIED。未执行 DDL 时由 <see cref="Helpers.LabelRegionSchemaHelper"/> 读写，ORM 忽略本列。
    /// </summary>
    [SugarColumn(IsIgnore = true)]
    public string AppliedRegionType { get; set; } = "SPECIFIED";

    public string? LabelCategoryId { get; set; }

    public string? LabelTypeId { get; set; }

    public string? LabelType { get; set; }

    public bool State { get; set; }

    /// <summary>
    /// 适用 Region 范围：ALL=全平台；SPECIFIED=按 <c>fl_label_region</c> 关联
    /// </summary>
    public string AppliedRegionType { get; set; } = "SPECIFIED";

    /// <summary>
    /// json 字段，直接保存为字符串（入参/出参自行序列化/反序列化）
    /// </summary>
    public string? LabelInfoJson { get; set; }
}