loan eligibility evaluation
Tables (3)
loanApp (...)
- id (PK) — Primary key — NOT NULL
loan_eligibility_evaluation (table)
- id (PK) — INT? LONG? — Primary key — NOT NULL
- id (FK1) — Foreign key → product_comprehension.id — NOT NULL
- loan_app_id (FK2) — Foreign key → loanApp.id — NOT NULL
- loan_usage (Field)
- income (Field2)
- total_asset_scale(?) (Field3)
- debt_scale (Field4)
- how_to_repay (Field5)
- product_comprehension_id (Field6)
product_comprehension (..)
- id (PK) — Primary key — NOT NULL
- past_loan_experience(?) (Field)
- product_comprehension.. (Field2)
- fixed_spending (Field3)