Table : estates

Raw table description

Fields

id id

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

dealId  → deals  (Deal the estate belongs to)

{
  "name": "dealId",
  "type": "foreignKey",
  "table": "deals",
  "note": "Deal the estate belongs to"
}

mainImageFileId  → files  (Image that represents the estate)

{
  "name": "mainImageFileId",
  "type": "foreignKey",
  "table": "files",
  "note": "Image that represents the estate"
}

apartmentNumber   (Apartment number from housing association.)

{
  "name": "apartmentNumber",
  "type": "text",
  "maxLength": 30,
  "note": "Apartment number from housing association."
}

governmentApartmentNumber   (Official apartment number.)

{
  "name": "governmentApartmentNumber",
  "type": "text",
  "maxLength": 30,
  "note": "Official apartment number."
}

housingAssociationId  → housingAssociations

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

housingAssociationBuildingId  → housingAssociationBuildings

{
  "name": "housingAssociationBuildingId",
  "type": "foreignKey",
  "table": "housingAssociationBuildings"
}

housingAssociationName

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

housingAssociationIdentifier

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

housingAssociationFoundedYear

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

housingAssociationTaxationType E

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

buildingArea

{
  "name": "buildingArea",
  "type": "decimal",
  "digits": 7,
  "decimals": 1
}

totalLivingArea

{
  "name": "totalLivingArea",
  "type": "decimal",
  "digits": 5,
  "decimals": 1
}

plotAreaComment T

{
  "name": "plotAreaComment",
  "type": "text",
  "maxLength": 150,
  "enums": [
    "ENUMS_LIVINGAREACOMMENT_TYPE_NOTE_THAT_THE_EXACT_SIZE_IS_NOT_MEASURED (Arean är uppskattad)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_TAX_INFORMATION (Taxeringsinformationen)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_OF_THE_SELLER (Säljaren)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_SELLER_AND_HOUSING_ASSOCIATION (Säljaren och bostadsrättsföreningen)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_DRAWING_(S) (Ritning(ar))",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_MEASURING (Mätning)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_LANDLORD (Hyresvärden)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_CONDOMINIUM_ASSOCIATION (Bostadsrättsföreningen)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_OF_OWNERS_OF (Bostadsföreningen)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_NO_MEASURING (Mätning saknas)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_LANTMATERIET (Lantmäteriet)"
  ]
}

note

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

costAccuracy E

{
  "name": "costAccuracy",
  "type": "enum",
  "enums": [
    "ENUMS_ESTATE_COST_ACCURACY_ACTUALLY_COST (Faktisk kostnad)",
    "ENUMS_ESTATE_COST_ACCURACY_STANDARD_COST (Schablon kostnad)"
  ]
}

totalArea

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

propertyDesignation

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

propertyName

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

identifier

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

countryId  → countries

{
  "name": "countryId",
  "type": "foreignKey",
  "table": "countries",
  "schema": "mspx_admin"
}

objectTypeId  → objectTypes

{
  "name": "objectTypeId",
  "type": "foreignKey",
  "table": "objectTypes",
  "schema": "mspx_admin"
}

objectSubTypeId  → objectSubTypes

{
  "name": "objectSubTypeId",
  "type": "foreignKey",
  "table": "objectSubTypes",
  "schema": "mspx_admin"
}

objectSubTypeText   (When objectSubTypeId is set to OBJECTSUBTYPES_OTHER, we allow the user to write their own sub type in this field.)

{
  "name": "objectSubTypeText",
  "type": "text",
  "maxLength": 100,
  "note": "When objectSubTypeId is set to OBJECTSUBTYPES_OTHER, we allow the user to write their own sub type in this field."
}

numberOfRoom

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

roomsDescription

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

roomsDescriptionMultiLang   (Allowed languages: en, sv, es, de, da, fr, nl. Structure: {"en": "text", "sv": "text", "es": "texto" })

{
  "name": "roomsDescriptionMultiLang",
  "type": "jsonObject",
  "validationSchema": {
    "id": "estates/roomsDescriptionMultiLang",
    "type": "object",
    "additionalProperties": false,
    "properties": {
      "sv": {
        "type": "string"
      },
      "en": {
        "type": "string"
      },
      "es": {
        "type": "string"
      },
      "de": {
        "type": "string"
      },
      "da": {
        "type": "string"
      },
      "fr": {
        "type": "string"
      },
      "nl": {
        "type": "string"
      }
    }
  },
  "note": "Allowed languages: en, sv, es, de, da, fr, nl. Structure: {\"en\": \"text\", \"sv\": \"text\", \"es\": \"texto\" }"
}

numberOfBedrooms

{
  "name": "numberOfBedrooms",
  "type": "int",
  "maxLength": 3
}

numberOfBathrooms   (Only used for international deals)

{
  "name": "numberOfBathrooms",
  "type": "int",
  "maxLength": 3,
  "note": "Only used for international deals"
}

numberOfToilets   (Only used for international deals)

{
  "name": "numberOfToilets",
  "type": "int",
  "maxLength": 3,
  "note": "Only used for international deals"
}

swimmingPool E  (Only used for international deals)

{
  "name": "swimmingPool",
  "type": "enum",
  "enums": [
    "ENUM_ESTATE_SWIMMING_POOL_INSIDE (Inomhus)",
    "ENUM_ESTATE_SWIMMING_POOL_OUTSIDE (Utomhus)"
  ],
  "note": "Only used for international deals"
}

convertNumberOfBedRooms

{
  "name": "convertNumberOfBedRooms",
  "type": "int",
  "maxLength": 3
}

