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

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

namespace Business.Domain
{
    /// <summary>
    /// 物料库存表
    /// </summary>
    [CollectionName("dopbase", "ic_item_stock")]
    [Comment("物料库存表")]
    [Index(nameof(icitem_number), nameof(fversion), nameof(tenant_id), nameof(factory_id), IsUnique = true)]
    public class ic_item_stock : BaseEntity
    {
        /// <summary>
        /// 物料id
        /// </summary>
        [Required]
        [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 icitem_name { get; set; }

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


        /// <summary>
        /// 物料库存量
        /// </summary>
        [Precision(23, 10)]
        [Comment("物料库存量")]
        public decimal? sqty { get; set; }
        /// <summary>
        /// 调拨在途数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("调拨在途数量")]
        public decimal? quantity_in_transit { get; set; }

        /// <summary>
        /// 计算id
        /// </summary>
        [Comment("计算id")]
        [NotMapped]
        public long? bang_id { get; set; }
    }
}