// 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; using vendorApproverBackend.Entities; #nullable disable namespace vendorApproverBackend.Migrations { [DbContext(typeof(DataContext))] [Migration("20260513135048_AddOtpCreatedAtToUser")] partial class AddOtpCreatedAtToUser { /// 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("ApplicationCategoryUser", b => { b.Property("CategoriesId") .HasColumnType("bigint"); b.Property("UserId") .HasColumnType("bigint"); b.HasKey("CategoriesId", "UserId"); b.HasIndex("UserId"); b.ToTable("UserApplicationCategories", (string)null); }); modelBuilder.Entity("AssessmentReport", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("CreatedById") .HasColumnType("bigint"); b.Property("Grade") .HasColumnType("text"); b.Property("PrequalificationRequestId") .HasColumnType("bigint"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("TotalMarks") .HasColumnType("double precision"); b.Property("passed") .HasColumnType("boolean"); b.HasKey("Id"); b.HasIndex("CreatedById"); b.HasIndex("PrequalificationRequestId") .IsUnique(); b.ToTable("AssessmentReports"); }); modelBuilder.Entity("DegreeUser", b => { b.Property("DegreesId") .HasColumnType("bigint"); b.Property("UserId") .HasColumnType("bigint"); b.HasKey("DegreesId", "UserId"); b.HasIndex("UserId"); b.ToTable("UserDegrees", (string)null); }); modelBuilder.Entity("EmployeeCertificationUser", b => { b.Property("CertificationsId") .HasColumnType("bigint"); b.Property("UserId") .HasColumnType("bigint"); b.HasKey("CertificationsId", "UserId"); b.HasIndex("UserId"); b.ToTable("UserCertifications", (string)null); }); modelBuilder.Entity("FileModelVendorResponse", b => { b.Property("DocumentsId") .HasColumnType("bigint"); b.Property("VendorResponseId") .HasColumnType("bigint"); b.HasKey("DocumentsId", "VendorResponseId"); b.HasIndex("VendorResponseId"); b.ToTable("vendor_response_files", (string)null); }); modelBuilder.Entity("PrequalificationRequestUser", b => { b.Property("InspectedPrequalificationRequestsId") .HasColumnType("bigint"); b.Property("InspectorsId") .HasColumnType("bigint"); b.HasKey("InspectedPrequalificationRequestsId", "InspectorsId"); b.HasIndex("InspectorsId"); b.ToTable("PqRequestInspector", (string)null); }); modelBuilder.Entity("UserWorkExperience", b => { b.Property("UserId") .HasColumnType("bigint"); b.Property("WorkExperiencesId") .HasColumnType("bigint"); b.HasKey("UserId", "WorkExperiencesId"); b.HasIndex("WorkExperiencesId"); b.ToTable("UserWorkExperiences", (string)null); }); modelBuilder.Entity("vendorApproverBackend.Entities.ApplicationCategory", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("EmployeeApplicationId") .HasColumnType("bigint"); b.Property("Name") .IsRequired() .HasMaxLength(255) .HasColumnType("character varying(255)"); b.Property("NameAr") .IsRequired() .HasMaxLength(255) .HasColumnType("character varying(255)"); b.Property("Timestamp") .HasColumnType("timestamp without time zone"); b.HasKey("Id"); b.HasIndex("EmployeeApplicationId"); b.ToTable("ApplicationCategories"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Category", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("ApplicationCategoryId") .HasColumnType("bigint"); b.Property("Label") .IsRequired() .HasMaxLength(255) .HasColumnType("character varying(255)"); b.Property("LabelAr") .IsRequired() .HasMaxLength(255) .HasColumnType("character varying(255)"); b.HasKey("Id"); b.HasIndex("ApplicationCategoryId"); b.ToTable("Categories"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Certification", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("CertificationNumber") .IsRequired() .HasColumnType("text") .HasColumnName("certification_number"); b.Property("CertificationType") .IsRequired() .HasColumnType("text") .HasColumnName("certification_type"); b.Property("ExpiryDate") .HasColumnType("timestamp without time zone") .HasColumnName("expiry_date"); b.Property("IssueDate") .HasColumnType("timestamp without time zone") .HasColumnName("issue_date"); b.Property("PrequalificationRequestId") .HasColumnType("bigint") .HasColumnName("prequalification_request_id"); b.Property("RequiresReinspection") .HasColumnType("boolean") .HasColumnName("requires_reinspection"); b.Property("Status") .HasColumnType("integer") .HasColumnName("status"); b.Property("SupplierId") .HasColumnType("bigint") .HasColumnName("supplier_id"); b.Property("SupplierName") .IsRequired() .HasColumnType("text") .HasColumnName("supplier_name"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("VerifiedById") .HasColumnType("bigint") .HasColumnName("verified_by_user_id"); b.HasKey("Id"); b.HasIndex("PrequalificationRequestId") .IsUnique(); b.HasIndex("VerifiedById"); b.ToTable("certifications"); }); modelBuilder.Entity("vendorApproverBackend.Entities.CertificationPack", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Description") .IsRequired() .HasColumnType("TEXT"); b.Property("Name") .IsRequired() .HasMaxLength(255) .HasColumnType("character varying(255)"); b.Property("Price") .HasColumnType("double precision") .HasColumnName("price"); b.Property("Timestamp") .HasColumnType("timestamp without time zone"); b.HasKey("Id"); b.ToTable("CertificationPacks"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Degree", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("FileId") .HasColumnType("bigint") .HasColumnName("file_id"); b.Property("Institution") .IsRequired() .HasMaxLength(255) .HasColumnType("character varying(255)"); b.Property("Year") .HasColumnType("integer") .HasColumnName("completion_year"); b.HasKey("Id"); b.ToTable("Degrees"); }); modelBuilder.Entity("vendorApproverBackend.Entities.EmployeeApplication", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Category") .HasColumnType("integer") .HasColumnName("Category"); b.PrimitiveCollection>("CertificationIds") .IsRequired() .HasColumnType("bigint[]") .HasColumnName("certification_ids"); b.Property("Experience") .HasColumnType("integer") .HasColumnName("experience"); b.Property("Qualifications") .HasColumnType("text") .HasColumnName("qualifications"); b.Property("Reason") .HasColumnType("text") .HasColumnName("reason"); b.Property("Status") .HasColumnType("integer") .HasColumnName("status"); b.Property("SubmissionDate") .HasColumnType("timestamp without time zone") .HasColumnName("submission_date"); b.Property("Type") .HasColumnType("integer") .HasColumnName("type"); b.Property("UserId") .HasColumnType("bigint") .HasColumnName("user_id"); b.HasKey("Id"); b.HasIndex("UserId"); b.ToTable("employee_applications"); }); modelBuilder.Entity("vendorApproverBackend.Entities.EmployeeCertification", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("FileId") .HasColumnType("bigint") .HasColumnName("file_id"); b.Property("Name") .IsRequired() .HasMaxLength(255) .HasColumnType("character varying(255)"); b.HasKey("Id"); b.ToTable("EmployeeCertifications"); }); modelBuilder.Entity("vendorApproverBackend.Entities.EvaluationData", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("EvaluatedBy") .IsRequired() .HasColumnType("text") .HasColumnName("evaluated_by"); b.Property("EvaluationDate") .IsRequired() .HasColumnType("text") .HasColumnName("evaluation_date"); b.Property("RequestRenewId") .HasColumnType("bigint") .HasColumnName("request_renew_id"); b.Property("Status") .HasColumnType("integer") .HasColumnName("status"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("TotalScore") .HasColumnType("double precision") .HasColumnName("total_score"); b.HasKey("Id"); b.ToTable("evaluation_data", (string)null); }); modelBuilder.Entity("vendorApproverBackend.Entities.FileModel", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Description") .HasColumnType("text") .HasColumnName("description"); b.Property("Name") .HasColumnType("text") .HasColumnName("file_name"); b.Property("Range") .HasColumnType("integer") .HasColumnName("range"); b.Property("Share") .HasColumnType("boolean") .HasColumnName("share"); b.Property("Size") .HasColumnType("bigint") .HasColumnName("file_size"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("Type") .HasColumnType("text") .HasColumnName("file_type"); b.Property("Url") .IsRequired() .HasColumnType("text") .HasColumnName("file_url"); b.HasKey("Id"); b.ToTable("File_model"); }); modelBuilder.Entity("vendorApproverBackend.Entities.LetterProducts", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("Id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("AdminComment") .HasColumnType("text") .HasColumnName("AdminComment"); b.Property("Category") .HasColumnType("text") .HasColumnName("Category"); b.Property("ManagerComment") .HasColumnType("text") .HasColumnName("ManagerComment"); b.Property("ProductCity") .HasColumnType("text") .HasColumnName("ProductCity"); b.Property("ProductCountry") .HasColumnType("text") .HasColumnName("ProductCountry"); b.Property("ProductDesc") .HasColumnType("text") .HasColumnName("ProductDesc"); b.Property("ProductName") .HasColumnType("text") .HasColumnName("ProductName"); b.Property("ProductType") .HasColumnType("text") .HasColumnName("ProductType"); b.Property("RejectionReason") .HasColumnType("text") .HasColumnName("RejectionReason"); b.Property("Status") .HasColumnType("integer") .HasColumnName("Status"); b.Property("Subcategory") .HasColumnType("text") .HasColumnName("Subcategory"); b.Property("VendorRequestLetterId") .HasColumnType("bigint") .HasColumnName("VendorRequestLetterId"); b.HasKey("Id"); b.HasIndex("VendorRequestLetterId"); b.ToTable("letter_products", (string)null); }); modelBuilder.Entity("vendorApproverBackend.Entities.NotificationModel", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("notificatoin_id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Action") .HasColumnType("integer") .HasColumnName("action"); b.Property("ActionId") .HasColumnType("bigint") .HasColumnName("action_id"); b.Property("Content") .IsRequired() .HasColumnType("text") .HasColumnName("content"); b.Property("LogUrl") .IsRequired() .HasColumnType("text") .HasColumnName("logUrl"); b.Property("ReciverId") .HasColumnType("bigint") .HasColumnName("ReciverId"); b.Property("SenderId") .HasColumnType("bigint") .HasColumnName("SenderId"); b.Property("Status") .HasColumnType("integer") .HasColumnName("status"); b.Property("Subject") .IsRequired() .HasColumnType("text") .HasColumnName("subject"); b.Property("Timestmp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.HasKey("Id"); b.HasIndex("ReciverId"); b.HasIndex("SenderId"); b.ToTable("notificationmodel"); }); modelBuilder.Entity("vendorApproverBackend.Entities.PaymentDetail", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Amount") .HasColumnType("double precision") .HasColumnName("amount"); b.Property("AttachementId") .HasColumnType("bigint") .HasColumnName("attachement_id"); b.Property("Description") .IsRequired() .HasColumnType("TEXT") .HasColumnName("description"); b.Property("PaymentDate") .HasColumnType("timestamp without time zone") .HasColumnName("payment_date"); b.Property("PaymentMethode") .HasColumnType("integer") .HasColumnName("payment_methode"); b.Property("Reference") .IsRequired() .HasColumnType("text") .HasColumnName("reference"); b.Property("Status") .HasColumnType("integer") .HasColumnName("status"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.HasKey("Id"); b.ToTable("PaymentDetail"); }); modelBuilder.Entity("vendorApproverBackend.Entities.PerformanceLetter", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("FileId") .HasColumnType("bigint") .HasColumnName("file_id"); b.Property("Order") .HasColumnType("integer") .HasColumnName("display_order"); b.Property("RequestRenewId") .HasColumnType("bigint") .HasColumnName("request_renew_id"); b.HasKey("Id"); b.HasIndex("FileId"); b.HasIndex("RequestRenewId"); b.ToTable("performance_letters"); }); modelBuilder.Entity("vendorApproverBackend.Entities.PqRequestClarification", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Comment") .HasColumnType("text") .HasColumnName("comment"); b.Property("DeadlineReply") .HasColumnType("timestamp without time zone") .HasColumnName("deadline_reply"); b.Property("PrequalificationRequestId") .HasColumnType("bigint") .HasColumnName("prequalification_request_id"); b.Property("Receiver") .HasColumnType("integer") .HasColumnName("receiver_role"); b.Property("Sender") .HasColumnType("integer") .HasColumnName("sender_role"); b.Property>("StepObservations") .HasColumnType("jsonb") .HasColumnName("step_observations"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestamp"); b.HasKey("Id"); b.HasIndex("PrequalificationRequestId"); b.ToTable("pq_request_clarifications", (string)null); }); modelBuilder.Entity("vendorApproverBackend.Entities.PrequalificationRequest", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("ApprovalDate") .HasColumnType("timestamp without time zone"); b.Property("AssignedToUserId") .HasColumnType("bigint") .HasColumnName("assigned_to_user_id"); b.Property("AssignmentDate") .HasColumnType("timestamp without time zone") .HasColumnName("assignment_date"); b.Property("FirstApprovalDate") .HasColumnType("timestamp without time zone"); b.Property("PaymentDetailId") .HasColumnType("bigint") .HasColumnName("payment_detail_id"); b.Property("Reason") .HasColumnType("text"); b.Property("Status") .HasColumnType("integer") .HasColumnName("status"); b.Property("SubmissionDate") .HasColumnType("timestamp without time zone") .HasColumnName("submission_date"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("VendorId") .HasColumnType("bigint"); b.Property("VisitRequestId") .HasColumnType("bigint"); b.Property("deadline") .HasColumnType("timestamp without time zone"); b.HasKey("Id"); b.HasIndex("AssignedToUserId"); b.HasIndex("PaymentDetailId") .IsUnique(); b.HasIndex("VendorId"); b.HasIndex("VisitRequestId") .IsUnique(); b.ToTable("PrequalificationRequests"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Product", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("ApprovalDate") .HasColumnType("timestamp without time zone") .HasColumnName("approvalDate"); b.Property("Category") .HasColumnType("text") .HasColumnName("category"); b.Property("ExpiryDate") .HasColumnType("timestamp without time zone") .HasColumnName("expiryDate"); b.Property("FirstApprovalDate") .HasColumnType("timestamp without time zone") .HasColumnName("firstapprovalDate"); b.Property("LocalAgent") .HasColumnType("text") .HasColumnName("local_agent"); b.Property("LocalAgentEmail") .HasColumnType("text") .HasColumnName("localAgentEmail"); b.Property("Manufacturer") .HasColumnType("text") .HasColumnName("manufacturer"); b.Property("ManufacturerEmail") .HasColumnType("text") .HasColumnName("manufacturerEmail"); b.Property("PrequalificationRequestId") .HasColumnType("bigint") .HasColumnName("prequalification_request_id"); b.Property("ProductCity") .HasColumnType("text") .HasColumnName("product_city"); b.Property("ProductCountry") .HasColumnType("text") .HasColumnName("product_country"); b.Property("ProductDesc") .HasColumnType("text") .HasColumnName("product_desc"); b.Property("ProductName") .HasColumnType("text") .HasColumnName("product_name"); b.Property("ProductType") .HasColumnType("text") .HasColumnName("product_type"); b.Property("Sku") .HasColumnType("text") .HasColumnName("sku"); b.Property("Status") .HasColumnType("integer") .HasColumnName("status"); b.Property("Subcategory") .HasColumnType("text") .HasColumnName("sub_category"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("VendorId") .HasColumnType("bigint") .HasColumnName("vendor_id"); b.Property("VendorName") .HasColumnType("text") .HasColumnName("vendor_name"); b.HasKey("Id"); b.HasIndex("PrequalificationRequestId") .IsUnique(); b.ToTable("products"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RenewalClarification", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Comments") .HasColumnType("text"); b.Property("RequestedBy") .HasColumnType("text"); b.Property("RequestedDate") .HasColumnType("timestamp without time zone"); b.PrimitiveCollection>("RequiredDocuments") .IsRequired() .HasColumnType("jsonb"); b.Property("VendorResponseId") .HasColumnType("bigint"); b.HasKey("Id"); b.HasIndex("VendorResponseId"); b.ToTable("renewal_clarifications"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RenewalFinalDecision", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Comments") .HasColumnType("text") .HasColumnName("comments"); b.Property("Decision") .HasColumnType("text") .HasColumnName("decision"); b.Property("ReviewDate") .HasColumnType("timestamp without time zone") .HasColumnName("review_date"); b.Property("SupportingDocumentId") .HasColumnType("bigint") .HasColumnName("supporting_document_id"); b.HasKey("Id"); b.HasIndex("SupportingDocumentId"); b.ToTable("renewal_final_decisions", (string)null); }); modelBuilder.Entity("vendorApproverBackend.Entities.RenewalPart2Evaluation", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("TotalScore") .HasColumnType("double precision") .HasColumnName("total_score"); b.HasKey("Id"); b.ToTable("renewal_part2_evaluations"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RenewalPart3Decision", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("DecidedBy") .HasColumnType("text") .HasColumnName("decided_by"); b.Property("Decision") .HasColumnType("text") .HasColumnName("decision"); b.Property("DecisionDate") .HasColumnType("timestamp without time zone") .HasColumnName("decision_date"); b.Property("Reason") .HasColumnType("text") .HasColumnName("reason"); b.Property("SupportingDocumentId") .HasColumnType("bigint") .HasColumnName("supporting_document_id"); b.HasKey("Id"); b.HasIndex("SupportingDocumentId"); b.ToTable("renewal_part3_decisions", (string)null); }); modelBuilder.Entity("vendorApproverBackend.Entities.RenewalPayment", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Amount") .HasColumnType("double precision") .HasColumnName("amount"); b.Property("Currency") .HasColumnType("text") .HasColumnName("currency"); b.Property("PaymentDate") .HasColumnType("timestamp without time zone") .HasColumnName("payment_date"); b.Property("Status") .IsRequired() .HasColumnType("text") .HasColumnName("status"); b.Property("TransactionId") .HasColumnType("text") .HasColumnName("transaction_id"); b.HasKey("Id"); b.ToTable("renewal_payments"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RequestRenew", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("ApprovedDesignFileId") .HasColumnType("bigint") .HasColumnName("approved_design_file_id"); b.Property("ApprovedDesignRemark") .HasColumnType("text"); b.Property("AssignDate") .HasColumnType("timestamp without time zone") .HasColumnName("assign_date"); b.Property("AssignedToId") .HasColumnType("bigint") .HasColumnName("assigned_to_id"); b.Property("CertificationId") .HasColumnType("bigint") .HasColumnName("certification_id"); b.Property("ChangeApprovalComment") .HasColumnType("text") .HasColumnName("change_approval_comment"); b.Property("ChangeRejectionComment") .HasColumnType("text") .HasColumnName("change_rejection_comment"); b.Property("ClarificationId") .HasColumnType("bigint"); b.Property("Comments") .IsRequired() .HasColumnType("text") .HasColumnName("comments"); b.Property("ExpiredProductCertificateFileId") .HasColumnType("bigint") .HasColumnName("expired_cert_file_id"); b.Property("ExpiredProductCertificateRemark") .HasColumnType("text"); b.Property("FinalDecisionId") .HasColumnType("bigint"); b.Property("InspectionRequired") .HasColumnType("boolean") .HasColumnName("inspection_required"); b.Property("IsExpiredOver2Years") .HasColumnType("boolean") .HasColumnName("is_expired_over_two_years"); b.Property("ManagerRenewComment") .HasColumnType("text"); b.Property("ManagerRenewFileId") .HasColumnType("bigint") .HasColumnName("manager_renew_file_id"); b.Property("OfficialLetterFileId") .HasColumnType("bigint") .HasColumnName("official_letter_file_id"); b.Property("OfficialLetterFileRemarkId") .HasColumnType("bigint") .HasColumnName("official_letter_file_remark_id"); b.Property("Part2EvaluationId") .HasColumnType("bigint"); b.Property("Part3DecisionId") .HasColumnType("bigint"); b.Property("PaymentId") .HasColumnType("bigint"); b.Property("ReferenceOrdersFileId") .HasColumnType("bigint") .HasColumnName("ref_orders_file_id"); b.Property("ReferenceOrdersRemark") .HasColumnType("text"); b.Property("RenewComment") .HasColumnType("text") .HasColumnName("renew_comment"); b.Property("RenewRequestFileId") .HasColumnType("bigint") .HasColumnName("renew_request_file_id"); b.Property("RenewalDate") .HasColumnType("timestamp without time zone") .HasColumnName("renewal_date"); b.Property("RenewalStep") .HasColumnType("integer") .HasColumnName("renewal_step"); b.Property("RequestNumber") .HasColumnType("integer") .HasColumnName("request_number"); b.Property("RequestType") .HasColumnType("integer") .HasColumnName("request_type"); b.Property("RequiresFactoryAudit") .HasColumnType("boolean") .HasColumnName("require_factory_audit"); b.Property("SignatureId") .HasColumnType("bigint") .HasColumnName("signature_id"); b.Property("Status") .HasColumnType("integer") .HasColumnName("status"); b.Property("TdcDocumentId") .HasColumnType("bigint") .HasColumnName("tdc_document_id"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("UpdateTDSFileId") .HasColumnType("bigint") .HasColumnName("update_tds_file_id"); b.Property("UpdateTDSRemark") .HasColumnType("text"); b.Property("UpdatedVendorDataId") .HasColumnType("bigint") .HasColumnName("updated_vendor_data_id"); b.Property("ValidAgencyAgreementFileId") .HasColumnType("bigint") .HasColumnName("valid_agency_agreement_id"); b.Property("ValidAgencyAgreementFileRemark") .HasColumnType("text") .HasColumnName("valid_agency_agreement_file_remark"); b.HasKey("Id"); b.HasIndex("ApprovedDesignFileId") .IsUnique(); b.HasIndex("AssignedToId"); b.HasIndex("CertificationId"); b.HasIndex("ClarificationId") .IsUnique(); b.HasIndex("ExpiredProductCertificateFileId") .IsUnique(); b.HasIndex("FinalDecisionId") .IsUnique(); b.HasIndex("ManagerRenewFileId") .IsUnique(); b.HasIndex("OfficialLetterFileId") .IsUnique(); b.HasIndex("OfficialLetterFileRemarkId") .IsUnique(); b.HasIndex("Part2EvaluationId") .IsUnique(); b.HasIndex("Part3DecisionId") .IsUnique(); b.HasIndex("PaymentId") .IsUnique(); b.HasIndex("ReferenceOrdersFileId") .IsUnique(); b.HasIndex("RenewRequestFileId") .IsUnique(); b.HasIndex("SignatureId") .IsUnique(); b.HasIndex("TdcDocumentId") .IsUnique(); b.HasIndex("UpdateTDSFileId") .IsUnique(); b.HasIndex("UpdatedVendorDataId") .IsUnique(); b.HasIndex("ValidAgencyAgreementFileId") .IsUnique(); b.ToTable("request_renews"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RequestRenewClarification", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Message") .IsRequired() .HasColumnType("TEXT") .HasColumnName("message"); b.Property("PrequalificationRequestId") .HasColumnType("bigint") .HasColumnName("prequalification_request_id"); b.Property("RequestRenewId") .HasColumnType("bigint") .HasColumnName("request_renew_id"); b.Property("SenderId") .HasColumnType("bigint") .HasColumnName("sender_id"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("VendorRequestLetterId") .HasColumnType("bigint") .HasColumnName("vendor_request_letter_id"); b.HasKey("Id"); b.HasIndex("PrequalificationRequestId"); b.HasIndex("RequestRenewId"); b.HasIndex("SenderId"); b.HasIndex("VendorRequestLetterId"); b.ToTable("request_renew_clarifications"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Signature", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Date") .HasColumnType("timestamp without time zone") .HasColumnName("date"); b.Property("Name") .IsRequired() .HasColumnType("text") .HasColumnName("name"); b.Property("SignatureData") .IsRequired() .HasColumnType("text") .HasColumnName("signature_data"); b.HasKey("Id"); b.ToTable("signatures"); }); modelBuilder.Entity("vendorApproverBackend.Entities.UpdatedVendorData", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("AgentContactPerson") .HasColumnType("text") .HasColumnName("agent_contact_person"); b.Property("ChangeReasonComment") .HasColumnType("text") .HasColumnName("change_reason_comment"); b.Property("OfficeLocation") .HasColumnType("text") .HasColumnName("office_location"); b.Property("OriginCountry") .HasColumnType("text") .HasColumnName("origin_country"); b.Property("ProductName") .HasColumnType("text") .HasColumnName("product_name"); b.Property("SupplierName") .HasColumnType("text") .HasColumnName("supplier_name"); b.HasKey("Id"); b.ToTable("updated_vendor_data"); }); modelBuilder.Entity("vendorApproverBackend.Entities.User", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("user_id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Active") .HasColumnType("boolean") .HasColumnName("active"); b.Property("City") .HasColumnType("text") .HasColumnName("city"); b.Property("Code") .HasColumnType("text") .HasColumnName("code"); b.Property("Country") .HasColumnType("text") .HasColumnName("country"); b.Property("Deleted") .HasColumnType("boolean") .HasColumnName("deleted"); b.Property("Departement") .HasColumnType("text") .HasColumnName("departement"); b.PrimitiveCollection>("DeviceIds") .IsRequired() .HasColumnType("text[]") .HasColumnName("device_ids"); b.Property("Email") .IsRequired() .HasColumnType("text") .HasColumnName("email"); b.Property("Gendre") .HasColumnType("integer") .HasColumnName("gender"); b.Property("InspectionPqId") .HasColumnType("bigint") .HasColumnName("inspection_pq_id"); b.Property("JobTitle") .HasColumnType("text") .HasColumnName("job_title"); b.Property("LastOtp") .HasColumnType("text") .HasColumnName("otp"); b.Property("Name") .IsRequired() .HasColumnType("text") .HasColumnName("name"); b.Property("OtpCreatedAt") .HasColumnType("timestamp without time zone") .HasColumnName("otp_created_at"); b.Property("PassOtp") .HasColumnType("text") .HasColumnName("pass_otp"); b.Property("Password") .IsRequired() .HasColumnType("text") .HasColumnName("password"); b.Property("PhoneNumber") .HasColumnType("text") .HasColumnName("phone_number"); b.Property("Position") .HasColumnType("text") .HasColumnName("position"); b.PrimitiveCollection>("RequestsEvaluationIds") .HasColumnType("bigint[]") .HasColumnName("requests_evaluation_ids"); b.Property("Role") .HasColumnType("integer") .HasColumnName("role"); b.Property("StartDate") .HasColumnType("timestamp without time zone") .HasColumnName("start_date"); b.Property("Status") .HasColumnType("boolean") .HasColumnName("Status"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("Type") .HasColumnType("integer") .HasColumnName("type"); b.Property("Username") .IsRequired() .HasColumnType("text") .HasColumnName("user_name"); b.Property("user_device") .HasColumnType("bigint"); b.Property("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("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("DeviceId") .HasColumnType("text") .HasColumnName("device_Id"); b.Property("DeviceType") .HasColumnType("text") .HasColumnName("deviceType"); b.Property("Ip") .HasColumnType("text") .HasColumnName("ip"); b.Property("LastJwt") .HasColumnType("text") .HasColumnName("token"); b.Property("PushNotificationToken") .HasColumnType("text") .HasColumnName("tokendevice"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.HasKey("Id"); b.ToTable("UserDevice"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Vendor", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("CommercialRegistrationNo") .HasColumnType("text") .HasColumnName("Commercial_registratio_no"); b.Property("LocalAgentName") .HasColumnType("text") .HasColumnName("Local_agent_name"); b.Property("LocalAgentPhone") .HasColumnType("text") .HasColumnName("Local_agent_phone"); b.Property("ManifactoryName") .HasColumnType("text") .HasColumnName("manifactory_name"); b.Property("PartnerCompany") .HasColumnType("text") .HasColumnName("partner_company"); b.Property("Position") .HasColumnType("text") .HasColumnName("position"); b.Property("RepresentativeEmail") .HasColumnType("text") .HasColumnName("representative_email"); b.Property("RepresentativeName") .HasColumnType("text") .HasColumnName("representative_name"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestmp"); b.Property("UserId") .HasColumnType("bigint"); b.HasKey("Id"); b.HasIndex("UserId") .IsUnique(); b.ToTable("Vendors"); }); modelBuilder.Entity("vendorApproverBackend.Entities.VendorRequestLetter", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("Id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("AgentContactPerson") .HasColumnType("text") .HasColumnName("AgentContactPerson"); b.Property("AgentDesignation") .HasColumnType("text") .HasColumnName("AgentDesignation"); b.Property("AgentEmail") .HasColumnType("text") .HasColumnName("AgentEmail"); b.Property("AgentFax") .HasColumnType("text") .HasColumnName("AgentFax"); b.Property("AgentNames") .HasColumnType("text") .HasColumnName("AgentNames"); b.Property("AgentTel") .HasColumnType("text") .HasColumnName("AgentTel"); b.Property("AgentWebsite") .HasColumnType("text") .HasColumnName("AgentWebsite"); b.Property("ApprovalDate") .HasColumnType("timestamp without time zone") .HasColumnName("ApprovalDate"); b.Property("AssignedToManager") .HasColumnType("boolean") .HasColumnName("AssignedToManager"); b.Property>("AssociatedCompanies") .IsRequired() .HasColumnType("jsonb") .HasColumnName("associated_companies"); b.Property("AuthorizedPersonsSubmitted") .HasColumnType("text") .HasColumnName("AuthorizedPersonsSubmitted"); b.Property>("AuthorizedSignatories") .IsRequired() .HasColumnType("jsonb") .HasColumnName("authorized_signatories"); b.Property>("BoardOfDirectors") .IsRequired() .HasColumnType("jsonb") .HasColumnName("board_of_directors"); b.Property("CertificatesAndLicenses") .HasColumnType("jsonb") .HasColumnName("certificates_and_licenses"); b.Property("CommercialRegNumber") .HasColumnType("text") .HasColumnName("CommercialRegNumber"); b.Property>("ContactPersons") .IsRequired() .HasColumnType("jsonb") .HasColumnName("contact_persons"); b.Property("CreatedPqRequestId") .HasColumnType("bigint") .HasColumnName("created_pq_request_id"); b.Property("DateEstablished") .HasColumnType("timestamp without time zone") .HasColumnName("DateEstablished"); b.Property("FactoryEmail") .HasColumnType("text") .HasColumnName("FactoryEmail"); b.Property("FactoryFax") .HasColumnType("text") .HasColumnName("FactoryFax"); b.Property("FactoryPoBox") .HasColumnType("text") .HasColumnName("FactoryPoBox"); b.Property("FactoryStreet") .HasColumnType("text") .HasColumnName("FactoryStreet"); b.Property("FactoryTel") .HasColumnType("text") .HasColumnName("FactoryTel"); b.Property("FullName") .HasColumnType("text") .HasColumnName("FullName"); b.Property("GccCountryName") .HasColumnType("text") .HasColumnName("GccCountryName"); b.Property("GpsCoordinates") .HasColumnType("text") .HasColumnName("GpsCoordinates"); b.Property("HqEmail") .HasColumnType("text") .HasColumnName("HqEmail"); b.Property("HqFax") .HasColumnType("text") .HasColumnName("HqFax"); b.Property("HqPoBox") .HasColumnType("text") .HasColumnName("HqPoBox"); b.Property("HqStreet") .HasColumnType("text") .HasColumnName("HqStreet"); b.Property("HqTel") .HasColumnType("text") .HasColumnName("HqTel"); b.Property("IsBranchInOman") .HasColumnType("boolean") .HasColumnName("IsBranchInOman"); b.Property>("LocalOwners") .IsRequired() .HasColumnType("jsonb") .HasColumnName("local_owners"); b.Property("OfficeLocation") .HasColumnType("text") .HasColumnName("OfficeLocation"); b.Property("OfficialAgencySubmitted") .HasColumnType("text") .HasColumnName("OfficialAgencySubmitted"); b.Property("OmanFax") .HasColumnType("text") .HasColumnName("OmanFax"); b.Property("OmanPoBox") .HasColumnType("text") .HasColumnName("OmanPoBox"); b.Property("OmanStreet") .HasColumnType("text") .HasColumnName("OmanStreet"); b.Property("OmanTel") .HasColumnType("text") .HasColumnName("OmanTel"); b.Property("OriginCountry") .HasColumnType("text") .HasColumnName("OriginCountry"); b.Property("OtherCountryName") .HasColumnType("text") .HasColumnName("OtherCountryName"); b.Property("RegisteredHeadOffice") .HasColumnType("text") .HasColumnName("RegisteredHeadOffice"); b.Property("RequestFileId") .HasColumnType("bigint"); b.Property("SalesEmail") .HasColumnType("text") .HasColumnName("SalesEmail"); b.Property("SalesFax") .HasColumnType("text") .HasColumnName("SalesFax"); b.Property("SalesPoBox") .HasColumnType("text") .HasColumnName("SalesPoBox"); b.Property("SalesStreet") .HasColumnType("text") .HasColumnName("SalesStreet"); b.Property("SalesTel") .HasColumnType("text") .HasColumnName("SalesTel"); b.Property("ShortName") .HasColumnType("text") .HasColumnName("ShortName"); b.Property("Status") .HasColumnType("integer") .HasColumnName("Status"); b.Property("SubmissionDate") .HasColumnType("timestamp without time zone") .HasColumnName("SubmissionDate"); b.Property("VendorGpsCoordinates") .HasColumnType("text") .HasColumnName("VendorGpsCoordinates"); b.Property("VendorId") .HasColumnType("bigint") .HasColumnName("VendorId"); b.Property("VendorWebsite") .HasColumnType("text") .HasColumnName("VendorWebsite"); b.HasKey("Id"); b.HasIndex("VendorId"); b.ToTable("vendor_request_letters", (string)null); }); modelBuilder.Entity("vendorApproverBackend.Entities.VendorResponse", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("Comments") .HasColumnType("text"); b.Property("ResponseDate") .HasColumnType("timestamp without time zone"); b.HasKey("Id"); b.ToTable("renewal_vendor_responses"); }); modelBuilder.Entity("vendorApproverBackend.Entities.VisitRequest", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint") .HasColumnName("id"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("ContactPerson") .HasColumnType("text") .HasColumnName("contact_person"); b.Property("ContactPhone") .HasColumnType("text") .HasColumnName("contact_phone"); b.Property("EndDate") .HasColumnType("timestamp without time zone") .HasColumnName("end_date"); b.Property("Location") .HasColumnType("text") .HasColumnName("location"); b.Property("Reason") .HasColumnType("text") .HasColumnName("reason"); b.Property("StartDate") .HasColumnType("timestamp without time zone") .HasColumnName("start_date"); b.Property("Status") .HasColumnType("integer") .HasColumnName("status"); b.Property("Timestamp") .HasColumnType("timestamp without time zone") .HasColumnName("timestamp"); b.Property("VisitPlanId") .HasColumnType("bigint") .HasColumnName("visit_plan_id"); b.Property("VisitPurpose") .HasColumnType("text") .HasColumnName("visit_purpose"); b.HasKey("Id"); b.ToTable("visit_requests"); }); modelBuilder.Entity("vendorApproverBackend.Entities.WorkExperience", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("bigint"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property("Id")); b.Property("CompanyName") .IsRequired() .HasMaxLength(255) .HasColumnType("character varying(255)") .HasColumnName("company_name"); b.Property("Description") .IsRequired() .HasColumnType("TEXT") .HasColumnName("description"); b.Property("FileId") .HasColumnType("bigint") .HasColumnName("file_id"); b.Property("JobTitle") .IsRequired() .HasMaxLength(255) .HasColumnType("character varying(255)") .HasColumnName("job_title"); b.Property("Years") .HasColumnType("integer"); b.HasKey("Id"); b.ToTable("WorkExperiences"); }); modelBuilder.Entity("ApplicationCategoryUser", b => { b.HasOne("vendorApproverBackend.Entities.ApplicationCategory", null) .WithMany() .HasForeignKey("CategoriesId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.User", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("AssessmentReport", b => { b.HasOne("vendorApproverBackend.Entities.User", "CreatedBy") .WithMany("CreatedAssessmentReports") .HasForeignKey("CreatedById") .OnDelete(DeleteBehavior.Restrict) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.PrequalificationRequest", "PrequalificationRequest") .WithOne("AssessmentReport") .HasForeignKey("AssessmentReport", "PrequalificationRequestId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.OwnsMany("QuestionsRate", "AuditVisit", b1 => { b1.Property("AssessmentReportId") .HasColumnType("bigint"); b1.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b1.Property("Description") .HasColumnType("text"); b1.Property("QuestionNumber") .HasColumnType("text"); b1.Property("Score") .HasColumnType("double precision"); b1.HasKey("AssessmentReportId", "__synthesizedOrdinal"); b1.ToTable("AssessmentReports"); b1.ToJson("AuditVisit"); b1.WithOwner() .HasForeignKey("AssessmentReportId"); }); b.OwnsMany("QuestionsRate", "DocumentationReview", b1 => { b1.Property("AssessmentReportId") .HasColumnType("bigint"); b1.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b1.Property("Description") .HasColumnType("text"); b1.Property("QuestionNumber") .HasColumnType("text"); b1.Property("Score") .HasColumnType("double precision"); b1.HasKey("AssessmentReportId", "__synthesizedOrdinal"); b1.ToTable("AssessmentReports"); b1.ToJson("DocumentationReview"); b1.WithOwner() .HasForeignKey("AssessmentReportId"); }); b.OwnsMany("QuestionsRate", "TechnicalFactoryAuditVisit", b1 => { b1.Property("AssessmentReportId") .HasColumnType("bigint"); b1.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b1.Property("Description") .HasColumnType("text"); b1.Property("QuestionNumber") .HasColumnType("text"); b1.Property("Score") .HasColumnType("double precision"); b1.HasKey("AssessmentReportId", "__synthesizedOrdinal"); b1.ToTable("AssessmentReports"); b1.ToJson("TechnicalFactoryAuditVisit"); b1.WithOwner() .HasForeignKey("AssessmentReportId"); }); b.OwnsOne("vendorApproverBackend.Entities.OutcomeFactoryAudit", "FactoryAuditOutcome", b1 => { b1.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("integer"); b1.Property("AssessmentReportId") .HasColumnType("bigint"); b1.Property("AuditDate") .HasColumnType("timestamp without time zone"); b1.Property("FirstAuditorName") .HasColumnType("text"); b1.Property("Grade") .HasColumnType("text"); b1.Property("Recommendation") .HasColumnType("integer"); b1.Property("SecondAuditorName") .HasColumnType("text"); b1.Property("Timestamp") .HasColumnType("timestamp without time zone"); b1.Property("TotalMarks") .HasColumnType("double precision"); b1.Property("passed") .HasColumnType("boolean"); b1.HasKey("Id"); b1.HasIndex("AssessmentReportId") .IsUnique(); b1.ToTable("AssessmentReports"); b1.ToJson("FactoryAuditOutcome"); b1.WithOwner() .HasForeignKey("AssessmentReportId"); }); b.Navigation("AuditVisit"); b.Navigation("CreatedBy"); b.Navigation("DocumentationReview"); b.Navigation("FactoryAuditOutcome"); b.Navigation("PrequalificationRequest"); b.Navigation("TechnicalFactoryAuditVisit"); }); modelBuilder.Entity("DegreeUser", b => { b.HasOne("vendorApproverBackend.Entities.Degree", null) .WithMany() .HasForeignKey("DegreesId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.User", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("EmployeeCertificationUser", b => { b.HasOne("vendorApproverBackend.Entities.EmployeeCertification", null) .WithMany() .HasForeignKey("CertificationsId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.User", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("FileModelVendorResponse", b => { b.HasOne("vendorApproverBackend.Entities.FileModel", null) .WithMany() .HasForeignKey("DocumentsId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.VendorResponse", null) .WithMany() .HasForeignKey("VendorResponseId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("PrequalificationRequestUser", b => { b.HasOne("vendorApproverBackend.Entities.PrequalificationRequest", null) .WithMany() .HasForeignKey("InspectedPrequalificationRequestsId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.User", null) .WithMany() .HasForeignKey("InspectorsId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("UserWorkExperience", b => { b.HasOne("vendorApproverBackend.Entities.User", null) .WithMany() .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.WorkExperience", null) .WithMany() .HasForeignKey("WorkExperiencesId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); }); modelBuilder.Entity("vendorApproverBackend.Entities.ApplicationCategory", b => { b.HasOne("vendorApproverBackend.Entities.EmployeeApplication", null) .WithMany("ApplicationCategories") .HasForeignKey("EmployeeApplicationId"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Category", b => { b.HasOne("vendorApproverBackend.Entities.ApplicationCategory", "ApplicationCategory") .WithMany("Categories") .HasForeignKey("ApplicationCategoryId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("ApplicationCategory"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Certification", b => { b.HasOne("vendorApproverBackend.Entities.PrequalificationRequest", "PrequalificationRequest") .WithOne("Certification") .HasForeignKey("vendorApproverBackend.Entities.Certification", "PrequalificationRequestId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.User", "VerifiedBy") .WithMany() .HasForeignKey("VerifiedById") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("PrequalificationRequest"); b.Navigation("VerifiedBy"); }); modelBuilder.Entity("vendorApproverBackend.Entities.EmployeeApplication", b => { b.HasOne("vendorApproverBackend.Entities.User", "User") .WithMany("EmployeeApplications") .HasForeignKey("UserId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("User"); }); modelBuilder.Entity("vendorApproverBackend.Entities.EvaluationData", b => { b.OwnsOne("vendorApproverBackend.Entities.EvaluationDetails", "Evaluation", b1 => { b1.Property("EvaluationDataId") .HasColumnType("bigint"); b1.HasKey("EvaluationDataId"); b1.ToTable("evaluation_data"); b1.ToJson("Evaluation"); b1.WithOwner() .HasForeignKey("EvaluationDataId"); b1.OwnsOne("vendorApproverBackend.Entities.CriteriaEvaluation", "CriteriaEvaluation", b2 => { b2.Property("EvaluationDetailsEvaluationDataId") .HasColumnType("bigint"); b2.HasKey("EvaluationDetailsEvaluationDataId"); b2.ToTable("evaluation_data"); b2.WithOwner() .HasForeignKey("EvaluationDetailsEvaluationDataId"); b2.OwnsOne("vendorApproverBackend.Entities.ScoreRemark", "AfterSaleService", b3 => { b3.Property("CriteriaEvaluationEvaluationDetailsEvaluationDataId") .HasColumnType("bigint"); b3.Property("Remark") .IsRequired() .HasColumnType("text"); b3.Property("Score") .HasColumnType("double precision"); b3.HasKey("CriteriaEvaluationEvaluationDetailsEvaluationDataId"); b3.ToTable("evaluation_data"); b3.WithOwner() .HasForeignKey("CriteriaEvaluationEvaluationDetailsEvaluationDataId"); }); b2.OwnsOne("vendorApproverBackend.Entities.ScoreRemark", "ComplianceWithStandards", b3 => { b3.Property("CriteriaEvaluationEvaluationDetailsEvaluationDataId") .HasColumnType("bigint"); b3.Property("Remark") .IsRequired() .HasColumnType("text"); b3.Property("Score") .HasColumnType("double precision"); b3.HasKey("CriteriaEvaluationEvaluationDetailsEvaluationDataId"); b3.ToTable("evaluation_data"); b3.WithOwner() .HasForeignKey("CriteriaEvaluationEvaluationDetailsEvaluationDataId"); }); b2.OwnsOne("vendorApproverBackend.Entities.ScoreRemark", "ProductPerformance", b3 => { b3.Property("CriteriaEvaluationEvaluationDetailsEvaluationDataId") .HasColumnType("bigint"); b3.Property("Remark") .IsRequired() .HasColumnType("text"); b3.Property("Score") .HasColumnType("double precision"); b3.HasKey("CriteriaEvaluationEvaluationDetailsEvaluationDataId"); b3.ToTable("evaluation_data"); b3.WithOwner() .HasForeignKey("CriteriaEvaluationEvaluationDetailsEvaluationDataId"); }); b2.Navigation("AfterSaleService") .IsRequired(); b2.Navigation("ComplianceWithStandards") .IsRequired(); b2.Navigation("ProductPerformance") .IsRequired(); }); b1.OwnsOne("vendorApproverBackend.Entities.FinalDecision", "FinalDecision", b2 => { b2.Property("EvaluationDetailsEvaluationDataId") .HasColumnType("bigint"); b2.Property("Decision") .IsRequired() .HasColumnType("text"); b2.Property("Reason") .IsRequired() .HasColumnType("text"); b2.Property("RepresentativeDate") .IsRequired() .HasColumnType("text"); b2.Property("RepresentativeName") .IsRequired() .HasColumnType("text"); b2.Property("RepresentativeSignature") .IsRequired() .HasColumnType("text"); b2.HasKey("EvaluationDetailsEvaluationDataId"); b2.ToTable("evaluation_data"); b2.WithOwner() .HasForeignKey("EvaluationDetailsEvaluationDataId"); }); b1.OwnsOne("vendorApproverBackend.Entities.ManufacturerDetails", "ManufacturerDetails", b2 => { b2.Property("EvaluationDetailsEvaluationDataId") .HasColumnType("bigint"); b2.Property("Date") .IsRequired() .HasColumnType("text"); b2.Property("Name") .IsRequired() .HasColumnType("text"); b2.Property("Signature") .IsRequired() .HasColumnType("text"); b2.HasKey("EvaluationDetailsEvaluationDataId"); b2.ToTable("evaluation_data"); b2.WithOwner() .HasForeignKey("EvaluationDetailsEvaluationDataId"); }); b1.OwnsOne("vendorApproverBackend.Entities.PolicyChecks", "PolicyChecks", b2 => { b2.Property("EvaluationDetailsEvaluationDataId") .HasColumnType("bigint"); b2.Property("CanProceedWithoutReferences") .HasColumnType("boolean"); b2.Property("HasReferenceOrders") .HasColumnType("boolean"); b2.Property("IsExpiredOver2Years") .HasColumnType("boolean"); b2.Property("IsThirdRenewal") .HasColumnType("boolean"); b2.Property("RequiresManufacturerEvaluation") .HasColumnType("boolean"); b2.HasKey("EvaluationDetailsEvaluationDataId"); b2.ToTable("evaluation_data"); b2.WithOwner() .HasForeignKey("EvaluationDetailsEvaluationDataId"); }); b1.Navigation("CriteriaEvaluation") .IsRequired(); b1.Navigation("FinalDecision") .IsRequired(); b1.Navigation("ManufacturerDetails") .IsRequired(); b1.Navigation("PolicyChecks") .IsRequired(); }); b.Navigation("Evaluation") .IsRequired(); }); modelBuilder.Entity("vendorApproverBackend.Entities.LetterProducts", b => { b.HasOne("vendorApproverBackend.Entities.VendorRequestLetter", "VendorRequestLetter") .WithMany("LetterProducts") .HasForeignKey("VendorRequestLetterId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("VendorRequestLetter"); }); modelBuilder.Entity("vendorApproverBackend.Entities.NotificationModel", b => { b.HasOne("vendorApproverBackend.Entities.User", "Reciver") .WithMany() .HasForeignKey("ReciverId"); b.HasOne("vendorApproverBackend.Entities.User", "Sender") .WithMany() .HasForeignKey("SenderId"); b.Navigation("Reciver"); b.Navigation("Sender"); }); modelBuilder.Entity("vendorApproverBackend.Entities.PerformanceLetter", b => { b.HasOne("vendorApproverBackend.Entities.FileModel", "File") .WithMany() .HasForeignKey("FileId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.RequestRenew", null) .WithMany("PerformanceLetters") .HasForeignKey("RequestRenewId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("File"); }); modelBuilder.Entity("vendorApproverBackend.Entities.PqRequestClarification", b => { b.HasOne("vendorApproverBackend.Entities.PrequalificationRequest", null) .WithMany("PqClarifications") .HasForeignKey("PrequalificationRequestId") .OnDelete(DeleteBehavior.Cascade); }); modelBuilder.Entity("vendorApproverBackend.Entities.PrequalificationRequest", b => { b.HasOne("vendorApproverBackend.Entities.User", "AssignedTo") .WithMany("AssignedPrequalificationRequests") .HasForeignKey("AssignedToUserId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("vendorApproverBackend.Entities.PaymentDetail", "PaymentDetail") .WithOne("PrequalificationRequest") .HasForeignKey("vendorApproverBackend.Entities.PrequalificationRequest", "PaymentDetailId") .OnDelete(DeleteBehavior.SetNull); b.HasOne("vendorApproverBackend.Entities.Vendor", "Vendor") .WithMany("PrequalificationRequests") .HasForeignKey("VendorId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.VisitRequest", "VisitRequest") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.PrequalificationRequest", "VisitRequestId"); b.OwnsMany("vendorApproverBackend.Entities.AdminObservation", "AdminObservations", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b1.Property("Description") .HasColumnType("text"); b1.Property("EnableUpdate") .HasColumnType("boolean"); b1.Property("StepNumber") .HasColumnType("integer"); b1.HasKey("PrequalificationRequestId", "__synthesizedOrdinal"); b1.ToTable("PrequalificationRequests"); b1.ToJson("AdminObservations"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); }); b.OwnsOne("vendorApproverBackend.Entities.Compliance", "Compliance", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.Property("ComplianceConfirmed") .HasColumnType("boolean"); b1.Property("ComplianceConfirmedFileId") .HasColumnType("bigint"); b1.Property("GtpFileId") .HasColumnType("bigint"); b1.Property("GtpSubmitted") .HasColumnType("boolean"); b1.Property("GtpSubmittedFileId") .HasColumnType("bigint"); b1.Property("StepEightApproverComment") .HasColumnType("text"); b1.HasKey("PrequalificationRequestId"); b1.ToTable("PrequalificationRequests"); b1.ToJson("Compliance"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); }); b.OwnsOne("vendorApproverBackend.Entities.Declaration", "Declaration", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.Property("Designation") .HasColumnType("text"); b1.Property("FullName") .HasColumnType("text"); b1.Property("OnBehalfOf") .HasColumnType("text"); b1.Property("PowerOfAttorneyFileId") .HasColumnType("bigint"); b1.Property("SignedDate") .HasColumnType("timestamp without time zone"); b1.Property("StepNineApproverComment") .HasColumnType("text"); b1.HasKey("PrequalificationRequestId"); b1.ToTable("PrequalificationRequests"); b1.ToJson("Declaration"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); }); b.OwnsOne("vendorApproverBackend.Entities.EquipmentGeneralArrangement", "EquipmentGeneralArrangement", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.Property("ConnectionDrawingFileId") .HasColumnType("bigint"); b1.Property("GaDrawingEnclosed") .HasColumnType("boolean"); b1.Property("GaFileId") .HasColumnType("bigint"); b1.Property("Product3DModel") .HasColumnType("boolean"); b1.Property("Product3DModelFileId") .HasColumnType("bigint"); b1.Property("StepSevenApproverComment") .HasColumnType("text"); b1.Property("TypicalConnectionDrawing") .HasColumnType("boolean"); b1.HasKey("PrequalificationRequestId"); b1.ToTable("PrequalificationRequests"); b1.ToJson("EquipmentGeneralArrangement"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); }); b.OwnsOne("vendorApproverBackend.Entities.ExperienceAndAfterSales", "ExperienceAndAfterSales", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.Property("AfterSalesReport") .HasColumnType("boolean"); b1.Property("ClientRefDate") .HasColumnType("timestamp without time zone"); b1.Property("IssueTrackingSystem") .HasColumnType("boolean"); b1.Property("ManufacturerProductInfo") .HasColumnType("text"); b1.Property("StepFourApproverComment") .HasColumnType("text"); b1.Property("WarrantyCertificateFileId") .HasColumnType("bigint") .HasColumnName("warranty_certificate_file_id"); b1.Property("WarrantyFileId") .HasColumnType("bigint"); b1.Property("afterSalesReportFileId") .HasColumnType("bigint"); b1.Property("issueTrackingSystemFileId") .HasColumnType("bigint"); b1.HasKey("PrequalificationRequestId"); b1.HasIndex("WarrantyCertificateFileId") .IsUnique(); b1.ToTable("PrequalificationRequests"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); b1.HasOne("vendorApproverBackend.Entities.FileModel", "WarrantyCertificateFile") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.PrequalificationRequest.ExperienceAndAfterSales#vendorApproverBackend.Entities.ExperienceAndAfterSales", "WarrantyCertificateFileId") .OnDelete(DeleteBehavior.Restrict); b1.OwnsMany("vendorApproverBackend.Entities.ClientReference", "ClientReferences", b2 => { b2.Property("ExperienceAndAfterSalesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("integer"); NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b2.Property("Id")); b2.Property("CertificateAttached") .HasColumnType("text"); b2.Property("CertificateFileId") .HasColumnType("bigint"); b2.Property("Client") .HasColumnType("text"); b2.Property("Country") .HasColumnType("text"); b2.Property("DeliveryYear") .HasColumnType("integer"); b2.Property("Industry") .HasColumnType("text"); b2.Property("OrderYear") .HasColumnType("integer"); b2.Property("Quantity") .HasColumnType("text"); b2.Property("YearsInService") .HasColumnType("integer"); b2.HasKey("ExperienceAndAfterSalesPrequalificationRequestId", "Id"); b2.ToTable("ClientReference"); b2.WithOwner() .HasForeignKey("ExperienceAndAfterSalesPrequalificationRequestId"); }); b1.Navigation("ClientReferences"); b1.Navigation("WarrantyCertificateFile"); }); b.OwnsOne("vendorApproverBackend.Entities.FinancialStanding", "FinancialStanding", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.PrimitiveCollection>("AuditReportsIds") .IsRequired() .HasColumnType("bigint[]"); b1.Property("AuditorAddress") .HasColumnType("text"); b1.Property("AuditorName") .HasColumnType("text"); b1.Property("CashFlowRatio_2022") .HasColumnType("text"); b1.Property("CashFlowRatio_2023") .HasColumnType("text"); b1.Property("CashFlowRatio_2024") .HasColumnType("text"); b1.Property("CurrentRatio_2022") .HasColumnType("text"); b1.Property("CurrentRatio_2023") .HasColumnType("text"); b1.Property("CurrentRatio_2024") .HasColumnType("text"); b1.Property("DebtEquityRatio_2022") .HasColumnType("text"); b1.Property("DebtEquityRatio_2023") .HasColumnType("text"); b1.Property("DebtEquityRatio_2024") .HasColumnType("text"); b1.Property("EBITDA_2022") .HasColumnType("text"); b1.Property("EBITDA_2023") .HasColumnType("text"); b1.Property("EBITDA_2024") .HasColumnType("text"); b1.Property("NetProfitMargin_2022") .HasColumnType("text"); b1.Property("NetProfitMargin_2023") .HasColumnType("text"); b1.Property("NetProfitMargin_2024") .HasColumnType("text"); b1.Property("StepThreeApproverComment") .HasColumnType("text"); b1.Property("VendorFullName") .HasColumnType("text"); b1.HasKey("PrequalificationRequestId"); b1.ToTable("PrequalificationRequests"); b1.ToJson("FinancialStanding"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); b1.OwnsMany("vendorApproverBackend.Entities.Banker", "Bankers", b2 => { b2.Property("FinancialStandingPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("BankAddress") .HasColumnType("text"); b2.Property("BankName") .HasColumnType("text"); b2.Property("CreditAmount") .HasColumnType("double precision"); b2.Property("CreditDetails") .HasColumnType("text"); b2.HasKey("FinancialStandingPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("FinancialStandingPrequalificationRequestId"); }); b1.Navigation("Bankers"); }); b.OwnsOne("vendorApproverBackend.Entities.GeneralInformation", "GeneralInformation", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.Property("AgentContactPerson") .HasColumnType("text"); b1.Property("AgentDesignation") .HasColumnType("text"); b1.Property("AgentEmail") .HasColumnType("text"); b1.Property("AgentFax") .HasColumnType("text"); b1.Property("AgentNames") .HasColumnType("text"); b1.Property("AgentTel") .HasColumnType("text"); b1.Property("AgentWebsite") .HasColumnType("text"); b1.Property("AuthorizedPersonsSubmitted") .HasColumnType("text"); b1.Property("Category") .HasColumnType("text"); b1.Property("CommercialRegNumber") .HasColumnType("text"); b1.Property("DateEstablished") .HasColumnType("timestamp without time zone"); b1.Property("FactoryEmail") .HasColumnType("text"); b1.Property("FactoryFax") .HasColumnType("text"); b1.Property("FactoryPoBox") .HasColumnType("text"); b1.Property("FactoryStreet") .HasColumnType("text"); b1.Property("FactoryTel") .HasColumnType("text"); b1.Property("FullName") .HasColumnType("text"); b1.Property("GccCountryName") .HasColumnType("text"); b1.Property("GpsCoordinates") .HasColumnType("text"); b1.Property("HqEmail") .HasColumnType("text"); b1.Property("HqFax") .HasColumnType("text"); b1.Property("HqPoBox") .HasColumnType("text"); b1.Property("HqStreet") .HasColumnType("text"); b1.Property("HqTel") .HasColumnType("text"); b1.Property("IsBranchInOman") .HasColumnType("boolean"); b1.Property("OfficeLocation") .HasColumnType("text"); b1.Property("OfficialAgencySubmitted") .HasColumnType("text"); b1.Property("OmanFax") .HasColumnType("text"); b1.Property("OmanPoBox") .HasColumnType("text"); b1.Property("OmanStreet") .HasColumnType("text"); b1.Property("OmanTel") .HasColumnType("text"); b1.Property("OriginCountry") .HasColumnType("text"); b1.Property("OtherCountryName") .HasColumnType("text"); b1.Property("ProductCity") .HasColumnType("text"); b1.Property("ProductCountry") .HasColumnType("text"); b1.Property("ProductDesc") .HasColumnType("text"); b1.Property("ProductName") .HasColumnType("text"); b1.Property("ProductType") .HasColumnType("text"); b1.Property("RegisteredHeadOffice") .HasColumnType("text"); b1.Property("SalesEmail") .HasColumnType("text"); b1.Property("SalesFax") .HasColumnType("text"); b1.Property("SalesPoBox") .HasColumnType("text"); b1.Property("SalesStreet") .HasColumnType("text"); b1.Property("SalesTel") .HasColumnType("text"); b1.Property("ShortName") .HasColumnType("text"); b1.Property("StepOneApproverComment") .HasColumnType("text"); b1.Property("Subcategory") .HasColumnType("text"); b1.Property("VendorGpsCoordinates") .HasColumnType("text"); b1.Property("VendorWebsite") .HasColumnType("text"); b1.HasKey("PrequalificationRequestId"); b1.ToTable("PrequalificationRequests"); b1.ToJson("GeneralInformation"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); b1.OwnsMany("vendorApproverBackend.Entities.AssociatedCompany", "AssociatedCompanies", b2 => { b2.Property("GeneralInformationPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Address") .HasColumnType("text"); b2.Property("AssociationType") .HasColumnType("text"); b2.Property("Name") .HasColumnType("text"); b2.Property("Notes") .HasColumnType("text"); b2.HasKey("GeneralInformationPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("GeneralInformationPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.AuthorizedSignatory", "AuthorizedSignatories", b2 => { b2.Property("GeneralInformationPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Designation") .HasColumnType("text"); b2.Property("Name") .HasColumnType("text"); b2.Property("SpecimenSignatureId") .HasColumnType("bigint"); b2.HasKey("GeneralInformationPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("GeneralInformationPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.BoardOfDirector", "BoardOfDirectors", b2 => { b2.Property("GeneralInformationPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Name") .HasColumnType("text"); b2.Property("Nationality") .HasColumnType("text"); b2.Property("Position") .HasColumnType("text"); b2.HasKey("GeneralInformationPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("GeneralInformationPrequalificationRequestId"); }); b1.OwnsOne("vendorApproverBackend.Entities.CertificatesAndLicenses", "CertificatesAndLicenses", b2 => { b2.Property("GeneralInformationPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("LocalSupportId") .HasColumnType("bigint"); b2.PrimitiveCollection>("SupportTeamCVsIds") .IsRequired() .HasColumnType("bigint[]"); b2.HasKey("GeneralInformationPrequalificationRequestId"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("GeneralInformationPrequalificationRequestId"); b2.OwnsOne("vendorApproverBackend.Entities.ChamberMembership", "ChamberMembership", b3 => { b3.Property("CertificatesAndLicensesGeneralInformationPrequalificationRequestId") .HasColumnType("bigint") .HasColumnName("CertificatesAndLicensesGeneralInformationPrequalificationReque~"); b3.Property("DocumentId") .HasColumnType("bigint"); b3.Property("ExpiryDate") .HasColumnType("timestamp without time zone"); b3.Property("RegistrationDate") .HasColumnType("timestamp without time zone"); b3.Property("RegistrationNo") .HasColumnType("text"); b3.HasKey("CertificatesAndLicensesGeneralInformationPrequalificationRequestId"); b3.ToTable("PrequalificationRequests"); b3.WithOwner() .HasForeignKey("CertificatesAndLicensesGeneralInformationPrequalificationRequestId"); }); b2.OwnsMany("vendorApproverBackend.Entities.IndustrialLicense", "IndustrialLicenses", b3 => { b3.Property("CertificatesAndLicensesGeneralInformationPrequalificationRequestId") .HasColumnType("bigint") .HasColumnName("CertificatesAndLicensesGeneralInformationPrequalificationReque~"); b3.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b3.Property("DocumentId") .HasColumnType("bigint"); b3.Property("ExpiryDate") .HasColumnType("timestamp without time zone"); b3.Property("IssuingAuthority") .HasColumnType("text"); b3.Property("RegistrationDate") .HasColumnType("timestamp without time zone"); b3.Property("RegistrationNo") .HasColumnType("text"); b3.HasKey("CertificatesAndLicensesGeneralInformationPrequalificationRequestId", "__synthesizedOrdinal"); b3.ToTable("PrequalificationRequests"); b3.WithOwner() .HasForeignKey("CertificatesAndLicensesGeneralInformationPrequalificationRequestId"); }); b2.OwnsOne("vendorApproverBackend.Entities.TradeLicense", "TradeLicense", b3 => { b3.Property("CertificatesAndLicensesGeneralInformationPrequalificationRequestId") .HasColumnType("bigint") .HasColumnName("CertificatesAndLicensesGeneralInformationPrequalificationReque~"); b3.Property("DocumentId") .HasColumnType("bigint"); b3.Property("ExpiryDate") .HasColumnType("timestamp without time zone"); b3.Property("RegistrationDate") .HasColumnType("timestamp without time zone"); b3.Property("RegistrationNo") .HasColumnType("text"); b3.HasKey("CertificatesAndLicensesGeneralInformationPrequalificationRequestId"); b3.ToTable("PrequalificationRequests"); b3.WithOwner() .HasForeignKey("CertificatesAndLicensesGeneralInformationPrequalificationRequestId"); }); b2.Navigation("ChamberMembership"); b2.Navigation("IndustrialLicenses"); b2.Navigation("TradeLicense"); }); b1.OwnsMany("vendorApproverBackend.Entities.ContactPerson", "ContactPersons", b2 => { b2.Property("GeneralInformationPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Designation") .HasColumnType("text"); b2.Property("Email") .HasColumnType("text"); b2.Property("Name") .HasColumnType("text"); b2.Property("Tel") .HasColumnType("text"); b2.HasKey("GeneralInformationPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("GeneralInformationPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.LocalOwner", "LocalOwners", b2 => { b2.Property("GeneralInformationPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Name") .HasColumnType("text"); b2.Property("Nationality") .HasColumnType("text"); b2.Property("OwnershipPercent") .HasColumnType("text"); b2.HasKey("GeneralInformationPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("GeneralInformationPrequalificationRequestId"); }); b1.Navigation("AssociatedCompanies"); b1.Navigation("AuthorizedSignatories"); b1.Navigation("BoardOfDirectors"); b1.Navigation("CertificatesAndLicenses"); b1.Navigation("ContactPersons"); b1.Navigation("LocalOwners"); }); b.OwnsOne("vendorApproverBackend.Entities.QualityHSERisk", "QualityHSERisk", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.Property("ApprovedAgencyNames") .HasColumnType("text"); b1.Property("CertInProcessDetails") .HasColumnType("text"); b1.Property("CertProcessLetterId") .HasColumnType("bigint"); b1.Property("EngineeringStandards") .HasColumnType("text"); b1.Property("HasAuditSchedule") .HasColumnType("boolean"); b1.Property("HasHSEManual") .HasColumnType("boolean"); b1.Property("HasQaManual") .HasColumnType("boolean"); b1.Property("HasQaProcedures") .HasColumnType("boolean"); b1.Property("HasQualitySystem") .HasColumnType("boolean"); b1.Property("HasTrainingFacility") .HasColumnType("boolean"); b1.Property("HseMeetsStandard") .HasColumnType("boolean"); b1.Property("QaSystemApprovedByAgency") .HasColumnType("boolean"); b1.Property("QaSystemDetails") .HasColumnType("text"); b1.Property("QaSystemMeetsStandard") .HasColumnType("boolean"); b1.Property("RiskManagement") .HasColumnType("text"); b1.Property("StepFiveApproverComment") .HasColumnType("text"); b1.Property("TrainingDescription") .HasColumnType("text"); b1.HasKey("PrequalificationRequestId"); b1.ToTable("PrequalificationRequests"); b1.ToJson("QualityHSERisk"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); b1.OwnsMany("vendorApproverBackend.Entities.Certificate", "Certificates", b2 => { b2.Property("QualityHSERiskPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("CertifiedBody") .HasColumnType("text"); b2.Property("Standard") .HasColumnType("text"); b2.HasKey("QualityHSERiskPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("QualityHSERiskPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.QaSummary", "QaSummary", b2 => { b2.Property("QualityHSERiskPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Company") .HasColumnType("text"); b2.Property("Standard") .HasColumnType("text"); b2.HasKey("QualityHSERiskPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("QualityHSERiskPrequalificationRequestId"); }); b1.Navigation("Certificates"); b1.Navigation("QaSummary"); }); b.OwnsOne("vendorApproverBackend.Entities.TypeTest", "TypeTest", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.Property("FactoryOwnLab") .HasColumnType("boolean"); b1.Property("FactoryOwnLabFileId") .HasColumnType("bigint"); b1.Property("FactoryTestApprovedProcedure") .HasColumnType("boolean"); b1.Property("FactoryTestApprovedProcedureFileId") .HasColumnType("bigint"); b1.Property("Lab17025Accredited") .HasColumnType("boolean"); b1.Property("Lab17025AccreditedFileId") .HasColumnType("bigint"); b1.Property("StepSixApproverComment") .HasColumnType("text"); b1.Property("TestType") .HasColumnType("text"); b1.Property("ThirdPartyCertificates") .HasColumnType("boolean"); b1.Property("ThirdPartyCertificatesFileId") .HasColumnType("bigint"); b1.Property("ThirdPartyReports") .HasColumnType("boolean"); b1.Property("ThirdPartyReportsFileId") .HasColumnType("bigint"); b1.HasKey("PrequalificationRequestId"); b1.ToTable("PrequalificationRequests"); b1.ToJson("TypeTest"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); }); b.OwnsOne("vendorApproverBackend.Entities.VendorResources", "VendorResources", b1 => { b1.Property("PrequalificationRequestId") .HasColumnType("bigint"); b1.Property("CommunicationFacilities") .HasColumnType("text"); b1.Property("DepartmentBuildings") .HasColumnType("text"); b1.Property("DesignChangeControl") .HasColumnType("text"); b1.Property("DesignProcess") .HasColumnType("text"); b1.Property("FailureStats") .HasColumnType("text"); b1.Property("IdentificationTraceability") .HasColumnType("text"); b1.Property("InventoryManagement") .HasColumnType("text"); b1.Property("MaintenanceOfEquipment") .HasColumnType("text"); b1.Property("NonConformityControl") .HasColumnType("text"); b1.Property("OrgChartCorporate") .HasColumnType("boolean"); b1.Property("OrgChartCorporateFileId") .HasColumnType("bigint"); b1.Property("OrgChartFactoryTechSupport") .HasColumnType("boolean"); b1.Property("OrgChartFactoryTechSupportFileId") .HasColumnType("bigint"); b1.Property("OrgChartFileId") .HasColumnType("bigint"); b1.Property("OrgChartLocalTechSupport") .HasColumnType("boolean"); b1.Property("OrgChartLocalTechSupportFileId") .HasColumnType("bigint"); b1.Property("OrgChartManufacturer") .HasColumnType("boolean"); b1.Property("OrgChartManufacturerFileId") .HasColumnType("bigint"); b1.Property("PackagingTransport") .HasColumnType("text"); b1.Property("PlanningMonitoring") .HasColumnType("text"); b1.Property("PlanningProcess") .HasColumnType("text"); b1.Property("ProductionAuthority") .HasColumnType("text"); b1.Property("ProductionCapacity") .HasColumnType("text"); b1.Property("ProductionPlanning") .HasColumnType("text"); b1.Property("ProductionProcessControl") .HasColumnType("text"); b1.Property("ProductionSupportFileId") .HasColumnType("bigint"); b1.Property("QcMethods") .HasColumnType("text"); b1.Property("QcPlanFileId") .HasColumnType("bigint"); b1.Property("QcPlans") .HasColumnType("text"); b1.Property("QcProcedures") .HasColumnType("text"); b1.Property("QcProceduresFileId") .HasColumnType("bigint"); b1.Property("QualityAuthority") .HasColumnType("text"); b1.Property("QualityControlPlanning") .HasColumnType("text"); b1.Property("QualityTraceability") .HasColumnType("text"); b1.Property("ReceiptMaterials") .HasColumnType("text"); b1.Property("StandardManagement") .HasColumnType("text"); b1.Property("StepTwoApproverComment") .HasColumnType("text"); b1.Property("SupplierApprovalProcess") .HasColumnType("text"); b1.Property("SupplierListFileId") .HasColumnType("bigint"); b1.Property("SupplierQCMeans") .HasColumnType("text"); b1.Property("SupplierReevaluation") .HasColumnType("text"); b1.Property("TechSupportChartFileId") .HasColumnType("bigint"); b1.Property("TotalBuiltUpArea") .HasColumnType("text"); b1.Property("TotalFactoryArea") .HasColumnType("text"); b1.Property("TransmissionToSuppliers") .HasColumnType("text"); b1.Property("WasteManagement") .HasColumnType("text"); b1.HasKey("PrequalificationRequestId"); b1.ToTable("PrequalificationRequests"); b1.ToJson("VendorResources"); b1.WithOwner() .HasForeignKey("PrequalificationRequestId"); b1.OwnsMany("vendorApproverBackend.Entities.Application", "Applications", b2 => { b2.Property("VendorResourcesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Name") .HasColumnType("text"); b2.HasKey("VendorResourcesPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("VendorResourcesPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.InternationalStandard", "InternationalStandards", b2 => { b2.Property("VendorResourcesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Scope") .HasColumnType("text"); b2.Property("Standard") .HasColumnType("text"); b2.Property("YesNo") .HasColumnType("text"); b2.HasKey("VendorResourcesPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("VendorResourcesPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.ProductionQualifiedStaff", "ProductionQualifiedStaff", b2 => { b2.Property("VendorResourcesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Number") .HasColumnType("integer"); b2.Property("Position") .HasColumnType("text"); b2.Property("Qualification") .HasColumnType("text"); b2.HasKey("VendorResourcesPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("VendorResourcesPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.QualifiedStaff", "QualifiedStaff", b2 => { b2.Property("VendorResourcesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Designation") .HasColumnType("text"); b2.Property("Number") .HasColumnType("integer"); b2.Property("Qualification") .HasColumnType("text"); b2.HasKey("VendorResourcesPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("VendorResourcesPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.QualityDocument", "QualityDocuments", b2 => { b2.Property("VendorResourcesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Date") .HasColumnType("timestamp without time zone"); b2.Property("Description") .HasColumnType("text"); b2.Property("Edition") .HasColumnType("text"); b2.Property("Title") .HasColumnType("text"); b2.HasKey("VendorResourcesPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("VendorResourcesPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.QualityQualifiedStaff", "QualityQualifiedStaff", b2 => { b2.Property("VendorResourcesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Number") .HasColumnType("integer"); b2.Property("Position") .HasColumnType("text"); b2.Property("Qualification") .HasColumnType("text"); b2.HasKey("VendorResourcesPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("VendorResourcesPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.SoftwareItem", "SoftwareList", b2 => { b2.Property("VendorResourcesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Program") .HasColumnType("text"); b2.Property("Version") .HasColumnType("text"); b2.HasKey("VendorResourcesPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("VendorResourcesPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.StaffDetail", "StaffDetails", b2 => { b2.Property("VendorResourcesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Factory") .HasColumnType("integer"); b2.Property("OnSite") .HasColumnType("integer"); b2.Property("Outsiders") .HasColumnType("integer"); b2.Property("Own") .HasColumnType("integer"); b2.HasKey("VendorResourcesPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("VendorResourcesPrequalificationRequestId"); }); b1.OwnsMany("vendorApproverBackend.Entities.TechnicalItem", "TechnicalItems", b2 => { b2.Property("VendorResourcesPrequalificationRequestId") .HasColumnType("bigint"); b2.Property("__synthesizedOrdinal") .ValueGeneratedOnAdd() .HasColumnType("integer"); b2.Property("Count") .HasColumnType("integer"); b2.HasKey("VendorResourcesPrequalificationRequestId", "__synthesizedOrdinal"); b2.ToTable("PrequalificationRequests"); b2.WithOwner() .HasForeignKey("VendorResourcesPrequalificationRequestId"); }); b1.Navigation("Applications"); b1.Navigation("InternationalStandards"); b1.Navigation("ProductionQualifiedStaff"); b1.Navigation("QualifiedStaff"); b1.Navigation("QualityDocuments"); b1.Navigation("QualityQualifiedStaff"); b1.Navigation("SoftwareList"); b1.Navigation("StaffDetails"); b1.Navigation("TechnicalItems"); }); b.Navigation("AdminObservations"); b.Navigation("AssignedTo"); b.Navigation("Compliance"); b.Navigation("Declaration"); b.Navigation("EquipmentGeneralArrangement"); b.Navigation("ExperienceAndAfterSales"); b.Navigation("FinancialStanding"); b.Navigation("GeneralInformation"); b.Navigation("PaymentDetail"); b.Navigation("QualityHSERisk"); b.Navigation("TypeTest"); b.Navigation("Vendor"); b.Navigation("VendorResources"); b.Navigation("VisitRequest"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Product", b => { b.HasOne("vendorApproverBackend.Entities.PrequalificationRequest", "PrequalificationRequest") .WithOne("Product") .HasForeignKey("vendorApproverBackend.Entities.Product", "PrequalificationRequestId"); b.Navigation("PrequalificationRequest"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RenewalClarification", b => { b.HasOne("vendorApproverBackend.Entities.VendorResponse", "VendorResponse") .WithMany() .HasForeignKey("VendorResponseId"); b.Navigation("VendorResponse"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RenewalFinalDecision", b => { b.HasOne("vendorApproverBackend.Entities.FileModel", "SupportingDocument") .WithMany() .HasForeignKey("SupportingDocumentId"); b.Navigation("SupportingDocument"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RenewalPart2Evaluation", b => { b.OwnsOne("vendorApproverBackend.Entities.CriteriaData", "Criteria", b1 => { b1.Property("RenewalPart2EvaluationId") .HasColumnType("bigint"); b1.HasKey("RenewalPart2EvaluationId"); b1.ToTable("renewal_part2_evaluations"); b1.ToJson("criteria"); b1.WithOwner() .HasForeignKey("RenewalPart2EvaluationId"); b1.OwnsOne("vendorApproverBackend.Entities.ScoreDetail", "AfterSaleService", b2 => { b2.Property("CriteriaDataRenewalPart2EvaluationId") .HasColumnType("bigint"); b2.Property("Remark") .HasColumnType("text"); b2.Property("Score") .HasColumnType("double precision"); b2.Property("ScoreLabel") .HasColumnType("text"); b2.HasKey("CriteriaDataRenewalPart2EvaluationId"); b2.ToTable("renewal_part2_evaluations"); b2.WithOwner() .HasForeignKey("CriteriaDataRenewalPart2EvaluationId"); }); b1.OwnsOne("vendorApproverBackend.Entities.ScoreDetail", "ComplianceWithStandards", b2 => { b2.Property("CriteriaDataRenewalPart2EvaluationId") .HasColumnType("bigint"); b2.Property("Remark") .HasColumnType("text"); b2.Property("Score") .HasColumnType("double precision"); b2.Property("ScoreLabel") .HasColumnType("text"); b2.HasKey("CriteriaDataRenewalPart2EvaluationId"); b2.ToTable("renewal_part2_evaluations"); b2.WithOwner() .HasForeignKey("CriteriaDataRenewalPart2EvaluationId"); }); b1.OwnsOne("vendorApproverBackend.Entities.ScoreDetail", "ProductPerformance", b2 => { b2.Property("CriteriaDataRenewalPart2EvaluationId") .HasColumnType("bigint"); b2.Property("Remark") .HasColumnType("text"); b2.Property("Score") .HasColumnType("double precision"); b2.Property("ScoreLabel") .HasColumnType("text"); b2.HasKey("CriteriaDataRenewalPart2EvaluationId"); b2.ToTable("renewal_part2_evaluations"); b2.WithOwner() .HasForeignKey("CriteriaDataRenewalPart2EvaluationId"); }); b1.Navigation("AfterSaleService") .IsRequired(); b1.Navigation("ComplianceWithStandards") .IsRequired(); b1.Navigation("ProductPerformance") .IsRequired(); }); b.Navigation("Criteria") .IsRequired(); }); modelBuilder.Entity("vendorApproverBackend.Entities.RenewalPart3Decision", b => { b.HasOne("vendorApproverBackend.Entities.FileModel", "SupportingDocument") .WithMany() .HasForeignKey("SupportingDocumentId"); b.Navigation("SupportingDocument"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RequestRenew", b => { b.HasOne("vendorApproverBackend.Entities.FileModel", "ApprovedDesignFile") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "ApprovedDesignFileId"); b.HasOne("vendorApproverBackend.Entities.User", "AssignedTo") .WithMany() .HasForeignKey("AssignedToId") .OnDelete(DeleteBehavior.Restrict); b.HasOne("vendorApproverBackend.Entities.Certification", null) .WithMany("RequestRenews") .HasForeignKey("CertificationId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.RenewalClarification", "Clarification") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "ClarificationId"); b.HasOne("vendorApproverBackend.Entities.FileModel", "ExpiredProductCertificateFile") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "ExpiredProductCertificateFileId"); b.HasOne("vendorApproverBackend.Entities.RenewalFinalDecision", "FinalDecision") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "FinalDecisionId"); b.HasOne("vendorApproverBackend.Entities.FileModel", "ManagerRenewFile") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "ManagerRenewFileId"); b.HasOne("vendorApproverBackend.Entities.FileModel", "OfficialLetterFile") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "OfficialLetterFileId"); b.HasOne("vendorApproverBackend.Entities.FileModel", "OfficialLetterFileRemark") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "OfficialLetterFileRemarkId"); b.HasOne("vendorApproverBackend.Entities.RenewalPart2Evaluation", "Part2Evaluation") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "Part2EvaluationId"); b.HasOne("vendorApproverBackend.Entities.RenewalPart3Decision", "Part3Decision") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "Part3DecisionId"); b.HasOne("vendorApproverBackend.Entities.RenewalPayment", "Payment") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "PaymentId"); b.HasOne("vendorApproverBackend.Entities.FileModel", "ReferenceOrdersFile") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "ReferenceOrdersFileId"); b.HasOne("vendorApproverBackend.Entities.FileModel", "RenewRequestFile") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "RenewRequestFileId"); b.HasOne("vendorApproverBackend.Entities.Signature", "Signature") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "SignatureId"); b.HasOne("vendorApproverBackend.Entities.FileModel", "TdcDocument") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "TdcDocumentId"); b.HasOne("vendorApproverBackend.Entities.FileModel", "UpdateTDSFile") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "UpdateTDSFileId"); b.HasOne("vendorApproverBackend.Entities.UpdatedVendorData", "UpdatedVendorData") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "UpdatedVendorDataId"); b.HasOne("vendorApproverBackend.Entities.FileModel", "ValidAgencyAgreementFile") .WithOne() .HasForeignKey("vendorApproverBackend.Entities.RequestRenew", "ValidAgencyAgreementFileId"); b.Navigation("ApprovedDesignFile"); b.Navigation("AssignedTo"); b.Navigation("Clarification"); b.Navigation("ExpiredProductCertificateFile"); b.Navigation("FinalDecision"); b.Navigation("ManagerRenewFile"); b.Navigation("OfficialLetterFile"); b.Navigation("OfficialLetterFileRemark"); b.Navigation("Part2Evaluation"); b.Navigation("Part3Decision"); b.Navigation("Payment"); b.Navigation("ReferenceOrdersFile"); b.Navigation("RenewRequestFile"); b.Navigation("Signature"); b.Navigation("TdcDocument"); b.Navigation("UpdateTDSFile"); b.Navigation("UpdatedVendorData"); b.Navigation("ValidAgencyAgreementFile"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RequestRenewClarification", b => { b.HasOne("vendorApproverBackend.Entities.PrequalificationRequest", null) .WithMany("Clarifications") .HasForeignKey("PrequalificationRequestId") .OnDelete(DeleteBehavior.Cascade); b.HasOne("vendorApproverBackend.Entities.RequestRenew", null) .WithMany("Clarifications") .HasForeignKey("RequestRenewId") .OnDelete(DeleteBehavior.Cascade); b.HasOne("vendorApproverBackend.Entities.User", "Sender") .WithMany() .HasForeignKey("SenderId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("vendorApproverBackend.Entities.VendorRequestLetter", null) .WithMany("Clarifications") .HasForeignKey("VendorRequestLetterId") .OnDelete(DeleteBehavior.Cascade); b.Navigation("Sender"); }); 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.VendorRequestLetter", b => { b.HasOne("vendorApproverBackend.Entities.Vendor", "Vendor") .WithMany("VendorRequestLetters") .HasForeignKey("VendorId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Vendor"); }); modelBuilder.Entity("vendorApproverBackend.Entities.ApplicationCategory", b => { b.Navigation("Categories"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Certification", b => { b.Navigation("RequestRenews"); }); modelBuilder.Entity("vendorApproverBackend.Entities.EmployeeApplication", b => { b.Navigation("ApplicationCategories"); }); modelBuilder.Entity("vendorApproverBackend.Entities.PaymentDetail", b => { b.Navigation("PrequalificationRequest") .IsRequired(); }); modelBuilder.Entity("vendorApproverBackend.Entities.PrequalificationRequest", b => { b.Navigation("AssessmentReport") .IsRequired(); b.Navigation("Certification"); b.Navigation("Clarifications"); b.Navigation("PqClarifications"); b.Navigation("Product"); }); modelBuilder.Entity("vendorApproverBackend.Entities.RequestRenew", b => { b.Navigation("Clarifications"); b.Navigation("PerformanceLetters"); }); modelBuilder.Entity("vendorApproverBackend.Entities.User", b => { b.Navigation("AssignedPrequalificationRequests"); b.Navigation("CreatedAssessmentReports"); b.Navigation("EmployeeApplications"); b.Navigation("Vendor"); }); modelBuilder.Entity("vendorApproverBackend.Entities.Vendor", b => { b.Navigation("PrequalificationRequests"); b.Navigation("VendorRequestLetters"); }); modelBuilder.Entity("vendorApproverBackend.Entities.VendorRequestLetter", b => { b.Navigation("Clarifications"); b.Navigation("LetterProducts"); }); #pragma warning restore 612, 618 } } }