livingArea

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

livingAreaIsApproximate bit  (The object description should show that the living area is approximate. livingAreaComment needs to be set to explain why its approximate.)

{
  "name": "livingAreaIsApproximate",
  "type": "bit",
  "note": "The object description should show that the living area is approximate. livingAreaComment needs to be set to explain why its approximate."
}

otherLivingArea

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

livingAreaComment T

{
  "name": "livingAreaComment",
  "type": "text",
  "maxLength": 150,
  "enums": [
    "ENUMS_LIVINGAREACOMMENT_TYPE_NOTE_THAT_THE_EXACT_SIZE_IS_NOT_MEASURED (Arean är uppskattad)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_TAX_INFORMATION (Taxeringsinformationen)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_OF_THE_SELLER (Säljaren)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_SELLER_AND_HOUSING_ASSOCIATION (Säljaren och bostadsrättsföreningen)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_DRAWING_(S) (Ritning(ar))",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_MEASURING (Mätning)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_LANDLORD (Hyresvärden)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_THE_CONDOMINIUM_ASSOCIATION (Bostadsrättsföreningen)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_OF_OWNERS_OF (Bostadsföreningen)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_NO_MEASURING (Mätning saknas)",
    "ENUMS_LIVINGAREACOMMENT_TYPE_AREA_INFORMATION_IN_ACCORDANCE_WITH_LANTMATERIET (Lantmäteriet)"
  ]
}

isLeasehold bit

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

isPartOf bit

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

isAcquisitionPermitNeeded bit  (swe: förvärvstillstånd)

{
  "name": "isAcquisitionPermitNeeded",
  "type": "bit",
  "note": "swe: förvärvstillstånd"
}

isPropertyAssociation bit  (Used in tenant ownership to mark a property association/Bostadsförening)

{
  "name": "isPropertyAssociation",
  "type": "bit",
  "note": "Used in tenant ownership to mark a property association/Bostadsförening"
}

plotArea

{
  "name": "plotArea",
  "type": "decimal",
  "digits": 15,
  "decimals": 1
}

waterArea

{
  "name": "waterArea",
  "type": "decimal",
  "digits": 15,
  "decimals": 1
}

district

{
  "name": "district",
  "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
}

isTenureHouse bit

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

tenureHouseCost $$  (Holds / year)

{
  "name": "tenureHouseCost",
  "type": "money",
  "note": "Holds / year"
}

tenureHousePeriod

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

tenureHouseLandLord

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

tenureHouseEndDate

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

feeDescription

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

premiseType E

{
  "name": "premiseType",
  "type": "enum",
  "enums": [
    "ENUM_ESTATE_PREMISE_TYPE_INDUSTRY (Industrier/verkstäder)",
    "ENUM_ESTATE_PREMISE_TYPE_OFFICE (Kontor)",
    "ENUM_ESTATE_PREMISE_TYPE_OFFICE_HOTEL (Kontorshotell)",
    "ENUM_ESTATE_PREMISE_TYPE_OTHER (Annat)",
    "ENUM_ESTATE_PREMISE_TYPE_SHOP (Butiker)",
    "ENUM_ESTATE_PREMISE_TYPE_STORAGE (Lager/logistik)"
  ]
}

premiseNumber

{
  "name": "premiseNumber",
  "type": "text",
  "maxLength": 30
}

premiseTenantContractNumber

{
  "name": "premiseTenantContractNumber",
  "type": "text",
  "maxLength": 30
}

moduleArea   (Used for premises)

{
  "name": "moduleArea",
  "type": "decimal",
  "digits": 15,
  "decimals": 1,
  "note": "Used for premises"
}

premiseTypeText

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

floorPlanDescription

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

localServicesDescription

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

businessDescription

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

displayPremiseRentAs E  (Used for premises, only used to display rent on for example OD)

{
  "name": "displayPremiseRentAs",
  "type": "enum",
  "enums": [
    "ENUM_ESTATE_DISPLAY_PREMISE_RENT_AS_CURRENCY/MONTH (SEK/MÅNAD)",
    "ENUM_ESTATE_DISPLAY_PREMISE_RENT_AS_CURRENCY/YEAR (SEK/ÅR)",
    "ENUM_ESTATE_DISPLAY_PREMISE_RENT_AS_CURRENCY/YEAR/M2 (SEK/ÅR/M2)"
  ],
  "note": "Used for premises, only used to display rent on for example OD"
}

premiseIndex

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

premiseEconomyValuesVATSetting T

{
  "name": "premiseEconomyValuesVATSetting",
  "type": "text",
  "maxLength": 200,
  "enums": [
    "ENUM_ESTATE_PREMISE_ECONOMY_VALUES_VAT_SETTING_INCLUDED (Tillkommer)",
    "ENUM_ESTATE_PREMISE_ECONOMY_VALUES_VAT_SETTING_NOT_INCLUDED (Utgår ej)"
  ],
  "notes": "Used only on premises and will trigger if. "
}

premiseHideRentOnMarketingPlaces bit

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

premiseHideRentInObjectDescription bit

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

premiseRentIsNegotiable bit  (If set, do not display the rent, but that the rent is negotiable.)

{
  "name": "premiseRentIsNegotiable",
  "type": "bit",
  "note": "If set, do not display the rent, but that the rent is negotiable."
}

businessTradeType E

