DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/SaleFcst/YearDemandManagement.cs

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

namespace Business.Domain
{
    /// <summary>
    /// 年度生产需求管理表
    /// </summary>
    [Comment("年度生产需求管理表")]
    [Index(nameof(Year), nameof(Area), nameof(ProdLine),nameof(ProdRange), nameof(Line),nameof(Model),nameof(PlanMonth),nameof(tenant_id), nameof(company_id),nameof(factory_id), IsUnique = true)]
    public class YearDemandManagement:BaseEntity
    {
        /// <summary>
        /// 年
        /// </summary>
        [Comment("年")]
        public int? Year { get; set; }

        /// <summary>
        /// 区域
        /// </summary>
        [Comment("区域")]
        public string? Area { get; set; }

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

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

        /// <summary>
        /// 车间线体
        /// </summary>
        [Comment("车间线体")]
        public string? Line { get; set; }

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

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

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