//
using System;
using GreenTree.Strohrmann.ERP.Domain.Model;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
namespace GreenTree.Strohrmann.ERP.Domain.Migrations
{
[DbContext(typeof(ERPDbContext))]
[Migration("20201109232837_CreationStatus")]
partial class CreationStatus
{
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("ProductVersion", "3.1.5")
.HasAnnotation("Relational:MaxIdentifierLength", 64);
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Craft", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("ChangedBy")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ChangedOn")
.HasColumnType("datetime(6)");
b.Property("Comment")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CreatedBy")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CreatedOn")
.HasColumnType("datetime(6)");
b.Property("CreationDate")
.HasColumnType("datetime(6)");
b.Property("CreationStatus")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CustomerId")
.HasColumnType("int");
b.Property("Name")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("Id");
b.HasIndex("CustomerId");
b.ToTable("Crafts");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.CraftEmployee", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("Amount")
.HasColumnType("float");
b.Property("Comment")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CraftId")
.HasColumnType("int");
b.Property("EmployeeId")
.HasColumnType("int");
b.Property("Value")
.HasColumnType("float");
b.HasKey("Id");
b.HasIndex("CraftId");
b.HasIndex("EmployeeId");
b.ToTable("CraftEmployees");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.CraftMaterial", b =>
{
b.Property("CraftId")
.HasColumnType("int");
b.Property("MaterialId")
.HasColumnType("int");
b.Property("Amount")
.HasColumnType("float");
b.Property("CalculationFactor")
.HasColumnType("float");
b.Property("Value")
.HasColumnType("float");
b.HasKey("CraftId", "MaterialId");
b.HasIndex("MaterialId");
b.ToTable("CraftMaterials");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Customer", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("Address")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ChangedBy")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ChangedOn")
.HasColumnType("datetime(6)");
b.Property("CompanyName")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Country")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CreatedBy")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CreatedOn")
.HasColumnType("datetime(6)");
b.Property("CreationStatus")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Firstname")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("IsBusiness")
.ValueGeneratedOnAdd()
.HasColumnType("tinyint(1)")
.HasDefaultValue(false);
b.Property("Lastname")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("TaxId")
.HasColumnType("int");
b.Property("TitleId")
.HasColumnType("int");
b.Property("Town")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ZipCode")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("Id");
b.HasIndex("TaxId");
b.HasIndex("TitleId");
b.ToTable("Customers");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Employee", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("Birthdate")
.HasColumnType("datetime(6)");
b.Property("ChangedBy")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ChangedOn")
.HasColumnType("datetime(6)");
b.Property("CreatedBy")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CreatedOn")
.HasColumnType("datetime(6)");
b.Property("CreationStatus")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("EmployeeDegreeId")
.HasColumnType("int");
b.Property("Firstname")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Lastname")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("MailAddress")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("Id");
b.HasIndex("EmployeeDegreeId");
b.ToTable("Employees");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.EmployeeDegree", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("Name")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Order")
.HasColumnType("int");
b.Property("Value")
.HasColumnType("float");
b.HasKey("Id");
b.ToTable("EmployeeDegrees");
b.HasData(
new
{
Id = 1,
Name = "Meister",
Order = 3,
Value = 60f
},
new
{
Id = 2,
Name = "Geselle",
Order = 2,
Value = 30f
},
new
{
Id = 3,
Name = "Aushilfe",
Order = 1,
Value = 15f
});
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Material", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("ChangedBy")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ChangedOn")
.HasColumnType("datetime(6)");
b.Property("CreatedBy")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CreatedOn")
.HasColumnType("datetime(6)");
b.Property("CreationStatus")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("DefaultUnitId")
.HasColumnType("int");
b.Property("Depth")
.HasColumnType("float");
b.Property("Description")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Height")
.HasColumnType("float");
b.Property("ItemNumber")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Name")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("NetValue")
.HasColumnType("float");
b.Property("PackageSize")
.ValueGeneratedOnAdd()
.HasColumnType("float")
.HasDefaultValue(1f);
b.Property("SupplierId")
.HasColumnType("int");
b.Property("Width")
.HasColumnType("float");
b.HasKey("Id");
b.HasIndex("DefaultUnitId");
b.HasIndex("SupplierId");
b.ToTable("Materials");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Supplier", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("Address")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ChangedBy")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ChangedOn")
.HasColumnType("datetime(6)");
b.Property("Comment")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Country")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CreatedBy")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("CreatedOn")
.HasColumnType("datetime(6)");
b.Property("CreationStatus")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Description")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("MailFirst")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("MailSecond")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Name")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("PhoneFirst")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("PhoneSecond")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Town")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ZipCode")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("Id");
b.ToTable("Suppliers");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Tax", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("Name")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ShortName")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Value")
.HasColumnType("float");
b.HasKey("Id");
b.ToTable("Taxes");
b.HasData(
new
{
Id = 1,
Name = "Deutschland Umsatzsteuer",
ShortName = "Umst. (19%)",
Value = 0.19f
},
new
{
Id = 2,
Name = "Deutschland Umsatzsteuer 2020",
ShortName = "Umst. (16%) 2020",
Value = 0.16f
});
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Title", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("Name")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("Id");
b.ToTable("Titles");
b.HasData(
new
{
Id = 1,
Name = "Keiner"
},
new
{
Id = 2,
Name = "Herr"
},
new
{
Id = 3,
Name = "Frau"
},
new
{
Id = 4,
Name = "Firma"
},
new
{
Id = 5,
Name = "Familie"
},
new
{
Id = 6,
Name = "Eheleute"
},
new
{
Id = 7,
Name = "Herr und Frau"
},
new
{
Id = 8,
Name = "Prof."
},
new
{
Id = 9,
Name = "Dr."
},
new
{
Id = 10,
Name = "Dr. med."
},
new
{
Id = 11,
Name = "Prof. Dr."
},
new
{
Id = 12,
Name = "Prof. Dr. med."
});
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Unit", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("Description")
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Name")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("ShortName")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("Id");
b.ToTable("Units");
b.HasData(
new
{
Id = 8,
Description = "Angabe in Einheit Milimeter",
Name = "Milimeter",
ShortName = "mm"
},
new
{
Id = 1,
Description = "Angabe in Einheit Meter",
Name = "Meter",
ShortName = "m"
},
new
{
Id = 2,
Description = "Angabe in Einheit Quadratmeter",
Name = "Quadratmeter",
ShortName = "m²"
},
new
{
Id = 3,
Description = "Angabe in Einheit Kubikmeter",
Name = "Kubikmeter",
ShortName = "m³"
},
new
{
Id = 4,
Description = "Angabe in Einheit Liter",
Name = "Liter",
ShortName = "l"
},
new
{
Id = 5,
Description = "Angabe in Stückzahl",
Name = "Stück",
ShortName = "Stck."
},
new
{
Id = 6,
Description = "Angabe in Stückzahl",
Name = "Kilogramm",
ShortName = "Kg"
},
new
{
Id = 7,
Description = "Angabe in Zeitstunden",
Name = "Stunden",
ShortName = "Std."
});
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Rights.Policy", b =>
{
b.Property("Name")
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.HasKey("Name");
b.ToTable("Policies");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Rights.User", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int");
b.Property("Accountname")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Activated")
.IsRequired()
.ValueGeneratedOnAdd()
.HasColumnType("tinyint(1)")
.HasDefaultValue(true);
b.Property("Birthdate")
.HasColumnType("datetime(6)");
b.Property("Forename")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Lastname")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("MailAddress")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.Property("Password")
.IsRequired()
.HasColumnType("longtext CHARACTER SET utf8mb4");
b.HasKey("Id");
b.ToTable("Users");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Rights.UserPolicy", b =>
{
b.Property("UserId")
.HasColumnType("int");
b.Property("PolicyName")
.HasColumnType("varchar(255) CHARACTER SET utf8mb4");
b.HasKey("UserId", "PolicyName");
b.ToTable("UserPolicies");
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Craft", b =>
{
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.Customer", "Customer")
.WithMany("Crafts")
.HasForeignKey("CustomerId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.CraftEmployee", b =>
{
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.Craft", "Craft")
.WithMany("CraftEmployees")
.HasForeignKey("CraftId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.Employee", "Employee")
.WithMany()
.HasForeignKey("EmployeeId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.CraftMaterial", b =>
{
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.Craft", "Craft")
.WithMany("CraftMaterials")
.HasForeignKey("CraftId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.Material", "Material")
.WithMany()
.HasForeignKey("MaterialId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Customer", b =>
{
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.Tax", "Tax")
.WithMany("Customers")
.HasForeignKey("TaxId")
.OnDelete(DeleteBehavior.Restrict);
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.Title", "Title")
.WithMany("Customers")
.HasForeignKey("TitleId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Employee", b =>
{
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.EmployeeDegree", "EmployeeDegree")
.WithMany("Employees")
.HasForeignKey("EmployeeDegreeId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Business.Material", b =>
{
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.Unit", "DefaultUnit")
.WithMany("Materials")
.HasForeignKey("DefaultUnitId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Business.Supplier", "Supplier")
.WithMany("Materials")
.HasForeignKey("SupplierId")
.OnDelete(DeleteBehavior.Restrict)
.IsRequired();
});
modelBuilder.Entity("GreenTree.Strohrmann.ERP.Core.Domain.Rights.UserPolicy", b =>
{
b.HasOne("GreenTree.Strohrmann.ERP.Core.Domain.Rights.User", "User")
.WithMany("Policies")
.HasForeignKey("UserId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
});
#pragma warning restore 612, 618
}
}
}