DEMOMySql/MicroServices/Business/Business.Host/Migrations/BusinessExtMigrationDb/20230323032012_init.cs

using System;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace Business.Migrations.BusinessExtMigrationDb
{
    public partial class init : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AlterDatabase()
                .Annotation("MySql:CharSet", "utf8mb4");

            migrationBuilder.CreateTable(
                name: "in_kd_bom",
                columns: table => new
                {
                    Id = table.Column<long>(type: "bigint", nullable: false)
                        .Annotation("MySql:ValueGenerationStrategy", MySqlValueGenerationStrategy.IdentityColumn),
                    FUseOrgId_Name = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "使用组织")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FNumber = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "BOM版本")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FName_2052 = table.Column<string>(type: "varchar(10)", maxLength: 10, nullable: true, comment: "BOM简称")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FBOMCATEGORY = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "BOM分类")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FMATERIALID_Name = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "父项物料编码")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FITEMNAME = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "物料名称")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FITEMMODEL = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "规格型号")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FITEMPPROPERTY = table.Column<string>(type: "varchar(10)", maxLength: 10, nullable: true, comment: "数据状态")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FReplaceGroup = table.Column<int>(type: "int", nullable: true, comment: "项次"),
                    FReplacePriority = table.Column<int>(type: "int", nullable: true, comment: "替代优先级"),
                    FSubstitutionId_Name = table.Column<string>(type: "varchar(255)", maxLength: 255, nullable: true, comment: "80")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FMATERIALIDCHILD_Name = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "子项物料编码")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FCHILDITEMNAME = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "子项物料名称")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FCHILDITEMMODEL = table.Column<DateTime>(type: "datetime(6)", maxLength: 80, nullable: true, comment: "子项规格型号"),
                    FSupplyType = table.Column<string>(type: "varchar(1)", maxLength: 1, nullable: true, comment: "供应类型")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FCHILDUNITID_Name = table.Column<string>(type: "varchar(10)", maxLength: 10, nullable: true, comment: "子项单位")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FChildSupplyOrgId_Name = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "供应组织")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    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: "varchar(80)", maxLength: 80, nullable: true, comment: "作业")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FReplacePolicy = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "替代策略")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FReplaceType = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "替代方式")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FIskeyItem = table.Column<string>(type: "varchar(1)", maxLength: 1, nullable: true, comment: "替代主料")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    FSubstitutionName = table.Column<string>(type: "varchar(80)", maxLength: 80, nullable: true, comment: "替代方案名称")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    F_ZXWLMS = table.Column<string>(type: "varchar(255)", maxLength: 255, nullable: true, comment: "子项物料描述")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    F_ZXWLPP = table.Column<string>(type: "varchar(255)", maxLength: 255, nullable: true, comment: "子项物料品牌")
                        .Annotation("MySql:CharSet", "utf8mb4")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_in_kd_bom", x => x.Id);
                },
                comment: "物料清单")
                .Annotation("MySql:CharSet", "utf8mb4");

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

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

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