{
  "name": "businessTradeType",
  "type": "enum",
  "enums": [
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_CARE_AND_HEALTH (Vård & Hälsa)",
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_CARRIER (Transportföretag)",
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_COMMERCE/E-COMMERCE (Handel/e-handel)",
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_CONSTRUCTION (Byggverksamhet)",
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_HOTEL/TOURIST (Hotell/Turistföretag)",
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_MANUFACTURING (Tillverkande företag)",
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_OTHER (Övrigt)",
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_RESTAURANTS/CAFES (Restauranger/Caféer)",
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_SERVICE_COMPANY (Tjänsteföretag)",
    "ENUM_ESTATE_BUSINESS_TRADE_TYPE_SHOPS (Butiker)"
  ]
}

businessEquipment

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

businessEstablishedYear

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

businessNumberOfEmployees

{
  "name": "businessNumberOfEmployees",
  "type": "int unsigned"
}

businessNumberOfCustomers

{
  "name": "businessNumberOfCustomers",
  "type": "int unsigned"
}

businessRevenue $$

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

businessProfit $$

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

renovateYear

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

renovateDescription

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

upcomingRenovationsDescription

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

heatingType T

{
  "name": "heatingType",
  "type": "text",
  "enums": [
    "ENUMS_HEATINGTYPE_TYPE_COMBI_BOILER_WITH_WOOD_OR_ELECTRICITY (Kombipanna med ved eller el)",
    "ENUMS_HEATINGTYPE_TYPE_COMBI_BOILER_WITH_OIL_OR_ELECTRICITY (Kombipanna med olja eller el)",
    "ENUMS_HEATINGTYPE_TYPE_COMBI_BOILER_WITH_OIL_ELECTRICITY_OR_WOOD (Kombipanna med olja el eller ved)",
    "ENUMS_HEATINGTYPE_TYPE_CERAMIC_TILE_FOR_WOOD (Keramikpanna för ved)",
    "ENUMS_HEATINGTYPE_TYPE_GAS (Gasvärme)",
    "ENUMS_HEATINGTYPE_TYPE_GAS_BOILER (Gaspanna)",
    "ENUMS_HEATINGTYPE_TYPE_DISTRICT_HEATING (Fjärrvärme)",
    "ENUMS_HEATINGTYPE_TYPE_ELECTRICITY-WATER_HEAT (El - vattenburen värme)",
    "ENUMS_HEATINGTYPE_TYPE_EL-AIR_HEATING (El - luftburen värme)",
    "ENUMS_HEATINGTYPE_TYPE_DIRECT_ELECTRIC (Direktverkande el)",
    "ENUMS_HEATINGTYPE_TYPE_HEAT_PUMP (Värmepump)",
    "ENUMS_HEATINGTYPE_TYPE_FIREWOOD (Ved)",
    "ENUMS_HEATINGTYPE_TYPE_OIL-FILLED_ELECTRIC_RADIATORS (Oljefyllda el-element)",
    "ENUMS_HEATINGTYPE_TYPE_OIL (Olja)",
    "ENUMS_HEATINGTYPE_TYPE_PELLET (Pellets)",
    "ENUMS_HEATINGTYPE_TYPE_WOODBURNER (Braskamin)",
    "ENUMS_HEATINGTYPE_TYPE_HEATPUMP_AIR_TO_AIR (Värmepump luft-luft)",
    "ENUMS_HEATINGTYPE_TYPE_HEATPUMP_AIR_TO_WATER (Värmepump luft-vatten)",
    "ENUMS_HEATINGTYPE_TYPE_GEOTHERMAL (Bergvärmepump)"
  ],
  "maxLength": 150
}

heatingPlantCondition

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

heatingPlantAge

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

heatingPlantBrand

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

heatingComment

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

electricalStemsCondition T

{
  "name": "electricalStemsCondition",
  "type": "text",
  "maxLength": 50,
  "enums": [
    "ENUMS_ELECTRICALSTEMSCONDITION_TYPE_WIRES_NOT_EXCHANGED (Ledningar ej bytta)",
    "ENUMS_ELECTRICALSTEMSCONDITION_TYPE_WIRES_EXCHANGED (Ledningar bytta)"
  ]
}

mainFuse T

{
  "name": "mainFuse",
  "type": "text",
  "maxLength": 10,
  "enums": [
    "ENUMS_MAINFUSE_TYPE_25_A (25 A)",
    "ENUMS_MAINFUSE_TYPE_20_A (20 A)",
    "ENUMS_MAINFUSE_TYPE_16_A (16 A)",
    "ENUMS_MAINFUSE_TYPE_10_A (10 A)"
  ]
}

electricalComment

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

standardPoints

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

internetSummary

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

electricSafety T

{
  "name": "electricSafety",
  "type": "text",
  "maxLength": 50,
  "enums": [
    "ENUMS_ELECTRICSAFETY_TYPE_UNEARTHED (Ojordat)",
    "ENUMS_ELECTRICSAFETY_TYPE_GROUNDED (Jordat)",
    "ENUMS_ELECTRICSAFETY_TYPE_PARTIALLY_GROUNDED (Delvis jordat)"
  ]
}

subFoundationType T

{
  "name": "subFoundationType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_SUBFOUNDATIONTYPE_TYPE_SAND (Sand)",
    "ENUMS_SUBFOUNDATIONTYPE_TYPE_MORAN (Morän)",
    "ENUMS_SUBFOUNDATIONTYPE_TYPE_LERA (Lera)",
    "ENUMS_SUBFOUNDATIONTYPE_TYPE_STONE (Sten)"
  ]
}

foundationWallType T

