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

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

namespace Business.Domain
{
    /// <summary>
    /// 计划订单表
    /// </summary>
    [Comment("计划订单表")]
    [Index(nameof(PlanMonth),nameof(Model),nameof(ItemNum),nameof(Type), nameof(tenant_id),nameof(company_id), nameof(factory_id), IsUnique = true)]
    public class crm_planorder : BaseEntity
    {
        /// <summary>
        /// 计划补货月份
        /// </summary>
        [Comment("计划补货月份")]
        public string PlanMonth { get; set; }

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

        /// <summary>
        /// 物料编码
        /// </summary>
        [Comment("物料编码")]
        public string ItemNum { get; set; }

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

        /// <summary>
        /// 产品类型
        /// </summary>
        [Comment("产品类型")]
        public string ProdType { get; set; }

        /// <summary>
        /// 需补货数量
        /// </summary>
        [Comment("需补货数量")]
        public decimal Qty { get; set; }

        /// <summary>
        /// 计划订单类型
        /// </summary>
        [Comment("计划订单类型")]
        public string Type { get; set; }

        /// <summary>
        /// 产生方式
        /// </summary>
        [Comment("产生方式")]
        public string Source { get; set; }
    }
}