// <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("20250508112533_InitialCreate5")]
|
partial class InitialCreate5
|
{
|
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.WmsInOutStockRecord.WmsInOutStockRecord", 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")
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.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<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>("MaterialId")
|
.IsRequired()
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("物料ID");
|
|
b.Property<string>("MaterialModel")
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("机型");
|
|
b.Property<string>("MaterialName")
|
.HasMaxLength(100)
|
.HasColumnType("varchar(100)")
|
.HasComment("物料名称");
|
|
b.Property<string>("MaterialNo")
|
.IsRequired()
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("物料件号");
|
|
b.Property<DateTime?>("OperateTime")
|
.HasColumnType("datetime(6)")
|
.HasComment("操作时间");
|
|
b.Property<string>("OrderNo")
|
.IsRequired()
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("单据编号");
|
|
b.Property<string>("Remark")
|
.HasMaxLength(500)
|
.HasColumnType("varchar(500)")
|
.HasComment("备注");
|
|
b.Property<int>("Sort")
|
.HasColumnType("int")
|
.HasComment("排序");
|
|
b.Property<string>("SourcePlace")
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("起始库位");
|
|
b.Property<int>("StockType")
|
.HasColumnType("int")
|
.HasComment("操作类型");
|
|
b.Property<string>("TaskNo")
|
.IsRequired()
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("任务号");
|
|
b.Property<string>("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.WmsMaterial.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")
|
.HasComment("并发戳");
|
|
b.Property<DateTime>("CreationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("CreationTime")
|
.HasComment("创建时间");
|
|
b.Property<Guid?>("CreatorId")
|
.HasMaxLength(36)
|
.HasColumnType("char(36)")
|
.HasColumnName("CreatorId")
|
.HasComment("创建人ID");
|
|
b.Property<string>("CreatorName")
|
.HasMaxLength(64)
|
.HasColumnType("varchar(64)")
|
.HasComment("创建人");
|
|
b.Property<Guid?>("DeleterId")
|
.HasMaxLength(36)
|
.HasColumnType("char(36)")
|
.HasColumnName("DeleterId")
|
.HasComment("删除人ID");
|
|
b.Property<DateTime?>("DeletionTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("DeletionTime")
|
.HasComment("删除时间");
|
|
b.Property<string>("ExtraField1")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("扩展字段1");
|
|
b.Property<string>("ExtraField2")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("扩展字段2");
|
|
b.Property<string>("ExtraField3")
|
.HasMaxLength(256)
|
.HasColumnType("varchar(256)")
|
.HasComment("扩展字段3");
|
|
b.Property<string>("ExtraProperties")
|
.HasColumnType("longtext")
|
.HasColumnName("ExtraProperties")
|
.HasComment("扩展属性");
|
|
b.Property<string>("Factory")
|
.HasMaxLength(64)
|
.HasColumnType("varchar(64)")
|
.HasComment("生产工厂");
|
|
b.Property<bool>("IsDeleted")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("tinyint(1)")
|
.HasDefaultValue(false)
|
.HasColumnName("IsDeleted")
|
.HasComment("是否删除");
|
|
b.Property<bool?>("IsDisabled")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("tinyint(1)")
|
.HasDefaultValue(false)
|
.HasComment("是否禁用");
|
|
b.Property<int>("IsMainBranch")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("int")
|
.HasDefaultValue(2)
|
.HasComment("是否为主支管");
|
|
b.Property<bool?>("IsSelfMade")
|
.HasColumnType("tinyint(1)")
|
.HasComment("数量");
|
|
b.Property<bool>("IsValid")
|
.HasColumnType("tinyint(1)")
|
.HasComment("是否有效物料");
|
|
b.Property<DateTime?>("LastModificationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("LastModificationTime")
|
.HasComment("修改时间");
|
|
b.Property<Guid?>("LastModifierId")
|
.HasMaxLength(36)
|
.HasColumnType("char(36)")
|
.HasColumnName("LastModifierId")
|
.HasComment("修改人ID");
|
|
b.Property<string>("LastModifierName")
|
.HasMaxLength(64)
|
.HasColumnType("varchar(64)")
|
.HasComment("修改人");
|
|
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?>("NullLength")
|
.HasColumnType("decimal(65,30)");
|
|
b.Property<int>("Num")
|
.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?>("SelfNum")
|
.HasColumnType("int")
|
.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("仓库信息表");
|
});
|
|
modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsTask.WmsTask", b =>
|
{
|
b.Property<Guid>("Id")
|
.ValueGeneratedOnAdd()
|
.HasColumnType("char(36)");
|
|
b.Property<int?>("Aisle")
|
.HasColumnType("int")
|
.HasComment("巷道");
|
|
b.Property<string>("ConcurrencyStamp")
|
.IsConcurrencyToken()
|
.HasMaxLength(40)
|
.HasColumnType("varchar(40)")
|
.HasColumnName("ConcurrencyStamp");
|
|
b.Property<string>("ContainerNo")
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.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?>("DodeviceId")
|
.HasColumnType("int")
|
.HasComment("堆垛机ID");
|
|
b.Property<int>("Dodevicetype")
|
.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?>("IsNextTask")
|
.HasColumnType("int")
|
.HasComment("下个任务是否生成成功");
|
|
b.Property<bool>("IsRead")
|
.HasColumnType("tinyint(1)")
|
.HasComment("WCS是否可以读取");
|
|
b.Property<DateTime?>("LastModificationTime")
|
.HasColumnType("datetime(6)")
|
.HasColumnName("LastModificationTime");
|
|
b.Property<Guid?>("LastModifierId")
|
.HasColumnType("char(36)")
|
.HasColumnName("LastModifierId");
|
|
b.Property<string>("MutableParam1")
|
.HasMaxLength(200)
|
.HasColumnType("varchar(200)")
|
.HasComment("可变变量1");
|
|
b.Property<string>("MutableParam2")
|
.HasMaxLength(200)
|
.HasColumnType("varchar(200)")
|
.HasComment("可变变量2");
|
|
b.Property<string>("MutableParam3")
|
.HasMaxLength(200)
|
.HasColumnType("varchar(200)")
|
.HasComment("可变变量3");
|
|
b.Property<int?>("SonTaskType")
|
.HasColumnType("int")
|
.HasComment("子任务类型");
|
|
b.Property<int>("Sort")
|
.HasColumnType("int")
|
.HasComment("排序");
|
|
b.Property<string>("SourceOrderNo")
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("来源单据号");
|
|
b.Property<string>("SourcePlace")
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("起始库位");
|
|
b.Property<int>("TaskDodeviceStatus")
|
.HasColumnType("int")
|
.HasComment("设备任务状态");
|
|
b.Property<int>("TaskLevel")
|
.HasColumnType("int")
|
.HasComment("任务等级");
|
|
b.Property<string>("TaskNo")
|
.IsRequired()
|
.HasMaxLength(50)
|
.HasColumnType("varchar(50)")
|
.HasComment("任务号");
|
|
b.Property<int>("TaskStatus")
|
.HasColumnType("int")
|
.HasComment("任务状态");
|
|
b.Property<int>("TaskType")
|
.HasColumnType("int")
|
.HasComment("任务类型");
|
|
b.Property<string>("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
|
}
|
}
|
}
|
