Table : mortgages

Raw table description

Fields

id id

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

isImportedMortgage bit

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

estateId  → estates

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

amount $$

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

externalId

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

logEntryId

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

holderName

{
  "name": "holderName",
  "type": "text",
  "maxLength": 60
}

displayOrder

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

createdDate

{
  "name": "createdDate",
  "type": "timestamp"
}

registrationDate

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

description

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

isWrittenMortgage bit

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

currency  → currencies

{
  "name": "currency",
  "type": "foreignKey",
  "table": "currencies",
  "schema": "mspx_admin"
}

updatedDate

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

Referenced by

loanMortgages as mortgageId (connection table to loans via loanId)