// <auto-generated />
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Migrations;
using PartSource.Data.Contexts;
using System;

namespace PartSource.Data.Migrations
{
	[DbContext(typeof(PartSourceContext))]
    [Migration("20190811020941_ImportDateDcfMapping")]
    partial class ImportDateDcfMapping
    {
        protected override void BuildTargetModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            modelBuilder
                .HasAnnotation("ProductVersion", "2.2.2-servicing-10034")
                .HasAnnotation("Relational:MaxIdentifierLength", 128)
                .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

            modelBuilder.Entity("PartSource.Data.Models.ApiClient", b =>
                {
                    b.Property<string>("Key")
                        .ValueGeneratedOnAdd();

                    b.Property<bool>("Active");

                    b.Property<string>("AppName");

                    b.Property<string>("Secret");

                    b.HasKey("Key");

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

            modelBuilder.Entity("PartSource.Data.Models.BaseVehicle", b =>
                {
                    b.Property<int>("Id");

                    b.Property<int>("VehicleMakeId");

                    b.Property<int>("VehicleModelId");

                    b.Property<int>("Year");

                    b.HasKey("Id");

                    b.ToTable("BaseVehicle","Vehicle");
                });

            modelBuilder.Entity("PartSource.Data.Models.DcfMapping", b =>
                {
                    b.Property<string>("LineCode");

                    b.Property<string>("WhiCode");

                    b.HasKey("LineCode", "WhiCode");

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

            modelBuilder.Entity("PartSource.Data.Models.Fitment", b =>
                {
                    b.Property<int>("FitmentId")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int?>("BaseVehicleId");

                    b.Property<int?>("EngineConfigId");

                    b.Property<string>("ManufacturerCode");

                    b.Property<string>("NoteText");

                    b.Property<string>("PartLabel");

                    b.Property<string>("PartNumber");

                    b.Property<string>("Position");

                    b.HasKey("FitmentId");

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

            modelBuilder.Entity("PartSource.Data.Models.ImportData", b =>
                {
                    b.Property<string>("VariantSku")
                        .ValueGeneratedOnAdd();

                    b.Property<string>("BodyHtml");

                    b.Property<decimal>("CompareAt");

                    b.Property<string>("ImageAltText");

                    b.Property<string>("ImageSrc");

                    b.Property<bool?>("IsFitment");

                    b.Property<bool?>("IsVariant");

                    b.Property<string>("LineCode");

                    b.Property<string>("PartNumber");

                    b.Property<decimal>("Price");

                    b.Property<long?>("ShopifyId");

                    b.Property<string>("Title");

                    b.Property<string>("VariantTitle");

                    b.Property<string>("Vendor");

                    b.HasKey("VariantSku");

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

            modelBuilder.Entity("PartSource.Data.Models.ImportMetric", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int?>("ChangedItems");

                    b.Property<DateTime>("ImportDate");

                    b.Property<int?>("TotalItems");

                    b.HasKey("Id");

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

            modelBuilder.Entity("PartSource.Data.Models.Manufacturer", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("LineCode");

                    b.Property<string>("Name");

                    b.HasKey("Id");

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

            modelBuilder.Entity("PartSource.Data.Models.Part", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Description");

                    b.Property<int>("ManufacturerId");

                    b.Property<string>("Name");

                    b.Property<string>("PartNumber");

                    b.Property<long?>("ShopifyId");

                    b.Property<int>("Sku");

                    b.HasKey("Id");

                    b.HasIndex("ManufacturerId");

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

            modelBuilder.Entity("PartSource.Data.Models.PartData", b =>
                {
                    b.Property<string>("SKU")
                        .ValueGeneratedOnAdd()
                        .HasMaxLength(255);

                    b.Property<string>("BRAND_NM")
                        .HasMaxLength(255);

                    b.Property<string>("CATEGORY_NM")
                        .HasMaxLength(255);

                    b.Property<string>("CORPORATE_STATUS_NM")
                        .HasMaxLength(255);

                    b.Property<decimal?>("Compare_Price")
                        .HasColumnName("Compare Price")
                        .HasColumnType("money");

                    b.Property<string>("FAMILY_FEATURES_BENEFITS1")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS10")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS11")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS12")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS13")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS14")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS2")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS3")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS4")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS5")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS6")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS7")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS8")
                        .HasMaxLength(255);

                    b.Property<string>("FAMILY_FEATURES_BENEFITS9")
                        .HasMaxLength(255);

                    b.Property<string>("FINELINE_NM")
                        .HasMaxLength(255);

                    b.Property<byte?>("IsFitment");

                    b.Property<string>("LOB_NM")
                        .HasMaxLength(255);

                    b.Property<string>("Line_Code")
                        .HasColumnName("Line Code")
                        .HasMaxLength(255);

                    b.Property<string>("PRODUCT_ENGLISH_LONG_DESC")
                        .HasMaxLength(255);

                    b.Property<string>("Part_Number")
                        .HasColumnName("Part Number")
                        .HasMaxLength(255);

                    b.Property<byte?>("Published");

                    b.Property<string>("SUBCATEGORY_NM")
                        .HasMaxLength(255);

                    b.Property<string>("Tested")
                        .HasMaxLength(255);

                    b.Property<string>("Title");

                    b.Property<string>("VariantTitle");

                    b.Property<decimal?>("Your_Price")
                        .HasColumnName("Your Price")
                        .HasColumnType("money");

                    b.HasKey("SKU");

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

            modelBuilder.Entity("PartSource.Data.Models.PartImage", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Sku");

                    b.Property<string>("Url");

                    b.HasKey("Id");

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

            modelBuilder.Entity("PartSource.Data.Models.PartPrice", b =>
                {
                    b.Property<string>("SKU")
                        .ValueGeneratedOnAdd();

                    b.Property<string>("Active");

                    b.Property<decimal?>("Compare_Price");

                    b.Property<decimal?>("Your_Price");

                    b.HasKey("SKU");

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

            modelBuilder.Entity("PartSource.Data.Models.PartsAvailability", b =>
                {
                    b.Property<int>("Store");

                    b.Property<int>("SKU");

                    b.Property<string>("Line_Code")
                        .HasColumnName("Line Code")
                        .HasMaxLength(50);

                    b.Property<string>("Part_Number")
                        .HasColumnName("Part Number")
                        .HasMaxLength(50);

                    b.Property<int?>("QTY");

                    b.HasKey("Store", "SKU");

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

            modelBuilder.Entity("PartSource.Data.Models.Submodel", b =>
                {
                    b.Property<int>("VehicleToEngineConfigId");

                    b.Property<int>("BaseVehicleId");

                    b.Property<int>("EngineId");

                    b.Property<int>("SubmodelId");

                    b.HasKey("VehicleToEngineConfigId");

                    b.ToTable("Submodel","Vehicle");
                });

            modelBuilder.Entity("PartSource.Data.Models.VehicleEngine", b =>
                {
                    b.Property<int>("Id");

                    b.Property<string>("Description");

                    b.HasKey("Id");

                    b.ToTable("VehicleEngine","Vehicle");
                });

            modelBuilder.Entity("PartSource.Data.Models.VehicleMake", b =>
                {
                    b.Property<int>("Id");

                    b.Property<string>("Name");

                    b.HasKey("Id");

                    b.ToTable("VehicleMake","Vehicle");
                });

            modelBuilder.Entity("PartSource.Data.Models.VehicleModel", b =>
                {
                    b.Property<int>("Id");

                    b.Property<string>("Name");

                    b.Property<int>("VehicleMakeId");

                    b.HasKey("Id");

                    b.ToTable("VehicleModel","Vehicle");
                });

            modelBuilder.Entity("PartSource.Data.Models.DcfMapping", b =>
                {
                    b.HasOne("PartSource.Data.Models.ImportData")
                        .WithMany("DcfMapping")
                        .HasForeignKey("LineCode")
                        .OnDelete(DeleteBehavior.Cascade);
                });

            modelBuilder.Entity("PartSource.Data.Models.Part", b =>
                {
                    b.HasOne("PartSource.Data.Models.Manufacturer", "Manufacturer")
                        .WithMany()
                        .HasForeignKey("ManufacturerId")
                        .OnDelete(DeleteBehavior.Cascade);
                });
#pragma warning restore 612, 618
        }
    }
}