{
  "name": "foundationWallType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_FOUNDATIONWALLTYPE_TYPE_WALLS_OF_ROCK (Murar till berg)",
    "ENUMS_FOUNDATIONWALLTYPE_TYPE_LECA-STONE (Lecablock)",
    "ENUMS_FOUNDATIONWALLTYPE_TYPE_CARVED_IN_STONE (Huggen sten)",
    "ENUMS_FOUNDATIONWALLTYPE_TYPE_CASTLEROCK (Gråsten)",
    "ENUMS_FOUNDATIONWALLTYPE_TYPE_CONCRETE (Betong)",
    "ENUMS_FOUNDATIONWALLTYPE_TYPE_CONCRETE_HOLLOW_BRICK (Betonghålsten)"
  ]
}

foundationType T

{
  "name": "foundationType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_FOUNDATIONTYPE_TYPE_TORPARGRUND (Torpargrund)",
    "ENUMS_FOUNDATIONTYPE_TYPE_PILES (Pålar)",
    "ENUMS_FOUNDATIONTYPE_TYPE_BLOCKS (Plintar)",
    "ENUMS_FOUNDATIONTYPE_TYPE_SLAB_ON_GROUND (Platta på mark)",
    "ENUMS_FOUNDATIONTYPE_TYPE_WALLS_OF_ROCK (Murar till berg)",
    "ENUMS_FOUNDATIONTYPE_TYPE_LECA-STONE (Leca-sten)",
    "ENUMS_FOUNDATIONTYPE_TYPE_CARVED_IN_STONE (Huggen sten)",
    "ENUMS_FOUNDATIONTYPE_TYPE_CASTLEROCK (Gråsten)",
    "ENUMS_FOUNDATIONTYPE_TYPE_FOOTINGS (Grundsula)",
    "ENUMS_FOUNDATIONTYPE_TYPE_CONCRETE (Betong)",
    "ENUMS_FOUNDATIONTYPE_TYPE_HOLLOW_FOUNDATION (Krypgrund)"
  ]
}

frameType T

{
  "name": "frameType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_FRAMETYPE_TYPE_WOOD (Trä)",
    "ENUMS_FRAMETYPE_TYPE_BRICK (Tegel)",
    "ENUMS_FRAMETYPE_TYPE_STEEL (Stål)",
    "ENUMS_FRAMETYPE_TYPE_LIGHTWEIGHT_CONCRETE (Lättbetong)",
    "ENUMS_FRAMETYPE_TYPE_CONCRETE (Betong)"
  ]
}

joistType T

{
  "name": "joistType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_JOISTTYPE_TYPE_WOOD (Trä)",
    "ENUMS_JOISTTYPE_TYPE_LIGHTWEIGHT_CONCRETE (Lättbetong)",
    "ENUMS_JOISTTYPE_TYPE_CAST_VAULT (Gjutna valv)",
    "ENUMS_JOISTTYPE_TYPE_CONCRETE (Betong)"
  ]
}

facadeType T

{
  "name": "facadeType",
  "type": "text",
  "enums": [
    "ENUMS_FACADETYPE_TYPE_WOOD (Träfasad)",
    "ENUMS_FACADETYPE_TYPE_BRICK (Tegelstensfasad)",
    "ENUMS_FACADETYPE_TYPE_STANDING_PANELED (Stående träpanel)",
    "ENUMS_FACADETYPE_TYPE_POLISHES (Puts)",
    "ENUMS_FACADETYPE_TYPE_MEXISTEN (Mexisten)",
    "ENUMS_FACADETYPE_TYPE_HORIZONTAL_WOOD_PANELING (Liggande träpanel)",
    "ENUMS_FACADETYPE_TYPE_LIMESTONE (Kalksandsten)",
    "ENUMS_FACADETYPE_TYPE_ETERNIT (Eternit)"
  ]
}

roofingType T

{
  "name": "roofingType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_ROOFINGTYPE_TYPE_BRICK (Tegel)",
    "ENUMS_ROOFINGTYPE_TYPE_ROOF (Takpannor)",
    "ENUMS_ROOFINGTYPE_TYPE_TILES (Taktegel)",
    "ENUMS_ROOFINGTYPE_TYPE_SHEET (Plåt)",
    "ENUMS_ROOFINGTYPE_TYPE_PAPP (Papp)",
    "ENUMS_ROOFINGTYPE_TYPE_COPPERPLATE (Kopparplåt)",
    "ENUMS_ROOFINGTYPE_TYPE_ETERNIT (Eternit)",
    "ENUMS_ROOFINGTYPE_TYPE_CONCRETE_TILES (Betongpannor)"
  ]
}

guttersType T

{
  "name": "guttersType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_GUTTERSTYPE_TYPE_SHEET (Plåt)",
    "ENUMS_GUTTERSTYPE_TYPE_PLASTIC (Plast)",
    "ENUMS_GUTTERSTYPE_TYPE_COPPER (Koppar)",
    "ENUMS_GUTTERSTYPE_TYPE_GALVANIZED_SHEET_METAL_UNPAINTED (Galvaniserad omålad plåt)",
    "ENUMS_GUTTERSTYPE_TYPE_GALVANIZED_PAINTED_PLATE (Galvaniserad målad plåt)"
  ]
}

windowsType T

