// using System; using CMS.Plugin.HIAWms.MySQL; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; using Volo.Abp.EntityFrameworkCore; #nullable disable namespace CMS.Plugin.HIAWms.MySQL.Migrations { [DbContext(typeof(CMSPluginDbContext))] [Migration("20250509065902_InitialCreate11")] partial class InitialCreate11 { protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("_Abp_DatabaseProvider", EfCoreDatabaseProvider.MySql) .HasAnnotation("ProductVersion", "6.0.16") .HasAnnotation("Relational:MaxIdentifierLength", 64); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsAreas.WmsArea", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("AreaDesc") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("描述"); b.Property("AreaName") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("库区名称"); b.Property("AreaNo") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("库区编号"); b.Property("AreaStatus") .HasColumnType("int") .HasComment("库区状态"); b.Property("AreaType") .HasColumnType("int") .HasComment("库区类型"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("是否禁用"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("RedundantField1") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("冗余字段1 - 预留扩展用途"); b.Property("RedundantField2") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("冗余字段2 - 预留扩展用途"); b.Property("RedundantField3") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("冗余字段3 - 预留扩展用途"); b.Property("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("备注"); b.Property("Sort") .HasColumnType("int") .HasComment("排序"); b.Property("StoreCode") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("仓库代码"); b.Property("StoreName") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("仓库名称"); b.HasKey("Id"); b.HasIndex("AreaName"); b.ToTable("scms_wmsareas", (string)null); b.HasComment("库区表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainerPlaces.WmsContainerPlace", b => { b.Property("PlaceNo") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("库位编码"); b.Property("ContainerNo") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("托盘编号"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp") .HasComment("并发戳"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime") .HasComment("创建时间"); b.Property("CreatorId") .HasMaxLength(36) .HasColumnType("char(36)") .HasColumnName("CreatorId") .HasComment("创建人ID"); b.Property("CreatorName") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("创建人"); b.Property("DeleteRemark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("删除备注"); b.Property("DeleterId") .HasMaxLength(36) .HasColumnType("char(36)") .HasColumnName("DeleterId") .HasComment("删除人ID"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime") .HasComment("删除时间"); b.Property("ExtraField1") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("扩展字段1"); b.Property("ExtraField2") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("扩展字段2"); b.Property("ExtraField3") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("扩展字段3"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties") .HasComment("扩展属性"); b.Property("Id") .HasColumnType("char(36)"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted") .HasComment("是否删除"); b.Property("IsDisabled") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasComment("是否禁用"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime") .HasComment("修改时间"); b.Property("LastModifierId") .HasMaxLength(36) .HasColumnType("char(36)") .HasColumnName("LastModifierId") .HasComment("修改人ID"); b.Property("LastModifierName") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("修改人"); b.Property("OperationRemark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("操作备注"); b.Property("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("备注"); b.Property("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("排序"); b.HasKey("PlaceNo", "ContainerNo"); b.HasIndex("ContainerNo"); b.HasIndex("PlaceNo"); b.ToTable("scms_wmscontainerplaces", (string)null); b.HasComment("容器库位关系表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainers.WmsContainer", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("ContainerNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("托盘编号"); b.Property("ContainerStatus") .HasColumnType("int") .HasComment("托盘状态"); b.Property("ContainerType") .HasColumnType("int") .HasComment("托盘类型"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("ExceptionNumber") .HasColumnType("int") .HasComment("异常数量"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("是否禁用"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("LimitHeight") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("限高"); b.Property("LimitLength") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("限长"); b.Property("LimitWidth") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("限宽"); b.Property("MaterialNumber") .HasColumnType("int") .HasComment("物料数量"); b.Property("MaxWeight") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("载重上限"); b.Property("RedundantField1") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("冗余字段1 - 预留扩展用途"); b.Property("RedundantField2") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("冗余字段2 - 预留扩展用途"); b.Property("RedundantField3") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("冗余字段3 - 预留扩展用途"); b.Property("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("备注"); b.Property("Sort") .HasColumnType("int") .HasComment("排序"); b.Property("SpecHeight") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("高度"); b.Property("SpecLength") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("长度"); b.Property("SpecWidth") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("宽度"); b.HasKey("Id"); b.HasIndex("ContainerNo") .IsUnique(); b.HasIndex("ContainerStatus"); b.HasIndex("ContainerType"); b.ToTable("scms_wmscontainers", (string)null); b.HasComment("托盘信息表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsInOutStockOrder.WmsInOutStockOrder", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("CompleteNumber") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("完成数量"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("DistributeNumber") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("下发数量"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasComment("是否禁用"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("MaterialBatch") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("批次号"); b.Property("MaterialModel") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("型号"); b.Property("MaterialName") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("物料名称"); b.Property("MaterialNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("物料件号"); b.Property("MaterialNumber") .HasColumnType("int") .HasComment("单据数量"); b.Property("OperateTime") .HasColumnType("datetime(6)") .HasComment("操作时间"); b.Property("OrderNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("单据编号"); b.Property("OrderStatus") .HasColumnType("int") .HasComment("单据状态"); b.Property("OrderType") .HasColumnType("int") .HasComment("单据类型"); b.Property("PlanNo") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("关联计划编号"); b.Property("Priority") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(1) .HasComment("优先级"); b.Property("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("备注"); b.Property("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("排序"); b.Property("StockType") .HasColumnType("int") .HasComment("操作类型（枚举值）"); b.HasKey("Id"); b.HasIndex("MaterialBatch"); b.HasIndex("MaterialNo"); b.HasIndex("OperateTime"); b.HasIndex("OrderNo") .IsUnique(); b.HasIndex("PlanNo"); b.ToTable("scms_wmsinoutstockorder", (string)null); b.HasComment("出入库单据表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsInOutStockOrderDetail.WmsInOutStockOrderDetail", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("ContainerNo") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("容器编号"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasComment("是否禁用"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("MaterialBatch") .HasColumnType("int") .HasComment("物料批次"); b.Property("MaterialId") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("物料唯一码"); b.Property("MaterialModel") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("机型"); b.Property("MaterialName") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("物料名称"); b.Property("MaterialNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("物料件号"); b.Property("OrderNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("单据编号"); b.Property("OrderType") .HasColumnType("int") .HasComment("单据类型（枚举值）"); b.Property("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("备注"); b.Property("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("排序"); b.HasKey("Id"); b.HasIndex("ContainerNo"); b.HasIndex("MaterialId"); b.HasIndex("MaterialNo"); b.HasIndex("OrderNo"); b.HasIndex("OrderNo", "OrderType"); b.ToTable("scms_wmsinoutstockorderdetail", (string)null); b.HasComment("出入库单据明细表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsInOutStockRecord.WmsInOutStockRecord", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("ContainerNo") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("容器编号"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("是否禁用"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("MaterialId") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("物料ID"); b.Property("MaterialModel") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("机型"); b.Property("MaterialName") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("物料名称"); b.Property("MaterialNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("物料件号"); b.Property("OperateTime") .HasColumnType("datetime(6)") .HasComment("操作时间"); b.Property("OrderNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("单据编号"); b.Property("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("备注"); b.Property("Sort") .HasColumnType("int") .HasComment("排序"); b.Property("SourcePlace") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("起始库位"); b.Property("StockType") .HasColumnType("int") .HasComment("操作类型"); b.Property("TaskNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("任务号"); b.Property("ToPlace") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("目标库位"); b.HasKey("Id"); b.HasIndex("ContainerNo"); b.HasIndex("MaterialId"); b.HasIndex("MaterialNo"); b.HasIndex("OperateTime"); b.HasIndex("OrderNo"); b.HasIndex("StockType"); b.HasIndex("TaskNo"); b.ToTable("scms_wmsinoutstockrecords", (string)null); b.HasComment("出入库记录表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialContainer.WmsMaterialContainer", b => { b.Property("MaterialId") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("物料ID"); b.Property("ContainerNo") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("托盘编号"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("Id") .HasColumnType("char(36)"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .HasColumnType("tinyint(1)"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("Sort") .HasColumnType("int"); b.HasKey("MaterialId", "ContainerNo"); b.HasIndex("ContainerNo"); b.HasIndex("MaterialId"); b.ToTable("scms_wmsmaterialcontainer", (string)null); b.HasComment("物料容器关系表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialInfos.WmsMaterialInfo", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("CheckStatus") .HasColumnType("int") .HasComment("检验状态(0:未检验,1:检验通过,2:检验不通过)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("是否禁用"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("MaterialBatch") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("物料批号"); b.Property("MaterialId") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("物料唯一码"); b.Property("MaterialModel") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("机型/规格"); b.Property("MaterialName") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("物料名称"); b.Property("MaterialNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("物料代号"); b.Property("RedundantField1") .HasMaxLength(255) .HasColumnType("varchar(255)") .HasComment("冗余字段1"); b.Property("RedundantField2") .HasMaxLength(255) .HasColumnType("varchar(255)") .HasComment("冗余字段2"); b.Property("RedundantField3") .HasMaxLength(255) .HasColumnType("varchar(255)") .HasComment("冗余字段3"); b.Property("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("备注"); b.Property("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("排序"); b.Property("StockNumber") .HasColumnType("int") .HasComment("库存数量"); b.Property("SupplierCode") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("供应商编号"); b.HasKey("Id"); b.HasIndex("CheckStatus"); b.HasIndex("MaterialBatch"); b.HasIndex("MaterialId") .IsUnique(); b.HasIndex("MaterialName"); b.HasIndex("MaterialNo") .IsUnique(); b.HasIndex("SupplierCode"); b.ToTable("scms_wmsmaterialinfos", (string)null); b.HasComment("WMS物料信息表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterials.WmsMaterial", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("Certification") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("证书编号"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("Factory") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("生产工厂"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasComment("是否禁用"); b.Property("IsMainBranch") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("是否为主支管"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("Length") .HasColumnType("decimal(18,2)") .HasComment("长度（单位：m）"); b.Property("MaterialNo") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("物料编码（唯一标识）"); b.Property("MaterialModel") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("型号"); b.Property("MaterialName") .IsRequired() .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("物料名称"); b.Property("MaterialQuality") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("材质（如：304不锈钢）"); b.Property("MaterialType") .HasColumnType("int") .HasComment("物料类型（枚举值）"); b.Property("OuterDiameter") .HasColumnType("decimal(18,2)") .HasComment("外径（单位：mm）"); b.Property("PrimaryUnit") .HasMaxLength(20) .HasColumnType("varchar(20)") .HasComment("主单位（如：kg、m、个）"); b.Property("PurchaseType") .HasColumnType("int") .HasComment("采购类型（枚举值）"); b.Property("RedundantField1") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("冗余字段1 - 预留扩展用途"); b.Property("RedundantField2") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("冗余字段2 - 预留扩展用途"); b.Property("RedundantField3") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("冗余字段3 - 预留扩展用途"); b.Property("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("备注"); b.Property("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("排序"); b.Property("Standard") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("规格/标准（如：GB/T 8163-2018）"); b.Property("WallThickness") .HasColumnType("decimal(18,2)") .HasComment("壁厚（单位：mm）"); b.HasKey("Id"); b.HasIndex("MaterialNo") .IsUnique(); b.HasIndex("MaterialName"); b.HasIndex("MaterialType"); b.HasIndex("PurchaseType"); b.ToTable("scms_wmsmaterials", (string)null); b.HasComment("物料基础信息表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialStocks.WmsMaterialStock", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("AreaCode") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("区域编号"); b.Property("AreaName") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("库区名称"); b.Property("CheckStatus") .HasColumnType("int") .HasComment("检验状态(1:未检验,2:检验通过,3:检验不通过)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("ContainerNo") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("容器编号"); b.Property("ContainerStatus") .HasColumnType("int") .HasComment("容器状态"); b.Property("ContainerType") .HasColumnType("int") .HasComment("容器类型"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("EmptyContainer") .HasColumnType("int") .HasComment("是否空托(2:否,1:是)"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("InStockTime") .HasColumnType("datetime(6)") .HasComment("入库时间"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("是否禁用"); b.Property("IsLock") .HasColumnType("int") .HasComment("是否锁定(2:未锁定,1:已锁定)"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("MaterialBatch") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("物料批次"); b.Property("MaterialId") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("物料ID"); b.Property("MaterialModel") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("机型/规格"); b.Property("MaterialName") .IsRequired() .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("物料名称"); b.Property("MaterialNo") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("物料编号"); b.Property("PlaceNo") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("库位编号"); b.Property("PlaceStatus") .HasColumnType("int") .HasComment("库位状态;"); b.Property("RedundantField1") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("冗余字段1 - 预留扩展用途"); b.Property("RedundantField2") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("冗余字段2 - 预留扩展用途"); b.Property("RedundantField3") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("冗余字段3 - 预留扩展用途"); b.Property("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("备注"); b.Property("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("排序"); b.Property("StockNumber") .HasColumnType("int") .HasComment("库存数量"); b.Property("StorageTypeNo") .HasColumnType("int") .HasComment("库位类型"); b.Property("SupplierCode") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("供应商编号"); b.HasKey("Id"); b.HasIndex("AreaCode"); b.HasIndex("ContainerNo"); b.HasIndex("MaterialName"); b.HasIndex("MaterialNo"); b.HasIndex("PlaceNo"); b.HasIndex("MaterialBatch", "SupplierCode"); b.ToTable("scms_wmsmaterialstocks", (string)null); b.HasComment("WMS物料库存表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsPlaces.WmsPlace", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("Aisle") .HasColumnType("int") .HasComment("巷道"); b.Property("AreaCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("所在库区"); b.Property("ColumnNo") .HasColumnType("int") .HasComment("列"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("EmptyContainer") .HasColumnType("int") .HasComment("是否空托"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("是否禁用"); b.Property("Islock") .HasColumnType("int") .HasComment("是否锁定"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("LayerNo") .HasColumnType("int") .HasComment("层"); b.Property("MaxStockNumber") .HasColumnType("int") .HasComment("最大库存量"); b.Property("PlaceNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("编号"); b.Property("PlaceStatus") .HasColumnType("int") .HasComment("货位状态"); b.Property("RedundantField1") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("冗余字段1 - 预留扩展用途"); b.Property("RedundantField2") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("冗余字段2 - 预留扩展用途"); b.Property("RedundantField3") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("冗余字段3 - 预留扩展用途"); b.Property("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("备注"); b.Property("RowNo") .HasColumnType("int") .HasComment("排"); b.Property("Sort") .HasColumnType("int") .HasComment("排序"); b.Property("StorageTypeNo") .HasColumnType("int") .HasComment("货位类型"); b.HasKey("Id"); b.HasIndex("AreaCode"); b.HasIndex("PlaceNo") .IsUnique(); b.HasIndex("PlaceStatus"); b.HasIndex("StorageTypeNo"); b.ToTable("scms_wmsplaces", (string)null); b.HasComment("库位表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsStores.WmsStore", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("是否禁用"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("RedundantField1") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("冗余字段1 - 预留扩展用途"); b.Property("RedundantField2") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("冗余字段2 - 预留扩展用途"); b.Property("RedundantField3") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("冗余字段3 - 预留扩展用途"); b.Property("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("备注"); b.Property("Sort") .HasColumnType("int") .HasComment("排序"); b.Property("StoreCode") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("仓库代码"); b.Property("StoreName") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("仓库名称"); b.HasKey("Id"); b.HasIndex("StoreName"); b.ToTable("scms_wmsstores", (string)null); b.HasComment("仓库信息表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsTask.WmsTask", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property("Aisle") .HasColumnType("int") .HasComment("巷道"); b.Property("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property("ContainerNo") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("托盘编号"); b.Property("CreationTime") .HasColumnType("datetime(6)") .HasColumnName("CreationTime"); b.Property("CreatorId") .HasColumnType("char(36)") .HasColumnName("CreatorId"); b.Property("DeleterId") .HasColumnType("char(36)") .HasColumnName("DeleterId"); b.Property("DeletionTime") .HasColumnType("datetime(6)") .HasColumnName("DeletionTime"); b.Property("DodeviceId") .HasColumnType("int") .HasComment("堆垛机ID"); b.Property("Dodevicetype") .HasColumnType("int") .HasComment("设备类型"); b.Property("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("是否禁用"); b.Property("IsNextTask") .HasColumnType("int") .HasComment("下个任务是否生成成功"); b.Property("IsRead") .HasColumnType("tinyint(1)") .HasComment("WCS是否可以读取"); b.Property("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property("MutableParam1") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("可变变量1"); b.Property("MutableParam2") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("可变变量2"); b.Property("MutableParam3") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("可变变量3"); b.Property("SonTaskType") .HasColumnType("int") .HasComment("子任务类型"); b.Property("Sort") .HasColumnType("int") .HasComment("排序"); b.Property("SourceOrderNo") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("来源单据号"); b.Property("SourcePlace") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("起始库位"); b.Property("TaskDodeviceStatus") .HasColumnType("int") .HasComment("设备任务状态"); b.Property("TaskLevel") .HasColumnType("int") .HasComment("任务等级"); b.Property("TaskNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("任务号"); b.Property("TaskStatus") .HasColumnType("int") .HasComment("任务状态"); b.Property("TaskType") .HasColumnType("int") .HasComment("任务类型"); b.Property("ToPlace") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("目标库位"); b.HasKey("Id"); b.HasIndex("ContainerNo"); b.HasIndex("DodeviceId"); b.HasIndex("IsRead"); b.HasIndex("Sort"); b.HasIndex("SourceOrderNo"); b.HasIndex("SourcePlace"); b.HasIndex("TaskNo") .IsUnique(); b.HasIndex("TaskStatus"); b.HasIndex("TaskType"); b.HasIndex("ToPlace"); b.ToTable("scms_wmstasks", (string)null); b.HasComment("任务表"); }); #pragma warning restore 612, 618 } } }