using FreeSql.DataAnnotations;
using System;

namespace BBWYB.Server.Model.Db
{

    [Table(Name = "purchaseschemeproductsku", DisableSyncStructure = true)]
    public partial class PurchaseSchemeProductSku
    {

        /// <summary>
        /// 采购商品的SKU和采购方案的关系Id
        /// </summary>
        [Column(IsPrimary = true)]
        public long Id { get; set; }

        [Column(DbType = "datetime")]
        public DateTime? CreateTime { get; set; }

        [Column(StringLength = 50, IsNullable = false)]
        public string ProductId { get; set; }

        /// <summary>
        /// 采购商品Id
        /// </summary>
        [Column(StringLength = 50, IsNullable = false)]
        public string PurchaseProductId { get; set; }

        /// <summary>
        /// 采购商品的SkuId
        /// </summary>
        [Column(StringLength = 50)]
        public string PurchaseSkuId { get; set; }

        /// <summary>
        /// 采购商品Sku的SpecId
        /// </summary>
        [Column(StringLength = 50)]
        public string PurchaseSkuSpecId { get; set; }

        [Column(StringLength = 50, IsNullable = false)]
        public string SkuId { get; set; }

        /// <summary>
        /// Sku采购方案Id
        /// </summary>
        public long SkuPurchaseSchemeId { get; set; }

        /// <summary>
        /// 采购比例
        /// </summary>
        [Column(DbType = "int(1)", IsNullable = true)]
        public int? PurchaseRatio { get; set; } = 1;

        /// <summary>
        /// 实际单价
        /// </summary>
        public decimal? ActualPrice { get; set; }

        /// <summary>
        /// 最近议价日期
        /// </summary>
        [Column(DbType = "datetime", IsNullable = true)]
        public DateTime? LastBargainingTime { get; set; }

        /// <summary>
        /// 配件的最近采购价(配件单价)
        /// </summary>
        public decimal? LastPurchasePriceCost { get; set; }

    }

}