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)