using FreeSql.DataAnnotations;

namespace SiNan.Model.Db
{

    [Table(Name = "aggregationjdpopularizeskudaily", DisableSyncStructure = true)]
    public partial class AggregationJDPopularizeSkuDaily
    {

        [Column(DbType = "bigint", IsPrimary = true)]
        public long Id { get; set; }

        /// <summary>
        /// 推广花费
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? Cost { get; set; }

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

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

        /// <summary>
        /// 推广维度GOI
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? PopularizeLevelGOI { get; set; }

        /// <summary>
        /// 推广维度毛利
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? PopularizeLevelProfit { get; set; }

        /// <summary>
        /// spu
        /// </summary>
        [Column(StringLength = 50)]
        public string ProductId { get; set; }

        /// <summary>
        /// 产品维度GOI
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? ProductLevelGOI { get; set; }

        /// <summary>
        /// 产品维度毛利
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? ProductLevelProfit { get; set; }

        [Column(DbType = "bigint")]
        public long? ShopId { get; set; }

        /// <summary>
        /// sku
        /// </summary>
        [Column(StringLength = 50)]
        public string SkuId { get; set; }

        /// <summary>
        /// 商品营业额(SKU实收)
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? ActualAmount { get; set; } = 0.00M;

        /// <summary>
        /// 推广营业额(SKU实收)
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? PopularizeAmount { get; set; } = 0.00M;

        /// <summary>
        /// 推广维度ROI
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? PopularizeLevelROI { get; set; } = 0.00M;

        /// <summary>
        /// 直接推广营业额(SKU实收)
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? DirectPopularizeAmount { get; set; } = 0.00M;

        /// <summary>
        /// 直接推广维度ROI
        /// </summary>
        [Column(DbType = "decimal(18,2)")]
        public decimal? DirectPopularizeLevelROI { get; set; } = 0.00M;
    }

}