// 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; #nullable disable namespace WCS.Service.Migrations { [DbContext(typeof(WCSDB))] [Migration("20220510062109_agvtask新增货物数量")] partial class agvtask新增货物数量 { protected override void BuildTargetModel(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("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("SRMMode") .HasColumnType("smallint"); b.Property("SRMStatus") .HasColumnType("smallint"); b.Property("Status_1") .HasColumnType("smallint"); b.Property("Status_2") .HasColumnType("smallint"); b.Property("TaskID_1") .HasColumnType("int"); b.Property("TaskID_2") .HasColumnType("int"); b.Property("TotalKM") .HasColumnType("real"); b.Property("TotalKM_1") .HasColumnType("real"); b.Property("TotalKM_2") .HasColumnType("real"); b.Property("TravelPos_1") .HasColumnType("int"); b.Property("TravelPos_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_SRM521"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SRM537", 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("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_SRM537"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_StatusLog", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("ENABLED") .HasColumnType("bit"); b.Property("NewStatus") .HasColumnType("int"); b.Property("Node") .HasColumnType("nvarchar(max)"); b.Property("OldStatus") .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("WCS_TASKID") .HasColumnType("int"); b.Property("msg") .HasColumnType("nvarchar(max)"); b.Property("upStatus") .HasColumnType("int"); b.HasKey("ID"); b.ToTable("WCS_StatusLog"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SystemConfig", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("Code") .HasColumnType("nvarchar(max)"); b.Property("DEVICECODE") .HasColumnType("nvarchar(max)"); b.Property("Describe") .HasColumnType("nvarchar(max)"); b.Property("Direction") .HasColumnType("nvarchar(max)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("TUNNEL") .HasColumnType("nvarchar(max)"); 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.ToTable("WCS_SystemConfig"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_Users", b => { b.Property("USER_NO") .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property("USER_PWD") .IsRequired() .HasMaxLength(128) .HasColumnType("nvarchar(128)"); b.Property("USER_TEXT") .HasColumnType("varbinary(max)"); b.HasKey("USER_NO"); b.ToTable("WCS_Users"); }); modelBuilder.Entity("WCS.Entity.WCS_CMD", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); 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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("DBCODE") .IsRequired() .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") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("DEVICE") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("EXCEPTIONTYPE") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property("MSG") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property("STARTTIME") .HasColumnType("datetime2"); b.Property("TIMES") .HasColumnType("int"); 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.ToTable("WCS_EXCEPTION"); }); modelBuilder.Entity("WCS.Entity.WCS_GROUPMEMBER", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("ENABLED") .HasColumnType("bit"); b.Property("GROUPCODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("MEMBERCODE") .IsRequired() .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("ID"); b.HasIndex("GROUPCODE"); b.HasIndex("MEMBERCODE"); b.ToTable("WCS_GROUPMEMBER"); }); modelBuilder.Entity("WCS.Entity.WCS_PATH", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("ENABLED") .HasColumnType("bit"); b.Property("ENDCODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("PATH") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("STARTCODE") .IsRequired() .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("ID"); b.HasIndex("ENDCODE"); b.HasIndex("STARTCODE"); b.ToTable("WCS_PATH"); }); modelBuilder.Entity("WCS.Entity.WCS_PATHPOINT", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("DEVICECODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("ENDCODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("NEXTCODE") .HasColumnType("nvarchar(50)"); b.Property("PREVCODE") .HasColumnType("nvarchar(50)"); b.Property("STARTCODE") .IsRequired() .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("ID"); b.HasIndex("DEVICECODE"); b.HasIndex("ENDCODE"); b.HasIndex("NEXTCODE"); b.HasIndex("PREVCODE"); b.HasIndex("STARTCODE"); b.ToTable("WCS_PATHPOINT"); }); modelBuilder.Entity("WCS.Entity.WCS_PLC", b => { b.Property("CODE") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("IP") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("MODEL") .HasMaxLength(10) .HasColumnType("nvarchar(10)"); b.Property("NAME") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("PORT") .HasColumnType("int"); b.Property("RACK") .HasColumnType("int"); b.Property("SLOT") .HasColumnType("int"); b.Property("TYPE") .HasColumnType("int"); 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_PLC"); }); modelBuilder.Entity("WCS.Entity.WCS_ROUTE", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("DEVICECODE") .IsRequired() .HasColumnType("nvarchar(50)"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("NEXTCODE") .IsRequired() .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("ID"); b.HasIndex("DEVICECODE"); b.HasIndex("NEXTCODE"); b.ToTable("WCS_ROUTE"); }); modelBuilder.Entity("WCS.Entity.WCS_TASK", b => { b.Property("ID") .ValueGeneratedOnAdd() .HasColumnType("int") .HasColumnOrder(0); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("ID"), 1L, 1); b.Property("ADDRFROM") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("ADDRNEXT") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("ADDRTO") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("AgvTask") .HasColumnType("int"); b.Property("BARCODE") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("CREATETIME") .HasColumnType("datetime2"); b.Property("DEVICE") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("DOCID") .HasColumnType("int"); b.Property("ENABLED") .HasColumnType("bit"); b.Property("ENDTIME") .HasColumnType("datetime2"); b.Property("FLOOR") .HasColumnType("int"); b.Property("FULLQTY") .HasColumnType("smallint"); b.Property("HEIGHT") .HasColumnType("smallint"); b.Property("Length") .HasColumnType("decimal(18,2)"); b.Property("ManualRemarks") .HasColumnType("nvarchar(max)"); b.Property("PALLETTYPE") .HasColumnType("smallint"); b.Property("PRODLINE") .HasColumnType("smallint"); b.Property("Priority") .HasColumnType("int"); b.Property("SRMSTATION") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.Property("STARTTIME") .HasColumnType("datetime2"); b.Property("STATUS") .HasColumnType("int"); b.Property("TUNNEL") .HasMaxLength(10) .HasColumnType("nvarchar(10)"); b.Property("TYPE") .HasColumnType("int"); b.Property("TaskGroupKey") .HasColumnType("nvarchar(max)"); b.Property("UPDATETIME") .HasColumnType("datetime2"); b.Property("UPDATEUSER") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("UPLOADED") .HasColumnType("int"); b.Property("VER") .IsConcurrencyToken() .ValueGeneratedOnAddOrUpdate() .HasColumnType("rowversion"); b.Property("WMSTASK") .HasColumnType("int"); b.HasKey("ID"); b.ToTable("WCS_TASK"); }); modelBuilder.Entity("WCS.Entity.Protocol.BCR.WCS_BCR80", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.Station.WCS_Station520", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.Station.WCS_Station521", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.Station.WCS_Station523", 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_SRM520", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SRM521", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.Protocol.WCS_SRM537", 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") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany("PROTOCOLS") .HasForeignKey("DEVICECODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("DB"); b.Navigation("DEVICE"); }); modelBuilder.Entity("WCS.Entity.WCS_GROUPMEMBER", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "GROUP") .WithMany("DEVICEGROUP") .HasForeignKey("GROUPCODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("WCS.Entity.WCS_DEVICE", "MEMBER") .WithMany() .HasForeignKey("MEMBERCODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("GROUP"); b.Navigation("MEMBER"); }); modelBuilder.Entity("WCS.Entity.WCS_PATH", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "END") .WithMany() .HasForeignKey("ENDCODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("WCS.Entity.WCS_DEVICE", "START") .WithMany("PATHS") .HasForeignKey("STARTCODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("END"); b.Navigation("START"); }); modelBuilder.Entity("WCS.Entity.WCS_PATHPOINT", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany() .HasForeignKey("DEVICECODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("WCS.Entity.WCS_DEVICE", "END") .WithMany() .HasForeignKey("ENDCODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("WCS.Entity.WCS_DEVICE", "NEXT") .WithMany() .HasForeignKey("NEXTCODE"); b.HasOne("WCS.Entity.WCS_DEVICE", "PREV") .WithMany() .HasForeignKey("PREVCODE"); b.HasOne("WCS.Entity.WCS_DEVICE", "START") .WithMany() .HasForeignKey("STARTCODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("DEVICE"); b.Navigation("END"); b.Navigation("NEXT"); b.Navigation("PREV"); b.Navigation("START"); }); modelBuilder.Entity("WCS.Entity.WCS_ROUTE", b => { b.HasOne("WCS.Entity.WCS_DEVICE", "DEVICE") .WithMany("ROUTES") .HasForeignKey("DEVICECODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("WCS.Entity.WCS_DEVICE", "NEXT") .WithMany() .HasForeignKey("NEXTCODE") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.Navigation("DEVICE"); b.Navigation("NEXT"); }); modelBuilder.Entity("WCS.Entity.WCS_DEVICE", b => { b.Navigation("DEVICEGROUP"); b.Navigation("PATHS"); b.Navigation("PROTOCOLS"); b.Navigation("ROUTES"); }); #pragma warning restore 612, 618 } } }