// <auto-generated />
using System;
using System.Collections.Generic;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Migrations;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
using vendorApproverBackend.Data;

#nullable disable

namespace vendorApproverBackend.Migrations
{
    [DbContext(typeof(DataContext))]
    [Migration("20250930103514_AddFinancialRole")]
    partial class AddFinancialRole
    {
        /// <inheritdoc />
        protected override void BuildTargetModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            modelBuilder
                .HasAnnotation("ProductVersion", "9.0.9")
                .HasAnnotation("Relational:MaxIdentifierLength", 63);

            NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);

            modelBuilder.Entity("FileModelPrequalificationRequest", b =>
                {
                    b.Property<long>("PrequalificationRequestId")
                        .HasColumnType("bigint");

                    b.Property<long>("TypeTestFilesId")
                        .HasColumnType("bigint");

                    b.HasKey("PrequalificationRequestId", "TypeTestFilesId");

                    b.HasIndex("TypeTestFilesId");

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

            modelBuilder.Entity("vendorApproverBackend.Entities.FileModel", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnName("id");

                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));

                    b.Property<string>("Description")
                        .HasColumnType("text")
                        .HasColumnName("description");

                    b.Property<string>("Name")
                        .HasColumnType("text")
                        .HasColumnName("file_name");

                    b.Property<int?>("Range")
                        .HasColumnType("integer")
                        .HasColumnName("range");

                    b.Property<bool>("Share")
                        .HasColumnType("boolean")
                        .HasColumnName("share");

                    b.Property<long?>("Size")
                        .HasColumnType("bigint")
                        .HasColumnName("file_size");

                    b.Property<DateTime>("Timestamp")
                        .HasColumnType("timestamp with time zone")
                        .HasColumnName("timestmp");

                    b.Property<string>("Type")
                        .HasColumnType("text")
                        .HasColumnName("file_type");

                    b.Property<string>("Url")
                        .IsRequired()
                        .HasColumnType("text")
                        .HasColumnName("file_url");

                    b.HasKey("Id");

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

            modelBuilder.Entity("vendorApproverBackend.Entities.PrequalificationRequest", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnName("id");

                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));

                    b.Property<DateTime?>("AfterSalesDate")
                        .HasColumnType("timestamp with time zone");

                    b.Property<long?>("AfterSalesEvaluationReportId")
                        .HasColumnType("bigint");

                    b.Property<string>("AfterSalesProductName")
                        .HasColumnType("text");

                    b.Property<long?>("AuthorizedPersonnelFileId")
                        .HasColumnType("bigint");

                    b.Property<long?>("ClientIssuesTrackingSystemId")
                        .HasColumnType("bigint");

                    b.Property<long?>("ComplianceConfirmationId")
                        .HasColumnType("bigint");

                    b.Property<string>("CountryOfOrigin")
                        .HasColumnType("text");

                    b.Property<DateTime?>("DateEstablished")
                        .HasColumnType("timestamp with time zone");

                    b.Property<long?>("FinancialReport2022Id")
                        .HasColumnType("bigint");

                    b.Property<long?>("FinancialReport2023Id")
                        .HasColumnType("bigint");

                    b.Property<long?>("FinancialReport2024Id")
                        .HasColumnType("bigint");

                    b.Property<long?>("GeneralArrangementDrawingId")
                        .HasColumnType("bigint");

                    b.Property<string>("GpsLocationCoordinates")
                        .HasColumnType("text");

                    b.Property<long?>("GtpTechnicalDataSheetId")
                        .HasColumnType("bigint");

                    b.Property<long?>("GtpUploadId")
                        .HasColumnType("bigint");

                    b.Property<bool>("IsForeignCompanyBranchInOman")
                        .HasColumnType("boolean");

                    b.Property<bool>("ManufacturerHasLocalSupport")
                        .HasColumnType("boolean");

                    b.Property<int>("OfficesAvailableIn")
                        .HasColumnType("integer");

                    b.Property<long?>("OfficialAgencyAgreementId")
                        .HasColumnType("bigint");

                    b.Property<long?>("OrgChartCorporateId")
                        .HasColumnType("bigint");

                    b.Property<long?>("OrgChartFactorySupportId")
                        .HasColumnType("bigint");

                    b.Property<long?>("OrgChartLocalSupportId")
                        .HasColumnType("bigint");

                    b.Property<long?>("OrgChartManufacturerId")
                        .HasColumnType("bigint");

                    b.Property<long?>("PendingCertificationFileId")
                        .HasColumnType("bigint");

                    b.Property<long?>("Product3DModelId")
                        .HasColumnType("bigint");

                    b.Property<string>("ShortName")
                        .HasColumnType("text");

                    b.Property<int>("Status")
                        .HasColumnType("integer")
                        .HasColumnName("status");

                    b.Property<DateTime>("SubmissionDate")
                        .HasColumnType("timestamp with time zone")
                        .HasColumnName("submission_date");

                    b.Property<int>("TestType")
                        .HasColumnType("integer");

