Table : housingAssociationBuildings

Raw table description

Fields

id id

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

housingAssociationId  → housingAssociations

{
  "name": "housingAssociationId",
  "type": "foreignKey",
  "table": "housingAssociations"
}

name

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

streetAddress

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

postalCode

{
  "name": "postalCode",
  "type": "text",
  "maxLength": 20
}

city

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

description

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

hasLiftSetting E

{
  "name": "hasLiftSetting",
  "type": "enum",
  "enums": [
    "ENUM_HAS_LIFT_SETTING_NO (Nej)",
    "ENUM_HAS_LIFT_SETTING_YES (Ja)"
  ]
}

heatAndAirConditionFacilityDescription

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

multimediaDescription

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

liftDescription

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

maxFloors

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

buildYear

{
  "name": "buildYear",
  "type": "text",
  "maxLength": 20
}

energyClass E

{
  "name": "energyClass",
  "type": "enum",
  "enums": [
    "ENUMS_ENERGYCLASS_TYPE_A (A)",
    "ENUMS_ENERGYCLASS_TYPE_B (B)",
    "ENUMS_ENERGYCLASS_TYPE_C (C)",
    "ENUMS_ENERGYCLASS_TYPE_D (D)",
    "ENUMS_ENERGYCLASS_TYPE_E (E)",
    "ENUMS_ENERGYCLASS_TYPE_F (F)",
    "ENUMS_ENERGYCLASS_TYPE_G (G)"
  ]
}

energyPerformance

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

energyPrimaryPerformance   (kWh/m2, introduced in 2018. sv: primärenergital)

{
  "name": "energyPrimaryPerformance",
  "type": "int",
  "note": "kWh/m2, introduced in 2018. sv: primärenergital"
}

energyDescription

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

energyStatus E

{
  "name": "energyStatus",
  "type": "enum",
  "enums": [
    "ENUMS_EnergyStatus_TYPE_ENERGY_AUDITS_ARE_COMMISSIONED (Energideklaration är beställd)",
    "ENUMS_EnergyStatus_TYPE_ENERGY_AUDITS_NOT_PERFORMED (Energideklaration ej utförd)",
    "ENUMS_EnergyStatus_TYPE_ENERGY_USE_IN_PROGRESS (Energideklaration pågår)",
    "ENUMS_EnergyStatus_TYPE_ENERGY_USE_IS_MADE (Energideklaration är utförd)",
    "ENUMS_EnergyStatus_TYPE_ENERGY_USE_IS_NOT_NEEDED (Energideklaration behövs ej)"
  ]
}

energyStatusDate

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

energyStatusEntrepreneur

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

displayOrder

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

doorCode

{
  "name": "doorCode",
  "type": "text",
  "maxLength": 16
}

updatedDate

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

Referenced by

estates as housingAssociationBuildingId
filesInHousingAssociationBuildings as housingAssociationBuildingId (connection table to files via fileId)