// 文件: MES.Service.Modes/ZZCXB.cs
using SqlSugar;

namespace MES.Service.Modes
{
    /// <summary>
    /// ZZCXB - 组装拆卸 孙表
    /// </summary>
    [SugarTable("ZZCXB")]
    public class ZZCXB
    {
        /// <summary>
        /// 主键 ID（Oracle 序列）
        /// </summary>
        [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_ZZCXB")]
        public decimal? Id { get; set; }

        /// <summary>
        /// 对应子表 ID (ZZCXA.ID)
        /// </summary>
        [SugarColumn(ColumnName = "PID")]
        public decimal? Pid { get; set; }

        /// <summary>
        /// ERP 主表 ID（冗余）
        /// </summary>
        [SugarColumn(ColumnName = "ERPID")]
        public decimal? Erpid { get; set; }

        /// <summary>
        /// YD_ID：主表 ERPID（冗余）
        /// </summary>
        [SugarColumn(ColumnName = "YD_ID")]
        public decimal? YdId { get; set; }

        /// <summary>
        /// ERP 子表行 ID (EID)
        /// </summary>
        [SugarColumn(ColumnName = "EID")]
        public decimal? Eid { get; set; }

        /// <summary>
        /// 物料编码 ID
        /// </summary>
        [SugarColumn(ColumnName = "ITEM_ID")]
        public decimal? ItemId { get; set; }

        /// <summary>
        /// 数量
        /// </summary>
        [SugarColumn(ColumnName = "QTY")]
        public decimal? Qty { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        [SugarColumn(ColumnName = "UNIT")]
        public string Unit { get; set; }

        /// <summary>
        /// 仓库 ID
        /// </summary>
        [SugarColumn(ColumnName = "DEPOT_ID")]
        public decimal? DepotId { get; set; }

        /// <summary>
        /// 批号
        /// </summary>
        [SugarColumn(ColumnName = "LOT_NO")]
        public string LotNo { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(ColumnName = "MEMO")]
        public string Memo { get; set; }
    }
}