                    b.Property<string>("TypeTestComments")
                        .HasColumnType("text");

                    b.Property<long?>("TypicalConnectionDrawingId")
                        .HasColumnType("bigint");

                    b.Property<string>("VendorFullName")
                        .HasColumnType("text");

                    b.Property<long>("VendorId")
                        .HasColumnType("bigint");

                    b.Property<long?>("WarrantyCertificateId")
                        .HasColumnType("bigint");

                    b.Property<string>("Website")
                        .HasColumnType("text");

                    b.HasKey("Id");

                    b.HasIndex("AfterSalesEvaluationReportId");

                    b.HasIndex("AuthorizedPersonnelFileId");

                    b.HasIndex("ClientIssuesTrackingSystemId");

                    b.HasIndex("ComplianceConfirmationId");

                    b.HasIndex("FinancialReport2022Id");

                    b.HasIndex("FinancialReport2023Id");

                    b.HasIndex("FinancialReport2024Id");

                    b.HasIndex("GeneralArrangementDrawingId");

                    b.HasIndex("GtpTechnicalDataSheetId");

                    b.HasIndex("GtpUploadId");

                    b.HasIndex("OfficialAgencyAgreementId");

                    b.HasIndex("OrgChartCorporateId");

                    b.HasIndex("OrgChartFactorySupportId");

                    b.HasIndex("OrgChartLocalSupportId");

                    b.HasIndex("OrgChartManufacturerId");

                    b.HasIndex("PendingCertificationFileId");

                    b.HasIndex("Product3DModelId");

                    b.HasIndex("TypicalConnectionDrawingId");

                    b.HasIndex("VendorId");

                    b.HasIndex("WarrantyCertificateId");

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

