Table : loans

Raw table description

Fields

id id

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

estateId  → estates

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

loanType T

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

loanCategory E

{
  "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)"
  ]
}

loanNumber

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

financialInstitution

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

loanDescription

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

amount $$

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

interestRate

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

hasFloatingRate bit

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

yearlyAmortizationSum

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

yearlyNumberOfAmortizations

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

mostResentAmortizationSum

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

secondMostResentAmortizationSum

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

loanDuration

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

loanEndDate

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

numberOfNonAmortizationYears

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

interestRateAdjustmentDate

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

conversionDate

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

description

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

accruedInterest $$

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

interestCompensation $$

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

serviceFee $$

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

loanControlDate

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

updatedDate

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

Collections

[
  "loanAmounts",
  "loanMortgages"
]

Referenced by

loanAmounts as loanId (connection table to amounts via amountId)
loanMortgages as loanId (connection table to mortgages via mortgageId)