//
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("20250506070902_InitialCreate6")]
partial class InitialCreate6
{
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");
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("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.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.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(2)
.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("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("仓库信息表");
});
#pragma warning restore 612, 618
}
}
}