Field Name

Data Type

Description/Example

Mortgage_Key

Integer

Primary Key

Mortgage_Type

Varchar

Car/Home/Personal mortgage

Mortgage_Amount

Integer

Mortgage Amount, Like $1000, $10000 etc.

Mortgage_Tenure

Integer

Mortgage Tenure in Months like 12, 24, 36 etc

Mortgage_Interest

Double

Applicable Interest Rate.

Mortgage_EMI

Double

Amount payable monthly as installments.