Table : estateTenants

Raw table description

Fields

id id

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

estateId M  → estates

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

estateTenantsObjectTypeId M  → estateTenantsObjectTypes

{
  "name": "estateTenantsObjectTypeId",
  "type": "foreignKey",
  "table": "estateTenantsObjectTypes",
  "mandatory": "true"
}

estateTenantsSubObjectTypeId  → estateTenantsSubObjectTypes

{
  "name": "estateTenantsSubObjectTypeId",
  "type": "foreignKey",
  "table": "estateTenantsSubObjectTypes"
}

status  → estateTenantsObjectTypesStatus

{
  "name": "status",
  "type": "foreignKey",
  "table": "estateTenantsObjectTypesStatus"
}

buildingId  → buildings

{
  "name": "buildingId",
  "type": "foreignKey",
  "table": "buildings"
}

name

{
  "name": "name",
  "type": "text",
  "maxLength": 80
}

contractNr

{
  "name": "contractNr",
  "type": "text",
  "maxLength": 80
}

contractEndDate

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

noticePeriod

{
  "name": "noticePeriod",
  "type": "text",
  "maxLength": 40
}

prolongation

{
  "name": "prolongation",
  "type": "text",
  "maxLength": 80
}

identifier

{
  "name": "identifier",
  "type": "text",
  "maxLength": 80
}

apartmentNumber

{
  "name": "apartmentNumber",
  "type": "text",
  "maxLength": 10
}

governmentApartmentNumber

{
  "name": "governmentApartmentNumber",
  "type": "text",
  "maxLength": 10
}

floorNumber

{
  "name": "floorNumber",
  "type": "text",
  "maxLength": 40
}

area

{
  "name": "area",
  "type": "decimal",
  "digits": 6,
  "decimals": 1
}

livingArea

{
  "name": "livingArea",
  "type": "decimal",
  "digits": 6,
  "decimals": 1
}

otherLivingArea

{
  "name": "otherLivingArea",
  "type": "decimal",
  "digits": 6,
  "decimals": 1
}

numberOfRooms

{
  "name": "numberOfRooms",
  "type": "decimal",
  "digits": 4,
  "decimals": 1
}

rent $$  (yearly)

{
  "name": "rent",
  "type": "money",
  "note": "yearly"
}

income $$  (yearly)

{
  "name": "income",
  "type": "money",
  "note": "yearly"
}

incomePerArea $$  (yearly, area = m²)

{
  "name": "incomePerArea",
  "type": "money",
  "note": "yearly, area = m²"
}

isIncomeApproximate bit

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

isHeatIncludedInRent bit

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

isWaterIncludedInRent bit

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

isElectricityIncludedInRent bit

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

yearlyIndexIncrease

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

isTax bit

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

otherFeesIncludedInRent

{
  "name": "otherFeesIncludedInRent",
  "type": "text",
  "maxLength": 150
}

comment

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

vatSettings T

{
  "name": "vatSettings",
  "type": "text",
  "maxLength": 200,
  "enums": [
    "ENUM_ESTATE_TENANTS_VAT_SETTINGS_INCLUDED (Tillkommer)",
    "ENUM_ESTATE_TENANTS_VAT_SETTINGS_NOT_INCLUDED (Utgår ej)"
  ]
}

displayOrder

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

rentIndex

{
  "name": "rentIndex",
  "type": "text",
  "maxLength": 40
}

updatedDate

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

Referenced by

estateTenantsExtras as estateTenantId