DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Production/MonthlyProdCapacityMain.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(Month), nameof(ProdRange), nameof(Model), nameof(ProdLine), nameof(tenant_id), nameof(factory_id), IsUnique = true)]
    public class MonthlyProdCapacityMain
    {
        /// <summary>
        /// 主键
        /// </summary>
        [Comment("主键")]
        [Key]
        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 ProdRange { get; set; }

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

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

        /// <summary>
        /// 生产线
        /// </summary>
        [Comment("生产线")]
        public string ProdLine { 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; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [Comment("创建时间")]
        public DateTime? CreateTime { get; set; }

        /// <summary>
        /// 整体需求计划版本号
        /// </summary>
        [Comment("整体需求计划版本号")]
        public string Version { get; set; }
    }
}