{
  "name": "windowsType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_WINDOWSTYPE_TYPE_SIMPLE_WINDOW (Enkelglasfönster)",
    "ENUMS_WINDOWSTYPE_TYPE_PAIRED_WINDOWS_WITH_TRANSOMS (Kopplade fönster med spröjs)",
    "ENUMS_WINDOWSTYPE_TYPE_PAIRED_WINDOW (Kopplade fönster)",
    "ENUMS_WINDOWSTYPE_TYPE_LIGHTWEIGHT_WINDOWS_WITH_TRANSOMS (Enkelglasfönster med spröjs)",
    "ENUMS_WINDOWSTYPE_TYPE_GLAZED_WINDOWS_WITH_GLAZING_BARS (Isolerglasfönster med spröjs)",
    "ENUMS_WINDOWSTYPE_TYPE_GLAZED (Isolerglasfönster)",
    "ENUMS_WINDOWSTYPE_TYPE_3-GLAZED_INSULATING (3-glasfönster isoler)",
    "ENUMS_WINDOWSTYPE_TYPE_3-GLASS_WINDOWS_WITH_TRANSOMS (3-glasfönster med spröjs)",
    "ENUMS_WINDOWSTYPE_TYPE_3-GLASS_WINDOW (3-glasfönster)",
    "ENUMS_WINDOWSTYPE_TYPE_2-GLAZED_WINDOWS_WITH_TRANSOMS (2-glasfönster med spröjs)",
    "ENUMS_WINDOWSTYPE_TYPE_2-GLAZED_INSULATING_(SINGLE) (2-glasfönster isoler (enkel))",
    "ENUMS_WINDOWSTYPE_TYPE_2-GLAZED_INSULATING (2-glasfönster isoler)",
    "ENUMS_WINDOWSTYPE_TYPE_2-GLASS_WINDOWS (2-glasfönster)"
  ]
}

ventilationType T

{
  "name": "ventilationType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_VENTILATIONTYPE_TYPE_NATURAL_DRAFT (Självdrag)",
    "ENUMS_VENTILATIONTYPE_TYPE_MECHANICAL_SUPPLY_AND_EXHAUST_AIR (Mekanisk till- och frånluft)",
    "ENUMS_VENTILATIONTYPE_TYPE_MECHANICAL_EXHAUST_AIR (Mekanisk frånluft)"
  ]
}

ventilationInspectionDate

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

chimneyType T

{
  "name": "chimneyType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_CHIMNEYTYPE_TYPE_STACK_OF_PLATES (Skorsten av plåt)",
    "ENUMS_CHIMNEYTYPE_TYPE_BRICK_CHIMNEY_WITH_FLUE_LINER (Murad skorsten med insatsrör)",
    "ENUMS_CHIMNEYTYPE_TYPE_BRICK_CHIMNEY (Murad skorsten)"
  ]
}

chimneyLastUsedDate

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

chimneyComment

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

waterType T

{
  "name": "waterType",
  "type": "text",
  "maxLength": 200,
  "enums": [
    "ENUMS_WATERTYPE_TYPE_WATER_MISSING (Vatten saknas)",
    "ENUMS_WATERTYPE_TYPE_MUNICIPAL_WATER (Kommunalt vatten)",
    "ENUMS_WATERTYPE_TYPE_DUG_WELLS (Grävd brunn)",
    "ENUMS_WATERTYPE_TYPE_INDIVIDUAL_WATER (Enskilt vatten)",
    "ENUMS_WATERTYPE_TYPE_DEEP_DRILLED_WELL (Djupborrad brunn)"
  ]
}

drainType T

{
  "name": "drainType",
  "type": "text",
  "maxLength": 200,
  "enums": [
    "ENUMS_DRAINTYPE_TYPE_SANITATION (Kommunalt avlopp)",
    "ENUMS_DRAINTYPE_TYPE_INDIVIDUAL_SEWAGE (Enskilt avlopp)",
    "ENUMS_DRAINTYPE_TYPE_DRAIN_WITH_INFILTRATION (Avloppsbrunn med infiltration)",
    "ENUMS_DRAINTYPE_TYPE_DRAIN_MISSING (Avlopp saknas)"
  ]
}

hasRadon bit

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

radonComment

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

otherBuildings

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

isAllYear bit

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

createdDate

{
  "name": "createdDate",
  "type": "timestamp"
}

costDescription

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

latitude

{
  "name": "latitude",
  "type": "text",
  "maxLength": 22
}

longitude

{
  "name": "longitude",
  "type": "text",
  "maxLength": 22
}

zoomLevel

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

directions

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

communications

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

locationComment

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

locationCommentMultiLang   (Allowed languages: en, sv, es, de, da, fr, nl. Structure: {"en": "text", "sv": "text", "es": "texto" })

{
  "name": "locationCommentMultiLang",
  "type": "jsonObject",
  "validationSchema": {
    "id": "estates/locationCommentMultiLang",
    "type": "object",
    "additionalProperties": false,
    "properties": {
      "sv": {
        "type": "string"
      },
      "en": {
        "type": "string"
      },
      "es": {
        "type": "string"
      },
      "de": {
        "type": "string"
      },
      "da": {
        "type": "string"
      },
      "fr": {
        "type": "string"
      },
      "nl": {
        "type": "string"
      }
    }
  },
  "note": "Allowed languages: en, sv, es, de, da, fr, nl. Structure: {\"en\": \"text\", \"sv\": \"text\", \"es\": \"texto\" }"
}

locationDescriptionId  → locationDescriptions

{
  "name": "locationDescriptionId",
  "type": "foreignKey",
  "table": "locationDescriptions"
}

description

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

floorNr

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

floorsInTotal

{
  "name": "floorsInTotal",
  "type": "int",
  "maxLength": 3
}

floorNrComment

{
  "name": "floorNrComment",
  "type": "text",
  "maxLength": 200,
  "isDeprecated": "true"
}

tenantOwnershipLandComment T

