YG-MW-WCS/Projects/永冠/WCS.Service/Migrations/20210712055535_7-12-4.Designer.cs

// <auto-generated />
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("20210712055535_7-12-4")]
    partial class _7124
    {
        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<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("CONTENT")
                        .HasMaxLength(200)
                        .HasColumnType("nvarchar(200)");

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_BCR80");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV520", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<short>("DestPosition")
                        .HasColumnType("smallint");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<short>("FinishedACK")
                        .HasColumnType("smallint");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<short>("PRIORITY")
                        .HasColumnType("smallint");

                    b.Property<short>("RES1")
                        .HasColumnType("smallint");

                    b.Property<short>("StartPosition")
                        .HasColumnType("smallint");

                    b.Property<int>("TaskID")
                        .HasColumnType("int");

                    b.Property<short>("TaskType")
                        .HasColumnType("smallint");

                    b.Property<short>("Trigger")
                        .HasColumnType("smallint");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_RGV520");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV521", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<short>("ACT_V")
                        .HasColumnType("smallint");

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<short>("DestPosition")
                        .HasColumnType("smallint");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<bool>("Finish")
                        .HasColumnType("bit");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<float>("Mileage")
                        .HasColumnType("real");

                    b.Property<bool>("PH_Status")
                        .HasColumnType("bit");

                    b.Property<short>("PRIORITY")
                        .HasColumnType("smallint");

                    b.Property<float>("Position")
                        .HasColumnType("real");

                    b.Property<short>("RES")
                        .HasColumnType("smallint");

                    b.Property<short>("RES2")
                        .HasColumnType("smallint");

                    b.Property<float>("Runtime")
                        .HasColumnType("real");

                    b.Property<short>("StartPosition")
                        .HasColumnType("smallint");

                    b.Property<short>("SystemStatus")
                        .HasColumnType("smallint");

                    b.Property<int>("TaskID")
                        .HasColumnType("int");

                    b.Property<short>("TaskType")
                        .HasColumnType("smallint");

                    b.Property<bool>("ToSition")
                        .HasColumnType("bit");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.Property<short>("WorkMode")
                        .HasColumnType("smallint");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_RGV521");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV523", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<int>("Fault")
                        .HasColumnType("int");

                    b.Property<int>("Fault1")
                        .HasColumnType("int");

                    b.Property<int>("Fault2")
                        .HasColumnType("int");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<int>("Status")
                        .HasColumnType("int");

                    b.Property<int>("Status1")
                        .HasColumnType("int");

                    b.Property<int>("Status2")
                        .HasColumnType("int");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_RGV523");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC520", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<short>("ECol")
                        .HasColumnType("smallint");

                    b.Property<short>("EDepth")
                        .HasColumnType("smallint");

                    b.Property<short>("ELayer")
                        .HasColumnType("smallint");

                    b.Property<short>("ELine")
                        .HasColumnType("smallint");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<short>("Endnumber2")
                        .HasColumnType("smallint");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<short>("FinishedACK")
                        .HasColumnType("smallint");

                    b.Property<short>("GoodsType")
                        .HasColumnType("smallint");

                    b.Property<short>("Handshake")
                        .HasColumnType("smallint");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<short>("SCol")
                        .HasColumnType("smallint");

                    b.Property<short>("SDepth")
                        .HasColumnType("smallint");

                    b.Property<short>("SLayer")
                        .HasColumnType("smallint");

                    b.Property<short>("SLine")
                        .HasColumnType("smallint");

                    b.Property<short>("SpeedMode")
                        .HasColumnType("smallint");

                    b.Property<short>("Startnumber1")
                        .HasColumnType("smallint");

                    b.Property<int>("TaskID")
                        .HasColumnType("int");

                    b.Property<short>("Trigger")
                        .HasColumnType("smallint");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_SC520");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC521", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<bool>("Alarm")
                        .HasColumnType("bit");

                    b.Property<short>("Col")
                        .HasColumnType("smallint");

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<short>("ECol")
                        .HasColumnType("smallint");

                    b.Property<short>("EDepth")
                        .HasColumnType("smallint");

                    b.Property<short>("ELayer")
                        .HasColumnType("smallint");

                    b.Property<short>("ELine")
                        .HasColumnType("smallint");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<short>("Endnumber2")
                        .HasColumnType("smallint");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<int>("FinishedTask")
                        .HasColumnType("int");

                    b.Property<bool>("ForkCenter")
                        .HasColumnType("bit");

                    b.Property<int>("ForkPos")
                        .HasColumnType("int");

                    b.Property<bool>("GetFinishi")
                        .HasColumnType("bit");

                    b.Property<short>("GoodsType")
                        .HasColumnType("smallint");

                    b.Property<bool>("Handshake")
                        .HasColumnType("bit");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<short>("Layer")
                        .HasColumnType("smallint");

                    b.Property<int>("LiftPos")
                        .HasColumnType("int");

                    b.Property<short>("Line")
                        .HasColumnType("smallint");

                    b.Property<bool>("Loaded")
                        .HasColumnType("bit");

                    b.Property<short>("Mode")
                        .HasColumnType("smallint");

                    b.Property<bool>("PutFinishi")
                        .HasColumnType("bit");

                    b.Property<byte>("RES")
                        .HasColumnType("tinyint");

                    b.Property<float>("Runtime")
                        .HasColumnType("real");

                    b.Property<short>("SCol")
                        .HasColumnType("smallint");

                    b.Property<short>("SDepth")
                        .HasColumnType("smallint");

                    b.Property<short>("SLayer")
                        .HasColumnType("smallint");

                    b.Property<short>("SLine")
                        .HasColumnType("smallint");

                    b.Property<short>("Status")
                        .HasColumnType("smallint");

                    b.Property<bool>("TaskFinishi")
                        .HasColumnType("bit");

                    b.Property<int>("TaskID")
                        .HasColumnType("int");

                    b.Property<float>("TotalKM")
                        .HasColumnType("real");

                    b.Property<int>("TravelPos")
                        .HasColumnType("int");

                    b.Property<short>("Trigger")
                        .HasColumnType("smallint");

                    b.Property<short>("Tunnel")
                        .HasColumnType("smallint");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_SC521");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC537", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<decimal>("SCAlarm")
                        .HasColumnType("decimal(20,0)");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_SC537");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION520", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<bool>("CONFIRM")
                        .HasColumnType("bit");

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<int>("GOODSCODE")
                        .HasColumnType("int");

                    b.Property<short>("GOODSEND")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSSIZE")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSSTART")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSTYPE")
                        .HasColumnType("smallint");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<bool>("RES")
                        .HasColumnType("bit");

                    b.Property<int>("TASKNUM")
                        .HasColumnType("int");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_STATION520");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION521", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<bool>("BCR_NOREAD")
                        .HasColumnType("bit");

                    b.Property<bool>("B_OUTSIDE")
                        .HasColumnType("bit");

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<bool>("F_OUTSIDE")
                        .HasColumnType("bit");

                    b.Property<int>("GOODSCODE")
                        .HasColumnType("int");

                    b.Property<short>("GOODSEND")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSSIZE")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSSTART")
                        .HasColumnType("smallint");

                    b.Property<short>("GOODSTYPE")
                        .HasColumnType("smallint");

                    b.Property<bool>("GOODS_ERR")
                        .HasColumnType("bit");

                    b.Property<bool>("H_OUTSIDE")
                        .HasColumnType("bit");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<bool>("L_OUTSIDE")
                        .HasColumnType("bit");

                    b.Property<bool>("OVERLOAD")
                        .HasColumnType("bit");

                    b.Property<bool>("PH_STATUS")
                        .HasColumnType("bit");

                    b.Property<bool>("PH_STATUS2")
                        .HasColumnType("bit");

                    b.Property<bool>("REQUEST")
                        .HasColumnType("bit");

                    b.Property<bool>("RES")
                        .HasColumnType("bit");

                    b.Property<bool>("RES1")
                        .HasColumnType("bit");

                    b.Property<bool>("RES2")
                        .HasColumnType("bit");

                    b.Property<bool>("RES4")
                        .HasColumnType("bit");

                    b.Property<bool>("RES5")
                        .HasColumnType("bit");

                    b.Property<bool>("R_OUTSIDE")
                        .HasColumnType("bit");

                    b.Property<int>("TASKNUM")
                        .HasColumnType("int");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.Property<int>("WEIGHT")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_STATION521");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION523", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DEVICECODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime>("FRAME")
                        .HasColumnType("datetime2");

                    b.Property<int>("Fault")
                        .HasColumnType("int");

                    b.Property<bool>("ISLAST")
                        .HasColumnType("bit");

                    b.Property<short>("RES")
                        .HasColumnType("smallint");

                    b.Property<float>("RunTime")
                        .HasColumnType("real");

                    b.Property<short>("Status")
                        .HasColumnType("smallint");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.ToTable("WCS_STATION523");
                });

            modelBuilder.Entity("WCS.Entity.WCS_CMD", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DEVICE_CODE")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("PROPERTY")
                        .HasMaxLength(32)
                        .HasColumnType("nvarchar(32)");

                    b.Property<string>("PROTOCOL")
                        .HasMaxLength(256)
                        .HasColumnType("nvarchar(256)");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("VALUE")
                        .HasMaxLength(512)
                        .HasColumnType("nvarchar(512)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WCSVERSION")
                        .HasColumnType("int");

                    b.HasKey("ID");

                    b.ToTable("WCS_CMD");
                });

            modelBuilder.Entity("WCS.Entity.WCS_DATABLOCK", b =>
                {
                    b.Property<string>("CODE")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<int>("DATALENGTH")
                        .HasColumnType("int");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<int>("LENGTH")
                        .HasColumnType("int");

                    b.Property<string>("NAME")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<int>("NO")
                        .HasColumnType("int");

                    b.Property<bool>("NOUPDATE")
                        .HasColumnType("bit");

                    b.Property<string>("PLCCODE")
                        .HasColumnType("nvarchar(20)");

                    b.Property<string>("PROTOCOL")
                        .IsRequired()
                        .HasMaxLength(200)
                        .HasColumnType("nvarchar(200)");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("CODE");

                    b.HasIndex("PLCCODE");

                    b.ToTable("WCS_DATABLOCK");
                });

            modelBuilder.Entity("WCS.Entity.WCS_DEVICE", b =>
                {
                    b.Property<string>("CODE")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("NAME")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("CODE");

                    b.ToTable("WCS_DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.WCS_DEVICEPROTOCOL", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DBCODE")
                        .HasColumnType("nvarchar(20)");

                    b.Property<string>("DEVICECODE")
                        .IsRequired()
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<short>("POSITION")
                        .HasColumnType("smallint");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("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<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("MSG")
                        .HasMaxLength(1000)
                        .HasColumnType("nvarchar(1000)");

                    b.Property<DateTime>("STARTTIME")
                        .HasColumnType("datetime2");

                    b.Property<int>("TIMES")
                        .HasColumnType("int");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("ID");

                    b.ToTable("WCS_EXCEPTION");
                });

            modelBuilder.Entity("WCS.Entity.WCS_PATH", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("ENDCODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("PATH")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("STARTCODE")
                        .IsRequired()
                        .HasColumnType("nvarchar(50)");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("ID");

                    b.HasIndex("ENDCODE");

                    b.HasIndex("STARTCODE");

                    b.ToTable("WCS_PATH");
                });

            modelBuilder.Entity("WCS.Entity.WCS_PLC", b =>
                {
                    b.Property<string>("CODE")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("IP")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<string>("MODEL")
                        .HasMaxLength(10)
                        .HasColumnType("nvarchar(10)");

                    b.Property<string>("NAME")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<int>("PORT")
                        .HasColumnType("int");

                    b.Property<int>("RACK")
                        .HasColumnType("int");

                    b.Property<int>("SLOT")
                        .HasColumnType("int");

                    b.Property<int>("TYPE")
                        .HasColumnType("int");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("CODE");

                    b.ToTable("WCS_PLC");
                });

            modelBuilder.Entity("WCS.Entity.WCS_ROUTE", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DEVICECODE")
                        .IsRequired()
                        .HasColumnType("nvarchar(50)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<string>("NEXTCODE")
                        .HasColumnType("nvarchar(50)");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.HasKey("ID");

                    b.HasIndex("DEVICECODE");

                    b.HasIndex("NEXTCODE");

                    b.ToTable("WCS_ROUTE");
                });

            modelBuilder.Entity("WCS.Entity.WCS_TASK", b =>
                {
                    b.Property<int>("ID")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("ADDRFROM")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<string>("ADDRTO")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<string>("BARCODE")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<DateTime>("CREATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("DEVICE")
                        .HasMaxLength(20)
                        .HasColumnType("nvarchar(20)");

                    b.Property<bool>("ENABLED")
                        .HasColumnType("bit");

                    b.Property<DateTime?>("ENDTIME")
                        .HasColumnType("datetime2");

                    b.Property<int>("FLOOR")
                        .HasColumnType("int");

                    b.Property<short>("FULLQTY")
                        .HasColumnType("smallint");

                    b.Property<short>("PALLETTYPE")
                        .HasColumnType("smallint");

                    b.Property<DateTime?>("STARTTIME")
                        .HasColumnType("datetime2");

                    b.Property<int>("STATUS")
                        .HasColumnType("int");

                    b.Property<int>("TUNNEL")
                        .HasColumnType("int");

                    b.Property<int>("TYPE")
                        .HasColumnType("int");

                    b.Property<DateTime>("UPDATETIME")
                        .HasColumnType("datetime2");

                    b.Property<string>("UPDATEUSER")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<int>("UPLOADED")
                        .HasColumnType("int");

                    b.Property<byte[]>("VER")
                        .IsConcurrencyToken()
                        .ValueGeneratedOnAddOrUpdate()
                        .HasColumnType("rowversion");

                    b.Property<int>("WMSTASK")
                        .HasColumnType("int");

                    b.Property<short>("WORKSHOP")
                        .HasColumnType("smallint");

                    b.HasKey("ID");

                    b.ToTable("WCS_TASK");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_BCR80", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV520", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV521", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_RGV523", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC520", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC521", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_SC537", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION520", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION521", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.Protocol.WCS_STATION523", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany()
                        .HasForeignKey("DEVICECODE");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.WCS_DATABLOCK", b =>
                {
                    b.HasOne("WCS.Entity.WCS_PLC", "PLC")
                        .WithMany()
                        .HasForeignKey("PLCCODE");

                    b.Navigation("PLC");
                });

            modelBuilder.Entity("WCS.Entity.WCS_DEVICEPROTOCOL", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DATABLOCK", "DB")
                        .WithMany()
                        .HasForeignKey("DBCODE");

                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany("PROTOCOLS")
                        .HasForeignKey("DEVICECODE")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("DB");

                    b.Navigation("DEVICE");
                });

            modelBuilder.Entity("WCS.Entity.WCS_PATH", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "END")
                        .WithMany()
                        .HasForeignKey("ENDCODE");

                    b.HasOne("WCS.Entity.WCS_DEVICE", "START")
                        .WithMany("PATHS")
                        .HasForeignKey("STARTCODE")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("END");

                    b.Navigation("START");
                });

            modelBuilder.Entity("WCS.Entity.WCS_ROUTE", b =>
                {
                    b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE")
                        .WithMany("ROUTES")
                        .HasForeignKey("DEVICECODE")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("WCS.Entity.WCS_DEVICE", "NEXT")
                        .WithMany()
                        .HasForeignKey("NEXTCODE");

                    b.Navigation("DEVICE");

                    b.Navigation("NEXT");
                });

            modelBuilder.Entity("WCS.Entity.WCS_DEVICE", b =>
                {
                    b.Navigation("PATHS");

                    b.Navigation("PROTOCOLS");

                    b.Navigation("ROUTES");
                });
#pragma warning restore 612, 618
        }
    }
}