//
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("20250430035549_InitialCreate1")]
partial class InitialCreate1
{
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.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.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("MaterialCode")
.IsRequired()
.HasMaxLength(64)
.HasColumnType("varchar(64)")
.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("MaterialCode")
.IsUnique();
b.HasIndex("MaterialName");
b.HasIndex("MaterialType");
b.HasIndex("PurchaseType");
b.ToTable("scms_wmsmaterials", (string)null);
b.HasComment("物料基础信息表");
});
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
}
}
}