{
  "name": "tenantOwnershipLandComment",
  "type": "text",
  "enums": [
    "ENUMS_ESTATE_TENANT_OWNER_SHIP_LAND_COMMENT_TYPE_PATIO_MARK (Uteplatsen/marken är upplåten med bostadsrätten (ingår i bostadsrätten))",
    "ENUMS_ESTATE_TENANT_OWNER_SHIP_LAND_COMMENT_TYPE_PATIO_MARK_UNCLEAR (Det är oklart med vilken rätt uteplatsen/marken nyttjas)",
    "ENUMS_ESTATE_TENANT_OWNER_SHIP_LAND_COMMENT_TYPE_GRANTED_WITH_OTHER_RIGHT_THAN_TENANT_OWNERSHIP (Upplåten med annan nyttjanderätt än bostadsrätt)"
  ]
}

hasDoorCode bit

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

doorCode

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

hasKey bit

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

keyComment

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

keyInDate

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

keyInPersonName

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

keyOutDate

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

keyOutPersonName

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

hasBurglarAlarm bit

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

burglarAlarmType

{
  "name": "burglarAlarmType",
  "type": "text",
  "maxLength": 50
}

burglarAlarmCode

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

burglarAlarmComment

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

showBurglarAlarmOnMarketingPlaces bit  (Bit that says if burglar alarm should be showed on object description and website)

{
  "name": "showBurglarAlarmOnMarketingPlaces",
  "type": "bit",
  "note": "Bit that says if burglar alarm should be showed on object description and website"
}

hasLiftSetting E

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

liftComment

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

feeChanges

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

housingAssociationPlotOwnership E

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

storageDescription

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

cashFlowAnalysisId  → cashFlowAnalysis

{
  "name": "cashFlowAnalysisId",
  "type": "foreignKey",
  "table": "cashFlowAnalysis",
  "unique": true
}

cashFlowAnalysisIgnoreFields   (Fields in this json will not be included in the sum: 'cashFlowAnalysisSumRevenue'. Structure: ['cashFlowAnalysisSumRevenue', 'cashFlowAnalysisSumVacancies'])

{
  "name": "cashFlowAnalysisIgnoreFields",
  "type": "jsonObject",
  "note": "Fields in this json will not be included in the sum: 'cashFlowAnalysisSumRevenue'. Structure: ['cashFlowAnalysisSumRevenue', 'cashFlowAnalysisSumVacancies']"
}

cashFlowAnalysisComment

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

cashFlowAnalysisYield

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

isCashFlowAnalysisCalculationSetManually bit  (Toggles if the values are set manually or retrieved automatically)

{
  "name": "isCashFlowAnalysisCalculationSetManually",
  "type": "bit",
  "note": "Toggles if the values are set manually or retrieved automatically"
}

cashFlowAnalysisSumRevenue $$

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

cashFlowAnalysisSumOtherIncomes $$

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

cashFlowAnalysisSumVacancies $$

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

cashFlowAnalysisCosts $$

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

cashFlowAnalysisMaintenanceCost $$

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

cashFlowAnalysisPropertyTax $$

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

cashFlowAnalysisYearlyGroundRend $$

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

cashFlowAnalysisGeneralizedOperationAndMaintenanceCost $$

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

cashFlowAnalysisGeneralizedOperationCost $$

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

cashFlowAnalysisGeneralizedMaintenanceCost $$

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

isCashFlowAnalysisMaintenanceCostPerAreaSetManually bit  (Toggles if the value is set manually or calculated from areas)

{
  "name": "isCashFlowAnalysisMaintenanceCostPerAreaSetManually",
  "type": "bit",
  "note": "Toggles if the value is set manually or calculated from areas"
}

cashFlowAnalysisMaintenanceCostPerArea $$  (cost/m2)

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

isCashFlowAnalysisCostPerAreaSetManually bit  (Toggles if the value is set manually or calculated from areas)

{
  "name": "isCashFlowAnalysisCostPerAreaSetManually",
  "type": "bit",
  "note": "Toggles if the value is set manually or calculated from areas"
}

cashFlowAnalysisCostPerArea $$  (cost/m2)

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

companyTransferValuesFromDate

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

companyTransferBookedEstateValue $$

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

companyTransferBookedInventoryValue $$

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

companyTransferBookedSum $$

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

companyTransferTaxResidualEstateValue $$

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

companyTransferTaxResidualInventoryValue $$

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

companyTransferTaxResidualSum $$

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

plotDescription

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

livingAreaDescription

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

farmingPurposeText   (Used to write purposes that are not in farmingPurpose table)

{
  "name": "farmingPurposeText",
  "type": "text",
  "maxLength": 100,
  "note": "Used to write purposes that are not in farmingPurpose table"
}

patioSummary

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

parkingSummary

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

estateEconomicTypeCodeId  → estateEconomicTypeCodes

{
  "name": "estateEconomicTypeCodeId",
  "type": "foreignKey",
  "table": "estateEconomicTypeCodes",
  "schema": "mspx_admin"
}

assessmentYear

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

assessValueYear

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

assessValueBuilding $$

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

assessValueLand $$

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

assessValueTotal $$

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

assessValueDescription

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

assessmentValueAccuracy E

{
  "name": "assessmentValueAccuracy",
  "type": "enum",
  "enums": [
    "ENUMS_ASSESSMENTVALUEACCURACY_TYPE_APPRECIATED (Uppskattat)",
    "ENUMS_ASSESSMENTVALUEACCURACY_TYPE_CALCULATED (Beräknat)",
    "ENUMS_ASSESSMENTVALUEACCURACY_TYPE_DETERMINED (Fastställt)",
    "ENUMS_ASSESSMENTVALUEACCURACY_TYPE_NOT_DETERMINED (Ej fastställt)",
    "ENUMS_ASSESSMENTVALUEACCURACY_TYPE_PRELIMINARY (Preliminärt)",
    "ENUMS_ASSESSMENTVALUEACCURACY_TYPE_PROPOSED (Föreslaget)"
  ]
}

