Egalware/lux
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
lux/EgwCoreLib.Lux.Data/Migrations/DataLayerContextModelSnapshot.cs
T
Samuele Locatelli 273fa4fc0c Migration + fix gestione note in offerta
2026-03-18 08:12:19 +01:00

4109 lines
162 KiB
C#
Raw Permalink Blame History

// <auto-generated />
using System;
using EgwCoreLib.Lux.Data;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
#nullable disable
namespace EgwCoreLib.Lux.Data.Migrations
{
[DbContext(typeof(DataLayerContext))]
partial class DataLayerContextModelSnapshot : ModelSnapshot
{
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "8.0.23")
.HasAnnotation("Relational:MaxIdentifierLength", 64);
MySqlModelBuilderExtensions.AutoIncrementColumns(modelBuilder);
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Catalog.TemplateModel", b =>
{
b.Property<int>("TemplateID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("TemplateID"));
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("Envir")
.HasColumnType("int");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("SourceType")
.HasColumnType("int");
b.HasKey("TemplateID");
b.ToTable("sales_template");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Catalog.TemplateRowModel", b =>
{
b.Property<int>("TemplateRowID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("TemplateRowID"));
b.Property<bool>("AwaitBom")
.HasColumnType("tinyint(1)");
b.Property<bool>("AwaitPrice")
.HasColumnType("tinyint(1)");
b.Property<double>("BomCost")
.HasColumnType("double");
b.Property<bool>("BomOk")
.HasColumnType("tinyint(1)");
b.Property<double>("BomPrice")
.HasColumnType("double");
b.Property<int>("Envir")
.HasColumnType("int");
b.Property<string>("FileName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("FileResource")
.IsRequired()
.HasColumnType("longtext");
b.Property<long>("FileSize")
.HasColumnType("bigint");
b.Property<int>("ImgType")
.HasColumnType("int");
b.Property<DateTime>("Inserted")
.HasColumnType("datetime(6)");
b.Property<string>("ItemBOM")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("ItemJCD")
.IsRequired()
.HasColumnType("longtext");
b.Property<bool>("ItemOk")
.HasColumnType("tinyint(1)");
b.Property<string>("ItemSteps")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("ItemTags")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("JobID")
.HasColumnType("int");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("Note")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("ProdItemQty")
.HasColumnType("int");
b.Property<double>("Qty")
.HasColumnType("double");
b.Property<int>("RowNum")
.HasColumnType("int");
b.Property<int>("SellingItemID")
.HasColumnType("int");
b.Property<string>("SerStruct")
.IsRequired()
.HasColumnType("longtext");
b.Property<double>("StepCost")
.HasColumnType("double");
b.Property<double>("StepFlowTime")
.HasColumnType("double");
b.Property<double>("StepLeadTime")
.HasColumnType("double");
b.Property<double>("StepPrice")
.HasColumnType("double");
b.Property<int>("TemplateID")
.HasColumnType("int");
b.Property<string>("TemplateRowUID")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("TemplateRowID");
b.HasIndex("SellingItemID");
b.HasIndex("TemplateID");
b.ToTable("sales_template_row");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Config.EnvirParamModel", b =>
{
b.Property<int>("EnvirID")
.HasColumnType("int");
b.Property<string>("SerStrucKey")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("EnvirID");
b.ToTable("conf_envir");
b.HasData(
new
{
EnvirID = 1,
SerStrucKey = "SerializedData"
},
new
{
EnvirID = 2,
SerStrucKey = "SerializedData"
},
new
{
EnvirID = 4,
SerStrucKey = "SerializedData"
},
new
{
EnvirID = 3,
SerStrucKey = "SerializedData"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Config.GlassModel", b =>
{
b.Property<int>("GlassID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("GlassID"));
b.Property<string>("Code")
.HasColumnType("longtext");
b.Property<string>("Description")
.HasColumnType("longtext");
b.Property<double>("Thickness")
.HasColumnType("double");
b.HasKey("GlassID");
b.ToTable("conf_glass");
b.HasData(
new
{
GlassID = 1,
Code = "0001",
Description = "Vetro BE 2S 4/12/4",
Thickness = 20.0
},
new
{
GlassID = 2,
Code = "0002",
Description = "Vetro BE 2S 4/16/4",
Thickness = 24.0
},
new
{
GlassID = 3,
Code = "0003",
Description = "Vetro BE 3S 4/12/4/12/4",
Thickness = 36.0
},
new
{
GlassID = 4,
Code = "0004",
Description = "Vetro BE 3S 4/16/4/16/4",
Thickness = 44.0
},
new
{
GlassID = 5,
Code = "0005",
Description = "Vetro BE 2S 4T/12/4T",
Thickness = 20.0
},
new
{
GlassID = 6,
Code = "0006",
Description = "Vetro BE 2S 4T/16/4T",
Thickness = 24.0
},
new
{
GlassID = 7,
Code = "0007",
Description = "Vetro BE 3S 4T/12/4T/12/4T",
Thickness = 36.0
},
new
{
GlassID = 8,
Code = "0008",
Description = "Vetro BE 3S 4T/16/4T/16/4T",
Thickness = 44.0
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Config.ProfileModel", b =>
{
b.Property<int>("ProfileID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("ProfileID"));
b.Property<string>("Code")
.HasColumnType("longtext");
b.Property<string>("Description")
.HasColumnType("longtext");
b.Property<string>("ProfDataRaw")
.HasColumnType("longtext");
b.Property<double>("Thickness")
.HasColumnType("double");
b.Property<string>("ThreshDataRaw")
.HasColumnType("longtext");
b.HasKey("ProfileID");
b.ToTable("conf_profile");
b.HasData(
new
{
ProfileID = 1,
Code = "0001",
Description = "Profilo60",
ProfDataRaw = "",
Thickness = 60.0,
ThreshDataRaw = ""
},
new
{
ProfileID = 2,
Code = "0002",
Description = "Profilo78",
ProfDataRaw = "",
Thickness = 78.0,
ThreshDataRaw = ""
},
new
{
ProfileID = 3,
Code = "0003",
Description = "Profilo90",
ProfDataRaw = "",
Thickness = 90.0,
ThreshDataRaw = ""
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Config.WoodModel", b =>
{
b.Property<int>("WoodID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("WoodID"));
b.Property<string>("Code")
.HasColumnType("longtext");
b.Property<string>("Description")
.HasColumnType("longtext");
b.Property<int>("Type")
.HasColumnType("int");
b.HasKey("WoodID");
b.ToTable("conf_wood");
b.HasData(
new
{
WoodID = 1,
Code = "0001",
Description = "Abete",
Type = 1
},
new
{
WoodID = 2,
Code = "0002",
Description = "Acero",
Type = 1
},
new
{
WoodID = 3,
Code = "0003",
Description = "Pino",
Type = 2
},
new
{
WoodID = 4,
Code = "0004",
Description = "Tek",
Type = 3
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Cost.CostDriverModel", b =>
{
b.Property<int>("CostDriverID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("CostDriverID"));
b.Property<string>("Descript")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("Unit")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("CostDriverID");
b.ToTable("cost_driver");
b.HasData(
new
{
CostDriverID = 1,
Descript = "Ore lavorate",
Name = "WorkHour",
Unit = "h"
},
new
{
CostDriverID = 2,
Descript = "Metri prodotto",
Name = "Meter",
Unit = "m"
},
new
{
CostDriverID = 3,
Descript = "Unità prodotto",
Name = "Unit",
Unit = "#"
},
new
{
CostDriverID = 4,
Descript = "Volume prodotto",
Name = "Volume",
Unit = "m3"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Cost.ResourceModel", b =>
{
b.Property<int>("ResourceID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("ResourceID"));
b.Property<string>("CodResource")
.IsRequired()
.HasColumnType("longtext");
b.Property<decimal>("CostDriverBudget")
.HasColumnType("decimal(65,30)");
b.Property<int>("CostDriverID")
.HasColumnType("int");
b.Property<decimal>("EBTPerc")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("FixedCost")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("LaborCost")
.HasColumnType("decimal(65,30)");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.Property<decimal>("OverHeadCost")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("OverHeadPerc")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("PriceMargin")
.HasColumnType("decimal(65,30)");
b.Property<decimal>("VariableCost")
.HasColumnType("decimal(65,30)");
b.HasKey("ResourceID");
b.HasIndex("CostDriverID");
b.ToTable("cost_resource");
b.HasData(
new
{
ResourceID = 1,
CodResource = "0000",
CostDriverBudget = 1m,
CostDriverID = 3,
EBTPerc = 0.15m,
FixedCost = 50m,
LaborCost = 100m,
Name = "Item Generico",
OverHeadCost = 100m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 50m
},
new
{
ResourceID = 2,
CodResource = "0010",
CostDriverBudget = 2200m,
CostDriverID = 3,
EBTPerc = 0.15m,
FixedCost = 200000m,
LaborCost = 200000m,
Name = "Serramento (media annua globale)",
OverHeadCost = 100000m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 200000m
},
new
{
ResourceID = 3,
CodResource = "0110",
CostDriverBudget = 880m,
CostDriverID = 1,
EBTPerc = 0.15m,
FixedCost = 12000m,
LaborCost = 30m,
Name = "Sezionatrice",
OverHeadCost = 5000m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 6000m
},
new
{
ResourceID = 4,
CodResource = "0120.01",
CostDriverBudget = 1760m,
CostDriverID = 1,
EBTPerc = 0.15m,
FixedCost = 100000m,
LaborCost = 40m,
Name = "Linea SAOMAD WoodPecker Just 3500",
OverHeadCost = 15000m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 30000m
},
new
{
ResourceID = 5,
CodResource = "0120.02",
CostDriverBudget = 1760m,
CostDriverID = 1,
EBTPerc = 0.15m,
FixedCost = 24000m,
LaborCost = 35m,
Name = "Linea Pantografo",
OverHeadCost = 5000m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 6000m
},
new
{
ResourceID = 6,
CodResource = "0130.01",
CostDriverBudget = 880m,
CostDriverID = 1,
EBTPerc = 0.15m,
FixedCost = 24000m,
LaborCost = 30m,
Name = "Stazione Verniciatura",
OverHeadCost = 3000m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 6000m
},
new
{
ResourceID = 7,
CodResource = "0130.02",
CostDriverBudget = 220m,
CostDriverID = 1,
EBTPerc = 0.15m,
FixedCost = 6000m,
LaborCost = 30m,
Name = "Verniciatura Manuale",
OverHeadCost = 3000m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 2000m
},
new
{
ResourceID = 8,
CodResource = "0140",
CostDriverBudget = 3520m,
CostDriverID = 1,
EBTPerc = 0.15m,
FixedCost = 500m,
LaborCost = 30m,
Name = "Montaggio Manuale",
OverHeadCost = 500m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 500m
},
new
{
ResourceID = 9,
CodResource = "0150",
CostDriverBudget = 3520m,
CostDriverID = 1,
EBTPerc = 0.15m,
FixedCost = 0m,
LaborCost = 40m,
Name = "Installatore",
OverHeadCost = 0m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 3000m
},
new
{
ResourceID = 10,
CodResource = "0120.3",
CostDriverBudget = 1760m,
CostDriverID = 1,
EBTPerc = 0.15m,
FixedCost = 100000m,
LaborCost = 40m,
Name = "Linea Essetre FAST",
OverHeadCost = 15000m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 30000m
},
new
{
ResourceID = 11,
CodResource = "0120.0",
CostDriverBudget = 1760m,
CostDriverID = 1,
EBTPerc = 0.15m,
FixedCost = 0m,
LaborCost = 40m,
Name = "Lavorazione Manuale /Esterna",
OverHeadCost = 15000m,
OverHeadPerc = 0.15m,
PriceMargin = 0.2m,
VariableCost = 90000m
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Items.ItemGroupModel", b =>
{
b.Property<string>("CodGroup")
.HasColumnType("varchar(255)");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("CodGroup");
b.ToTable("item_group");
b.HasData(
new
{
CodGroup = "BeamTrunk",
Description = "Barre legno per lavorazione Travi"
},
new
{
CodGroup = "WindowTrunk",
Description = "Barre legno per lavorazione Finestre"
},
new
{
CodGroup = "WindowGlass",
Description = "Vetri serramento"
},
new
{
CodGroup = "WindowVarnish",
Description = "Vernici per legno"
},
new
{
CodGroup = "WindowHardware",
Description = "Ferramenta serramento"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Items.ItemModel", b =>
{
b.Property<int>("ItemID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("ItemID"));
b.Property<string>("CodGroup")
.IsRequired()
.HasColumnType("varchar(255)");
b.Property<double>("Cost")
.HasColumnType("double");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("ExtItemCode")
.IsRequired()
.HasColumnType("longtext");
b.Property<bool>("IsService")
.HasColumnType("tinyint(1)");
b.Property<int>("ItemCode")
.HasColumnType("int");
b.Property<int>("ItemIDParent")
.HasColumnType("int");
b.Property<int>("ItemType")
.HasColumnType("int");
b.Property<double>("Margin")
.HasColumnType("double");
b.Property<double>("QtyMax")
.HasColumnType("double");
b.Property<double>("QtyMin")
.HasColumnType("double");
b.Property<string>("SupplCode")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("UM")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("ItemID");
b.HasIndex("CodGroup");
b.ToTable("item_item");
b.HasData(
new
{
ItemID = 1,
CodGroup = "WindowTrunk",
Cost = 20.0,
Description = "BARRA-60x80 generica",
ExtItemCode = "",
IsService = false,
ItemCode = 1001,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.29999999999999999,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "BARR.001",
UM = "#"
},
new
{
ItemID = 2,
CodGroup = "WindowTrunk",
Cost = 16.5,
Description = "Barra 60x80, lunghezza 12m",
ExtItemCode = "BARRA-60x80x12000",
IsService = false,
ItemCode = 1002,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.20999999999999999,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "ABC.00123.12000",
UM = "#"
},
new
{
ItemID = 3,
CodGroup = "WindowTrunk",
Cost = 17.5,
Description = "Barra 60x80, lunghezza 8m",
ExtItemCode = "BARRA-60x80x8000",
IsService = false,
ItemCode = 1003,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.22,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "ABC.00123.8000",
UM = "#"
},
new
{
ItemID = 4,
CodGroup = "WindowTrunk",
Cost = 15.5,
Description = "Barra 60x80, lunghezza 16m",
ExtItemCode = "BARRA-60x80x16000",
IsService = false,
ItemCode = 1004,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.20000000000000001,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "ABC.00123.16000",
UM = "#"
},
new
{
ItemID = 5,
CodGroup = "WindowGlass",
Cost = 300.0,
Description = "Vetro triplo, basso indice termico, 800x1000",
ExtItemCode = "VETRO-3L-THERMO-800x1000",
IsService = false,
ItemCode = 2001,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.20000000000000001,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "V3T.800.1000",
UM = "m2"
},
new
{
ItemID = 6,
CodGroup = "WindowGlass",
Cost = 200.0,
Description = "Vetro doppio, 800x1000",
ExtItemCode = "VETRO-2L-800x1000",
IsService = false,
ItemCode = 2002,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.14999999999999999,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "V2.800.1000",
UM = "m2"
},
new
{
ItemID = 7,
CodGroup = "WindowGlass",
Cost = 250.0,
Description = "Vetro triplo, 800x1000",
ExtItemCode = "VETRO-3L-800x1000",
IsService = false,
ItemCode = 2003,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.17999999999999999,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "V3.800.1000",
UM = "m2"
},
new
{
ItemID = 8,
CodGroup = "WindowVarnish",
Cost = 20.0,
Description = "Vernice trasparente",
ExtItemCode = "VERN-TRASP",
IsService = false,
ItemCode = 3001,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.20000000000000001,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "VT.STD",
UM = "l"
},
new
{
ItemID = 9,
CodGroup = "WindowHardware",
Cost = 65.0,
Description = "Kit standard completo AGB tipo 001",
ExtItemCode = "KIT-001",
IsService = false,
ItemCode = 5001,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.20000000000000001,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "AGB-KIT-001",
UM = "#"
},
new
{
ItemID = 10,
CodGroup = "WindowHardware",
Cost = 10.0,
Description = "Cerniera AGB tipo 001",
ExtItemCode = "CERN-001",
IsService = false,
ItemCode = 5002,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.20000000000000001,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "AGB-CERN-001",
UM = "#"
},
new
{
ItemID = 11,
CodGroup = "WindowHardware",
Cost = 15.0,
Description = "Serratura AGB tipo 001",
ExtItemCode = "SERR-001",
IsService = false,
ItemCode = 5003,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.20000000000000001,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "AGB-SERR-001",
UM = "#"
},
new
{
ItemID = 12,
CodGroup = "WindowHardware",
Cost = 25.0,
Description = "Maniglia AGB tipo 001",
ExtItemCode = "MAN-001",
IsService = false,
ItemCode = 5004,
ItemIDParent = 0,
ItemType = 1,
Margin = 0.20000000000000001,
QtyMax = 0.0,
QtyMin = 0.0,
SupplCode = "AGB-MAN-001",
UM = "#"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Items.SellingItemModel", b =>
{
b.Property<int>("SellingItemID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("SellingItemID"));
b.Property<double>("Cost")
.HasColumnType("double");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("Envir")
.HasColumnType("int");
b.Property<string>("ExtItemCode")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("FileName")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("ImgType")
.HasColumnType("int");
b.Property<bool>("IsService")
.HasColumnType("tinyint(1)");
b.Property<int>("ItemCode")
.HasColumnType("int");
b.Property<string>("ItemSteps")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("JobID")
.HasColumnType("int");
b.Property<double>("Margin")
.HasColumnType("double");
b.Property<string>("SerStruct")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("SourceType")
.HasColumnType("int");
b.Property<string>("SupplCode")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("UM")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("SellingItemID");
b.HasIndex("JobID");
b.ToTable("item_selling_item");
b.HasData(
new
{
SellingItemID = 1,
Cost = 500.0,
Description = "Finestra Anta Singola",
Envir = 1,
ExtItemCode = "",
FileName = "",
ImgType = 0,
IsService = false,
ItemCode = 0,
ItemSteps = "",
JobID = 2,
Margin = 0.20000000000000001,
SerStruct = "{\"ProfilePath\": \"Profilo78\",\"Material\": \"Pino\",\"ColorMaterial\": \"Black\",\"Glass\": \"Vetro BE 2S 4T/16/4T\",\"AreaList\": [{\"Shape\": \"RECTANGLE\",\"DimensionList\": [{\"Index\": 1,\"Name\": \"Width\",\"Value\": 800.0},{\"Index\": 2,\"Name\": \"Height\",\"Value\": 1200.0}],\"JointList\": [{\"Index\": 1,\"JointType\": \"FULL_H\"},{\"Index\": 2,\"JointType\": \"FULL_H\"},{\"Index\": 3,\"JointType\": \"FULL_H\"},{\"Index\": 4,\"JointType\": \"FULL_H\"}],\"BottomRail\": false,\"BottomRailQty\": 0,\"GroupId\": 1,\"AreaList\": [{\"IsSashVertical\": true,\"SashList\": [{\"SashId\": 1,\"OpeningType\": \"TILTTURN_LEFT\",\"HasHandle\": true,\"Dimension\": 100.0}],\"SashType\": \"NULL\",\"JointList\": [{\"Index\": 1,\"JointType\": \"FULL_H\"},{\"Index\": 2,\"JointType\": \"FULL_H\"},{\"Index\": 3,\"JointType\": \"FULL_H\"},{\"Index\": 4,\"JointType\": \"FULL_H\"}],\"Hardware\": \"000635\",\"HwOptionList\": [{\"Name\": \"Entrata\",\"Value\": \"15\"},{\"Name\": \"LavManigliaPassante\",\"Value\": \"false\"},{\"Name\": \"PosizioneForoCilindro\",\"Value\": \"sotto\"},{\"Name\": \"Deviatore\",\"Value\": \"false\"},{\"Name\": \"ModelloCilindro\",\"Value\": \"c999\"},{\"Name\": \"LavCilindroPassante\",\"Value\": \"false\"},{\"Name\": \"HMan\",\"Value\": \"400\"}],\"GroupId\": 2,\"AreaList\": [{\"FillType\": \"GLASS\",\"GroupId\": 3,\"AreaList\": [],\"AreaType\": \"FILL\"}],\"AreaType\": \"SASH\"}],\"AreaType\": \"FRAME\"}]}",
SourceType = 0,
SupplCode = "",
UM = "#"
},
new
{
SellingItemID = 2,
Cost = 300.0,
Description = "Finestra Vetro Fisso ",
Envir = 1,
ExtItemCode = "",
FileName = "",
ImgType = 0,
IsService = false,
ItemCode = 0,
ItemSteps = "",
JobID = 2,
Margin = 0.20000000000000001,
SerStruct = "{\"ProfilePath\": \"Profilo78\",\"Material\": \"Pino\",\"ColorMaterial\": \"Black\",\"Glass\": \"Vetro BE 2S 4T/16/4T\",\"AreaList\": [{\"Shape\": \"RECTANGLE\",\"DimensionList\": [{\"Index\": 1,\"Name\": \"Width\",\"Value\": 800.0},{\"Index\": 2,\"Name\": \"Height\",\"Value\": 1200.0}],\"JointList\": [{\"Index\": 1,\"JointType\": \"FULL_H\"},{\"Index\": 2,\"JointType\": \"FULL_H\"},{\"Index\": 3,\"JointType\": \"FULL_H\"},{\"Index\": 4,\"JointType\": \"FULL_H\"}],\"BottomRail\": false,\"BottomRailQty\": 0,\"GroupId\": 1,\"AreaList\": [{\"IsSashVertical\": true,\"SashList\": [{\"SashId\": 1,\"OpeningType\": \"TILTTURN_LEFT\",\"HasHandle\": true,\"Dimension\": 100.0}],\"SashType\": \"NULL\",\"JointList\": [{\"Index\": 1,\"JointType\": \"FULL_H\"},{\"Index\": 2,\"JointType\": \"FULL_H\"},{\"Index\": 3,\"JointType\": \"FULL_H\"},{\"Index\": 4,\"JointType\": \"FULL_H\"}],\"Hardware\": \"000635\",\"HwOptionList\": [{\"Name\": \"Entrata\",\"Value\": \"15\"},{\"Name\": \"LavManigliaPassante\",\"Value\": \"false\"},{\"Name\": \"PosizioneForoCilindro\",\"Value\": \"sotto\"},{\"Name\": \"Deviatore\",\"Value\": \"false\"},{\"Name\": \"ModelloCilindro\",\"Value\": \"c999\"},{\"Name\": \"LavCilindroPassante\",\"Value\": \"false\"},{\"Name\": \"HMan\",\"Value\": \"400\"}],\"GroupId\": 2,\"AreaList\": [{\"FillType\": \"GLASS\",\"GroupId\": 3,\"AreaList\": [],\"AreaType\": \"FILL\"}],\"AreaType\": \"SASH\"}],\"AreaType\": \"FRAME\"}]}",
SourceType = 0,
SupplCode = "",
UM = "#"
},
new
{
SellingItemID = 3,
Cost = 150.0,
Description = "Persiana anta singola",
Envir = 1,
ExtItemCode = "",
FileName = "",
ImgType = 0,
IsService = false,
ItemCode = 0,
ItemSteps = "",
JobID = 1,
Margin = 0.10000000000000001,
SerStruct = "",
SourceType = 0,
SupplCode = "",
UM = "#"
},
new
{
SellingItemID = 4,
Cost = 200.0,
Description = "Installazione",
Envir = 1,
ExtItemCode = "",
FileName = "",
ImgType = 0,
IsService = true,
ItemCode = 0,
ItemSteps = "",
JobID = 1,
Margin = 0.29999999999999999,
SerStruct = "",
SourceType = 0,
SupplCode = "",
UM = "#"
},
new
{
SellingItemID = 5,
Cost = 1000.0,
Description = "Trave lamellare",
Envir = 2,
ExtItemCode = "",
FileName = "",
ImgType = 0,
IsService = false,
ItemCode = 0,
ItemSteps = "",
JobID = 3,
Margin = 0.29999999999999999,
SerStruct = "",
SourceType = 0,
SupplCode = "",
UM = "#"
},
new
{
SellingItemID = 6,
Cost = 500.0,
Description = "Cabinet",
Envir = 4,
ExtItemCode = "",
FileName = "",
ImgType = 0,
IsService = false,
ItemCode = 0,
ItemSteps = "",
JobID = 4,
Margin = 0.29999999999999999,
SerStruct = "",
SourceType = 0,
SupplCode = "",
UM = "#"
},
new
{
SellingItemID = 7,
Cost = 2000.0,
Description = "Parete",
Envir = 3,
ExtItemCode = "",
FileName = "",
ImgType = 0,
IsService = false,
ItemCode = 0,
ItemSteps = "",
JobID = 5,
Margin = 0.29999999999999999,
SerStruct = "",
SourceType = 0,
SupplCode = "",
UM = "#"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Items.SupplierModel", b =>
{
b.Property<int>("SupplierID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("SupplierID"));
b.Property<string>("CompanyName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("FirstName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("LastName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("VAT")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("SupplierID");
b.ToTable("item_supplier");
b.HasData(
new
{
SupplierID = 1,
CompanyName = "Company One",
FirstName = "Supplier A",
LastName = "Egalware",
VAT = "7294857103879254"
},
new
{
SupplierID = 2,
CompanyName = "Company Two",
FirstName = "Supplier B",
LastName = "User",
VAT = "7294857103879254"
},
new
{
SupplierID = 3,
CompanyName = "Company Two",
FirstName = "Supplier C",
LastName = "User Test",
VAT = "7294857103879254"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobDriverConfigModel", b =>
{
b.Property<int>("JobDriverConfID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("JobDriverConfID"));
b.Property<int>("CostDriverID")
.HasColumnType("int");
b.Property<double>("DefaultVal")
.HasColumnType("double");
b.Property<double>("Intercept")
.HasColumnType("double");
b.Property<int>("JobDriverID")
.HasColumnType("int");
b.Property<int>("JobID")
.HasColumnType("int");
b.Property<string>("Note")
.IsRequired()
.HasColumnType("longtext");
b.Property<double>("Regress")
.HasColumnType("double");
b.HasKey("JobDriverConfID");
b.HasIndex("CostDriverID");
b.HasIndex("JobDriverID");
b.HasIndex("JobID");
b.ToTable("task_job_driver_config");
b.HasData(
new
{
JobDriverConfID = 1,
CostDriverID = 3,
DefaultVal = 1.0,
Intercept = 0.0,
JobDriverID = 3,
JobID = 6,
Note = "Numero prodotti",
Regress = 1.0
},
new
{
JobDriverConfID = 2,
CostDriverID = 3,
DefaultVal = 1.0,
Intercept = 0.0,
JobDriverID = 3,
JobID = 7,
Note = "Numero prodotti",
Regress = 1.0
},
new
{
JobDriverConfID = 3,
CostDriverID = 1,
DefaultVal = 5.0,
Intercept = 0.0,
JobDriverID = 1,
JobID = 7,
Note = "Ore Equivalenti",
Regress = 0.016666666666666666
},
new
{
JobDriverConfID = 4,
CostDriverID = 3,
DefaultVal = 1.0,
Intercept = 0.0,
JobDriverID = 3,
JobID = 2,
Note = "Numero prodotti",
Regress = 1.0
},
new
{
JobDriverConfID = 5,
CostDriverID = 1,
DefaultVal = 5.0,
Intercept = 0.0,
JobDriverID = 1,
JobID = 2,
Note = "Ore Equivalenti",
Regress = 0.016666666666666666
},
new
{
JobDriverConfID = 6,
CostDriverID = 1,
DefaultVal = 8.0,
Intercept = 0.0,
JobDriverID = 4,
JobID = 2,
Note = "Ore Extra per complex Articolo (1 min/pezzo)",
Regress = 0.016666666666666666
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobDriverModel", b =>
{
b.Property<int>("JobDriverID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("JobDriverID"));
b.Property<string>("Descript")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("JobDriverID");
b.ToTable("task_job_driver");
b.HasData(
new
{
JobDriverID = 1,
Descript = "Tempo netto di lavorazione, in minuti",
Name = "LeadTime"
},
new
{
JobDriverID = 2,
Descript = "Tempo di attraversamento complessivo del processo, in giorni lavorativi",
Name = "FlowTime"
},
new
{
JobDriverID = 3,
Descript = "Numero Articoli/Prodotti",
Name = "NumArticoli"
},
new
{
JobDriverID = 4,
Descript = "Numero Items per Articolo",
Name = "NumItems"
},
new
{
JobDriverID = 5,
Descript = "Indice complex lavorazioni",
Name = "WorkCompScore"
},
new
{
JobDriverID = 6,
Descript = "Indice complex materiali",
Name = "MaterialCompScore"
},
new
{
JobDriverID = 7,
Descript = "Indice complex generale",
Name = "GeneralScore"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobStepItemModel", b =>
{
b.Property<int>("JobStepItemID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("JobStepItemID"));
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("Index")
.HasColumnType("int");
b.Property<int>("ItemID")
.HasColumnType("int");
b.Property<int>("JobStepID")
.HasColumnType("int");
b.Property<double>("Qty")
.HasColumnType("double");
b.HasKey("JobStepItemID");
b.HasIndex("ItemID");
b.HasIndex("JobStepID");
b.ToTable("task_job_step_item");
b.HasData(
new
{
JobStepItemID = 1,
Description = "Grezzo legno abete",
Index = 1,
ItemID = 1,
JobStepID = 1,
Qty = 1.0
},
new
{
JobStepItemID = 2,
Description = "Vernice trasparente standard 1L",
Index = 2,
ItemID = 8,
JobStepID = 3,
Qty = 0.10000000000000001
},
new
{
JobStepItemID = 3,
Description = "Ferramenta AGB - rif. AGFD.00000.00000",
Index = 3,
ItemID = 9,
JobStepID = 4,
Qty = 1.0
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobStepModel", b =>
{
b.Property<int>("JobStepID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("JobStepID"));
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("Index")
.HasColumnType("int");
b.Property<int>("JobID")
.HasColumnType("int");
b.Property<int>("PhaseID")
.HasColumnType("int");
b.Property<decimal>("ProductivityRate")
.HasColumnType("decimal(65,30)");
b.Property<int>("ResourceID")
.HasColumnType("int");
b.Property<string>("TagsModelCodTag")
.HasColumnType("varchar(255)");
b.HasKey("JobStepID");
b.HasIndex("JobID");
b.HasIndex("PhaseID");
b.HasIndex("ResourceID");
b.HasIndex("TagsModelCodTag");
b.ToTable("task_job_step");
b.HasData(
new
{
JobStepID = 1,
Description = "Preparazione Tronchetti",
Index = 1,
JobID = 2,
PhaseID = 1,
ProductivityRate = 1m,
ResourceID = 3
},
new
{
JobStepID = 2,
Description = "Taglio profilo",
Index = 2,
JobID = 2,
PhaseID = 2,
ProductivityRate = 1m,
ResourceID = 4
},
new
{
JobStepID = 3,
Description = "Verniciatura",
Index = 3,
JobID = 2,
PhaseID = 3,
ProductivityRate = 1m,
ResourceID = 6
},
new
{
JobStepID = 4,
Description = "Assemblaggio Serramento",
Index = 4,
JobID = 2,
PhaseID = 4,
ProductivityRate = 1m,
ResourceID = 8
},
new
{
JobStepID = 5,
Description = "Installazione cliente",
Index = 5,
JobID = 2,
PhaseID = 6,
ProductivityRate = 1m,
ResourceID = 9
},
new
{
JobStepID = 6,
Description = "Produzione Serramento (media annua)",
Index = 1,
JobID = 6,
PhaseID = 7,
ProductivityRate = 1m,
ResourceID = 2
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobStepTagModel", b =>
{
b.Property<int>("JobStepID")
.HasColumnType("int");
b.Property<string>("CodTag")
.HasColumnType("varchar(255)");
b.HasKey("JobStepID", "CodTag");
b.HasIndex("CodTag");
b.ToTable("task_job_step_tag");
b.HasData(
new
{
JobStepID = 1,
CodTag = "Serramento"
},
new
{
JobStepID = 2,
CodTag = "Serramento"
},
new
{
JobStepID = 3,
CodTag = "Serramento"
},
new
{
JobStepID = 4,
CodTag = "Serramento"
},
new
{
JobStepID = 5,
CodTag = "Serramento"
},
new
{
JobStepID = 6,
CodTag = "Serramento"
},
new
{
JobStepID = 2,
CodTag = "LineaCNC"
},
new
{
JobStepID = 4,
CodTag = "Montaggio"
},
new
{
JobStepID = 5,
CodTag = "Servizi"
},
new
{
JobStepID = 2,
CodTag = "LineaManuale"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobTaskModel", b =>
{
b.Property<int>("JobID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("JobID"));
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<bool>("Enabled")
.HasColumnType("tinyint(1)");
b.Property<int>("Index")
.HasColumnType("int");
b.Property<bool>("Lock")
.HasColumnType("tinyint(1)");
b.Property<string>("TagsModelCodTag")
.HasColumnType("varchar(255)");
b.HasKey("JobID");
b.HasIndex("TagsModelCodTag");
b.ToTable("task_job");
b.HasData(
new
{
JobID = 1,
Description = "Rivendita / servizi",
Enabled = true,
Index = 4,
Lock = true
},
new
{
JobID = 2,
Description = "Serramento Legno - Ciclo Completo con installazione",
Enabled = true,
Index = 3,
Lock = true
},
new
{
JobID = 3,
Description = "Realizzazione Trave",
Enabled = true,
Index = 5,
Lock = true
},
new
{
JobID = 4,
Description = "Realizzazione Cabinet",
Enabled = true,
Index = 6,
Lock = true
},
new
{
JobID = 5,
Description = "Realizzazione Parete",
Enabled = true,
Index = 7,
Lock = true
},
new
{
JobID = 6,
Description = "Serramento - ciclo base",
Enabled = true,
Index = 1,
Lock = true
},
new
{
JobID = 7,
Description = "Serramento - ciclo intermedio",
Enabled = true,
Index = 2,
Lock = true
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobTaskTagModel", b =>
{
b.Property<int>("JobID")
.HasColumnType("int");
b.Property<string>("CodTag")
.HasColumnType("varchar(255)");
b.HasKey("JobID", "CodTag");
b.HasIndex("CodTag");
b.ToTable("task_job_task_tag");
b.HasData(
new
{
JobID = 1,
CodTag = "Rivendita"
},
new
{
JobID = 2,
CodTag = "Serramento"
},
new
{
JobID = 3,
CodTag = "Trave"
},
new
{
JobID = 4,
CodTag = "Cabinet"
},
new
{
JobID = 5,
CodTag = "Parete"
},
new
{
JobID = 6,
CodTag = "Serramento"
},
new
{
JobID = 7,
CodTag = "Serramento"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.PhaseModel", b =>
{
b.Property<int>("PhaseID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("PhaseID"));
b.Property<string>("CodPhase")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("Name")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("PhaseID");
b.ToTable("task_phase");
b.HasData(
new
{
PhaseID = 1,
CodPhase = "010",
Description = "Taglio tronchetti",
Name = "Taglio"
},
new
{
PhaseID = 2,
CodPhase = "020",
Description = "Lavorazione pezzi serramento",
Name = "Lavorazione CNC"
},
new
{
PhaseID = 3,
CodPhase = "030",
Description = "Verniciatura",
Name = "Verniciatura"
},
new
{
PhaseID = 4,
CodPhase = "030.01",
Description = "Assemblaggio completo",
Name = "Montaggio"
},
new
{
PhaseID = 5,
CodPhase = "030.02",
Description = "Assemblaggio Ferramenta",
Name = "Ferramenta"
},
new
{
PhaseID = 6,
CodPhase = "040",
Description = "Installazione e posa in opera",
Name = "Installazione"
},
new
{
PhaseID = 7,
CodPhase = "000",
Description = "Produzione Completa: Fase Unica complessiva",
Name = "Produzione Completa"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionBatchModel", b =>
{
b.Property<int>("ProdBatchID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("ProdBatchID"));
b.Property<string>("BatchTag")
.IsRequired()
.HasColumnType("longtext");
b.Property<DateTime?>("DateEnd")
.HasColumnType("datetime(6)");
b.Property<DateTime?>("DateStart")
.HasColumnType("datetime(6)");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<DateTime>("DueDate")
.HasColumnType("datetime(6)");
b.Property<int>("Envir")
.HasColumnType("int");
b.HasKey("ProdBatchID");
b.ToTable("production_batch");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionGroupModel", b =>
{
b.Property<int>("ProdGroupID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("ProdGroupID"));
b.Property<int>("GrpIdx")
.HasColumnType("int");
b.Property<int>("OrderRowID")
.HasColumnType("int");
b.Property<string>("WorkGroupListRaw")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("ProdGroupID");
b.HasIndex("OrderRowID");
b.ToTable("production_group");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionItem2ODLModel", b =>
{
b.Property<int>("ProdItemID")
.HasColumnType("int");
b.Property<int>("ProdODLID")
.HasColumnType("int");
b.Property<DateTime>("DtAssign")
.HasColumnType("datetime(6)");
b.HasKey("ProdItemID", "ProdODLID");
b.HasIndex("ProdODLID");
b.ToTable("production_item2odl");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionItemModel", b =>
{
b.Property<int>("ProdItemID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("ProdItemID"));
b.Property<double>("EstimTime")
.HasColumnType("double");
b.Property<string>("ExtItemCode")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("ItemCode")
.HasColumnType("int");
b.Property<int>("OrderRowID")
.HasColumnType("int");
b.Property<int?>("ProdBatchID")
.HasColumnType("int");
b.Property<int?>("ProdGroupID")
.HasColumnType("int");
b.Property<string>("ProdItemTag")
.HasColumnType("varchar(255)");
b.HasKey("ProdItemID");
b.HasIndex("OrderRowID");
b.HasIndex("ProdBatchID");
b.HasIndex("ProdGroupID");
b.HasIndex("ProdItemTag")
.IsUnique()
.HasDatabaseName("idx_prod_item_tag");
b.ToTable("production_item");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionODLModel", b =>
{
b.Property<int>("ProdODLID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("ProdODLID"));
b.Property<DateTime?>("DateAssign")
.HasColumnType("datetime(6)");
b.Property<DateTime?>("DateEnd")
.HasColumnType("datetime(6)");
b.Property<DateTime?>("DateMaxCompl")
.HasColumnType("datetime(6)");
b.Property<DateTime?>("DateStart")
.HasColumnType("datetime(6)");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<decimal>("EstimTime")
.HasColumnType("decimal(65,30)");
b.Property<int>("Index")
.HasColumnType("int");
b.Property<string>("OdlTag")
.IsRequired()
.HasColumnType("longtext");
b.Property<int?>("PhaseID")
.HasColumnType("int");
b.Property<int>("ProdBatchID")
.HasColumnType("int");
b.Property<string>("ProdPlantCod")
.IsRequired()
.HasColumnType("longtext");
b.Property<double>("Qty")
.HasColumnType("double");
b.Property<string>("RawBoM")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("RawItemRawList")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("RawMaterials")
.IsRequired()
.HasColumnType("longtext");
b.Property<int?>("ResourceID")
.HasColumnType("int");
b.Property<decimal>("WorkTime")
.HasColumnType("decimal(65,30)");
b.HasKey("ProdODLID");
b.HasIndex("ProdBatchID");
b.ToTable("production_odl");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionPlantModel", b =>
{
b.Property<string>("ProdPlantCod")
.HasColumnType("varchar(255)");
b.Property<bool>("IsManual")
.HasColumnType("tinyint(1)");
b.Property<bool>("Outsource")
.HasColumnType("tinyint(1)");
b.Property<string>("ProdPlantDescript")
.IsRequired()
.HasColumnType("longtext");
b.Property<int?>("ResourceID")
.HasColumnType("int");
b.HasKey("ProdPlantCod");
b.HasIndex("ResourceID");
b.ToTable("production_plant");
b.HasData(
new
{
ProdPlantCod = "EXT",
IsManual = true,
Outsource = true,
ProdPlantDescript = "External / Manuale"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.CustomerModel", b =>
{
b.Property<int>("CustomerID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("CustomerID"));
b.Property<string>("CompanyName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("FirstName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("LastName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("VAT")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("CustomerID");
b.ToTable("sales_customer");
b.HasData(
new
{
CustomerID = 1,
CompanyName = "",
FirstName = "Customer A",
LastName = "Egalware",
VAT = "1234567890123456"
},
new
{
CustomerID = 2,
CompanyName = "",
FirstName = "Customer B",
LastName = "User",
VAT = "1234567890123456"
},
new
{
CustomerID = 3,
CompanyName = "",
FirstName = "Customer C",
LastName = "User Test",
VAT = "1234567890123456"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.DealerModel", b =>
{
b.Property<int>("DealerID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("DealerID"));
b.Property<string>("CompanyName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("FirstName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("LastName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("VAT")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("DealerID");
b.ToTable("sales_dealer");
b.HasData(
new
{
DealerID = 1,
CompanyName = "Company First",
FirstName = "Dealer A",
LastName = "Egalware",
VAT = "9587362514671527"
},
new
{
DealerID = 2,
CompanyName = "Company First",
FirstName = "Dealer B",
LastName = "User",
VAT = "9587362514671527"
},
new
{
DealerID = 3,
CompanyName = "Company Second",
FirstName = "Dealer C",
LastName = "User Test",
VAT = "9587362514671527"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OfferModel", b =>
{
b.Property<int>("OfferID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("OfferID"));
b.Property<string>("ConsNote")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("CustomerID")
.HasColumnType("int");
b.Property<int>("DealerID")
.HasColumnType("int");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("DictPresel")
.IsRequired()
.HasColumnType("longtext");
b.Property<double>("Discount")
.HasColumnType("double");
b.Property<DateTime>("DueDateProm")
.HasColumnType("datetime(6)");
b.Property<DateTime>("DueDateReq")
.HasColumnType("datetime(6)");
b.Property<int>("Envir")
.HasColumnType("int");
b.Property<DateTime>("Inserted")
.HasColumnType("datetime(6)");
b.Property<DateTime>("Modified")
.HasColumnType("datetime(6)");
b.Property<int>("OffertState")
.HasColumnType("int");
b.Property<int>("RefNum")
.HasColumnType("int");
b.Property<int>("RefRev")
.HasColumnType("int");
b.Property<int>("RefYear")
.HasColumnType("int");
b.Property<DateTime>("ValidUntil")
.HasColumnType("datetime(6)");
b.HasKey("OfferID");
b.HasIndex("CustomerID");
b.HasIndex("DealerID");
b.ToTable("sales_offer");
b.HasData(
new
{
OfferID = 1,
ConsNote = "",
CustomerID = 2,
DealerID = 2,
Description = "Offerta per tre serramenti",
DictPresel = "",
Discount = 0.0,
DueDateProm = new DateTime(2026, 5, 17, 0, 0, 0, 0, DateTimeKind.Local),
DueDateReq = new DateTime(2026, 4, 17, 0, 0, 0, 0, DateTimeKind.Local),
Envir = 1,
Inserted = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Modified = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
OffertState = 0,
RefNum = 1,
RefRev = 1,
RefYear = 2025,
ValidUntil = new DateTime(2026, 4, 18, 7, 36, 8, 630, DateTimeKind.Local).AddTicks(2026)
},
new
{
OfferID = 2,
ConsNote = "",
CustomerID = 2,
DealerID = 2,
Description = "Offerta BEAM",
DictPresel = "",
Discount = 0.0,
DueDateProm = new DateTime(2026, 5, 17, 0, 0, 0, 0, DateTimeKind.Local),
DueDateReq = new DateTime(2026, 4, 17, 0, 0, 0, 0, DateTimeKind.Local),
Envir = 2,
Inserted = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Modified = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
OffertState = 0,
RefNum = 2,
RefRev = 1,
RefYear = 2025,
ValidUntil = new DateTime(2026, 4, 18, 7, 36, 8, 630, DateTimeKind.Local).AddTicks(2044)
},
new
{
OfferID = 3,
ConsNote = "",
CustomerID = 2,
DealerID = 2,
Description = "Offerta Cabinet",
DictPresel = "",
Discount = 0.0,
DueDateProm = new DateTime(2026, 5, 17, 0, 0, 0, 0, DateTimeKind.Local),
DueDateReq = new DateTime(2026, 4, 17, 0, 0, 0, 0, DateTimeKind.Local),
Envir = 4,
Inserted = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Modified = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
OffertState = 0,
RefNum = 3,
RefRev = 1,
RefYear = 2025,
ValidUntil = new DateTime(2026, 4, 18, 7, 36, 8, 630, DateTimeKind.Local).AddTicks(2051)
},
new
{
OfferID = 4,
ConsNote = "",
CustomerID = 2,
DealerID = 2,
Description = "Offerta Wall",
DictPresel = "",
Discount = 0.0,
DueDateProm = new DateTime(2026, 5, 17, 0, 0, 0, 0, DateTimeKind.Local),
DueDateReq = new DateTime(2026, 4, 17, 0, 0, 0, 0, DateTimeKind.Local),
Envir = 3,
Inserted = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
Modified = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
OffertState = 0,
RefNum = 4,
RefRev = 1,
RefYear = 2025,
ValidUntil = new DateTime(2026, 4, 18, 7, 36, 8, 630, DateTimeKind.Local).AddTicks(2057)
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OfferRowModel", b =>
{
b.Property<int>("OfferRowID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("OfferRowID"));
b.Property<bool>("AwaitBom")
.HasColumnType("tinyint(1)");
b.Property<bool>("AwaitPrice")
.HasColumnType("tinyint(1)");
b.Property<double>("BomCost")
.HasColumnType("double");
b.Property<bool>("BomOk")
.HasColumnType("tinyint(1)");
b.Property<double>("BomPrice")
.HasColumnType("double");
b.Property<int>("Envir")
.HasColumnType("int");
b.Property<string>("FileName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("FileResource")
.IsRequired()
.HasColumnType("longtext");
b.Property<long>("FileSize")
.HasColumnType("bigint");
b.Property<int>("ImgType")
.HasColumnType("int");
b.Property<DateTime>("Inserted")
.HasColumnType("datetime(6)");
b.Property<string>("ItemBOM")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("ItemJCD")
.IsRequired()
.HasColumnType("longtext");
b.Property<bool>("ItemOk")
.HasColumnType("tinyint(1)");
b.Property<string>("ItemSteps")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("ItemTags")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("JobID")
.HasColumnType("int");
b.Property<DateTime>("Modified")
.HasColumnType("datetime(6)");
b.Property<string>("Note")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("OfferID")
.HasColumnType("int");
b.Property<string>("OfferRowUID")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("ProdItemQty")
.HasColumnType("int");
b.Property<double>("Qty")
.HasColumnType("double");
b.Property<int>("RowNum")
.HasColumnType("int");
b.Property<int?>("SellingItemID")
.HasColumnType("int");
b.Property<string>("SerStruct")
.IsRequired()
.HasColumnType("longtext");
b.Property<double>("StepCost")
.HasColumnType("double");
b.Property<double>("StepFlowTime")
.HasColumnType("double");
b.Property<double>("StepLeadTime")
.HasColumnType("double");
b.Property<double>("StepPrice")
.HasColumnType("double");
b.Property<int?>("TemplateRowID")
.HasColumnType("int");
b.HasKey("OfferRowID");
b.HasIndex("OfferID");
b.HasIndex("SellingItemID");
b.HasIndex("TemplateRowID");
b.ToTable("sales_offer_row");
b.HasData(
new
{
OfferRowID = 2,
AwaitBom = false,
AwaitPrice = false,
BomCost = 900.0,
BomOk = true,
BomPrice = 950.0,
Envir = 1,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Finestra Anta Singola 2025",
OfferID = 1,
OfferRowUID = "SOR.26.00000002",
ProdItemQty = 0,
Qty = 3.0,
RowNum = 1,
SellingItemID = 1,
SerStruct = "{\"ProfilePath\": \"Profilo78\",\"Material\": \"Pino\",\"ColorMaterial\": \"Black\",\"Glass\": \"Vetro BE 2S 4T/16/4T\",\"AreaList\": [{\"Shape\": \"RECTANGLE\",\"DimensionList\": [{\"Index\": 1,\"Name\": \"Width\",\"Value\": 800.0},{\"Index\": 2,\"Name\": \"Height\",\"Value\": 1200.0}],\"JointList\": [{\"Index\": 1,\"JointType\": \"FULL_H\"},{\"Index\": 2,\"JointType\": \"FULL_H\"},{\"Index\": 3,\"JointType\": \"FULL_H\"},{\"Index\": 4,\"JointType\": \"FULL_H\"}],\"BottomRail\": false,\"BottomRailQty\": 0,\"GroupId\": 1,\"AreaList\": [{\"IsSashVertical\": true,\"SashList\": [{\"SashId\": 1,\"OpeningType\": \"TILTTURN_LEFT\",\"HasHandle\": true,\"Dimension\": 100.0}],\"SashType\": \"NULL\",\"JointList\": [{\"Index\": 1,\"JointType\": \"FULL_H\"},{\"Index\": 2,\"JointType\": \"FULL_H\"},{\"Index\": 3,\"JointType\": \"FULL_H\"},{\"Index\": 4,\"JointType\": \"FULL_H\"}],\"Hardware\": \"000635\",\"HwOptionList\": [{\"Name\": \"Entrata\",\"Value\": \"15\"},{\"Name\": \"LavManigliaPassante\",\"Value\": \"false\"},{\"Name\": \"PosizioneForoCilindro\",\"Value\": \"sotto\"},{\"Name\": \"Deviatore\",\"Value\": \"false\"},{\"Name\": \"ModelloCilindro\",\"Value\": \"c999\"},{\"Name\": \"LavCilindroPassante\",\"Value\": \"false\"},{\"Name\": \"HMan\",\"Value\": \"400\"}],\"GroupId\": 2,\"AreaList\": [{\"FillType\": \"GLASS\",\"GroupId\": 3,\"AreaList\": [],\"AreaType\": \"FILL\"}],\"AreaType\": \"SASH\"}],\"AreaType\": \"FRAME\"}]}",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
},
new
{
OfferRowID = 1,
AwaitBom = false,
AwaitPrice = false,
BomCost = 900.0,
BomOk = true,
BomPrice = 950.0,
Envir = 1,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Finestra Vetro Fisso 2025",
OfferID = 1,
OfferRowUID = "SOR.26.00000001",
ProdItemQty = 0,
Qty = 3.0,
RowNum = 2,
SellingItemID = 2,
SerStruct = "{\"ProfilePath\": \"Profilo78\",\"Material\": \"Pino\",\"ColorMaterial\": \"Black\",\"Glass\": \"Vetro BE 2S 4T/16/4T\",\"AreaList\": [{\"Shape\": \"RECTANGLE\",\"DimensionList\": [{\"Index\": 1,\"Name\": \"Width\",\"Value\": 800.0},{\"Index\": 2,\"Name\": \"Height\",\"Value\": 1200.0}],\"JointList\": [{\"Index\": 1,\"JointType\": \"FULL_H\"},{\"Index\": 2,\"JointType\": \"FULL_H\"},{\"Index\": 3,\"JointType\": \"FULL_H\"},{\"Index\": 4,\"JointType\": \"FULL_H\"}],\"BottomRail\": false,\"BottomRailQty\": 0,\"GroupId\": 1,\"AreaList\": [{\"IsSashVertical\": true,\"SashList\": [{\"SashId\": 1,\"OpeningType\": \"TILTTURN_LEFT\",\"HasHandle\": true,\"Dimension\": 100.0}],\"SashType\": \"NULL\",\"JointList\": [{\"Index\": 1,\"JointType\": \"FULL_H\"},{\"Index\": 2,\"JointType\": \"FULL_H\"},{\"Index\": 3,\"JointType\": \"FULL_H\"},{\"Index\": 4,\"JointType\": \"FULL_H\"}],\"Hardware\": \"000635\",\"HwOptionList\": [{\"Name\": \"Entrata\",\"Value\": \"15\"},{\"Name\": \"LavManigliaPassante\",\"Value\": \"false\"},{\"Name\": \"PosizioneForoCilindro\",\"Value\": \"sotto\"},{\"Name\": \"Deviatore\",\"Value\": \"false\"},{\"Name\": \"ModelloCilindro\",\"Value\": \"c999\"},{\"Name\": \"LavCilindroPassante\",\"Value\": \"false\"},{\"Name\": \"HMan\",\"Value\": \"400\"}],\"GroupId\": 2,\"AreaList\": [{\"FillType\": \"GLASS\",\"GroupId\": 3,\"AreaList\": [],\"AreaType\": \"FILL\"}],\"AreaType\": \"SASH\"}],\"AreaType\": \"FRAME\"}]}",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
},
new
{
OfferRowID = 3,
AwaitBom = false,
AwaitPrice = false,
BomCost = 160.0,
BomOk = true,
BomPrice = 200.0,
Envir = 1,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Persiana per Finestra anta singola 2025",
OfferID = 1,
OfferRowUID = "SOR.26.00000003",
ProdItemQty = 0,
Qty = 3.0,
RowNum = 3,
SellingItemID = 3,
SerStruct = "{}",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
},
new
{
OfferRowID = 4,
AwaitBom = false,
AwaitPrice = false,
BomCost = 200.0,
BomOk = true,
BomPrice = 250.0,
Envir = 1,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Installazione serramento",
OfferID = 1,
OfferRowUID = "SOR.26.00000004",
ProdItemQty = 0,
Qty = 3.0,
RowNum = 4,
SellingItemID = 4,
SerStruct = "{}",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
},
new
{
OfferRowID = 5,
AwaitBom = false,
AwaitPrice = false,
BomCost = 800.0,
BomOk = true,
BomPrice = 1150.0,
Envir = 2,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Demo file 01",
OfferID = 2,
OfferRowUID = "SOR.26.00000005",
ProdItemQty = 0,
Qty = 10.0,
RowNum = 1,
SellingItemID = 5,
SerStruct = "",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
},
new
{
OfferRowID = 6,
AwaitBom = false,
AwaitPrice = false,
BomCost = 600.0,
BomOk = true,
BomPrice = 950.0,
Envir = 2,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Demo file 02",
OfferID = 2,
OfferRowUID = "SOR.26.00000006",
ProdItemQty = 0,
Qty = 4.0,
RowNum = 1,
SellingItemID = 5,
SerStruct = "",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
},
new
{
OfferRowID = 7,
AwaitBom = false,
AwaitPrice = false,
BomCost = 200.0,
BomOk = true,
BomPrice = 250.0,
Envir = 3,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Demo file 01",
OfferID = 3,
OfferRowUID = "SOR.26.00000007",
ProdItemQty = 0,
Qty = 4.0,
RowNum = 1,
SellingItemID = 6,
SerStruct = "",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
},
new
{
OfferRowID = 8,
AwaitBom = false,
AwaitPrice = false,
BomCost = 50.0,
BomOk = true,
BomPrice = 80.0,
Envir = 3,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Demo file 02",
OfferID = 3,
OfferRowUID = "SOR.26.00000008",
ProdItemQty = 0,
Qty = 12.0,
RowNum = 1,
SellingItemID = 6,
SerStruct = "",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
},
new
{
OfferRowID = 9,
AwaitBom = false,
AwaitPrice = false,
BomCost = 800.0,
BomOk = true,
BomPrice = 1150.0,
Envir = 4,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Demo file 01",
OfferID = 4,
OfferRowUID = "SOR.26.00000009",
ProdItemQty = 0,
Qty = 6.0,
RowNum = 1,
SellingItemID = 7,
SerStruct = "",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
},
new
{
OfferRowID = 10,
AwaitBom = false,
AwaitPrice = false,
BomCost = 600.0,
BomOk = true,
BomPrice = 950.0,
Envir = 4,
FileName = "",
FileResource = "",
FileSize = 0L,
ImgType = 0,
Inserted = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
ItemBOM = "",
ItemJCD = "",
ItemOk = true,
ItemSteps = "{}",
ItemTags = "",
JobID = 0,
Modified = new DateTime(2026, 3, 18, 0, 0, 0, 0, DateTimeKind.Local),
Note = "Demo file 02",
OfferID = 4,
OfferRowUID = "SOR.26.0000000A",
ProdItemQty = 0,
Qty = 4.0,
RowNum = 1,
SellingItemID = 7,
SerStruct = "",
StepCost = 0.0,
StepFlowTime = 0.0,
StepLeadTime = 0.0,
StepPrice = 0.0
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OrderModel", b =>
{
b.Property<int>("OrderID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("OrderID"));
b.Property<string>("ConsNote")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("CustomerID")
.HasColumnType("int");
b.Property<int>("DealerID")
.HasColumnType("int");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("DictPresel")
.IsRequired()
.HasColumnType("longtext");
b.Property<double>("Discount")
.HasColumnType("double");
b.Property<DateTime>("DueDateProm")
.HasColumnType("datetime(6)");
b.Property<DateTime>("DueDateReq")
.HasColumnType("datetime(6)");
b.Property<int>("Envir")
.HasColumnType("int");
b.Property<DateTime>("Inserted")
.HasColumnType("datetime(6)");
b.Property<DateTime>("Modified")
.HasColumnType("datetime(6)");
b.Property<int>("OfferID")
.HasColumnType("int");
b.Property<int>("OrderState")
.HasColumnType("int");
b.Property<string>("RawHistory")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("RefNum")
.HasColumnType("int");
b.Property<int>("RefRev")
.HasColumnType("int");
b.Property<int>("RefYear")
.HasColumnType("int");
b.Property<DateTime>("ValidUntil")
.HasColumnType("datetime(6)");
b.HasKey("OrderID");
b.HasIndex("CustomerID");
b.HasIndex("DealerID");
b.HasIndex("OfferID");
b.ToTable("sales_order");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OrderRowModel", b =>
{
b.Property<int>("OrderRowID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("OrderRowID"));
b.Property<bool>("AwaitBom")
.HasColumnType("tinyint(1)");
b.Property<bool>("AwaitPrice")
.HasColumnType("tinyint(1)");
b.Property<double>("BomCost")
.HasColumnType("double");
b.Property<bool>("BomOk")
.HasColumnType("tinyint(1)");
b.Property<double>("BomPrice")
.HasColumnType("double");
b.Property<int>("Envir")
.HasColumnType("int");
b.Property<string>("FileName")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("FileResource")
.IsRequired()
.HasColumnType("longtext");
b.Property<long>("FileSize")
.HasColumnType("bigint");
b.Property<int>("ImgType")
.HasColumnType("int");
b.Property<DateTime>("Inserted")
.HasColumnType("datetime(6)");
b.Property<string>("ItemBOM")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("ItemJCD")
.IsRequired()
.HasColumnType("longtext");
b.Property<bool>("ItemOk")
.HasColumnType("tinyint(1)");
b.Property<string>("ItemSteps")
.IsRequired()
.HasColumnType("longtext");
b.Property<string>("ItemTags")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("JobID")
.HasColumnType("int");
b.Property<DateTime>("Modified")
.HasColumnType("datetime(6)");
b.Property<string>("Note")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("OrderID")
.HasColumnType("int");
b.Property<int>("OrderRowState")
.HasColumnType("int");
b.Property<string>("OrderRowUID")
.IsRequired()
.HasColumnType("longtext");
b.Property<decimal>("ProdEstimTime")
.HasColumnType("decimal(65,30)");
b.Property<string>("ProdEstimate")
.IsRequired()
.HasColumnType("longtext");
b.Property<int>("ProdItemQty")
.HasColumnType("int");
b.Property<double>("Qty")
.HasColumnType("double");
b.Property<int>("RowNum")
.HasColumnType("int");
b.Property<int?>("SellingItemID")
.HasColumnType("int");
b.Property<string>("SerStruct")
.IsRequired()
.HasColumnType("longtext");
b.Property<double>("StepCost")
.HasColumnType("double");
b.Property<double>("StepFlowTime")
.HasColumnType("double");
b.Property<double>("StepLeadTime")
.HasColumnType("double");
b.Property<double>("StepPrice")
.HasColumnType("double");
b.Property<int?>("TemplateRowID")
.HasColumnType("int");
b.HasKey("OrderRowID");
b.HasIndex("OrderID");
b.HasIndex("SellingItemID");
b.HasIndex("TemplateRowID");
b.ToTable("sales_order_row");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Stats.StatsAggregatedModel", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("Id"));
b.Property<double>("AvgDuration")
.HasColumnType("double");
b.Property<DateTime>("Hour")
.HasColumnType("datetime(6)");
b.Property<double>("MaxDuration")
.HasColumnType("double");
b.Property<long>("NoReply")
.HasColumnType("bigint");
b.Property<long>("RequestCount")
.HasColumnType("bigint");
b.HasKey("Id");
b.HasIndex("Hour")
.IsUnique()
.HasDatabaseName("idx_statsaggr_hour");
b.ToTable("stats_aggr");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Stats.StatsDetailModel", b =>
{
b.Property<int>("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("Id"));
b.Property<double>("AvgDuration")
.HasColumnType("double");
b.Property<string>("Environment")
.IsRequired()
.HasColumnType("varchar(255)");
b.Property<DateTime>("Hour")
.HasColumnType("datetime(6)");
b.Property<double>("MaxDuration")
.HasColumnType("double");
b.Property<long>("NoReply")
.HasColumnType("bigint");
b.Property<long>("RequestCount")
.HasColumnType("bigint");
b.Property<string>("Type")
.IsRequired()
.HasColumnType("varchar(255)");
b.HasKey("Id");
b.HasIndex("Hour", "Environment", "Type")
.IsUnique()
.HasDatabaseName("idx_statsdet_hour_env_type");
b.ToTable("stats_detail");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Stock.StockMovModel", b =>
{
b.Property<int>("StockMovID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("StockMovID"));
b.Property<string>("CodDoc")
.IsRequired()
.HasColumnType("longtext");
b.Property<DateTime>("DtCreate")
.ValueGeneratedOnAdd()
.HasColumnType("timestamp")
.HasDefaultValueSql("CURRENT_TIMESTAMP");
b.Property<DateTime>("DtMod")
.ValueGeneratedOnAddOrUpdate()
.HasColumnType("timestamp")
.HasDefaultValueSql("CURRENT_TIMESTAMP");
MySqlPropertyBuilderExtensions.UseMySqlComputedColumn(b.Property<DateTime>("DtMod"));
b.Property<string>("MovCod")
.IsRequired()
.HasColumnType("varchar(255)");
b.Property<string>("Note")
.IsRequired()
.HasColumnType("longtext");
b.Property<double>("QtyRec")
.HasColumnType("double");
b.Property<int>("StockStatusId")
.HasColumnType("int");
b.Property<double>("UnitVal")
.HasColumnType("double");
b.Property<string>("UserId")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("StockMovID");
b.HasIndex("MovCod");
b.HasIndex("StockStatusId");
b.ToTable("stock_mov");
b.HasData(
new
{
StockMovID = 1,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 5.0,
StockStatusId = 1,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
},
new
{
StockMovID = 2,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 8.0,
StockStatusId = 2,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
},
new
{
StockMovID = 3,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 5.0,
StockStatusId = 3,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
},
new
{
StockMovID = 4,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 1.0,
StockStatusId = 4,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
},
new
{
StockMovID = 5,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 10.0,
StockStatusId = 5,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
},
new
{
StockMovID = 6,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 1.0,
StockStatusId = 6,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
},
new
{
StockMovID = 7,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 50.0,
StockStatusId = 7,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
},
new
{
StockMovID = 8,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 1.0,
StockStatusId = 8,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
},
new
{
StockMovID = 9,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 1.0,
StockStatusId = 9,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
},
new
{
StockMovID = 10,
CodDoc = "",
DtCreate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
DtMod = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
MovCod = "CAR",
Note = "DEMO",
QtyRec = 1.0,
StockStatusId = 10,
UnitVal = 0.0,
UserId = "samuele.locatelli@egalware.com"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Stock.StockStatusModel", b =>
{
b.Property<int>("StockStatusId")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("StockStatusId"));
b.Property<bool>("IsDeleted")
.HasColumnType("tinyint(1)");
b.Property<bool>("IsRemn")
.HasColumnType("tinyint(1)");
b.Property<int>("ItemID")
.HasColumnType("int");
b.Property<string>("Location")
.IsRequired()
.HasColumnType("longtext");
b.Property<double>("QtyAvail")
.HasColumnType("double");
b.HasKey("StockStatusId");
b.HasIndex("ItemID");
b.ToTable("stock_status");
b.HasData(
new
{
StockStatusId = 1,
IsDeleted = false,
IsRemn = false,
ItemID = 1,
Location = "B001-001-003",
QtyAvail = 5.0
},
new
{
StockStatusId = 2,
IsDeleted = false,
IsRemn = false,
ItemID = 2,
Location = "B001-001-002",
QtyAvail = 8.0
},
new
{
StockStatusId = 3,
IsDeleted = false,
IsRemn = false,
ItemID = 3,
Location = "B001-001-001",
QtyAvail = 5.0
},
new
{
StockStatusId = 4,
IsDeleted = false,
IsRemn = false,
ItemID = 4,
Location = "V002-001-001",
QtyAvail = 1.0
},
new
{
StockStatusId = 5,
IsDeleted = false,
IsRemn = false,
ItemID = 5,
Location = "V001-001-002",
QtyAvail = 10.0
},
new
{
StockStatusId = 6,
IsDeleted = false,
IsRemn = false,
ItemID = 6,
Location = "V001-001-003",
QtyAvail = 1.0
},
new
{
StockStatusId = 7,
IsDeleted = false,
IsRemn = false,
ItemID = 8,
Location = "V001-001-003",
QtyAvail = 50.0
},
new
{
StockStatusId = 8,
IsDeleted = false,
IsRemn = false,
ItemID = 11,
Location = "S001-002-001",
QtyAvail = 1.0
},
new
{
StockStatusId = 9,
IsDeleted = false,
IsRemn = false,
ItemID = 9,
Location = "S001-002-001",
QtyAvail = 1.0
},
new
{
StockStatusId = 10,
IsDeleted = false,
IsRemn = false,
ItemID = 10,
Location = "S001-001-001",
QtyAvail = 1.0
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Utils.CounterModel", b =>
{
b.Property<int>("RefYear")
.HasColumnType("int");
b.Property<string>("CountName")
.HasColumnType("varchar(255)");
b.Property<int>("Counter")
.HasColumnType("int");
b.HasKey("RefYear", "CountName");
b.ToTable("utils_counter");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Utils.GenClassModel", b =>
{
b.Property<string>("ClassCod")
.HasColumnType("varchar(255)");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("ClassCod");
b.ToTable("utils_gen_class");
b.HasData(
new
{
ClassCod = "ShapeList",
Description = "Elenco Shape Gestite"
},
new
{
ClassCod = "WoodCol",
Description = "Elenco Colori Legno"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Utils.GenValueModel", b =>
{
b.Property<int>("GenValID")
.ValueGeneratedOnAdd()
.HasColumnType("int");
MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("GenValID"));
b.Property<string>("ClassCod")
.IsRequired()
.HasColumnType("varchar(255)");
b.Property<int>("Index")
.HasColumnType("int");
b.Property<string>("ValString")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("GenValID");
b.HasIndex("ClassCod");
b.ToTable("utils_gen_value");
b.HasData(
new
{
GenValID = 1,
ClassCod = "WoodCol",
Index = 1,
ValString = "Blue"
},
new
{
GenValID = 2,
ClassCod = "WoodCol",
Index = 2,
ValString = "White"
},
new
{
GenValID = 3,
ClassCod = "WoodCol",
Index = 3,
ValString = "Red"
},
new
{
GenValID = 4,
ClassCod = "WoodCol",
Index = 4,
ValString = "Black"
},
new
{
GenValID = 5,
ClassCod = "ShapeList",
Index = 1,
ValString = "Rectangle"
},
new
{
GenValID = 6,
ClassCod = "ShapeList",
Index = 2,
ValString = "Trapezoid"
},
new
{
GenValID = 7,
ClassCod = "ShapeList",
Index = 3,
ValString = "Triangular"
},
new
{
GenValID = 8,
ClassCod = "ShapeList",
Index = 4,
ValString = "Arc"
},
new
{
GenValID = 9,
ClassCod = "ShapeList",
Index = 5,
ValString = "FullArc"
},
new
{
GenValID = 10,
ClassCod = "ShapeList",
Index = 6,
ValString = "SemiFullArc"
},
new
{
GenValID = 11,
ClassCod = "ShapeList",
Index = 7,
ValString = "SemiArc"
},
new
{
GenValID = 12,
ClassCod = "ShapeList",
Index = 8,
ValString = "Circle"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Utils.MovTypeModel", b =>
{
b.Property<string>("MovCod")
.HasColumnType("varchar(255)");
b.Property<string>("Description")
.IsRequired()
.HasColumnType("longtext");
b.HasKey("MovCod");
b.ToTable("utils_mov_type");
b.HasData(
new
{
MovCod = "CAR",
Description = "Carico a magazzino"
},
new
{
MovCod = "MOV",
Description = "Movimento interno (spostamento)"
},
new
{
MovCod = "ND",
Description = "Non Definito"
},
new
{
MovCod = "OFOR",
Description = "Ordine Fornitore"
},
new
{
MovCod = "RETT",
Description = "Rettifica magazzino"
},
new
{
MovCod = "SCAR",
Description = "Scarico da magazzino"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Utils.TagsModel", b =>
{
b.Property<string>("CodTag")
.HasColumnType("varchar(255)");
b.HasKey("CodTag");
b.ToTable("utils_tags");
b.HasData(
new
{
CodTag = "Cabinet"
},
new
{
CodTag = "LineaCNC"
},
new
{
CodTag = "LineaManuale"
},
new
{
CodTag = "Montaggio"
},
new
{
CodTag = "Parete"
},
new
{
CodTag = "Rivendita"
},
new
{
CodTag = "Serramento"
},
new
{
CodTag = "Servizi"
},
new
{
CodTag = "Trave"
},
new
{
CodTag = "Trave_200x200"
},
new
{
CodTag = "Trave_400x400"
},
new
{
CodTag = "Trave_800x600"
});
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Catalog.TemplateRowModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Items.SellingItemModel", "SellingItemNav")
.WithMany()
.HasForeignKey("SellingItemID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Catalog.TemplateModel", "TemplateNav")
.WithMany("TemplateRowNav")
.HasForeignKey("TemplateID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("SellingItemNav");
b.Navigation("TemplateNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Cost.ResourceModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Cost.CostDriverModel", "DriverNav")
.WithMany()
.HasForeignKey("CostDriverID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("DriverNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Items.ItemModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Items.ItemGroupModel", "ItemGroupNav")
.WithMany()
.HasForeignKey("CodGroup")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("ItemGroupNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Items.SellingItemModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Job.JobTaskModel", "JobNav")
.WithMany()
.HasForeignKey("JobID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("JobNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobDriverConfigModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Cost.CostDriverModel", "CostDriverNav")
.WithMany()
.HasForeignKey("CostDriverID")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Job.JobDriverModel", "JobDriverNav")
.WithMany()
.HasForeignKey("JobDriverID")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Job.JobTaskModel", "JobNav")
.WithMany()
.HasForeignKey("JobID")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("CostDriverNav");
b.Navigation("JobDriverNav");
b.Navigation("JobNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobStepItemModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Items.ItemModel", "ItemNav")
.WithMany()
.HasForeignKey("ItemID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Job.JobStepModel", "JobStepNav")
.WithMany()
.HasForeignKey("JobStepID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("ItemNav");
b.Navigation("JobStepNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobStepModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Job.JobTaskModel", "JobNav")
.WithMany("JobStepNav")
.HasForeignKey("JobID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Job.PhaseModel", "PhaseNav")
.WithMany()
.HasForeignKey("PhaseID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Cost.ResourceModel", "ResourceNav")
.WithMany("JobStepNav")
.HasForeignKey("ResourceID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Utils.TagsModel", null)
.WithMany("JobSteps")
.HasForeignKey("TagsModelCodTag")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("JobNav");
b.Navigation("PhaseNav");
b.Navigation("ResourceNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobStepTagModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Utils.TagsModel", "TagNav")
.WithMany()
.HasForeignKey("CodTag")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Job.JobStepModel", "JobStepNav")
.WithMany("TagNav")
.HasForeignKey("JobStepID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("JobStepNav");
b.Navigation("TagNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobTaskModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Utils.TagsModel", null)
.WithMany("JobTasks")
.HasForeignKey("TagsModelCodTag")
.OnDelete(DeleteBehavior.Restrict);
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobTaskTagModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Utils.TagsModel", "TagNav")
.WithMany()
.HasForeignKey("CodTag")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Job.JobTaskModel", "JobNav")
.WithMany("TagNav")
.HasForeignKey("JobID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("JobNav");
b.Navigation("TagNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionGroupModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Sales.OrderRowModel", "OrderRowNav")
.WithMany()
.HasForeignKey("OrderRowID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("OrderRowNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionItem2ODLModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Production.ProductionItemModel", "ProductionItemNav")
.WithMany("Item2OdlNav")
.HasForeignKey("ProdItemID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Production.ProductionODLModel", "ProductionODLNav")
.WithMany("Item2OdlNav")
.HasForeignKey("ProdODLID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("ProductionItemNav");
b.Navigation("ProductionODLNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionItemModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Sales.OrderRowModel", "OrderRowNav")
.WithMany("ProdItemNav")
.HasForeignKey("OrderRowID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Production.ProductionBatchModel", "ProductionBatchNav")
.WithMany()
.HasForeignKey("ProdBatchID")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Production.ProductionGroupModel", "ProductionGroupNav")
.WithMany("ItemsNav")
.HasForeignKey("ProdGroupID")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("OrderRowNav");
b.Navigation("ProductionBatchNav");
b.Navigation("ProductionGroupNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionODLModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Production.ProductionBatchModel", "ProdBatchNav")
.WithMany()
.HasForeignKey("ProdBatchID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("ProdBatchNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionPlantModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Cost.ResourceModel", "ResourceNav")
.WithMany()
.HasForeignKey("ResourceID")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("ResourceNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OfferModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Sales.CustomerModel", "CustomerNav")
.WithMany()
.HasForeignKey("CustomerID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Sales.DealerModel", "DealerNav")
.WithMany()
.HasForeignKey("DealerID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("CustomerNav");
b.Navigation("DealerNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OfferRowModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Sales.OfferModel", "OfferNav")
.WithMany("OfferRowNav")
.HasForeignKey("OfferID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Items.SellingItemModel", "SellingItemNav")
.WithMany()
.HasForeignKey("SellingItemID")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Catalog.TemplateRowModel", "TemplateRowNav")
.WithMany()
.HasForeignKey("TemplateRowID")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("OfferNav");
b.Navigation("SellingItemNav");
b.Navigation("TemplateRowNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OrderModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Sales.CustomerModel", "CustomerNav")
.WithMany()
.HasForeignKey("CustomerID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Sales.DealerModel", "DealerNav")
.WithMany()
.HasForeignKey("DealerID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Sales.OfferModel", "OfferNav")
.WithMany()
.HasForeignKey("OfferID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("CustomerNav");
b.Navigation("DealerNav");
b.Navigation("OfferNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OrderRowModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Sales.OrderModel", "OrderNav")
.WithMany("OrderRowNav")
.HasForeignKey("OrderID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Items.SellingItemModel", "SellingItemNav")
.WithMany()
.HasForeignKey("SellingItemID")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Catalog.TemplateRowModel", "TemplateRowNav")
.WithMany()
.HasForeignKey("TemplateRowID")
.OnDelete(DeleteBehavior.Restrict);
b.Navigation("OrderNav");
b.Navigation("SellingItemNav");
b.Navigation("TemplateRowNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Stock.StockMovModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Utils.MovTypeModel", "MovTypeNav")
.WithMany()
.HasForeignKey("MovCod")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Stock.StockStatusModel", "StockStatusNav")
.WithMany()
.HasForeignKey("StockStatusId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("MovTypeNav");
b.Navigation("StockStatusNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Stock.StockStatusModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Items.ItemModel", "ItemNav")
.WithMany()
.HasForeignKey("ItemID")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("ItemNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Utils.GenValueModel", b =>
{
b.HasOne("EgwCoreLib.Lux.Data.DbModel.Utils.GenClassModel", "GenClassNav")
.WithMany("GenValNav")
.HasForeignKey("ClassCod")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.Navigation("GenClassNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Catalog.TemplateModel", b =>
{
b.Navigation("TemplateRowNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Cost.ResourceModel", b =>
{
b.Navigation("JobStepNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobStepModel", b =>
{
b.Navigation("TagNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Job.JobTaskModel", b =>
{
b.Navigation("JobStepNav");
b.Navigation("TagNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionGroupModel", b =>
{
b.Navigation("ItemsNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionItemModel", b =>
{
b.Navigation("Item2OdlNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Production.ProductionODLModel", b =>
{
b.Navigation("Item2OdlNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OfferModel", b =>
{
b.Navigation("OfferRowNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OrderModel", b =>
{
b.Navigation("OrderRowNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Sales.OrderRowModel", b =>
{
b.Navigation("ProdItemNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Utils.GenClassModel", b =>
{
b.Navigation("GenValNav");
});
modelBuilder.Entity("EgwCoreLib.Lux.Data.DbModel.Utils.TagsModel", b =>
{
b.Navigation("JobSteps");
b.Navigation("JobTasks");
});
#pragma warning restore 612, 618
}
}
}
Reference in New Issue View Git Blame Copy Permalink