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

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

namespace Business.Domain
{
    /// <summary>
    /// 物料BOM明细
    /// </summary>
    [CollectionName("dopbase", "ic_bom_child")]
    [Comment("物料BOM明细")]
    [Index(nameof(bom_number), nameof(item_number), nameof(version), nameof(tenant_id), nameof(company_id), nameof(factory_id), IsUnique = true)]
    public class ic_bom_child : BaseEntity
    {
        public ic_bom_child(long Id) : base(Id)
        {
        }
        /// <summary>
        /// bom主键
        /// </summary>
        [Required]
        [Comment("bom主键")]
        public long? bom_id { get; set; }
        /// <summary>
        /// bom单编号
        /// </summary>
        [StringLength(20)]
        [Comment("bom单编号")]
        public string bom_number { get; set; }
        /// <summary>
        /// 是否是BOM
        /// </summary>
        [Comment("是否是BOM")]
        public int? is_bom { get; set; }
        /// <summary>
        /// 物料id
        /// </summary>
        [Required]
        [Comment("物料id")]
        public long? icitem_id { get; set; }
        /// <summary>
        /// 物料代码
        /// </summary>
        [StringLength(80)]
        [Comment("物料代码")]
        public string item_number { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        [StringLength(200)]
        [Comment("物料名称")]
        public string item_name { get; set; }
        /// <summary>
        /// 单位
        /// </summary>
        [StringLength(20)]
        [Comment("单位")]
        public string unit { get; set; }
        /// <summary>
        /// 用量
        /// </summary>
        [Precision(23, 10)]
        [Comment("用量")]
        public decimal? qty { get; set; }
        /// <summary>
        /// 损耗率
        /// </summary>
        [Precision(23, 10)]
        [Comment("损耗率")]
        public decimal? scrap { get; set; }
        /// <summary>
        /// 固定损耗量
        /// </summary>
        [Precision(12, 5)]
        [Comment("固定损耗量")]
        public decimal? wastage { get; set; }
        /// <summary>
        /// 是否倒冲
        /// </summary>
        [Comment("是否倒冲")]
        public int? backflush { get; set; }
        /// <summary>
        /// 是否关键件
        /// </summary>
        [Comment("是否关键件")]
        public int? iskeyitem { get; set; }
        /// <summary>
        /// 存在替代关系
        /// </summary>
        [Comment("存在替代关系")]
        public int? haveicsubs { get; set; }
        /// <summary>
        /// 群组代码
        /// </summary>
        [StringLength(20)]
        [Comment("群组代码")]
        public string substitute_code { get; set; }
        /// <summary>
        /// 是否群组替代
        /// </summary>
        [Comment("是否群组替代")]
        public int? is_replace { get; set; }
        /// <summary>
        /// 组合模式
        /// </summary>
        [StringLength(2000)]
        [Comment("组合模式")]
        public string icitem_ids { get; set; }
        /// <summary>
        /// 备注
        /// </summary>
        [StringLength(1000)]
        [Comment("备注")]
        public string note { get; set; }
        /// <summary>
        /// 顺序号
        /// </summary>
        [Comment("顺序号")]
        public int? entryid { get; set; }
        /// <summary>
        /// 物料类型
        /// </summary>
        [Comment("物料类型")]
        public int? type { get; set; }
        /// <summary>
        /// 物料属性
        /// </summary>
        [Comment("物料属性")]
        public int? erp_cls { get; set; }
        /// <summary>
        /// 使用状态
        /// </summary>
        [Comment("使用状态")]
        public int? use_status { get; set; }
        /// <summary>
        /// 生效日期
        /// </summary>
        [Comment("生效日期")]
        public DateTime? begin_day { get; set; }
        /// <summary>
        /// 失效日期
        /// </summary>
        [Comment("失效日期")]
        public DateTime? end_day { get; set; }
        /// <summary>
        /// 操作时间
        /// </summary>
        [Comment("操作时间")]
        public DateTime? op_time { get; set; }
        /// <summary>
        /// 序号
        /// </summary>
        [Comment("序号")]
        public int? child_num { get; set; }

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

        /// <summary>
        /// 工序
        /// </summary>
        [Comment("工序")]
        public int Op { get; set; }

        //[ForeignKey("Id")]
        //public virtual ic_bom Bom { get; set; }
    }
}