yearlyGroundRent $$

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

groundRentEndDate

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

groundRentPeriod

{
  "name": "groundRentPeriod",
  "type": "text",
  "maxLength": 50
}

groundRentLandlord

{
  "name": "groundRentLandlord",
  "type": "text",
  "maxLength": 250
}

monthlyRent $$

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

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"
}

isCoolingIncluded bit

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

isGarageIncluded bit

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

isCarportIncluded bit

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

isParkingSpaceIncluded bit

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

isCondominiumSupplementIncluded bit

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

isHotWaterIncluded bit

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

isColdWaterIncluded bit

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

isIPTVIncluded bit

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

isIPTelephonyIncluded bit

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

otherFeeIncludedComment

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

livingCostAnalysisComment

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

bboxObjectJSON   (Expected structure: {minY : 1,minX: 2,maxY : 2,maxX : 3})

{
  "name": "bboxObjectJSON",
  "type": "jsonObject",
  "note": "Expected structure: {minY : 1,minX: 2,maxY : 2,maxX : 3}"
}

polygonListJSON   (Expected structure: [ [{x:19.232323, y:56.3434343}, {x:15.33434, y:70.444}...], [{x:15.232323, y:50.3434343}, {x:16.33434, y:45.444}...]...]. A list that contains polygons which is a list with coordinates)

{
  "name": "polygonListJSON",
  "type": "jsonObject",
  "note": "Expected structure: [ [{x:19.232323, y:56.3434343}, {x:15.33434, y:70.444}...], [{x:15.232323, y:50.3434343}, {x:16.33434, y:45.444}...]...]. A list that contains polygons which is a list with coordinates"
}

monthlyRentSummary

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

transferFee

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

pledgingFee

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

condominiumSupplement $$

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

repairFundSetting E

{
  "name": "repairFundSetting",
  "type": "enum",
  "enums": [
    "ENUM_ESTATE_REPAIR_FUND_SETTING_EXISTS (Inre reparationsfond finns)",
    "ENUM_ESTATE_REPAIR_FUND_SETTING_MISSING (Inre reparationsfond saknas)",
    "ENUM_ESTATE_REPAIR_FUND_SETTING_NOT_CHECKED (Inre reparationsfond inte kontrollerad)"
  ]
}

repairFund $$

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

repairFundDescription

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

repairFundCheckDate

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

transferFeePaidBy E

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

shareInCondo T

{
  "name": "shareInCondo",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUM_ESTATE_SHARE_IN_CONDO_NOT_POSSIBLE_TO_OBTAIN (Uppgiften har ej gått att få fram)",
    "ENUM_ESTATE_SHARE_IN_CONDO_MISSING_IN_HA_REGISTER (Uppgiften saknas i föreningens register)"
  ]
}

shareInCondoContribution T

{
  "name": "shareInCondoContribution",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUM_ESTATE_SHARE_IN_CONDO_NOT_POSSIBLE_TO_OBTAIN (Uppgiften har ej gått att få fram)",
    "ENUM_ESTATE_SHARE_IN_CONDO_MISSING_IN_HA_REGISTER (Uppgiften saknas i föreningens register)"
  ]
}

shareInCondoFee T

{
  "name": "shareInCondoFee",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUM_ESTATE_SHARE_IN_CONDO_NOT_POSSIBLE_TO_OBTAIN (Uppgiften har ej gått att få fram)",
    "ENUM_ESTATE_SHARE_IN_CONDO_MISSING_IN_HA_REGISTER (Uppgiften saknas i föreningens register)"
  ]
}

shareInCondoComment

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

isSharedOwnership bit

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

sharedOwnershipDescription

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

sharedOwnershipName

{
  "name": "sharedOwnershipName",
  "type": "text",
  "maxLength": 30
}

sharedOwnershipFee $$

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

sharedOwnershipFeePeriod E

{
  "name": "sharedOwnershipFeePeriod",
  "type": "enum",
  "enums": [
    "ENUMS_ESTATE_SHARED_OWNERSHIP_FEE_PERIOD_MONTH (SEK/MÅNAD)",
    "ENUMS_ESTATE_SHARED_OWNERSHIP_FEE_PERIOD_YEAR (SEK/ÅR)",
    "ENUMS_ESTATE_SHARED_OWNERSHIP_FEE_PERIOD_QUARTER (SEK/KVARTAL)"
  ]
}

pawnedSetting T

{
  "name": "pawnedSetting",
  "type": "text",
  "maxLength": 200,
  "enums": [
    "ENUM_ESTATE_PAWNED_SETTING_IS_PAWNED (är pantsatt)",
    "ENUM_ESTATE_PAWNED_SETTING_IS_NOT_PAWNED (är inte pantsatt)",
    "ENUM_ESTATE_PAWNED_SETTING_IS_NOT_CHECKED (är inte kontrollerad)"
  ]
}

pawnedAmountCheckDate

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

heatingCost $$

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

chimneySweepingCost $$

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

communityFee $$

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

insuranceFee $$  (For tenant ownership homeinsurance fee will be stored here, for other object types it will be a sum of all needed insurances)

{
  "name": "insuranceFee",
  "type": "money",
  "note": "For tenant ownership homeinsurance fee will be stored here, for other object types it will be a sum of all needed insurances"
}

