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

using Business.Core.Attributes;
using Microsoft.EntityFrameworkCore;
using System;
using System.ComponentModel.DataAnnotations;

namespace Business.Domain
{
    /// <summary>
    /// 成品库存占用表
    /// </summary>
    [CollectionName("dopbase", "mes_stockoccupy")]
    [Comment("成品库存占用表")]
    public class mes_stockoccupy : BaseEntity
    {
        ///// <summary>
        ///// 成品库存占用id
        ///// </summary>
        //[Key]
        //[Comment("成品库存占用id")]
        //public long soccupy_id { get; set; }
        /// <summary>
        /// 类型
        /// </summary>
        [Required]
        [StringLength(50)]
        [Comment("类型")]
        public string soccupy_type { get; set; }
        /// <summary>
        /// 订单行id
        /// </summary>
        [Comment("订单行id")]
        public long? soentry_id { get; set; }
        /// <summary>
        /// 订单行号
        /// </summary>
        [Comment("订单行号")]
        public long? fentry_id { get; set; }
        /// <summary>
        /// 订单编号
        /// </summary>
        [StringLength(50)]
        [Comment("订单编号")]
        public string fbill_no { get; set; }
        /// <summary>
        /// 物料编码
        /// </summary>
        [StringLength(50)]
        [Comment("物料编码")]
        public string fitem_number { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        [StringLength(200)]
        [Comment("物料名称")]
        public string fitem_name { get; set; }
        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(200)]
        [Comment("规格型号")]
        public string fmodel { get; set; }
        /// <summary>
        /// 仓库id
        /// </summary>
        [Comment("仓库id")]
        public long warehouse_id { get; set; }
        /// <summary>
        /// 仓库名称
        /// </summary>
        [StringLength(80)]
        [Comment("仓库名称")]
        public string warehouse_name { get; set; }
        /// <summary>
        /// 仓库类型
        /// </summary>
        [StringLength(50)]
        [Comment("仓库类型")]
        public string warehouse_type { get; set; }
        /// <summary>
        /// 占用量
        /// </summary>
        [Precision(20, 2)]
        [Comment("占用量")]
        public decimal? occupyqty { get; set; }
        /// <summary>
        /// 开始时间
        /// </summary>
        [Comment("开始时间")]
        public DateTime? soccupy_stime { get; set; }
        /// <summary>
        /// 结束时间
        /// </summary>
        [Comment("结束时间")]
        public DateTime? soccupy_etime { get; set; }
        /// <summary>
        /// 占用状态
        /// </summary>
        [StringLength(50)]
        [Comment("占用状态")]
        public string soccupy_state { get; set; }
        /// <summary>
        /// 变更人
        /// </summary>
        [StringLength(50)]
        [Comment("变更人")]
        public string soccupy_cby { get; set; }
        /// <summary>
        /// 变更时间
        /// </summary>
        [Comment("变更时间")]
        public DateTime? soccupy_ctime { get; set; }
        /// <summary>
        /// 变更原因
        /// </summary>
        [StringLength(255)]
        [Comment("变更原因")]
        public string soccupy_creason { get; set; }
    }
}