DEMOMySql/MicroServices/Business/Business.Host/Migrations/BusinessExtMigrationDb/20230529172130_demoinitext.cs

using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Business.Migrations.BusinessExtMigrationDb
{
    public partial class demoinitext : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "in_kd_bom",
                columns: table => new
                {
                    Id = table.Column<long>(type: "bigint", nullable: false),
                    FUseOrgId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "使用组织"),
                    FNumber = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "BOM版本"),
                    FName_2052 = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "BOM简称"),
                    FBOMCATEGORY = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "BOM分类"),
                    FMATERIALID_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "父项物料编码"),
                    FITEMNAME = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "物料名称"),
                    FITEMMODEL = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "规格型号"),
                    FITEMPPROPERTY = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "数据状态"),
                    FReplaceGroup = table.Column<int>(type: "int", nullable: true, comment: "项次"),
                    FReplacePriority = table.Column<int>(type: "int", nullable: true, comment: "替代优先级"),
                    FSubstitutionId_Name = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "80"),
                    FMATERIALIDCHILD_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "子项物料编码"),
                    FCHILDITEMNAME = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "子项物料名称"),
                    FCHILDITEMMODEL = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "子项规格型号"),
                    FSupplyType = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "供应类型"),
                    FCHILDUNITID_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "子项单位"),
                    FChildSupplyOrgId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "供应组织"),
                    FNUMERATOR = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "用量:分子"),
                    FDENOMINATOR = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "用量:分母"),
                    FPROCESSID_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "作业"),
                    FReplacePolicy = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "替代策略"),
                    FReplaceType = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "替代方式"),
                    FIskeyItem = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "替代主料"),
                    FSubstitutionName = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "替代方案名称"),
                    F_ZXWLMS = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "子项物料描述"),
                    F_ZXWLPP = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "子项物料品牌")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_in_kd_bom", x => x.Id);
                },
                comment: "物料清单");

            migrationBuilder.CreateTable(
                name: "in_kd_material",
                columns: table => new
                {
                    Id = table.Column<long>(type: "bigint", nullable: false),
                    FCreateOrgId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "创建组织"),
                    FUseOrgId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "使用组织"),
                    FNumber = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "编码"),
                    FDataSource = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "物料来源"),
                    FName_2052 = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "名称"),
                    FSpecification_2052 = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "规格型号"),
                    FMnemonicCode = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "助记码"),
                    FOldNumber = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "旧物料编码"),
                    FDescription_2052 = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "描述"),
                    FMaterialGroup_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "物料分组"),
                    FMaterialGroup = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "物料分组编码"),
                    FUseStatus = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "数据状态"),
                    FForbidStatus = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "禁用状态"),
                    FCreatorId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "创建人"),
                    FCreateDate = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "创建日期"),
                    FModifierId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "修改人"),
                    FModifyDate = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "修改日期"),
                    FApproverId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "审核人"),
                    FApproveDate = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "审核日期"),
                    FForbidderId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "禁用人"),
                    FForbidDate = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "禁用日期"),
                    FErpClsID = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "物料属性"),
                    FCategoryID_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "存货类别"),
                    FTaxType_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "税分类"),
                    FTaxRateId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "默认税率"),
                    FBaseUnitId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "基本单位"),
                    FIsPurchase = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许采购"),
                    FIsInventory = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许库存"),
                    FIsSubContract = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许委外"),
                    FIsSale = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许销售"),
                    FIsProduce = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "FIsProduce"),
                    FIsAsset = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许资产"),
                    FBARCODE = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "条码"),
                    FGROSSWEIGHT = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "毛重"),
                    FNETWEIGHT = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "净重"),
                    FVOLUMEUNITID_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "尺寸单位"),
                    FLENGTH = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "长"),
                    FWIDTH = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "宽"),
                    FHEIGHT = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "高"),
                    FWEIGHTUNITID_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "重量单位"),
                    FVOLUME = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "体积"),
                    FStoreUnitID_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "库存单位"),
                    FAuxUnitID_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "辅助单位"),
                    FStockId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "仓库"),
                    FStockLoc = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "仓位"),
                    FStockPlaceId_FF100002 = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "仓位.客户.编码"),
                    FStockPlaceId_FF100002_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "仓位.客户.名称"),
                    FStockPlaceId_FF100003 = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "仓位.供应商.编码"),
                    FStockPlaceId_FF100003_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "仓位.供应商.名称"),
                    FStockPlaceId_FF100004 = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "仓位.服务机客户.编码"),
                    FStockPlaceId_FF100004_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "仓位.服务机客户.名称"),
                    FIsLockStock = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "可锁库"),
                    FIsCycleCounting = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用盘点周期"),
                    FCountCycle = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "盘点周期单位"),
                    FCountDay = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "盘点周期"),
                    FIsMustCounting = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "必盘"),
                    FIsBatchManage = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用批号管理"),
                    FBatchRuleID_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "批号编码规则"),
                    FIsKFPeriod = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用保质期管理"),
                    FIsExpParToFlot = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "批号附属信息"),
                    FExpUnit = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "保质期单位"),
                    FExpPeriod = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "保质期"),
                    FOnlineLife = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "在架寿命期"),
                    FRefCost = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "参考成本"),
                    FCurrencyId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "币别"),
                    FIsSNManage = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "库存管理"),
                    FIsEnableMinStock = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用最小库存"),
                    FIsEnableSafeStock = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用安全库存"),
                    FSNCodeRule_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "序列号编码规则"),
                    FIsEnableReOrder = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用再订货点"),
                    FIsEnableMaxStock = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用最大库存"),
                    FSNUnit_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "序列号单位"),
                    FMinStock = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "最小库存"),
                    FSafeStock = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "安全库存"),
                    FReOrderGood = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "再订货点"),
                    FEconReOrderQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "经济订货批量"),
                    FMaxStock = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "最大库存"),
                    FSaleUnitId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "销售单位"),
                    FSalePriceUnitId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "销售计价单位"),
                    FOrderQty = table.Column<decimal>(type: "decimal(20,10)", precision: 20, scale: 10, nullable: true, comment: "起订量"),
                    FOutStockLmtH = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "超发上限(%)"),
                    FOutStockLmtL = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "超发下限(%)"),
                    FAgentSalReduceRate = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "代理销售减价比例(%)"),
                    FIsATPCheck = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "ATP检查"),
                    FIsReturn = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许退货"),
                    FIsReturnPart = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "部件可退"),
                    FAllowPublish = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许发布到订货平台"),
                    FISAFTERSALE = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用售后服务"),
                    FISPRODUCTFILES = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "生成产品档案"),
                    FISWARRANTED = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "是否保修"),
                    FWARRANTYUNITID = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "保修期单位"),
                    FPurchaseUnitId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "采购单位"),
                    FPurchasePriceUnitId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "采购计价单位"),
                    FPurchaseGroupId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "采购组"),
                    FPurchaserId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "采购员"),
                    FIsQuota = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "配额管理"),
                    FQuotaType = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "配额方式"),
                    FMinSplitQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "最小拆分数量"),
                    FIsVmiBusiness = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "VMI业务"),
                    FDefaultVendor_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "默认供应商"),
                    FChargeID_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "费用项目"),
                    FIsSourceControl = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "货源控制"),
                    FIsPR = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "需要请购"),
                    FReceiveMaxScale = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "收货上限比例(%)"),
                    FReceiveMinScale = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "收货下限比例(%)"),
                    FAgentPurPlusRate = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "代理采购加成比例"),
                    FReceiveAdvanceDays = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "收货提前天数"),
                    FReceiveDelayDays = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "收货延迟天数"),
                    FIsReturnMaterial = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许退料"),
                    FPurchaseOrgId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "采购组织"),
                    FSubconUnitId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "委外单位"),
                    FSubconPriceUnitId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "委外计价单位"),
                    FPOBillTypeId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "采购类型"),
                    FSubBillType_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "委外类型"),
                    FPlanningStrategy = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "计划策略"),
                    FMfgPolicyId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "制造策略"),
                    FCheckLeadTimeType = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "检验提前期单位"),
                    FOrderPolicy = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "订货策略"),
                    FMinPOQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "最小订货量"),
                    FPlanWorkshop_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "计划区"),
                    FOrderIntervalTimeType = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "订货间隔期单位"),
                    FFixLeadTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "固定提前期"),
                    FIncreaseQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "最小包装量"),
                    FFixLeadTimeType = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "固定提前期单位"),
                    FOrderIntervalTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "订货间隔期"),
                    FVarLeadTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "变动提前期"),
                    FVarLeadTimeLotSize = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "变动提前期批量"),
                    FVarLeadTimeType = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "变动提前期单位"),
                    FMaxPOQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "最大订货量"),
                    FCheckLeadTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "检验提前期"),
                    FEOQ = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "固定/经济批量"),
                    FPlanIntervalsDays = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "批量拆分间隔天数"),
                    FPlanBatchSplitQty = table.Column<decimal>(type: "decimal(20,10)", precision: 20, scale: 10, nullable: true, comment: "拆分批量"),
                    FIsMrpComReq = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "MRP计算是否合并需求"),
                    FRequestTimeZone = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "需求时界"),
                    FIsMrpComBill = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "MRP计算是否按单合并"),
                    FCanLeadDays = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "允许提前天数"),
                    FPlanTimeZone = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "计划时界"),
                    FReserveType = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "预留类型"),
                    FPlanGroupId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "计划组"),
                    FLeadExtendDay = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "提前宽限期"),
                    FPlanerID_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "计划员"),
                    FATOSchemeId_Name = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "ATO预测冲销方案"),
                    FCanDelayDays = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "允许延后天数"),
                    FPlanOffsetTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "偏置时间"),
                    FPlanSafeStockQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "安全库存"),
                    FDSMatchByLot = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "按批号匹配供需"),
                    FAllowPartAhead = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "预计入库允许部分提前"),
                    FTimeFactorId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "时间紧迫系数"),
                    FAllowPartDelay = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "预计入库允许部分延后"),
                    FQtyFactorId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "数量负荷系数"),
                    FSupplySourceId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "供应来源"),
                    FDelayExtendDay = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "延后宽限期"),
                    FPlanOffsetTimeType = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "时间单位"),
                    FIssueType = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "发料方式"),
                    FWorkShopId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "生产车间"),
                    FIsCoby = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "可为联副产品"),
                    FProduceUnitId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "生产单位"),
                    FIsMainPrd = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "可为主产品"),
                    FBKFLTime = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "倒冲时机"),
                    FFinishReceiptOverRate = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "入库超收比例(%)"),
                    FPickStockId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "发料仓库"),
                    FFinishReceiptShortRate = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "入库欠收比例(%)"),
                    FPickStockLoc = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "发料仓位"),
                    FPickBinId_FF100002 = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "发料仓位.客户.编码"),
                    FPickBinId_FF100002_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "发料仓位.客户.名称"),
                    FPickBinId_FF100003 = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "发料仓位.供应商.编码"),
                    FPickBinId_FF100003_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "发料仓位.供应商.名称"),
                    FPickBinId_FF100004 = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "发料仓位.服务机客户.编码"),
                    FPickBinId_FF100004_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "发料仓位.服务机客户.名称"),
                    FOverControlMode = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "超发控制方式"),
                    FBOMUnitId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "子项单位"),
                    FMinIssueQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "最小发料批量"),
                    FIsKitting = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "是否关键件"),
                    FIsCompleteSet = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "是否齐套件"),
                    FStdLaborPrePareTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "标准人员准备工时"),
                    FStdLaborProcessTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "标准人员实作工时"),
                    FDefaultRouting_Name = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "默认工艺路线"),
                    FPerUnitStandHour = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "标准工时"),
                    FStdMachinePrepareTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "标准机器准备工时"),
                    FConsumVolatility = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "消耗波动(%)"),
                    FLOSSPERCENT = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "变动损耗率(%)"),
                    FIsSNCarryToParent = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "序列号携带到父项"),
                    FStdMachineProcessTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "标准机器实作工时"),
                    FIsProductLine = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "生产线生产"),
                    FProduceBillType_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "生产类型"),
                    FOrgTrustBillType_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "组织间受托类型"),
                    FISMinIssueQty = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "领料考虑最小发料批量"),
                    FIsECN = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用ECN"),
                    FIsEnable1 = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用"),
                    FIsAffectPrice1 = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "影响价格"),
                    FIsAffectPlan1 = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "影响计划"),
                    FIsAffectCost1 = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "影响出库成本"),
                    FAuxPropertyId_Name = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "辅助属性"),
                    FIsComControl = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "组合控制"),
                    FCheckIncoming = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "来料检验"),
                    FCheckStock = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "库存检验"),
                    FCheckProduct = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "产品检验"),
                    FIncSampSchemeId_Name = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "抽样方案"),
                    FIncQcSchemeId_Name = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "质检方案"),
                    FEnableCyclistQCSTK = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用库存周期复检"),
                    FStockCycle = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "复检周期"),
                    FEnableCyclistQCSTKEW = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用库存周期复检提醒"),
                    FIsSNPRDTracy = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "生产追溯"),
                    FEWLeadDay = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "提醒提前期"),
                    FWARRANTY = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "保修期"),
                    FOutLmtUnit = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "超发控制单位"),
                    FInspectGroupId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "质检组"),
                    FCheckDelivery = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "发货检验"),
                    FDefBarCodeRuleId_Name = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "默认条码规则"),
                    FCheckReturn = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "退货检验"),
                    FInspectorId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "质检员"),
                    FCONFIGTYPE = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "配置生产"),
                    FFeatureItem = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "特征件子项"),
                    FPrintCount = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "重复打印数"),
                    FMinIssueUnitId_Name = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "最小发料批量单位"),
                    FMdlId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "产品模型"),
                    FMdlMaterialId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "模型物料"),
                    FTaxCategoryCodeId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "税收分类编码"),
                    FCheckEntrusted = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "受托材料检验"),
                    FSuite = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "套件"),
                    FBoxStandardQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "单箱标准数量"),
                    FSalGroup_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "销售分组"),
                    FCheckOther = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "其他检验"),
                    FIsTaxEnjoy = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "享受税收优惠政策"),
                    FTaxDiscountsType = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "税收优惠政策类型"),
                    FStandHourUnitId = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "工时单位"),
                    FCostPriceRate = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "结算成本价加减价比例(%)"),
                    FBackFlushType = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "倒冲数量"),
                    FAccuLeadTime = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "累计提前期"),
                    FProductLine_Name = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "产品系列"),
                    FWriteOffQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "冲销数量"),
                    FFIXLOSS = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "固定损耗"),
                    FPlanIdent_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "计划标识"),
                    FProScheTrackId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "订单进度分组"),
                    FMinPackCount = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "最小包装数"),
                    FDailyOutQty = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "日产量"),
                    FIsFirstInspect = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "产品首检"),
                    FCheckReturnMtrl = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "生产退料检验"),
                    FForbidReson_2052 = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "禁用原因"),
                    FForbidResonIsUsed = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "已使用"),
                    FUnValidateExpQty = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "不参与可发量统计"),
                    F_WLLX = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "物料类型"),
                    FIsEnableSchedule = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "启用日排产"),
                    F_ZJGLWLH_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "直接关联物料号"),
                    FDefaultLineId_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "默认产线"),
                    F_DYDWLX = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "电压/电网类型"),
                    F_GWLH_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "根物料号"),
                    F_GLD_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "功率段"),
                    F_DZLSX = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "电子料属性"),
                    F_JWLBMU8 = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "旧物料编码U8"),
                    F_PP_Name = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "品牌"),
                    F_ZJCSGS = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "整机测试工时"),
                    F_ZYGS = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "作业工时"),
                    F_GSZHGGRQ = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "工时最后更改日期"),
                    F_TJZLZHGGRQ = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "体积重量最后更改日期"),
                    F_SMZQZHGGRQ = table.Column<DateTime>(type: "datetime2", nullable: true, comment: "生命周期最后更改日期"),
                    F_TJZLZHGGR_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "体积重量最后更改人"),
                    F_SMZQZHGGR_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "生命周期最后更改人"),
                    F_GSZHGGR_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "工时最后更改人"),
                    F_ZJZB_Name = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "整机质保(月)"),
                    F_SFJLPCH = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "是否记录批次号"),
                    F_YWLX = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "业务类型"),
                    F_CPPLLB = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "产品披露类别"),
                    F_YZSG = table.Column<string>(type: "nvarchar(10)", maxLength: 10, nullable: true, comment: "已终审过"),
                    F_WLSQR_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "物料申请人"),
                    F_CPX_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "产品线"),
                    F_CPFL_Name = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "产品分类"),
                    F_SMZQ = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "料号生命周期"),
                    F_YXSL = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许收料"),
                    F_XSXH_2052 = table.Column<string>(type: "nvarchar(80)", maxLength: 80, nullable: true, comment: "SAJ型号"),
                    F_HLBZL = table.Column<decimal>(type: "decimal(23,10)", precision: 23, scale: 10, nullable: true, comment: "回料包装量"),
                    F_BZGG = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "包装规格"),
                    F_GYS = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "供应商"),
                    F_JCYY = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: true, comment: "禁采原因"),
                    F_YXQG = table.Column<string>(type: "nvarchar(1)", maxLength: 1, nullable: true, comment: "允许请购")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_in_kd_material", x => x.Id);
                },
                comment: "物料");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "in_kd_bom");

            migrationBuilder.DropTable(
                name: "in_kd_material");
        }
    }
}