//
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("20210705045814_Intt6")]
partial class Intt6
{
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_BCR80", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("CONTENT")
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
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_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("smallint");
b.Property("Trigger_2")
.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_1")
.HasColumnType("smallint");
b.Property("DestPosition_2")
.HasColumnType("smallint");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("Finish_1")
.HasColumnType("bit");
b.Property("Finish_2")
.HasColumnType("bit");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("Mileage")
.HasColumnType("real");
b.Property("PH_Status_1")
.HasColumnType("bit");
b.Property("PH_Status_2")
.HasColumnType("bit");
b.Property("PRIORITY_1")
.HasColumnType("smallint");
b.Property("PRIORITY_2")
.HasColumnType("smallint");
b.Property("Position")
.HasColumnType("real");
b.Property("RES")
.HasColumnType("smallint");
b.Property("RES1_2")
.HasColumnType("smallint");
b.Property("RES2_1")
.HasColumnType("smallint");
b.Property("RES2_2")
.HasColumnType("smallint");
b.Property("Runtime")
.HasColumnType("real");
b.Property("StartPosition_1")
.HasColumnType("smallint");
b.Property("StartPosition_2")
.HasColumnType("smallint");
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("ToSition_1")
.HasColumnType("bit");
b.Property("ToSition_2")
.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_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("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("Startnumber1")
.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("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("smallint");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FLAGS")
.HasColumnType("smallint");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("GOODSCODE")
.HasColumnType("smallint");
b.Property("GOODSEND")
.HasColumnType("smallint");
b.Property("GOODSSIZE")
.HasColumnType("smallint");
b.Property("GOODSSTART")
.HasColumnType("smallint");
b.Property("GOODSTYPE")
.HasColumnType("smallint");
b.Property("ISLAST")
.HasColumnType("bit");
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.Property("WEIGHT")
.HasColumnType("smallint");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_STATION520");
});
modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION521", b =>
{
b.Property("ID")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("BCR_NOREAD")
.HasColumnType("bit");
b.Property("B_OUTSIDE")
.HasColumnType("bit");
b.Property("DEVICECODE")
.HasColumnType("nvarchar(50)");
b.Property("ENABLED")
.HasColumnType("bit");
b.Property("FRAME")
.HasColumnType("datetime2");
b.Property("F_OUTSIDE")
.HasColumnType("bit");
b.Property("GOODSCODE")
.HasColumnType("smallint");
b.Property("GOODSEND")
.HasColumnType("smallint");
b.Property("GOODSSIZE")
.HasColumnType("smallint");
b.Property("GOODSSTART")
.HasColumnType("smallint");
b.Property("GOODSTYPE")
.HasColumnType("smallint");
b.Property("GOODS_ERR")
.HasColumnType("bit");
b.Property("H_OUTSIDE")
.HasColumnType("bit");
b.Property("ISLAST")
.HasColumnType("bit");
b.Property("L_OUTSIDE")
.HasColumnType("bit");
b.Property("OVERLOAD")
.HasColumnType("bit");
b.Property("PH_STATUS")
.HasColumnType("bit");
b.Property("REQUEST")
.HasColumnType("bit");
b.Property("RES")
.HasColumnType("bit");
b.Property("RES1")
.HasColumnType("bit");
b.Property("RES2")
.HasColumnType("bit");
b.Property("RES3")
.HasColumnType("bit");
b.Property("RES4")
.HasColumnType("bit");
b.Property("RES5")
.HasColumnType("bit");
b.Property("R_OUTSIDE")
.HasColumnType("bit");
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.Property("WEIGHT")
.HasColumnType("int");
b.HasKey("ID");
b.HasIndex("DEVICECODE");
b.ToTable("WCS_STATION521");
});
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("TYPE")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
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