using FreeSql.DataAnnotations;

namespace Store.Shops.Entities;

/// <summary>运单库存及分配状态；映射旧库，不自动修改数据库结构。</summary>
[Table(Name = "wxxd.express_optimize")]
public sealed class WaybillEntity
{
    /// <summary>记录ID。</summary>
    [Column(Name = "id", IsPrimary = true, IsIdentity = true)]
    public int Id { get; set; }

    /// <summary>运单所属账号。</summary>
    [Column(Name = "user_name")]
    public string UserName { get; set; } = "";

    /// <summary>物流公司编码。</summary>
    [Column(Name = "delivery_id")]
    public string DeliveryId { get; set; } = "";

    /// <summary>物流公司名称。</summary>
    [Column(Name = "delivery_name")]
    public string DeliveryName { get; set; } = "";

    /// <summary>运单号。</summary>
    [Column(Name = "waybill_id")]
    public string WaybillId { get; set; } = "";

    /// <summary>预绑定订单ID。</summary>
    [Column(Name = "bind_order_id")]
    public string BindOrderId { get; set; } = "";

    /// <summary>分配订单ID。</summary>
    [Column(Name = "order_id")]
    public string OrderId { get; set; } = "";

    /// <summary>使用店铺ID。</summary>
    [Column(Name = "shop_id")]
    public string ShopId { get; set; } = "";

    /// <summary>0未使用，1已预占，2已使用。</summary>
    [Column(Name = "status")]
    public int Status { get; set; }

    /// <summary>入库时间。</summary>
    [Column(Name = "add_time")]
    public DateTime AddTime { get; set; }

    /// <summary>正式使用时间。</summary>
    [Column(Name = "use_time")]
    public DateTime? UseTime { get; set; }

    /// <summary>揽收时间。</summary>
    [Column(Name = "waybill_pickup_time")]
    public DateTime? WaybillPickupTime { get; set; }
}