//
using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using WCS.Service;
namespace WCS.Service.Migrations
{
[DbContext(typeof(WCSDB))]
[Migration("20210928080839_9-28-11")]
partial class _92811
{
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("ProductVersion", "5.0.5")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("WCS.Entity.Protocol.WCS_AGVTask", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
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("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_BCR80", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("CONTENT")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
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.WCS_RGV520", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("DestPosition")
.HasColumnType("smallint");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("FinishedACK")
.HasColumnType("smallint");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("PRIORITY")
.HasColumnType("smallint");
b.Property("RES1")
.HasColumnType("smallint");
b.Property("StartPosition")
.HasColumnType("smallint");
b.Property("TaskID")
.HasColumnType("int");
b.Property("TaskType")
.HasColumnType("smallint");
b.Property("Trigger")
.HasColumnType("smallint");
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")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("ACT_V")
.HasColumnType("smallint");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("DestPosition")
.HasColumnType("smallint");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("Finish")
.HasColumnType("bit");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Mileage")
.HasColumnType("real");
b.Property("PH_Status")
.HasColumnType("bit");
b.Property("PRIORITY")
.HasColumnType("smallint");
b.Property("Position")
.HasColumnType("real");
b.Property("RES")
.HasColumnType("smallint");
b.Property("RES2")
.HasColumnType("smallint");
b.Property("Runtime")
.HasColumnType("real");
b.Property("StartPosition")
.HasColumnType("smallint");
b.Property("SystemStatus")
.HasColumnType("smallint");
b.Property("TaskID")
.HasColumnType("int");
b.Property("TaskType")
.HasColumnType("smallint");
b.Property("ToSition")
.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.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")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
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_Robot", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("FinishedTask")
.HasColumnType("int");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Mode")
.HasColumnType("smallint");
b.Property("Status")
.HasColumnType("smallint");
b.Property("Target")
.HasColumnType("smallint");
b.Property("TaskID")
.HasColumnType("int");
b.Property("Trigger")
.HasColumnType("smallint");
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_Robot");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_RobotStation", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("DocId")
.HasColumnType("int");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("MaxQty")
.HasColumnType("smallint");
b.Property("PalletType")
.HasColumnType("smallint");
b.Property("Qty")
.HasColumnType("smallint");
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_RobotStation");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC520", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ECol")
.HasColumnType("smallint");
b.Property("EDepth")
.HasColumnType("smallint");
b.Property("ELayer")
.HasColumnType("smallint");
b.Property("ELine")
.HasColumnType("smallint");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("Endnumber2")
.HasColumnType("smallint");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("FinishedACK")
.HasColumnType("smallint");
b.Property("GoodsType")
.HasColumnType("smallint");
b.Property("Handshake")
.HasColumnType("smallint");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("SCol")
.HasColumnType("smallint");
b.Property("SDepth")
.HasColumnType("smallint");
b.Property("SLayer")
.HasColumnType("smallint");
b.Property("SLine")
.HasColumnType("smallint");
b.Property("SpeedMode")
.HasColumnType("smallint");
b.Property("Startnumber1")
.HasColumnType("smallint");
b.Property("TaskID")
.HasColumnType("int");
b.Property("Trigger")
.HasColumnType("smallint");
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_SC520");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC521", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("Alarm")
.HasColumnType("bit");
b.Property("Col")
.HasColumnType("smallint");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ECol")
.HasColumnType("smallint");
b.Property("EDepth")
.HasColumnType("smallint");
b.Property("ELayer")
.HasColumnType("smallint");
b.Property("ELine")
.HasColumnType("smallint");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("Endnumber2")
.HasColumnType("smallint");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("FinishedTask")
.HasColumnType("int");
b.Property("ForkCenter")
.HasColumnType("bit");
b.Property("ForkPos")
.HasColumnType("int");
b.Property("GetFinishi")
.HasColumnType("bit");
b.Property("GoodsType")
.HasColumnType("smallint");
b.Property("Handshake")
.HasColumnType("bit");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Layer")
.HasColumnType("smallint");
b.Property("LiftPos")
.HasColumnType("int");
b.Property("Line")
.HasColumnType("smallint");
b.Property("Loaded")
.HasColumnType("bit");
b.Property("Mode")
.HasColumnType("smallint");
b.Property("PutFinishi")
.HasColumnType("bit");
b.Property("RES")
.HasColumnType("tinyint");
b.Property("Runtime")
.HasColumnType("real");
b.Property("SCol")
.HasColumnType("smallint");
b.Property("SDepth")
.HasColumnType("smallint");
b.Property("SLayer")
.HasColumnType("smallint");
b.Property("SLine")
.HasColumnType("smallint");
b.Property("Status")
.HasColumnType("smallint");
b.Property("TaskFinishi")
.HasColumnType("bit");
b.Property("TaskID")
.HasColumnType("int");
b.Property("TotalKM")
.HasColumnType("real");
b.Property("TravelPos")
.HasColumnType("int");
b.Property("Trigger")
.HasColumnType("smallint");
b.Property("Tunnel")
.HasColumnType("smallint");
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_SC521");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC537", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("SCAlarm")
.HasColumnType("decimal(20,0)");
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_SC537");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION520", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("CONFIRM")
.HasColumnType("bit");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("GOODSCODE")
.HasColumnType("int");
b.Property("GOODSEND")
.HasColumnType("smallint");
b.Property("GOODSSIZE")
.HasColumnType("smallint");
b.Property("GOODSSTART")
.HasColumnType("smallint");
b.Property("GOODSTYPE")
.HasColumnType("smallint");
b.Property("HEIGHT")
.HasColumnType("int");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("RES")
.HasColumnType("bit");
b.Property("RES2")
.HasColumnType("tinyint");
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("WCSVERSION")
.HasColumnType("int");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_STATION520");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION523", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("Fault")
.HasColumnType("int");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("RES")
.HasColumnType("smallint");
b.Property("RunTime")
.HasColumnType("real");
b.Property("Status")
.HasColumnType("smallint");
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.WCS_CMD", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("DEVICE_CODE")
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("PROPERTY")
.HasMaxLength(32)
.HasColumnType("nvarchar(32)");
b.Property("PROTOCOL")
.HasMaxLength(256)
.HasColumnType("nvarchar(256)");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VALUE")
.HasMaxLength(512)
.HasColumnType("nvarchar(512)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.Property("WCSVERSION")
.HasColumnType("int");
b.HasKey("ID");
b.ToTable("WCS_CMD");
});
modelBuilder.Entity("WCS.Entity.WCS_DATABLOCK", b =>
{
b.Property("CODE")
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property("DATALENGTH")
.HasColumnType("int");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("LENGTH")
.HasColumnType("int");
b.Property("NAME")
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.Property("NO")
.HasColumnType("int");
b.Property("NOUPDATE")
.HasColumnType("bit");
b.Property("PLCCODE")
.HasColumnType("nvarchar(20)");
b.Property("PROTOCOL")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.HasKey("CODE");
b.HasIndex("PLCCODE");
b.ToTable("WCS_DATABLOCK");
});
modelBuilder.Entity("WCS.Entity.WCS_DEVICE", b =>
{
b.Property("CODE")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("NAME")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.HasKey("CODE");
b.ToTable("WCS_DEVICE");
});
modelBuilder.Entity("WCS.Entity.WCS_DEVICEPROTOCOL", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("DBCODE")
.HasColumnType("nvarchar(20)");
b.Property("DEVICECODE")
.IsRequired()
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("POSITION")
.HasColumnType("smallint");
b.Property("UPDATETIME")
.HasColumnType("datetime2");
b.Property("UPDATEUSER")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("VER")
.IsConcurrencyToken()
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("rowversion");
b.HasKey("ID");
b.HasIndex("DBCODE");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_DEVICEPROTOCOL");
});
modelBuilder.Entity("WCS.Entity.WCS_EXCEPTION", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("MSG")
.HasMaxLength(1000)
.HasColumnType("nvarchar(1000)");
b.Property("STARTTIME")
.HasColumnType("datetime2");
b.Property