insuranceDescription

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

maintenanceCost $$

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

waterAndDrainFee $$

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

roadFee $$

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

sanitationFee $$

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

householdElectricityCost $$

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

electricityCost $$  (Can be used instead of dividing into householdElectricityCost and heatingCost)

{
  "name": "electricityCost",
  "type": "money",
  "note": "Can be used instead of dividing into householdElectricityCost and heatingCost"
}

operationalComment

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

securityCost $$

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

operatingCostSum $$

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

isOperatingCostSumSetManually bit

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

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   (kWh/m2)

{
  "name": "energyPerformance",
  "type": "int",
  "note": "kWh/m2"
}

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": 100
}

energyStatusSummary

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

energyConsumption   (kWh)

{
  "name": "energyConsumption",
  "type": "int",
  "note": "kWh"
}

personsInHousehold

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

buildingComment

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

otherAreasComment

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

landComment

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

buildingRightsLandDescription

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

mortgageComment

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

hasNoMortgages bit  (If set it should override any mortages connected to the estate. Should print a text that no mortgages is present on the estate.)

{
  "name": "hasNoMortgages",
  "type": "bit",
  "note": "If set it should override any mortages connected to the estate. Should print a text that no mortgages is present on the estate."
}

loanComment

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

areaComment

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

areaType T

{
  "name": "areaType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUM_ESTATE_AREA_TYPE_TAXABLEAREA (Taxerad areal)",
    "ENUM_ESTATE_AREA_TYPE_FORESTRYPLAN (Skogsbruksplan)",
    "ENUM_ESTATE_AREA_TYPE_SAMAPPLICATION (SAM-ansökan)",
    "ENUM_ESTATE_AREA_TYPE_PLANONPROPERTY (Uppmätning på fastighetskarta)",
    "ENUM_ESTATE_AREA_TYPE_AREAUNDERREGISTER (Areal enligt fastighetsbok)",
    "ENUM_ESTATE_AREA_TYPE_SELLERS_DATA (Säljarens uppgifter)"
  ]
}

easementsAndDetailsComment

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

faultsAndDefectsComment

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

residentialArea

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

propertyTax $$

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

propertyTaxPaidByTenants $$  (Used in commercial)

{
  "name": "propertyTaxPaidByTenants",
  "type": "money",
  "note": "Used in commercial"
}

netPropertyTax $$  (Used in commercial)

{
  "name": "netPropertyTax",
  "type": "money",
  "note": "Used in commercial"
}

premiseComment

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

buildingType

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

buildYear

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

tenantsIncomeComment T

{
  "name": "tenantsIncomeComment",
  "type": "text",
  "maxLength": 150,
  "enums": [
    "ENUM_ESTATE_TENANTS_INCOME_COMMENT_FROM_RENTAL_LISTINGS (Hyreslistor)",
    "ENUM_ESTATE_TENANTS_INCOME_COMMENT_FROM_APPROXIMATING (Schablonberäkning)",
    "ENUM_ESTATE_TENANTS_INCOME_COMMENT_FROM_SELLER (Säljaren)"
  ]
}

generalInformation

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

electricityConsumption   (kWh)

{
  "name": "electricityConsumption",
  "type": "int",
  "note": "kWh"
}

grantingFee $$  (Only used in tenant ownership)

{
  "name": "grantingFee",
  "type": "money",
  "note": "Only used in tenant ownership"
}

contributionFee $$  (Only used in tenant ownership)

{
  "name": "contributionFee",
  "type": "money",
  "note": "Only used in tenant ownership"
}

keyIdentifier   (The identifier on the physical house key)

{
  "name": "keyIdentifier",
  "type": "text",
  "maxLength": 20,
  "note": "The identifier on the physical house key"
}

valueIndication   (We store data from valuation services, for now we only use valueguard.)

{
  "name": "valueIndication",
  "type": "jsonObject",
  "note": "We store data from valuation services, for now we only use valueguard."
}

updatedDate

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

Collections

[
  "areas",
  "buildings",
  "commercialOtherIncomes",
  "coordinates",
  "easementsAndDetails",
  "estateCashFlowAnalysisOtherCostsAmounts",
  "estateGeographicalAreas",
  "estateOperatingCosts",
  "estateTenants",
  "estateTenantsSubObjectTypeEstateCalculations",
  "farmingPurposes",
  "farmingSpecifics",
  "imagesInEstates",
  "loans",
  "marketValuations",
  "matchingAttributes",
  "mortgages",
  "parkingSpaces",
  "patios",
  "rooms"
]

Referenced by

areas as estateId
buildings as estateId
commercialOtherIncomes as estateId
coordinates as estateId
deals as mainEstateId
easementsAndDetails as estateId
estateCashFlowAnalysisOtherCostsAmounts as estateId (connection table to amounts via amountId)
estateFarmingPurposes as estateId (connection table to farmingPurposes via farmingPurposeId)
estateGeographicalAreas as estateId (connection table to geographicalAreas via geographicalAreaId)
estateOperatingCosts as estateId (connection table to amounts via amountId)
estateParkingSpaces as estateId (connection table to parkingSpaces via parkingSpaceId)
estatePremiseEconomyAmounts as estateId
estateTenants as estateId
estateTenantsSubObjectTypeEstateCalculations as estateId
farmingSpecifics as estateId
imagesInEstates as estateId
loans as estateId
marketValuations as estateId
matchingAttributesEstate as estateId (connection table to matchingAttributes via matchingAttributeId)
mortgages as estateId
patios as estateId
premises as estateId
rooms as estateId