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