final_pf

Tables (20)

Benefit_Condition

  • ConditionID — VARCHAR(255)
  • ProductID — VARCHAR(255) — NOT NULL
  • ConditionName — VARCHAR(255) — NOT NULL
  • ConditionDescription — TEXT
  • PreferredRate — DECIMAL(5, 3)
  • PreferredAmount — DECIMAL(18, 2)

ConsultationSession

  • SessionID — VARCHAR(255)
  • EmployeeID — VARCHAR(255) — NOT NULL
  • CustomerID — VARCHAR(255) — NOT NULL
  • StartTime — DATETIME — NOT NULL
  • EndTime — DATETIME
  • Status — VARCHAR(50) — NOT NULL
  • CurrentActiveFormSessionID — VARCHAR(255)

Customer

  • CustomerID — VARCHAR(255)
  • Name — VARCHAR(255) — NOT NULL
  • DateOfBirth — DATE
  • ContactNumber — VARCHAR(255)
  • Address — TEXT
  • Gender — VARCHAR(50)
  • RegistrationDate — DATETIME

CustomerExternalFinancialInfo

  • ExternalInfoID — VARCHAR(255)
  • CustomerID — VARCHAR(255) — NOT NULL
  • InstitutionName — VARCHAR(255) — NOT NULL
  • AssetType — VARCHAR(255) — NOT NULL
  • AccountNumber — VARCHAR(255)
  • CurrentBalance — DECIMAL(18, 2)
  • DataCollectionDateTime — DATETIME — NOT NULL
  • InterestRate — DECIMAL(5, 3)
  • MaturityDate — DATE

CustomerFormSignature

  • SignatureID — VARCHAR(255)
  • SessionFormID — VARCHAR(255) — NOT NULL
  • CustomerID — VARCHAR(255) — NOT NULL
  • SignatureDateTime — DATETIME — NOT NULL
  • SignatureData — TEXT — NOT NULL
  • SignatureMatchRate — DECIMAL(5, 3)
  • IsSignatureValid — BOOLEAN

CustomerPortfolio

  • PortfolioID — VARCHAR(255)
  • CustomerID — VARCHAR(255) — NOT NULL
  • RecommendedProducts — JSON
  • SimulatedYield — DECIMAL(5, 3)
  • ExpectedGain — DECIMAL(18, 2)
  • CreationTimestamp — DATETIME
  • Source — VARCHAR(50)

CustomerProduct

  • EnrollmentID — VARCHAR(255)
  • CustomerID — VARCHAR(255) — NOT NULL
  • ProductID — VARCHAR(255) — NOT NULL
  • EnrollmentDate — DATE — NOT NULL
  • MaturityDate — DATE
  • CurrentBalance — DECIMAL(18, 2)
  • CurrentAppliedRate — DECIMAL(5, 3)
  • Status — VARCHAR(50) — NOT NULL
  • CancellationDate — DATETIME

Deposit

  • DepositProductID — VARCHAR(255)
  • Benefit — TEXT
  • MaturityDate — DATE
  • Cost — DECIMAL(18, 2)

EForm

  • FormID — VARCHAR(255)
  • FormName — VARCHAR(255) — NOT NULL
  • FormType — VARCHAR(255)
  • FormSchema — JSON — NOT NULL
  • FormTemplatePath — VARCHAR(255)
  • Description — TEXT
  • VersionNumber — VARCHAR(50)
  • ProductID — VARCHAR(255)

Employee

  • EmployeeID — VARCHAR(255)
  • Name — VARCHAR(255) — NOT NULL
  • Position — VARCHAR(255)
  • Department — VARCHAR(255)
  • ContactNumber — VARCHAR(255)
  • HireDate — DATE
  • BranchCode — VARCHAR(255)

Fund

  • FundProductID — VARCHAR(255)
  • FundType — VARCHAR(255)
  • ReturnRate — DECIMAL(5, 3)
  • RiskRating — VARCHAR(50)
  • AssetManager — VARCHAR(255)

ISA

  • ISAProductID — VARCHAR(255)
  • AccountType — VARCHAR(255)
  • ContributionLimit — DECIMAL(18, 2)
  • TaxExemptionBenefit — TEXT
  • EligibilityCriteria — TEXT

Insurance

  • InsuranceProductID — VARCHAR(255)
  • InsuranceType — VARCHAR(255)
  • PremiumPaymentFrequency — VARCHAR(255)
  • CoverageDetails — TEXT
  • PremiumAmount — DECIMAL(18, 2)

Loan

  • LoanProductID — VARCHAR(255)
  • LoanInterestRate — DECIMAL(5, 3)
  • RepaymentPeriod — INT
  • MaxLoanAmount — DECIMAL(18, 2)
  • CollateralRequired — BOOLEAN

PensionFund

  • PensionFundProductID — VARCHAR(255)
  • PensionType — VARCHAR(255)
  • OperationMethod — VARCHAR(255)
  • FeeStructure — TEXT
  • MinimumContribution — DECIMAL(18, 2)

Product

  • ProductID — VARCHAR(255)
  • ProductName — VARCHAR(255) — NOT NULL
  • ProductType — VARCHAR(255) — NOT NULL
  • Description — TEXT
  • LaunchDate — DATE
  • SalesStatus — VARCHAR(50)
  • MinAmount — DECIMAL(18, 2)
  • MaxAmount — DECIMAL(18, 2)
  • BaseRate — DECIMAL(5, 3)

ProductApplication

  • ApplicationID — VARCHAR(255)
  • CustomerID — VARCHAR(255) — NOT NULL
  • ProductID — VARCHAR(255) — NOT NULL
  • ApplicationDate — DATETIME — NOT NULL
  • ApplicationStatus — VARCHAR(50) — NOT NULL
  • EmployeeID — VARCHAR(255)
  • FinalSessionFormID — VARCHAR(255)
  • SignedDocumentPath — VARCHAR(255)

Recommendation

  • RecommendationID — VARCHAR(255)
  • CustomerID — VARCHAR(255) — NOT NULL
  • RecommendedProductID — VARCHAR(255) — NOT NULL
  • RecommendationDateTime — DATETIME — NOT NULL
  • Reasoning — TEXT
  • ConfidenceScore — DECIMAL(5, 3)
  • IsAccepted — BOOLEAN
  • SourceAIModel — VARCHAR(255)

SessionForm

  • SessionFormID — VARCHAR(255)
  • SessionID — VARCHAR(255) — NOT NULL
  • FormID — VARCHAR(255) — NOT NULL
  • Status — VARCHAR(50) — NOT NULL
  • SentTimestamp — DATETIME — NOT NULL
  • LastUpdateTimestamp — DATETIME
  • FilledData — JSON

Simulation

  • SimulationID — VARCHAR(255)
  • CustomerID — VARCHAR(255) — NOT NULL
  • SimulationDateTime — DATETIME — NOT NULL
  • SelectedConditions — JSON
  • InitialAnnualBenefit — DECIMAL(18, 2)
  • ExpectedAnnualBenefit — DECIMAL(18, 2)
  • ExpectedBenefitIncrease — DECIMAL(18, 2)
  • RecommendedPortfolio — JSON