Table : housingAssociations

Raw table description

Fields

id id

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

organizationUnitId  → organizationUnits

{
  "name": "organizationUnitId",
  "type": "foreignKey",
  "table": "organizationUnits"
}

name

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

identifier

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

taxationType E

{
  "name": "taxationType",
  "type": "enum",
  "enums": [
    "ENUMS_HOUSING_ASSOCIATION_TAXATION_TYPE_NOT_PRIVATE (Ej privatbostadsföretag (oäkta))",
    "ENUMS_HOUSING_ASSOCIATION_TAXATION_TYPE_PRIVATE (Privatbostadsföretag (äkta))"
  ]
}

housingAssociationType E

{
  "name": "housingAssociationType",
  "type": "enum",
  "enums": [
    "ENUMS_HOUSING_ASSOCIATION_TYPE_PROPERTY_COMPANY (Bostadsaktiebolag)",
    "ENUMS_HOUSING_ASSOCIATION_TYPE_PROPERTY_ASSOCIATION (Bostadsförening)",
    "ENUMS_HOUSING_ASSOCIATION_TYPE_HOUSING_ASSOCIATION (Bostadsrättsförening)"
  ]
}

contactInformationId  → contactInformation

{
  "name": "contactInformationId",
  "type": "foreignKey",
  "table": "contactInformation"
}

foundedYear

{
  "name": "foundedYear",
  "type": "year"
}

numberOfApartments

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

numberOfPremises

{
  "name": "numberOfPremises",
  "type": "smallint"
}

numberOfRentApartments

{
  "name": "numberOfRentApartments",
  "type": "smallint"
}

legalEntityAcceptableSetting E

{
  "name": "legalEntityAcceptableSetting",
  "type": "enum",
  "enums": [
    "ENUM_LEGAL_ENTITY_ACCEPTABLE_SETTING_YES (Ja)",
    "ENUM_LEGAL_ENTITY_ACCEPTABLE_SETTING_NO (Nej)",
    "ENUM_LEGAL_ENTITY_ACCEPTABLE_SETTING_AFTER_CONSIDERATION (Föreningen kan acceptera juridisk person efter särskild prövning)"
  ]
}

transferFee

{
  "name": "transferFee",
  "type": "text",
  "maxLength": 120
}

transferFeePaidBy E

{
  "name": "transferFeePaidBy",
  "type": "enum",
  "enums": [
    "ENUMS_HOUSING_ASSOCIATION_TRANSFER_FEE_PAID_BY_SELLER (Säljare)",
    "ENUMS_HOUSING_ASSOCIATION_TRANSFER_FEE_PAID_BY_BUYER (Köpare)",
    "ENUMS_HOUSING_ASSOCIATION_TRANSFER_FEE_PAID_BY_NO_FEE (Ingen avgift)"
  ]
}

generalInformation

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

economy

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

feeChanges

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

upcomingRenovations

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

madeRenovations

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

businessHours

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

errors

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

insurance

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

other

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

pledgingFee

{
  "name": "pledgingFee",
  "type": "text",
  "maxLength": 120
}

otherAreasComment

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

parkingDescription

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

locationDescription

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

directions

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

comment

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

transferRoutine

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

updatedByContactId  → contacts

{
  "name": "updatedByContactId",
  "type": "foreignKey",
  "table": "contacts"
}

manuallyUpdatedDate

{
  "name": "manuallyUpdatedDate",
  "type": "datetime"
}

websiteURL

{
  "name": "websiteURL",
  "type": "text",
  "maxLength": 200
}

communications

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

yearlyRent $$

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

loans $$

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

loansPerAreaUnit $$  (Area unit for the moment is m²)

{
  "name": "loansPerAreaUnit",
  "type": "money",
  "note": "Area unit for the moment is m²"
}

plotOwnership E

{
  "name": "plotOwnership",
  "type": "enum",
  "enums": [
    "ENUMS_HOUSING_ASSOCIATION_PLOT_OWNERSHIP_LEASEHOLD (Marken är tomträtt)",
    "ENUMS_HOUSING_ASSOCIATION_PLOT_OWNERSHIP_OWNS (Föreningen äger marken)"
  ]
}

isHotWaterIncluded bit

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

isColdWaterIncluded bit

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

isCondominiumSupplementIncluded bit

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

isHeatIncluded bit

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

isWaterIncluded bit

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

isElectricityIncluded bit

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

isCableTVIncluded bit

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

isInternetIncluded bit

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

isGarageIncluded bit

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

isCarportIncluded bit

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

isParkingSpaceIncluded bit

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

isIPTVIncluded bit

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

isIPTelephonyIncluded bit

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

otherFeesIncludedInRent

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

monthlyRentSummary

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

updatedDate

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

Collections

[
  "filesInHousingAssociations",
  "housingAssociationBuildings",
  "housingAssociationContacts",
  "imagesInHousingAssociations",
  "parkingSpaces"
]

Unique Fields

 The fields identifier and organizationUnitId together.

Referenced by

contacts as housingAssociationId
estates as housingAssociationId
filesInHousingAssociations as housingAssociationId
housingAssociationBuildings as housingAssociationId
housingAssociationContacts as housingAssociationId
housingAssociationGeographicalAreas as housingAssociationId (connection table to geographicalAreas via geographicalAreaId)
housingAssociationUrls as housingAssociationId
housingAssociationsParkingSpaces as housingAssociationId (connection table to parkingSpaces via parkingSpaceId)
imagesInHousingAssociations as housingAssociationId (connection table to files via fileId)