Table : housingAssociationBuildings

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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