namespace MDM.Model.Material
{
    /// <summary>
    /// 物料清单
    /// </summary>
    [SugarTable("material_list", "物料清单")]
    public class MaterialList
    {
        /// <summary>
        /// 雪花id 
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, IsIdentity = false, Length =50)]
        public string  Id { get; set; }

        /// <summary>
        /// 物料类型code 
        /// </summary>
        [SugarColumn(ColumnName = "fk_material_type_code",Length =50)]
        public string FkMaterialTypeCode { get; set; }

        /// <summary>
        /// 物料名称 
        /// </summary>
        [SugarColumn( Length = 50)]
        public string Name { get; set; }

        /// <summary>
        /// 物料编码 
        /// </summary>
        [SugarColumn(Length = 50)]
        public string Code { get; set; }

        /// <summary>
        /// 物料代码 
        /// </summary>
        [SugarColumn(Length = 50)]
        public string Addcode { get; set; }

        /// <summary>
        /// 客户编码 
        /// </summary>
        
        [SugarColumn(ColumnName = "customer_code",Length =50)]
        public string CustomerCode { get; set; }

        /// <summary>
        /// 颜色 
        /// </summary>
        [SugarColumn(Length = 50)]
        public string Color { get; set; }

        /// <summary>
        /// 规格型号 
        /// </summary>
        [SugarColumn(Length = 50)]
        public string Specification { get; set; }

        /// <summary>
        /// 计量单位 
        /// </summary>
        [SugarColumn(Length = 50)]
        public string Unit { get; set; }

        /// <summary>
        /// 描述 
        /// </summary>
        [SugarColumn(Length = 50)]
        public string Description { get; set; }

        /// <summary>
        /// 供应商外键id 
        /// </summary>
        [SugarColumn(ColumnName = "fk_supplier_id", Length = 50)]
        public int? FkSupplierId { get; set; }

        /// <summary>
        /// 供应商code 
        /// </summary>
        [SugarColumn(ColumnName = "supplier_code", Length = 50)]
        public string SupplierCode { get; set; }

        /// <summary>
        /// 保质期单位 
        /// </summary>
        [SugarColumn(ColumnName = "expiration_unit", Length = 50)]
        public string ExpirationUnit { get; set; }

        /// <summary>
        /// 保质期 
        /// </summary>
        [SugarColumn(ColumnName = "expiration_date")]
        public decimal ExpirationDate { get; set; }

        /// <summary>
        /// 保质期预警天数 
        /// </summary>
        [SugarColumn(ColumnName = "shelf_life_warning_days")]
        public int? ShelfLifeWarningDays { get; set; }

        /// <summary>
        /// 是否有效期管理 
        /// </summary>
        [SugarColumn(ColumnName = "is_shelf_life", Length = 50)]
        public int? IsShelfLife { get; set; }

        /// <summary>
        /// 启用日期 
        /// </summary>
        [SugarColumn(ColumnName = "start_time")]
        public DateTime? StartTime { get; set; }

        /// <summary>
        /// 停用日期 
        /// </summary>
        [SugarColumn(ColumnName = "stop_time")]
        public DateTime? StopTime { get; set; }

        /// <summary>
        /// 对应条码 
        /// </summary>
        [SugarColumn(ColumnName = "bar_code")]
        public string BarCode { get; set; }

        /// <summary>
        /// 是否启用批次管理 
        /// </summary>
        [SugarColumn(ColumnName = "is_batch")]
        public int? IsBatch { get; set; }

        /// <summary>
        /// 创建人 
        /// </summary>
        [SugarColumn(ColumnName = "cREATED_BY", Length = 50)]
        public string CreatedBy { get; set; }

        /// <summary>
        /// 创建时间 
        /// </summary>
        [SugarColumn(ColumnName = "cREATED_TIME")]
        public DateTime? CreatedTime { get; set; }

        /// <summary>
        /// 更新人 
        /// </summary>
        [SugarColumn(ColumnName = "uPDATED_BY", Length = 50)]
        public string UpdatedBy { get; set; }

        /// <summary>
        /// 更新时间 
        /// </summary>
        [SugarColumn(ColumnName = "uPDATED_TIME")]
        public DateTime? UpdatedTime { get; set; }

    }
}