Table : loans

{
  "name": "id",
  "type": "primaryKey"
}

{
  "name": "estateId",
  "type": "foreignKey",
  "table": "estates"
}

{
  "name": "loanType",
  "type": "text",
  "maxLength": 120,
  "enums": [
    "ENUMS_LOANTYPE_VARIABLE_RATE_MORTGAGES (Bottenlån)",
    "ENUMS_LOANTYPE_SECOND_MORTGAGE (Topplån)"
  ]
}

{
  "name": "loanCategory",
  "type": "enum",
  "enums": [
    "ENUMS_LOANCATEGORY_DOWN_PAYMENT_LOANS (Handpenningslån)",
    "ENUMS_LOANCATEGORY_RESOLVED_BY_THE_SELLER (Löses av säljaren)",
    "ENUMS_LOANCATEGORY_NEW_LOAN (Nytt lån)",
    "ENUMS_LOANCATEGORY_ASSUMED_BY_THE_PURCHASER (Övertas av köparen)",
    "ENUMS_LOANCATEGORY_CHANGE_OF_MORTGAGE (Säkerhetsbyte)"
  ]
}

{
  "name": "loanNumber",
  "type": "text",
  "maxLength": 30
}

{
  "name": "financialInstitution",
  "type": "text",
  "maxLength": 100
}

{
  "name": "loanDescription",
  "type": "text",
  "maxLength": 50
}

{
  "name": "amount",
  "type": "money"
}

{
  "name": "interestRate",
  "type": "percentage"
}

{
  "name": "hasFloatingRate",
  "type": "bit"
}

{
  "name": "yearlyAmortizationSum",
  "type": "int"
}

{
  "name": "yearlyNumberOfAmortizations",
  "type": "int"
}

{
  "name": "mostResentAmortizationSum",
  "type": "int"
}

{
  "name": "secondMostResentAmortizationSum",
  "type": "int"
}

{
  "name": "loanDuration",
  "type": "year"
}

{
  "name": "loanEndDate",
  "type": "date"
}

{
  "name": "numberOfNonAmortizationYears",
  "type": "float"
}

{
  "name": "interestRateAdjustmentDate",
  "type": "date"
}

{
  "name": "conversionDate",
  "type": "date"
}

{
  "name": "description",
  "type": "text"
}

{
  "name": "accruedInterest",
  "type": "money"
}

{
  "name": "interestCompensation",
  "type": "money"
}

{
  "name": "serviceFee",
  "type": "money"
}

{
  "name": "loanControlDate",
  "type": "date"
}

{
  "name": "updatedDate",
  "type": "updated"
}