//
using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using TaskManager.EntityFramework;
#nullable disable
namespace TaskManager.EntityFramework.Migrations
{
[DbContext(typeof(JobDbContext))]
[Migration("20250528092555_init")]
partial class init
{
///
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "8.0.0")
.HasAnnotation("Relational:MaxIdentifierLength", 128);
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
modelBuilder.Entity("TaskManager.Entity.Entitys.SUPPLIER_PRO_STATION_FIRST_PASSYIELD", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("AcceptableNumber")
.HasPrecision(16, 5)
.HasColumnType("DECIMAL");
b.Property("CheryProductName")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("VARCHAR");
b.Property("CheryProductNo")
.IsRequired()
.HasMaxLength(32)
.HasColumnType("VARCHAR");
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("DateTime")
.IsRequired()
.HasMaxLength(19)
.HasColumnType("CHAR");
b.Property("DefectiveNumber")
.HasPrecision(16, 5)
.HasColumnType("DECIMAL");
b.Property("ManufactureNo")
.IsRequired()
.HasMaxLength(32)
.HasColumnType("VARCHAR");
b.Property("OncePassRateRealValue")
.HasPrecision(16, 5)
.HasColumnType("DECIMAL");
b.Property("OncePassRateTagValue")
.HasPrecision(16, 5)
.HasColumnType("DECIMAL");
b.Property("PlantId")
.IsRequired()
.HasMaxLength(32)
.HasColumnType("VARCHAR");
b.Property("PlantName")
.IsRequired()
.HasMaxLength(64)
.HasColumnType("VARCHAR");
b.Property("ProductBatchNo")
.IsRequired()
.HasMaxLength(32)
.HasColumnType("VARCHAR");
b.Property("ProductionLineId")
.IsRequired()
.HasMaxLength(32)
.HasColumnType("VARCHAR");
b.Property("ProductionLineName")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("VARCHAR");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("Remark")
.IsRequired()
.HasMaxLength(500)
.HasColumnType("NVarchar");
b.Property("StationId")
.IsRequired()
.HasMaxLength(32)
.HasColumnType("VARCHAR");
b.Property("StationName")
.IsRequired()
.HasMaxLength(64)
.HasColumnType("VARCHAR");
b.Property("StatisticalTime")
.IsRequired()
.HasMaxLength(19)
.HasColumnType("CHAR");
b.Property("SupplierCode")
.IsRequired()
.HasMaxLength(32)
.HasColumnType("VARCHAR");
b.Property("SupplierName")
.IsRequired()
.HasMaxLength(64)
.HasColumnType("VARCHAR");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("VendorProductName")
.IsRequired()
.HasMaxLength(100)
.HasColumnType("VARCHAR");
b.Property("VendorProductNo")
.IsRequired()
.HasMaxLength(32)
.HasColumnType("VARCHAR");
b.Property("WorkOrderNumber")
.HasPrecision(16, 5)
.HasColumnType("DECIMAL");
b.Property("WorkShift")
.IsRequired()
.HasMaxLength(10)
.HasColumnType("VARCHAR");
b.Property("WorkshopId")
.IsRequired()
.HasMaxLength(32)
.HasColumnType("VARCHAR");
b.Property("WorkshopName")
.IsRequired()
.HasMaxLength(64)
.HasColumnType("VARCHAR");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_PRO_STATION_FIRST_PASSYIELD", (string)null);
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_BOM", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("Remark")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_BOM");
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_CON_DATE", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("FeedbackResults")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("MaterialCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Measures")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("PlantId")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QuantityMeet1")
.HasColumnType("int");
b.Property("QuantityMeet10")
.HasColumnType("int");
b.Property("QuantityMeet11")
.HasColumnType("int");
b.Property("QuantityMeet12")
.HasColumnType("int");
b.Property("QuantityMeet13")
.HasColumnType("int");
b.Property("QuantityMeet14")
.HasColumnType("int");
b.Property("QuantityMeet15")
.HasColumnType("int");
b.Property("QuantityMeet16")
.HasColumnType("int");
b.Property("QuantityMeet17")
.HasColumnType("int");
b.Property("QuantityMeet18")
.HasColumnType("int");
b.Property("QuantityMeet19")
.HasColumnType("int");
b.Property("QuantityMeet2")
.HasColumnType("int");
b.Property("QuantityMeet20")
.HasColumnType("int");
b.Property("QuantityMeet21")
.HasColumnType("int");
b.Property("QuantityMeet22")
.HasColumnType("int");
b.Property("QuantityMeet23")
.HasColumnType("int");
b.Property("QuantityMeet24")
.HasColumnType("int");
b.Property("QuantityMeet25")
.HasColumnType("int");
b.Property("QuantityMeet26")
.HasColumnType("int");
b.Property("QuantityMeet27")
.HasColumnType("int");
b.Property("QuantityMeet28")
.HasColumnType("int");
b.Property("QuantityMeet29")
.HasColumnType("int");
b.Property("QuantityMeet3")
.HasColumnType("int");
b.Property("QuantityMeet30")
.HasColumnType("int");
b.Property("QuantityMeet31")
.HasColumnType("int");
b.Property("QuantityMeet4")
.HasColumnType("int");
b.Property("QuantityMeet5")
.HasColumnType("int");
b.Property("QuantityMeet6")
.HasColumnType("int");
b.Property("QuantityMeet7")
.HasColumnType("int");
b.Property("QuantityMeet8")
.HasColumnType("int");
b.Property("QuantityMeet9")
.HasColumnType("int");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("ReleaseEdition")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Remark")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("StartDate")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("SupplierCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("VentureSpecific")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("VentureType")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_CON_DATE");
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_CON_MMRP", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("FeedbackResults")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("MaterialCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Measures")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("PlantId")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QuantityMeet1")
.HasColumnType("int");
b.Property("QuantityMeet10")
.HasColumnType("int");
b.Property("QuantityMeet11")
.HasColumnType("int");
b.Property("QuantityMeet12")
.HasColumnType("int");
b.Property("QuantityMeet2")
.HasColumnType("int");
b.Property("QuantityMeet3")
.HasColumnType("int");
b.Property("QuantityMeet4")
.HasColumnType("int");
b.Property("QuantityMeet5")
.HasColumnType("int");
b.Property("QuantityMeet6")
.HasColumnType("int");
b.Property("QuantityMeet7")
.HasColumnType("int");
b.Property("QuantityMeet8")
.HasColumnType("int");
b.Property("QuantityMeet9")
.HasColumnType("int");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("ReleaseEdition")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Remark")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("StartMonth")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("SupplierCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("VentureSpecific")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("VentureType")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_CON_MMRP");
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_CON_PO", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("FeedbackResults")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Measures")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("PurchaseOrder")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QuantityMeet")
.HasColumnType("int");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("Remark")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("SerialNumber")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("SupplierCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("VentureSpecific")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("VentureType")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_CON_PO");
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_DEL_STATE", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreateByUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("CreateTime")
.HasColumnType("datetime2");
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("DataCreateTime")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("DeliveryNumber")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Id")
.HasColumnType("nvarchar(max)");
b.Property("IsDelete")
.HasColumnType("int");
b.Property("MaterialCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("MaterialDescription")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("PlantId")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QuantityDelivery")
.HasColumnType("int");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("ReceivingCrossings")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Remark")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("RequestDate")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("RoadReceiveTime")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("RoadShippedTime")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("SerialNumber")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("SerialSrate")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("SupplierReceiveTime")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("UpdateByUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("UpdateTime")
.HasColumnType("datetime2");
b.Property("Version")
.HasColumnType("int");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_DEL_STATE");
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_EMPLOYEE", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("Remark")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_EMPLOYEE");
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_INFO", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("Remark")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_INFO");
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_INV_DATA", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreateByUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("CreateTime")
.HasColumnType("datetime2");
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("DataUpdateTime")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Id")
.HasColumnType("nvarchar(max)");
b.Property("IsDelete")
.HasColumnType("int");
b.Property("MaterialCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("MaterialDescription")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("PlantId")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("PlantName")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QuantityCurrent")
.HasColumnType("int");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("Remark")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("RequestDate")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("StockState")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("UpdateByUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("UpdateTime")
.HasColumnType("datetime2");
b.Property("Version")
.HasColumnType("int");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_INV_DATA");
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_MRP_DATE", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreateByUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("CreateTime")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("Id")
.HasColumnType("nvarchar(max)");
b.Property("IsDelete")
.HasColumnType("int");
b.Property("IsUpdate")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("MaterialCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("MaterialDescription")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("PlantId")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("PlantName")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("QuantityDemand1")
.HasColumnType("int");
b.Property("QuantityDemand10")
.HasColumnType("int");
b.Property("QuantityDemand11")
.HasColumnType("int");
b.Property("QuantityDemand12")
.HasColumnType("int");
b.Property("QuantityDemand13")
.HasColumnType("int");
b.Property("QuantityDemand14")
.HasColumnType("int");
b.Property("QuantityDemand15")
.HasColumnType("int");
b.Property("QuantityDemand16")
.HasColumnType("int");
b.Property("QuantityDemand17")
.HasColumnType("int");
b.Property("QuantityDemand18")
.HasColumnType("int");
b.Property("QuantityDemand19")
.HasColumnType("int");
b.Property("QuantityDemand2")
.HasColumnType("int");
b.Property("QuantityDemand20")
.HasColumnType("int");
b.Property("QuantityDemand21")
.HasColumnType("int");
b.Property("QuantityDemand22")
.HasColumnType("int");
b.Property("QuantityDemand23")
.HasColumnType("int");
b.Property("QuantityDemand24")
.HasColumnType("int");
b.Property("QuantityDemand25")
.HasColumnType("int");
b.Property("QuantityDemand26")
.HasColumnType("int");
b.Property("QuantityDemand27")
.HasColumnType("int");
b.Property("QuantityDemand28")
.HasColumnType("int");
b.Property("QuantityDemand29")
.HasColumnType("int");
b.Property("QuantityDemand3")
.HasColumnType("int");
b.Property("QuantityDemand30")
.HasColumnType("int");
b.Property("QuantityDemand31")
.HasColumnType("int");
b.Property("QuantityDemand4")
.HasColumnType("int");
b.Property("QuantityDemand5")
.HasColumnType("int");
b.Property("QuantityDemand6")
.HasColumnType("int");
b.Property("QuantityDemand7")
.HasColumnType("int");
b.Property("QuantityDemand8")
.HasColumnType("int");
b.Property("QuantityDemand9")
.HasColumnType("int");
b.Property("ReadState")
.HasColumnType("bit");
b.Property("ReleaseEdition")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Remark")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("RequestDate")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("StartDate")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("TaskId")
.HasColumnType("uniqueidentifier");
b.Property("UpdateByUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("UpdateTime")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Version")
.HasColumnType("int");
b.Property("WriteState")
.HasColumnType("bit");
b.HasKey("UId");
b.ToTable("SUPPLIER_MRP_DATE");
});
modelBuilder.Entity("TaskManager.Entity.SUPPLIER_MRP_MONTH", b =>
{
b.Property("UId")
.ValueGeneratedOnAdd()
.HasColumnType("bigint");
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("UId"));
b.Property("CreateByUser")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("CreateTime")
.HasColumnType("datetime2");
b.Property("CreationTime")
.HasColumnType("datetime2");
b.Property("Id")
.HasColumnType("nvarchar(max)");
b.Property("IsDelete")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("IsUpdate")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("MaterialCode")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("MaterialDescription")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property