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

        /// <summary>
        /// 主表id
        /// </summary>
        public long MainId { get; set; }

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

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

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

        /// <summary>
        /// 日工作时间(小时)
        /// </summary>
        [Comment("日工作时间(小时)")]
        public decimal? DailyWorks { get; set; }

        /// <summary>
        /// 月工作天数(天)
        /// </summary>
        [Comment("月工作天数(天)")]
        public decimal? YearWorks { get; set; }

        /// <summary>
        /// 班次数
        /// </summary>
        [Comment("班次数")]
        public int? FlightQty { get; set; }

        /// <summary>
        /// 月度可利用工作时间(小时)
        /// </summary>
        [Comment("月度可利用工作时间(小时)")]
        public decimal? AvailableTimes { get; set; }

        /// <summary>
        /// 月度需求工作时间(小时)
        /// </summary>
        [Comment("月度需求工作时间(小时)")]
        public decimal? NeedWorks { get; set; }

        /// <summary>
        /// 排产效率
        /// </summary>
        [Comment("排产效率")]
        public decimal? ProdRate { get; set; }

        /// <summary>
        /// 产线标准产能符合率
        /// </summary>
        [Comment("产线标准产能符合率")]
        public decimal? Rate { get; set; }

        /// <summary>
        /// 是否加班:是，否
        /// </summary>
        [Comment("是否加班")]
        public string IsOverTime { get; set; }

        /// <summary>
        /// 加班工时
        /// </summary>
        [Comment("加班工时")]
        public decimal? OverTimes { 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 string Version { get; set; }
    }
}