//
using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using WCS.Service;
#nullable disable
namespace WCS.Service.Migrations
{
[DbContext(typeof(WCSDB))]
partial class WCSDBModelSnapshot : ModelSnapshot
{
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "6.0.4")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
modelBuilder.Entity("WCS.Entity.Protocol.BCR.WCS_BCR80", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("Content")
.HasMaxLength(130)
.HasColumnType("nvarchar(130)");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property("WCSVERSION")
.HasColumnType("int");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_BCR80");
});
modelBuilder.Entity("WCS.Entity.Protocol.Station.WCS_Station520", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("CmdType")
.HasColumnType("smallint");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("GoodsSize")
.HasColumnType("smallint");
b.Property("Goodscode")
.HasColumnType("int");
b.Property("Goodsend")
.HasColumnType("smallint");
b.Property("Goodsnum")
.HasColumnType("smallint");
b.Property("Goodsstart")
.HasColumnType("smallint");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Istation521Status")
.HasColumnType("int");
b.Property("Request")
.HasColumnType("smallint");
b.Property("Tasknum")
.HasColumnType("int");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property("VoucherNo")
.HasColumnType("smallint");
b.Property("WCSVERSION")
.HasColumnType("int");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_STATION520");
});
modelBuilder.Entity("WCS.Entity.Protocol.Station.WCS_Station521", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("CmdType")
.HasColumnType("smallint");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("GoodsSize")
.HasColumnType("smallint");
b.Property("Goodscode")
.HasColumnType("int");
b.Property("Goodsend")
.HasColumnType("smallint");
b.Property("Goodsnum")
.HasColumnType("smallint");
b.Property("Goodsstart")
.HasColumnType("smallint");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Request")
.HasColumnType("smallint");
b.Property("Status")
.HasColumnType("int");
b.Property("Tasknum")
.HasColumnType("int");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property("VoucherNo")
.HasColumnType("smallint");
b.Property("WCSVERSION")
.HasColumnType("int");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_STATION521");
});
modelBuilder.Entity("WCS.Entity.Protocol.Station.WCS_Station523", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("Alarm")
.HasColumnType("int");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("RES")
.HasColumnType("smallint");
b.Property("RunTime")
.HasColumnType("real");
b.Property("Status")
.HasColumnType("int");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property("WCSVERSION")
.HasColumnType("int");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_STATION523");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_AGVTask", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("AGVID")
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property("AGVStatus")
.HasColumnType("int");
b.Property("AGVUpdateTime")
.HasColumnType("datetime2");
b.Property("CreateTime")
.HasColumnType("datetime2");
b.Property("Goodsnum")
.HasColumnType("int");
b.Property("Position")
.IsRequired()
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property("Station")
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property("Status")
.HasColumnType("int");
b.Property("TaskType")
.HasColumnType("int");
b.Property("UpdateTime")
.HasColumnType("datetime2");
b.Property("Workshop")
.HasColumnType("int");
b.HasKey("ID");
b.ToTable("WCS_AGVTask");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_MAPPINGENTRY", b =>
{
b.Property("MEP_ID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("MEP_ID"), 1L, 1);
b.Property("MEP_ISSTOP")
.HasColumnType("bit");
b.Property("MEP_MAPPINGCHNAME")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("MEP_MAPPINGNO")
.HasColumnType("int");
b.Property("MEP_MAPPINGTYPE")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.HasKey("MEP_ID");
b.ToTable("WCS_MAPPINGENTRY");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV520", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("DestPosition_1")
.HasColumnType("smallint");
b.Property("DestPosition_2")
.HasColumnType("smallint");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Priority_1")
.HasColumnType("smallint");
b.Property("Priority_2")
.HasColumnType("smallint");
b.Property("RES1_1")
.HasColumnType("smallint");
b.Property("RES1_2")
.HasColumnType("smallint");
b.Property("RES2_1")
.HasColumnType("smallint");
b.Property("RES2_2")
.HasColumnType("smallint");
b.Property("StartPosition_1")
.HasColumnType("smallint");
b.Property("StartPosition_2")
.HasColumnType("smallint");
b.Property("TaskID_1")
.HasColumnType("int");
b.Property("TaskID_2")
.HasColumnType("int");
b.Property("TaskType_1")
.HasColumnType("smallint");
b.Property("TaskType_2")
.HasColumnType("smallint");
b.Property("Trigger_1")
.HasColumnType("int");
b.Property("Trigger_2")
.HasColumnType("int");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property("WCSVERSION")
.HasColumnType("int");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_RGV520");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV521", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("DestPosition_1")
.HasColumnType("smallint");
b.Property("DestPosition_2")
.HasColumnType("smallint");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Mileage")
.HasColumnType("real");
b.Property("PRIORITY_1")
.HasColumnType("smallint");
b.Property("PRIORITY_2")
.HasColumnType("smallint");
b.Property("Position")
.HasColumnType("real");
b.Property("RES1_1")
.HasColumnType("smallint");
b.Property("RES1_2")
.HasColumnType("smallint");
b.Property("RES2_1")
.HasColumnType("smallint");
b.Property("RES2_2")
.HasColumnType("smallint");
b.Property("RES6")
.HasColumnType("smallint");
b.Property("Runtime")
.HasColumnType("real");
b.Property("StartPosition_1")
.HasColumnType("smallint");
b.Property("StartPosition_2")
.HasColumnType("smallint");
b.Property("Status_1")
.HasColumnType("int");
b.Property("Status_2")
.HasColumnType("int");
b.Property("SystemStatus")
.HasColumnType("smallint");
b.Property("TaskID_1")
.HasColumnType("int");
b.Property("TaskID_2")
.HasColumnType("int");
b.Property("TaskType_1")
.HasColumnType("smallint");
b.Property("TaskType_2")
.HasColumnType("smallint");
b.Property("Trigger_1")
.HasColumnType("int");
b.Property("Trigger_2")
.HasColumnType("int");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property("WCSVERSION")
.HasColumnType("int");
b.Property("WorkMode")
.HasColumnType("smallint");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_RGV521");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV523", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("Fault")
.HasColumnType("int");
b.Property("Fault1")
.HasColumnType("int");
b.Property("Fault2")
.HasColumnType("int");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Status")
.HasColumnType("int");
b.Property("Status1")
.HasColumnType("int");
b.Property("Status2")
.HasColumnType("int");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property("WCSVERSION")
.HasColumnType("int");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_RGV523");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_SRM520", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ECol_1")
.HasColumnType("smallint");
b.Property("ECol_2")
.HasColumnType("smallint");
b.Property("EDepth_1")
.HasColumnType("smallint");
b.Property("EDepth_2")
.HasColumnType("smallint");
b.Property("ELayer_1")
.HasColumnType("smallint");
b.Property("ELayer_2")
.HasColumnType("smallint");
b.Property("ELine_1")
.HasColumnType("smallint");
b.Property("ELine_2")
.HasColumnType("smallint");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("FinishedACK_1")
.HasColumnType("smallint");
b.Property("FinishedACK_2")
.HasColumnType("smallint");
b.Property("GoodsType_1")
.HasColumnType("smallint");
b.Property("GoodsType_2")
.HasColumnType("smallint");
b.Property("Handshake_1")
.HasColumnType("smallint");
b.Property("Handshake_2")
.HasColumnType("smallint");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("RES1_1")
.HasColumnType("smallint");
b.Property("RES1_2")
.HasColumnType("smallint");
b.Property("RES2_1")
.HasColumnType("smallint");
b.Property("RES2_2")
.HasColumnType("smallint");
b.Property("RES3_1")
.HasColumnType("smallint");
b.Property("RES3_2")
.HasColumnType("smallint");
b.Property("RES4_1")
.HasColumnType("smallint");
b.Property("RES4_2")
.HasColumnType("smallint");
b.Property("SCSpeedMode_2")
.HasColumnType("smallint");
b.Property("SCol_1")
.HasColumnType("smallint");
b.Property("SCol_2")
.HasColumnType("smallint");
b.Property("SDepth_1")
.HasColumnType("smallint");
b.Property("SDepth_2")
.HasColumnType("smallint");
b.Property("SLayer_1")
.HasColumnType("smallint");
b.Property("SLayer_2")
.HasColumnType("smallint");
b.Property("SLine_1")
.HasColumnType("smallint");
b.Property("SLine_2")
.HasColumnType("smallint");
b.Property("SpeedMode_1")
.HasColumnType("smallint");
b.Property("TaskID_1")
.HasColumnType("int");
b.Property("TaskID_2")
.HasColumnType("int");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property("VoucherNo_1")
.HasColumnType("smallint");
b.Property("VoucherNo_2")
.HasColumnType("smallint");
b.Property("WCSVERSION")
.HasColumnType("int");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_SRM520");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_SRM521", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasColumnOrder(0);
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1);
b.Property("Alarm")
.HasColumnType("smallint");
b.Property("Col_1")
.HasColumnType("smallint");
b.Property("Col_2")
.HasColumnType("smallint");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ECol_1")
.HasColumnType("smallint");
b.Property("ECol_2")
.HasColumnType("smallint");
b.Property("EDepth_1")
.HasColumnType("smallint");
b.Property("EDepth_2")
.HasColumnType("smallint");
b.Property("ELayer_1")
.HasColumnType("smallint");
b.Property("ELayer_2")
.HasColumnType("smallint");
b.Property("ELine_1")
.HasColumnType("smallint");
b.Property("ELine_2")
.HasColumnType("smallint");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("FinishedTask_1")
.HasColumnType("int");
b.Property("FinishedTask_2")
.HasColumnType("int");
b.Property("ForkPos_1")
.HasColumnType("int");
b.Property("ForkPos_2")
.HasColumnType("int");
b.Property("ForkStatus_1")
.HasColumnType("int");
b.Property("ForkStatus_2")
.HasColumnType("int");
b.Property("GoodsType_1")
.HasColumnType("smallint");
b.Property("GoodsType_2")
.HasColumnType("smallint");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Layer_1")
.HasColumnType("smallint");
b.Property("Layer_2")
.HasColumnType("smallint");
b.Property("LiftPos_1")
.HasColumnType("int");
b.Property("LiftPos_2")
.HasColumnType("int");
b.Property("Line_1")
.HasColumnType("smallint");
b.Property("Line_2")
.HasColumnType("smallint");
b.Property("Mode_1")
.HasColumnType("smallint");
b.Property("Mode_2")
.HasColumnType("smallint");
b.Property("RES10_1")
.HasColumnType("smallint");
b.Property("RES10_2")
.HasColumnType("smallint");
b.Property("RES11_1")
.HasColumnType("int");
b.Property("RES11_2")
.HasColumnType("int");
b.Property("RES12_1")
.HasColumnType("int");
b.Property("RES12_2")
.HasColumnType("int");
b.Property("RES13_1")
.HasColumnType("int");
b.Property("RES13_2")
.HasColumnType("int");
b.Property("RES14_1")
.HasColumnType("int");
b.Property("RES14_2")
.HasColumnType("int");
b.Property("RES9_1")
.HasColumnType("smallint");
b.Property("RES9_2")
.HasColumnType("smallint");
b.Property("Runtime")
.HasColumnType("real");
b.Property("Runtime_1")
.HasColumnType("real");
b.Property("Runtime_2")
.HasColumnType("real");
b.Property