// <auto-generated />
|
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("20250429025531_InitialCreate")]
|
partial class InitialCreate
|
{
|
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<Guid>("Id")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("char(36)");
|
|
b.Property<string>("AreaDesc")
|
.HasMaxLength(200)
|
.HasColumnType("varchar(200)")
|
.HasComment("描述");
|
|
b.Property<string>("AreaName")
|
.IsRequired()
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("库区名称");
|
|
b.Property<string>("AreaNo")
|
.IsRequired()
|
.HasMaxLength(64)
|
.HasColumnType("varchar(64)")
|
.HasComment("库区编号");
|
|
b.Property<int>("AreaStatus")
|
.HasColumnType("int")
|
.HasComment("库区状态");
|
|
b.Property<int>("AreaType")
|
.HasColumnType("int")
|
.HasComment("库区类型");
|
|
b.Property<string>("ConcurrencyStamp")
|
.IsConcurrencyToken()
|
.HasMaxLength(40)
|
.HasColumnType("varchar(40)")
|
.HasColumnName("ConcurrencyStamp");
|
|
b.Property<DateTime>("CreationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("CreationTime");
|
|
b.Property<Guid?>("CreatorId")
|
.HasColumnType("char(36)")
|
.HasColumnName("CreatorId");
|
|
b.Property<Guid?>("DeleterId")
|
.HasColumnType("char(36)")
|
.HasColumnName("DeleterId");
|
|
b.Property<DateTime?>("DeletionTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("DeletionTime");
|
|
b.Property<string>("ExtraProperties")
|
.HasColumnType("longtext")
|
.HasColumnName("ExtraProperties");
|
|
b.Property<bool>("IsDeleted")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("tinyint(1)")
|
.HasDefaultValue(false)
|
.HasColumnName("IsDeleted");
|
|
b.Property<bool?>("IsDisabled")
|
.HasColumnType("tinyint(1)")
|
.HasComment("是否禁用");
|
|
b.Property<DateTime?>("LastModificationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("LastModificationTime");
|
|
b.Property<Guid?>("LastModifierId")
|
.HasColumnType("char(36)")
|
.HasColumnName("LastModifierId");
|
|
b.Property<string>("RedundantField1")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("冗余字段1 - 预留扩展用途");
|
|
b.Property<string>("RedundantField2")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("冗余字段2 - 预留扩展用途");
|
|
b.Property<string>("RedundantField3")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("冗余字段3 - 预留扩展用途");
|
|
b.Property<string>("Remark")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("备注");
|
|
b.Property<int>("Sort")
|
.HasColumnType("int")
|
.HasComment("排序");
|
|
b.Property<string>("StoreCode")
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("仓库代码");
|
|
b.Property<string>("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<Guid>("Id")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("char(36)");
|
|
b.Property<string>("ConcurrencyStamp")
|
.IsConcurrencyToken()
|
.HasMaxLength(40)
|
.HasColumnType("varchar(40)")
|
.HasColumnName("ConcurrencyStamp");
|
|
b.Property<string>("ContainerNo")
|
.IsRequired()
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("托盘编号");
|
|
b.Property<int>("ContainerStatus")
|
.HasColumnType("int")
|
.HasComment("托盘状态");
|
|
b.Property<int>("ContainerType")
|
.HasColumnType("int")
|
.HasComment("托盘类型");
|
|
b.Property<DateTime>("CreationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("CreationTime");
|
|
b.Property<Guid?>("CreatorId")
|
.HasColumnType("char(36)")
|
.HasColumnName("CreatorId");
|
|
b.Property<Guid?>("DeleterId")
|
.HasColumnType("char(36)")
|
.HasColumnName("DeleterId");
|
|
b.Property<DateTime?>("DeletionTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("DeletionTime");
|
|
b.Property<int?>("ExceptionNumber")
|
.HasColumnType("int")
|
.HasComment("异常数量");
|
|
b.Property<string>("ExtraProperties")
|
.HasColumnType("longtext")
|
.HasColumnName("ExtraProperties");
|
|
b.Property<bool>("IsDeleted")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("tinyint(1)")
|
.HasDefaultValue(false)
|
.HasColumnName("IsDeleted");
|
|
b.Property<bool?>("IsDisabled")
|
.HasColumnType("tinyint(1)")
|
.HasComment("是否禁用");
|
|
b.Property<DateTime?>("LastModificationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("LastModificationTime");
|
|
b.Property<Guid?>("LastModifierId")
|
.HasColumnType("char(36)")
|
.HasColumnName("LastModifierId");
|
|
b.Property<decimal?>("LimitHeight")
|
.HasPrecision(18, 2)
|
.HasColumnType("decimal(18,2)")
|
.HasComment("限高");
|
|
b.Property<decimal?>("LimitLength")
|
.HasPrecision(18, 2)
|
.HasColumnType("decimal(18,2)")
|
.HasComment("限长");
|
|
b.Property<decimal?>("LimitWidth")
|
.HasPrecision(18, 2)
|
.HasColumnType("decimal(18,2)")
|
.HasComment("限宽");
|
|
b.Property<int?>("MaterialNumber")
|
.HasColumnType("int")
|
.HasComment("物料数量");
|
|
b.Property<decimal?>("MaxWeight")
|
.HasPrecision(18, 2)
|
.HasColumnType("decimal(18,2)")
|
.HasComment("载重上限");
|
|
b.Property<string>("RedundantField1")
|
.HasMaxLength(200)
|
.HasColumnType("varchar(200)")
|
.HasComment("冗余字段1 - 预留扩展用途");
|
|
b.Property<string>("RedundantField2")
|
.HasMaxLength(200)
|
.HasColumnType("varchar(200)")
|
.HasComment("冗余字段2 - 预留扩展用途");
|
|
b.Property<string>("RedundantField3")
|
.HasMaxLength(200)
|
.HasColumnType("varchar(200)")
|
.HasComment("冗余字段3 - 预留扩展用途");
|
|
b.Property<string>("Remark")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("备注");
|
|
b.Property<int>("Sort")
|
.HasColumnType("int")
|
.HasComment("排序");
|
|
b.Property<decimal?>("SpecHeight")
|
.HasPrecision(18, 2)
|
.HasColumnType("decimal(18,2)")
|
.HasComment("高度");
|
|
b.Property<decimal?>("SpecLength")
|
.HasPrecision(18, 2)
|
.HasColumnType("decimal(18,2)")
|
.HasComment("长度");
|
|
b.Property<decimal?>("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<Guid>("Id")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("char(36)");
|
|
b.Property<string>("Certification")
|
.HasMaxLength(128)
|
.HasColumnType("varchar(128)")
|
.HasComment("证书编号");
|
|
b.Property<string>("ConcurrencyStamp")
|
.IsConcurrencyToken()
|
.HasMaxLength(40)
|
.HasColumnType("varchar(40)")
|
.HasColumnName("ConcurrencyStamp");
|
|
b.Property<DateTime>("CreationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("CreationTime");
|
|
b.Property<Guid?>("CreatorId")
|
.HasColumnType("char(36)")
|
.HasColumnName("CreatorId");
|
|
b.Property<Guid?>("DeleterId")
|
.HasColumnType("char(36)")
|
.HasColumnName("DeleterId");
|
|
b.Property<DateTime?>("DeletionTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("DeletionTime");
|
|
b.Property<string>("ExtraProperties")
|
.HasColumnType("longtext")
|
.HasColumnName("ExtraProperties");
|
|
b.Property<string>("Factory")
|
.HasMaxLength(64)
|
.HasColumnType("varchar(64)")
|
.HasComment("生产工厂");
|
|
b.Property<bool>("IsDeleted")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("tinyint(1)")
|
.HasDefaultValue(false)
|
.HasColumnName("IsDeleted");
|
|
b.Property<bool?>("IsDisabled")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("tinyint(1)")
|
.HasDefaultValue(false)
|
.HasComment("是否禁用");
|
|
b.Property<bool>("IsMainBranch")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("tinyint(1)")
|
.HasDefaultValue(false)
|
.HasComment("是否为主支管");
|
|
b.Property<DateTime?>("LastModificationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("LastModificationTime");
|
|
b.Property<Guid?>("LastModifierId")
|
.HasColumnType("char(36)")
|
.HasColumnName("LastModifierId");
|
|
b.Property<decimal>("Length")
|
.HasColumnType("decimal(18,2)")
|
.HasComment("长度（单位：m）");
|
|
b.Property<string>("MaterialCode")
|
.IsRequired()
|
.HasMaxLength(64)
|
.HasColumnType("varchar(64)")
|
.HasComment("物料编码（唯一标识）");
|
|
b.Property<string>("MaterialName")
|
.IsRequired()
|
.HasMaxLength(128)
|
.HasColumnType("varchar(128)")
|
.HasComment("物料名称");
|
|
b.Property<string>("MaterialQuality")
|
.HasMaxLength(64)
|
.HasColumnType("varchar(64)")
|
.HasComment("材质（如：304不锈钢）");
|
|
b.Property<int>("MaterialType")
|
.HasColumnType("int")
|
.HasComment("物料类型（枚举值）");
|
|
b.Property<decimal>("OuterDiameter")
|
.HasColumnType("decimal(18,2)")
|
.HasComment("外径（单位：mm）");
|
|
b.Property<string>("PrimaryUnit")
|
.HasMaxLength(20)
|
.HasColumnType("varchar(20)")
|
.HasComment("主单位（如：kg、m、个）");
|
|
b.Property<int>("PurchaseType")
|
.HasColumnType("int")
|
.HasComment("采购类型（枚举值）");
|
|
b.Property<string>("RedundantField1")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("冗余字段1 - 预留扩展用途");
|
|
b.Property<string>("RedundantField2")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("冗余字段2 - 预留扩展用途");
|
|
b.Property<string>("RedundantField3")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("冗余字段3 - 预留扩展用途");
|
|
b.Property<string>("Remark")
|
.HasMaxLength(500)
|
.HasColumnType("varchar(500)")
|
.HasComment("备注");
|
|
b.Property<int>("Sort")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("int")
|
.HasDefaultValue(0)
|
.HasComment("排序");
|
|
b.Property<string>("Standard")
|
.HasMaxLength(128)
|
.HasColumnType("varchar(128)")
|
.HasComment("规格/标准（如：GB/T 8163-2018）");
|
|
b.Property<decimal>("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<Guid>("Id")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("char(36)");
|
|
b.Property<int>("Aisle")
|
.HasColumnType("int")
|
.HasComment("巷道");
|
|
b.Property<string>("AreaCode")
|
.IsRequired()
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("所在库区");
|
|
b.Property<int>("ColumnNo")
|
.HasColumnType("int")
|
.HasComment("列");
|
|
b.Property<string>("ConcurrencyStamp")
|
.IsConcurrencyToken()
|
.HasMaxLength(40)
|
.HasColumnType("varchar(40)")
|
.HasColumnName("ConcurrencyStamp");
|
|
b.Property<DateTime>("CreationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("CreationTime");
|
|
b.Property<Guid?>("CreatorId")
|
.HasColumnType("char(36)")
|
.HasColumnName("CreatorId");
|
|
b.Property<Guid?>("DeleterId")
|
.HasColumnType("char(36)")
|
.HasColumnName("DeleterId");
|
|
b.Property<DateTime?>("DeletionTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("DeletionTime");
|
|
b.Property<int>("EmptyContainer")
|
.HasColumnType("int")
|
.HasComment("是否空托");
|
|
b.Property<string>("ExtraProperties")
|
.HasColumnType("longtext")
|
.HasColumnName("ExtraProperties");
|
|
b.Property<bool>("IsDeleted")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("tinyint(1)")
|
.HasDefaultValue(false)
|
.HasColumnName("IsDeleted");
|
|
b.Property<bool?>("IsDisabled")
|
.HasColumnType("tinyint(1)")
|
.HasComment("是否禁用");
|
|
b.Property<int>("Islock")
|
.HasColumnType("int")
|
.HasComment("是否锁定");
|
|
b.Property<DateTime?>("LastModificationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("LastModificationTime");
|
|
b.Property<Guid?>("LastModifierId")
|
.HasColumnType("char(36)")
|
.HasColumnName("LastModifierId");
|
|
b.Property<int>("LayerNo")
|
.HasColumnType("int")
|
.HasComment("层");
|
|
b.Property<string>("PlaceNo")
|
.IsRequired()
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("编号");
|
|
b.Property<int>("PlaceStatus")
|
.HasColumnType("int")
|
.HasComment("货位状态");
|
|
b.Property<string>("RedundantField1")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("冗余字段1 - 预留扩展用途");
|
|
b.Property<string>("RedundantField2")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("冗余字段2 - 预留扩展用途");
|
|
b.Property<string>("RedundantField3")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("冗余字段3 - 预留扩展用途");
|
|
b.Property<string>("Remark")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("备注");
|
|
b.Property<int>("RowNo")
|
.HasColumnType("int")
|
.HasComment("排");
|
|
b.Property<int>("Sort")
|
.HasColumnType("int")
|
.HasComment("排序");
|
|
b.Property<int>("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<Guid>("Id")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("char(36)");
|
|
b.Property<string>("ConcurrencyStamp")
|
.IsConcurrencyToken()
|
.HasMaxLength(40)
|
.HasColumnType("varchar(40)")
|
.HasColumnName("ConcurrencyStamp");
|
|
b.Property<DateTime>("CreationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("CreationTime");
|
|
b.Property<Guid?>("CreatorId")
|
.HasColumnType("char(36)")
|
.HasColumnName("CreatorId");
|
|
b.Property<Guid?>("DeleterId")
|
.HasColumnType("char(36)")
|
.HasColumnName("DeleterId");
|
|
b.Property<DateTime?>("DeletionTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("DeletionTime");
|
|
b.Property<string>("ExtraProperties")
|
.HasColumnType("longtext")
|
.HasColumnName("ExtraProperties");
|
|
b.Property<bool>("IsDeleted")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("tinyint(1)")
|
.HasDefaultValue(false)
|
.HasColumnName("IsDeleted");
|
|
b.Property<bool?>("IsDisabled")
|
.HasColumnType("tinyint(1)")
|
.HasComment("是否禁用");
|
|
b.Property<DateTime?>("LastModificationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("LastModificationTime");
|
|
b.Property<Guid?>("LastModifierId")
|
.HasColumnType("char(36)")
|
.HasColumnName("LastModifierId");
|
|
b.Property<string>("RedundantField1")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("冗余字段1 - 预留扩展用途");
|
|
b.Property<string>("RedundantField2")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("冗余字段2 - 预留扩展用途");
|
|
b.Property<string>("RedundantField3")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("冗余字段3 - 预留扩展用途");
|
|
b.Property<string>("Remark")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("备注");
|
|
b.Property<int>("Sort")
|
.HasColumnType("int")
|
.HasComment("排序");
|
|
b.Property<string>("StoreCode")
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("仓库代码");
|
|
b.Property<string>("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
|
}
|
}
|
}
|
