Table : estateTenantsSubObjectTypeEstateCalculations

Raw table description

Fields

id id

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

estateId M  → estates

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

estateTenantsSubObjectTypeId M  → estateTenantsSubObjectTypes

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

generalizedCost $$  (cost/m2)

{
  "name": "generalizedCost",
  "type": "money",
  "note": "cost/m2"
}

generalizedOperationCost $$  (cost/m2)

{
  "name": "generalizedOperationCost",
  "type": "money",
  "note": "cost/m2"
}

generalizedMaintenanceCost $$  (cost/m2)

{
  "name": "generalizedMaintenanceCost",
  "type": "money",
  "note": "cost/m2"
}

quantity

{
  "name": "quantity",
  "type": "tinyint"
}

totalArea   (m2)

{
  "name": "totalArea",
  "type": "decimal",
  "digits": 15,
  "decimals": 1,
  "note": "m2"
}

totalRevenue $$  (SEK/year)

{
  "name": "totalRevenue",
  "type": "money",
  "note": "SEK/year"
}

totalRevenuePerArea $$  (SEK/m2)

{
  "name": "totalRevenuePerArea",
  "type": "money",
  "note": "SEK/m2"
}

otherRevenues $$  (SEK/year)

{
  "name": "otherRevenues",
  "type": "money",
  "note": "SEK/year"
}

otherRevenuesPerArea $$  (SEK/m2)

{
  "name": "otherRevenuesPerArea",
  "type": "money",
  "note": "SEK/m2"
}

vacancyQuantity

{
  "name": "vacancyQuantity",
  "type": "tinyint"
}

vacancyTotalArea   (m2)

{
  "name": "vacancyTotalArea",
  "type": "decimal",
  "digits": 15,
  "decimals": 1,
  "note": "m2"
}

vacancyTotalRevenue $$  (SEK/m2)

{
  "name": "vacancyTotalRevenue",
  "type": "money",
  "note": "SEK/m2"
}

updatedDate

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

Unique Fields

 The fields estateId and estateTenantsSubObjectTypeId together.