DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/MES/IC/ic_item_stockoccupy.cs

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

namespace Business.Domain
{
    /// <summary>
    /// 资源检查物料占用明细表
    /// </summary>
    [CollectionName("dopbase", "ic_item_stockoccupy")]
    [Comment("资源检查物料占用明细表")]
    //[Index(nameof(orderentry_id), nameof(icitem_number), nameof(fversion), nameof(tenant_id), nameof(company_id), nameof(factory_id), IsUnique = true)]
    public class ic_item_stockoccupy : BaseEntity
    {
        /// <summary>
        /// bangid
        /// </summary>
        [Comment("bangid")]
        [NotMapped]
        public long bang_id { get; set; }

        /// <summary>
        /// 订单id
        /// </summary>
        [Comment("订单id")]
        public long? order_id { get; set; }

        /// <summary>
        /// 订单行id
        /// </summary>
        [Comment("订单行id")]
        public long? orderentry_id { get; set; }

        /// <summary>
        /// 工单ID
        /// </summary>
        [Comment("工单ID")]
        public long? morder_id { get; set; }

        /// <summary>
        /// 工单编号
        /// </summary>
        [Comment("工单编号")]
        [StringLength(80)]
        public string morder_mo { get; set; }

        /// <summary>
        /// 物料id
        /// </summary>
        [Comment("物料id")]
        public long icitem_id { get; set; }


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

        /// <summary>
        /// 版本号
        /// </summary>
        [StringLength(80)]
        [Comment("版本号")]
        public string fversion { get; set; }

        /// <summary>
        /// 占用数量
        /// </summary>
        [Comment("占用数量")]
        [Precision(23, 10)]
        public decimal quantity { get; set; }

        /// <summary>
        /// 占用时间
        /// </summary>
        [Comment("占用时间")]
        public DateTime? occupy_time { get; set; }

        /// <summary>
        /// 项次号
        /// </summary>
        [Comment("项次号")]
        [StringLength(20)]
        public string item_no { get; set; }
    }
}