DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Production/OverallDemandPlanDtl.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Business.Domain
{
    /// <summary>
    /// 整体需求计划明细表
    /// </summary>
    [Comment("整体需求计划明细表")]
    [Index(nameof(Version), nameof(ProdRange), nameof(Model), nameof(PlanDate), nameof(tenant_id), nameof(factory_id), IsUnique = true)]
    public class OverallDemandPlanDtl
    {
        /// <summary>
        /// 主键
        /// </summary>
        [Comment("主键")]
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public long Id { get; set; }

        /// <summary>
        /// 年
        /// </summary>
        [Comment("年")]
        public int? Year { get; set; }

        /// <summary>
        /// 月
        /// </summary>
        [Comment("月")]
        public int? Month { get; set; }

        /// <summary>
        /// 版本号
        /// </summary>
        [Comment("版本号")]
        public string Version { get; set; }

        /// <summary>
        /// 产品线
        /// </summary>
        [Comment("产品线")]
        public string ProdLine { get; set; }

        /// <summary>
        /// 产品系列
        /// </summary>
        [Comment("产品系列")]
        public string ProdRange { get; set; }

        /// <summary>
        /// 规格型号
        /// </summary>
        [Comment("规格型号")]
        public string Model { get; set; }

        /// <summary>
        /// 计划月份
        /// </summary>
        [Comment("计划月份")]
        public string PlanDate { get; set; }

        /// <summary>
        /// 月份计数:M0,M1,M2,M3,M4,M5,M6,M7,M8,M9,M10,M11
        /// </summary>
        [Comment("月份计数")]
        public string MonthTimes { get; set; }

        /// <summary>
        /// 计划数量
        /// </summary>
        [Comment("计划数量")]
        public decimal? Qty { get; set; }

        /// <summary>
        /// 集团id
        /// </summary>
        [Comment("集团id")]
        public long? tenant_id { get; set; }

        /// <summary>
        /// 工厂id
        /// </summary>
        [Comment("工厂id")]
        public long? factory_id { get; set; }
    }
}