            modelBuilder.Entity("vendorApproverBackend.Entities.Product", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnName("id");

                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));

                    b.Property<int?>("Category")
                        .HasColumnType("integer")
                        .HasColumnName("category");

                    b.Property<string>("Code")
                        .HasColumnType("text")
                        .HasColumnName("code");

                    b.Property<double?>("Cost")
                        .HasColumnType("double precision")
                        .HasColumnName("cost");

                    b.Property<string>("Description")
                        .HasColumnType("text")
                        .HasColumnName("description");

                    b.Property<DateTime?>("ExpiryDate")
                        .HasColumnType("timestamp with time zone")
                        .HasColumnName("expiry_date");

                    b.Property<bool>("HasWarranty")
                        .HasColumnType("boolean")
                        .HasColumnName("has_warranty");

                    b.Property<long?>("ImageId")
                        .HasColumnType("bigint");

                    b.Property<bool>("IsFeaturedProduct")
                        .HasColumnType("boolean")
                        .HasColumnName("is_featured");

                    b.Property<string>("Name")
                        .IsRequired()
                        .HasColumnType("text")
                        .HasColumnName("name");

                    b.Property<double?>("Price")
                        .HasColumnType("double precision")
                        .HasColumnName("price");

                    b.Property<double?>("Quantity")
                        .HasColumnType("double precision")
                        .HasColumnName("quantity");

                    b.Property<int?>("Status")
                        .HasColumnType("integer")
                        .HasColumnName("status");

                    b.Property<double?>("Weight")
                        .HasColumnType("double precision")
                        .HasColumnName("weight");

                    b.HasKey("Id");

                    b.HasIndex("ImageId")
                        .IsUnique();

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

            modelBuilder.Entity("vendorApproverBackend.Entities.User", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnName("user_id");

                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));

                    b.Property<bool>("Active")
                        .HasColumnType("boolean")
                        .HasColumnName("active");

                    b.Property<int>("Category")
                        .HasColumnType("integer")
                        .HasColumnName("Category");

                    b.Property<string>("City")
                        .HasColumnType("text")
                        .HasColumnName("city");

                    b.Property<string>("Country")
                        .HasColumnType("text")
                        .HasColumnName("country");

                    b.Property<bool>("Deleted")
                        .HasColumnType("boolean")
                        .HasColumnName("deleted");

                    b.Property<string>("Email")
                        .IsRequired()
                        .HasColumnType("text")
                        .HasColumnName("email");

                    b.Property<string>("LastOtp")
                        .HasColumnType("text")
                        .HasColumnName("otp");

                    b.Property<string>("Name")
                        .IsRequired()
                        .HasColumnType("text")
                        .HasColumnName("name");

                    b.Property<string>("Password")
                        .IsRequired()
                        .HasColumnType("text")
                        .HasColumnName("password");

                    b.Property<string>("PhoneNumber")
                        .HasColumnType("text")
                        .HasColumnName("phone_number");

                    b.Property<int>("Role")
                        .HasColumnType("integer")
                        .HasColumnName("role");

                    b.Property<DateTime>("StartDate")
                        .HasColumnType("timestamp with time zone")
                        .HasColumnName("start_date");

                    b.Property<bool>("Status")
                        .HasColumnType("boolean")
                        .HasColumnName("Status");

                    b.Property<DateTime>("Timestamp")
                        .HasColumnType("timestamp with time zone")
                        .HasColumnName("timestmp");

                    b.Property<int>("Type")
                        .HasColumnType("integer")
                        .HasColumnName("type");

                    b.Property<string>("Username")
                        .IsRequired()
                        .HasColumnType("text")
                        .HasColumnName("user_name");

                    b.Property<long?>("user_device")
                        .HasColumnType("bigint");

                    b.Property<long?>("users_profile_media")
                        .HasColumnType("bigint");

                    b.HasKey("Id");

                    b.HasIndex("Email")
                        .IsUnique();

                    b.HasIndex("PhoneNumber")
                        .IsUnique();

                    b.HasIndex("Username")
                        .IsUnique();

                    b.HasIndex("user_device")
                        .IsUnique();

                    b.HasIndex("users_profile_media")
                        .IsUnique();

                    b.ToTable("users_table", (string)null);
                });

            modelBuilder.Entity("vendorApproverBackend.Entities.UserDevice", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnName("id");

                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));

                    b.Property<string>("DeviceId")
                        .HasColumnType("text")
                        .HasColumnName("device_Id");

                    b.Property<string>("DeviceType")
                        .HasColumnType("text")
                        .HasColumnName("deviceType");

                    b.Property<string>("Ip")
                        .HasColumnType("text")
                        .HasColumnName("ip");

                    b.Property<string>("LastJwt")
                        .HasColumnType("text")
                        .HasColumnName("token");

                    b.Property<string>("PushNotificationToken")
                        .HasColumnType("text")
                        .HasColumnName("tokendevice");

                    b.Property<DateTime>("Timestamp")
                        .HasColumnType("timestamp with time zone")
                        .HasColumnName("timestmp");

                    b.HasKey("Id");

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

            modelBuilder.Entity("vendorApproverBackend.Entities.Vendor", b =>
                {
                    b.Property<long>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("bigint")
                        .HasColumnName("id");

                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<long>("Id"));

                    b.Property<string>("CommercialRegistrationNo")
                        .HasColumnType("text")
                        .HasColumnName("Commercial_registratio_no");

                    b.Property<string>("LocalAgentName")
                        .HasColumnType("text")
                        .HasColumnName("Local_agent_name");

                    b.Property<string>("LocalAgentPhone")
                        .HasColumnType("text")
                        .HasColumnName("Local_agent_phone");

                    b.Property<string>("ManifactoryName")
                        .HasColumnType("text")
                        .HasColumnName("manifactory_name");

                    b.Property<string>("PartnerCompany")
                        .HasColumnType("text")
                        .HasColumnName("partner_company");

                    b.Property<string>("Position")
                        .HasColumnType("text")
                        .HasColumnName("position");

                    b.Property<string>("RepresentativeEmail")
                        .HasColumnType("text")
                        .HasColumnName("representative_email");

                    b.Property<string>("RepresentativeName")
                        .HasColumnType("text")
                        .HasColumnName("representative_name");

                    b.Property<DateTime>("Timestamp")
                        .HasColumnType("timestamp with time zone")
                        .HasColumnName("timestmp");

                    b.Property<long>("UserId")
                        .HasColumnType("bigint");

                    b.HasKey("Id");

                    b.HasIndex("UserId")
                        .IsUnique();

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

            modelBuilder.Entity("FileModelPrequalificationRequest", b =>
                {
                    b.HasOne("vendorApproverBackend.Entities.PrequalificationRequest", null)
                        .WithMany()
                        .HasForeignKey("PrequalificationRequestId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("vendorApproverBackend.Entities.FileModel", null)
                        .WithMany()
                        .HasForeignKey("TypeTestFilesId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();
                });

            modelBuilder.Entity("vendorApproverBackend.Entities.PrequalificationRequest", b =>
                {
                    b.HasOne("vendorApproverBackend.Entities.FileModel", "AfterSalesEvaluationReport")
                        .WithMany()
                        .HasForeignKey("AfterSalesEvaluationReportId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "AuthorizedPersonnelFile")
                        .WithMany()
                        .HasForeignKey("AuthorizedPersonnelFileId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "ClientIssuesTrackingSystem")
                        .WithMany()
                        .HasForeignKey("ClientIssuesTrackingSystemId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "ComplianceConfirmation")
                        .WithMany()
                        .HasForeignKey("ComplianceConfirmationId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "FinancialReport2022")
                        .WithMany()
                        .HasForeignKey("FinancialReport2022Id");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "FinancialReport2023")
                        .WithMany()
                        .HasForeignKey("FinancialReport2023Id");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "FinancialReport2024")
                        .WithMany()
                        .HasForeignKey("FinancialReport2024Id");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "GeneralArrangementDrawing")
                        .WithMany()
                        .HasForeignKey("GeneralArrangementDrawingId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "GtpTechnicalDataSheet")
                        .WithMany()
                        .HasForeignKey("GtpTechnicalDataSheetId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "GtpUpload")
                        .WithMany()
                        .HasForeignKey("GtpUploadId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "OfficialAgencyAgreement")
                        .WithMany()
                        .HasForeignKey("OfficialAgencyAgreementId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "OrgChartCorporate")
                        .WithMany()
                        .HasForeignKey("OrgChartCorporateId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "OrgChartFactorySupport")
                        .WithMany()
                        .HasForeignKey("OrgChartFactorySupportId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "OrgChartLocalSupport")
                        .WithMany()
                        .HasForeignKey("OrgChartLocalSupportId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "OrgChartManufacturer")
                        .WithMany()
                        .HasForeignKey("OrgChartManufacturerId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "PendingCertificationFile")
                        .WithMany()
                        .HasForeignKey("PendingCertificationFileId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "Product3DModel")
                        .WithMany()
                        .HasForeignKey("Product3DModelId");

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "TypicalConnectionDrawing")
                        .WithMany()
                        .HasForeignKey("TypicalConnectionDrawingId");

                    b.HasOne("vendorApproverBackend.Entities.Vendor", "Vendor")
                        .WithMany("PrequalificationRequests")
                        .HasForeignKey("VendorId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "WarrantyCertificate")
                        .WithMany()
                        .HasForeignKey("WarrantyCertificateId");

                    b.OwnsMany("vendorApproverBackend.Entities.AssociatedCompany", "AssociatedCompanies", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<int>("__synthesizedOrdinal")
                                .ValueGeneratedOnAdd()
                                .HasColumnType("integer");

                            b1.Property<string>("Address")
                                .HasColumnType("text");

                            b1.Property<string>("CompanyName")
                                .HasColumnType("text");

                            b1.Property<string>("TypeOfAssociation")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId", "__synthesizedOrdinal");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("AssociatedCompanies");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsMany("vendorApproverBackend.Entities.AuthorizedSignatory", "AuthorizedSignatories", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<int>("__synthesizedOrdinal")
                                .ValueGeneratedOnAdd()
                                .HasColumnType("integer");

                            b1.Property<string>("Designation")
                                .HasColumnType("text");

                            b1.Property<string>("Name")
                                .HasColumnType("text");

                            b1.Property<string>("SpecimenSignature")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId", "__synthesizedOrdinal");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("AuthorizedSignatories");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsMany("vendorApproverBackend.Entities.ClientReference", "ClientReferences", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<int>("__synthesizedOrdinal")
                                .ValueGeneratedOnAdd()
                                .HasColumnType("integer");

                            b1.Property<string>("ClientOwner")
                                .HasColumnType("text");

                            b1.Property<string>("Country")
                                .HasColumnType("text");

                            b1.Property<int>("DeliveryYear")
                                .HasColumnType("integer");

                            b1.Property<int>("OrderYear")
                                .HasColumnType("integer");

                            b1.Property<bool>("PerformanceCertificateAttached")
                                .HasColumnType("boolean");

                            b1.Property<string>("QuantityOfOrder")
                                .HasColumnType("text");

                            b1.Property<string>("TypeOfIndustry")
                                .HasColumnType("text");

                            b1.Property<int>("YearsInService")
                                .HasColumnType("integer");

                            b1.HasKey("PrequalificationRequestId", "__synthesizedOrdinal");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("ClientReferences");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsMany("vendorApproverBackend.Entities.ContactPerson", "ContactPersons", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<int>("__synthesizedOrdinal")
                                .ValueGeneratedOnAdd()
                                .HasColumnType("integer");

                            b1.Property<string>("Designation")
                                .HasColumnType("text");

                            b1.Property<string>("Email")
                                .HasColumnType("text");

                            b1.Property<string>("Name")
                                .HasColumnType("text");

                            b1.Property<string>("TelNo")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId", "__synthesizedOrdinal");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("ContactPersons");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.Declaration", "Declaration", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<DateTime>("Date")
                                .HasColumnType("timestamp with time zone");

                            b1.Property<string>("Designation")
                                .HasColumnType("text");

                            b1.Property<string>("FullName")
                                .HasColumnType("text");

                            b1.Property<string>("OnBehalfOf")
                                .HasColumnType("text");

                            b1.Property<long?>("PowerOfAttorneyId")
                                .HasColumnType("bigint");

                            b1.HasKey("PrequalificationRequestId");

                            b1.HasIndex("PowerOfAttorneyId");

                            b1.ToTable("PrequalificationRequests");

                            b1.HasOne("vendorApproverBackend.Entities.FileModel", "PowerOfAttorney")
                                .WithMany()
                                .HasForeignKey("PowerOfAttorneyId");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.Navigation("PowerOfAttorney");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.FactoryInfrastructure", "FactoryInfrastructure", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<string>("DepartmentBuildings")
                                .HasColumnType("text");

                            b1.Property<string>("ProductionCapacity")
                                .HasColumnType("text");

                            b1.Property<string>("TotalBuiltUpArea")
                                .HasColumnType("text");

                            b1.Property<string>("TotalFactoryArea")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.FinancialStanding", "FinancialStanding", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<string>("AuditorAddress")
                                .HasColumnType("text");

                            b1.Property<string>("AuditorName")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("FinancialStanding");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.OwnsMany("vendorApproverBackend.Entities.BankFacility", "BankFacilities", b2 =>
                                {
                                    b2.Property<long>("FinancialStandingPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<int>("__synthesizedOrdinal")
                                        .ValueGeneratedOnAdd()
                                        .HasColumnType("integer");

                                    b2.Property<string>("Address")
                                        .HasColumnType("text");

                                    b2.Property<decimal>("Amount")
                                        .HasColumnType("numeric");

                                    b2.Property<string>("BankName")
                                        .HasColumnType("text");

                                    b2.Property<string>("Details")
                                        .HasColumnType("text");

                                    b2.HasKey("FinancialStandingPrequalificationRequestId", "__synthesizedOrdinal");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("FinancialStandingPrequalificationRequestId");
                                });

                            b1.OwnsOne("vendorApproverBackend.Entities.FinancialYearDetail", "Details2022", b2 =>
                                {
                                    b2.Property<long>("FinancialStandingPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<decimal>("CashFlowOperationRatio")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("CurrentRatio")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("DebtToEquityRatio")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("EbitdaMargin")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("NetProfitMargin")
                                        .HasColumnType("numeric");

                                    b2.HasKey("FinancialStandingPrequalificationRequestId");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("FinancialStandingPrequalificationRequestId");
                                });

                            b1.OwnsOne("vendorApproverBackend.Entities.FinancialYearDetail", "Details2023", b2 =>
                                {
                                    b2.Property<long>("FinancialStandingPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<decimal>("CashFlowOperationRatio")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("CurrentRatio")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("DebtToEquityRatio")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("EbitdaMargin")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("NetProfitMargin")
                                        .HasColumnType("numeric");

                                    b2.HasKey("FinancialStandingPrequalificationRequestId");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("FinancialStandingPrequalificationRequestId");
                                });

                            b1.OwnsOne("vendorApproverBackend.Entities.FinancialYearDetail", "Details2024", b2 =>
                                {
                                    b2.Property<long>("FinancialStandingPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<decimal>("CashFlowOperationRatio")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("CurrentRatio")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("DebtToEquityRatio")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("EbitdaMargin")
                                        .HasColumnType("numeric");

                                    b2.Property<decimal>("NetProfitMargin")
                                        .HasColumnType("numeric");

                                    b2.HasKey("FinancialStandingPrequalificationRequestId");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("FinancialStandingPrequalificationRequestId");
                                });

                            b1.Navigation("BankFacilities");

                            b1.Navigation("Details2022")
                                .IsRequired();

                            b1.Navigation("Details2023")
                                .IsRequired();

                            b1.Navigation("Details2024")
                                .IsRequired();
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.HumanResourcesDetails", "HumanResourcesDetails", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("HumanResourcesDetails");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.OwnsMany("vendorApproverBackend.Entities.QualifiedStaff", "QualifiedStaff", b2 =>
                                {
                                    b2.Property<long>("HumanResourcesDetailsPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<int>("__synthesizedOrdinal")
                                        .ValueGeneratedOnAdd()
                                        .HasColumnType("integer");

                                    b2.Property<int>("Number")
                                        .HasColumnType("integer");

                                    b2.Property<string>("Qualification")
                                        .HasColumnType("text");

                                    b2.HasKey("HumanResourcesDetailsPrequalificationRequestId", "__synthesizedOrdinal");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("HumanResourcesDetailsPrequalificationRequestId");
                                });

                            b1.OwnsMany("vendorApproverBackend.Entities.StaffCount", "StaffCounts", b2 =>
                                {
                                    b2.Property<long>("HumanResourcesDetailsPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<int>("__synthesizedOrdinal")
                                        .ValueGeneratedOnAdd()
                                        .HasColumnType("integer");

                                    b2.Property<int>("FactoryCount")
                                        .HasColumnType("integer");

                                    b2.Property<int>("OnSiteCount")
                                        .HasColumnType("integer");

                                    b2.Property<int>("OutsidersCount")
                                        .HasColumnType("integer");

                                    b2.Property<int>("OwnCount")
                                        .HasColumnType("integer");

                                    b2.Property<string>("StaffCategory")
                                        .HasColumnType("text");

                                    b2.HasKey("HumanResourcesDetailsPrequalificationRequestId", "__synthesizedOrdinal");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("HumanResourcesDetailsPrequalificationRequestId");
                                });

                            b1.Navigation("QualifiedStaff");

                            b1.Navigation("StaffCounts");
                        });

                    b.OwnsMany("vendorApproverBackend.Entities.LocalCompanyOwner", "LocalCompanyOwners", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<int>("__synthesizedOrdinal")
                                .ValueGeneratedOnAdd()
                                .HasColumnType("integer");

                            b1.Property<string>("OwnerName")
                                .HasColumnType("text");

                            b1.Property<double>("PercentageOfOwnership")
                                .HasColumnType("double precision");

                            b1.HasKey("PrequalificationRequestId", "__synthesizedOrdinal");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("LocalCompanyOwners");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.Address", "CorporateHeadquarters", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<string>("Email")
                                .HasColumnType("text");

                            b1.Property<string>("FaxNo")
                                .HasColumnType("text");

                            b1.Property<string>("POBox")
                                .HasColumnType("text");

                            b1.Property<string>("Street")
                                .HasColumnType("text");

                            b1.Property<string>("TelNo")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.Address", "FactoryAddress", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<string>("Email")
                                .HasColumnType("text");

                            b1.Property<string>("FaxNo")
                                .HasColumnType("text");

                            b1.Property<string>("POBox")
                                .HasColumnType("text");

                            b1.Property<string>("Street")
                                .HasColumnType("text");

                            b1.Property<string>("TelNo")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.IndustrialLicense", "IndustrialLicenseFromEconomicDept", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<DateTime?>("DateOfRegistration")
                                .HasColumnType("timestamp with time zone");

                            b1.Property<DateTime?>("ExpiryDate")
                                .HasColumnType("timestamp with time zone");

                            b1.Property<string>("IssuingAuthority")
                                .HasColumnType("text");

                            b1.Property<long?>("LicenseDocumentId")
                                .HasColumnType("bigint");

                            b1.Property<string>("RegistrationNo")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.HasIndex("LicenseDocumentId");

                            b1.ToTable("PrequalificationRequests");

                            b1.HasOne("vendorApproverBackend.Entities.FileModel", "LicenseDocument")
                                .WithMany()
                                .HasForeignKey("LicenseDocumentId");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.Navigation("LicenseDocument");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.Address", "NearestSalesOfficeToOman", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<string>("Email")
                                .HasColumnType("text");

                            b1.Property<string>("FaxNo")
                                .HasColumnType("text");

                            b1.Property<string>("POBox")
                                .HasColumnType("text");

                            b1.Property<string>("Street")
                                .HasColumnType("text");

                            b1.Property<string>("TelNo")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.Address", "OfficeInOman", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<string>("Email")
                                .HasColumnType("text");

                            b1.Property<string>("FaxNo")
                                .HasColumnType("text");

                            b1.Property<string>("POBox")
                                .HasColumnType("text");

                            b1.Property<string>("Street")
                                .HasColumnType("text");

                            b1.Property<string>("TelNo")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.IndustrialLicense", "OmanChamberMembership", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<DateTime?>("DateOfRegistration")
                                .HasColumnType("timestamp with time zone");

                            b1.Property<DateTime?>("ExpiryDate")
                                .HasColumnType("timestamp with time zone");

                            b1.Property<string>("IssuingAuthority")
                                .HasColumnType("text");

                            b1.Property<long?>("LicenseDocumentId")
                                .HasColumnType("bigint");

                            b1.Property<string>("RegistrationNo")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.HasIndex("LicenseDocumentId");

                            b1.ToTable("PrequalificationRequests");

                            b1.HasOne("vendorApproverBackend.Entities.FileModel", "LicenseDocument")
                                .WithMany()
                                .HasForeignKey("LicenseDocumentId");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.Navigation("LicenseDocument");
                        });

                    b.OwnsMany("vendorApproverBackend.Entities.IndustrialLicense", "OtherIndustrialLicenses", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<int>("Id")
                                .ValueGeneratedOnAdd()
                                .HasColumnType("integer");

                            NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b1.Property<int>("Id"));

                            b1.Property<DateTime?>("DateOfRegistration")
                                .HasColumnType("timestamp with time zone");

                            b1.Property<DateTime?>("ExpiryDate")
                                .HasColumnType("timestamp with time zone");

                            b1.Property<string>("IssuingAuthority")
                                .HasColumnType("text");

                            b1.Property<long?>("LicenseDocumentId")
                                .HasColumnType("bigint");

                            b1.Property<string>("RegistrationNo")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId", "Id");

                            b1.HasIndex("LicenseDocumentId");

                            b1.ToTable("PrequalificationRequests_OtherIndustrialLicenses");

                            b1.HasOne("vendorApproverBackend.Entities.FileModel", "LicenseDocument")
                                .WithMany()
                                .HasForeignKey("LicenseDocumentId");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.Navigation("LicenseDocument");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.ProductAppliedFor", "ProductAppliedFor", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<string>("BriefDescription")
                                .HasColumnType("text");

                            b1.Property<int?>("EquipmentCategory")
                                .HasColumnType("integer");

                            b1.Property<string>("ManufacturerName")
                                .HasColumnType("text");

                            b1.Property<string>("ManufacturingCity")
                                .HasColumnType("text");

                            b1.Property<string>("ManufacturingCountry")
                                .HasColumnType("text");

                            b1.Property<string>("TypeModel")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.ProductionDetails", "ProductionDetails", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<string>("AuthorityAndResponsibility")
                                .HasColumnType("text");

                            b1.Property<string>("ProcessControl")
                                .HasColumnType("text");

                            b1.Property<long?>("SupportingDocumentId")
                                .HasColumnType("bigint");

                            b1.HasKey("PrequalificationRequestId");

                            b1.HasIndex("SupportingDocumentId");

                            b1.ToTable("PrequalificationRequests");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.HasOne("vendorApproverBackend.Entities.FileModel", "SupportingDocument")
                                .WithMany()
                                .HasForeignKey("SupportingDocumentId");

                            b1.Navigation("SupportingDocument");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.QualityHseRisk", "QualityHseRisk", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<bool>("AreInternalAuditsConducted")
                                .HasColumnType("boolean");

                            b1.Property<bool>("CanProvideTrainingFacilities")
                                .HasColumnType("boolean");

                            b1.Property<string>("EngineeringFabricationStandards")
                                .HasColumnType("text");

                            b1.Property<bool>("HasFormalQualitySystem")
                                .HasColumnType("boolean");

                            b1.Property<bool>("HasHseManual")
                                .HasColumnType("boolean");

                            b1.Property<bool>("HseSystemMeetIsoStandards")
                                .HasColumnType("boolean");

                            b1.Property<bool>("IsQaSystemApprovedByAgency")
                                .HasColumnType("boolean");

                            b1.Property<string>("PendingCertificationDetails")
                                .HasColumnType("text");

                            b1.Property<bool>("QaSystemMeetIsoRequirements")
                                .HasColumnType("boolean");

                            b1.Property<string>("RiskManagementSystem")
                                .HasColumnType("text");

                            b1.Property<bool>("SystemIncludesQaManual")
                                .HasColumnType("boolean");

                            b1.Property<bool>("SystemIncludesQaProcedures")
                                .HasColumnType("boolean");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("QualityHseRisk");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.OwnsMany("vendorApproverBackend.Entities.CertificationDetail", "Certifications", b2 =>
                                {
                                    b2.Property<long>("QualityHseRiskPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<int>("__synthesizedOrdinal")
                                        .ValueGeneratedOnAdd()
                                        .HasColumnType("integer");

                                    b2.Property<string>("CertifiedBody")
                                        .HasColumnType("text");

                                    b2.Property<string>("Scope")
                                        .HasColumnType("text");

                                    b2.Property<string>("Standard")
                                        .HasColumnType("text");

                                    b2.Property<string>("SystemName")
                                        .HasColumnType("text");

                                    b2.HasKey("QualityHseRiskPrequalificationRequestId", "__synthesizedOrdinal");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("QualityHseRiskPrequalificationRequestId");
                                });

                            b1.OwnsMany("vendorApproverBackend.Entities.QaAccreditationSummary", "QaAccreditationSummaries", b2 =>
                                {
                                    b2.Property<long>("QualityHseRiskPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<int>("__synthesizedOrdinal")
                                        .ValueGeneratedOnAdd()
                                        .HasColumnType("integer");

                                    b2.Property<string>("CompanyName")
                                        .HasColumnType("text");

                                    b2.Property<string>("IsoEquivalentStandards")
                                        .HasColumnType("text");

                                    b2.HasKey("QualityHseRiskPrequalificationRequestId", "__synthesizedOrdinal");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("QualityHseRiskPrequalificationRequestId");
                                });

                            b1.Navigation("Certifications");

                            b1.Navigation("QaAccreditationSummaries");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.QualitySystem", "QualitySystem", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.Property<string>("DesignChangeControl")
                                .HasColumnType("text");

                            b1.Property<string>("DesignProcess")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("QualitySystem");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.OwnsMany("vendorApproverBackend.Entities.EngineeringSoftware", "Software", b2 =>
                                {
                                    b2.Property<long>("QualitySystemPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<int>("__synthesizedOrdinal")
                                        .ValueGeneratedOnAdd()
                                        .HasColumnType("integer");

                                    b2.Property<string>("Program")
                                        .HasColumnType("text");

                                    b2.Property<string>("Version")
                                        .HasColumnType("text");

                                    b2.HasKey("QualitySystemPrequalificationRequestId", "__synthesizedOrdinal");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("QualitySystemPrequalificationRequestId");
                                });

                            b1.Navigation("Software");
                        });

                    b.OwnsOne("vendorApproverBackend.Entities.TechnicalCapabilities", "TechnicalCapabilities", b1 =>
                        {
                            b1.Property<long>("PrequalificationRequestId")
                                .HasColumnType("bigint");

                            b1.PrimitiveCollection<List<string>>("ApplicationSoftware")
                                .IsRequired()
                                .HasColumnType("text[]");

                            b1.Property<string>("CommunicationNetworkFacilities")
                                .HasColumnType("text");

                            b1.HasKey("PrequalificationRequestId");

                            b1.ToTable("PrequalificationRequests");

                            b1.ToJson("TechnicalCapabilities");

                            b1.WithOwner()
                                .HasForeignKey("PrequalificationRequestId");

                            b1.OwnsMany("vendorApproverBackend.Entities.CapabilityItem", "Items", b2 =>
                                {
                                    b2.Property<long>("TechnicalCapabilitiesPrequalificationRequestId")
                                        .HasColumnType("bigint");

                                    b2.Property<int>("__synthesizedOrdinal")
                                        .ValueGeneratedOnAdd()
                                        .HasColumnType("integer");

                                    b2.Property<string>("ItemName")
                                        .HasColumnType("text");

                                    b2.Property<int>("Number")
                                        .HasColumnType("integer");

                                    b2.HasKey("TechnicalCapabilitiesPrequalificationRequestId", "__synthesizedOrdinal");

                                    b2.ToTable("PrequalificationRequests");

                                    b2.WithOwner()
                                        .HasForeignKey("TechnicalCapabilitiesPrequalificationRequestId");
                                });

                            b1.Navigation("Items");
                        });

                    b.Navigation("AfterSalesEvaluationReport");

                    b.Navigation("AssociatedCompanies");

                    b.Navigation("AuthorizedPersonnelFile");

                    b.Navigation("AuthorizedSignatories");

                    b.Navigation("ClientIssuesTrackingSystem");

                    b.Navigation("ClientReferences");

                    b.Navigation("ComplianceConfirmation");

                    b.Navigation("ContactPersons");

                    b.Navigation("CorporateHeadquarters")
                        .IsRequired();

                    b.Navigation("Declaration")
                        .IsRequired();

                    b.Navigation("FactoryAddress")
                        .IsRequired();

                    b.Navigation("FactoryInfrastructure")
                        .IsRequired();

                    b.Navigation("FinancialReport2022");

                    b.Navigation("FinancialReport2023");

                    b.Navigation("FinancialReport2024");

                    b.Navigation("FinancialStanding")
                        .IsRequired();

                    b.Navigation("GeneralArrangementDrawing");

                    b.Navigation("GtpTechnicalDataSheet");

                    b.Navigation("GtpUpload");

                    b.Navigation("HumanResourcesDetails")
                        .IsRequired();

                    b.Navigation("IndustrialLicenseFromEconomicDept");

                    b.Navigation("LocalCompanyOwners");

                    b.Navigation("NearestSalesOfficeToOman")
                        .IsRequired();

                    b.Navigation("OfficeInOman")
                        .IsRequired();

                    b.Navigation("OfficialAgencyAgreement");

                    b.Navigation("OmanChamberMembership");

                    b.Navigation("OrgChartCorporate");

                    b.Navigation("OrgChartFactorySupport");

                    b.Navigation("OrgChartLocalSupport");

                    b.Navigation("OrgChartManufacturer");

                    b.Navigation("OtherIndustrialLicenses");

                    b.Navigation("PendingCertificationFile");

                    b.Navigation("Product3DModel");

                    b.Navigation("ProductAppliedFor")
                        .IsRequired();

                    b.Navigation("ProductionDetails")
                        .IsRequired();

                    b.Navigation("QualityHseRisk")
                        .IsRequired();

                    b.Navigation("QualitySystem")
                        .IsRequired();

                    b.Navigation("TechnicalCapabilities")
                        .IsRequired();

                    b.Navigation("TypicalConnectionDrawing");

                    b.Navigation("Vendor");

                    b.Navigation("WarrantyCertificate");
                });

            modelBuilder.Entity("vendorApproverBackend.Entities.Product", b =>
                {
                    b.HasOne("vendorApproverBackend.Entities.FileModel", "Image")
                        .WithOne()
                        .HasForeignKey("vendorApproverBackend.Entities.Product", "ImageId")
                        .OnDelete(DeleteBehavior.SetNull);

                    b.Navigation("Image");
                });

            modelBuilder.Entity("vendorApproverBackend.Entities.User", b =>
                {
                    b.HasOne("vendorApproverBackend.Entities.UserDevice", "Device")
                        .WithOne()
                        .HasForeignKey("vendorApproverBackend.Entities.User", "user_device")
                        .OnDelete(DeleteBehavior.Cascade);

                    b.HasOne("vendorApproverBackend.Entities.FileModel", "Image")
                        .WithOne()
                        .HasForeignKey("vendorApproverBackend.Entities.User", "users_profile_media")
                        .OnDelete(DeleteBehavior.Cascade);

                    b.Navigation("Device");

                    b.Navigation("Image");
                });

            modelBuilder.Entity("vendorApproverBackend.Entities.Vendor", b =>
                {
                    b.HasOne("vendorApproverBackend.Entities.User", "User")
                        .WithOne("Vendor")
                        .HasForeignKey("vendorApproverBackend.Entities.Vendor", "UserId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.Navigation("User");
                });

            modelBuilder.Entity("vendorApproverBackend.Entities.User", b =>
                {
                    b.Navigation("Vendor");
                });

            modelBuilder.Entity("vendorApproverBackend.Entities.Vendor", b =>
                {
                    b.Navigation("PrequalificationRequests");
                });
#pragma warning restore 612, 618
        }
    }
}