Table : marketValuations

Raw table description

Fields

id id

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

name

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

officerRole T  (Will be pre populated with the role from teamRoles.)

{
  "name": "officerRole",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUM_MARKET_VALUATION_OFFIDER_ROLE_AUTH_ESTATE_APPRAISER (Auktoriserad fastighetsvärderare)",
    "ENUM_MARKET_VALUATION_OFFIDER_ROLE_AUTH_FARMING_APPRAISER (Auktoriserad lantbruksvärderare)",
    "ENUM_MARKET_VALUATION_OFFIDER_ROLE_AUTH_ESTATE_AND_TENANT_OWNERSHIP_APPRAISER (Auktoriserad småhus- och lägenhetsvärderare)",
    "ENUM_MARKET_VALUATION_OFFIDER_ROLE_BROKER (Fastighetsmäklare)",
    "ENUM_MARKET_VALUATION_OFFIDER_ROLE_FORESTER (Jägmästare)",
    "ENUM_MARKET_VALUATION_OFFIDER_ROLE_FOREST_MANAGER (Skogsmästare)",
    "ENUM_MARKET_VALUATION_OFFIDER_ROLE_FOREST_TECHNICIAN (Skogstekniker)",
    "ENUM_MARKET_VALUATION_OFFIDER_ROLE_AGRONOMY (Lantmästare)",
    "ENUM_MARKET_VALUATION_OFFIDER_ROLE_FOREST_ECONOMICS (Skogsekonom)"
  ],
  "note": "Will be pre populated with the role from teamRoles."
}

printHeadline

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

estateId M  → estates

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

imageFileId  → files

{
  "name": "imageFileId",
  "type": "foreignKey",
  "table": "files"
}

officerContactId  → contacts

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

propertyName

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

streetAddress

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

postalCode

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

city

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

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

livingArea

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

otherLivingArea

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

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

numberOfBedrooms

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

numberOfRooms

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

assessValueYear

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

assessValueBuilding $$

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

assessValueLand $$

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

assessValueTotal $$

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

assessmentYear

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

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

personsInHousehold

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

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

buildingArea

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

plotArea

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

buildYear

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

renovateYear

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

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

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
}

operatingCostSum $$

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

estateDescription

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

marketValueDependentInformation

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

propertyCondition E

{
  "name": "propertyCondition",
  "type": "enum",
  "enums": [
    "ENUMS_MARKET_VALUATION_RATING_VERY_GOOD (Mycket bra)",
    "ENUMS_MARKET_VALUATION_RATING_GOOD (Bra)",
    "ENUMS_MARKET_VALUATION_RATING_NORMAL (Normalt)",
    "ENUMS_MARKET_VALUATION_RATING_LESS_GOOD (Mindre gott)",
    "ENUMS_MARKET_VALUATION_RATING_BAD (Dåligt)"
  ]
}

demandForResort E

{
  "name": "demandForResort",
  "type": "enum",
  "enums": [
    "ENUMS_MARKET_VALUATION_RATING_VERY_GOOD (Mycket bra)",
    "ENUMS_MARKET_VALUATION_RATING_GOOD (Bra)",
    "ENUMS_MARKET_VALUATION_RATING_NORMAL (Normalt)",
    "ENUMS_MARKET_VALUATION_RATING_LESS_GOOD (Mindre gott)",
    "ENUMS_MARKET_VALUATION_RATING_BAD (Dåligt)"
  ]
}

resortsGeneralDevelopment E

{
  "name": "resortsGeneralDevelopment",
  "type": "enum",
  "enums": [
    "ENUMS_MARKET_VALUATION_RATING_VERY_GOOD (Mycket bra)",
    "ENUMS_MARKET_VALUATION_RATING_GOOD (Bra)",
    "ENUMS_MARKET_VALUATION_RATING_NORMAL (Normalt)",
    "ENUMS_MARKET_VALUATION_RATING_LESS_GOOD (Mindre gott)",
    "ENUMS_MARKET_VALUATION_RATING_BAD (Dåligt)"
  ]
}

customerDescription

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

marketValue $$

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

marketValueInText

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

marketValueSpread

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

generalInformation

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

buildingDescription

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

valuationDate

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

signatureDate

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

isLeasehold bit

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

isPartOf bit

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

isTenureHouse bit

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

isSharedOwnership bit

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

acreageDescription

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

monthlyRent $$

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

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

repairFund $$

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

housingAssociationDescription

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

yearlyRent $$

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

loanInHousingAssociation $$

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

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

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

createdDate

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

numberOfApartments

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

numberOfPremises

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

numberOfRentApartments

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

apartmentNumber

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

floorNr

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

floorsInTotal

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

valuationPurposeDescription

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

locationDescription

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

economicalConditionsDescription

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

legalConditionsDescription

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

environmentalAspectsDescription

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

basicAssessmentDescription

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

printExtendedInformation bit

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

preconditionsDescription

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

descriptionDescription

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

inspectionDescription

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

otherSourcesDescription

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

other

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

valuationDescription

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

partValuesDescription

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

finalValuationDescription

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

finalValueAssessment

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

residentialBuildingValue $$

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

economyBuildingValue $$

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

forestValue $$

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

fieldValue $$

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

fencedFieldValue $$

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

plotValue $$

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

mainBuildingValue $$

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

impedimentForestValue $$

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

pastureValue $$

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

estateEconomicTypeCodeId  → estateEconomicTypeCodes

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

updatedDate

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

Referenced by

marketValuationCustomers as marketValuationId (connection table to contacts via contactId)
marketValuationFiles as marketValuationId (connection table to files via fileId)